STATSPACK report for Database DB Id Instance Inst Num Startup Time Release RAC ~~~~~~~~ ----------- ------------ -------- --------------- ----------- --- 1372668229 svtlsdb 1 22-Nov-08 23:09 10.2.0.3.0 NO Host Name: fvt108 Num CPUs: 2 Phys Memory (MB): 3,978 ~~~~ Snapshot Snap Id Snap Time Sessions Curs/Sess Comment ~~~~~~~~ ---------- ------------------ -------- --------- ------------------- Begin Snap: 11 23-Nov-08 00:02:54 48 43.8 End Snap: 12 23-Nov-08 00:08:18 49 45.3 Elapsed: 5.40 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 832M Std Block Size: 8K Shared Pool Size: 320M Log Buffer: 13,964K Load Profile Per Second Per Transaction ~~~~~~~~~~~~ --------------- --------------- Redo size: 41,792.07 3,296.16 Logical reads: 19,234.85 1,517.06 Block changes: 734.41 57.92 Physical reads: 2.60 0.20 Physical writes: 8.23 0.65 User calls: 395.93 31.23 Parses: 136.40 10.76 Hard parses: 0.57 0.05 Sorts: 7,757.80 611.86 Logons: 2.10 0.17 Executes: 638.18 50.33 Transactions: 12.68 % Blocks changed per Read: 3.82 Recursive Call %: 79.92 Rollback per transaction %: 2.12 Rows per Sort: 0.82 Instance Efficiency Percentages ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 99.99 In-memory Sort %: 100.00 Library Hit %: 98.81 Soft Parse %: 99.58 Execute to Parse %: 78.63 Latch Hit %: 99.99 Parse CPU to Parse Elapsd %: 80.20 % Non-Parse CPU: 96.57 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 55.64 58.17 % SQL with executions>1: 70.80 74.91 % Memory for SQL w/exec>1: 89.60 91.42 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time ----------------------------------------- ------------ ----------- ------ ------ CPU time 262 46.1 log file sync 4,104 122 30 21.5 log file parallel write 3,864 87 23 15.3 HS message to agent 31,437 52 2 9.2 db file parallel write 1,174 35 30 6.2 ------------------------------------------------------------- Host CPU (CPUs: 2) ~~~~~~~~ Load Average Begin End User System Idle WIO WCPU ------- ------- ------- ------- ------- ------- -------- 4.11 3.58 65.85 16.85 17.29 2.90 105.54 Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: 41.86 % of busy CPU for Instance: 50.61 %DB time waiting for CPU - Resource Mgr: Memory Statistics Begin End ~~~~~~~~~~~~~~~~~ ------------ ------------ Host Mem (MB): 3,977.6 3,977.6 SGA use (MB): 1,200.0 1,200.0 PGA use (MB): 158.3 166.2 % Host Mem used for SGA+PGA: 34.1 34.3 ------------------------------------------------------------- Time Model System Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Ordered by % of DB time desc, Statistic name Statistic Time (s) % of DB time ----------------------------------- -------------------- ------------ sql execute elapsed time 502.7 78.0 PL/SQL execution elapsed time 273.3 42.4 DB CPU 262.1 40.7 parse time elapsed 13.6 2.1 connection management call elapsed 6.2 1.0 hard parse elapsed time 3.6 .6 repeated bind elapsed time 0.0 .0 DB time 644.1 background elapsed time 125.7 background cpu time 4.5 ------------------------------------------------------------- Wait Events DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> s - second, cs - centisecond, ms - millisecond, us - microsecond -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by Total Wait Time desc, Waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn --------------------------------- ------------ ------ ---------- ------ -------- log file sync 4,104 0 122 30 1.0 log file parallel write 3,864 0 87 23 0.9 HS message to agent 31,437 0 52 2 7.7 db file parallel write 1,174 0 35 30 0.3 control file parallel write 138 0 4 27 0.0 db file sequential read 319 0 3 10 0.1 os thread startup 6 0 1 148 0.0 db file scattered read 67 0 1 12 0.0 buffer busy waits 17 0 0 20 0.0 SQL*Net more data to client 2,466 0 0 0 0.6 enq: TX - index contention 8 0 0 25 0.0 control file single write 11 0 0 15 0.0 enq: TX - row lock contention 2 0 0 8 0.0 control file sequential read 403 0 0 0 0.1 SQL*Net break/reset to client 20 0 0 0 0.0 SQL*Net message from client 111,045 0 9,611 87 27.0 Streams AQ: qmn slave idle wait 12 0 328 27364 0.0 Streams AQ: qmn coordinator idle 24 50 328 13682 0.0 jobq slave wait 53 98 155 2921 0.0 SQL*Net more data from client 4,232 0 1 0 1.0 SQL*Net message to client 111,046 0 0 0 27.0 ------------------------------------------------------------- Background Wait Events DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by Total Wait Time desc, Waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn --------------------------------- ------------ ------ ---------- ------ -------- log file parallel write 3,856 0 87 22 0.9 db file parallel write 1,174 0 35 30 0.3 control file parallel write 138 0 4 27 0.0 os thread startup 6 0 1 148 0.0 control file single write 11 0 0 15 0.0 control file sequential read 44 0 0 0 0.0 rdbms ipc message 4,532 22 2,381 525 1.1 Streams AQ: qmn slave idle wait 12 0 328 27364 0.0 Streams AQ: qmn coordinator idle 24 50 328 13682 0.0 pmon timer 160 100 313 1955 0.0 smon timer 9 0 259 28743 0.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Total Waits - units: K is 1000, M is 1000000, G is 1000000000 -> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms -> % of Waits - value: .0 indicates value was <.05%, null is truly 0 -> Ordered by Event (idle events last) Total ----------------- % of Waits ------------------ Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- HS message to agent 31K 89.7 3.2 1.3 1.2 1.2 2.4 .9 LGWR wait for redo copy 4 100.0 SQL*Net break/reset to cli 20 100.0 SQL*Net more data to clien 2466 99.6 .1 .1 .1 .0 .0 buffer busy waits 17 64.7 5.9 5.9 23.5 control file parallel writ 138 4.3 31.9 45.7 18.1 control file sequential re 403 100.0 control file single write 11 9.1 54.5 27.3 9.1 db file parallel write 1174 .3 23.7 55.5 20.5 db file scattered read 66 22.7 1.5 24.2 19.7 27.3 4.5 db file sequential read 314 22.3 1.3 4.8 35.4 22.9 8.6 4.8 enq: TX - index contention 8 12.5 25.0 37.5 25.0 enq: TX - row lock content 2 50.0 50.0 latch free 2 100.0 latch: cache buffers chain 2 100.0 log file parallel write 3861 36.9 53.5 9.5 log file sync 4100 .1 .0 .1 28.8 47.6 23.4 os thread startup 6 100.0 SQL*Net message from clien 111K 70.4 10.3 5.5 4.2 3.8 1.9 2.6 1.3 SQL*Net message to client 111K 100.0 .0 .0 .0 .0 SQL*Net more data from cli 4232 98.1 1.6 .2 .0 .0 .0 .0 Streams AQ: qmn coordinato 24 41.7 4.2 4.2 50.0 Streams AQ: qmn slave idle 12 100.0 jobq slave wait 53 100.0 pmon timer 160 12.5 1.9 4.4 1.3 6.3 1.3 6.3 66.3 rdbms ipc message 4536 14.0 .8 2.4 11.4 6.5 7.2 44.4 13.3 smon timer 9 11.1 88.9 ------------------------------------------------------------- SQL ordered by CPU DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total DB CPU (s): 262 -> Captured SQL accounts for 149.4% of Total DB CPU -> SQL reported below exceeded 1.0% of Total DB CPU CPU CPU per Elapsd Old Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- 97.15 204 0.48 37.1 124.82 4,531,728 3467345457 Module: dllhost.exe CALL ICMLSPKG.ICMDELETEITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,: 12,:13,:14,:15) 68.85 203 0.34 26.3 87.92 2,905,336 370994769 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00200001 PR ,ICMUT00201001 RS ,ICMUT00202001 WN where ((((PR.ITEMID=:b1 and PR.PROCESSNAME =WN.WORKNODENAME) and (WN.ITEMID=RS.FROMWNITEMID or WN.ITEMID=RS .TOWNITEMID)) and WN.WORKNODETYPE=:"SYS_B_1") and ROWNUM<:"SYS_B _2") 42.24 331 0.13 16.1 89.46 350,039 2707031533 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 25.81 12,686 0.00 9.8 29.01 138,640 2486774319 Module: dllhost.exe select C.ATTRIBUTEID ,C.ATTRIBUTEGROUP ,C.SEQUENCENUM ,C.ATTRFLA GS ,C.DEFAULTTYPE ,C.DEFAULTVALUE ,A.ATTRSQLTYPE ,A.ATTRLENGTH , A.ATTRSCALE from ICMSTATTRDEFS A ,ICMSTCOMPATTRS C where (C.COM PONENTTYPEID=:b0 and C.ATTRIBUTEID=A.ATTRIBUTEID) order by C.SEQ UENCENUM 23.99 2,849 0.01 9.2 67.65 350,310 3370725959 Module: dllhost.exe CALL ICMLSPKG.ICMGETITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12, :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28, :29,:30,:31,:32,:33) 23.05 203 0.11 8.8 26.67 1,535,086 1456593118 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00204001 where (PROCESSITE MID=:b1 and ROWNUM<:"SYS_B_1") 12.68 650 0.02 4.8 76.72 20,809 437928417 Module: dllhost.exe CALL ICMLSPKG.ICMLOGON(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:1 3,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:2 9,:30,:31) 9.73 1,347 0.01 3.7 24.07 84,972 2648636559 Module: dllhost.exe CALL ICMLSPKG.ICMSEARCH(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,: 13,:14,:15,:16) 7.99 219 0.04 3.0 22.06 67,715 72702193 Module: dllhost.exe SQL ordered by CPU DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total DB CPU (s): 262 -> Captured SQL accounts for 149.4% of Total DB CPU -> SQL reported below exceeded 1.0% of Total DB CPU CPU CPU per Elapsd Old Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- CALL ICMLSPKG.ICMCREATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 6.58 2 3.29 2.5 7.29 67,043 4277267583 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT PLCS_FL D_1.ITEMID, PLCS_FLD_1.COMPONENTID, PLCS_FLD_1.VERSIONID, :"SYS_ B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID FROM ICMUT02 374001 PLCS_FLD_1 WHERE (PLCS_FLD_1.ATTR0000002137 like :"SYS_B_ 02") AND (((( ( (EXISTS (SELECT :"SYS_B_03" FROM ICMSTCOMPILEDAC 5.53 332 0.02 2.1 15.39 49,217 3029130978 Module: dllhost.exe CALL ICMLSPKG.ICMCREATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 4.92 280 0.02 1.9 12.35 76,468 2182786527 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 4.31 49 0.09 1.6 5.18 80,752 2912681429 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT GPSFold er_1.ITEMID, GPSFolder_1.COMPONENTID, GPSFolder_1.VERSIONID, :"S YS_B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID FROM ICMU T02427001 GPSFolder_1 WHERE (UPPER(GPSFolder_1.ATTR0000002084) = :"SYS_B_02") AND (((( ( (EXISTS (SELECT :"SYS_B_03" FROM ICMSTC 3.98 528 0.01 1.5 6.92 47,739 2371518632 Module: dllhost.exe CALL ICMLSPKG.ICMCHECKOUTITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11 ,:12,:13,:14,:15,:16,:17,:18) ------------------------------------------------------------- SQL ordered by Elapsed DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total DB Time (s): 644 -> Captured SQL accounts for 104.6% of Total DB Time -> SQL reported below exceeded 1.0% of Total DB Time Elapsed Elap per CPU Old Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- 124.82 204 0.61 19.4 97.15 0 3467345457 Module: dllhost.exe CALL ICMLSPKG.ICMDELETEITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,: 12,:13,:14,:15) 89.46 331 0.27 13.9 42.24 62 2707031533 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 87.92 203 0.43 13.6 68.85 0 370994769 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00200001 PR ,ICMUT00201001 RS ,ICMUT00202001 WN where ((((PR.ITEMID=:b1 and PR.PROCESSNAME =WN.WORKNODENAME) and (WN.ITEMID=RS.FROMWNITEMID or WN.ITEMID=RS .TOWNITEMID)) and WN.WORKNODETYPE=:"SYS_B_1") and ROWNUM<:"SYS_B _2") 76.72 650 0.12 11.9 12.68 0 437928417 Module: dllhost.exe CALL ICMLSPKG.ICMLOGON(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:1 3,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:2 9,:30,:31) 67.65 2,849 0.02 10.5 23.99 0 3370725959 Module: dllhost.exe CALL ICMLSPKG.ICMGETITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12, :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28, :29,:30,:31,:32,:33) 29.01 12,686 0.00 4.5 25.81 0 2486774319 Module: dllhost.exe select C.ATTRIBUTEID ,C.ATTRIBUTEGROUP ,C.SEQUENCENUM ,C.ATTRFLA GS ,C.DEFAULTTYPE ,C.DEFAULTVALUE ,A.ATTRSQLTYPE ,A.ATTRLENGTH , A.ATTRSCALE from ICMSTATTRDEFS A ,ICMSTCOMPATTRS C where (C.COM PONENTTYPEID=:b0 and C.ATTRIBUTEID=A.ATTRIBUTEID) order by C.SEQ UENCENUM 26.67 203 0.13 4.1 23.05 0 1456593118 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00204001 where (PROCESSITE MID=:b1 and ROWNUM<:"SYS_B_1") 24.07 1,347 0.02 3.7 9.73 0 2648636559 Module: dllhost.exe CALL ICMLSPKG.ICMSEARCH(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,: 13,:14,:15,:16) 22.06 219 0.10 3.4 7.99 73 72702193 Module: dllhost.exe SQL ordered by Elapsed DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total DB Time (s): 644 -> Captured SQL accounts for 104.6% of Total DB Time -> SQL reported below exceeded 1.0% of Total DB Time Elapsed Elap per CPU Old Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- CALL ICMLSPKG.ICMCREATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 15.39 332 0.05 2.4 5.53 10 3029130978 Module: dllhost.exe CALL ICMLSPKG.ICMCREATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 12.35 280 0.04 1.9 4.92 0 2182786527 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 8.23 219 0.04 1.3 2.27 23 2369546304 Module: dllhost.exe CALL ICMLSPKG.ICMPREPCRTDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,: 11,:12,:13,:14,:15,:16,:17,:18,:19) 7.29 2 3.64 1.1 6.58 0 4277267583 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT PLCS_FL D_1.ITEMID, PLCS_FLD_1.COMPONENTID, PLCS_FLD_1.VERSIONID, :"SYS_ B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID FROM ICMUT02 374001 PLCS_FLD_1 WHERE (PLCS_FLD_1.ATTR0000002137 like :"SYS_B_ 02") AND (((( ( (EXISTS (SELECT :"SYS_B_03" FROM ICMSTCOMPILEDAC 6.92 528 0.01 1.1 3.98 0 2371518632 Module: dllhost.exe CALL ICMLSPKG.ICMCHECKOUTITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11 ,:12,:13,:14,:15,:16,:17,:18) ------------------------------------------------------------- SQL ordered by Gets DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> End Buffer Gets Threshold: 10000 Total Buffer Gets: 6,232,090 -> Captured SQL accounts for 179.4% of Total Buffer Gets -> SQL reported below exceeded 1.0% of Total Buffer Gets CPU Elapsd Old Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 4,531,728 204 22,214.4 72.7 97.15 124.82 3467345457 Module: dllhost.exe CALL ICMLSPKG.ICMDELETEITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,: 12,:13,:14,:15) 2,905,336 203 14,312.0 46.6 68.85 87.92 370994769 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00200001 PR ,ICMUT00201001 RS ,ICMUT00202001 WN where ((((PR.ITEMID=:b1 and PR.PROCESSNAME =WN.WORKNODENAME) and (WN.ITEMID=RS.FROMWNITEMID or WN.ITEMID=RS .TOWNITEMID)) and WN.WORKNODETYPE=:"SYS_B_1") and ROWNUM<:"SYS_B _2") 1,535,086 203 7,562.0 24.6 23.05 26.67 1456593118 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMUT00204001 where (PROCESSITE MID=:b1 and ROWNUM<:"SYS_B_1") 350,310 2,849 123.0 5.6 23.99 67.65 3370725959 Module: dllhost.exe CALL ICMLSPKG.ICMGETITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12, :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28, :29,:30,:31,:32,:33) 350,039 331 1,057.5 5.6 42.24 89.46 2707031533 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 138,640 12,686 10.9 2.2 25.81 29.01 2486774319 Module: dllhost.exe select C.ATTRIBUTEID ,C.ATTRIBUTEGROUP ,C.SEQUENCENUM ,C.ATTRFLA GS ,C.DEFAULTTYPE ,C.DEFAULTVALUE ,A.ATTRSQLTYPE ,A.ATTRLENGTH , A.ATTRSCALE from ICMSTATTRDEFS A ,ICMSTCOMPATTRS C where (C.COM PONENTTYPEID=:b0 and C.ATTRIBUTEID=A.ATTRIBUTEID) order by C.SEQ UENCENUM 84,972 1,347 63.1 1.4 9.73 24.07 2648636559 Module: dllhost.exe CALL ICMLSPKG.ICMSEARCH(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,: 13,:14,:15,:16) 80,752 49 1,648.0 1.3 4.31 5.18 2912681429 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT GPSFold er_1.ITEMID, GPSFolder_1.COMPONENTID, GPSFolder_1.VERSIONID, :"S YS_B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID FROM ICMU T02427001 GPSFolder_1 WHERE (UPPER(GPSFolder_1.ATTR0000002084) = :"SYS_B_02") AND (((( ( (EXISTS (SELECT :"SYS_B_03" FROM ICMSTC SQL ordered by Gets DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> End Buffer Gets Threshold: 10000 Total Buffer Gets: 6,232,090 -> Captured SQL accounts for 179.4% of Total Buffer Gets -> SQL reported below exceeded 1.0% of Total Buffer Gets CPU Elapsd Old Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 78,498 39,249 2.0 1.3 2.25 2.55 1652415585 Module: dllhost.exe select COMPONENTTYPEID into :b0 from ICMSTCOMPVIEWDEFS where (C OMPONENTVIEWID=:b1 and ROWNUM<:"SYS_B_0") 76,468 280 273.1 1.2 4.92 12.35 2182786527 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 74,127 279 265.7 1.2 0.39 0.48 1479930697 Module: dllhost.exe select D.COMPONENTVIEWID ,D.COMPONENTTYPEID from ICMSTCOMPVIEWD EFS A ,ICMSTCOMPDEFS B ,ICMSTITVIEWID C ,ICMSTCOMPVIEWDEFS D whe re ((((A.COMPONENTVIEWID=:b0 and A.COMPONENTTYPEID=B.PARENTCOMPT YPEID) and B.COMPONENTTYPEID=D.COMPONENTTYPEID) and D.COMPONENTV IEWID=C.COMPONENTVIEWID) and C.ITEMTYPEVIEWID=:b1) order by D.CO 73,234 36,615 2.0 1.2 1.46 1.58 261344901 Module: dllhost.exe select ITEMLEVELACLFLAG into :b0 from ICMSTITEMTYPEDEFS where I TEMTYPEID=:b1 67,715 219 309.2 1.1 7.99 22.06 72702193 Module: dllhost.exe CALL ICMLSPKG.ICMCREATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 67,043 2 33,521.5 1.1 6.58 7.29 4277267583 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM (SELECT DISTINCT PLCS_FL D_1.ITEMID, PLCS_FLD_1.COMPONENTID, PLCS_FLD_1.VERSIONID, :"SYS_ B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID FROM ICMUT02 374001 PLCS_FLD_1 WHERE (PLCS_FLD_1.ATTR0000002137 like :"SYS_B_ 02") AND (((( ( (EXISTS (SELECT :"SYS_B_03" FROM ICMSTCOMPILEDAC ------------------------------------------------------------- SQL ordered by Reads DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Disk Reads Threshold: 1000 Total Disk Reads: 842 -> Captured SQL accounts for 43.0% of Total Disk Reads -> SQL reported below exceeded 1.0% of Total Disk Reads CPU Elapsd Old Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 133 1 133.0 15.8 0.42 0.95 2522684317 Module: sqlplus@fvt108 (TNS V1-V3) BEGIN statspack.snap; END; 73 219 0.3 8.7 7.99 22.06 72702193 Module: dllhost.exe CALL ICMLSPKG.ICMCREATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 62 331 0.2 7.4 42.24 89.46 2707031533 Module: dllhost.exe CALL ICMLSPKG.ICMUPDATEDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:1 1,:12,:13,:14,:15,:16,:17,:18,:19) 35 772 0.0 4.2 0.70 1.30 3214843858 Module: dllhost.exe insert into ICMSTITEMS001001 (ITEMID,VERSIONID,COMPONENTID,SEGME NTID,ACLCODE,SEMANTICTYPE,ITEMTYPEID,COMPONENTTYPEID,CHANGED,INP ROGRESS,ICMMANAGEDRECORD) values (:b0,:b1,:b2,:b3,:b4,:b5,:b6,:b 7,SYS_EXTRACT_UTC(SYSTIMESTAMP),:b8,:"SYS_B_0") 35 260 0.1 4.2 0.17 0.39 3858065425 Module: dllhost.exe insert into ICMSTRI001001 (SOURCEITEMID,SOURCEITEMTYPEID,SOURCEC OMPID,SOURCECOMPTYPEID,SOURCEVERSIONID,TARGETITEMID,TARGETITEMTY PEID,TARGETCOMPID,TARGETCOMPTYPEID,TARGETVERSIONID,RRIID,STATUS) values (:b0,:b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:"SYS_B_0" ) 34 626 0.1 4.0 0.45 0.66 1236604319 Module: dllhost.exe update ICMSTITEMS001001 set VERSIONID=:b0,SEGMENTID=:b1,ACLCODE =:b2,SEMANTICTYPE=:b3,ITEMTYPEID=:b4,COMPONENTTYPEID=:b5,CHANGED =TO_TIMESTAMP(RTRIM(:b6),:"SYS_B_0"),ICMMANAGEDRECORD=:b7 where ITEMID=:b8 23 219 0.1 2.7 2.27 8.23 2369546304 Module: dllhost.exe CALL ICMLSPKG.ICMPREPCRTDOCPART(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,: 11,:12,:13,:14,:15,:16,:17,:18,:19) 19 516 0.0 2.3 0.36 0.50 887067706 Module: dllhost.exe update ICMSTITEMS001001 set CHANGED=TO_TIMESTAMP(RTRIM(:b0),:"S YS_B_0"),INPROGRESS=:b1 where ITEMID=:b2 19 611 0.0 2.3 0.10 0.16 3262600863 Module: dllhost.exe select :"SYS_B_0" into :b0 from ICMSTRI001001 where ((((((TARGE TITEMID=:b1 and TARGETCOMPID=:b2) and TARGETCOMPTYPEID=:b3) and TARGETITEMTYPEID=:b4) and SOURCEITEMTYPEID=:b5) and SOURCECOMPTY PEID=:b6) and ROWNUM<:"SYS_B_1") SQL ordered by Reads DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Disk Reads Threshold: 1000 Total Disk Reads: 842 -> Captured SQL accounts for 43.0% of Total Disk Reads -> SQL reported below exceeded 1.0% of Total Disk Reads CPU Elapsd Old Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 10 332 0.0 1.2 5.53 15.39 3029130978 Module: dllhost.exe CALL ICMLSPKG.ICMCREATEITEMS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11, :12,:13,:14,:15,:16,:17,:18,:19) 9 79 0.1 1.1 0.15 0.16 885295739 Module: dllhost.exe INSERT INTO SVTLSADM.ICMUT02359001(COMPCLUSTERID, COMPONENTID, I TEMID, VERSIONID, ACLCODE, SEMANTICTYPE, EXPIRATIONDATE, COMPKEY , CREATETS, CREATEUSERID, LASTCHANGEDTS, LASTCHANGEDUSERID, ATTR 0000002129, ATTR0000002155, ATTR0000002182, ATTR0000001077, ATTR 0000001078, ATTR0000002119, ATTR0000002168, ATTR0000002153, ATTR ------------------------------------------------------------- SQL ordered by Executions DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Executions Threshold: 100 Total Executions: 206,769 -> Captured SQL accounts for 97.5% of Total Executions -> SQL reported below exceeded 1.0% of Total Executions CPU per Elap per Old Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- 39,249 39,249 1.0 0.00 0.00 1652415585 Module: dllhost.exe select COMPONENTTYPEID into :b0 from ICMSTCOMPVIEWDEFS where (C OMPONENTVIEWID=:b1 and ROWNUM<:"SYS_B_0") 36,615 36,617 1.0 0.00 0.00 261344901 Module: dllhost.exe select ITEMLEVELACLFLAG into :b0 from ICMSTITEMTYPEDEFS where I TEMTYPEID=:b1 14,561 14,561 1.0 0.00 0.00 332751908 Module: dllhost.exe select ACCESSMODULESTATUS into :b0 from ICMSTCOMPVIEWDEFS where COMPONENTVIEWID=:b1 13,312 13,312 1.0 0.00 0.00 2591812284 Module: dllhost.exe select count(*) into :b0 from ICMSTCOMPATTRS where COMPONENTTY PEID=:b1 12,686 237,013 18.7 0.00 0.00 2486774319 Module: dllhost.exe select C.ATTRIBUTEID ,C.ATTRIBUTEGROUP ,C.SEQUENCENUM ,C.ATTRFLA GS ,C.DEFAULTTYPE ,C.DEFAULTVALUE ,A.ATTRSQLTYPE ,A.ATTRLENGTH , A.ATTRSCALE from ICMSTATTRDEFS A ,ICMSTCOMPATTRS C where (C.COM PONENTTYPEID=:b0 and C.ATTRIBUTEID=A.ATTRIBUTEID) order by C.SEQ UENCENUM 5,546 5,542 1.0 0.00 0.00 3472917369 Module: java@cmsun07 (TNS V1-V3) select :"SYS_B_0" into :b0 from ICMSTCOMPILEDPERM where (UNUM=: b1 and PRIVDEFCODE=:b2) 4,933 4,933 1.0 0.00 0.00 3551714715 Module: dllhost.exe SELECT VIEWACCESSINFO, ACLSUBSELECT, TO_CHAR(LASTCHANGEDTS, :"SY S_B_0") FROM ICMSTVIEWACCESS WHERE COMPONENTVIEWID=:h1 AND SEGME NTID=:h2 3,238 3,238 1.0 0.00 0.00 1534611058 Module: dllhost.exe select RMFLAGS into :b0 from ICMSTRESOURCEMGR where RMCODE=:b1 2,849 0 0.0 0.01 0.02 3370725959 Module: dllhost.exe CALL ICMLSPKG.ICMGETITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12, :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28, :29,:30,:31,:32,:33) 2,847 2,847 1.0 0.00 0.00 4099525024 Module: dllhost.exe select A.ITEMTYPECLASS ,A.ITEMEVENTFLAG ,A.ITEMLEVELACLFLAG ,A.I SQL ordered by Executions DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Executions Threshold: 100 Total Executions: 206,769 -> Captured SQL accounts for 97.5% of Total Executions -> SQL reported below exceeded 1.0% of Total Executions CPU per Elap per Old Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value ------------ --------------- ---------------- ----------- ---------- ---------- TEMTYPEFLAG ,B.ACLCODE into :b0,:b1,:b2,:b3,:b4 from ICMSTITEMT YPEDEFS A ,ICMSTITVIEWDEFS B where (A.ITEMTYPEID=B.ITEMTYPEID an d B.ITEMTYPEVIEWID=:b5) 2,833 2,916 1.0 0.00 0.00 401489244 Module: dllhost.exe select PRIVS from ICMSTCOMPILEDACL where ((ACL=:b0 or ACL=(-:"S YS_B_0")) and UNUM=:b1) union select PRIVS from ICMSTCOMPILEDAC L where (((ACL=:b0 or ACL=(-:"SYS_B_1")) and UNUM=:"SYS_B_2") an d exists (select :"SYS_B_3" from ICMSTCOMPILEDPERM where (UNUM= :b1 and PRIVDEFCODE=:b4))) 2,376 2,376 1.0 0.00 0.00 587455219 Module: dllhost.exe select ITEMTYPECLASS ,ACLCODE ,ITEMLEVELACLFLAG ,VERSIONCONTROL ,VERSIONMAX ,DFLTPREFCHCOLLCODE ,DFLTXDOCLASSID ,AUTOLINKENABLE ,AUTOLINKSMS ,ITEMEVENTFLAG ,PROCESSNAME ,DFLTPRIORITY ,DFLTRETE NTIONUNIT ,DFLTITEMRETENTION into :b0,:b1,:b2,:b3,:b4,:b5,:b6,:b 7,:b8,:b9,:b10:b11,:b12:b13,:b14,:b15 from ICMSTITEMTYPEDEFS IT ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Parse Calls Threshold: 1000 Total Parse Calls: 44,192 -> Captured SQL accounts for 85.8% of Total Parse Calls -> SQL reported below exceeded 1.0% of Total Parse Calls % Total Old Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- 4,933 4,933 11.16 3551714715 Module: dllhost.exe SELECT VIEWACCESSINFO, ACLSUBSELECT, TO_CHAR(LASTCHANGEDTS, :"SY S_B_0") FROM ICMSTVIEWACCESS WHERE COMPONENTVIEWID=:h1 AND SEGME NTID=:h2 2,848 2,849 6.44 3370725959 Module: dllhost.exe CALL ICMLSPKG.ICMGETITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12, :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28, :29,:30,:31,:32,:33) 1,347 1,347 3.05 2648636559 Module: dllhost.exe CALL ICMLSPKG.ICMSEARCH(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,: 13,:14,:15,:16) 1,308 1,615 2.96 3908166862 Module: java@cmsun07 (TNS V1-V3) select UPPER(:b0) into :b0 from DUAL 1,300 1,300 2.94 1049533648 Module: java@cmsun07 (TNS V1-V3) update ICMSTUSERS set LOGGEDON=:"SYS_B_0" where USERID=:b0 662 662 1.50 3840591838 select privilege# from sysauth$ where (grantee#=:1 or grantee#=1 ) and privilege#>0 656 912 1.48 194186009 Module: java@cmsun07 (TNS V1-V3) select LIBRARYSERVERID ,LANGUAGECODE ,SYSSEGMENTID ,SYSSEGMENTTH RESHLD ,ACLBINDINGLEVEL ,LIBRARYACLCODE ,PUBACCESSENABLED ,DFLTA CLCHOICE ,SMSCHOICE ,TRACELEVEL ,MAXUSERS ,MAXUSERACTION ,CURREN TUSERS ,MAXLOGONRETRY ,PASSWORDDURATION ,SYSADMINEVENTFLAG ,SYST EMFLAG ,DATABASETYPE ,MAXTXDURATION ,MAXRESULTSETSIZE ,ALLOWTRUS 656 656 1.48 801255854 select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERE NV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTU P_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance wher e INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') 656 656 1.48 3425645771 select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT ', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE ', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failove r_delay, flags from service$ where name = :1 656 656 1.48 4166735688 select value$ from props$ where name = 'GLOBAL_DB_NAME' SQL ordered by Parse Calls DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Parse Calls Threshold: 1000 Total Parse Calls: 44,192 -> Captured SQL accounts for 85.8% of Total Parse Calls -> SQL reported below exceeded 1.0% of Total Parse Calls % Total Old Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- 651 650 1.47 437928417 Module: dllhost.exe CALL ICMLSPKG.ICMLOGON(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:1 3,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:2 9,:30,:31) 651 651 1.47 463672576 Module: java@cmsun07 (TNS V1-V3) select :"SYS_B_0" into :b0 from ICMSTNLSLANGUAGES where LANGUAG ECODE=:b1 651 651 1.47 1698605937 Module: java@cmsun07 (TNS V1-V3) select USER into :b0 from DUAL 651 651 1.47 2670598184 Module: java@cmsun07 (TNS V1-V3) SELECT LIBRARYSERVERID,LANGUAGECODE,SYSSEGMENTID,SYSSEGMENTTHRES HLD,ACLBINDINGLEVEL,LIBRARYACLCODE,PUBACCESSENABLED,DFLTACLCHOIC E,SMSCHOICE,TRACELEVEL,MAXUSERS,MAXUSERACTION,CURRENTUSERS,MAXLO GONRETRY,PASSWORDDURATION,SYSADMINEVENTFLAG,DATABASETYPE,MAXTXDU RATION,ALLOWTRUSTEDLOGON,DOCROUTINGUPDATE,DOCROUTINGFREQ,TIEUSER 651 651 1.47 2837744703 Module: java@cmsun07 (TNS V1-V3) select U.UNUM ,U.USERID ,U.DOMAINID ,U.USERNAME ,U.USERPRIVSETCO DE ,K1.KEYWORDNAME USERPRIVSET ,U.GRANTPRIVSETCODE ,K2.KEYWORDNA ME GRANTPRIVSET ,U.DFLTACLCODE ,K3.KEYWORDNAME DFLTITEMACL ,U.DF LTRMCODE ,RMNAME ,U.DFLTCOLLCODE ,C.SMSCOLLNAME SMSCOLLECTION ,U .LASTACCESS ,U.PASSWORD ,U.RETRYCOUNT ,TO_CHAR(PASSWORDEXPIRATIO 650 650 1.47 1759003923 Module: dllhost.exe CALL ICMLSPKG.ICMLOGOFF(:1,:2,:3,:4,:5,:6,:7,:8,:9) 650 650 1.47 2032517917 Module: java@cmsun07 (TNS V1-V3) call icmlspkg.execstmtwat(:b0) 650 650 1.47 2230517700 Module: dllhost.exe SELECT PRIVDEFCODE FROM SVTLSADM.ICMSTPRIVSETS WHERE PRIVSETCODE = :"SYS_B_0" 650 650 1.47 3944164234 Module: java@cmsun07 (TNS V1-V3) select count(U.UNUM) into :b0 from ICMSTUSERS U ,ICMSTCOMPILEDP ERM P where ((U.UNUM=:b1 and U.UNUM=P.UNUM) and P.PRIVDEFCODE=:" SYS_B_0") 606 606 1.37 2964190568 SQL ordered by Parse Calls DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Parse Calls Threshold: 1000 Total Parse Calls: 44,192 -> Captured SQL accounts for 85.8% of Total Parse Calls -> SQL reported below exceeded 1.0% of Total Parse Calls % Total Old Parse Calls Executions Parses Hash Value ------------ ------------ -------- ---------- Module: dllhost.exe SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTY PE,A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS,A. LASTCHANGEDUSERID,A.ATTR0000002124,A.ATTR0000002123,A.ATTR000000 2137,A.ATTR0000002132,A.ATTR0000002135,A.ATTR0000002163,A.ICMMAN AGEDRECORD ,B.USERID, B.CREATED FROM SVTLSADM.ICMUT02353001 A L 528 528 1.19 2371518632 Module: dllhost.exe CALL ICMLSPKG.ICMCHECKOUTITEM(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11 ,:12,:13,:14,:15,:16,:17,:18) 459 459 1.04 3696995247 Module: dllhost.exe SELECT A.COMPONENTID,A.ITEMID,A.VERSIONID,A.ACLCODE,A.SEMANTICTY PE,A.EXPIRATIONDATE,A.CREATETS,A.CREATEUSERID,A.LASTCHANGEDTS,A. LASTCHANGEDUSERID,A.ATTR0000002084,A.ATTR0000002085,A.ATTR000000 2086,A.ATTR0000002087,A.ATTR0000002088,A.ATTR0000002089,A.ATTR00 00002090,A.ATTR0000002091,A.ATTR0000002092,A.ATTR0000002093,A.AT ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Old Hash Value ---------------- ------------ ------- -------------- 14,425,034 58 4.3 4048129702 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID, GPSQueue_1.A TTR0000002096 AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE (((GP SQueue_1.ATTR0000002084 like :"SYS_B_2") and (GPSQueue_1.ATTR000 11,963,126 42 3.6 683295453 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID, GPSQueue_1.A TTR0000002096 AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE ((((G PSQueue_1.ATTR0000002084 like :"SYS_B_2") and (GPSQueue_1.ATTR00 9,695,523 19 2.9 4013808567 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID, GPSQueue_1 .CREATETS AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE ((GPSQueu e_1.ATTR0000002084 like :"SYS_B_02") and (GPSQueue_1.ATTR0000002 ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> End Version Count Threshold: 20 Version Count Executions Old Hash Value -------- ------------ --------------- 530 58 4048129702 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID, GPSQueue_1.A TTR0000002096 AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE (((GP SQueue_1.ATTR0000002084 like :"SYS_B_2") and (GPSQueue_1.ATTR000 382 42 683295453 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_0" AS COMPONENTTYPEID, :"SYS_B_1" AS ITEMTYPEID, GPSQueue_1.A TTR0000002096 AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE ((((G PSQueue_1.ATTR0000002084 like :"SYS_B_2") and (GPSQueue_1.ATTR00 183 19 4013808567 Module: dllhost.exe SELECT /*+ FIRST_ROWS (500) */ T.* FROM ((SELECT DISTINCT GPSQue ue_1.ITEMID, GPSQueue_1.COMPONENTID, GPSQueue_1.VERSIONID, :"SYS _B_00" AS COMPONENTTYPEID, :"SYS_B_01" AS ITEMTYPEID, GPSQueue_1 .CREATETS AS Exp_1 FROM ICMUT02428001 GPSQueue_1 WHERE ((GPSQueu e_1.ATTR0000002084 like :"SYS_B_02") and (GPSQueue_1.ATTR0000002 ------------------------------------------------------------- Instance Activity Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ CPU used by this session 26,221 80.9 6.4 CPU used when call started 26,355 81.3 6.4 CR blocks created 709 2.2 0.2 DB time 88,072 271.8 21.4 DBWR checkpoint buffers written 2,665 8.2 0.7 DBWR checkpoints 0 0.0 0.0 DBWR revisited being-written buff 0 0.0 0.0 DBWR transaction table writes 17 0.1 0.0 DBWR undo block writes 999 3.1 0.2 SQL*Net roundtrips to/from client 108,816 335.9 26.5 SQL*Net roundtrips to/from dblink 11,345 35.0 2.8 active txn count during cleanout 1,054 3.3 0.3 application wait time 2 0.0 0.0 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 1,018 3.1 0.3 branch node splits 0 0.0 0.0 buffer is not pinned count 2,714,501 8,378.1 660.8 buffer is pinned count 5,644,605 17,421.6 1,374.1 bytes received via SQL*Net from c 29,248,245 90,272.4 7,119.8 bytes received via SQL*Net from d 8,171,077 25,219.4 1,989.1 bytes sent via SQL*Net to client 23,433,450 72,325.5 5,704.4 bytes sent via SQL*Net to dblink 12,307,092 37,984.9 2,995.9 calls to get snapshot scn: kcmgss 468,609 1,446.3 114.1 calls to kcmgas 5,123 15.8 1.3 calls to kcmgcs 167 0.5 0.0 change write time 176 0.5 0.0 cleanout - number of ktugct calls 942 2.9 0.2 cleanouts and rollbacks - consist 526 1.6 0.1 cleanouts only - consistent read 21 0.1 0.0 cluster key scan block gets 775 2.4 0.2 cluster key scans 444 1.4 0.1 commit batch/immediate performed 10 0.0 0.0 commit batch/immediate requested 10 0.0 0.0 commit cleanout failures: buffer 2 0.0 0.0 commit cleanout failures: callbac 19 0.1 0.0 commit cleanout failures: cannot 9 0.0 0.0 commit cleanouts 25,221 77.8 6.1 commit cleanouts successfully com 25,191 77.8 6.1 commit immediate performed 10 0.0 0.0 commit immediate requested 10 0.0 0.0 commit txn count during cleanout 316 1.0 0.1 concurrency wait time 143 0.4 0.0 consistent changes 165,075 509.5 40.2 consistent gets 5,652,900 17,447.2 1,376.1 consistent gets - examination 477,268 1,473.1 116.2 consistent gets from cache 5,652,900 17,447.2 1,376.1 cursor authentications 9 0.0 0.0 data blocks consistent reads - un 797 2.5 0.2 db block changes 237,950 734.4 57.9 db block gets 579,187 1,787.6 141.0 db block gets direct 0 0.0 0.0 db block gets from cache 579,187 1,787.6 141.0 deferred (CURRENT) block cleanout 7,903 24.4 1.9 enqueue conversions 403 1.2 0.1 enqueue releases 22,143 68.3 5.4 Instance Activity Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ enqueue requests 22,141 68.3 5.4 enqueue timeouts 0 0.0 0.0 enqueue waits 10 0.0 0.0 exchange deadlocks 0 0.0 0.0 execute count 206,769 638.2 50.3 free buffer inspected 5 0.0 0.0 free buffer requested 47,119 145.4 11.5 heap block compress 271 0.8 0.1 immediate (CR) block cleanout app 547 1.7 0.1 immediate (CURRENT) block cleanou 4,275 13.2 1.0 index crx upgrade (found) 2 0.0 0.0 index crx upgrade (positioned) 8,945 27.6 2.2 index fast full scans (full) 620 1.9 0.2 index fetch by key 199,327 615.2 48.5 index scans kdiixs1 1,830,310 5,649.1 445.6 leaf node 90-10 splits 34 0.1 0.0 leaf node splits 95 0.3 0.0 lob reads 45,928 141.8 11.2 lob writes 42,914 132.5 10.5 lob writes unaligned 37,421 115.5 9.1 logons cumulative 679 2.1 0.2 messages received 5,039 15.6 1.2 messages sent 5,039 15.6 1.2 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 5,019,801 15,493.2 1,222.0 opened cursors cumulative 40,970 126.5 10.0 parse count (failures) 0 0.0 0.0 parse count (hard) 185 0.6 0.1 parse count (total) 44,192 136.4 10.8 parse time cpu 899 2.8 0.2 parse time elapsed 1,121 3.5 0.3 physical read IO requests 357 1.1 0.1 physical read bytes 6,897,664 21,289.1 1,679.1 physical read total IO requests 760 2.4 0.2 physical read total bytes 10,199,040 31,478.5 2,482.7 physical read total multi block r 63 0.2 0.0 physical reads 842 2.6 0.2 physical reads cache 842 2.6 0.2 physical reads cache prefetch 485 1.5 0.1 physical reads direct 0 0.0 0.0 physical reads direct temporary t 0 0.0 0.0 physical reads prefetch warmup 485 1.5 0.1 physical write IO requests 1,174 3.6 0.3 physical write bytes 21,831,680 67,381.7 5,314.4 physical write total IO requests 5,303 16.4 1.3 physical write total bytes 38,817,792 119,808.0 9,449.3 physical write total multi block 2,904 9.0 0.7 physical writes 2,665 8.2 0.7 physical writes direct 0 0.0 0.0 physical writes direct (lob) 0 0.0 0.0 physical writes from cache 2,665 8.2 0.7 physical writes non checkpoint 1,858 5.7 0.5 process last non-idle time 321 1.0 0.1 recursive calls 510,433 1,575.4 124.3 recursive cpu usage 19,079 58.9 4.6 redo blocks written 28,427 87.7 6.9 Instance Activity Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ redo buffer allocation retries 0 0.0 0.0 redo entries 40,521 125.1 9.9 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo size 13,540,632 41,792.1 3,296.2 redo synch time 12,605 38.9 3.1 redo synch writes 12,760 39.4 3.1 redo wastage 834,800 2,576.5 203.2 redo write time 8,942 27.6 2.2 redo writer latching time 0 0.0 0.0 redo writes 3,852 11.9 0.9 rollback changes - undo records a 28 0.1 0.0 rollbacks only - consistent read 184 0.6 0.0 rows fetched via callback 56,786 175.3 13.8 session connect time 0 0.0 0.0 session cursor cache hits 29,242 90.3 7.1 session logical reads 6,232,090 19,234.9 1,517.1 session pga memory 16,411,840 50,653.8 3,995.1 session pga memory max 19,412,128 59,914.0 4,725.4 session uga memory 25,795,228,680 79,614,903.3 6,279,267.0 session uga memory max 409,861,304 1,265,004.0 99,771.5 shared hash latch upgrades - no w 12,011 37.1 2.9 shared hash latch upgrades - wait 2 0.0 0.0 sorts (memory) 2,513,528 7,757.8 611.9 sorts (rows) 2,057,041 6,348.9 500.7 sql area evicted 0 0.0 0.0 sql area purged 0 0.0 0.0 switch current to new buffer 271 0.8 0.1 table fetch by rowid 2,062,148 6,364.7 502.0 table fetch continued row 1,970 6.1 0.5 table scan blocks gotten 1,783,694 5,505.2 434.2 table scan rows gotten 57,312,517 176,890.5 13,951.4 table scans (long tables) 2 0.0 0.0 table scans (short tables) 16,387 50.6 4.0 total number of times SMON posted 9 0.0 0.0 transaction rollbacks 10 0.0 0.0 undo change vector size 5,230,668 16,144.0 1,273.3 user I/O wait time 364 1.1 0.1 user calls 128,280 395.9 31.2 user commits 4,021 12.4 1.0 user rollbacks 87 0.3 0.0 workarea executions - optimal 1,692,714 5,224.4 412.1 write clones created in backgroun 0 0.0 0.0 write clones created in foregroun 6 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value --------------------------------- --------------- --------------- logons current 48 49 opened cursors current 2,101 2,222 session cursor cache count 61,887 69,980 workarea memory allocated 162 162 ------------------------------------------------------------- Instance Activity Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour --------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- OS Statistics DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name Statistic Total ------------------------- ---------------------- BUSY_TIME 52,661 IDLE_TIME 11,011 IOWAIT_TIME 1,849 SYS_TIME 10,730 USER_TIME 41,931 OS_CPU_WAIT_TIME 67,200 VM_IN_BYTES 98,304 PHYSICAL_MEMORY_BYTES 4,170,850,304 NUM_CPUS 2 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->ordered by IOs (Reads + Writes) desc Tablespace ------------------------------ Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ ICMLFQ32 2,344 7 7.2 16.2 2,683 8 34 2.4 SYSTEM 4,385 14 3.0 1.4 105 0 0 0.0 ICMLSNDX 1,411 4 7.6 2.0 1,549 5 56 8.4 SYSAUX 931 3 4.9 2.2 497 2 0 0.0 UNDOTBS1 44 0 0.2 1.0 575 2 64 6.6 ICMSFQ04 263 1 6.3 2.6 229 1 7 0.0 STATSPACK 249 1 11.7 3.3 122 0 0 0.0 ICMVFQ04 141 0 8.8 55.5 13 0 2 0.0 ICMLNF32 15 0 4.7 1.5 20 0 0 0.0 ICMLSTXT 10 0 5.0 1.0 4 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->Mx Rd Bkt: Max bucket time for single block read ->ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Mx Av Av Rd Rd Av Av Buffer BufWt Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Waits (ms) -------------- ------- ----- --- ------- ------------ -------- ---------- ------ ICMLFQ32 /oradata/svtlsdb/svtlsdb_ICMLFQ32_01.dbf 227 1 15.2 84.7 22 0 0 /oradata/svtlsdb/svtlsdb_ICMLFQ32_02.dbf 2,117 7 6.3 8 8.9 2,661 8 34 2.4 ICMLNF32 /oradata/svtlsdb/svtlsdb_ICMLNF32_01.dbf 15 0 4.7 1.5 20 0 0 ICMLSNDX /oradata/svtlsdb/svtlsdb_ICMLSNDX_01.dbf 922 3 7.6 ### 1.9 1,128 3 56 8.4 /oradata/svtlsdb/svtlsdb_ICMLSNDX_02.dbf 489 2 7.6 32 2.0 421 1 0 ICMLSTXT /oradata/svtlsdb/svtlsdb_ICMLSTXT_01.dbf 5 0 6.0 1.0 2 0 0 /oradata/svtlsdb/svtlsdb_ICMLSTXT_02.dbf 5 0 4.0 1.0 2 0 0 ICMSFQ04 /oradata/svtlsdb/svtlsdb_ICMSFQ04_01.dbf 98 0 3.9 2.6 24 0 0 /oradata/svtlsdb/svtlsdb_ICMSFQ04_02.dbf 165 1 7.7 8 2.7 205 1 7 0.0 ICMVFQ04 /oradata/svtlsdb/svtlsdb_ICMVFQ04_01.dbf 55 0 8.0 38.3 11 0 2 0.0 /oradata/svtlsdb/svtlsdb_ICMVFQ04_02.dbf 86 0 9.3 66.6 2 0 0 STATSPACK /oradata/svtlsdb/STATSPACK_01 5 0 2.0 1.0 2 0 0 /oradata/svtlsdb/statspack_tbs.dbf 244 1 11.9 ### 3.4 120 0 0 SYSAUX /oradata/svtlsdb/svtlsdb_SYSAUX_01.dbf 489 2 5.3 2.1 250 1 0 /oradata/svtlsdb/svtlsdb_SYSAUX_02.dbf 442 1 4.3 2.2 247 1 0 SYSTEM /oradata/svtlsdb/svtlsdb_SYSTEM_01.dbf 4,148 13 2.7 ### 1.3 96 0 0 /oradata/svtlsdb/svtlsdb_SYSTEM_02.dbf 237 1 7.2 ### 3.0 9 0 0 UNDOTBS1 /oradata/svtlsdb/svtlsdb_UNDOTBS1_01.dbf 44 0 0.2 1.0 575 2 64 6.6 ------------------------------------------------------------- File Read Histogram Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->Number of single block reads in each time range ->ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- 0 - 2 ms 2 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms ------------ ------------ ------------ ------------ ------------ ------------ ICMLFQ32 /oradata/svtlsdb/svtlsdb_ICMLFQ32_02.dbf 10 0 1 0 0 0 ICMLSNDX /oradata/svtlsdb/svtlsdb_ICMLSNDX_01.dbf 6 1 3 5 1 2 /oradata/svtlsdb/svtlsdb_ICMLSNDX_02.dbf 2 0 7 3 1 0 ICMSFQ04 /oradata/svtlsdb/svtlsdb_ICMSFQ04_02.dbf 1 0 1 0 0 0 STATSPACK /oradata/svtlsdb/statspack_tbs.dbf 16 13 77 46 20 7 SYSTEM /oradata/svtlsdb/svtlsdb_SYSTEM_01.dbf 32 6 24 24 8 4 /oradata/svtlsdb/svtlsdb_SYSTEM_02.dbf 21 5 39 16 3 4 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k -> Buffers: the number of buffers. Units of K, M, G are divided by 1000 Free Writ Buffer Pool Buffer Physical Physical Buffer Comp Busy P Buffers Hit% Gets Reads Writes Waits Wait Waits --- ------- ---- -------------- ------------ ----------- ------- ---- ---------- D 102K 100 6,257,659 1,063 2,665 0 0 17 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> B: Begin snapshot, E: End snapshot Targt Estd Log File Log Ckpt Log Ckpt MTTR MTTR Recovery Actual Target Size Timeout Interval (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks - ----- ----- ---------- --------- --------- ---------- --------- ------------ B 0 18 2107 33746 166858 1887390 166858 E 0 17 1442 26336 164789 1887390 164789 ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: SVTLSDB/svtlsdb End Snap: 12 -> Only rows with estimated physical reads >0 are displayed -> ordered by Pool, Block Size, Buffers For Estimate Est Phys Estimated Est Size for Size Buffers Read Phys Reads Est Phys % dbtime P Est (M) Factr (thousands) Factr (thousands) Read Time for Rds --- -------- ----- ------------ ------ -------------- ------------ -------- D 80 .1 10 5.8 339 1,095 21.8 D 160 .2 20 1.0 61 61 1.2 D 240 .3 30 1.0 59 54 1.1 D 320 .4 40 1.0 59 52 1.0 D 400 .5 49 1.0 58 51 1.0 D 480 .6 59 1.0 58 51 1.0 D 560 .7 69 1.0 58 51 1.0 D 640 .8 79 1.0 58 51 1.0 D 720 .9 89 1.0 58 51 1.0 D 800 1.0 99 1.0 58 51 1.0 D 832 1.0 103 1.0 58 51 1.0 D 880 1.1 109 1.0 58 51 1.0 D 960 1.2 119 1.0 58 51 1.0 D 1,040 1.3 129 1.0 58 51 1.0 D 1,120 1.3 139 1.0 58 51 1.0 D 1,200 1.4 148 1.0 58 51 1.0 D 1,280 1.5 158 1.0 58 51 1.0 D 1,360 1.6 168 1.0 58 51 1.0 D 1,440 1.7 178 1.0 58 51 1.0 D 1,520 1.8 188 1.0 58 51 1.0 D 1,600 1.9 198 1.0 58 51 1.0 ------------------------------------------------------------- Buffer wait Statistics DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by wait time desc, waits desc Class Waits ------------------------------------------------------------------ ----------- Total Wait Time (s) Avg Time (ms) ------------------- ------------- data block 12 0 18 undo block 2 0 60 undo header 3 0 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> B: Begin snap E: End snap (rows identified with B or E contain data which is absolute i.e. not diffed over the interval) -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory -> Auto PGA Target - actual workarea memory target -> W/A PGA Used - amount of memory used for all Workareas (manual + auto) -> %PGA W/A Mem - percentage of PGA memory allocated to workareas -> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt -> %Man W/A Mem - percentage of workarea memory under manual control PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ---------------- ------------------------- 100.0 3,619 0 %PGA %Auto %Man PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K) - --------- --------- ---------- ---------- ------ ------ ------ ---------- B 500 368 158.3 0.2 .1 100.0 .0 102,400 E 500 363 166.2 0.2 .1 100.0 .0 102,400 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- ------------- ------------ ------------ 2K 4K 1,683,353 1,683,353 0 0 64K 128K 6 6 0 0 128K 256K 3 3 0 0 512K 1024K 337 337 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: SVTLSDB/svtlsdb End Snap: 12 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd PGA Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overalloc Est (MB) Factr Processed Written to Disk Hit % Count ---------- ------- ---------------- ---------------- -------- ---------- 63 0.1 28,874.4 86.0 100.0 21 125 0.3 28,874.4 0.0 100.0 0 250 0.5 28,874.4 0.0 100.0 0 375 0.8 28,874.4 0.0 100.0 0 500 1.0 28,874.4 0.0 100.0 0 600 1.2 28,874.4 0.0 100.0 0 700 1.4 28,874.4 0.0 100.0 0 800 1.6 28,874.4 0.0 100.0 0 900 1.8 28,874.4 0.0 100.0 0 1,000 2.0 28,874.4 0.0 100.0 0 1,500 3.0 28,874.4 0.0 100.0 0 2,000 4.0 28,874.4 0.0 100.0 0 3,000 6.0 28,874.4 0.0 100.0 0 4,000 8.0 28,874.4 0.0 100.0 0 ------------------------------------------------------------- Process Memory Summary Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> B: Begin snap E: End snap -> All rows below contain absolute values (i.e. not diffed over the interval) -> Max Alloc is Maximum PGA Allocation size at snapshot time Hist Max Alloc is the Historical Max Allocation for still-connected processes -> Num Procs or Allocs: For Begin/End snapshot lines, it is the number of processes. For Category lines, it is the number of allocations -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Hist Num Avg Std Dev Max Max Procs Alloc Used Freeabl Alloc Alloc Alloc Alloc or Category (MB) (MB) (MB) (MB) (MB) (MB) (MB) Allocs -------- --------- --------- -------- -------- ------- ------- ------ ------ B -------- 158.1 92.4 31.9 3.3 3.2 23 24 48 Other 111.3 2.3 3.1 22 23 48 Freeable 31.8 .0 .9 .3 2 36 SQL 13.9 9.0 .3 .2 1 7 41 PL/SQL 1.5 .9 .0 .0 0 0 48 E -------- 166.2 96.4 35.4 3.4 3.3 23 24 49 Other 115.1 2.3 3.1 22 23 49 Freeable 35.4 .0 .9 .3 2 39 SQL 14.4 9.3 .3 .2 1 7 40 PL/SQL 1.5 .9 .0 .0 0 0 48 ------------------------------------------------------------- Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- B 6 LGWR -------- 22.9 10.4 1.0 22.9 23.9 Other 21.9 21.9 22.9 Freeable 1.0 .0 1.0 PL/SQL .0 .0 .0 .0 13 TNS V1-V3 --- 6.8 5.1 .3 6.8 6.8 Other 5.9 5.9 5.9 SQL .6 .4 .6 1.8 Freeable .3 .0 .3 PL/SQL .0 .0 .0 .0 25 ------------ 5.4 3.6 1.1 5.4 10.8 Other 3.5 3.5 3.5 Freeable 1.1 .0 1.1 SQL .7 .4 .7 6.6 PL/SQL .0 .0 .0 .0 35 ------------ 5.0 3.4 .9 5.0 9.3 Other 3.6 3.6 3.6 Freeable .9 .0 .9 SQL .5 .3 .5 6.2 PL/SQL .0 .0 .0 .0 32 ------------ 4.9 3.3 1.1 4.9 9.9 Other 3.3 3.3 3.3 Freeable 1.1 .0 1.1 SQL .5 .3 .5 6.4 PL/SQL .0 .0 .0 .0 30 ------------ 4.7 3.2 .8 4.7 10.6 Other 3.3 3.3 3.3 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- B 30 Freeable .8 .0 .8 SQL .5 .3 .5 6.5 PL/SQL .0 .0 .0 .0 27 ------------ 4.6 2.8 1.0 4.6 10.6 Other 2.9 2.9 3.0 Freeable 1.0 .0 1.0 SQL .6 .4 .6 6.6 PL/SQL .1 .0 .1 .1 36 ------------ 4.5 2.9 1.0 4.5 8.8 Other 3.1 3.1 3.1 Freeable 1.0 .0 1.0 SQL .4 .2 .4 6.1 PL/SQL .0 .0 .0 .0 29 ------------ 4.1 2.2 1.1 4.1 10.4 Other 2.6 2.6 2.8 Freeable 1.1 .0 1.1 SQL .5 .3 .5 6.5 PL/SQL .0 .0 .0 .0 37 ------------ 3.9 2.5 .9 3.9 8.5 Other 2.5 2.5 2.5 Freeable .9 .0 .9 SQL .4 .3 .4 6.2 PL/SQL .0 .0 .0 .0 39 ------------ 3.8 2.3 1.0 3.8 8.3 Other 2.4 2.4 2.4 Freeable 1.0 .0 1.0 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- B 39 SQL .3 .2 .3 6.0 PL/SQL .0 .0 .0 .0 45 ------------ 3.8 2.5 1.0 3.8 8.3 Other 2.3 2.3 2.3 Freeable 1.0 .0 1.0 SQL .4 .3 .4 6.1 PL/SQL .0 .0 .0 .0 17 ------------ 3.7 2.0 1.0 3.7 11.6 Other 2.2 2.2 3.7 Freeable 1.0 .0 1.0 SQL .4 .3 .4 6.8 PL/SQL .1 .0 .1 .1 46 ------------ 3.6 2.3 .8 3.6 7.5 Other 2.3 2.3 2.3 Freeable .8 .0 .8 SQL .4 .3 .4 5.9 PL/SQL .0 .0 .0 .0 41 ------------ 3.6 2.2 .9 3.6 8.1 Other 2.3 2.3 2.3 Freeable .9 .0 .9 SQL .3 .2 .3 6.0 PL/SQL .0 .0 .0 .0 43 ------------ 3.6 2.3 .9 3.6 7.4 Other 2.2 2.2 2.2 Freeable .9 .0 .9 SQL .4 .3 .4 5.8 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- B 43 PL/SQL .0 .0 .0 .0 47 ------------ 3.6 2.3 .9 3.6 7.2 Other 2.2 2.2 2.2 Freeable .9 .0 .9 SQL .4 .3 .4 5.8 PL/SQL .0 .0 .0 .0 38 ------------ 3.4 1.9 1.1 3.4 8.5 Other 2.0 2.0 2.0 Freeable 1.1 .0 1.1 SQL .4 .2 .4 6.1 PL/SQL .0 .0 .0 .0 48 ------------ 3.4 2.3 .8 3.4 7.4 Other 2.1 2.1 2.1 Freeable .8 .0 .8 SQL .4 .3 .4 5.9 PL/SQL .0 .0 .0 .0 11 MMON -------- 3.3 1.8 1.2 3.3 3.4 Other 1.9 1.9 1.9 Freeable 1.2 .0 1.2 SQL .2 .1 .2 1.3 PL/SQL .0 .0 .0 .0 E 6 LGWR -------- 22.9 10.4 1.0 22.9 23.9 Other 21.9 21.9 22.9 Freeable 1.0 .0 1.0 PL/SQL .0 .0 .0 .0 13 TNS V1-V3 --- 8.2 6.0 1.2 8.2 12.7 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- E 13 Other 6.3 6.3 7.3 Freeable 1.2 .0 1.2 SQL .7 .4 .7 4.2 PL/SQL .0 .0 .0 .0 30 ------------ 5.7 3.8 1.1 5.7 10.6 Other 3.9 3.9 3.9 Freeable 1.1 .0 1.1 SQL .6 .4 .6 6.5 PL/SQL .0 .0 .0 .0 35 ------------ 5.1 3.4 1.0 5.1 9.3 Other 3.6 3.6 3.6 Freeable 1.0 .0 1.0 SQL .5 .3 .5 6.2 PL/SQL .0 .0 .0 .0 32 ------------ 5.1 3.6 .9 5.1 9.9 Other 3.6 3.6 3.6 Freeable .9 .0 .9 SQL .6 .4 .6 6.4 PL/SQL .0 .0 .0 .0 17 ------------ 4.9 3.2 1.0 4.9 11.6 Other 3.2 3.2 3.7 Freeable 1.0 .0 1.0 SQL .6 .4 .6 6.8 PL/SQL .1 .0 .1 .1 27 ------------ 4.9 3.1 1.1 4.9 10.6 Other 3.1 3.1 3.1 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- E 27 Freeable 1.1 .0 1.1 SQL .6 .4 .6 6.6 PL/SQL .1 .0 .1 .1 29 ------------ 4.7 3.2 .8 4.7 10.4 Other 3.2 3.2 3.2 Freeable .8 .0 .8 SQL .6 .4 .6 6.5 PL/SQL .0 .0 .0 .0 36 ------------ 4.6 3.0 1.1 4.6 8.8 Other 3.0 3.0 3.0 Freeable 1.1 .0 1.1 SQL .4 .3 .4 6.1 PL/SQL .0 .0 .0 .0 25 ------------ 4.5 2.8 1.0 4.5 10.8 Other 2.9 2.9 3.2 Freeable 1.0 .0 1.0 SQL .6 .4 .6 6.6 PL/SQL .0 .0 .0 .0 45 ------------ 3.8 2.5 .8 3.8 8.3 Other 2.5 2.5 2.5 Freeable .8 .0 .8 SQL .4 .3 .4 6.1 PL/SQL .0 .0 .0 .0 39 ------------ 3.8 2.3 1.0 3.8 8.3 Other 2.3 2.3 2.3 Freeable 1.0 .0 1.0 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- E 39 SQL .4 .2 .4 6.0 PL/SQL .0 .0 .0 .0 46 ------------ 3.7 2.3 .9 3.7 7.5 Other 2.4 2.4 2.4 Freeable .9 .0 .9 SQL .4 .3 .4 5.9 PL/SQL .0 .0 .0 .0 47 ------------ 3.7 2.4 .9 3.7 7.2 Other 2.3 2.3 2.3 Freeable .9 .0 .9 SQL .4 .3 .4 5.8 PL/SQL .0 .0 .0 .0 43 ------------ 3.6 2.3 .8 3.6 7.4 Other 2.4 2.4 2.4 Freeable .8 .0 .8 SQL .4 .3 .4 5.8 PL/SQL .0 .0 .0 .0 31 ------------ 3.6 2.1 .9 3.6 9.6 Other 2.2 2.2 2.3 Freeable .9 .0 .9 SQL .4 .2 .4 6.3 PL/SQL .0 .0 .0 .0 41 ------------ 3.5 2.2 1.0 3.5 8.1 Other 2.2 2.2 2.2 Freeable 1.0 .0 1.0 SQL .3 .2 .3 6.0 Top Process Memory (by component) DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by Begin/End snapshot, Alloc (MB) desc -------------------------------------------------------------------------------- Alloc Used Freeabl Max Hist Max PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB) ------ ------------- ------- ------- -------- ---------- ---------- E 41 PL/SQL .0 .0 .0 .0 20 ------------ 3.5 1.7 1.1 3.5 8.7 Other 2.0 2.0 2.0 Freeable 1.1 .0 1.1 SQL .4 .2 .4 6.2 PL/SQL .0 .0 .0 .0 48 ------------ 3.4 2.3 .8 3.4 7.4 Other 2.2 2.2 2.2 Freeable .8 .0 .8 SQL .4 .3 .4 5.9 PL/SQL .0 .0 .0 .0 38 ------------ 3.4 1.8 1.1 3.4 8.5 Other 2.0 2.0 2.0 Freeable 1.1 .0 1.1 SQL .3 .2 .3 6.1 PL/SQL .0 .0 .0 .0 ------------------------------------------------------------- Enqueue activity DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- TX-Transaction (index contention) 8 8 0 8 0 25.63 TX-Transaction (row lock contention) 2 2 0 2 0 8.00 ------------------------------------------------------------- Latch Activity DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests ->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests ->"Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ASM db client latch 210 0.0 0 0 Consistent RBA 3,844 0.0 0 0 FOB s.o list latch 59 0.0 0 0 JS queue state obj latch 1,920 0.0 0 0 JS slv state obj latch 16 0.0 0 0 KMG MMAN ready and start 106 0.0 0 0 KTF sga latch 1 0.0 0 107 0.0 KWQP Prop Status 1 0.0 0 0 MQL Tracking Latch 0 0 6 0.0 Memory Management Latch 0 0 106 0.0 OS process 2,025 0.0 0 0 OS process allocation 1,457 0.0 0 0 OS process: request allo 1,327 0.0 0 0 PL/SQL warning settings 685 0.0 0 0 SQL memory manager latch 1 0.0 0 105 0.0 SQL memory manager worka 35,581 0.0 0 0 Shared B-Tree 15 0.0 0 0 active checkpoint queue 1,278 0.0 0 0 active service list 4,614 0.0 0 160 0.0 cache buffer handles 288 0.0 0 0 cache buffers chains 12,499,169 0.0 0.0 0 36,657 0.0 cache buffers lru chain 94,312 0.1 0.0 0 64,919 0.1 channel handle pool latc 1,343 0.0 0 0 channel operations paren 3,581 0.0 0.0 0 0 checkpoint queue latch 8,665 0.0 0 1,799 0.0 client/application info 3,470 0.0 0 0 compile environment latc 15,562 0.0 0 0 dml lock allocation 24,837 0.0 0.0 0 0 dummy allocation 1,354 0.0 0 0 enqueue hash chains 44,635 0.0 0.0 0 13 0.0 enqueues 26,674 0.0 0.0 0 0 event group latch 664 0.0 0 0 file cache latch 9 0.0 0 0 fixed table rows for x$h 1,327 0.0 0 0 global KZLD latch for me 668 0.0 0 0 hash table column usage 0 0 11,495 0.0 hash table modification 24 0.0 0 0 job workq parent latch 0 0 12 0.0 job_queue_processes para 12 0.0 0 0 kks stats 246 0.0 0 0 ksuosstats global area 23 0.0 0 0 ktm global data 9 0.0 0 0 kwqbsn:qsga 15 0.0 0 0 lgwr LWN SCN 3,846 0.0 0 0 library cache 176,375 0.0 0.0 0 0 library cache load lock 682 0.0 0 0 library cache lock 70,552 0.0 0 0 library cache lock alloc 6,075 0.0 0 0 library cache pin 67,708 0.0 0.0 0 0 library cache pin alloca 97 0.0 0 0 Latch Activity DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests ->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests ->"Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ list of block allocation 1,385 0.0 0 0 message pool operations 22 0.0 0 0 messages 16,838 0.0 0 0 mostly latch-free SCN 3,848 0.0 0.0 0 0 multiblock read objects 122 0.0 0 0 ncodef allocation latch 8 0.0 0 0 object queue header heap 1,337 0.0 0 12 0.0 object queue header oper 97,144 0.0 0.0 0 0 object stats modificatio 48 0.0 0 0 parallel query alloc buf 40 0.0 0 0 parameter table allocati 677 0.0 0 0 post/wait queue 16,758 0.4 0.0 0 4,085 0.0 process allocation 1,327 0.0 0 664 0.0 process group creation 1,327 0.0 0 0 qmn task queue latch 48 0.0 0 0 redo allocation 48,177 0.0 0.0 0 0 redo copy 0 0 40,491 0.0 redo writing 13,031 0.0 0.0 0 0 resmgr group change latc 694 0.0 0 0 resmgr:actses active lis 1,355 0.0 0 0 resmgr:actses change gro 670 0.0 0 0 resmgr:free threads list 1,354 0.0 0 0 resmgr:schema config 1 0.0 0 0 row cache objects 166,464 0.0 0.0 0 0 rules engine rule set st 100 0.0 0 0 sequence cache 2,001 0.0 0 0 session allocation 80,544 0.0 0.0 0 0 session idle bit 271,094 0.0 0.0 0 0 session state list latch 24 0.0 0 0 session switching 8 0.0 0 0 session timer 160 0.0 0 0 shared pool 33,980 0.0 0.0 0 0 shared pool sim alloc 15 0.0 0 0 shared pool simulator 1,793 0.0 0 0 simulator hash latch 407,285 0.0 0 0 simulator lru latch 394,886 0.2 0.0 0 2,905 0.0 sort extent pool 168 0.0 0 0 temp lob duration state 16 0.0 0 0 threshold alerts latch 7 0.0 0 0 transaction allocation 1,362 0.0 0 0 transaction branch alloc 8 0.0 0 0 undo global data 15,375 0.0 0 0 user lock 2,666 0.0 0 0 ------------------------------------------------------------- Latch Sleep breakdown DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> ordered by misses desc Get Spin Latch Name Requests Misses Sleeps Gets -------------------------- --------------- ------------ ----------- ----------- cache buffers chains 12,499,169 755 2 753 post/wait queue 16,758 59 1 58 session idle bit 271,094 38 1 37 ------------------------------------------------------------- Latch Miss Sources DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- cache buffers chains kcbgtcr: fast path 0 2 1 cache buffers chains kcbchg: kslbegin: bufs not 0 1 0 cache buffers chains kcbnew: new latch again 0 1 0 channel operations paren ksrsconsume() 0 1 0 post/wait queue kslpstevent:get 0 1 0 session idle bit ksupuc: clear busy 0 1 1 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->"Pct Misses" should be very low (< 2% in most cases) ->"Final Usage" is the number of cache entries being used in End Snapshot Get Pct Scan Pct Mod Final Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_awr_control 6 0.0 0 0 1 dc_histogram_data 229 83.0 0 0 434 dc_histogram_defs 2,551 25.4 0 0 3,961 dc_object_ids 5,053 0.9 0 0 1,001 dc_objects 1,340 9.6 0 0 994 dc_profiles 673 0.0 0 0 1 dc_rollback_segments 33 0.0 0 0 18 dc_segments 1,018 4.2 0 0 898 dc_tablespace_quotas 4 0.0 0 4 3 dc_tablespaces 16,061 0.0 0 0 11 dc_usernames 4,813 0.0 0 0 18 dc_users 28,059 0.0 0 0 13 ------------------------------------------------------------- Library Cache Activity DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 ->"Pct Misses" should be very low Get Pct Pin Namespace Requests Miss Requests --------------------------------------------- ------------ ------ -------------- Pct Invali- Miss Reloads dations ------ ---------- -------- BODY 60 0.0 10,113 0.0 0 0 SQL AREA 6,078 0.6 47,168 1.0 0 0 TABLE/PROCEDURE 495 20.8 23,212 2.0 1 0 ------------------------------------------------------------- Rule Sets DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> * indicates Rule Set activity (re)started between Begin/End snaps -> Top 25 ordered by Evaluations desc Rule ----------------------------------- * -------------------------------------------------------------------------------- No-SQL SQL Eval/sec Reloads/sec Eval % Eval % ------------ ----------- ------ ------ SYS.ALERT_QUE_R 0 0 0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: SVTLSDB/svtlsdb End Snap: 12 -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor -> Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid Est LC Est LC Est LC Est LC Shared SP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Size (M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 96 .3 38 2,845 17,778 1.0 137 1.1 325,044 128 .4 66 3,812 17,786 1.0 129 1.0 325,448 160 .5 97 5,689 17,786 1.0 129 1.0 325,536 192 .6 99 6,075 17,786 1.0 129 1.0 325,536 224 .7 99 6,075 17,786 1.0 129 1.0 325,536 256 .8 99 6,075 17,786 1.0 129 1.0 325,536 288 .9 99 6,075 17,786 1.0 129 1.0 325,536 320 1.0 99 6,075 17,786 1.0 129 1.0 325,536 352 1.1 99 6,075 17,786 1.0 129 1.0 325,536 384 1.2 99 6,075 17,786 1.0 129 1.0 325,536 416 1.3 99 6,075 17,786 1.0 129 1.0 325,536 448 1.4 99 6,075 17,786 1.0 129 1.0 325,536 480 1.5 99 6,075 17,786 1.0 129 1.0 325,536 512 1.6 99 6,075 17,786 1.0 129 1.0 325,536 544 1.7 99 6,075 17,786 1.0 129 1.0 325,536 576 1.8 99 6,075 17,786 1.0 129 1.0 325,536 608 1.9 99 6,075 17,786 1.0 129 1.0 325,536 640 2.0 99 6,075 17,786 1.0 129 1.0 325,536 ------------------------------------------------------------- SGA Target Advisory DB/Inst: SVTLSDB/svtlsdb End Snap: 12 SGA Target SGA Size Est DB Est DB Est Physical Size (M) Factor Time (s) Time Factor Reads ---------- -------- -------- ----------- -------------- 300 .3 5,053 1.0 60,915 600 .5 5,035 1.0 58,418 900 .8 5,035 1.0 58,249 1,200 1.0 5,032 1.0 58,197 1,500 1.3 5,034 1.0 58,197 1,800 1.5 5,034 1.0 58,197 2,100 1.8 5,036 1.0 58,197 2,400 2.0 5,036 1.0 58,197 ------------------------------------------------------------- SGA Memory Summary DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ -------------------- -------------------- Database Buffers 872,415,232 Fixed Size 2,029,816 Redo Buffers 14,745,600 Variable Size 369,100,552 -------------------- -------------------- sum 1,258,291,200 ------------------------------------------------------------- SGA breakdown difference DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 -> Top 35 rows by size, ordered by Pool, Name (note rows with null values for Pool column, or Names showing free memory are always shown) -> Null value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot Pool Name Begin MB End MB % Diff ------ ------------------------------ -------------- -------------- -------- java p free memory 16.0 16.0 0.00 large PX msg pool .9 .9 0.00 large free memory 15.1 15.1 0.00 shared ASH buffers 4.0 4.0 0.00 shared CCursor 12.6 13.4 6.55 shared FileOpenBlock 7.1 7.1 0.00 shared KCB Table Scan Buffer 4.0 4.0 0.00 shared KGLS heap 7.3 7.8 6.87 shared KSFD SGA I/O b 4.0 4.0 0.00 shared PCursor 7.2 7.5 5.04 shared db_block_hash_buckets 5.6 5.6 0.00 shared free memory 142.0 133.8 -5.71 shared kglsim hash table bkts 4.0 4.0 0.00 shared library cache 8.8 9.1 2.75 shared row cache 7.2 7.2 0.00 shared sql area 67.6 72.7 7.55 buffer_cache 832.0 832.0 0.00 fixed_sga 1.9 1.9 0.00 log_buffer 14.1 14.1 0.00 ------------------------------------------------------------- SQL Memory Statistics DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 Begin End % Diff -------------- -------------- -------------- Avg Cursor Size (KB): 29.81 29.92 .36 Cursor to Parent ratio: 2.63 2.71 3.02 Total Cursors: 2,800 2,928 4.37 Total Parents: 1,065 1,080 1.39 ------------------------------------------------------------- init.ora Parameters DB/Inst: SVTLSDB/svtlsdb Snaps: 11-12 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- background_dump_dest /opt/oracle10g/admin/svtlsdb/bdum compatible 9.2.0.0.0 control_files /oradata/svtlsdb/svtlsdb_control_ core_dump_dest /opt/oracle10g/admin/svtlsdb/cdum cursor_sharing SIMILAR cursor_space_for_time TRUE db_block_size 8192 db_domain cn.ibm.com db_files 1024 db_name svtlsdb job_queue_processes 1 max_dump_file_size 10240 open_cursors 500 pga_aggregate_target 524288000 pre_page_sga TRUE processes 150 session_cached_cursors 500 sga_max_size 1258291200 sga_target 1258291200 spfile /oradata/svtlsdb/spfilesvtlsdb.or timed_statistics TRUE undo_management AUTO undo_tablespace UNDOTBS1 user_dump_dest /opt/oracle10g/admin/svtlsdb/udum ------------------------------------------------------------- End of Report ( test11-12.rep )