ASH Report For HTDB/htdb

DB Name DB Id Instance Inst num Release RAC Host
HTDB 1840233104 htdb 1 10.2.0.5.0 NO ECMora01

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size
32 52,432M (100%) 48,560M (92.6%) 3,376M (6.4%) 50.0M (0.1%)

Sample Time Data Source
Analysis Begin Time: 14-10ÔÂ-13 11:00:00 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 25445
Analysis End Time: 14-10ÔÂ-13 11:59:59 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 25446
+ V$ACTIVE_SESSION_HISTORY
Elapsed Time: 60.0 (mins)  
Sample Count: 68,969  
Average Active Sessions: 191.63  
Avg. Active Session per CPU: 5.99  
Report Target: None specified  

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

Event Event Class % Activity Avg Active Sessions
latch: library cache Concurrency 55.02 105.45
cursor: pin S wait on X Concurrency 16.83 32.25
CPU + Wait for CPU CPU 14.28 27.37
SQL*Net message from dblink Network 7.46 14.29
latch: shared pool Concurrency 2.39 4.58

Back to Top Events
Back to Top

Top Background Events

No data exists for this section of the report.

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
latch: library cache 55.12 "504403212888108880","217","0" 0.71 address number tries
cursor: pin S wait on X 16.83 "32850666","3526168150016","21474862927" 0.00 idn value where|sleeps
SQL*Net message from dblink 7.46 "1952673792","1","0" 7.46 driver id #bytes NOT DEFINED
latch: shared pool 2.42 "504403158534983656","216","0" 0.26 address number tries

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

Service Module % Activity Action % Action
SYS$USERS UNNAMED 99.04 UNNAMED 99.04

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 Type Distinct SQLIDs % Activity Avg Active Sessions
SELECT 7,165 57.57 110.32
UPDATE 97 2.57 4.92
INSERT 66 1.89 3.62

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL ID Planhash % Activity Event % Event SQL Text
8tzz6w3889pu7 3632441102 8.91 SQL*Net message from dblink 5.65 select count(*) from (select r...
      CPU + Wait for CPU 2.81

Back to Top SQL
Back to Top

Top SQL using literals

Plan Hash % Activity # of Sampled SQL Versions Example SQL 1 Example SQL TEXT 1 Example SQL 2 Example SQL TEXT 2
4116844999 8.33 5746 004fyvnrvjf7j select count(distinct id) from... gzxgg79q2gcum select count(distinct id) from...
1014334271 5.98 4121 003ssyu3zgyu0 select * from ( select distinc... gzx0aj3gp361s select * from ( select distinc...
1778274180 3.95 2721 009fxs1381j4g select distinct * from ( selec... gzxtcfnj0qb20 select distinct * from ( selec...
4154862089 2.09 1442 01g8xxxk2f09k select count(*) from (select r... gydzw672pcaj9 select count(*) from (select r...

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL Id SQL Text
003ssyu3zgyu0 select * from ( select distinct null as pendingcode, ve.BUSSINESSTYPE, ve.workflowid, ve.processcreator, ve.accepted, ve.parentworkflowid, ve.afarid, to_char(ve.sendtime, 'yyyy-MM-dd') as sendtime, appt.name as workflowtype, to_char(ve.starttime, 'yyyy-MM-dd HH24:mi:ss') as starttime , replace(ve.sendername, 'N/A', '') as sendername, ve.senderid, ve.approvelevel, ve.accepterid, ve.acceptername, ve.processinstid, ve.title, ve.createtime, ve.creator, ve.creatorname, ve.deptid, ve.deptname, ve.workitemid, ve.beCommission, ve.batch from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1=1 and ve.globalID in ('P{319280979}', 'O{310257384}', 'O{310203000}', 'O{31}') union select pendingcode, businessTypeId, null, null, null, null, null, null, businessTypeName, starttime, seandername, null, null, null, null, null, title, null, null, null, null, null, null, '0', null from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, to_char(tab1.senddate, 'yyyy-MM-dd HH24:mi:ss') as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :1 ) wher e 1=1 order by starttime desc ) where rownum<=:2
004fyvnrvjf7j select count(distinct id) from ( select ve.workflowid||'' as id from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and ve.globalID in ('P{209172862}', 'O{39469021390}', 'O{39469}', 'G{300765506}') union select t.pendingcode as id from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, tab1.senddate as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :1 )t where 1=1 )
009fxs1381j4g select distinct * from ( select ve.BUSSINESSTYPE as BUSSINESSTYPE from v_executableworktask ve where 1= 1 and ve.globalID in ('P{205661873}', 'O{310016445}', 'O{310002100}', 'O{31}', 'G{224210423}', 'G{228647000}') union all select tab1.type as workflowtype from t_approve_notify tab1 where tab1.flag=:1 and tab1.recieverid = :2 )
01g8xxxk2f09k select count(*) from (select rank() over(partition by vh.workflowid order by vh.workitemid desc) rowseq, null as pendingcode, vh.BUSSINESSTYPE, vh.workflowid, vh.parentworkflowid, vh.approvelevel, vh.processcreator, vh.accepted, vh.workitemid, replace(vh.currentactivityname, 'N/A', '') as currentactivityname, replace(vh.acceptername, 'N/A', '') as acceptername, vh.accepterid, vh.afarid, appt.name as workflowtype, to_char(vh.endtime, 'yyyy-MM-dd HH24:mi:ss') as starttime , vh.sendername, vh.senderid, vh.processinstid, vh.title, to_char(vh.createtime, 'yyyy-MM-dd HH24:mi:ss') as createtime, vh.creator, vh.creatorname, vh.deptid, vh.deptname from v_hasexecutableworktask vh left join T_DATA_ITEM appt on appt.value=vh.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vh.globalID in ('P{2287058}', 'O{410004304}', 'O{410004300}', 'O{4100}') union select 1 as rowseq, t1.pendingcode, t1.businessTypeId, null, null, null, null, null, null, t1.currentactivityname, t1.recievername, null, null, t1.businessTypeName, t1.starttime, null, null, null, t1.title, null, null, null, null, null from( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as currentactivityname, tab2.name as businessTypeName, to_char(tab1.createtime, 'yyyy-MM-dd HH24:mi:ss') as starttime, tab1.recievername from t_approve_notify tab1 left join t_data_item tab 2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 left join (select bussinessId, max(no1.createtime) as createtime, max(no1.type)as type, max(id) as id from t_approve_notify no1 where no1.flag = 1 and no1.type in(38, 39, 40, 41) and no1.recieverid = :1 group by no1.bussinessId ) tab3 on tab1.id = tab3.id where tab1.flag = 1 and (tab1.type not in(38, 39, 40, 41) or (tab1.id = tab3.id)) and tab1.recieverid = :2 ) t1 where 1=1 )WHERE rowseq = 1 order by starttime desc
8tzz6w3889pu7 select count(*) from (select rank() over(partition by vh.workflowid order by vh.workitemid desc) rowseq, null as pendingcode, vh.BUSSINESSTYPE, vh.workflowid, vh.parentworkflowid, vh.approvelevel, vh.processcreator, vh.accepted, vh.workitemid, replace(vh.currentactivityname, 'N/A', '') as currentactivityname, replace(vh.acceptername, 'N/A', '') as acceptername, vh.accepterid, vh.afarid, appt.name as workflowtype, to_char(vh.endtime, 'yyyy-MM-dd HH24:mi:ss') as starttime , vh.sendername, vh.senderid, vh.processinstid, vh.title, to_char(vh.createtime, 'yyyy-MM-dd HH24:mi:ss') as createtime, vh.creator, vh.creatorname, vh.deptid, vh.deptname from v_hasexecutableworktask vh left join T_DATA_ITEM appt on appt.value=vh.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vh.globalID in ('P{208943057}', 'O{150300031}', 'O{1503}', 'G{309117492}') and vh.BUSSINESSTYPE = :1 union select 1 as rowseq, t1.pendingcode, t1.businessTypeId, null, null, null, null, null, null, t1.currentactivityname, t1.recievername, null, null, t1.businessTypeName, t1.starttime, null, null, null, t1.title, null, null, null, null, null from( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as currentactivityname, tab2.name as businessTypeName, to_char(tab1.createtime, 'yyyy-MM-dd HH24:mi:ss') as starttime, tab1.recievername from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 left join (select bussinessId, max(no1.createtime) as createtime, max(no1.type)as type, max(id) as id from t_approve_notify no1 where no1.flag = 1 and no1.type in(38, 39, 40, 41) and no1.recieverid = :2 group by no1.bussinessId ) tab3 on tab1.id = tab3.id where tab1.flag = 1 and (tab1.type not in(38, 39, 40, 41) or (tab1.id = tab3.id)) and tab1.recieverid = :3 ) t1 where 1=1 and t1.businessTypeId = :4 )WHERE rowseq = 1 order by starttime desc
gydzw672pcaj9 select count(*) from (select rank() over(partition by vh.workflowid order by vh.workitemid desc) rowseq, null as pendingcode, vh.BUSSINESSTYPE, vh.workflowid, vh.parentworkflowid, vh.approvelevel, vh.processcreator, vh.accepted, vh.workitemid, replace(vh.currentactivityname, 'N/A', '') as currentactivityname, replace(vh.acceptername, 'N/A', '') as acceptername, vh.accepterid, vh.afarid, appt.name as workflowtype, to_char(vh.endtime, 'yyyy-MM-dd HH24:mi:ss') as starttime , vh.sendername, vh.senderid, vh.processinstid, vh.title, to_char(vh.createtime, 'yyyy-MM-dd HH24:mi:ss') as createtime, vh.creator, vh.creatorname, vh.deptid, vh.deptname from v_hasexecutableworktask vh left join T_DATA_ITEM appt on appt.value=vh.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vh.globalID in ('P{814266286}', 'O{520306697}', 'O{520331000}', 'O{5203}') union select 1 as rowseq, t1.pendingcode, t1.businessTypeId, null, null, null, null, null, null, t1.currentactivityname, t1.recievername, null, null, t1.businessTypeName, t1.starttime, null, null, null, t1.title, null, null, null, null, null from( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as currentactivityname, tab2.name as businessTypeName, to_char(tab1.createtime, 'yyyy-MM-dd HH24:mi:ss') as starttime, tab1.recievername from t_approve_notify tab1 left join t_data_item t ab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 left join (select bussinessId, max(no1.createtime) as createtime, max(no1.type)as type, max(id) as id from t_approve_notify no1 where no1.flag = 1 and no1.type in(38, 39, 40, 41) and no1.recieverid = :1 group by no1.bussinessId ) tab3 on tab1.id = tab3.id where tab1.flag = 1 and (tab1.type not in(38, 39, 40, 41) or (tab1.id = tab3.id)) and tab1.recieverid = :2 ) t1 where 1=1 )WHERE rowseq = 1 order by starttime desc
gzx0aj3gp361s select * from ( select distinct null as pendingcode, ve.BUSSINESSTYPE, ve.workflowid, ve.processcreator, ve.accepted, ve.parentworkflowid, ve.afarid, to_char(ve.sendtime, 'yyyy-MM-dd') as sendtime, appt.name as workflowtype, to_char(ve.starttime, 'yyyy-MM-dd HH24:mi:ss') as starttime , replace(ve.sendername, 'N/A', '') as sendername, ve.senderid, ve.approvelevel, ve.accepterid, ve.acceptername, ve.processinstid, ve.title, ve.createtime, ve.creator, ve.creatorname, ve.deptid, ve.deptname, ve.workitemid, ve.beCommission, ve.batch from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1=1 and ve.globalID in ('P{208786791}', 'O{1120}', 'O{11}', 'G{344064838}') union select pendingcode, businessTypeId, null, null, null, null, null, null, businessTypeName, starttime, seandername, null, null, null, null, null, title, null, null, null, null, null, null, '0', null from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, to_char(tab1.senddate, 'yyyy-MM-dd HH24:mi:ss') as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :1 ) where 1=1 order by starttime desc ) where rownum<=:2
gzxgg79q2gcum select count(distinct id) from ( select ve.workflowid||'' as id from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and ve.globalID in ('P{209235018}', 'O{88582}', 'O{36065}') union select t.pendingcode as id from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, tab1.senddate as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :1 )t where 1=1 )
gzxtcfnj0qb20 select distinct * from ( select ve.BUSSINESSTYPE as BUSSINESSTYPE from v_executableworktask ve where 1= 1 and ve.globalID in ('P{205682896}', 'O{520259959}', 'O{5202}') union all select tab1.type as workflowtype from t_approve_notify tab1 where tab1.flag=:1 and tab1.recieverid = :2 )

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Sessions

Back to Top

Top Sessions

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Top Latches

Latch % Latch Blocking Sid % Activity Max Sampled Wait secs # Waits Sampled # Sampled Wts < 10ms # Sampled Wts 10ms - 100ms # Sampled Wts 100ms - 1s # Sampled Wts > 1s
latch: library cache 55.12 Held Shared 55.12 0.32 37,395 4 289 37,102 0
latch: shared pool 2.42 Held Shared 2.42 0.59 1,632 6 73 1,553 0

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration) Slot Count Event Event Count % Event
11:00:00 (5.0 min) 973 SQL*Net message from dblink 611 0.89
    CPU + Wait for CPU 348 0.50
    db file sequential read 7 0.01
11:05:00 (5.0 min) 1,128 SQL*Net message from dblink 816 1.18
    CPU + Wait for CPU 299 0.43
    db file sequential read 4 0.01
11:10:00 (5.0 min) 5,439 latch: library cache 1,961 2.84
    CPU + Wait for CPU 1,565 2.27
    cursor: pin S wait on X 421 0.61
11:15:00 (5.0 min) 5,292 latch: library cache 2,254 3.27
    CPU + Wait for CPU 1,211 1.76
    SQL*Net message from dblink 650 0.94
11:20:00 (5.0 min) 3,530 latch: library cache 1,273 1.85
    CPU + Wait for CPU 1,144 1.66
    SQL*Net message from dblink 542 0.79
11:25:00 (5.0 min) 2,362 CPU + Wait for CPU 808 1.17
    SQL*Net message from dblink 675 0.98
    latch: library cache 532 0.77
11:30:00 (5.0 min) 4,671 latch: library cache 2,500 3.62
    CPU + Wait for CPU 902 1.31
    SQL*Net message from dblink 522 0.76
11:35:00 (5.0 min) 13,968 latch: library cache 9,494 13.77
    cursor: pin S wait on X 2,935 4.26
    CPU + Wait for CPU 916 1.33
11:40:00 (5.0 min) 18,848 latch: library cache 12,122 17.58
    cursor: pin S wait on X 4,130 5.99
    CPU + Wait for CPU 1,439 2.09
11:45:00 (5.0 min) 12,195 latch: library cache 7,874 11.42
    cursor: pin S wait on X 2,777 4.03
    CPU + Wait for CPU 1,043 1.51
11:50:00 (5.0 min) 282 CPU + Wait for CPU 160 0.23
    SQL*Net message from dblink 94 0.14
    db file sequential read 8 0.01
11:55:00 (5.0 min) 281 CPU + Wait for CPU 146 0.21
    SQL*Net message from dblink 119 0.17
    db file sequential read 8 0.01


Back to Top

End of Report