ASH Report For CAPGENT/capgent1

DB NameDB IdInstanceInst numReleaseRACHost
CAPGENT4127787440capgent1110.2.0.4.0YESrac1.capgent.com

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
43,840M (100%)3,184M (82.9%)507M (13.2%)8.0M (0.2%)

Sample TimeData Source
Analysis Begin Time:05-Jun-11 15:24:23DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 21351
Analysis End Time:07-Jun-11 15:29:23DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 21355
+ V$ACTIVE_SESSION_HISTORY
Elapsed Time: 2,885.0 (mins)  
Sample Count: 3,592 
Average Active Sessions: 0.21 
Avg. Active Session per CPU: 0.05 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
db file sequential read User I/O 44.63 0.09
CPU + Wait for CPU CPU 20.02 0.04
db file scattered read User I/O 4.06 0.01
control file sequential read System I/O 2.34 0.00
gc current block 2-way Cluster 2.31 0.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 4.12 0.01
control file sequential read System I/O 4.04 0.01
Streams AQ: qmn coordinator waiting for slave to start Other 3.34 0.01
reliable message Other 2.03 0.00
control file parallel write System I/O 1.50 0.00

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
db file sequential read 45.96 "6","287527","1" 0.06 file# block# blocks
control file sequential read 6.38 "0","35","1" 2.20 file# block# blocks
db file scattered read 4.09 "6","399762","3" 0.06 file# block# blocks
reliable message 2.03 "5629965400","5629882976","5630841744" 0.22 channel context channel handle broadcast message
control file parallel write 1.53 "3","3","3" 1.48 files block# requests

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
capgent JDBC Thin Client 66.09 UNNAMED 66.09
SYS$BACKGROUND UNNAMED 17.07 UNNAMED 17.07
SYS$USERS DBMS_SCHEDULER 9.41 AUTO_SPACE_ADVISOR_JOB 4.06
      GATHER_STATS_JOB 3.87
      AGING_CALCULATIONS 1.36
  emagent@rac1.capgent.com (TNS V1-V3) 2.73 UNNAMED 2.73
SYS$BACKGROUND MMON_SLAVE 2.14 Remote-Flush Slave Action 0.72

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 701 66.09 0.14
INSERT 36 6.24 0.01
UPDATE 18 4.54 0.01

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
bkhf6mdtuuark 2154183644 6.60 db file sequential read 4.54 select * from ( select row_.*,...
237t2j21fva8x 1756123102 5.18 db file sequential read 3.67 /* named native SQL query sear...
39q7fgx59n296 1246553133 4.45 db file sequential read 4.45 select stslogs0_.IV_ID as IV16...
8szmwam7fysa3 2976124318 3.42 db file sequential read 3.37 insert into wri$_adv_objspace_...
4gd6b1r53yt88   2.59 reliable message 1.95 ** SQL Text Not Available **

Back to Top SQL
Back to Top

Top SQL using literals

Plan Hash% Activity# of Sampled SQL VersionsExample SQL 1Example SQL TEXT 1Example SQL 2Example SQL TEXT 2
1928032458 4.93 177 00c71dj788y1m select cmtslog0_.CM_CRTDBY as ... gzudx733sj1wv select cmtslog0_.CM_CRTDBY as ...

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00c71dj788y1mselect cmtslog0_.CM_CRTDBY as col_0_0_, cmtslog0_.CM_CRTDT as col_1_0_, cmtslog0_.CM_ACTION as col_2_0_, cmtslog0_.CM_TEXT as col_3_0_ from CMTS_LOG cmtslog0_, INV_TXN invtxn1_ where cmtslog0_.CM_IVID=invtxn1_.IV_ID and cmtslog0_.CM_IVDATE=invtxn1_.IV_DATE and (invtxn1_.EN_ID in (4180)) and cmtslog0_.CM_IVID='3811313' order by cmtslog0_.CM_CRTDT DESC
237t2j21fva8x/* named native SQL query search.account.assignment */ SELECT /*+ INDEX(CST_HDR CST_HDR_ENID_TYPE_CSACT_IDX)*/ CST_HDR.CS_ID FROM CST_HDR INNER JOIN INV_TXN ON CST_HDR.CS_ID = INV_TXN.CS_ID WHERE (CST_HDR.CS_ACTIVE = 1 AND CST_HDR.EN_ID = :1 AND CST_HDR.CS_TYPE = (SELECT /*+ INDEX(CSTPE_HDR CSTPE_HDR_CSNAME_INDEX)*/ CS_TYPE FROM CSTPE_HDR WHERE CS_NAME = :2) AND INV_TXN.IV_TYPE = :3 AND INV_TXN.IV_ASSGNTO IS NULL)
39q7fgx59n296 select stslogs0_.IV_ID as IV16_1_, stslogs0_.IV_DATE as IV17_1_, stslogs0_.LOG_ID as LOG1_1_, stslogs0_.LOG_ID as LOG1_73_0_, stslogs0_.ST_IDT1 as ST2_73_0_, stslogs0_.ST_IDT2 as ST3_73_0_, stslogs0_.ST_TXNTPE as ST4_73_0_, stslogs0_.ST_DESC as ST5_73_0_, stslogs0_.ST_CRTDBY as ST6_73_0_, stslogs0_.ST_MODBY as ST7_73_0_, stslogs0_.ST_CRTDDT as ST8_73_0_, stslogs0_.ST_MODDT as ST9_73_0_, stslogs0_.ST_ISCURR as ST10_73_0_, stslogs0_.EN_ID as EN11_73_0_, stslogs0_.STE_ID as STE12_73_0_, stslogs0_.TID as TID73_0_, stslogs0_.AID as AID73_0_, stslogs0_.ST_ID as ST15_73_0_, stslogs0_.IV_ID as IV16_73_0_, stslogs0_.IV_DATE as IV17_73_0_, stslogs0_.CS_ID as CS18_73_0_ from STS_LOG stslogs0_ where ( stslogs0_.st_txntpe='Receivables') and ((stslogs0_.IV_ID=:1 and stslogs0_.IV_DATE=:2) or (stslogs0_.IV_ID=:3 and stslogs0_.IV_DATE=:4) or (stslogs0_.IV_ID=:5 and stslogs0_.IV_DATE=:6) or (stslogs0_.IV_ID=:7 and stslogs0_.IV_DATE=:8) or (stslogs0_.IV_ID=:9 and stslogs0_.IV_DATE=:10) or (stslogs0_.IV_ID=:11 and stslogs0_.IV_DATE=:12) or (stslogs0_.IV_ID=:13 and stslogs0_.IV_DATE=:14) or (stslogs0_.IV_ID=:15 and stslogs0_.IV_DATE=:16) or (stslogs0_.IV_ID=:17 and stslogs0_.IV_DATE=:18) or (stslogs0_.IV_ID=:19 and stslogs0_.IV_DATE=:20) or (stslogs0_.IV_ID=:21 and stslogs0_.IV_DATE=:22) or (stslogs0_.IV_ID=:23 and stslogs0_.IV_DATE=:24) or (stslogs0_.IV_ID=:25 and stslogs0_.IV_DATE=:26) or (stslogs0_.IV_ID=:27 and stslogs0_.IV_DATE=:28) or (stslogs0_.IV_ID=:29 and stslogs0_ .IV_DATE=:30) or (stslogs0_.IV_ID=:31 and stslogs0_.IV_DATE=:32) or (stslogs0_.IV_ID=:33 and stslogs0_.IV_DATE=:34) or (stslogs0_.IV_ID=:35 and stslogs0_.IV_DATE=:36) or (stslogs0_.IV_ID=:37 and stslogs0_.IV_DATE=:38) or (stslogs0_.IV_ID=:39 and stslogs0_.IV_DATE=:40) or (stslogs0_.IV_ID=:41 and stslogs0_.IV_DATE=:42) or (stslogs0_.IV_ID=:43 and stslogs0_.IV_DATE=:44) or (stslogs0_.IV_ID=:45 and stslogs0_.IV_DATE=:46) or (stslogs0_.IV_ID=:47 and stslogs0_.IV_DATE=:48) or (stslogs0_.IV_ID=:49 and stslogs0_.IV_DATE=:50))
4gd6b1r53yt88** SQL Text Not Available **
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
bkhf6mdtuuark select * from ( select row_.*, rownum rownum_ from ( select /*+ ALL_ROWS */ stshdr3_.ST_NAME as col_0_0_, sum(cstagehdr1_.CS_AGEBUCKET1+cstagehdr1_.CS_AGEBUCKET2+cstagehdr1_.CS_AGEBUCKET3+cstagehdr1_.CS_AGEBUCKET4+cstagehdr1_.CS_AGEBUCKET5+cstagehdr1_.CS_AGEBUCKET6+cstagehdr1_.CS_AGEBUCKET7+cstagehdr1_.CS_AGEBUCKET8+cstagehdr1_.CS_AGEBUCKET9+cstagehdr1_.CS_AGEBUCKET10+cstagehdr1_.CS_AGEBUCKET11+cstagehdr1_.CS_AGEBUCKET12) as col_1_0_, sum(cstagehdr1_.CS_AGEBUCKET1) as col_2_0_, sum(cstagehdr1_.CS_AGEBUCKET2) as col_3_0_, sum(cstagehdr1_.CS_AGEBUCKET3) as col_4_0_, sum(cstagehdr1_.CS_AGEBUCKET4) as col_5_0_, sum(cstagehdr1_.CS_AGEBUCKET5) as col_6_0_, sum(cstagehdr1_.CS_AGEBUCKET6) as col_7_0_, sum(cstagehdr1_.CS_AGEBUCKET7) as col_8_0_, sum(cstagehdr1_.CS_AGEBUCKET8) as col_9_0_, stshdr3_.ST_ID as col_10_0_ from CST_HDR csthdr0_, CST_AGEHDR cstagehdr1_, INV_TXN invtxns2_, STS_HDR stshdr3_ where csthdr0_.CS_ID=cstagehdr1_.CS_ID(+) and csthdr0_.CS_ID=invtxns2_.CS_ID(+) and invtxns2_.IV_STID=stshdr3_.ST_ID(+) and (csthdr0_.EN_ID in (4060)) and cstagehdr1_.CS_ID=csthdr0_.CS_ID and invtxns2_.IV_TYPE='Account' and csthdr0_.CS_TYPE=2502 and csthdr0_.CS_ACTIVE=1 group by stshdr3_.ST_NAME , stshdr3_.ST_ID , csthdr0_.rowid order by csthdr0_.rowid ASC ) row_ where rownum <= :1) where rownum_ > :2
gzudx733sj1wvselect cmtslog0_.CM_CRTDBY as col_0_0_, cmtslog0_.CM_CRTDT as col_1_0_, cmtslog0_.CM_ACTION as col_2_0_, cmtslog0_.CM_TEXT as col_3_0_ from CMTS_LOG cmtslog0_, INV_TXN invtxn1_ where cmtslog0_.CM_IVID=invtxn1_.IV_ID and cmtslog0_.CM_IVDATE=invtxn1_.IV_DATE and (invtxn1_.EN_ID in (4170)) and cmtslog0_.CM_IVID='8987826' order by cmtslog0_.CM_CRTDT DESC

Back to Top SQL
Back to Top

Top PL/SQL Procedures

PLSQL Entry Subprogram% ActivityPLSQL Current Subprogram% Current
SYS.DBMS_SPACE.AUTO_SPACE_ADVISOR_JOB_PROC 4.06 SYS.DBMS_SPACE.OBJECT_SPACE_USAGE 3.76
SYS.DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC 3.87 SQL 3.81
DNBI.ALL_ENTITY_AGING_CALCULATIONS 1.11 SQL 1.11


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
276,54573 10.22 db file sequential read 5.82 DNBI JDBC Thin Client 209/17K [ 1%] 2
    CPU + Wait for CPU 2.37     85/17K [ 0%] 0
267,10792 5.99 CPU + Wait for CPU 2.53 DNBI JDBC Thin Client 91/17K [ 1%] 2
    db file sequential read 2.48     89/17K [ 1%] 2
238,19348 4.79 db file sequential read 3.20 DNBI JDBC Thin Client 115/17K [ 1%] 6
293,24702 4.79 db file sequential read 3.15 DNBI JDBC Thin Client 113/17K [ 1%] 8
332, 1 4.45 control file sequential read 2.95 SYS oracle@rac1.capgent.com (LMON) 106/17K [ 1%] 0

Back to Top Sessions
Back to Top

Top Blocking Sessions

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
56469 18.43 db file sequential read 12.39 DNBI.INV_TXN (TABLE) CAPGENT_DATA
    db file scattered read 2.34    
    gc current block 2-way 2.09    
56446 5.62 db file sequential read 5.51 DNBI.CMTS_LOG (TABLE) CAPGENT_DATA
56506 5.32 db file sequential read 5.29 DNBI.STS_LOG (TABLE) CAPGENT_DATA
56429 3.84 db file sequential read 3.76 DNBI.ACCR_TXN (TABLE) CAPGENT_DATA
86115 2.23 db file sequential read 2.23 DNBI.STS_LOG_COMP_IDX (INDEX) CAPGENT_INDEX

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
6 40.28 db file sequential read 33.60 +DATA/capgent/capgent_data.dbf CAPGENT_DATA
    db file scattered read 2.56    
    gc current block 2-way 2.17    
7 8.74 db file sequential read 8.41 +DATA/capgent/capgent_index.dbf CAPGENT_INDEX
3 4.09 db file sequential read 2.20 +DATA/capgent/sysaux01.dbf SYSAUX
    db file scattered read 1.53    

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
15:24:23 (155.6 min) 29 control file sequential read 9 0.25
    Streams AQ: qmn coordinator waiting for slave to start 7 0.19
    CPU + Wait for CPU 4 0.11
18:00:00 (290.0 min) 83 db file sequential read 35 0.97
    Streams AQ: qmn coordinator waiting for slave to start 12 0.33
    reliable message 9 0.25
22:50:00 (290.0 min) 276 db file sequential read 125 3.48
    CPU + Wait for CPU 58 1.61
    control file sequential read 15 0.42
03:40:00 (290.0 min) 382 db file sequential read 217 6.04
    CPU + Wait for CPU 47 1.31
    control file sequential read 20 0.56
08:30:00 (290.0 min) 672 db file sequential read 259 7.21
    CPU + Wait for CPU 162 4.51
    cursor: pin S wait on X 52 1.45
13:20:00 (290.0 min) 366 CPU + Wait for CPU 229 6.38
    db file sequential read 64 1.78
    control file sequential read 18 0.50
18:10:00 (290.0 min) 404 db file sequential read 228 6.35
    db file scattered read 57 1.59
    CPU + Wait for CPU 52 1.45
23:00:00 (290.0 min) 507 db file sequential read 265 7.38
    CPU + Wait for CPU 69 1.92
    control file sequential read 46 1.28
03:50:00 (290.0 min) 337 db file sequential read 219 6.10
    CPU + Wait for CPU 40 1.11
    control file sequential read 25 0.70
08:40:00 (290.0 min) 337 db file sequential read 147 4.09
    CPU + Wait for CPU 125 3.48
    control file sequential read 22 0.61
13:30:00 (119.4 min) 199 db file sequential read 92 2.56
    CPU + Wait for CPU 75 2.09
    control file sequential read 7 0.19


Back to Top

End of Report