WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- 3496722888 2 01-Mar-12 11:04 11.1.0.7.0 YES Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- Linux x86 64-bit 24 12 2 23.41 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 3911 13-Mar-12 17:00:28 59 2.3 End Snap: 3912 13-Mar-12 18:00:10 76 2.1 Elapsed: 59.70 (mins) DB Time: 99.61 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 848M 880M Std Block Size: 8K Shared Pool Size: 640M 608M Log Buffer: 7,240K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ --------------- --------------- ---------- ---------- DB Time(s): 1.7 8.0 0.63 0.33 DB CPU(s): 1.3 6.2 0.49 0.25 Redo size: 623,022.9 3,003,527.9 Logical reads: 141,129.4 680,369.8 Block changes: 4,204.0 20,267.2 Physical reads: 969.8 4,675.4 Physical writes: 45.1 217.4 User calls: 5.1 24.6 Parses: 2.2 10.7 Hard parses: 0.0 0.2 W/A MB processed: 703,738.6 3,392,649.8 Logons: 0.7 3.2 Executes: 2.6 12.7 Rollbacks: 0.2 1.0 Transactions: 0.2 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 99.74 In-memory Sort %: 100.00 Library Hit %: 99.33 Soft Parse %: 98.08 Execute to Parse %: 16.12 Latch Hit %: 99.99 Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 99.96 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 89.21 92.15 % SQL with executions>1: 91.45 89.64 % Memory for SQL w/exec>1: 84.26 79.14 Top 5 Timed Foreground Events ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg wait % DB Event Waits Time(s) (ms) time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- DB CPU 4,577 76.6 db file parallel read 116,151 513 4 8.6 User I/O gc cr multi block request 132,610 376 3 6.3 Cluster db file sequential read 128,742 239 2 4.0 User I/O direct path read 17,412 202 12 3.4 User I/O Host CPU (CPUs: 24 Cores: 12 Sockets: 2) ~~~~~~~~ Load Average Begin End %User %System %WIO %Idle --------- --------- --------- --------- --------- --------- 0.55 1.72 5.4 0.2 1.1 94.3 Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: 5.4 % of busy CPU for Instance: 94.3 %DB time waiting for CPU - Resource Mgr: 0.0 Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End Host Mem (MB): 23,969.6 23,969.6 SGA use (MB): 1,536.0 1,536.0 PGA use (MB): 1,003.8 812.1 % Host Mem used for SGA+PGA: 10.60 10.60 RAC Statistics DB/Inst: / 2 Snaps: 3911-3912 Begin End ----- ----- Number of Instances: 2 2 Global Cache Load Profile ~~~~~~~~~~~~~~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Global Cache blocks received: 44.82 216.09 Global Cache blocks served: 3.51 16.91 GCS/GES messages received: 85.21 410.77 GCS/GES messages sent: 132.42 638.38 DBWR Fusion writes: 0.05 0.24 Estd Interconnect traffic (KB) 429.15 Global Cache Efficiency Percentages (Target local+remote 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer access - local cache %: 99.71 Buffer access - remote cache %: 0.03 Buffer access - disk %: 0.26 Global Cache and Enqueue Services - Workload Characteristics ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg global enqueue get time (ms): 0.3 Avg global cache cr block receive time (ms): 1.7 Avg global cache current block receive time (ms): 1.9 Avg global cache cr block build time (ms): 0.0 Avg global cache cr block send time (ms): 0.0 Global cache log flushes for cr blocks served %: 7.6 Avg global cache cr block flush time (ms): 26.8 Avg global cache current block pin time (ms): 0.1 Avg global cache current block send time (ms): 0.1 Global cache log flushes for current blocks served %: 0.1 Avg global cache current block flush time (ms): 5.7 Global Cache and Enqueue Services - Messaging Statistics ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg message sent queue time (ms): 1462.2 Avg message sent queue time on ksxp (ms): 1.4 Avg message received queue time (ms): 0.0 Avg GCS message process time (ms): 0.0 Avg GES message process time (ms): 0.0 % of direct sent messages: 46.73 % of indirect sent messages: 52.85 % of flow controlled messages: 0.42 ------------------------------------------------------------- Cluster Interconnect ~~~~~~~~~~~~~~~~~~~~ Begin End -------------------------------------------------- ----------- Interface IP Address Pub Source IP Pub Src ---------- --------------- --- ------------------------------ --- --- --- bond0 192.168.234.3 N Oracle Cluster Repository Time Model Statistics DB/Inst: / 2 Snaps: 3911-3912 -> Total time in database user-calls (DB Time): 5976.7s -> Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic -> Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time ------------------------------------------ ------------------ ------------ sql execute elapsed time 5,924.1 99.1 DB CPU 4,576.6 76.6 parse time elapsed 5.5 .1 connection management call elapsed time 5.3 .1 hard parse elapsed time 5.1 .1 hard parse (sharing criteria) elapsed time 3.5 .1 hard parse (bind mismatch) elapsed time 0.9 .0 PL/SQL execution elapsed time 0.5 .0 sequence load elapsed time 0.4 .0 PL/SQL compilation elapsed time 0.1 .0 failed parse elapsed time 0.0 .0 repeated bind elapsed time 0.0 .0 DB time 5,976.7 background elapsed time 168.0 background cpu time 34.1 ------------------------------------------------------------- Operating System Statistics DB/Inst: / 2 Snaps: 3911-3912 -> *TIME statistic values are diffed. All others display actual values. End Value is displayed if different -> ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name Statistic Value End Value ------------------------- ---------------------- ---------------- BUSY_TIME 489,123 IDLE_TIME 8,110,649 IOWAIT_TIME 97,540 NICE_TIME 129 SYS_TIME 19,518 USER_TIME 465,472 LOAD 1 2 RSRC_MGR_CPU_WAIT_TIME 0 PHYSICAL_MEMORY_BYTES 25,133,981,696 NUM_CPUS 24 NUM_CPU_CORES 12 NUM_CPU_SOCKETS 2 GLOBAL_RECEIVE_SIZE_MAX 4,194,304 GLOBAL_SEND_SIZE_MAX 262,144 TCP_RECEIVE_SIZE_DEFAULT 87,380 TCP_RECEIVE_SIZE_MAX 4,194,304 TCP_RECEIVE_SIZE_MIN 4,096 TCP_SEND_SIZE_DEFAULT 16,384 TCP_SEND_SIZE_MAX 4,194,304 TCP_SEND_SIZE_MIN 4,096 ------------------------------------------------------------- Operating System Statistics - Detail DB/Inst: / 2 Snaps: 3911-3912 Snap Time Load %busy %user %sys %idle %iowait --------------- -------- -------- -------- -------- -------- -------- 13-Mar 17:00:28 0.5 N/A N/A N/A N/A N/A 13-Mar 18:00:10 1.7 5.7 5.4 0.2 1.1 94.3 ------------------------------------------------------------- Foreground Wait Class DB/Inst: / 2 Snaps: 3911-3912 -> s - second, ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Captured Time accounts for 100.2% of Total DB time 5,976.68 (s) -> Total FG Wait Time: 1,410.16 (s) DB CPU time: 4,576.64 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- DB CPU 4,577 76.6 User I/O 269,939 0 990 4 16.6 Cluster 200,817 0 396 2 6.6 Other 99,832 87 12 0 0.2 System I/O 2,574 0 4 2 0.1 Concurrency 2,573 1 3 1 0.1 Application 916 0 2 2 0.0 Configuration 233 0 2 8 0.0 Commit 98 0 1 9 0.0 Network 5,896 0 0 0 0.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: / 2 Snaps: 3911-3912 -> s - second, ms - millisecond - 1000th of a second -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by wait time desc, waits desc (idle events last) -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % DB Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ db file parallel read 116,151 0 513 4 156.3 8.6 gc cr multi block request 132,610 0 376 3 178.5 6.3 db file sequential read 128,742 0 239 2 173.3 4.0 direct path read 17,412 0 202 12 23.4 3.4 db file scattered read 7,630 0 35 5 10.3 .6 gc current grant 2-way 56,431 1 9 0 76.0 .1 DFS lock handle 381 15 5 12 0.5 .1 control file sequential re 2,574 0 4 2 3.5 .1 gc buffer busy acquire 13 15 4 297 0.0 .1 gc current block 2-way 9,220 2 3 0 12.4 .1 reliable message 2,939 0 2 1 4.0 .0 SQL*Net break/reset to cli 794 0 2 2 1.1 .0 gc current block lost 3 0 2 645 0.0 .0 os thread startup 16 0 2 115 0.0 .0 log file switch completion 47 0 2 36 0.1 .0 IPC send completion sync 10,782 91 2 0 14.5 .0 gc buffer busy release 4 25 1 257 0.0 .0 log file sync 98 0 1 9 0.1 .0 PX Nsq: PQ load info query 4 100 1 201 0.0 .0 enq: PS - contention 2,176 0 1 0 2.9 .0 PX Deq: reap credit 72,064 100 1 0 97.0 .0 buffer busy waits 18 0 1 40 0.0 .0 PX Deq: Slave Session Stat 5,658 26 0 0 7.6 .0 library cache pin 1,504 0 0 0 2.0 .0 read by other session 4 0 0 82 0.0 .0 gc cr grant 2-way 1,275 0 0 0 1.7 .0 enq: KO - fast object chec 122 0 0 2 0.2 .0 library cache lock 872 0 0 0 1.2 .0 PX Deq Credit: Session Sta 1,634 0 0 0 2.2 .0 name-service call wait 2 0 0 60 0.0 .0 gc cr block 2-way 328 0 0 0 0.4 .0 PX Deq: Signal ACK RSG 1,552 50 0 0 2.1 .0 gc current multi block req 506 0 0 0 0.7 .0 gc current grant busy 407 0 0 0 0.5 .0 gc current block busy 11 18 0 9 0.0 .0 enq: HW - contention 186 0 0 0 0.3 .0 row cache lock 137 0 0 0 0.2 .0 enq: JS - job run lock - s 57 100 0 0 0.1 .0 gc cr block busy 9 0 0 3 0.0 .0 SQL*Net message to client 5,652 0 0 0 7.6 .0 ges inquiry response 42 0 0 0 0.1 .0 PX Deq: Signal ACK EXT 91 0 0 0 0.1 .0 rdbms ipc reply 40 0 0 0 0.1 .0 cr request retry 348 100 0 0 0.5 .0 KJC: Wait for msg sends to 104 0 0 0 0.1 .0 PX qref latch 1,941 100 0 0 2.6 .0 SQL*Net more data to clien 134 0 0 0 0.2 .0 SQL*Net more data from cli 110 0 0 0 0.1 .0 library cache: mutex X 17 100 0 0 0.0 .0 SQL*Net message from clien 5,651 0 46,498 8228 7.6 PX Deq Credit: send blkd 34,265 8 28,288 826 46.1 Streams AQ: waiting for me 1,177 91 3,941 3348 1.6 jobq slave wait 570 100 1,711 3001 0.8 PX Deq: Execution Msg 10,992 25 641 58 14.8 PX Deq Credit: need buffer 386 1 314 814 0.5 PX Deq: Execute Reply 3,316 29 4 1 4.5 PX Deq: Parse Reply 2,255 36 1 1 3.0 PX Deq: Join ACK 1,330 0 1 0 1.8 PX Deq: Msg Fragment 4,975 34 0 0 6.7 ------------------------------------------------------------- Background Wait Events DB/Inst: / 2 Snaps: 3911-3912 -> ordered by wait time desc, waits desc (idle events last) -> Only events with Total Wait Time (s) >= .001 are shown -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % bg Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ log file parallel write 2,910 0 47 16 3.9 28.1 control file sequential re 17,166 0 33 2 23.1 19.6 db file parallel write 3,205 0 22 7 4.3 13.1 db file sequential read 952 0 7 8 1.3 4.4 control file parallel writ 2,411 0 6 2 3.2 3.6 gcs log flush sync 433 20 5 12 0.6 3.1 gc cr multi block request 2,510 0 5 2 3.4 2.9 library cache pin 16,721 0 4 0 22.5 2.2 ASM file metadata operatio 739 0 2 2 1.0 1.1 name-service call wait 16 0 2 104 0.0 1.0 enq: CF - contention 1,189 4 1 1 1.6 .6 os thread startup 70 0 1 14 0.1 .6 enq: WF - contention 13 0 1 43 0.0 .3 ges inquiry response 1,381 0 1 0 1.9 .3 PX Deq: Slave Join Frag 3,141 40 0 0 4.2 .3 enq: CO - master slave det 1,194 100 0 0 1.6 .3 direct path read 404 0 0 1 0.5 .2 CGS wait for IPC msg 34,706 100 0 0 46.7 .2 gc current block 2-way 970 0 0 0 1.3 .2 log file sequential read 48 0 0 6 0.1 .2 reliable message 43 0 0 6 0.1 .1 DFS lock handle 838 71 0 0 1.1 .1 db file scattered read 4 0 0 33 0.0 .1 db file parallel read 2 0 0 59 0.0 .1 ksxr poll remote instances 10,553 100 0 0 14.2 .1 gc current grant 2-way 394 0 0 0 0.5 .1 PX Deq: reap credit 10,575 100 0 0 14.2 .1 gc cr block 2-way 250 0 0 0 0.3 .0 ges lmd/lmses to freeze in 41 0 0 1 0.1 .0 row cache lock 149 0 0 0 0.2 .0 library cache lock 147 39 0 0 0.2 .0 log file single write 48 0 0 1 0.1 .0 kjbdrmcvtq lmon drm quiesc 8 0 0 5 0.0 .0 gc cr grant 2-way 175 0 0 0 0.2 .0 enq: HW - contention 131 0 0 0 0.2 .0 direct path write 191 0 0 0 0.3 .0 enq: KO - fast object chec 110 0 0 0 0.1 .0 gc cr block busy 5 0 0 5 0.0 .0 rdbms ipc reply 139 0 0 0 0.2 .0 gc current grant busy 68 0 0 0 0.1 .0 LGWR wait for redo copy 251 0 0 0 0.3 .0 gc object scan 2,062 100 0 0 2.8 .0 gc current block busy 3 0 0 2 0.0 .0 PX Deq: Slave Session Stat 58 36 0 0 0.1 .0 log file sync 2 0 0 3 0.0 .0 IPC send completion sync 39 72 0 0 0.1 .0 enq: PS - contention 12 0 0 0 0.0 .0 SQL*Net more data to clien 170 0 0 0 0.2 .0 SQL*Net message to client 674 0 0 0 0.9 .0 gc current multi block req 8 0 0 0 0.0 .0 enq: TM - contention 6 100 0 0 0.0 .0 KJC: Wait for msg sends to 166 0 0 0 0.2 .0 PX Deq: Signal ACK RSG 20 50 0 0 0.0 .0 SQL*Net more data from cli 170 0 0 0 0.2 .0 enq: FB - contention 4 0 0 0 0.0 .0 rdbms ipc message 76,403 74 71,555 937 102.8 DIAG idle wait 113,293 95 7,158 63 152.5 gcs remote message 192,374 86 7,155 37 258.9 PX Idle Wait 4,215 53 7,118 1689 5.7 fbar timer 12 100 3,600 300006 0.0 Background Wait Events DB/Inst: / 2 Snaps: 3911-3912 -> ordered by wait time desc, waits desc (idle events last) -> Only events with Total Wait Time (s) >= .001 are shown -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % bg Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ smon timer 15 47 3,597 239794 0.0 Streams AQ: qmn slave idle 125 0 3,594 28750 0.2 Streams AQ: qmn coordinato 250 50 3,594 14375 0.3 PING 1,438 19 3,587 2494 1.9 wait for unread message on 3,579 100 3,583 1001 4.8 Space Manager: slave idle 724 98 3,582 4947 1.0 pmon timer 1,330 90 3,582 2693 1.8 ges remote message 120,419 27 3,579 30 162.1 ASM background timer 729 0 3,575 4905 1.0 JOX Jit Process Sleep 238 100 3,571 15004 0.3 class slave wait 16 13 600 37503 0.0 SQL*Net message from clien 674 0 12 17 0.9 KSV master wait 2,173 100 0 0 2.9 PX Deq Credit: send blkd 45 49 0 0 0.1 PX Deq: Join ACK 15 0 0 1 0.0 PX Deq: Parse Reply 26 42 0 0 0.0 Streams AQ: RAC qmn coordi 257 100 0 0 0.3 PX Deq: Execute Reply 16 31 0 0 0.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: / 2 Snaps: 3911-3912 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> % of Waits: value of .0 indicates value was <.05%. Value of null is truly 0 -> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms -> Ordered by Event (idle events last) % of Waits ----------------------------------------------- Total Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ASM file metadata operatio 738 83.6 .1 13.7 2.4 .1 CGS wait for IPC msg 34K 100.0 DFS lock handle 1217 96.5 .7 .1 .2 2.5 IPC send completion sync 10K 99.9 .0 .0 KJC: Wait for msg sends to 271 100.0 LGWR wait for redo copy 251 100.0 PX Deq Credit: Session Sta 1641 99.6 .4 PX Deq: Signal ACK EXT 96 100.0 PX Deq: Signal ACK RSG 1584 99.7 .1 .1 .1 .1 PX Deq: Slave Join Frag 3149 99.9 .1 .0 PX Deq: Slave Session Stat 5754 99.9 .1 PX Deq: reap credit 82K 100.0 PX Nsq: PQ load info query 4 100.0 PX qref latch 1941 100.0 SQL*Net break/reset to cli 794 95.0 1.6 2.4 .1 .9 SQL*Net message to client 6335 100.0 SQL*Net more data from cli 280 100.0 SQL*Net more data to clien 306 100.0 buffer busy waits 18 16.7 11.1 5.6 22.2 44.4 control file parallel writ 2408 52.0 24.8 11.5 5.4 4.2 1.9 .2 control file sequential re 19K 67.1 15.1 8.4 4.7 3.2 1.2 .3 cr request retry 352 100.0 db file parallel read 115K 43.0 23.4 12.6 7.3 8.3 3.3 2.0 .0 db file parallel write 3207 8.7 19.8 35.1 18.5 10.7 4.7 2.5 db file scattered read 7623 56.2 17.6 9.6 5.1 5.0 2.7 3.8 db file sequential read 129K 70.1 12.9 6.7 4.8 4.0 1.1 .4 direct path read 17K 75.3 .6 1.5 3.7 4.0 4.9 10.0 .0 direct path write 191 94.8 1.0 3.1 1.0 enq: CF - contention 1189 98.4 .3 .3 .2 .1 .3 .5 enq: CO - master slave det 1194 99.9 .1 enq: FB - contention 2 100.0 enq: HW - contention 311 100.0 enq: JS - job run lock - s 57 100.0 enq: KO - fast object chec 232 94.8 .4 .4 .9 1.3 1.7 .4 enq: PS - contention 2195 99.8 .0 .0 .1 enq: TM - contention 6 100.0 enq: WF - contention 13 92.3 7.7 gc buffer busy acquire 13 23.1 15.4 61.5 gc buffer busy release 4 25.0 25.0 25.0 25.0 gc cr block 2-way 561 100.0 gc cr block busy 12 16.7 33.3 25.0 16.7 8.3 gc cr grant 2-way 1330 100.0 gc cr multi block request 135K 99.7 .0 .0 .0 .0 .2 .1 gc current block 2-way 9807 99.9 .0 .0 .0 .0 .0 gc current block busy 12 8.3 33.3 33.3 8.3 8.3 8.3 gc current block lost 2 50.0 50.0 gc current grant 2-way 35K 100.0 .0 .0 gc current grant busy 462 99.8 .2 gc current multi block req 509 100.0 gc object scan 2062 100.0 gcs log flush sync 449 32.7 10.2 13.8 11.4 6.7 7.3 17.8 ges inquiry response 1423 99.7 .1 .2 ges lmd/lmses to freeze in 41 61.0 19.5 19.5 kjbdrmcvtq lmon drm quiesc 8 100.0 ksxr poll remote instances 10K 100.0 latch free 3 100.0 latch: cache buffers chain 8 100.0 latch: cache buffers lru c 3 100.0 latch: gc element 1 100.0 latch: gcs resource hash 5 100.0 Wait Event Histogram DB/Inst: / 2 Snaps: 3911-3912 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> % of Waits: value of .0 indicates value was <.05%. Value of null is truly 0 -> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms -> Ordered by Event (idle events last) % of Waits ----------------------------------------------- Total Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- latch: ges resource hash l 11 100.0 latch: object queue header 8 100.0 latch: session allocation 4 100.0 latch: shared pool 2 100.0 library cache lock 1010 100.0 library cache pin 18K 100.0 .0 .0 .0 library cache: mutex X 17 94.1 5.9 lock deadlock retry 2 100.0 log file parallel write 2919 9.4 6.2 11.6 33.1 23.1 9.0 7.6 .0 log file sequential read 48 50.0 4.2 14.6 27.1 4.2 log file single write 48 81.3 10.4 6.3 2.1 log file switch completion 47 27.7 2.1 2.1 19.1 6.4 42.6 log file sync 100 23.0 18.0 21.0 20.0 8.0 4.0 6.0 name-service call wait 18 5.6 94.4 os thread startup 86 81.4 18.6 rdbms ipc reply 179 100.0 read by other session 4 25.0 25.0 25.0 25.0 reliable message 3007 98.4 1.4 .0 .0 .0 .2 row cache lock 266 99.6 .4 ASM background timer 728 1.4 .1 .7 97.8 DIAG idle wait 113K 3.1 .1 .3 .5 .3 46.0 49.7 JOX Jit Process Sleep 238 100.0 KSV master wait 2173 99.9 .0 .0 PING 1438 80.1 19.9 PX Deq Credit: need buffer 386 4.4 .3 75.4 19.9 PX Deq Credit: send blkd 34K 17.3 .0 .0 .0 .0 38.0 44.6 PX Deq: Execute Reply 3352 86.6 3.6 4.3 2.0 1.9 .9 .7 PX Deq: Execution Msg 11K 87.6 4.4 2.0 1.2 .5 .1 .7 3.4 PX Deq: Join ACK 1355 99.0 1.0 PX Deq: Msg Fragment 4992 99.7 .2 .1 PX Deq: Parse Reply 2299 83.6 14.4 .6 1.0 .2 .1 .1 PX Idle Wait 4221 .3 .1 .1 .4 .2 35.8 63.2 SQL*Net message from clien 6334 46.9 7.9 7.3 8.8 .7 .1 14.5 13.8 Space Manager: slave idle 725 .3 .1 99.6 Streams AQ: RAC qmn coordi 257 100.0 Streams AQ: qmn coordinato 250 50.0 50.0 Streams AQ: qmn slave idle 125 100.0 Streams AQ: waiting for me 1177 .6 .1 38.3 61.0 class slave wait 16 75.0 6.3 6.3 12.5 fbar timer 12 100.0 gcs remote message 192K 5.8 1.1 1.2 1.6 2.2 5.1 83.0 ges remote message 120K 52.4 2.7 2.0 1.6 2.3 4.8 34.2 jobq slave wait 570 100.0 pmon timer 1331 10.2 89.8 rdbms ipc message 76K 13.6 .5 .6 .4 .4 .5 57.8 26.1 smon timer 14 7.1 7.1 85.7 wait for unread message on 3581 100.0 ------------------------------------------------------------- Service Statistics DB/Inst: / 2 Snaps: 3911-3912 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K) ---------------------------- ------------ ------------ ------------ ------------ _dr.dr.amer.dell.com 5,948 4,564 3,472 505,242 SYS$USERS 29 11 1 30 SYS$BACKGROUND 0 0 2 32 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: / 2 Snaps: 3911-3912 -> Wait Class info for services in the Service Statistics section. -> Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network -> Time Waited (Wt Time) in seconds Service Name ---------------------------------------------------------------- User I/O User I/O Concurcy Concurcy Admin Admin Network Network Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time --------- --------- --------- --------- --------- --------- --------- --------- _dr.dr.amer.dell.com 269900 989 966 3 0 0 2192 0 SYS$USERS 53 1 1606 0 0 0 3704 0 SYS$BACKGROUND 1536 8 17088 5 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> Total DB Time (s): 5,977 -> Captured SQL account for 98.3% of Total -> Total DB Time (s): 5,977 -> Captured PL/SQL account for 98.1% of Total Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- 2,522 2,441 1 2522.0 42.2 ank4sbr3urr3m Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select distinct fp_desc from e2ec_pro duct_hierarchy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C40000'; commit; end; 2,469 2,426 1 2468.8 41.3 dyhcfyss545j9 Module: TOAD 10.1.1.8 UPDATE E2EC_ITEM_PH B SET FP_DESC=(SELECT DISTINCT FP_DESC FROM E2EC_PRODUCT_HIE RARCHY A WHERE A.LOB_ID=B.LOB_ID AND A.FAMILY_ID=B.FMLY_ID) WHERE CCN = 'C40000' 1,399 315 3 466.5 23.4 bzb8b8xdrymd8 Module: ReportingServicesService.exe begin GET_MTM_REP_PKG.GET_MTM_REP(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_REPORT , P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SELASO FDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_SELBU , P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMILY=> 1,387 1,346 0 N/A 23.2 1udsybbfypf3m Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'DAO' 1,380 1,344 0 N/A 23.1 9tabfvfbahn1g Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'DAO'; commit; en d; 1,215 286 1 1215.0 20.3 768mqk94rkm8b Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 461 424 1 461.5 7.7 9fs63m4j0rdvb Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'E10000' 455 422 1 454.7 7.6 b2wasvcy9u7r3 Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'E10000'; commit; end; 117 26 1 116.8 2.0 856ghz6w65rbt Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_PART_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ( (INSTR(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 ,','||A. PART_NUM||',') <> 0) OR INSTR(:B2 , 'DEFAULT') > 0) AND RUN_DATE <= TO_DATE(:B1 107 3 6 17.8 1.8 7nmdpdtnps3tj Module: ReportingServicesService.exe SQL ordered by Elapsed Time DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> Total DB Time (s): 5,977 -> Captured SQL account for 98.3% of Total -> Total DB Time (s): 5,977 -> Captured PL/SQL account for 98.1% of Total Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- SELECT MAX(RUN_DATE) FROM E2EC_MAX_CYCLE_DATE WHERE RUN_DATE <= :B2 AND COST_TYP E = :B1 90 26 1 90.1 1.5 f18jk50vqxna2 Module: ReportingServicesService.exe begin GET_STS_REP_SUR_PKG.get_STS_rep(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_RE PORT, P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SE LASOFDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_S ELBU, P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMI ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total is the CPU Time divided into the Total CPU Time times 100 -> Total CPU Time (s): 4,577 -> Captured SQL account for 99.5% of Total -> Total CPU Time (s): 4,577 -> Captured PL/SQL account for 99.4% of Total CPU Elapsed CPU per % Total Time (s) Time (s) Executions Exec (s) % Total DB Time SQL Id ---------- ---------- ------------ ----------- ------- ------- ------------- 2,441 2,522 1 2440.54 53.3 42.2 ank4sbr3urr3m Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select distinct fp_desc from e2ec_pro duct_hierarchy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C40000'; commit; end; 2,426 2,469 1 2426.42 53.0 41.3 dyhcfyss545j9 Module: TOAD 10.1.1.8 UPDATE E2EC_ITEM_PH B SET FP_DESC=(SELECT DISTINCT FP_DESC FROM E2EC_PRODUCT_HIE RARCHY A WHERE A.LOB_ID=B.LOB_ID AND A.FAMILY_ID=B.FMLY_ID) WHERE CCN = 'C40000' 1,346 1,387 0 N/A 29.4 23.2 1udsybbfypf3m Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'DAO' 1,344 1,380 0 N/A 29.4 23.1 9tabfvfbahn1g Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'DAO'; commit; en d; 424 461 1 423.74 9.3 7.7 9fs63m4j0rdvb Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'E10000' 422 455 1 422.45 9.2 7.6 b2wasvcy9u7r3 Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'E10000'; commit; end; 315 1,399 3 104.91 6.9 23.4 bzb8b8xdrymd8 Module: ReportingServicesService.exe begin GET_MTM_REP_PKG.GET_MTM_REP(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_REPORT , P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SELASO FDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_SELBU , P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMILY=> 286 1,215 1 286.40 6.3 20.3 768mqk94rkm8b Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 26 117 1 26.08 0.6 2.0 856ghz6w65rbt Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_PART_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ( (INSTR(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 ,','||A. PART_NUM||',') <> 0) OR INSTR(:B2 , 'DEFAULT') > 0) AND RUN_DATE <= TO_DATE(:B1 26 90 1 25.56 0.6 1.5 f18jk50vqxna2 Module: ReportingServicesService.exe SQL ordered by CPU Time DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total is the CPU Time divided into the Total CPU Time times 100 -> Total CPU Time (s): 4,577 -> Captured SQL account for 99.5% of Total -> Total CPU Time (s): 4,577 -> Captured PL/SQL account for 99.4% of Total CPU Elapsed CPU per % Total Time (s) Time (s) Executions Exec (s) % Total DB Time SQL Id ---------- ---------- ------------ ----------- ------- ------- ------------- begin GET_STS_REP_SUR_PKG.get_STS_rep(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_RE PORT, P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SE LASOFDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_S ELBU, P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMI ------------------------------------------------------------- SQL ordered by Gets DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 505,514,786 -> Captured SQL account for 99.6% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 247,850,869 0 N/A 49.0 1346.36 1387.43 1udsybbfypf3m Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'DAO' 247,832,944 0 N/A 49.0 1344.07 1380.04 9tabfvfbahn1g Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'DAO'; commit; en d; 159,381,294 1 1.5938E+08 31.5 2440.54 2522.04 ank4sbr3urr3m Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select distinct fp_desc from e2ec_pro duct_hierarchy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C40000'; commit; end; 156,868,198 1 1.5687E+08 31.0 2426.42 2468.83 dyhcfyss545j9 Module: TOAD 10.1.1.8 UPDATE E2EC_ITEM_PH B SET FP_DESC=(SELECT DISTINCT FP_DESC FROM E2EC_PRODUCT_HIE RARCHY A WHERE A.LOB_ID=B.LOB_ID AND A.FAMILY_ID=B.FMLY_ID) WHERE CCN = 'C40000' 81,210,197 1 8.1210E+07 16.1 422.45 454.65 b2wasvcy9u7r3 Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'E10000'; commit; end; 81,210,190 1 8.1210E+07 16.1 423.74 461.47 9fs63m4j0rdvb Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'E10000' 15,734,921 3 5,244,973.7 3.1 314.72 1399.36 bzb8b8xdrymd8 Module: ReportingServicesService.exe begin GET_MTM_REP_PKG.GET_MTM_REP(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_REPORT , P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SELASO FDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_SELBU , P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMILY=> 14,351,633 1 1.4352E+07 2.8 286.40 1215.02 768mqk94rkm8b Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 1,731,181 1 1,731,181.0 0.3 25.56 90.13 f18jk50vqxna2 Module: ReportingServicesService.exe begin GET_STS_REP_SUR_PKG.get_STS_rep(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_RE PORT, P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SE LASOFDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_S ELBU, P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMI 1,677,449 1 1,677,449.0 0.3 24.41 42.60 a9tthpqu02md3 Module: pmdtm@ausinfsit03.us.dell.com (TNS V1-V3) SQL ordered by Gets DB/Inst: / 2 Snaps: 3911-3912 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 505,514,786 -> Captured SQL account for 99.6% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR (:B4 = 'DEFAULT')) AND ((INSTR(:B3 , ','||A.SK U||',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) W ------------------------------------------------------------- SQL ordered by Reads DB/Inst: / 2 Snaps: 3911-3912 -> Total Disk Reads: 3,473,826 -> Captured SQL account for 97.1% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 3,179,140 3 1,059,713.3 91.5 314.72 1399.36 bzb8b8xdrymd8 Module: ReportingServicesService.exe begin GET_MTM_REP_PKG.GET_MTM_REP(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_REPORT , P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SELASO FDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_SELBU , P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMILY=> 2,216,430 1 2,216,430.0 63.8 286.40 1215.02 768mqk94rkm8b Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 900,807 1 900,807.0 25.9 26.08 116.82 856ghz6w65rbt Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_PART_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ( (INSTR(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 ,','||A. PART_NUM||',') <> 0) OR INSTR(:B2 , 'DEFAULT') > 0) AND RUN_DATE <= TO_DATE(:B1 123,069 1 123,069.0 3.5 25.56 90.13 f18jk50vqxna2 Module: ReportingServicesService.exe begin GET_STS_REP_SUR_PKG.get_STS_rep(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_RE PORT, P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SE LASOFDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_S ELBU, P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMI 93,359 6 15,559.8 2.7 3.10 106.79 7nmdpdtnps3tj Module: ReportingServicesService.exe SELECT MAX(RUN_DATE) FROM E2EC_MAX_CYCLE_DATE WHERE RUN_DATE <= :B2 AND COST_TYP E = :B1 91,158 1 91,158.0 2.6 24.41 42.60 a9tthpqu02md3 Module: pmdtm@ausinfsit03.us.dell.com (TNS V1-V3) WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR (:B4 = 'DEFAULT')) AND ((INSTR(:B3 , ','||A.SK U||',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) W 34,175 0 N/A 1.0 1346.36 1387.43 1udsybbfypf3m Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'DAO' 24,466 1 24,466.0 0.7 423.74 461.47 9fs63m4j0rdvb Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'E10000' 24,466 1 24,466.0 0.7 422.45 454.65 b2wasvcy9u7r3 Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'E10000'; commit; end; 23,334 1 23,334.0 0.7 2440.54 2522.04 ank4sbr3urr3m SQL ordered by Reads DB/Inst: / 2 Snaps: 3911-3912 -> Total Disk Reads: 3,473,826 -> Captured SQL account for 97.1% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select distinct fp_desc from e2ec_pro duct_hierarchy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C40000'; commit; end; ------------------------------------------------------------- SQL ordered by Executions DB/Inst: / 2 Snaps: 3911-3912 -> Total Executions: 9,434 -> Captured SQL account for 48.9% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 357 357 1.0 0.01 0.02 7frqszzdu8sgg Module: racgimon@ausfl db02.us.dell.com (TNS V1-V3) select DECODE(UPPER(d.OPEN_MODE),'READ WRITE','R','N') ,DECODE(UPPER(i.STATUS),' OPEN','O','N') into :b0,:b1 from v$database d ,gv$instance i where i.INSTANCE_N AME=:b2 348 348 1.0 0.00 0.00 3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitan d(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag ,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0 ,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), 342 1,140 3.3 0.00 0.00 5p05u81kcmzt8 Module: TOAD 10.1.1.8 SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NEWLINES WHERE INST_ID = 2 AND HASH_VALUE= TO_NUMBER(:hash) ORDER BY PIECE 289 586 2.0 0.00 0.00 bsa0wjtftg3uw select file# from file$ where ts#=:1 238 238 1.0 0.01 0.00 bq7ct6kf8k64q select count(*) from x$kgllk where kgllkhdl=:1 and kgllkmod=1 and kgllkuse!=:2 223 223 1.0 0.00 0.00 0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE _NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') 223 223 1.0 0.00 0.00 459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME' 209 779 3.7 0.00 0.02 7s4hvxfax4rat Module: TOAD 10.1.1.8 SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NEWLINES WHERE INST_ID = 1 AND HASH_VALUE= TO_NUMBER(:hash) ORDER BY PIECE 193 193 1.0 0.00 0.00 grwydz59pu6mc select text from view$ where rowid=:1 157 157 1.0 0.00 0.00 81ky0n97v4zsg Module: emagent_SQL_oracle_database /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select s id from v$mystat where rownum=1) 145 145 1.0 0.00 0.00 3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) 138 138 1.0 0.00 0.00 f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual 121 0 0.0 0.00 0.00 b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait 96 0 0.0 0.00 0.00 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 96 96 1.0 0.00 0.00 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del SQL ordered by Executions DB/Inst: / 2 Snaps: 3911-3912 -> Total Executions: 9,434 -> Captured SQL account for 48.9% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: / 2 Snaps: 3911-3912 -> Total Parse Calls: 7,913 -> Captured SQL account for 72.3% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 713 89 9.01 b08c2zp99fxyt Module: TOAD 10.1.1.8 select decode(sql_hash_value, 0, prev_hash_value, sql_hash_value) hash , decode(sql_id, null, prev_sql_id, sql_id) sql_id from gv$session where sid = :si d and inst_id = :inst 608 89 7.68 1jdt1pwnunb9f Module: TOAD 10.1.1.8 SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NEWLINES WHERE INST_ID = 2 AND HASH_VALUE =TO_NUMBER(:hash) ORDER BY PIECE 429 67 5.42 5tupqpa5uv0xw Module: TOAD 10.1.1.8 SELECT round(bitand(s.ownerid, 65535)) parent_session_sid, round(bitand(s.owner id,16711680)/65536) parent_session_instid, s.INST_ID, s.SADDR, s.SID, s.SERIAL#, s.AUDSID, s.PADDR, s.USER#, s.USERNAME, s.COMMAND, s.OWNERID, s.TADDR, s.LOCKWA IT, s.STATUS, s.SERVER, s.SCHEMA#, s.SCHEMANAME, s.OSUSER, s.PROCESS, s.MACHINE, 357 357 4.51 7frqszzdu8sgg Module: racgimon@ausfl db02.us.dell.com (TNS V1-V3) select DECODE(UPPER(d.OPEN_MODE),'READ WRITE','R','N') ,DECODE(UPPER(i.STATUS),' OPEN','O','N') into :b0,:b1 from v$database d ,gv$instance i where i.INSTANCE_N AME=:b2 342 342 4.32 5p05u81kcmzt8 Module: TOAD 10.1.1.8 SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NEWLINES WHERE INST_ID = 2 AND HASH_VALUE= TO_NUMBER(:hash) ORDER BY PIECE 289 289 3.65 bsa0wjtftg3uw select file# from file$ where ts#=:1 238 238 3.01 bq7ct6kf8k64q select count(*) from x$kgllk where kgllkhdl=:1 and kgllkmod=1 and kgllkuse!=:2 223 223 2.82 0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE _NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') 223 223 2.82 459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME' 209 209 2.64 7s4hvxfax4rat Module: TOAD 10.1.1.8 SELECT SQL_TEXT FROM GV$SQLTEXT_WITH_NEWLINES WHERE INST_ID = 1 AND HASH_VALUE= TO_NUMBER(:hash) ORDER BY PIECE 193 193 2.44 grwydz59pu6mc select text from view$ where rowid=:1 157 157 1.98 81ky0n97v4zsg Module: emagent_SQL_oracle_database /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select s id from v$mystat where rownum=1) 145 145 1.83 3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) SQL ordered by Parse Calls DB/Inst: / 2 Snaps: 3911-3912 -> Total Parse Calls: 7,913 -> Captured SQL account for 72.3% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 138 138 1.74 f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual 121 348 1.53 3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitan d(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag ,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0 ,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), 121 121 1.53 b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait 96 96 1.21 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 96 96 1.21 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: / 2 Snaps: 3911-3912 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 2,669,966 1 0.42 a9tthpqu02md3 Module: pmdtm@ausinfsit03.us.dell.com (TNS V1-V3) WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR (:B4 = 'DEFAULT')) AND ((INSTR(:B3 , ','||A.SK U||',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) W 2,623,815 1 0.41 768mqk94rkm8b Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 2,475,454 1 0.39 856ghz6w65rbt Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_PART_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ( (INSTR(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 ,','||A. PART_NUM||',') <> 0) OR INSTR(:B2 , 'DEFAULT') > 0) AND RUN_DATE <= TO_DATE(:B1 1,548,138 1 0.24 6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti me_secs, operation FROM ( SELECT 1 as source, trunc( (sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 1,200,758 1 0.19 9wvcmbd9r5dfb Module: TOAD 10.1.1.8 SELECT owner FROM all_objects WHERE object_name = 'QU_VERSION' AND object_type = 'PACKAGE' AND owner = USER UNION SELECT owner FROM al l_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC' UNION SELECT owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = USER 1,200,758 1 0.19 9wvcmbd9r5dfb Module: TOAD 10.1.1.8 SELECT owner FROM all_objects WHERE object_name = 'QU_VERSION' AND object_type = 'PACKAGE' AND owner = USER UNION SELECT owner FROM al l_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC' UNION SELECT owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = USER 1,160,828 4 0.18 2358hy7wb7qym Module: TOAD 10.1.1.8 Select t.trigger_name, t.trigger_type, t.triggering_event, t.when_clause , t.status enabled, o.status, t.owner, o.object_id, t.trigger_body from sys.DBA_ OBJECTS o, sys.DBA_TRIGGERS t WHERE t.table_owner = :tableOwner and o.object_t ype = 'TRIGGER' and o.object_name = t.trigger_name and t.table_name = :tabl ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: / 2 Snaps: 3911-3912 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 27 6 7ng34ruy5awxq select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( 27 6 7ng34ruy5awxq select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( 27 6 7ng34ruy5awxq select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( 27 6 7ng34ruy5awxq select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( ------------------------------------------------------------- SQL ordered by Cluster Wait Time DB/Inst: / 2 Snaps: 3911-3912 -> %Ela is Cluster Wait Time as percentage of SQL Elapsed Time -> %Total is Cluster Wait Time as percentage of Total Cluster Wait Time -> Only SQL with Cluster Wait Time > .005 seconds is reported -> Total Cluster Wait Time (s): 401 -> Captured Segments account for 99.3% of Total Cluster Elapsed CPU Wait Time (s) %Ela %Total Time(s) Time(s) Executions SQL Id ------------- ------- ------- ----------- ----------- -------------- ----------- 292.9 20.9 73.0 1,399.36 314.72 3 bzb8b8xdrym Module: ReportingServicesService.exe begin GET_MTM_REP_PKG.GET_MTM_REP(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_REPORT , P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SELASO FDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_SELBU , P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMILY=> 222.7 18.3 55.5 1,215.02 286.40 1 768mqk94rkm Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 , ','||A.SKU| |',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) WHE 90.9 85.1 22.7 106.79 3.10 6 7nmdpdtnps3 Module: ReportingServicesService.exe SELECT MAX(RUN_DATE) FROM E2EC_MAX_CYCLE_DATE WHERE RUN_DATE <= :B2 AND COST_TYP E = :B1 50.5 56.0 12.6 90.13 25.56 1 f18jk50vqxn Module: ReportingServicesService.exe begin GET_STS_REP_SUR_PKG.get_STS_rep(P_USERGROUP=>:P_USERGROUP, P_REPORT=>:P_RE PORT, P_REPORTVIEW=>:P_REPORTVIEW, P_COSTTYPE=>:P_COSTTYPE, P_SELASOFDATE=>:P_SE LASOFDATE, P_SELCCN=>:P_SELCCN, P_PRIORASOFDATE=>:P_PRIORASOFDATE, P_SELBU=>:P_S ELBU, P_SELLOB=>:P_SELLOB, P_SELBRAND=>:P_SELBRAND, P_SELFP=>:P_SELFP, P_SELFAMI 14.5 12.4 3.6 116.82 26.08 1 856ghz6w65r Module: ReportingServicesService.exe WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_PART_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ( (INSTR(:B5 , ','||A.CCN||',') <> 0) OR :B4 = 'DEFAULT') AND ((INSTR(:B3 ,','||A. PART_NUM||',') <> 0) OR INSTR(:B2 , 'DEFAULT') > 0) AND RUN_DATE <= TO_DATE(:B1 13.1 96.2 3.3 13.63 0.15 4 bqfx5q2jas0 Module: emagent_SQL_oracle_database SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETER S_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STAT US = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUT 13.1 95.2 3.3 13.78 0.17 4 fcsu9qb17sk Module: emagent_SQL_oracle_database /* OracleOEM */ DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TY PE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM 8.4 1.8 2.1 461.47 423.74 1 9fs63m4j0rd Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'E10000' 8.4 1.8 2.1 454.65 422.45 1 b2wasvcy9u7 Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'E10000'; commit; end; SQL ordered by Cluster Wait Time DB/Inst: / 2 Snaps: 3911-3912 -> %Ela is Cluster Wait Time as percentage of SQL Elapsed Time -> %Total is Cluster Wait Time as percentage of Total Cluster Wait Time -> Only SQL with Cluster Wait Time > .005 seconds is reported -> Total Cluster Wait Time (s): 401 -> Captured Segments account for 99.3% of Total Cluster Elapsed CPU Wait Time (s) %Ela %Total Time(s) Time(s) Executions SQL Id ------------- ------- ------- ----------- ----------- -------------- ----------- 8.1 19.0 2.0 42.60 24.41 1 a9tthpqu02m Module: pmdtm@ausinfsit03.us.dell.com (TNS V1-V3) WITH CYCL AS (SELECT * FROM (SELECT A.*, RANK () OVER (PARTITION BY CCN ORDER BY RUN_DATE DESC) RANK FROM E2EC_MAX_CYCLE_DATE A WHERE COST_TYPE = :B6 AND ((INST R(:B5 , ','||A.CCN||',') <> 0) OR (:B4 = 'DEFAULT')) AND ((INSTR(:B3 , ','||A.SK U||',') <> 0 ) OR (INSTR(:B2 , 'DEFAULT') > 0)) AND RUN_DATE <= TO_DATE(:B1 )) W 7.3 0.3 1.8 2,522.04 2,440.54 1 ank4sbr3urr Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select distinct fp_desc from e2ec_pro duct_hierarchy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C40000'; commit; end; 7.2 0.3 1.8 2,468.83 2,426.42 1 dyhcfyss545 Module: TOAD 10.1.1.8 UPDATE E2EC_ITEM_PH B SET FP_DESC=(SELECT DISTINCT FP_DESC FROM E2EC_PRODUCT_HIE RARCHY A WHERE A.LOB_ID=B.LOB_ID AND A.FAMILY_ID=B.FMLY_ID) WHERE CCN = 'C40000' 6.1 93.3 1.5 6.53 0.09 6 0frazbfvq7y Module: ReportingServicesService.exe SELECT ROWNUM AS MONTH_ID,CASE SUBSTR(FISCAL_MONTH,6,2) WHEN '12' THEN 'JAN' WHE N '01' THEN 'FEB' WHEN '02' THEN 'MAR' WHEN '03' THEN 'APR' WHEN '04' THEN 'MAY' WHEN '05' THEN 'JUN' WHEN '06' THEN 'JUL' WHEN '07' THEN 'AUG' WHEN '08' THEN ' SEP' WHEN '09' THEN 'OCT' WHEN '10' THEN 'NOV' WHEN '11' THEN 'DEC' END || ' FY' 6.0 99.0 1.5 6.04 0.05 4 bdhsfa51s4z Module: ReportingServicesService.exe SELECT MAX(ACTUAL_DATE) END_DATE, MIN(ACTUAL_DATE) START_DATE FROM CORP_FISCAL_D AY_CALENDAR WHERE FISCAL_MONTH = (SELECT FISCAL_MONTH FROM CORP_FISCAL_DAY_CALEN DAR WHERE ACTUAL_DATE = TRUNC(SYSDATE)) 5.8 0.4 1.5 1,387.43 1,346.36 0 1udsybbfypf Module: PL/SQL Developer UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FAMILY_ID = B.FMLY_ID AND ROWNUM < 2) WHERE CC N = 'DAO' 5.8 0.4 1.5 1,380.04 1,344.07 0 9tabfvfbahn Module: PL/SQL Developer begin UPDATE E2EC_ITEM_PH B SET FP_DESC = (SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID = B.LOB_ID AND A.FA MILY_ID = B.FMLY_ID and rownum < 2) WHERE CCN = 'DAO'; commit; en d; 5.1 95.3 1.3 5.36 0.13 4 drdys53m8s2 Module: SQL*Plus UPDATE ACTIVITY_MONITOR SET END_TIME = SYSDATE, STATUS_MSG = :B5 , ACTIVITY_CODE = :B4 , ERROR_MSG = :B3 , ERROR_CODE = :B2 WHERE PROCESS_ID = :B1 2.7 95.0 0.7 2.84 0.09 1 cfz686a6qp0 select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 26843545 6), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user# 2.3 62.7 0.6 3.60 0.32 1 6ajkhukk78n begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; 2.2 93.0 0.5 2.35 0.03 1 3w720nb9z46 Module: ReportingServicesService.exe SQL ordered by Cluster Wait Time DB/Inst: / 2 Snaps: 3911-3912 -> %Ela is Cluster Wait Time as percentage of SQL Elapsed Time -> %Total is Cluster Wait Time as percentage of Total Cluster Wait Time -> Only SQL with Cluster Wait Time > .005 seconds is reported -> Total Cluster Wait Time (s): 401 -> Captured Segments account for 99.3% of Total Cluster Elapsed CPU Wait Time (s) %Ela %Total Time(s) Time(s) Executions SQL Id ------------- ------- ------- ----------- ----------- -------------- ----------- SELECT COUNT (DISTINCT FISCAL_MONTH)-1 FROM CORP_FISCAL_DAY_CALENDAR WHERE ACTUA L_DATE >=:B2 AND ACTUAL_DATE <=:B1 2.2 95.1 0.5 2.26 0.04 1 6wm3n4d7bnd SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti me_secs, operation FROM ( SELECT 1 as source, trunc( (sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 2.1 83.8 0.5 2.52 0.37 1 8g6q1y9btgk Module: TOAD 10.1.1.8 select tabs.table_name, 'COSTPL_CODE_ADMIN', tabs.cluster_name , partit ioned, iot_type , TEMPORARY, table_type, table_type_owner , tabl espace_name , NESTED , last_analyzed , Dropped , d ecode(nvl(buffer_pool, 'x') || upper(partitioned) || nvl(iot_type, 'x'), 'xNOx', 1.2 30.2 0.3 3.83 0.15 55 4vs91dcv7u1 Module: sqlplus.exe insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in .1 10.3 0.0 0.57 0.52 1 du2gqnj72t0 Module: TOAD 10.1.1.8 Select table_owner, table_name, db_link from sys.all_synonyms where synonym_name =:Objectname and Owner=:Name .1 6.0 0.0 0.97 0.87 1 9wvcmbd9r5d Module: TOAD 10.1.1.8 SELECT owner FROM all_objects WHERE object_name = 'QU_VERSION' AND object_type = 'PACKAGE' AND owner = USER UNION SELECT owner FROM al l_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC' UNION SELECT owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = USER .0 11.9 0.0 0.41 0.39 6 706zmtx38z6 Module: ReportingServicesService.exe select overload, decode(position,0,'RETURN_VALUE',nvl(argument_name,chr(0))) nam e, decode(in_out,'IN',1,'IN/OUT',3,'OUT',decode(argument_name,null,6,2),1) direc tion, decode(data_type, 'BFILE',1, 'BLOB',2, 'CHAR',3, 'CLOB',4, 'DATE',6, 'FLOA T',13, 'INTERVAL YEAR TO MONTH',8, 'INTERVAL DAY TO SECOND',7, 'LONG',10, 'LONG .0 36.4 0.0 0.10 0.07 75 87gaftwrm2h select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 .0 6.6 0.0 0.53 1.04 56 d5uz9k7utxu select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_ enabled_time), a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1), a.sch_jo b from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_e .0 96.4 0.0 0.03 0.00 4 9tgj4g8y4rw select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL (bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 .0 3.9 0.0 0.58 0.29 4 a8j39qb13tq Module: emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID,DECODE(RECINFO.TYPE,NULL, 'Uncategor SQL ordered by Cluster Wait Time DB/Inst: / 2 Snaps: 3911-3912 -> %Ela is Cluster Wait Time as percentage of SQL Elapsed Time -> %Total is Cluster Wait Time as percentage of Total Cluster Wait Time -> Only SQL with Cluster Wait Time > .005 seconds is reported -> Total Cluster Wait Time (s): 401 -> Captured Segments account for 99.3% of Total Cluster Elapsed CPU Wait Time (s) %Ela %Total Time(s) Time(s) Executions SQL Id ------------- ------- ------- ----------- ----------- -------------- ----------- ized',RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMP ACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 ,'MM-DD-YYYY HH24:MI:SS') START_TIME, TO _DATE(:B2 ,'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUN .0 46.9 0.0 0.04 0.02 64 dwypdxsjg4j select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,stime, status, dataob j#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namesp ace=:3 and remoteowner is null and linkname is null and subname is null .0 3.6 0.0 0.55 0.06 348 3c1kubcdjnp update sys.col_usage$ set equality_preds = equality_preds + decode(bitan d(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag ,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0 ,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1), .0 30.3 0.0 0.06 0.02 56 bcapm04cdx1 select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, nex t_run_date, last_start_date, last_end_date, retry_count, run_count, fail ure_count, running_instance, running_slave, flags, job_status, creator, .0 0.8 0.0 1.72 0.60 1 2j4nxk666zt Module: TOAD 10.1.1.8 Select a1.constraint_name, c1.column_name, c1.position from sys.DBA_CONS_COL UMNS C1, sys.DBA_CONSTRAINTS A1 where A1.table_name = C1.Table_name And A1.co nstraint_name = C1.Constraint_Name and A1.constraint_type = 'P' and A1.table_n ame =:TabName and C1.owner = A1.Owner and A1.owner =:Owner ORDER BY 3 .0 5.7 0.0 0.18 0.02 193 grwydz59pu6 select text from view$ where rowid=:1 .0 0.4 0.0 2.40 0.03 1 96hcm7pbdxg Module: TOAD 10.1.1.8 begin update e2ec_item_ph b set fp_desc=(select fp_desc from e2ec_product_hier archy a where a.lob_id=b.lob_id and a.family_id=b.fmly_id) where ccn = 'C4 0000'; commit; end; .0 0.4 0.0 2.29 0.03 1 1cxbsrg78fs Module: TOAD 10.1.1.8 UPDATE E2EC_ITEM_PH B SET FP_DESC=(SELECT FP_DESC FROM E2EC_PRODUCT_HIERARCHY A WHERE A.LOB_ID=B.LOB_ID AND A.FAMILY_ID=B.FMLY_ID) WHERE CCN = 'C40000' .0 26.0 0.0 0.03 0.01 57 3ktacv9r56b select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(proper ty,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj #=obj#(+) order by order# .0 12.7 0.0 0.06 0.01 145 3m8smr0v7v1 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) .0 66.0 0.0 0.01 0.01 57 8swypbbr0m3 select order#,columns,types from access$ where d_obj#=:1 .0 54.5 0.0 0.01 0.01 60 c4nhd1ntptx select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING wh ere reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instanc e_number = :4 .0 0.2 0.0 2.84 0.08 1 fdntddxugk3 SQL ordered by Cluster Wait Time DB/Inst: / 2 Snaps: 3911-3912 -> %Ela is Cluster Wait Time as percentage of SQL Elapsed Time -> %Total is Cluster Wait Time as percentage of Total Cluster Wait Time -> Only SQL with Cluster Wait Time > .005 seconds is reported -> Total Cluster Wait Time (s): 401 -> Captured Segments account for 99.3% of Total Cluster Elapsed CPU Wait Time (s) %Ela %Total Time(s) Time(s) Executions SQL Id ------------- ------- ------- ----------- ----------- -------------- ----------- Module: TOAD 10.1.1.8 select * from e2ec_item_ph where fmly_desc='RIPTIDE V' .0 13.2 0.0 0.04 0.00 6 7ng34ruy5aw select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( .0 5.6 0.0 0.10 0.01 66 5h7w8ykwtb2 INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID,NAME,DATATYPE,VALUE,FLAGS,DESCRIPTI ON) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) ------------------------------------------------------------- Instance Activity Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- Batched IO (bound) vector count 191,469 53.5 257.7 Batched IO (full) vector count 2,908 0.8 3.9 Batched IO block miss count 2,319,012 647.4 3,121.2 Batched IO buffer defrag count 1,359 0.4 1.8 Batched IO double miss count 18,696 5.2 25.2 Batched IO same unit count 1,186,891 331.4 1,597.4 Batched IO single block count 73,452 20.5 98.9 Batched IO slow jump count 19,948 5.6 26.9 Batched IO vector block count 1,061,581 296.4 1,428.8 Batched IO vector read count 120,937 33.8 162.8 Block Cleanout Optim referenced 3,902 1.1 5.3 CCursor + sql area evicted 1 0.0 0.0 CPU used by this session 488,291 136.3 657.2 CPU used when call started 356,859 99.6 480.3 CR blocks created 7 0.0 0.0 Cached Commit SCN referenced 273,451 76.3 368.0 Clusterwide global transactions 0 0.0 0.0 Commit SCN cached 49 0.0 0.1 DB time 1,867,583 521.4 2,513.6 DBWR checkpoint buffers written 85,813 24.0 115.5 DBWR checkpoints 96 0.0 0.1 DBWR fusion writes 179 0.1 0.2 DBWR object drop buffers written 0 0.0 0.0 DBWR parallel query checkpoint b 3 0.0 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR tablespace checkpoint buffe 0 0.0 0.0 DBWR thread checkpoint buffers w 9,157 2.6 12.3 DBWR transaction table writes 232 0.1 0.3 DBWR undo block writes 95,975 26.8 129.2 DDL statements parallelized 0 0.0 0.0 DFO trees parallelized 823 0.2 1.1 DML statements parallelized 0 0.0 0.0 DX/BB enqueue lock background ge 0 0.0 0.0 DX/BB enqueue lock background ge 0 0.0 0.0 DX/BB enqueue lock foreground re 0 0.0 0.0 DX/BB enqueue lock foreground wa 0 0.0 0.0 Effective IO time 202,385,752 56,502.0 272,390.0 HSC Compressed Segment Block Cha 5,870,757 1,639.0 7,901.4 HSC Heap Segment Block Changes 5,872,596 1,639.5 7,903.9 Heap Segment Array Inserts 113 0.0 0.2 Heap Segment Array Updates 17 0.0 0.0 LOB table id lookup cache misses 0 0.0 0.0 Number of read IOs issued 17,630 4.9 23.7 PX local messages recv'd 34,227 9.6 46.1 PX local messages sent 34,274 9.6 46.1 PX remote messages recv'd 14,681 4.1 19.8 PX remote messages sent 8,447 2.4 11.4 Parallel operations downgraded t 457 0.1 0.6 Parallel operations not downgrad 823 0.2 1.1 RowCR - row contention 0 0.0 0.0 RowCR attempts 0 0.0 0.0 RowCR hits 0 0.0 0.0 SMON posted for undo segment rec 0 0.0 0.0 SMON posted for undo segment shr 0 0.0 0.0 SQL*Net roundtrips to/from clien 5,654 1.6 7.6 SQL*Net roundtrips to/from dblin 0 0.0 0.0 TBS Extension: files extended 0 0.0 0.0 TBS Extension: tasks created 6 0.0 0.0 TBS Extension: tasks executed 6 0.0 0.0 active txn count during cleanout 410,402 114.6 552.4 Instance Activity Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- application wait time 226 0.1 0.3 auto extends on undo tablespace 0 0.0 0.0 background checkpoints completed 10 0.0 0.0 background checkpoints started 12 0.0 0.0 background timeouts 25,012 7.0 33.7 branch node splits 0 0.0 0.0 buffer is not pinned count 6,595,924 1,841.5 8,877.4 buffer is pinned count 6,855,326 1,913.9 9,226.6 bytes received via SQL*Net from 3,642,775 1,017.0 4,902.8 bytes received via SQL*Net from 0 0.0 0.0 bytes sent via SQL*Net to client 3,435,884 959.2 4,624.3 bytes sent via SQL*Net to dblink 0 0.0 0.0 calls to get snapshot scn: kcmgs 17,946,677 5,010.3 24,154.3 calls to kcmgas 93,278 26.0 125.5 calls to kcmgcs 458,393 128.0 617.0 cell physical IO interconnect by 34,268,638,208 9,567,101.0 46,121,989.5 change write time 7,461 2.1 10.0 cleanout - number of ktugct call 413,796 115.5 556.9 cleanouts and rollbacks - consis 1 0.0 0.0 cleanouts only - consistent read 3,365 0.9 4.5 cluster key scan block gets 766 0.2 1.0 cluster key scans 548 0.2 0.7 cluster wait time 40,113 11.2 54.0 commit batch performed 0 0.0 0.0 commit batch requested 0 0.0 0.0 commit batch/immediate performed 3 0.0 0.0 commit batch/immediate requested 3 0.0 0.0 commit cleanout failures: block 456 0.1 0.6 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callba 20 0.0 0.0 commit cleanout failures: cannot 13 0.0 0.0 commit cleanouts 14,266 4.0 19.2 commit cleanouts successfully co 13,777 3.9 18.5 commit immediate performed 3 0.0 0.0 commit immediate requested 3 0.0 0.0 commit txn count during cleanout 3,594 1.0 4.8 concurrency wait time 785 0.2 1.1 consistent changes 1,194 0.3 1.6 consistent gets 495,033,956 138,203.3 666,263.7 consistent gets - examination 531,531 148.4 715.4 consistent gets direct 2,111,180 589.4 2,841.4 consistent gets from cache 492,847,618 137,593.0 663,321.2 consistent gets from cache (fast 492,101,819 137,384.7 662,317.4 current blocks converted for CR 0 0.0 0.0 cursor authentications 59 0.0 0.1 data blocks consistent reads - u 26,807 7.5 36.1 db block changes 15,058,541 4,204.0 20,267.2 db block gets 10,480,884 2,926.1 14,106.2 db block gets direct 43 0.0 0.1 db block gets from cache 10,480,841 2,926.0 14,106.1 db block gets from cache (fastpa 2,305,180 643.6 3,102.5 deferred (CURRENT) block cleanou 36,449 10.2 49.1 dirty buffers inspected 16,522 4.6 22.2 enqueue conversions 7,020 2.0 9.5 enqueue releases 108,962 30.4 146.7 enqueue requests 110,226 30.8 148.4 enqueue timeouts 1,228 0.3 1.7 enqueue waits 5,198 1.5 7.0 exchange deadlocks 0 0.0 0.0 execute count 9,434 2.6 12.7 Instance Activity Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- failed probes on index block rec 0 0.0 0.0 free buffer inspected 1,665,337 464.9 2,241.4 free buffer requested 1,564,957 436.9 2,106.3 gc CPU used by this session 2,549 0.7 3.4 gc blocks lost 357 0.1 0.5 gc cr block build time 1 0.0 0.0 gc cr block flush time 509 0.1 0.7 gc cr block receive time 497 0.1 0.7 gc cr block send time 7 0.0 0.0 gc cr blocks received 2,909 0.8 3.9 gc cr blocks served 2,515 0.7 3.4 gc current block flush time 8 0.0 0.0 gc current block pin time 117 0.0 0.2 gc current block receive time 29,623 8.3 39.9 gc current block send time 62 0.0 0.1 gc current blocks received 157,647 44.0 212.2 gc current blocks served 10,046 2.8 13.5 gc local grants 1,304,411 364.2 1,755.6 gc remote grants 61,879 17.3 83.3 gcs messages sent 376,842 105.2 507.2 ges messages sent 97,477 27.2 131.2 global enqueue get time 2,722 0.8 3.7 global enqueue gets async 756 0.2 1.0 global enqueue gets sync 107,878 30.1 145.2 global enqueue releases 100,891 28.2 135.8 heap block compress 1,059,162 295.7 1,425.5 hot buffers moved to head of LRU 415,413 116.0 559.1 immediate (CR) block cleanout ap 3,366 0.9 4.5 immediate (CURRENT) block cleano 1,566 0.4 2.1 index crx upgrade (positioned) 2,969 0.8 4.0 index crx upgrade (prefetch) 0 0.0 0.0 index fast full scans (full) 49 0.0 0.1 index fetch by key 19,301 5.4 26.0 index scans kdiixs1 99,979 27.9 134.6 java call heap collected bytes 398,944 111.4 536.9 java call heap collected count 3,276 0.9 4.4 java call heap gc count 2 0.0 0.0 java call heap live object count 0 0.0 0.0 java call heap live object count 0 0.0 0.0 java call heap live size 0 0.0 0.0 java call heap live size max 0 0.0 0.0 java call heap object count 0 0.0 0.0 java call heap object count max 0 0.0 0.0 java call heap total size 0 0.0 0.0 java call heap total size max 0 0.0 0.0 java call heap used size 0 0.0 0.0 java call heap used size max 0 0.0 0.0 leaf node 90-10 splits 27 0.0 0.0 leaf node splits 37 0.0 0.1 lob reads 12,910,643 3,604.4 17,376.4 lob writes 389 0.1 0.5 lob writes unaligned 389 0.1 0.5 logons cumulative 2,348 0.7 3.2 messages received 7,809 2.2 10.5 messages sent 7,777 2.2 10.5 min active SCN optimization appl 7 0.0 0.0 no buffer to keep pinned count 5,289 1.5 7.1 no work - consistent read gets 476,477,201 133,022.7 641,288.3 opened cursors cumulative 8,063 2.3 10.9 parse count (describe) 0 0.0 0.0 Instance Activity Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- parse count (failures) 38 0.0 0.1 parse count (hard) 152 0.0 0.2 parse count (total) 7,913 2.2 10.7 parse time cpu 202 0.1 0.3 parse time elapsed 275 0.1 0.4 physical IO disk bytes 34,268,638,208 9,567,101.0 46,121,989.5 physical read IO requests 1,233,736 344.4 1,660.5 physical read bytes 27,822,292,992 7,767,413.6 37,445,885.6 physical read total IO requests 1,255,144 350.4 1,689.3 physical read total bytes 28,254,362,624 7,888,038.6 38,027,406.0 physical read total multi block 17,905 5.0 24.1 physical reads 3,473,826 969.8 4,675.4 physical reads cache 1,284,258 358.5 1,728.5 physical reads cache prefetch 1,031,020 287.8 1,387.6 physical reads direct 2,112,018 589.6 2,842.6 physical reads direct (lob) 218 0.1 0.3 physical reads direct temporary 0 0.0 0.0 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 15,494 4.3 20.9 physical write bytes 1,323,106,304 369,384.2 1,780,762.2 physical write total IO requests 32,225 9.0 43.4 physical write total bytes 6,014,275,584 1,679,062.4 8,094,583.6 physical write total multi block 14,379 4.0 19.4 physical writes 161,512 45.1 217.4 physical writes direct 229 0.1 0.3 physical writes direct (lob) 21 0.0 0.0 physical writes direct temporary 0 0.0 0.0 physical writes from cache 161,283 45.0 217.1 physical writes non checkpoint 144,009 40.2 193.8 pinned buffers inspected 249 0.1 0.3 prefetch warmup blocks aged out 0 0.0 0.0 prefetched blocks aged out befor 175 0.1 0.2 process last non-idle time 3,134 0.9 4.2 queries parallelized 795 0.2 1.1 recursive calls 57,286 16.0 77.1 recursive cpu usage 355,189 99.2 478.1 redo blocks checksummed by FG (e 273,148 76.3 367.6 redo blocks written 4,509,200 1,258.9 6,068.9 redo buffer allocation retries 29 0.0 0.0 redo entries 7,544,807 2,106.4 10,154.5 redo k-bytes read total 0 0.0 0.0 redo log space requests 49 0.0 0.1 redo log space wait time 167 0.1 0.2 redo ordering marks 91,394 25.5 123.0 redo size 2,231,621,228 623,022.9 3,003,527.9 redo size for direct writes 1,248 0.4 1.7 redo subscn max counts 134 0.0 0.2 redo synch time 98 0.0 0.1 redo synch writes 141 0.0 0.2 redo wastage 1,156,428 322.9 1,556.4 redo write broadcast ack time 0 0.0 0.0 redo write time 4,897 1.4 6.6 redo writer latching time 2 0.0 0.0 redo writes 2,909 0.8 3.9 rollback changes - undo records 826,796 230.8 1,112.8 rollbacks only - consistent read 1,360 0.4 1.8 rows fetched via callback 6,894 1.9 9.3 session connect time 0 0.0 0.0 session cursor cache hits 3,176 0.9 4.3 session logical reads 505,514,786 141,129.4 680,369.8 Instance Activity Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- shared hash latch upgrades - no 5,424 1.5 7.3 shared hash latch upgrades - wai 0 0.0 0.0 sorts (disk) 0 0.0 0.0 sorts (memory) 4,949 1.4 6.7 sorts (rows) 27,591,079 7,702.9 37,134.7 sql area evicted 134 0.0 0.2 sql area purged 38 0.0 0.1 summed dirty queue length 12,757 3.6 17.2 switch current to new buffer 54 0.0 0.1 table fetch by rowid 6,687,934 1,867.1 9,001.3 table fetch continued row 5 0.0 0.0 table scan blocks gotten 474,220,400 132,392.6 638,250.9 table scan rows gotten 13,269,241,859 3,704,500.2 17,859,006.5 table scans (cache partitions) 0 0.0 0.0 table scans (direct read) 419 0.1 0.6 table scans (long tables) 426 0.1 0.6 table scans (rowid ranges) 383 0.1 0.5 table scans (short tables) 1,117,011 311.9 1,503.4 total number of slots 32 0.0 0.0 total number of times SMON poste 7 0.0 0.0 transaction lock background get 0 0.0 0.0 transaction lock background gets 0 0.0 0.0 transaction lock foreground requ 0 0.0 0.0 transaction lock foreground wait 0 0.0 0.0 transaction rollbacks 3 0.0 0.0 transaction tables consistent re 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 undo change vector size 731,206,084 204,137.7 984,126.6 user I/O wait time 99,794 27.9 134.3 user calls 18,307 5.1 24.6 user commits 27 0.0 0.0 user rollbacks 716 0.2 1.0 workarea executions - onepass 0 0.0 0.0 workarea executions - optimal 5,008 1.4 6.7 write clones created in backgrou 0 0.0 0.0 write clones created in foregrou 18 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: / 2 Snaps: 3911-3 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session pga memory max 1.5363768E+12 1.5545016E+12 session cursor cache count 679,447 682,862 session uga memory 7.9191849E+12 7.9193030E+12 opened cursors current 134 158 workarea memory allocated 24,056 3,981 logons current 59 76 session uga memory max 1.8501183E+11 1.8638298E+11 session pga memory 3.8779282E+11 3.9210133E+11 ------------------------------------------------------------- Instance Activity Stats - Thread ActivityDB/Inst: / 2 Snaps: 3911-39 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 12 12.06 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: / 2 Snaps: 3911-3912 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ COST_DATA01 1,220,085 341 13.2 2.8 5,695 2 13 315.4 UNDOTBS2 12,971 4 3.2 1.0 8,787 2 2 0.0 SYSAUX 1,499 0 34.6 1.2 487 0 0 0.0 SYSTEM 807 0 41.2 1.1 61 0 19 39.5 COST_INDEX01 805 0 2.6 1.0 6 0 0 0.0 DATA 78 0 26.9 1.0 78 0 0 0.0 _DATA 30 0 27.0 1.0 30 0 0 0.0 TEMP 32 0 8.8 1.0 24 0 0 0.0 INDX 12 0 26.7 1.0 12 0 0 0.0 COST_ARCHIVE01 6 0 28.3 1.0 6 0 0 0.0 UNDOTBS1 6 0 16.7 1.0 6 0 1 0.0 USERS 6 0 25.0 1.0 6 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: / 2 Snaps: 3911-3912 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ COST_ARCHIVE01 +DATA_1/ _dr/datafile/cost_archive01 6 0 28.3 1.0 6 0 0 0.0 COST_DATA01 +DATA_1/ _dr/datafile/cost_data01 411,538 115 15.1 2.8 1,809 1 8 511.3 COST_DATA01 +DATA_1/ _dr/datafile/cost_data01.294.776754273 431,707 121 12.6 2.7 2,105 1 4 2.5 COST_DATA01 +DATA_1/ _dr/datafile/cost_data01.296.776754289 376,840 105 11.9 2.9 1,781 0 1 0.0 COST_INDEX01 +DATA_1/ _dr/datafile/cost_index01 805 0 2.6 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.283.737137237 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.284.737137239 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.285.737137239 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.286.737137239 6 0 16.7 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.297.776754327 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.298.776754339 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.299.776754391 6 0 25.0 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.300.776754403 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.301.776754415 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.302.776754429 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.303.776754447 6 0 25.0 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.304.776754483 6 0 28.3 1.0 6 0 0 0.0 DATA +DATA_1/ _dr/datafile/data.305.776754493 6 0 28.3 1.0 6 0 0 0.0 INDX +DATA_1/ _dr/datafile/indx.287.737137239 6 0 25.0 1.0 6 0 0 0.0 INDX +DATA_1/ _dr/datafile/indx.288.737137241 6 0 28.3 1.0 6 0 0 0.0 _DATA +DATA_1/ _dr/datafile/data 6 0 28.3 1.0 6 0 0 0.0 _DATA +DATA_1/ _dr/datafile/ _data.307.776772797 6 0 28.3 1.0 6 0 0 0.0 _DATA +DATA_1/ _dr/datafile/ _data.308.776772809 6 0 28.3 1.0 6 0 0 0.0 _DATA +DATA_1/ _dr/datafile/ _data.309.776772823 6 0 26.7 1.0 6 0 0 0.0 _DATA +DATA_1/ _dr/datafile/ _data.310.776772835 6 0 23.3 1.0 6 0 0 0.0 SYSAUX +DATA_1/ _dr/datafile/sysaux.261.736371093 1,499 0 34.6 1.2 487 0 0 0.0 SYSTEM +DATA_1/ _dr/datafile/system.265.736371093 807 0 41.2 1.1 61 0 19 39.5 TEMP +DATA_1/ _dr/tempfile/temp.291.776751279 23 0 10.9 1.0 11 0 0 N/A TEMP +DATA_1/ _dr/tempfile/temp.311.776776837 6 0 3.3 1.0 5 0 0 N/A TEMP +DATA_1/ _dr/tempfile/temp.312.776776851 3 0 3.3 1.0 8 0 0 N/A File IO Stats DB/Inst: / 2 Snaps: 3911-3912 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ UNDOTBS1 +DATA_1/ _dr/datafile/undotbs1.264.736371093 6 0 16.7 1.0 6 0 1 0.0 UNDOTBS2 +DATA_1/ _dr/datafile/undotbs2.262.736371093 6,694 2 3.2 1.0 4,387 1 2 0.0 UNDOTBS2 +DATA_1/ _dr/datafile/undotbs2.313.776776875 6,277 2 3.1 1.0 4,400 1 0 0.0 USERS +DATA_1/ _dr/datafile/users.260.736371093 6 0 25.0 1.0 6 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: / 2 Snaps: 3911-3912 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Writ Buffer Number of Pool Buffer Physical Physical Buff Comp Busy P Buffers Hit% Gets Reads Writes Wait Wait Waits --- ---------- ---- -------------- ------------ ----------- ---- ---- ---------- D 104,555 100 503,252,734 1,284,685 160,636 0 0 35 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: / 2 Snaps: 3911-3912 -> 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 0 307 1189 1449 763200 1449 N/A E 0 40 16624 771533 763200 763200 1962871 N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: / 2 Snap: 3912 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Size for Size Buffers for Read Estimated P Est (M) Factor Estimate Factor Physical Reads --- -------- ------ ---------------- ------ ------------------ D 80 .1 9,505 1.8 29,692,979 D 160 .2 19,010 1.6 26,125,946 D 240 .3 28,515 1.4 23,724,645 D 320 .4 38,020 1.3 22,135,127 D 400 .5 47,525 1.2 20,918,556 D 480 .5 57,030 1.2 19,689,638 D 560 .6 66,535 1.1 18,825,655 D 640 .7 76,040 1.1 18,170,105 D 720 .8 85,545 1.0 17,585,293 D 800 .9 95,050 1.0 17,123,042 D 880 1.0 104,555 1.0 16,760,948 D 960 1.1 114,060 1.0 16,444,456 D 1,040 1.2 123,565 1.0 16,169,674 D 1,120 1.3 133,070 0.9 15,908,571 D 1,200 1.4 142,575 0.9 15,675,864 D 1,280 1.5 152,080 0.9 15,452,352 D 1,360 1.5 161,585 0.9 15,232,327 D 1,440 1.6 171,090 0.9 15,018,173 D 1,520 1.7 180,595 0.9 14,803,897 D 1,600 1.8 190,100 0.9 14,560,136 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: / 2 Snaps: 3911-3912 -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ------------------ -------------------------- 100.0 1,695 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: / 2 Snaps: 3911-3912 -> B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval) -> 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 %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 8,052 6,804 1,003.8 23.5 2.3 100.0 .0 824,520 E 8,052 6,746 812.1 3.9 .5 100.0 .0 824,520 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: / 2 Snaps: 3911-3912 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 4,322 4,322 0 0 64K 128K 109 109 0 0 256K 512K 4 4 0 0 512K 1024K 277 277 0 0 1M 2M 194 194 0 0 2M 4M 39 39 0 0 4M 8M 42 42 0 0 8M 16M 5 5 0 0 16M 32M 12 12 0 0 128M 256M 3 3 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: / 2 Snap: 3912 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd P Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd Est (MB) Factr Processed Written to Disk Hit % Count Time ---------- ------- ---------------- ---------------- ------ -------- ------- 1,007 0.1 178,503.3 151,753.7 54.0 6 8.0E+07 2,013 0.3 178,503.3 39,391.2 82.0 0 5.3E+07 4,026 0.5 178,503.3 39,391.2 82.0 0 5.3E+07 6,039 0.8 178,503.3 39,391.2 82.0 0 5.3E+07 8,052 1.0 178,503.3 2,136.3 99.0 0 4.4E+07 9,662 1.2 178,503.3 0.0 100.0 0 4.3E+07 11,273 1.4 178,503.3 0.0 100.0 0 4.3E+07 12,883 1.6 178,503.3 0.0 100.0 0 4.3E+07 14,494 1.8 178,503.3 0.0 100.0 0 4.3E+07 16,104 2.0 178,503.3 0.0 100.0 0 4.3E+07 24,156 3.0 178,503.3 0.0 100.0 0 4.3E+07 32,208 4.0 178,503.3 0.0 100.0 0 4.3E+07 48,312 6.0 178,503.3 0.0 100.0 0 4.3E+07 64,416 8.0 178,503.3 0.0 100.0 0 4.3E+07 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: / 2 Snap: 3912 -> 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 Obj Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Hits (K) -------- ----- -------- ------------ -------- ------ ------- ------ ------------ 416 .7 14 977 26,395 1.0 3,014 1.1 1,100 480 .8 76 4,657 26,428 1.0 2,981 1.1 4,673 544 .9 139 6,799 26,559 1.0 2,850 1.0 4,700 608 1.0 203 8,881 26,648 1.0 2,761 1.0 4,719 672 1.1 267 11,658 26,695 1.0 2,714 1.0 4,729 736 1.2 331 15,532 26,719 1.0 2,690 1.0 4,734 800 1.3 395 19,249 26,730 1.0 2,679 1.0 4,736 864 1.4 459 22,357 26,736 1.0 2,673 1.0 4,737 928 1.5 523 25,219 26,739 1.0 2,670 1.0 4,738 992 1.6 587 28,709 26,740 1.0 2,669 1.0 4,739 1,056 1.7 650 30,751 26,741 1.0 2,668 1.0 4,739 1,120 1.8 714 31,692 26,742 1.0 2,667 1.0 4,739 1,184 1.9 778 33,537 26,743 1.0 2,666 1.0 4,739 1,248 2.1 842 35,674 26,743 1.0 2,666 1.0 4,739 ------------------------------------------------------------- SGA Target Advisory DB/Inst: / 2 Snap: 3912 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 768 0.5 54,975 24,996,350 1,152 0.8 47,563 18,526,864 1,536 1.0 45,528 16,760,326 1,920 1.3 44,189 15,597,159 2,304 1.5 43,589 15,339,050 2,688 1.8 43,538 15,339,050 3,072 2.0 43,538 15,339,050 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: / 2 Snap: 3912 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: / 2 Snap: 3912 Est LC Est LC Est LC Est LC Java JP 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 ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 16 1.0 1 42 1 1.0 2,761 1.0 31 32 2.0 1 72 1 1.0 2,761 1.0 52 ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: / 2 Snaps: 3911-3912 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 31 5 156 undo header 3 0 0 segment header 1 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: / 2 Snaps: 3911-3912 -> 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) ------------ ------------ ----------- ----------- ------------ -------------- PS-PX Process Reservation 6,542 6,511 31 2,188 1 .38 CF-Controlfile Transaction 10,341 10,338 3 1,189 1 .66 WF-AWR Flush 21 21 0 13 1 42.31 KO-Multiple Object Checkpoint (fast object checkpoint) 546 546 0 232 0 1.34 HW-Segment High Water Mark 625 625 0 317 0 .35 CO-KTUCLO Master Slave enq (master slave det) 1,194 0 1,194 1,194 0 .02 JS-Job Scheduler (job run lock - synchronize) 57 57 0 57 0 .00 TM-DML 9,718 9,718 0 6 0 .00 FB-Format Block 786 786 0 4 0 .00 US-Undo Segment 1 1 0 1 0 .00 ------------------------------------------------------------- Undo Segment Summary DB/Inst: / 2 Snaps: 3911-3912 -> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) -> STO - Snapshot Too Old count, OOS - Out of Space count -> Undo segment block stats: -> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed -> eS - expired Stolen, eR - expired Released, eU - expired reUsed Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/ TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU ---- ---------- --------------- -------- -------- --------- ----- -------------- 4 79.5 527 3,834 3 35.9/75.9 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: / 2 Snaps: 3911-3912 -> Most recent 35 Undostat rows, ordered by Time desc Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/ End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU ------------ ----------- ------------ ------- ------- ------- ----- ------------ 13-Mar 17:54 27,253 44 2,335 3 51 0/0 0/0/0/0/0/0 13-Mar 17:44 25,738 29 3,834 3 76 0/0 0/0/0/0/0/0 13-Mar 17:34 20,393 95 3,233 3 66 0/0 0/0/0/0/0/0 13-Mar 17:24 5,509 36 2,632 2 56 0/0 0/0/0/0/0/0 13-Mar 17:14 438 195 2,032 1 46 0/0 0/0/0/0/0/0 13-Mar 17:04 142 128 1,431 3 36 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: / 2 Snaps: 3911-3912 -> "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 Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ASM allocation 18 0.0 0 0 N/A ASM db client latch 2,628 0.0 0 0 N/A ASM map headers 21 0.0 0 0 N/A ASM map load waiting lis 3 0.0 0 0 N/A ASM map operation freeli 1,623 0.1 0.0 0 0 N/A ASM map operation hash t 2,650,347 0.0 0.0 0 0 N/A ASM network background l 1,462 0.0 0 0 N/A AWR Alerted Metric Eleme 26,671 0.0 0 0 N/A Change Notification Hash 1,195 0.0 0 0 N/A Consistent RBA 2,922 0.0 0 0 N/A DML lock allocation 6,211,626 0.0 0 0 N/A Event Group Locks 312 0.0 0 0 N/A FIB s.o chain latch 684 0.0 0 0 N/A FOB s.o list latch 1,582 0.1 0.0 0 0 N/A File State Object Pool P 1 0.0 0 0 N/A IPC stats buffer allocat 5,261 0.0 0 5,319 0.0 In memory undo latch 1 0.0 0 0 N/A JS Sh mem access 115 0.0 0 0 N/A JS broadcast add buf lat 2,618 0.0 0 0 N/A JS broadcast drop buf la 2,561 0.0 0 0 N/A JS broadcast load blnc l 2,288 0.0 0 0 N/A JS mem alloc latch 120 0.0 0 0 N/A JS queue access latch 121 0.0 0 0 N/A JS queue state obj latch 74,538 0.0 0 0 N/A JS slv state obj latch 229 0.0 0 0 N/A KFC FX Hash Latch 1 0.0 0 0 N/A KFC Hash Latch 1 0.0 0 0 N/A KFCL LE Freelist 1 0.0 0 0 N/A KFK SGA Libload latch 952 0.0 0 0 N/A KFMD SGA 579 1.6 0.1 0 0 N/A KFR redo allocation latc 1 0.0 0 0 N/A KGNFS-NFS:SHM structure 1 0.0 0 0 N/A KGNFS-NFS:SVR LIST 1 0.0 0 0 N/A KJC message pool free li 14,695 0.0 0.0 0 11,986 0.0 KJCT flow control latch 302,141 0.0 0.0 0 0 N/A KMG MMAN ready and start 1,194 0.0 0 0 N/A KMG resize request state 2 0.0 0 0 N/A KTF sga latch 54 0.0 0 1,115 0.0 KWQMN job cache list lat 277 0.0 0 0 N/A KWQS pqsubs latch 8 0.0 0 0 N/A KWQS pqueue ctx latch 8 0.0 0 0 N/A Locator state objects po 1 0.0 0 0 N/A MQL Tracking Latch 0 N/A 0 72 0.0 Memory Management Latch 24 0.0 0 1,194 0.0 Memory Queue 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Subscriber 1 0.0 0 0 N/A MinActiveScn Latch 13,787,657 0.0 0.0 0 0 N/A Mutex 1 0.0 0 0 N/A Mutex Stats 1 0.0 0 0 N/A OS process 1,402 0.0 0 0 N/A OS process allocation 2,144 0.0 0 0 N/A OS process: request allo 606 0.0 0 0 N/A PL/SQL warning settings 2,495 0.0 0 0 N/A QMT 1 0.0 0 0 N/A Real-time plan statistic 22,556 0.0 0.0 0 0 N/A SGA IO buffer pool latch 1,442 0.0 0 1,469 0.0 Latch Activity DB/Inst: / 2 Snaps: 3911-3912 -> "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 Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ SGA blob parent 1 0.0 0 0 N/A SGA bucket locks 1 0.0 0 0 N/A SGA heap locks 1 0.0 0 0 N/A SGA pool locks 1 0.0 0 0 N/A SQL memory manager latch 1 0.0 0 1,191 0.0 SQL memory manager worka 495,303 0.0 0 0 N/A Shared B-Tree 142 0.0 0 0 N/A Streams Generic 1 0.0 0 0 N/A Testing 1 0.0 0 0 N/A Token Manager 1 0.0 0 0 N/A Write State Object Pool 1 0.0 0 0 N/A XDB NFS Security Latch 1 0.0 0 0 N/A XDB unused session pool 1 0.0 0 0 N/A XDB used session pool 1 0.0 0 0 N/A active checkpoint queue 8,477 0.6 0.0 0 0 N/A active service list 210,333 0.0 0.3 0 1,330 0.0 archive control 383 0.0 0 0 N/A begin backup scn array 24 0.0 0 0 N/A buffer pool 4 0.0 0 0 N/A business card 1,639 0.0 0 0 N/A cache buffer handles 17,391 0.0 0 0 N/A cache buffers chains 1,039,745,284 0.0 0.0 0 3,823,045 0.1 cache buffers lru chain 556,164 0.0 0.1 0 2,206,783 0.0 cache table scan latch 7,634 0.0 0 7,634 0.0 cas latch 1 0.0 0 0 N/A change notification clie 1 0.0 0 0 N/A channel handle pool latc 623 0.0 0 0 N/A channel operations paren 880,476 0.0 0.0 0 0 N/A checkpoint queue latch 625,049 0.0 0.0 0 180,808 0.0 client/application info 14,692 0.0 0 0 N/A commit callback allocati 17 0.0 0 0 N/A compile environment latc 2,346 0.0 0 0 N/A corrupted undo seg lock 2,480,391 0.0 0 0 N/A cp cmon/server latch 1 0.0 0 0 N/A cp pool latch 1 0.0 0 0 N/A cp server hash latch 1 0.0 0 0 N/A cp sga latch 64 0.0 0 0 N/A cvmap freelist lock 1 0.0 0 0 N/A deferred cleanup latch 64 0.0 0 0 N/A dml lock allocation 64 0.0 0 0 N/A done queue latch 1 0.0 0 0 N/A dummy allocation 4,676 0.0 0 0 N/A enqueue hash chains 266,544 0.0 0.0 0 5 0.0 enqueues 195,301 0.0 0.0 0 0 N/A error message lists 3,718 0.0 0 0 N/A fifth spare latch 1 0.0 0 0 N/A file cache latch 813 0.0 0 0 N/A flashback archiver latch 12 0.0 0 0 N/A flashback copy 1 0.0 0 0 N/A gc element 1,242,886 0.0 0.0 0 8,448 0.0 gcs commit scn state 1 0.0 0 0 N/A gcs opaque info freelist 234,774 0.2 0.0 0 0 N/A gcs partitioned table ha 13,313,464 0.1 0.0 0 1,379,613 0.0 gcs pcm hashed value buc 1 0.0 0 0 N/A gcs remaster request que 7 0.0 0 0 N/A gcs remastering latch 276,289 2.7 0.0 0 0 N/A gcs resource freelist 94,131 0.0 0 83,999 0.0 gcs resource hash 2,507,798 0.0 0.1 0 0 N/A gcs resource scan list 1 0.0 0 0 N/A gcs shadows freelist 43,175 0.0 0 93,905 0.0 Latch Activity DB/Inst: / 2 Snaps: 3911-3912 -> "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 Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ges caches resource list 143,015 0.0 0.0 0 129,710 0.0 ges deadlock list 38,392 0.0 0 1 0.0 ges domain table 203,320 0.0 0 0 N/A ges enqueue table freeli 290,835 0.0 0.0 0 0 N/A ges group table 305,298 0.0 0.0 0 0 N/A ges process hash list 260,850 0.0 0 0 N/A ges process parent latch 530,877 0.0 0 0 N/A ges process table freeli 606 0.2 0.0 0 0 N/A ges resource hash list 644,559 0.0 0.1 0 97,276 0.0 ges resource scan list 2,597 0.0 0 0 N/A ges resource table freel 187,842 0.0 0.0 0 0 N/A ges synchronous data 32 0.0 0 1,375 0.1 ges timeout list 4,278 0.0 0 778 0.0 ges value block free lis 115 0.0 0 0 N/A global KZLD latch for me 55 0.0 0 0 N/A global tx hash mapping 1 0.0 0 0 N/A granule operation 1 0.0 0 0 N/A hash table column usage 204 0.0 0 226,236 0.0 hash table modification 77 0.0 0 0 N/A heartbeat check 1 0.0 0 716 0.0 intra txn parallel recov 1 0.0 0 0 N/A io pool granule metadata 1 0.0 0 0 N/A job workq parent latch 1 0.0 0 114 0.0 job_queue_processes para 2,574 0.0 0 0 N/A k2q global data latch 2,388 0.0 0 0 N/A k2q lock allocation 1 0.0 0 0 N/A kdlx hb parent latch 1 0.0 0 0 N/A kgb parent 1 0.0 0 0 N/A kks stats 141 0.0 0 0 N/A kokc descriptor allocati 2,882 0.0 0 0 N/A ksfv messages 1 0.0 0 0 N/A ksim membership request 338 0.0 0 2,627 0.0 kss move lock 27 0.0 0 0 N/A ksuosstats global area 241 0.0 0 0 N/A ksv allocation latch 116 0.0 0 0 N/A ksv class latch 4,420 0.0 0 0 N/A ksv msg queue latch 6 0.0 0 5 0.0 ksxp shared latch 606 0.2 0.0 0 0 N/A ksz_so allocation latch 606 0.0 0 0 N/A ktm global data 29 0.0 0 0 N/A kwqbsn:qsga 125 0.0 0 0 N/A lgwr LWN SCN 3,103 0.0 0 0 N/A list of block allocation 3,102 0.0 0 0 N/A loader state object free 954 0.3 0.0 0 0 N/A lob segment dispenser la 1 0.0 0 0 N/A lob segment hash table l 13 0.0 0 0 N/A lob segment query latch 1 0.0 0 0 N/A lock DBA buffer during m 1 0.0 0 0 N/A logical standby cache 1 0.0 0 0 N/A logminer context allocat 1 0.0 0 0 N/A logminer work area 1 0.0 0 0 N/A longop free list parent 2,685 0.0 0 24 0.0 mapped buffers lru chain 1 0.0 0 0 N/A message pool operations 18,219 0.0 0 0 N/A messages 165,625 0.0 0.0 0 0 N/A mostly latch-free SCN 3,148 0.3 0.0 0 0 N/A msg queue latch 1 0.0 0 0 N/A multiblock read objects 267,527 0.0 0.0 0 0 N/A name-service memory obje 2,681 0.0 0 0 N/A name-service namespace b 21,577 0.0 0 0 N/A Latch Activity DB/Inst: / 2 Snaps: 3911-3912 -> "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 Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ name-service pending que 1,852 0.0 0 0 N/A name-service request 36 0.0 0 0 N/A name-service request que 35,464 0.0 0 0 N/A ncodef allocation latch 64 0.0 0 0 N/A object queue header heap 35,959 0.0 0 3,882 0.0 object queue header oper 3,980,859 0.0 0.1 0 0 N/A object stats modificatio 47 0.0 0 0 N/A parallel query alloc buf 25,358 0.0 0 0 N/A parallel query stats 4,409 0.0 0.0 0 0 N/A parallel txn reco latch 1,176 0.0 0 0 N/A parameter list 1,104 0.0 0 0 N/A parameter table manageme 4,677 0.0 0 0 N/A peshm 1 0.0 0 0 N/A pesom_free_list 1 0.0 0 0 N/A pesom_hash_node 1 0.0 0 0 N/A post/wait queue 730 0.0 0 583 0.0 process allocation 17,339 0.0 0 311 0.0 process group creation 606 0.0 0 0 N/A process queue 12,043 0.0 0.0 0 0 N/A process queue reference 774,892 0.0 0.0 0 103,341 1.9 qmn task queue latch 521 0.0 0 0 N/A query server freelists 9,456 0.0 0 0 N/A query server process 16 0.0 0 1 0.0 queued dump request 12 0.0 0 0 N/A recovery domain hash lis 1 0.0 0 0 N/A redo allocation 11,144 0.2 0.0 0 7,542,954 0.0 redo copy 1 0.0 0 7,543,154 0.0 redo writing 20,967 0.1 0.0 0 0 N/A resmgr group change latc 3,076 0.0 0 0 N/A resmgr:active threads 4,676 0.0 0 0 N/A resmgr:actses change gro 2,232 0.0 0 0 N/A resmgr:actses change sta 1 0.0 0 0 N/A resmgr:free threads list 4,675 0.0 0.0 0 0 N/A resmgr:plan CPU method 1 0.0 0 0 N/A resmgr:resource group CP 1 0.0 0 0 N/A resmgr:schema config 81 0.0 0 0 N/A resmgr:session queuing 1 0.0 0 0 N/A rm cas latch 1 0.0 0 0 N/A row cache objects 4,047,589 0.0 0.0 0 0 N/A second spare latch 1 0.0 0 0 N/A segmented array pool 4 0.0 0 0 N/A sequence cache 709 0.0 0 0 N/A session allocation 50,136 0.2 0.0 0 0 N/A session idle bit 38,301 0.0 0 0 N/A session queue latch 1 0.0 0 0 N/A session state list latch 4,613 0.0 0.0 0 0 N/A session switching 65 0.0 0 0 N/A session timer 1,330 0.0 0 0 N/A shared pool 118,781 0.0 0.1 0 0 N/A shared pool sim alloc 5 0.0 0 0 N/A shared pool simulator 2,848 0.0 0 0 N/A sim partition latch 1 0.0 0 0 N/A simulator hash latch 31,985,119 0.0 0.0 0 0 N/A simulator lru latch 110 0.0 0 31,862,196 0.0 sort extent pool 129 0.0 0 0 N/A space background task la 2,684 0.0 0 2,388 0.0 state object free list 2 0.0 0 0 N/A statistics aggregation 336 0.0 0 0 N/A tablespace key chain 1 0.0 0 0 N/A temp lob duration state 4 0.0 0 0 N/A Latch Activity DB/Inst: / 2 Snaps: 3911-3912 -> "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 Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ test excl. parent l0 1 0.0 0 0 N/A test excl. parent2 l0 1 0.0 0 0 N/A third spare latch 1 0.0 0 0 N/A threshold alerts latch 212 0.0 0 0 N/A transaction allocation 1,485,605 0.0 0 0 N/A transaction branch alloc 1,330 0.0 0 0 N/A undo global data 440,045 0.0 0 0 N/A user lock 223 0.0 0 0 N/A virtual circuit buffers 1 0.0 0 0 N/A virtual circuit holder 1 0.0 0 0 N/A virtual circuit queues 1 0.0 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: / 2 Snaps: 3911-3912 -> ordered by misses desc Get Spin Latch Name Requests Misses Sleeps Gets -------------------------- --------------- ------------ ----------- ----------- cache buffers chains 1,039,745,284 43,124 8 43,117 ges resource hash list 644,559 142 11 131 object queue header operat 3,980,859 88 9 80 session allocation 50,136 86 4 82 gcs resource hash 2,507,798 58 5 53 cache buffers lru chain 556,164 46 3 43 ges caches resource lists 143,015 30 1 29 shared pool 118,781 24 2 22 KFMD SGA 579 9 1 8 active service list 210,333 3 1 2 ------------------------------------------------------------- Latch Miss Sources DB/Inst: / 2 Snaps: 3911-3912 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- KFMD SGA kfmdSlvJoin_LU 0 1 0 active service list ksws_event: ksws event 0 1 1 cache buffers chains kcbgcur_2 0 3 1 cache buffers chains kcbgtcr: fast path (cr pin 0 3 4 cache buffers chains kcbnew: new latch again 0 2 0 cache buffers chains kcbbxsv 0 1 1 cache buffers chains kcbgtcr: fast path 0 1 0 cache buffers chains kcbzgb: scan from tail. no 0 1 0 cache buffers lru chain kcbzgws 0 3 0 gcs resource hash kjbassume 0 2 0 gcs resource hash kjbmpopen 0 2 0 gcs resource hash kjbmpclose 0 1 1 ges resource hash list kjakcai: search for resp b 0 5 0 ges resource hash list kjrmas1: lookup master nod 0 4 1 ges resource hash list kjuscl: lock close request 0 2 4 ges resource table freel kjruch: cached obj cleanup 0 1 0 object queue header oper kclobj_6 0 5 0 object queue header oper kclobj_2 0 3 4 object queue header oper kcbo_switch_q_bg 0 1 1 session allocation ksuxds: KSUSFCLC not set 0 4 1 shared pool kghfre 0 2 2 ------------------------------------------------------------- Mutex Sleep Summary DB/Inst: / 2 Snaps: 3911-3912 -> ordered by number of sleeps desc Wait Mutex Type Location Sleeps Time (ms) --------------------- -------------------------------- ------------ ------------ Library Cache kglhdgn2 106 3 0 Library Cache kglpin1 4 3 0 Library Cache kglget2 2 2 0 Library Cache kgllkc1 57 2 0 Library Cache kglpnal2 91 2 0 Library Cache kglpndl1 95 2 0 Library Cache kglhdgn1 62 1 0 Library Cache kgllkck1 89 1 0 Library Cache kglpnal1 90 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: / 2 Snaps: 3911-3912 -> Total Logical Reads: 505,514,786 -> Captured Segments account for 96.7% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_PRODUCT_HIERARC TABLE 475,888,048 94.14 ADMIN_COST COST_DATA0 E2EC_ITEM_PH TEM_PH_DAO TABLE 5,497,888 1.09 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 OST_T4_DAO TABLE 3,070,480 .61 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_E10000 TABLE 1,582,048 .31 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_C40000 TABLE 1,127,760 .22 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: / 2 Snaps: 3911-3912 -> Total Physical Reads: 3,473,826 -> Captured Segments account for 97.3% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 OST_T4_DAO TABLE 2,182,106 62.82 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 _T4_E10000 TABLE 335,398 9.66 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 _T4_C40000 TABLE 234,696 6.76 ADMIN_COST COST_DATA0 E2EC_MAX_CYCLE_DATE E_DATE_DAO TABLE 202,260 5.82 ADMIN_COST COST_DATA0 ITEM_MST EM_MST_DAO TABLE 95,391 2.75 ------------------------------------------------------------- Segments by Direct Physical Reads DB/Inst: / 2 Snaps: 3911-3912 -> Total Direct Physical Reads: 2,112,018 -> Captured Segments account for 100.0% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 OST_T4_DAO TABLE 1,112,956 52.70 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 _T4_E10000 TABLE 334,852 15.85 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2 _T4_C40000 TABLE 234,696 11.11 ADMIN_COST COST_DATA0 E2EC_MAX_CYCLE_DATE E_DATE_DAO TABLE 202,230 9.58 ADMIN_COST COST_DATA0 ITEM_MST EM_MST_DAO TABLE 95,391 4.52 ------------------------------------------------------------- Segments by Physical Writes DB/Inst: / 2 Snaps: 3911-3912 -> Total Physical Writes: 161,512 -> Captured Segments account for 39.0% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_PH TEM_PH_DAO TABLE 22,199 13.74 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_C40000 TABLE 20,371 12.61 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_E10000 TABLE 20,090 12.44 SYS SYSAUX WRH$_EVENT_HISTOGRAM 22888_3900 TABLE 51 .03 SYS SYSAUX WRH$_SQL_PLAN TABLE 50 .03 ------------------------------------------------------------- Segments by Direct Physical Writes DB/Inst: / 2 Snaps: 3911-3912 -> Total Direct Physical Writes: 229 -> Captured Segments account for 18.8% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_ACTIVE_SESSION_ 22888_3900 TABLE 22 9.61 SYS SYSAUX SYS_LOB0000005981C00 LOB 21 9.17 ------------------------------------------------------------- Segments by Table Scans DB/Inst: / 2 Snaps: 3911-3912 -> Total Table Scans: 475 -> Captured Segments account for 97.3% of Total Tablespace Subobject Obj. Table Owner Name Object Name Name Type Scans %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_E10000 TABLE 207 43.58 ADMIN_COST COST_DATA0 E2EC_ITEM_PH TEM_PH_DAO TABLE 175 36.84 SYS SYSTEM I_OBJ2 INDEX 31 6.53 ADMIN_COST COST_DATA0 E2EC_MAX_CYCLE_DATE E_DATE_DAO TABLE 14 2.95 ADMIN_COST COST_DATA0 E2EC_ATTACH_RATE AR_MON_10 TABLE 4 .84 ------------------------------------------------------------- Segments by DB Blocks Changes DB/Inst: / 2 Snaps: 3911-3912 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot Tablespace Subobject Obj. DB Block % of Owner Name Object Name Name Type Changes Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_PH TEM_PH_DAO TABLE 5,151,440 69.63 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_E10000 TABLE 1,323,104 17.88 ADMIN_COST COST_DATA0 E2EC_ITEM_PH _PH_C40000 TABLE 922,240 12.46 SYS SYSAUX WRH$_SQL_PLAN TABLE 736 .01 SYS SYSAUX WRI$_ADV_MESSAGE_GRO TABLE 160 .00 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Segments by ITL Waits DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: / 2 Snaps: 3911-3912 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot Buffer Tablespace Subobject Obj. Busy % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 15 93.75 ADMIN_COST COST_DATA0 E2EC_ITEM_PH TEM_PH_DAO TABLE 1 6.25 ------------------------------------------------------------- Segments by Global Cache Buffer Busy DB/Inst: / 2 Snaps: 3911-3912 -> % of Capture shows % of GC Buffer Busy for each top segment compared -> with GC Buffer Busy for all segments captured by the Snapshot GC Tablespace Subobject Obj. Buffer % of Owner Name Object Name Name Type Busy Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 CORP_FISCAL_DAY_CALE TABLE 11 91.67 SYS SYSTEM AUD$ TABLE 1 8.33 ------------------------------------------------------------- Segments by CR Blocks Received DB/Inst: / 2 Snaps: 3911-3912 -> Total CR Blocks Received: 2,909 -> Captured Segments account for 92.0% of Total CR Tablespace Subobject Obj. Blocks Owner Name Object Name Name Type Received %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_PRODUCT_HIERARC TABLE 2,198 75.56 SYS SYSTEM SCHEDULER$_JOB TABLE 126 4.33 SYS SYSTEM OBJ$ TABLE 121 4.16 SYS SYSAUX SMON_SCN_TIME TABLE 34 1.17 ADMIN_COST COST_DATA0 CORP_FISCAL_DAY_CALE TABLE 25 .86 ------------------------------------------------------------- Segments by Current Blocks Received DB/Inst: / 2 Snaps: 3911-3912 -> Total Current Blocks Received: 157,647 -> Captured Segments account for 98.5% of Total Current Tablespace Subobject Obj. Blocks Owner Name Object Name Name Type Received %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2_ID OST_T4_DAO INDEX 54,220 34.39 ADMIN_COST COST_DATA0 E2EC_MAX_CYCLE_DATE ATE_C40000 TABLE 30,614 19.42 ADMIN_COST COST_DATA0 E2EC_MAX_CYCLE_DATE ATE_E10000 TABLE 20,480 12.99 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2_ID _T4_E10000 INDEX 11,964 7.59 ADMIN_COST COST_DATA0 E2EC_ITEM_COST_T2_ID _T4_C40000 INDEX 7,661 4.86 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: / 2 Snaps: 3911-3912 -> "Pct Misses" should be very low (< 2% in most cases) -> "Final Usage" is the number of cache entries being used Get Pct Scan Pct Mod Final Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_awr_control 62 1.6 0 N/A 1 1 dc_database_links 452 0.0 0 N/A 0 6 dc_global_oids 1,831 0.4 0 N/A 0 51 dc_histogram_data 6,200 0.9 0 N/A 0 4,437 dc_histogram_defs 9,096 0.4 0 N/A 0 6,900 dc_object_grants 14 0.0 0 N/A 0 77 dc_objects 9,485 0.9 0 N/A 0 2,220 dc_profiles 88 0.0 0 N/A 0 3 dc_rollback_segments 5,448 0.0 0 N/A 0 100 dc_segments 643 1.7 0 N/A 20 1,707 dc_sequences 50 10.0 0 N/A 50 7 dc_tablespace_quotas 48 2.1 0 N/A 0 3 dc_tablespaces 1,070,194 0.0 0 N/A 0 13 dc_users 245,453 0.0 0 N/A 0 80 global database name 3,832 0.0 0 N/A 0 1 outstanding_alerts 72 83.3 0 N/A 0 11 ------------------------------------------------------------- Dictionary Cache Stats (RAC) DB/Inst: / 2 Snaps: 3911-3912 GES GES GES Cache Requests Conflicts Releases ------------------------- ------------ ------------ ------------ dc_awr_control 3 1 0 dc_global_oids 7 0 0 dc_histogram_defs 39 0 0 dc_objects 68 56 0 dc_segments 45 0 0 dc_sequences 100 3 0 dc_tablespace_quotas 25 0 0 dc_users 1 0 0 outstanding_alerts 144 62 0 ------------------------------------------------------------- Library Cache Activity DB/Inst: / 2 Snaps: 3911-3912 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 87 0.0 145 0.0 0 0 CLUSTER 298 0.0 52 0.0 0 0 INDEX 9 0.0 7 42.9 3 0 SQL AREA 4,768 1.3 17,235 2.3 83 38 TABLE/PROCEDURE 55,622 0.0 57,260 0.2 91 0 ------------------------------------------------------------- Library Cache Activity (RAC) DB/Inst: / 2 Snaps: 3911-3912 GES Lock GES Pin GES Pin GES Inval GES Invali- Namespace Requests Requests Releases Requests dations --------------- ------------ ------------ ------------ ----------- ----------- CLUSTER 52 52 0 0 0 INDEX 7 7 0 0 0 TABLE/PROCEDURE 4,495 56,384 0 0 0 ------------------------------------------------------------- Memory Dynamic Components DB/Inst: / 2 Snaps: 3911-3912 -> Min/Max sizes since instance startup -> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred -> ordered by Component Begin Snap Current Min Max Oper Last Op Component Size (Mb) Size (Mb) Size (Mb) Size (Mb) Count Typ/Mod --------------- ----------- ----------- ----------- ----------- ------ ------- ASM Buffer Cach .00 .00 .00 .00 0 STA/ DEFAULT 16K buf .00 .00 .00 .00 0 STA/ DEFAULT 2K buff .00 .00 .00 .00 0 STA/ DEFAULT 32K buf .00 .00 .00 .00 0 STA/ DEFAULT 4K buff .00 .00 .00 .00 0 STA/ DEFAULT 8K buff .00 .00 .00 .00 0 STA/ DEFAULT buffer 848.00 880.00 704.00 1,152.00 1 GRO/DEF KEEP buffer cac .00 .00 .00 .00 0 STA/ PGA Target 8,064.00 8,064.00 8,064.00 8,064.00 0 STA/ RECYCLE buffer .00 .00 .00 .00 0 STA/ SGA Target 1,536.00 1,536.00 1,536.00 1,536.00 0 STA/ Shared IO Pool .00 .00 .00 .00 0 STA/ java pool 16.00 16.00 16.00 16.00 0 STA/ large pool 16.00 16.00 16.00 128.00 0 SHR/DEF shared pool 640.00 608.00 336.00 672.00 1 SHR/DEF streams pool .00 .00 .00 .00 0 STA/ ------------------------------------------------------------- Memory Resize Operations Summary DB/Inst: / 2 Snaps: 3911-3912 -> Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured -> ordered by Component Min Max Avg Re- Component Size (Mb) Size (Mb) Size (Mb) Sizes Grows Shrink --------------- ----------- ----------- ----------- ------ ------ ------ DEFAULT buffer 880.00 880.00 880.00 1 1 0 shared pool 608.00 608.00 608.00 1 0 1 ------------------------------------------------------------- Memory Resize Ops DB/Inst: / 2 Snaps: 3911-3912 -> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size -> Status: COMplete/CANcelled/INActive/PENding/ERRor -> ordered by start_time desc,component Ela Oper Init Target Final Start (s) Component Typ/Mod Size (M Delta Delta (M) Sta -------------- ----- ----------- ------- ------- ------ ------ ------ --- 03/13 17:06:17 0 bufcache GRO/DEF 848 32 N/A 880 COM 03/13 17:06:17 0 shared SHR/DEF 640 -32 N/A 608 COM ------------------------------------------------------------- Process Memory Summary DB/Inst: / 2 Snaps: 3911-3912 -> 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 -> ordered by Begin/End snapshot, Alloc (MB) desc Hist Avg Std Dev Max Max Alloc Used Alloc Alloc Alloc Alloc Num Num Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc - -------- --------- --------- -------- -------- ------- ------- ------ ------ B Other 599.0 N/A 9.8 27.5 215 215 61 61 Freeable 310.9 .0 9.1 46.1 270 N/A 34 34 SQL 84.9 71.4 2.3 9.4 52 303 37 33 JAVA 6.4 6.4 3.2 .8 4 6 2 2 PL/SQL 2.6 .6 .0 .3 2 17 61 60 E Other 667.7 N/A 8.7 24.6 215 215 77 77 SQL 91.7 78.2 1.7 7.1 52 303 53 50 Freeable 43.7 .0 1.2 1.3 6 N/A 36 36 JAVA 6.4 6.4 3.2 .8 4 6 2 2 PL/SQL 2.6 .6 .0 .2 2 17 77 77 ------------------------------------------------------------- SGA Memory Summary DB/Inst: / 2 Snaps: 3911-3912 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 889,192,448 922,746,880 Fixed Size 2,160,112 Redo Buffers 7,413,760 Variable Size 704,645,648 671,091,216 ------------------- sum 1,603,411,968 ------------------------------------------------------------- SGA breakdown difference DB/Inst: / 2 Snaps: 3911-3912 -> ordered by Pool, Name -> N/A 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 free memory 9.3 9.3 0.00 java joxlod exec hp 6.6 6.6 0.00 large ASM map operations hashta .4 .4 0.00 large PX msg pool 1.0 1.0 0.00 large free memory 14.6 14.6 0.00 shared ASH buffers 30.7 30.7 0.00 shared CCursor 43.5 44.1 1.47 shared FileOpenBlock 6.6 6.6 0.00 shared KCL name table 12.0 12.0 0.00 shared KGL handle 8.8 8.8 0.58 shared KQR L PO 8.7 8.7 0.38 shared PCursor 15.5 15.7 1.10 shared PL/SQL DIANA 10.2 N/A -100.00 shared PX subheap 10.0 10.0 0.00 shared db_block_hash_buckets 11.1 11.1 0.00 shared dbwriter coalesce buffer 12.0 12.0 0.00 shared event statistics per sess 7.2 7.2 0.00 shared free memory 69.0 47.7 -30.90 shared gcs resources 22.7 22.7 0.00 shared gcs shadows 15.2 15.2 0.00 shared ges big msg buffers 15.2 15.2 0.00 shared ges enqueues 13.9 13.9 0.00 shared ges reserved msg buffers 7.9 7.9 0.00 shared ges resource 8.2 8.2 0.00 shared row cache 7.2 7.2 0.00 shared sessions 7.0 7.0 0.00 shared sql area 165.5 161.6 -2.32 buffer_cache 848.0 880.0 3.77 fixed_sga 2.1 2.1 0.00 log_buffer 7.1 7.1 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Persistent Subscribers DB/Inst: / 2 Snaps: 3911-3912 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: / 2 Snap: 3912 -> only rows with Current or Maximum Utilization > 80% of Limit are shown -> ordered by resource name Current Maximum Initial Resource Name Utilization Utilization Allocation Limit ------------------------------ ------------ ------------ ---------- ---------- gcs_resources 98,482 154,065 165614 165614 ------------------------------------------------------------- init.ora Parameters DB/Inst: / 2 Snaps: 3911-3912 -> if IP/Public/Source at End snap is different a '*' is displayed End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- archive_lag_target 900 audit_file_dest /u01/app/oracle/admin/ /adump audit_trail DB cluster_database TRUE cluster_database_instances 2 compatible 11.1.0.0.0 control_files +DATA_1/ _dr/controlfile/curr db_block_size 8192 db_create_file_dest +DATA_1 db_create_online_log_dest_1 +DATA_1 db_create_online_log_dest_2 +ARCH_1 db_domain dr.amer.dell.com db_file_name_convert , _dr, , _DR db_name db_unique_name _dr dg_broker_config_file1 +DATA_1/ _dr/dr1 .dat dg_broker_config_file2 +DATA_1/ _dr/dr2 .dat dg_broker_start FALSE diagnostic_dest /u01/app/oracle fal_client _dr fal_server _prd instance_number 2 local_listener (ADDRESS = (PROTOCOL = TCP)(HOST log_archive_config dg_config=( , _dr) log_archive_dest_1 location="+ARCH_1", valid_for=(A log_archive_dest_state_1 ENABLE log_archive_format %t_%s_%r.dbf log_archive_max_processes 10 log_archive_min_succeed_dest 1 log_archive_trace 0 log_file_name_convert , _dr, , _DR nls_length_semantics CHAR open_cursors 600 pga_aggregate_target 8443133952 processes 600 remote_listener LISTENERS_ remote_login_passwordfile EXCLUSIVE sga_target 1610612736 spfile +DATA_1/ /spfile .ora standby_file_management auto thread 2 undo_tablespace UNDOTBS2 ------------------------------------------------------------- Global Enqueue Statistics DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ acks for commit broadcast(actual) 476 0.1 0.6 acks for commit broadcast(logical 545 0.2 0.7 broadcast msgs on commit(actual) 2,831 0.8 3.8 broadcast msgs on commit(logical) 2,894 0.8 3.9 broadcast msgs on commit(wasted) 41 0.0 0.1 broadcast on commit wait time(ms) 5 0.0 0.0 broadcast on commit waits 15 0.0 0.0 dynamically allocated gcs resourc 0 0.0 0.0 dynamically allocated gcs shadows 0 0.0 0.0 false posts waiting for scn acks 0 0.0 0.0 flow control messages received 0 0.0 0.0 flow control messages sent 0 0.0 0.0 gcs assume cvt 0 0.0 0.0 gcs assume no cvt 9,780 2.7 13.2 gcs ast xid 0 0.0 0.0 gcs blocked converts 566 0.2 0.8 gcs blocked cr converts 2,631 0.7 3.5 gcs compatible basts 6 0.0 0.0 gcs compatible cr basts (global) 9 0.0 0.0 gcs compatible cr basts (local) 116,754 32.6 157.1 gcs cr basts to PIs 0 0.0 0.0 gcs cr serve without current lock 0 0.0 0.0 gcs dbwr flush pi msgs 174 0.0 0.2 gcs dbwr write request msgs 161 0.0 0.2 gcs error msgs 0 0.0 0.0 gcs forward cr to pinged instance 0 0.0 0.0 gcs immediate (compatible) conver 1,752 0.5 2.4 gcs immediate (null) converts 26,453 7.4 35.6 gcs immediate cr (compatible) con 3 0.0 0.0 gcs immediate cr (null) converts 84,298 23.5 113.5 gcs indirect ast 2,671 0.7 3.6 gcs indirect bidless ast 0 0.0 0.0 gcs indirect fg ast 2,671 0.7 3.6 gcs lms flush pi msgs 0 0.0 0.0 gcs lms write request msgs 8 0.0 0.0 gcs msgs process time(ms) 1,049 0.3 1.4 gcs msgs received 182,745 51.0 246.0 gcs new served by master 9,726 2.7 13.1 gcs out-of-order msgs 0 0.0 0.0 gcs pings refused 3 0.0 0.0 gcs pkey conflicts retry 0 0.0 0.0 gcs queued converts 0 0.0 0.0 gcs reader bypass N->Xw ping loca 0 0.0 0.0 gcs reader bypass N->Xw ping remo 0 0.0 0.0 gcs reader bypass grant X on assu 0 0.0 0.0 gcs reader bypass grant ast 0 0.0 0.0 gcs reader bypass grant fg ast 0 0.0 0.0 gcs reader bypass grant immediate 0 0.0 0.0 gcs recovery claim msgs 0 0.0 0.0 gcs refuse xid 0 0.0 0.0 gcs regular cr 0 0.0 0.0 gcs retry convert request 0 0.0 0.0 gcs share recovery bast 0 0.0 0.0 gcs side channel msgs actual 12,797 3.6 17.2 gcs side channel msgs logical 198,652 55.5 267.4 gcs stale cr 0 0.0 0.0 gcs undo cr 2,604 0.7 3.5 gcs write notification msgs 1 0.0 0.0 gcs writes refused 0 0.0 0.0 ges msgs process time(ms) 530 0.1 0.7 Global Enqueue Statistics DB/Inst: / 2 Snaps: 3911-3912 Statistic Total per Second per Trans --------------------------------- ---------------- ------------ ------------ ges msgs received 122,455 34.2 164.8 global posts dropped 0 0.0 0.0 global posts queue time 0 0.0 0.0 global posts queued 0 0.0 0.0 global posts requested 0 0.0 0.0 global posts sent 0 0.0 0.0 implicit batch messages received 5,500 1.5 7.4 implicit batch messages sent 1,380 0.4 1.9 lmd msg send time(ms) 1 0.0 0.0 lms(s) msg send time(ms) 0 0.0 0.0 messages flow controlled 703 0.2 0.9 messages queue sent actual 81,863 22.9 110.2 messages queue sent logical 84,918 23.7 114.3 messages received actual 115,848 32.3 155.9 messages received logical 305,231 85.2 410.8 messages sent directly 78,069 21.8 105.1 messages sent indirectly 88,309 24.7 118.9 messages sent not implicit batche 80,483 22.5 108.3 messages sent pbatched 390,351 109.0 525.4 msgs causing lmd to send msgs 47,804 13.3 64.3 msgs causing lms(s) to send msgs 7,596 2.1 10.2 msgs received queue time (ms) 4,568 1.3 6.1 msgs received queued 305,232 85.2 410.8 msgs sent queue time (ms) 122,220,380 34,121.4 164,495.8 msgs sent queue time on ksxp (ms) 249,213 69.6 335.4 msgs sent queued 83,586 23.3 112.5 msgs sent queued on ksxp 178,875 49.9 240.7 process batch messages received 49,857 13.9 67.1 process batch messages sent 97,170 27.1 130.8 ------------------------------------------------------------- Global CR Served Stats DB/Inst: / 2 Snaps: 3911-3912 Statistic Total ------------------------------ ------------------ CR Block Requests 256 CURRENT Block Requests 2,911 Data Block Requests 256 Undo Block Requests 1,621 TX Block Requests 996 Current Results 2,541 Private results 0 Zero Results 1 Disk Read Results 625 Fail Results 0 Fairness Down Converts 36 Fairness Clears 81 Free GC Elements 0 Flushes 190 Flushes Queued 0 Flush Queue Full 0 Flush Max Time (us) 742,389 Light Works 641 Errors 0 ------------------------------------------------------------- Global CURRENT Served Stats DB/Inst: / 2 Snaps: 3911-3912 -> Pins = CURRENT Block Pin Operations -> Flushes = Redo Flush before CURRENT Block Served Operations -> Writes = CURRENT Block Fusion Write Operations Statistic Total % <1ms % <10ms % <100ms % <1s % <10s ---------- ------------ -------- -------- -------- -------- -------- Pins 10,102 99.94 0.01 0.04 0.00 0.01 Flushes 14 7.14 64.29 28.57 0.00 0.00 Writes 179 1.12 49.16 49.72 0.00 0.00 ------------------------------------------------------------- Global Cache Transfer Stats DB/Inst: / 2 Snaps: 3911-3912 -> Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays -> Busy (Busy) - Block Transfer impacted by Remote Contention -> Congested (Congst) - Block Transfer impacted by Remote System Load -> ordered by CR + Current Blocks Received desc CR Current ----------------------------- ----------------------------- Inst Block Blocks % % % Blocks % % % No Class Received Immed Busy Congst Received Immed Busy Congst ---- ----------- -------- ------ ------ ------ -------- ------ ------ ------ 1 data block 2,824 99.6 .4 .0 156,795 99.0 .0 1.0 1 Others 34 100.0 .0 .0 820 99.8 .2 .0 1 undo header 44 100.0 .0 .0 13 100.0 .0 .0 ------------------------------------------------------------- Global Cache Transfer Times (ms) DB/Inst: / 2 Snaps: 3911-3912 -> Avg Time - average time of all blocks (Immed,Busy,Congst) in ms -> Immed, Busy, Congst - Average times in ms -> ordered by CR + Current Blocks Received desc CR Avg Time (ms) Current Avg Time (ms) -------------------------------- -------------------------------- Inst Block No Class All Immed Busy Congst All Immed Busy Congst ---- -------- -------- ------- ------- ------- -------- ------- ------- ------- 1 data blo 1.8 1.8 5.2 N/A 1.9 1.9 9.1 4.0 1 others 0.4 0.4 N/A N/A 0.4 0.4 6.5 N/A 1 undo hea 0.4 0.4 N/A N/A 0.4 0.4 N/A N/A 1 undo blo N/A N/A N/A N/A N/A N/A N/A N/A ------------------------------------------------------------- Global Cache Transfer (Immediate) DB/Inst: / 2 Snaps: 3911-3912 -> Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays -> % of Blocks Received requiring 2 or 3 hops -> ordered by CR + Current Blocks Received desc CR Current --------------------------- --------------------------- Src Block Blocks Immed Blks % % Immed Blks % % Inst Class Lost Received 2hop 3hop Received 2hop 3hop ---- -------- ------- ----------- ------- ------- ----------- ------- ------- 1 data blo 357 2,812 100.0 0.0 155,158 100.0 0.0 1 others 0 34 100.0 0.0 818 100.0 0.0 1 undo hea 0 44 100.0 0.0 13 100.0 0.0 1 undo blo 0 0 N/A N/A 0 N/A N/A ------------------------------------------------------------- Global Cache Times (Immediate) DB/Inst: / 2 Snaps: 3911-3912 -> Blocks Lost, 2-hop and 3-hop Average times in (ms) -> ordered by CR + Current Blocks Received desc CR Avg Time (ms) Current Avg Time (ms) ---------------------------- ---------------------------- Src Block Lost Inst Class Time Immed 2hop 3hop Immed 2hop 3hop ---- -------- ------- ---------- -------- -------- ---------- -------- -------- 1 data blo 1045.4 1.8 1.8 N/A 1.9 1.9 N/A 1 others 0.4 0.4 N/A 0.4 0.4 N/A 1 undo hea 0.4 0.4 N/A 0.4 0.4 N/A 1 undo blo N/A N/A N/A N/A N/A N/A ------------------------------------------------------------- Interconnect Ping Latency Stats DB/Inst: / 2 Snaps: 3911-3912 -> Ping latency of the roundtrip of a message from this instance to -> target in -> The target instance is identified by an instance number. -> Average and standard deviation of ping latency is given in miliseconds -> for message sizes of 500 bytes and 8K. -> Note that latency of a message from the instance to itself is used as -> control, since message latency can include wait for CPU Target 500B Pin Avg Latency Stddev 8K Ping Avg Latency Stddev Instance Count 500B msg 500B msg Count 8K msg 8K msg --------- -------- ----------- ----------- -------- ----------- ----------- 1 286 .31 .09 286 .39 .11 2 286 .14 .03 286 .14 .03 ------------------------------------------------------------- Interconnect Throughput by Client DB/Inst: / 2 Snaps: 3911-3912 -> Throughput of interconnect usage by major consumers. -> All throughput numbers are megabytes per second Send Receive Used By Mbytes/sec Mbytes/sec ---------------- ----------- ----------- Global Cache .03 .35 Parallel Query .01 .01 DB Locks .03 .02 DB Streams .00 .00 Other .00 .00 ------------------------------------------------------------- Interconnect Device Statistics DB/Inst: / 2 Snaps: 3911-3912 -> Throughput and errors of interconnect devices (at OS level). -> All throughput numbers are megabytes per second Device Name IP Address Public Source --------------- ---------------- ------ ------------------------------- Send Send Send Send Send Buffer Carrier Mbytes/sec Errors Dropped Overrun Lost ----------- -------- -------- -------- -------- Receive Receive Receive Receive Receive Buffer Frame Mbytes/sec Errors Dropped Overrun Errors ----------- -------- -------- -------- -------- bond0 192.168.234.3 NO Oracle Cluster Repository .14 0 0 0 0 .46 0 0 0 0 ------------------------------------------------------------- End of Report