WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- PROD 155795046 Prod 1 26-Feb-11 15:34 11.2.0.1.0 NO Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- atlas Solaris[tm] OE (64-bit) 4 4 4 32.00 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 476 16-Mar-11 14:00:23 156 37.9 End Snap: 478 16-Mar-11 16:00:39 164 40.6 Elapsed: 120.27 (mins) DB Time: 301.22 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 720M 720M Std Block Size: 8K Shared Pool Size: 2,384M 2,384M Log Buffer: 4,432K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ --------------- --------------- ---------- ---------- DB Time(s): 2.5 1.0 0.02 0.03 DB CPU(s): 0.7 0.3 0.00 0.01 Redo size: 16,651.9 6,779.0 Logical reads: 12,501.2 5,089.3 Block changes: 89.1 36.3 Physical reads: 420.5 171.2 Physical writes: 6.8 2.8 User calls: 80.9 32.9 Parses: 79.8 32.5 Hard parses: 1.2 0.5 W/A MB processed: 0.9 0.4 Logons: 0.4 0.2 Executes: 148.0 60.3 Rollbacks: 0.5 0.2 Transactions: 2.5 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 96.64 In-memory Sort %: 100.00 Library Hit %: 99.11 Soft Parse %: 98.50 Execute to Parse %: 46.08 Latch Hit %: 99.99 Parse CPU to Parse Elapsd %: 19.94 % Non-Parse CPU: 94.27 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 78.85 85.02 % SQL with executions>1: 89.94 86.40 % Memory for SQL w/exec>1: 91.48 89.08 Top 5 Timed Foreground Events ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg wait % DB Event Waits Time(s) (ms) time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- row cache lock 1,696 9,775 5763 54.1 Concurrenc DB CPU 4,688 25.9 SQL*Net message from dblink 2,942 390 133 2.2 Network db file sequential read 1,471,059 289 0 1.6 User I/O enq: TX - row lock contention 52 149 2867 .8 Applicatio Host CPU (CPUs: 4 Cores: 4 Sockets: 4) ~~~~~~~~ Load Average Begin End %User %System %WIO %Idle --------- --------- --------- --------- --------- --------- 0.86 1.23 17.5 6.7 0.0 75.8 Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: 16.5 % of busy CPU for Instance: 68.3 %DB time waiting for CPU - Resource Mgr: 0.0 Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End Host Mem (MB): 32,768.0 32,768.0 SGA use (MB): 4,000.0 4,000.0 PGA use (MB): 705.6 696.4 % Host Mem used for SGA+PGA: 14.36 14.33 Time Model Statistics DB/Inst: PROD/Prod Snaps: 476-478 -> Total time in database user-calls (DB Time): 18073.5s -> 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 13,818.7 76.5 DB CPU 4,688.0 25.9 connection management call elapsed time 3,075.4 17.0 parse time elapsed 2,137.6 11.8 hard parse elapsed time 1,875.2 10.4 hard parse (sharing criteria) elapsed time 621.5 3.4 PL/SQL execution elapsed time 324.5 1.8 PL/SQL compilation elapsed time 89.7 .5 failed parse elapsed time 27.0 .1 hard parse (bind mismatch) elapsed time 13.6 .1 sequence load elapsed time 2.6 .0 repeated bind elapsed time 0.7 .0 DB time 18,073.5 background elapsed time 529.3 background cpu time 85.6 ------------------------------------------------------------- Operating System Statistics DB/Inst: PROD/Prod Snaps: 476-478 -> *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 ------------------------- ---------------------- ---------------- AVG_BUSY_TIME 174,596 AVG_IDLE_TIME 547,108 AVG_SYS_TIME 48,310 AVG_USER_TIME 126,109 BUSY_TIME 699,142 IDLE_TIME 2,189,149 SYS_TIME 193,962 USER_TIME 505,180 LOAD 1 1 OS_CPU_WAIT_TIME 276,200 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 32,481,280 PHYSICAL_MEMORY_BYTES 34,359,738,368 NUM_CPUS 4 NUM_CPU_CORES 4 NUM_CPU_SOCKETS 4 TCP_RECEIVE_SIZE_DEFAULT 49,152 TCP_RECEIVE_SIZE_MAX 1,048,576 TCP_SEND_SIZE_DEFAULT 49,152 TCP_SEND_SIZE_MAX 1,048,576 ------------------------------------------------------------- Operating System Statistics - Detail DB/Inst: PROD/Prod Snaps: 476-478 Snap Time Load %busy %user %sys %idle %iowait --------------- -------- -------- -------- -------- -------- -------- 16-Mar 14:00:23 0.9 N/A N/A N/A N/A N/A 16-Mar 15:00:31 1.6 21.3 15.7 5.6 78.7 0.0 16-Mar 16:00:39 1.2 27.1 19.2 7.8 72.9 0.0 ------------------------------------------------------------- Foreground Wait Class DB/Inst: PROD/Prod Snaps: 476-478 -> 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 86.1% of Total DB time 18,073.46 (s) -> Total FG Wait Time: 10,868.40 (s) DB CPU time: 4,687.99 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- Concurrency 1,995 6 9,806 4915 54.3 DB CPU 4,688 25.9 Network 583,258 0 394 1 2.2 User I/O 1,700,028 0 370 0 2.0 Application 8,810 0 157 18 0.9 Commit 7,135 0 133 19 0.7 Other 1,231,058 100 4 0 0.0 System I/O 2,379 0 3 1 0.0 Configuration 10 0 1 103 0.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: PROD/Prod Snaps: 476-478 -> 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 -------------------------- ------------ ----- ---------- ------- -------- ------ row cache lock 1,696 7 9,775 5763 0.1 54.1 SQL*Net message from dblin 2,942 0 390 133 0.2 2.2 db file sequential read 1,471,059 0 289 0 83.0 1.6 enq: TX - row lock content 52 0 149 2867 0.0 .8 log file sync 7,135 0 133 19 0.4 .7 db file scattered read 213,202 0 47 0 12.0 .3 cursor: pin S wait on X 28 0 26 926 0.0 .1 local write wait 834 0 17 21 0.0 .1 db file parallel read 6,568 0 10 2 0.4 .1 enq: RO - fast object reus 148 0 6 39 0.0 .0 buffer busy waits 25 0 5 184 0.0 .0 control file parallel writ 112 0 3 29 0.0 .0 direct path write temp 96 0 3 28 0.0 .0 asynch descriptor resize 1,230,678 100 3 0 69.4 .0 SQL*Net more data to clien 30,997 0 3 0 1.7 .0 SQL*Net break/reset to cli 8,610 0 2 0 0.5 .0 Disk file operations I/O 6,346 0 1 0 0.4 .0 SQL*Net message to client 544,338 0 1 0 30.7 .0 read by other session 1,479 0 1 1 0.1 .0 log buffer space 7 0 1 104 0.0 .0 ADR block file read 126 0 0 4 0.0 .0 direct path read 314 0 0 1 0.0 .0 enq: TC - contention 7 0 0 51 0.0 .0 db file single write 32 0 0 11 0.0 .0 library cache lock 4 0 0 77 0.0 .0 log file switch completion 3 0 0 102 0.0 .0 direct path sync 3 0 0 75 0.0 .0 control file sequential re 2,267 0 0 0 0.1 .0 latch: row cache objects 58 0 0 2 0.0 .0 library cache: mutex X 37 0 0 4 0.0 .0 reliable message 161 0 0 1 0.0 .0 direct path read temp 95 0 0 1 0.0 .0 latch: cache buffers chain 112 0 0 1 0.0 .0 SQL*Net more data from cli 1,955 0 0 0 0.1 .0 ADR block file write 10 0 0 5 0.0 .0 latch: cache buffers lru c 8 0 0 6 0.0 .0 latch: shared pool 33 0 0 1 0.0 .0 latch: enqueue hash chains 1 0 0 22 0.0 .0 SQL*Net message to dblink 2,899 0 0 0 0.2 .0 rdbms ipc reply 38 0 0 0 0.0 .0 SQL*Net more data to dblin 123 0 0 0 0.0 .0 latch free 8 0 0 1 0.0 .0 SQL*Net more data from dbl 4 0 0 1 0.0 .0 latch: object queue header 4 0 0 1 0.0 .0 SQL*Net message from clien 544,332 0 891,457 1638 30.7 jobq slave wait 16,313 100 8,142 499 0.9 wait for unread message on 7,325 98 7,217 985 0.4 Streams AQ: waiting for me 1,446 100 7,215 4990 0.1 pipe get 1,601 92 6,976 4357 0.1 single-task message 43 0 35 805 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: PROD/Prod Snaps: 476-478 -> 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 15,967 0 230 14 0.9 43.5 db file parallel write 9,114 0 107 12 0.5 20.3 control file parallel writ 2,486 0 83 33 0.1 15.6 os thread startup 265 0 24 89 0.0 4.5 row cache lock 2 50 9 4275 0.0 1.6 db file sequential read 3,920 0 6 1 0.2 1.1 SQL*Net break/reset to cli 576 0 5 8 0.0 .9 log file sequential read 54 0 4 73 0.0 .7 log file sync 6 0 1 133 0.0 .2 control file sequential re 10,443 0 1 0 0.6 .1 db file scattered read 506 0 1 1 0.0 .1 log buffer space 1 0 0 466 0.0 .1 SQL*Net more data from cli 328 0 0 1 0.0 .1 direct path write 11 0 0 24 0.0 .0 direct path sync 3 0 0 44 0.0 .0 db file single write 2 0 0 64 0.0 .0 log file single write 6 0 0 17 0.0 .0 Disk file operations I/O 337 0 0 0 0.0 .0 ADR block file read 26 0 0 3 0.0 .0 ADR block file write 10 0 0 5 0.0 .0 direct path read 6 0 0 6 0.0 .0 db file parallel read 2 0 0 16 0.0 .0 Data file init write 2 0 0 14 0.0 .0 LGWR wait for redo copy 163 0 0 0 0.0 .0 SQL*Net more data to clien 328 0 0 0 0.0 .0 SQL*Net message to client 8,608 0 0 0 0.5 .0 asynch descriptor resize 2,725 100 0 0 0.2 .0 Log archive I/O 3 0 0 4 0.0 .0 reliable message 14 0 0 1 0.0 .0 rdbms ipc reply 16 0 0 1 0.0 .0 latch: cache buffers lru c 12 0 0 1 0.0 .0 latch free 12 0 0 0 0.0 .0 rdbms ipc message 48,797 62 114,938 2355 2.8 DIAG idle wait 14,393 100 14,394 1000 0.8 Streams AQ: qmn slave idle 1,002 0 14,393 14364 0.1 Streams AQ: waiting for ti 16 50 8,359 522427 0.0 shared server idle wait 241 100 7,230 30001 0.0 Space Manager: slave idle 1,462 98 7,223 4940 0.1 pmon timer 3,231 74 7,216 2233 0.2 smon timer 36 64 7,212 200323 0.0 dispatcher timer 120 100 7,200 60001 0.0 Streams AQ: qmn coordinato 686 37 7,196 10490 0.0 SQL*Net message from clien 11,060 0 72 7 0.6 class slave wait 24 0 0 1 0.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: PROD/Prod Snaps: 476-478 -> 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 -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ADR block file read 152 32.9 5.9 13.2 39.5 7.9 .7 ADR block file write 20 10.0 90.0 ADR file lock 24 100.0 ARCH wait for archivelog l 3 100.0 Data file init write 2 100.0 Disk file operations I/O 6677 99.8 .1 .0 .0 .1 .0 LGWR wait for redo copy 163 98.2 .6 .6 .6 Log archive I/O 3 33.3 66.7 SQL*Net break/reset to cli 9186 98.9 .6 .2 .1 .1 .0 .0 .0 SQL*Net message from dblin 2942 21.5 77.0 1.6 SQL*Net message to client 552.9 100.0 .0 .0 .0 SQL*Net message to dblink 2899 100.0 SQL*Net more data from cli 2283 87.8 11.9 .3 SQL*Net more data from dbl 4 50.0 50.0 SQL*Net more data to clien 31.3K 99.9 .0 .0 .0 .0 SQL*Net more data to dblin 123 100.0 asynch descriptor resize 1233. 100.0 .0 buffer busy waits 26 84.6 3.8 3.8 3.8 3.8 control file parallel writ 2599 .7 72.7 26.6 control file sequential re 12.7K 99.9 .0 .0 .0 .0 .0 .0 cursor: mutex S 1 100.0 cursor: pin S 1 100.0 cursor: pin S wait on X 28 60.7 10.7 28.6 db file parallel read 6570 89.4 3.4 1.2 1.6 3.0 .6 .7 db file parallel write 9115 28.9 2.6 4.6 22.4 24.7 9.4 7.3 db file scattered read 213.7 97.9 1.5 .2 .2 .1 .1 .1 db file sequential read 1474. 98.6 .1 .1 .7 .3 .1 .1 db file single write 34 44.1 44.1 11.8 direct path read 320 91.9 .6 1.6 .6 2.2 1.9 1.3 direct path read temp 95 91.6 1.1 1.1 4.2 1.1 1.1 direct path sync 6 16.7 16.7 66.7 direct path write 11 9.1 9.1 9.1 18.2 27.3 27.3 direct path write temp 96 4.2 1.0 4.2 8.3 17.7 38.5 26.0 enq: RO - fast object reus 148 43.2 4.7 52.0 enq: TC - contention 7 14.3 85.7 enq: TX - row lock content 52 3.8 1.9 3.8 7.7 5.8 38.5 38.5 latch free 20 95.0 5.0 latch: cache buffer handle 3 100.0 latch: cache buffers chain 113 96.5 .9 .9 1.8 latch: cache buffers lru c 20 85.0 5.0 5.0 5.0 latch: call allocation 5 100.0 latch: checkpoint queue la 1 100.0 latch: enqueue hash chains 1 100.0 latch: object queue header 4 75.0 25.0 latch: row cache objects 58 94.8 1.7 1.7 1.7 latch: session allocation 1 100.0 latch: shared pool 35 85.7 2.9 8.6 2.9 library cache lock 4 25.0 25.0 25.0 25.0 library cache: mutex X 37 73.0 2.7 10.8 5.4 8.1 local write wait 834 38.1 54.7 7.2 log buffer space 8 12.5 12.5 75.0 log file parallel write 16K .0 .1 1.2 42.6 41.6 8.2 6.3 log file sequential read 54 37.0 1.9 1.9 1.9 57.4 log file single write 6 16.7 16.7 66.7 log file switch completion 3 100.0 log file sync 7140 .2 .5 3.4 37.2 36.7 11.5 10.4 .0 os thread startup 265 100.0 rdbms ipc reply 54 96.3 1.9 1.9 read by other session 1479 90.7 2.0 .7 4.2 1.9 .3 .1 reliable message 175 96.6 1.1 1.1 .6 .6 Wait Event Histogram DB/Inst: PROD/Prod Snaps: 476-478 -> 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 -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- row cache lock 1698 .6 .2 .3 .4 .2 .1 7.1 91.1 DIAG idle wait 14.4K 100.0 SQL*Net message from clien 555.3 90.2 2.2 1.3 .4 .5 .4 3.0 2.0 Space Manager: slave idle 1462 .3 .1 .3 99.3 Streams AQ: qmn coordinato 686 62.5 37.5 Streams AQ: qmn slave idle 1001 48.8 51.2 Streams AQ: waiting for me 1447 .1 99.9 Streams AQ: waiting for ti 16 25.0 25.0 50.0 class slave wait 24 95.8 4.2 dispatcher timer 120 100.0 jobq slave wait 16.3K .0 .0 .0 100.0 pipe get 1600 .1 1.7 98.3 pmon timer 3231 24.6 .6 .1 .1 .0 .0 74.4 rdbms ipc message 48.8K 9.6 .5 1.1 3.1 3.2 2.6 32.1 47.8 shared server idle wait 241 100.0 single-task message 43 81.4 18.6 smon timer 36 22.2 77.8 wait for unread message on 7325 .4 99.6 ------------------------------------------------------------- Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: PROD/Prod Snaps: 476- -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second) -> % of Total Waits: total waits for all wait classes, including Idle -> % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0 -> Ordered by Event (only non-idle events are displayed) % of Total Waits ----------------------------------------------- Waits 64ms Event to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- SQL*Net break/reset to cli 1 100.0 .0 .0 SQL*Net message from dblin 2264 21.5 37.2 33.5 5.6 .1 .5 1.6 control file parallel writ 692 73.4 23.5 2.2 .8 .1 control file sequential re 2 100.0 .0 cursor: pin S wait on X 5 60.7 3.6 3.6 3.6 7.1 21.4 db file parallel read 48 99.3 .4 .2 .1 .0 .0 db file parallel write 669 92.7 4.7 2.0 .5 .1 .0 db file scattered read 172 99.9 .0 .0 .0 .0 .0 db file sequential read 1127 99.9 .0 .0 .0 .0 .0 db file single write 4 88.2 8.8 2.9 direct path read 4 98.8 1.3 direct path sync 4 33.3 16.7 50.0 direct path write 3 72.7 18.2 9.1 direct path write temp 25 74.0 14.6 11.5 enq: RO - fast object reus 77 48.0 37.8 10.8 1.4 1.4 .7 enq: TC - contention 6 14.3 57.1 28.6 enq: TX - row lock content 23 23.1 3.8 17.3 1.9 13.5 1.9 5.8 32.7 latch: cache buffers lru c 1 95.0 5.0 latch: row cache objects 1 98.3 1.7 library cache lock 1 75.0 25.0 local write wait 60 92.8 4.7 2.3 .1 .1 log buffer space 6 25.0 25.0 12.5 12.5 25.0 log file parallel write 1005 93.7 3.6 1.9 .5 .2 .0 log file sequential read 31 42.6 3.7 42.6 7.4 3.7 log file switch completion 3 33.3 33.3 33.3 log file sync 743 89.6 5.7 3.1 1.1 .4 .1 .0 os thread startup 265 97.4 2.6 read by other session 2 99.9 .1 row cache lock 253 1.8 .4 .6 .5 1.8 3.8 7.8 83.3 ------------------------------------------------------------- Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: PROD/Prod Snaps: 476-47 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) -> % of Total Waits: total waits for all wait classes, including Idle -> % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0 -> Ordered by Event (only non-idle events are displayed) % of Total Waits ----------------------------------------------- Waits 4s Event to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- SQL*Net break/reset to cli 1 100.0 .0 SQL*Net message from dblin 46 98.4 1.4 .1 .1 buffer busy waits 1 96.2 3.8 cursor: pin S wait on X 6 78.6 10.7 10.7 enq: TX - row lock content 17 67.3 5.8 9.6 15.4 1.9 row cache lock 1414 16.7 19.5 36.3 27.3 .2 ------------------------------------------------------------- Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Service Statistics DB/Inst: PROD/Prod Snaps: 476-478 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K) ---------------------------- ------------ ------------ ------------ ------------ Prod.airlinehyd.com 14,806 3,165 2,041 56,186 SYS$USERS 3,269 1,524 983 33,949 ProdXDB 0 0 0 0 SYS$BACKGROUND 0 0 10 79 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: PROD/Prod Snaps: 476-478 -> 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 --------- --------- --------- --------- --------- --------- --------- --------- Prod.airlinehyd.com 1244691 223 1701 8369 0 0 96490 284 SYS$USERS 455338 147 294 1437 0 0 486772 111 SYS$BACKGROUND 4775 7 270 32 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: PROD/Prod Snaps: 476-478 -> 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 - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 42.1% of Total DB Time (s): 18,073 -> Captured PL/SQL account for 39.1% of Total DB Time (s): 18,073 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- 1,688.0 1,300 1.30 9.3 .1 .0 2b8rundyd40jd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FUNC_CONTRACT_PRC_CHECK('',:B2 ,:B1 ,'QUOTE') FROM S.DUAL 1,218.6 384 3.17 6.7 45.7 2.3 anrjzw7r3fqqd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 994.2 1,633 0.61 5.5 4.3 .0 1szvs2fs58tw9 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FUNC_GET_CALC_PRICE(:B13 ,:B12 ,:B11 , :B10 ,:B9 ,:B8 , :B7 ,:B6 ,:B5 , : B4 , DECODE(NVL(:B3 ,'~'),'N',:B2 ,:B1 )) FROM S.DUAL 661.8 141 4.69 3.7 3.1 .2 1puuzrh2y9aas Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 585.2 413 1.42 3.2 95.3 2.7 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 495.6 335 1.48 2.7 20.1 1.1 ayaf3bbdabmbn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 479.1 31 15.45 2.7 98.1 .0 gmhfq16tr7nch Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 476.2 31 15.36 2.6 97.7 .1 3q8vccjyfjqg1 Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 440.4 235 1.87 2.4 1.9 .2 2q5t5dapfd2tk Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 419.6 254 1.65 2.3 7.7 .1 1ufjdctj705k5 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SQL ordered by Elapsed Time DB/Inst: PROD/Prod Snaps: 476-478 -> 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 - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 42.1% of Total DB Time (s): 18,073 -> Captured PL/SQL account for 39.1% of Total DB Time (s): 18,073 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 378.8 73 5.19 2.1 25.2 1.7 5k3q8y28x3xbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 364.7 944 0.39 2.0 1.2 .2 gf4ur2p266cmw Module: SQL*Plus UPDATE S.PENDING_INVENTORY_TRANSACTION P SET P.TRAN_QUANTITY = NVL(P.TRAN_QUANTI TY,0)+ NVL(:B1 ,0) - NVL(:B2 ,0) WHERE (P.MFG_ITEM_NO, P.MFG_CODE, P.CENTRAL_IT_ KEY,TRAN_TYPE, STATUS, TRUNC(TRAN_DATE)) IN ( SELECT IPS.MFG_ITEM_NO, IPS.MFG_CO DE, IT.CENTRAL_IT_KEY,'RQ','N',TRUNC(SYSDATE) FROM S.ITEM_PURCHASE_SOURCE IPS, S 359.6 208 1.73 2.0 .1 .0 7cwxyvk3yc1j0 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FUNC_CONTRACT_PRC_CHECK(:B3 ,:B2 ,:B1 ,'SHOPCART') FROM S.DUAL 334.6 161 2.08 1.9 4.7 .1 64wrbuf75gz29 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 311.9 52 6.00 1.7 42.1 6.7 8am8fmqz8pdpy Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 304.5 275 1.11 1.7 8.5 .6 8rr8w1r0kcxcd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 296.0 752 0.39 1.6 1.9 .5 2w3rc665nqqnn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) UPDATE S.SHIPMENT_SCHEDULE SET CUSTOMER_ACKNOWLEDGEMENT_DATE = DECODE(:B9 ,'Y',: B10 ,NVL(:B10 ,CUSTOMER_ACKNOWLEDGEMENT_DATE)), CUSTOMER_ACKNOWLEDGEMENT_NO = DE CODE(:B9 ,'Y',NVL(CUSTOMER_ACKNOWLEDGEMENT_NO,0)+1,CUSTOMER_ACKNOWLEDGEMENT_NO), QUOTED_DELIVERY_DATE = DECODE(:B8 ,'Y',DECODE(:B7 ,1,DECODE(:B6 ,'Y',NVL(:B5 ,Q 289.6 448 0.65 1.6 3.4 .9 cbhuamyt2gnn0 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 279.4 172 1.62 1.5 5.6 .2 4q81677k4uywt Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SQL ordered by Elapsed Time DB/Inst: PROD/Prod Snaps: 476-478 -> 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 - Elapsed Time as a percentage of Total DB time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 42.1% of Total DB Time (s): 18,073 -> Captured PL/SQL account for 39.1% of Total DB Time (s): 18,073 Elapsed Elapsed Time Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id ---------------- -------------- ------------- ------ ------ ------ ------------- declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 276.0 322 0.86 1.5 1.3 .5 14nu2rmyjb65z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 257.2 625 0.41 1.4 1.0 .4 8bk0cqsp3y3z0 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) UPDATE S.INVENTORY_REQUIREMENTS TRIG_IR SET TRIG_IR.REQUIREMENTS = GREATEST(NVL( TRIG_IR.REQUIREMENTS,0) - NVL(:B3 ,0),0) WHERE TRIG_IR.ITEM_KEY = :B2 AND TRIG_I R.INVENTORY_TRANSLATION_KEY = :B1 246.2 2,779 0.09 1.4 6.7 .0 1jc1ymz5qq44z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DECODE( :B2 , 'R', DECODE( RUSH_VALUE, NULL, DECODE( PRICE_FACTOR_TYPE, ' $', DECODE(:B3 , 'N',SOURCE_NAME, 'D',DECODE(:B2 , 'E', DECODE(EMERGENCY_VALUE,N ULL,'LIST-PRICE',SOURCE_NAME), SOURCE_NAME), SOURCE_NAME), 'D', DECODE(:B3 , 'N' ,SOURCE_NAME, 'D',DECODE(:B2 , 'E', DECODE(EMERGENCY_VALUE,NULL,'LIST-PRICE',SOU 236.0 51 4.63 1.3 4.7 .1 dbdzfck6t4t2d Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 221.8 115 1.93 1.2 14.2 3.2 fhzjzjznbd91p Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 216.1 57 3.79 1.2 2.3 .4 28gy2qwwqqyxa Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 198.0 1 198.02 1.1 97.5 .0 51bbkcd9zwsjw Module: emagent_SQL_oracle_database /* OracleOEM */ with max1 as (select :1 as select_tab,:2 as select_priv fr om dual) select 'select_any_table', substr(SYS_CONNECT_BY_PATH(c, '->'),3,512) path, c from ( select null p, name c from system_priv ilege_map where name = 'SELECT ANY TABLE' union select granted_ ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 63.4% of Total CPU Time (s): 4,688 -> Captured PL/SQL account for 30.5% of Total CPU Time (s): 4,688 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 557.9 413 1.35 11.9 585.2 95.3 2.7 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 557.4 384 1.45 11.9 1,218.6 45.7 2.3 anrjzw7r3fqqd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 470.0 31 15.16 10.0 479.1 98.1 .0 gmhfq16tr7nch Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 465.4 31 15.01 9.9 476.2 97.7 .1 3q8vccjyfjqg1 Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 193.1 1 193.11 4.1 198.0 97.5 .0 51bbkcd9zwsjw Module: emagent_SQL_oracle_database /* OracleOEM */ with max1 as (select :1 as select_tab,:2 as select_priv fr om dual) select 'select_any_table', substr(SYS_CONNECT_BY_PATH(c, '->'),3,512) path, c from ( select null p, name c from system_priv ilege_map where name = 'SELECT ANY TABLE' union select granted_ 148.2 8 18.53 3.2 150.6 98.4 .1 5k2b3qsy3b30r Module: emagent_SQL_oracle_database /* OracleOEM */ WITH blocked_resources AS (select id1 ,id2 ,SUM(ctime) as blocked_secs ,MAX(request) as max_request ,COUN T(1) as blocked_count from v$lock where request > 0 g roup by id1,id2 ) ,blockers AS (select L.* ,BR.blocked_se 132.3 79 1.67 2.8 137.8 96.0 7.9 1rqjjgzn8k7wc Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT PSSF.FORMID FROM S.SHIPMENT_SCHEDULE S, S.INVENTORY_TRANSLATION I, S.INSTALLATION_CONTROL IC, S.INSTALLATION_CONTROL IC2, S.INSTALLATION_CONTROL IC3, S.PD_SITE_SPECIFIC_FORM PSSF, S.SALES_ORDER_HEADER H, S.SALES_ORDER_DETAIL D WHERE H.PRINT_PK_LIST||'' IN ('Y','H') AND H.STATUS||'' = 'O' AND H.MAJOR_TYP 131.3 52 2.52 2.8 311.9 42.1 6.7 8am8fmqz8pdpy Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 118.5 40 2.96 2.5 123.5 96.0 9.5 g9t0gypcnh55g Module: ? @atlas (TNS interface) insert into s.work_pk016(formid,order_number,packing_list_number,address_key,pri ce_pk_list,order_priority,process_flag,customer_key)select distinct pssf.formid, SQL ordered by CPU Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 63.4% of Total CPU Time (s): 4,688 -> Captured PL/SQL account for 30.5% of Total CPU Time (s): 4,688 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- to_char(h.order_number),to_char(nvl(s.packing_list_number,0)),nvl(h.ship_to_addr ess_key,h.bill_to_address_key),decode(h.price_pk_list,'Y',0,5),nvl(h.order_prior 118.1 112 1.05 2.5 124.3 95.0 1.0 aux609pms79y1 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) UPDATE S.COMPLETION_SCHEDULE A SET A.BUILD_QTY = (SELECT TRUNC(MIN(SUM(DECODE(B. STATUS,'H',NVL(B.QTY_ISSUED,0),NVL(B.ISSUE_QTY,0))) /MAX(NVL(C.QUANTITY_PER_UNIT ,1)))) FROM S.ISSUE_SCHEDULE B, S.WORK_ORDER_DETAIL C, S.WORK_ORDER_HEADER D WHE RE A.KEY = D.COMPLETION_SCHEDULE_KEY AND D.MAJOR_TYPE = C.MAJOR_TYPE AND D.ORDER 99.8 335 0.30 2.1 495.6 20.1 1.1 ayaf3bbdabmbn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 95.5 73 1.31 2.0 378.8 25.2 1.7 5k3q8y28x3xbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 90.7 2 45.34 1.9 169.0 53.7 3.5 gp6r0y60qpdkt Module: SQL*Plus begin dbms_stats.gather_schema_stats(ownname=>'S', options=>'GATHER STAL E'); end; 78.4 31 2.53 1.7 81.9 95.7 .4 7a58g2qswr5f6 Module: WorldShipTD.exe select null, co.owner, co.table_name, co.column_name, decode(data_type, 'CHAR', 1, 'DATE', 11, 'FLOAT', 8, 'LONG', -1, 'LONG RAW', -4, 'NUMBER', 3, 'RAW', -3, ' VARCHAR2', 12, 'ROWID', 1, 0), data_type, decode(data_type, 'DATE', 19, 'FLOAT', 15, 'LONG', 2147483647, 'LONG RAW', 2147483647, 'ROWID', 18, 'NUMBER', decode(d 72.0 396 0.18 1.5 84.9 84.8 17.9 6t3dcd7h9g72z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 67.8 10 6.78 1.4 69.2 98.1 2.2 977u7sq9147ud Module: WorldShipTD.exe select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 67.1 10 6.71 1.4 69.2 96.9 .1 f1d6vzx9mjuxs Module: WorldShipTD.exe select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 62.7 108 0.58 1.3 67.4 93.1 10.0 1ky5ca7xd90pa Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT KEY FROM S.SHIPMENT_SCHEDULE SS, S.SALES_ORDER_DETAIL SOD, S.PUR SQL ordered by CPU Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - CPU Time as a percentage of Total DB CPU -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 63.4% of Total CPU Time (s): 4,688 -> Captured PL/SQL account for 30.5% of Total CPU Time (s): 4,688 CPU CPU per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- CHASE_ORDER_DETAIL POD WHERE SS.KEY = SOD.SHIPMENT_SCHEDULE_KEY+0 AND SOD.STATUS = 'O' AND SOD.HANDLING_CODE IN('N','R','E') AND SOD.PO_NUMBER = POD.ORDER_NUMBE R AND POD.STATUS = 'H' AND ((SS.QTY_SHIPPED = 0 AND NVL(SS.STATUS,'O') = 'O') OR 57.4 54 1.06 1.2 61.1 93.9 8.1 apv7p30a8rmx3 Module: f45run@atlas (TNS V1-V2) SELECT ORDER_NUMBER,REFERENCE_NO,CUSTOMER_PO_NUMBER,ORDER_DATE,MARK,CUSTOMER_KEY ,ENTERED_BY_USER_INITIALS_KEY,CO_STRUCTURE_RELATION_KEY,BILL_TO_ADDRESS_KEY,SHIP _TO_ADDRESS_KEY,OUR_CONTACT_USER_INITIALS_KEY,ORDERED_BY,LAST_INVOICE_DATE,LAST_ INVOICE_NO,BILL_TO_ATTENTION,SHIP_TO_ATTENTION,STATUS,SUB_STATUS,SO_TYPE,PRINT_A 51.0 2,941 0.02 1.1 118.8 43.0 .2 51xt4r344ffw2 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT CUST_PRICING_CLASS FROM S.CUST_PRICING_CLS_PROD_TYPE_OVR WHERE CUSTOMER_K EY = :B1 AND VENDOR_PRODUCT_TYPE IN (SELECT NVL(I.PRODUCT_TYPE, V.VENDOR_PRODUCT _TYPE) FROM S.ITEM I, S.VENDOR V WHERE I.KEY = :B2 AND V.KEY(+) = I.PRIMARY_PURC HASE_SOURCE) AND ROWNUM = 1 ------------------------------------------------------------- SQL ordered by User I/O Wait Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 28.7% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 31.7% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- 28.4 384 0.07 7.6 1,218.6 45.7 2.3 anrjzw7r3fqqd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 20.9 52 0.40 5.6 311.9 42.1 6.7 8am8fmqz8pdpy Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 15.9 413 0.04 4.2 585.2 95.3 2.7 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 15.2 396 0.04 4.0 84.9 84.8 17.9 6t3dcd7h9g72z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 11.7 40 0.29 3.1 123.5 96.0 9.5 g9t0gypcnh55g Module: ? @atlas (TNS interface) insert into s.work_pk016(formid,order_number,packing_list_number,address_key,pri ce_pk_list,order_priority,process_flag,customer_key)select distinct pssf.formid, to_char(h.order_number),to_char(nvl(s.packing_list_number,0)),nvl(h.ship_to_addr ess_key,h.bill_to_address_key),decode(h.price_pk_list,'Y',0,5),nvl(h.order_prior 10.9 79 0.14 2.9 137.8 96.0 7.9 1rqjjgzn8k7wc Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT PSSF.FORMID FROM S.SHIPMENT_SCHEDULE S, S.INVENTORY_TRANSLATION I, S.INSTALLATION_CONTROL IC, S.INSTALLATION_CONTROL IC2, S.INSTALLATION_CONTROL IC3, S.PD_SITE_SPECIFIC_FORM PSSF, S.SALES_ORDER_HEADER H, S.SALES_ORDER_DETAIL D WHERE H.PRINT_PK_LIST||'' IN ('Y','H') AND H.STATUS||'' = 'O' AND H.MAJOR_TYP 10.6 504 0.02 2.8 16.4 75.5 64.9 d9khn5yjabbp6 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'NO CONTACT' CONTACT, DECODE('~', :B1 ,'Y') SELECTED, 1 FROM S.DUAL UNION SELECT 'ALL' CONTACT, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SEL ECT DISTINCT CT.FORMAL_NAME, DECODE(CT.FORMAL_NAME,REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 9.0 52 0.17 2.4 45.5 84.5 19.9 d2zxpdg93y57n Module: ? @atlas (TNS interface) select distinct pssf.formid,to_char(hdr.order_number),hdr.major_type,inv2.pull_t icket_printer_code,decode(hdr.print_pull_ticket,'R','Y','N'),decode(hdr.print_pu ll_ticket,'R',to_char(iss.pt_number),'0'),nvl(hdr.pull_complete,'N'),to_char(dtl .inventory_translation_key)from s.installation_control ic,s.pd_site_specific_for 8.1 1 8.11 2.2 19.9 64.3 40.7 g141z6ydfkk14 Module: SQL*Plus Declare preallocate_NB_dates varchar2(1); reserve_credit_hold varchar2(1) ; reserve_quotes varchar2(1); lead_time_mult number :=0; bal SQL ordered by User I/O Wait Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 28.7% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 31.7% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- ance_on_hand number :=0; std_dev_on_lt number :=0; buy_lt number :=0; req_std_dev_mult number :=0; local_ship_complete 7.0 115 0.06 1.9 221.8 14.2 3.2 fhzjzjznbd91p Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 6.7 108 0.06 1.8 67.4 93.1 10.0 1ky5ca7xd90pa Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT KEY FROM S.SHIPMENT_SCHEDULE SS, S.SALES_ORDER_DETAIL SOD, S.PUR CHASE_ORDER_DETAIL POD WHERE SS.KEY = SOD.SHIPMENT_SCHEDULE_KEY+0 AND SOD.STATUS = 'O' AND SOD.HANDLING_CODE IN('N','R','E') AND SOD.PO_NUMBER = POD.ORDER_NUMBE R AND POD.STATUS = 'H' AND ((SS.QTY_SHIPPED = 0 AND NVL(SS.STATUS,'O') = 'O') OR 6.5 73 0.09 1.7 378.8 25.2 1.7 5k3q8y28x3xbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 6.2 2,720 0.00 1.6 13.9 71.0 44.2 6z8r7gd3atg1b Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'S' ORDER_TYPE, SOD.ORDER_NUMBER ORDER_NUMBER, SOD.SEQ_NUMBER SEQ_NUMBER, DECODE(SOD.STATUS, 'P',DECODE(SS.PACKING_LIST_NUMBER,'',NVL(SS.QTY_TO_SHIP,0), (NVL(SS.QTY_TO_SHIP,0) - NVL(SS.SHIP_QTY,0))), 'S',DECODE(SS.PACKING_LIST_NUMBER ,'',NVL(SS.QTY_TO_SHIP,0), NVL(SS.QTY_BACKORDERED,0)), 'I',DECODE(SS.PACKING_LIS 6.1 18 0.34 1.6 70.0 46.5 8.7 0u12awcsgp93a Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 5.9 2 2.96 1.6 169.0 53.7 3.5 gp6r0y60qpdkt Module: SQL*Plus begin dbms_stats.gather_schema_stats(ownname=>'S', options=>'GATHER STAL E'); end; 5.6 335 0.02 1.5 495.6 20.1 1.1 ayaf3bbdabmbn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 5.0 54 0.09 1.3 61.1 93.9 8.1 apv7p30a8rmx3 Module: f45run@atlas (TNS V1-V2) SELECT ORDER_NUMBER,REFERENCE_NO,CUSTOMER_PO_NUMBER,ORDER_DATE,MARK,CUSTOMER_KEY ,ENTERED_BY_USER_INITIALS_KEY,CO_STRUCTURE_RELATION_KEY,BILL_TO_ADDRESS_KEY,SHIP _TO_ADDRESS_KEY,OUR_CONTACT_USER_INITIALS_KEY,ORDERED_BY,LAST_INVOICE_DATE,LAST_ INVOICE_NO,BILL_TO_ATTENTION,SHIP_TO_ATTENTION,STATUS,SUB_STATUS,SO_TYPE,PRINT_A 4.9 64 0.08 1.3 50.4 74.4 9.7 22mym4knbqv79 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT C.CUSTOMER CUSTOMER , CREATED_BY , WSQ.QUOTE_NUMBER QUOTE_NUMBER , CON.FO SQL ordered by User I/O Wait Time DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - User I/O Time as a percentage of Total User I/O Wait time -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Captured SQL account for 28.7% of Total User I/O Wait Time (s): -> Captured PL/SQL account for 31.7% of Total User I/O Wait Time (s): User I/O UIO per Elapsed Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id ---------- ------------ ---------- ------ ---------- ------ ------ ------------- RMAL_NAME , INTERNAL_EXTERNAL , NOTES , WSQ.ENTRY_DATE ENTRY_DATE , DECODE(NVL(C ONVERTED_TO_ORDER,'N'),'Y','Yes','No') CONVERTED_TO_ORDER, C.NAME CUST_NAME, DEC ODE(NVL(:B1 ,'~'),'Q',WSQ.QUOTE_NUMBER,TO_NUMBER(NULL)) SORT1, DECODE(NVL(:B1 ,' 4.3 124 0.03 1.1 11.2 77.0 38.5 dkvsyf8ka7h06 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT CUSTOMER, NAME CUST_NAME, TO_CHAR(CO_CODE)||'-'||TO_CHAR(AREA_CODE)||'-'| | TO_CHAR(DIV_CODE)||'-'||TO_CHAR(SLS_CODE) STR_CHAIN, A.ADDRESS_LINE1||HTF.BR|| A.ADDRESS_LINE2 ADDINFO, A.CITY CITY, A.STATE STATE, A.ZIP_CODE ZIPCODE , CSR.SL S_NAME SLS_NAME, A.TYPE, (NVL(BALANCE_ON_ORDER,0) + NVL(BALANCE_ON_HOLD,0) + NVL 3.9 11 0.35 1.0 5.1 37.0 76.5 5zj484fyq0s87 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT SPO.PURCHASE_CLASS, DECODE(SPO.SHIP_TYPE,'D','Direct','N','Nonstock','S', 'Stock') SHIP_TYPE, SPO.FOR_ORDER_NUMBER, SPO.FOR_ORDER_SEQ_NO, NVL(SOD.MFG_PART _NO,NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER)) ITEM_NUMBER, NVL(WORK.RECEIPT_DATE,SPO.R ECEIPT_DATE) RECEIPT_DATE, TO_CHAR(SPO.ORIGINAL_RECEIPT_DATE,'sssss') RECEIPT_DA ------------------------------------------------------------- SQL ordered by Gets DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 90,212,126 -> Captured SQL account for 78.0% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ------ ------ ----------- 15,593,457 1 1.559346E+07 17.3 198.0 97.5 .0 51bbkcd9zws Module: emagent_SQL_oracle_database /* OracleOEM */ with max1 as (select :1 as select_tab,:2 as select_priv fr om dual) select 'select_any_table', substr(SYS_CONNECT_BY_PATH(c, '->'),3,512) path, c from ( select null p, name c from system_priv ilege_map where name = 'SELECT ANY TABLE' union select granted_ 10,173,637 384 26,493.8 11.3 1,218.6 45.7 2.3 anrjzw7r3fq Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 10,036,219 31 323,749.0 11.1 81.9 95.7 .4 7a58g2qswr5 Module: WorldShipTD.exe select null, co.owner, co.table_name, co.column_name, decode(data_type, 'CHAR', 1, 'DATE', 11, 'FLOAT', 8, 'LONG', -1, 'LONG RAW', -4, 'NUMBER', 3, 'RAW', -3, ' VARCHAR2', 12, 'ROWID', 1, 0), data_type, decode(data_type, 'DATE', 19, 'FLOAT', 15, 'LONG', 2147483647, 'LONG RAW', 2147483647, 'ROWID', 18, 'NUMBER', decode(d 10,030,139 413 24,286.1 11.1 585.2 95.3 2.7 4snhz2djjh9 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 5,290,962 10 529,096.2 5.9 69.2 96.9 .1 f1d6vzx9mju Module: WorldShipTD.exe select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 5,290,961 10 529,096.1 5.9 69.2 98.1 2.2 977u7sq9147 Module: WorldShipTD.exe select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 5,144,769 54 95,273.5 5.7 61.1 93.9 8.1 apv7p30a8rm Module: f45run@atlas (TNS V1-V2) SELECT ORDER_NUMBER,REFERENCE_NO,CUSTOMER_PO_NUMBER,ORDER_DATE,MARK,CUSTOMER_KEY ,ENTERED_BY_USER_INITIALS_KEY,CO_STRUCTURE_RELATION_KEY,BILL_TO_ADDRESS_KEY,SHIP _TO_ADDRESS_KEY,OUR_CONTACT_USER_INITIALS_KEY,ORDERED_BY,LAST_INVOICE_DATE,LAST_ INVOICE_NO,BILL_TO_ATTENTION,SHIP_TO_ATTENTION,STATUS,SUB_STATUS,SO_TYPE,PRINT_A 2,460,712 52 47,321.4 2.7 311.9 42.1 6.7 8am8fmqz8pd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 2,234,352 79 28,282.9 2.5 137.8 96.0 7.9 1rqjjgzn8k7 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT PSSF.FORMID FROM S.SHIPMENT_SCHEDULE S, S.INVENTORY_TRANSLATION I, S.INSTALLATION_CONTROL IC, S.INSTALLATION_CONTROL IC2, S.INSTALLATION_CONTROL SQL ordered by Gets DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 90,212,126 -> Captured SQL account for 78.0% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ------ ------ ----------- IC3, S.PD_SITE_SPECIFIC_FORM PSSF, S.SALES_ORDER_HEADER H, S.SALES_ORDER_DETAIL D WHERE H.PRINT_PK_LIST||'' IN ('Y','H') AND H.STATUS||'' = 'O' AND H.MAJOR_TYP 2,114,022 31 68,194.3 2.3 479.1 98.1 .0 gmhfq16tr7n Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 2,114,021 31 68,194.2 2.3 476.2 97.7 .1 3q8vccjyfjq Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 1,754,548 40 43,863.7 1.9 123.5 96.0 9.5 g9t0gypcnh5 Module: ? @atlas (TNS interface) insert into s.work_pk016(formid,order_number,packing_list_number,address_key,pri ce_pk_list,order_priority,process_flag,customer_key)select distinct pssf.formid, to_char(h.order_number),to_char(nvl(s.packing_list_number,0)),nvl(h.ship_to_addr ess_key,h.bill_to_address_key),decode(h.price_pk_list,'Y',0,5),nvl(h.order_prior 1,536,816 108 14,229.8 1.7 67.4 93.1 10.0 1ky5ca7xd90 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT KEY FROM S.SHIPMENT_SCHEDULE SS, S.SALES_ORDER_DETAIL SOD, S.PUR CHASE_ORDER_DETAIL POD WHERE SS.KEY = SOD.SHIPMENT_SCHEDULE_KEY+0 AND SOD.STATUS = 'O' AND SOD.HANDLING_CODE IN('N','R','E') AND SOD.PO_NUMBER = POD.ORDER_NUMBE R AND POD.STATUS = 'H' AND ((SS.QTY_SHIPPED = 0 AND NVL(SS.STATUS,'O') = 'O') OR 1,477,194 335 4,409.5 1.6 495.6 20.1 1.1 ayaf3bbdabm Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 1,323,454 52 25,451.0 1.5 45.5 84.5 19.9 d2zxpdg93y5 Module: ? @atlas (TNS interface) select distinct pssf.formid,to_char(hdr.order_number),hdr.major_type,inv2.pull_t icket_printer_code,decode(hdr.print_pull_ticket,'R','Y','N'),decode(hdr.print_pu ll_ticket,'R',to_char(iss.pt_number),'0'),nvl(hdr.pull_complete,'N'),to_char(dtl .inventory_translation_key)from s.installation_control ic,s.pd_site_specific_for 1,304,498 73 17,869.8 1.4 378.8 25.2 1.7 5k3q8y28x3x Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 1,161,554 2,941 395.0 1.3 118.8 43.0 .2 51xt4r344ff Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT CUST_PRICING_CLASS FROM S.CUST_PRICING_CLS_PROD_TYPE_OVR WHERE CUSTOMER_K EY = :B1 AND VENDOR_PRODUCT_TYPE IN (SELECT NVL(I.PRODUCT_TYPE, V.VENDOR_PRODUCT _TYPE) FROM S.ITEM I, S.VENDOR V WHERE I.KEY = :B2 AND V.KEY(+) = I.PRIMARY_PURC HASE_SOURCE) AND ROWNUM = 1 1,134,110 5 226,822.0 1.3 17.3 95.0 3.9 6uwc1b4s185 SQL ordered by Gets DB/Inst: PROD/Prod Snaps: 476-478 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> %Total - Buffer Gets as a percentage of Total Buffer Gets -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Buffer Gets: 90,212,126 -> Captured SQL account for 78.0% of Total Buffer Gets Elapsed Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ------------ ------ ---------- ------ ------ ----------- Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 1,131,829 5 226,365.8 1.3 16.7 98.4 4.0 bj7spkaqpxk Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DEBIT_SSC_KEY , PO_NUMBER , PO_SEQ_NUMBER , DESCRIPTION , TRAN_QUANTITY , GROSS_AMOUNT , DISCOUNT_AMOUNT , FC_GROSS_AMOUNT , FC_DISCOUNT_AMOUNT FROM S.AP _SYSTEM_JOURNAL WHERE VENDOR_KEY = :B4 AND VOUCHER_NO = :B3 AND INVOICE_TYPE = : B2 AND NVL(SO_NUMBER,-1) = NVL(:B1 ,NVL(SO_NUMBER,-1)) AND JOURNAL_TYPE IN ('3WA ------------------------------------------------------------- SQL ordered by Reads DB/Inst: PROD/Prod Snaps: 476-478 -> %Total - Physical Reads as a percentage of Total Disk Reads -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Disk Reads: 3,034,177 -> Captured SQL account for 55.6% of Total Physical Reads Elapsed Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ---------- ------ ---------- ------ ------ ------------- 423,736 52 8,148.8 14.0 311.9 42.1 6.7 8am8fmqz8pdpy Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 408,219 79 5,167.3 13.5 137.8 96.0 7.9 1rqjjgzn8k7wc Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT PSSF.FORMID FROM S.SHIPMENT_SCHEDULE S, S.INVENTORY_TRANSLATION I, S.INSTALLATION_CONTROL IC, S.INSTALLATION_CONTROL IC2, S.INSTALLATION_CONTROL IC3, S.PD_SITE_SPECIFIC_FORM PSSF, S.SALES_ORDER_HEADER H, S.SALES_ORDER_DETAIL D WHERE H.PRINT_PK_LIST||'' IN ('Y','H') AND H.STATUS||'' = 'O' AND H.MAJOR_TYP 396,988 384 1,033.8 13.1 1,218.6 45.7 2.3 anrjzw7r3fqqd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 308,321 413 746.5 10.2 585.2 95.3 2.7 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 260,228 40 6,505.7 8.6 123.5 96.0 9.5 g9t0gypcnh55g Module: ? @atlas (TNS interface) insert into s.work_pk016(formid,order_number,packing_list_number,address_key,pri ce_pk_list,order_priority,process_flag,customer_key)select distinct pssf.formid, to_char(h.order_number),to_char(nvl(s.packing_list_number,0)),nvl(h.ship_to_addr ess_key,h.bill_to_address_key),decode(h.price_pk_list,'Y',0,5),nvl(h.order_prior 195,918 64 3,061.2 6.5 50.4 74.4 9.7 22mym4knbqv79 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT C.CUSTOMER CUSTOMER , CREATED_BY , WSQ.QUOTE_NUMBER QUOTE_NUMBER , CON.FO RMAL_NAME , INTERNAL_EXTERNAL , NOTES , WSQ.ENTRY_DATE ENTRY_DATE , DECODE(NVL(C ONVERTED_TO_ORDER,'N'),'Y','Yes','No') CONVERTED_TO_ORDER, C.NAME CUST_NAME, DEC ODE(NVL(:B1 ,'~'),'Q',WSQ.QUOTE_NUMBER,TO_NUMBER(NULL)) SORT1, DECODE(NVL(:B1 ,' 126,900 52 2,440.4 4.2 45.5 84.5 19.9 d2zxpdg93y57n Module: ? @atlas (TNS interface) select distinct pssf.formid,to_char(hdr.order_number),hdr.major_type,inv2.pull_t icket_printer_code,decode(hdr.print_pull_ticket,'R','Y','N'),decode(hdr.print_pu ll_ticket,'R',to_char(iss.pt_number),'0'),nvl(hdr.pull_complete,'N'),to_char(dtl .inventory_translation_key)from s.installation_control ic,s.pd_site_specific_for 118,968 335 355.1 3.9 495.6 20.1 1.1 ayaf3bbdabmbn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 109,428 108 1,013.2 3.6 67.4 93.1 10.0 1ky5ca7xd90pa Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DISTINCT KEY FROM S.SHIPMENT_SCHEDULE SS, S.SALES_ORDER_DETAIL SOD, S.PUR CHASE_ORDER_DETAIL POD WHERE SS.KEY = SOD.SHIPMENT_SCHEDULE_KEY+0 AND SOD.STATUS SQL ordered by Reads DB/Inst: PROD/Prod Snaps: 476-478 -> %Total - Physical Reads as a percentage of Total Disk Reads -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Disk Reads: 3,034,177 -> Captured SQL account for 55.6% of Total Physical Reads Elapsed Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id ----------- ----------- ---------- ------ ---------- ------ ------ ------------- = 'O' AND SOD.HANDLING_CODE IN('N','R','E') AND SOD.PO_NUMBER = POD.ORDER_NUMBE R AND POD.STATUS = 'H' AND ((SS.QTY_SHIPPED = 0 AND NVL(SS.STATUS,'O') = 'O') OR 94,352 18 5,241.8 3.1 70.0 46.5 8.7 0u12awcsgp93a Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 78,387 396 197.9 2.6 84.9 84.8 17.9 6t3dcd7h9g72z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 71,496 504 141.9 2.4 16.4 75.5 64.9 d9khn5yjabbp6 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'NO CONTACT' CONTACT, DECODE('~', :B1 ,'Y') SELECTED, 1 FROM S.DUAL UNION SELECT 'ALL' CONTACT, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SEL ECT DISTINCT CT.FORMAL_NAME, DECODE(CT.FORMAL_NAME,REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 59,016 54 1,092.9 1.9 61.1 93.9 8.1 apv7p30a8rmx3 Module: f45run@atlas (TNS V1-V2) SELECT ORDER_NUMBER,REFERENCE_NO,CUSTOMER_PO_NUMBER,ORDER_DATE,MARK,CUSTOMER_KEY ,ENTERED_BY_USER_INITIALS_KEY,CO_STRUCTURE_RELATION_KEY,BILL_TO_ADDRESS_KEY,SHIP _TO_ADDRESS_KEY,OUR_CONTACT_USER_INITIALS_KEY,ORDERED_BY,LAST_INVOICE_DATE,LAST_ INVOICE_NO,BILL_TO_ATTENTION,SHIP_TO_ATTENTION,STATUS,SUB_STATUS,SO_TYPE,PRINT_A 47,080 73 644.9 1.6 378.8 25.2 1.7 5k3q8y28x3xbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 41,377 115 359.8 1.4 221.8 14.2 3.2 fhzjzjznbd91p Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; ------------------------------------------------------------- SQL ordered by Physical Reads (UnOptimized)DB/Inst: PROD/Prod Snaps: 476-478 -> UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs -> %Opt - Optimized Reads as percentage of SQL Read Requests -> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs -> Total Physical Read Requests: 1,725,240 -> Captured SQL account for 11.4% of Total -> Total UnOptimized Read Requests: 1,725,240 -> Captured SQL account for 11.4% of Total -> Total Optimized Read Requests: 1 -> Captured SQL account for 0.0% of Total UnOptimized Physical UnOptimized Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id ----------- ----------- ---------- ------------ ------ ------ ------------- 182,468 182,468 52 3,509.0 0.0 10.6 8am8fmqz8pdpy Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 105,635 105,635 413 255.8 0.0 6.1 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 39,471 39,471 73 540.7 0.0 2.3 5k3q8y28x3xbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 38,397 38,397 54 711.1 0.0 2.2 apv7p30a8rmx3 Module: f45run@atlas (TNS V1-V2) SELECT ORDER_NUMBER,REFERENCE_NO,CUSTOMER_PO_NUMBER,ORDER_DATE,MARK,CUSTOMER_KEY ,ENTERED_BY_USER_INITIALS_KEY,CO_STRUCTURE_RELATION_KEY,BILL_TO_ADDRESS_KEY,SHIP _TO_ADDRESS_KEY,OUR_CONTACT_USER_INITIALS_KEY,ORDERED_BY,LAST_INVOICE_DATE,LAST_ INVOICE_NO,BILL_TO_ATTENTION,SHIP_TO_ATTENTION,STATUS,SUB_STATUS,SO_TYPE,PRINT_A 37,363 37,363 18 2,075.7 0.0 2.2 0u12awcsgp93a Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 32,102 32,102 335 95.8 0.0 1.9 ayaf3bbdabmbn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 26,920 26,920 115 234.1 0.0 1.6 fhzjzjznbd91p Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 18,777 18,777 5 3,755.4 0.0 1.1 6uwc1b4s1853k Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.v c_arr; begin owa.init_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 255; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list __(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; 18,765 18,765 5 3,753.0 0.0 1.1 bj7spkaqpxkgz Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DEBIT_SSC_KEY , PO_NUMBER , PO_SEQ_NUMBER , DESCRIPTION , TRAN_QUANTITY , GROSS_AMOUNT , DISCOUNT_AMOUNT , FC_GROSS_AMOUNT , FC_DISCOUNT_AMOUNT FROM S.AP SQL ordered by Physical Reads (UnOptimized)DB/Inst: PROD/Prod Snaps: 476-478 -> UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs -> %Opt - Optimized Reads as percentage of SQL Read Requests -> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs -> Total Physical Read Requests: 1,725,240 -> Captured SQL account for 11.4% of Total -> Total UnOptimized Read Requests: 1,725,240 -> Captured SQL account for 11.4% of Total -> Total Optimized Read Requests: 1 -> Captured SQL account for 0.0% of Total UnOptimized Physical UnOptimized Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id ----------- ----------- ---------- ------------ ------ ------ ------------- _SYSTEM_JOURNAL WHERE VENDOR_KEY = :B4 AND VOUCHER_NO = :B3 AND INVOICE_TYPE = : B2 AND NVL(SO_NUMBER,-1) = NVL(:B1 ,NVL(SO_NUMBER,-1)) AND JOURNAL_TYPE IN ('3WA 10,013 10,013 1 10,013.0 0.0 0.6 g141z6ydfkk14 Module: SQL*Plus Declare preallocate_NB_dates varchar2(1); reserve_credit_hold varchar2(1) ; reserve_quotes varchar2(1); lead_time_mult number :=0; bal ance_on_hand number :=0; std_dev_on_lt number :=0; buy_lt number :=0; req_std_dev_mult number :=0; local_ship_complete ------------------------------------------------------------- SQL ordered by Executions DB/Inst: PROD/Prod Snaps: 476-478 -> %CPU - CPU Time as a percentage of Elapsed Time -> %IO - User I/O Time as a percentage of Elapsed Time -> Total Executions: 1,068,203 -> Captured SQL account for 13.2% of Total Elapsed Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id ------------ --------------- -------------- ---------- ------ ------ ----------- 17,583 17,583 1.0 13.7 91.6 .0 4dqasqjrvud Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) begin dbms_session.reset_package; end; 13,869 348,591 25.1 7.9 100.2 .0 cm5vu20fhtn select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 12,365 12,365 1.0 1.9 98.7 .0 3660x8n40ka Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'www tech support mail grou p' 9,445 55 0.0 39.1 98.1 .0 1cu126j29dd Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'x' FROM S.DOCUMENT_ATTACHMENTS A WHERE A.DOCUMENT_CODE = 'CN' AND TO_CHA R(A.IDENTIFIER) = :B1 AND NVL(A.IDENTIFIER_SEQ,0) = 0 AND ROWNUM = 1 6,482 6,482 1.0 1.5 104.8 .0 fucj4dp4uma Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'web test drive customer' 5,572 0 0.0 0.7 105.5 .0 abdpp6cgmzh Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT OVERRIDE_CUST_PRICING_CLASS FROM S.CUST_PRICING_CLASS_OVERRIDE WHERE CUST OMER_KEY = :B2 AND PRODUCT_PRICING_CLASS = :B1 4,854 4,854 1.0 0.8 93.3 .0 bda772fbhzs Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM INSTALLATION_CONTROL WHERE KEY = 'website domain name' 4,451 4,451 1.0 1.0 89.8 7.2 498r3w3bcyr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT KEY FROM S.CUSTOMER WHERE CUSTOMER = :B1 4,366 236 0.1 1.0 105.8 19.1 awvrd221k7p Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FINAL_SO_CREATED FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 AND CUSTOMER_KEY = :B1 AND ROWNUM = 1 3,689 3,689 1.0 0.4 95.5 .0 2aq5jxq484k Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'custom web help doc locati on' ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: PROD/Prod Snaps: 476-478 -> Total Parse Calls: 575,978 -> Captured SQL account for 19.2% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 17,583 17,583 3.05 4dqasqjrvudqn Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) begin dbms_session.reset_package; end; 13,869 13,869 2.41 cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 6,993 12,365 1.21 3660x8n40kasf Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'www tech support mail grou p' 6,446 6,482 1.12 fucj4dp4uma61 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'web test drive customer' 4,451 4,451 0.77 498r3w3bcyrb0 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT KEY FROM S.CUSTOMER WHERE CUSTOMER = :B1 4,366 4,366 0.76 awvrd221k7p1n Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FINAL_SO_CREATED FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 AND CUSTOMER_KEY = :B1 AND ROWNUM = 1 4,162 4,854 0.72 bda772fbhzs71 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM INSTALLATION_CONTROL WHERE KEY = 'website domain name' 3,689 3,689 0.64 2aq5jxq484krw Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'custom web help doc locati on' 3,689 3,689 0.64 5bjhg8k6hk05q Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(POWER_BAR_COLOR_ATTRIBUTE,'#008000'), NVL(CONTRAST_TEXT_COLOR_ATTRIBU TE,'#cccc99') FROM S.CUSTOMER_ABC_CODE WHERE CODE = :B1 3,689 3,689 0.64 9ncbp46avxgz3 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT VALUE FROM S.INSTALLATION_CONTROL WHERE KEY = 'apogee web help doc locati on' ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 26,153,529 46 1.05 4sbgkcdpd71tf Module: ? @atlas (TNS interface) /*Version 3.18*/insert into s.temp_pk001(order_number,linetype,detail_type,inv_k ey,sorting_sequence,break_key,shipping_instruction_code,seq_number,order_qty,shi p_qty,backorder_qty,stock_uom,item_info,other_info)select max(a.order_number),ma x('100'),max(a.detail_type),max(a.inventory_translation_key),10e9*a.seq_number,t 12,361,655 47 0.49 5ygn1vp9h9nvn Module: ? @atlas (TNS interface) insert into s.temp_po001(LINETYPE,PO_NUMBER,INV_KEY,SORT_KEY,STOCK_BUY_RATIO,QTY _COST_RATIO,OUR_STOCK_UOM_QTY_REQD,VENDOR_LIST_PER_OUR_STOCK_UOM,SEQNO,VENDOR_SE LL_UOM_QTY_REQD,VENDOR_SELL_UOM,ITEM,QTY_PER_SCHEDULE,DATE_PER_SCHEDULE,OUR_COST _PER_VENDOR_UOM,COST_UOM,VENDOR_LIST_PER_VENDOR_UOM,ACTUAL_DISCOUNT_PERCENT,RS_R 11,507,273 10 0.46 0gj3r7pvpv74u Module: ? @atlas (TNS interface) /*Version %I%*/insert into s.temp_pk001(order_number,linetype,detail_type,inv_ke y,sorting_sequence,break_key,shipping_instruction_code,seq_number,order_qty,ship _qty,backorder_qty,stock_uom,item_info,net_price,sell_uom,other_info)select max( a.order_number),max('100'),max(a.detail_type),max(a.inventory_translation_key),1 8,956,593 72 0.36 41us63n39uy6a Module: ? @atlas (TNS interface) insert into s.temp_pull_ticket(linetype,major_type,order_number,seq_number,item, qty_per_unit,uom,inventory,inv_key,is_key,available,bin_location,order_by_seq_no ,order_by_sub_seq_no,detail_count,printer_code,message)select'100',a.major_type, a.order_number,a.seq_number,c.item_number,a.quantity_per_unit,a.unit_of_measure, 6,687,364 47 0.27 duupxmqpm2dmj Module: ? @atlas (TNS interface) select'204',t.key,:1,decode(pr.header_command,null,'',decode(:12,null,pr.header_ command,substr(pr.header_command,1,instr(pr.header_command,pr.start_search_strin g)+length(pr.start_search_string)-decode(substr(pr.header_command,(instr(pr.head er_command,pr.start_search_string)+length(pr.start_search_string)),1),' ',0,1))| 6,585,017 10 0.26 0gj3r7pvpv74u Module: ? @atlas (TNS interface) /*Version %I%*/insert into s.temp_pk001(order_number,linetype,detail_type,inv_ke y,sorting_sequence,break_key,shipping_instruction_code,seq_number,order_qty,ship _qty,backorder_qty,stock_uom,item_info,net_price,sell_uom,other_info)select max( a.order_number),max('100'),max(a.detail_type),max(a.inventory_translation_key),1 4,867,476 2 0.19 bpahk3bt2q9nd Module: SQL*Plus /* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms _stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("ORIG_UNIT_COST")),to_char(substrb(dump(min("ORI G_UNIT_COST"),16,0,32),1,120)),to_char(substrb(dump(max("ORIG_UNIT_COST"),16,0,3 4,088,730 11 0.16 1prv7kr9xvdpb Module: ? @atlas (TNS interface) select'204',t.key,:1,decode(pr.header_command,null,'',decode(:10,null,pr.header_ command,substr(pr.header_command,1,instr(pr.header_command,pr.start_search_strin g)+length(pr.start_search_string)-decode(substr(pr.header_command,(instr(pr.head er_command,pr.start_search_string)+length(pr.start_search_string)),1),' ',0,1))| 3,960,771 151 0.16 693xn5dyf3gz9 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT WCSC.WEB_ORDER_NUMBER , WCSC.SEQ_NUMBER , WCSC.CUSTOMER_KEY , WCSC.ITEM_K EY , WCSC.NET_PRICE , WCSC.ORDER_QUANTITY , DECODE(:B6 ,'Y',:B18 ,NVL(WCSC.MFG_I SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- TEM_NO,WCSC.ITEM_NUMBER)) ITEM_NUMBER, WCSC.ITEM_DESCRIPTION , WCSC.INVENTORY_TR ANSLATION_KEY, WCSC.AVAILABLE_QUANTITY , DECODE(:B6 ,'Y',:B29 ,WCSC.STOCK_SELL_U 3,806,590 504 0.15 9jg3pdysb0mhu Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NOTE_DATE, SMN.NOTE NOTE,UI.NAME NAME, FORMAL_NAME,VENDOR_CONTACT, DECODE (VENDOR,'','','VENDOR '||TO_CHAR(VENDOR)) VENDOR, SMN.ENTRY_FORM ENTRY_FORM, AC. CODE, AC.COLOR_ATTRIBUTE COLOR,TO_CHAR(SMN.DOCUMENT_NUMBER) DOCUMENT_NUMBER, SMN .SALES_MGMT_NOTE_KEY, SMN.ACTIVITY_CODE, TO_CHAR(SMN.REFERENCE_NOTE_NUMBER) REFE 3,415,479 124 0.14 dkvsyf8ka7h06 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT CUSTOMER, NAME CUST_NAME, TO_CHAR(CO_CODE)||'-'||TO_CHAR(AREA_CODE)||'-'| | TO_CHAR(DIV_CODE)||'-'||TO_CHAR(SLS_CODE) STR_CHAIN, A.ADDRESS_LINE1||HTF.BR|| A.ADDRESS_LINE2 ADDINFO, A.CITY CITY, A.STATE STATE, A.ZIP_CODE ZIPCODE , CSR.SL S_NAME SLS_NAME, A.TYPE, (NVL(BALANCE_ON_ORDER,0) + NVL(BALANCE_ON_HOLD,0) + NVL 3,268,209 11 0.13 5zj484fyq0s87 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT SPO.PURCHASE_CLASS, DECODE(SPO.SHIP_TYPE,'D','Direct','N','Nonstock','S', 'Stock') SHIP_TYPE, SPO.FOR_ORDER_NUMBER, SPO.FOR_ORDER_SEQ_NO, NVL(SOD.MFG_PART _NO,NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER)) ITEM_NUMBER, NVL(WORK.RECEIPT_DATE,SPO.R ECEIPT_DATE) RECEIPT_DATE, TO_CHAR(SPO.ORIGINAL_RECEIPT_DATE,'sssss') RECEIPT_DA 3,259,468 64 0.13 22mym4knbqv79 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT C.CUSTOMER CUSTOMER , CREATED_BY , WSQ.QUOTE_NUMBER QUOTE_NUMBER , CON.FO RMAL_NAME , INTERNAL_EXTERNAL , NOTES , WSQ.ENTRY_DATE ENTRY_DATE , DECODE(NVL(C ONVERTED_TO_ORDER,'N'),'Y','Yes','No') CONVERTED_TO_ORDER, C.NAME CUST_NAME, DEC ODE(NVL(:B1 ,'~'),'Q',WSQ.QUOTE_NUMBER,TO_NUMBER(NULL)) SORT1, DECODE(NVL(:B1 ,' 2,992,122 47 0.12 b0mrs6u6xjh5m Module: ? @atlas (TNS interface) update s.temp_po001 set date_per_schedule=(select/*linked nonstock/direct SO/PO* /decode(s.date_type,'NB','Not Before ','On or Before ')||to_char(decode(si gn((trunc(ss.requested_ship_date)-nvl(v.shipping_delay,nvl(ic1.value,0)))-trunc( sysdate)),1,trunc(ss.requested_ship_date)-nvl(v.shipping_delay,nvl(ic1.value,0)) 2,805,041 47 0.11 1yt29rmgat9z7 Module: ? @atlas (TNS interface) insert into s.temp_po001(LINETYPE,PO_NUMBER,INV_KEY,SORT_KEY,STOCK_BUY_RATIO,QTY _COST_RATIO,OUR_STOCK_UOM_QTY_REQD,VENDOR_LIST_PER_OUR_STOCK_UOM,SEQNO,VENDOR_SE LL_UOM_QTY_REQD,VENDOR_SELL_UOM,ITEM,QTY_PER_SCHEDULE,DATE_PER_SCHEDULE,OUR_COST _PER_VENDOR_UOM,COST_UOM,VENDOR_LIST_PER_VENDOR_UOM,ACTUAL_DISCOUNT_PERCENT)sele 2,666,607 415 0.11 7kjmjnndj7v6z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) INSERT INTO S.WEB_CUSTOMER_SHOPPING_CART (CUSTOMER_KEY , WEB_ORDER_NUMBER , SEQ_ NUMBER , DETAIL_TYPE , ORIG_DETAIL_TYPE , ORIG_SEQ_NO, ITEM_KEY , NET_PRICE , OR DER_QUANTITY , ITEM_NUMBER , ITEM_DESCRIPTION , ENTRY_DATE , ROUND_PRICING , ITE M_STK_FLAG , ASSEMBLY_CONVERSION , LIST_PRICE , CO_STRUCTURE_TRANSLATION_KEY , I 2,641,614 31 0.11 7a58g2qswr5f6 Module: WorldShipTD.exe select null, co.owner, co.table_name, co.column_name, decode(data_type, 'CHAR', 1, 'DATE', 11, 'FLOAT', 8, 'LONG', -1, 'LONG RAW', -4, 'NUMBER', 3, 'RAW', -3, ' VARCHAR2', 12, 'ROWID', 1, 0), data_type, decode(data_type, 'DATE', 19, 'FLOAT', 15, 'LONG', 2147483647, 'LONG RAW', 2147483647, 'ROWID', 18, 'NUMBER', decode(d 2,510,350 10 0.10 5hu3w19szcg7r SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- Module: ? @atlas (TNS interface) insert into s.invoice_tax_detail(major_type,order_number,shipping_instruction_co de,geo_state_key,geo_county_key,geo_city_key,sales_tax_code,status,so_type,state _tax_rate,county_tax_rate,city_tax_rate,state_taxable_amount,county_taxable_amou nt,city_taxable_amount,inventory_translation_key)select h.major_type,h.order_num 2,506,899 91 0.10 g7ca0dhhthk3w Module: ? @atlas (TNS interface) /*Version %I%*/insert into s.temp_ak001(linetype,sub_seq_number,seq_number,order _number,item_no)select distinct'105',10e9*sod.seq_number+10e5*sod.seq_number+10e 4*sod.seq_number,sod.seq_number,sod.order_number,sod.added_desc_comment from s.i tem i,s.sales_order_detail sod,s.shipment_schedule ss where sod.order_number=:1 2,470,488 413 0.10 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 2,462,432 413 0.10 4snhz2djjh9zb Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER) ITEM_NUMBER, NVL(IPS.MFG_DESCRIPTION,I .DESCRIPTION) DESCRIPTION, I.LIST_PRICE LIST_PRICE, I.KEY KEY, NVL(TO_CHAR(ROUND (ILPM.PRICE,5),'9999999990.00000'), 'Not Available')IPM_PRICE, DECODE(I.MADE_TO_ STOCK,'',I.ASSEMBLY_CONVERSION,'') ASSEMBLY_CONVERSION, I.ITEM_STATUS, I.SUCCESS 2,447,218 504 0.10 d9khn5yjabbp6 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'NO CONTACT' CONTACT, DECODE('~', :B1 ,'Y') SELECTED, 1 FROM S.DUAL UNION SELECT 'ALL' CONTACT, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SEL ECT DISTINCT CT.FORMAL_NAME, DECODE(CT.FORMAL_NAME,REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 2,367,267 10 0.09 bcx8qjabm17kd Module: ? @atlas (TNS interface) insert into s.invoice_tax_detail(major_type,order_number,shipping_instruction_co de,geo_state_key,geo_county_key,geo_city_key,sales_tax_code,header_detail,status ,so_type,inventory_translation_key)/*FIRST OF TWO SELECTS IN UNION*//*THIS SELEC T IS FOR WHEN A TAX STRUCTURE LEVEL IS DESIGNATED IN IC*/select distinct'O',:1,s 2,328,894 47 0.09 26wu14m8z6n80 Module: ? @atlas (TNS interface) insert into s.temp_po001(LINETYPE,PO_NUMBER,INV_KEY,SORT_KEY,STOCK_BUY_RATIO,QTY _COST_RATIO,OUR_STOCK_UOM_QTY_REQD,VENDOR_LIST_PER_OUR_STOCK_UOM,SEQNO,VENDOR_SE LL_UOM_QTY_REQD,VENDOR_SELL_UOM,ITEM,QTY_PER_SCHEDULE,DATE_PER_SCHEDULE,OUR_COST _PER_VENDOR_UOM,COST_UOM,VENDOR_LIST_PER_VENDOR_UOM,ACTUAL_DISCOUNT_PERCENT)sele 2,326,337 5 0.09 cb8jnj836jadm Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT SOH.ORDER_NUMBER , SOH.ORDER_DATE, CSTSVC.CODE, CUST.CUSTOMER, CUST.NAME , SOH.PRINT_PK_LIST, SOD.SEQ_NUMBER, SOD.SHIP_TYPE, V.VENDOR, SOD.PO_NUMBER, ROU ND(((NVL(SOD.NET_PRICE,0)/DECODE(SOD.PRICE_UNIT,'C',100,'M',1000,1)) /NVL(SOD.CO NVERSION_FACTOR,1))*NVL(SS.QTY_TO_SHIP,0),2) EXT_PRICE, SS.REQUESTED_SHIP_DATE, 2,239,453 10 0.09 81wgy3pdc41z5 Module: ? @atlas (TNS interface) update s.invoice_tax_detail itd set(itd.state_taxable_amount,itd.state_tax_rate, itd.county_taxable_amount,itd.county_excess_taxable_amount,itd.county_tax_rate,i td.county_excess_tax_rate,itd.county_transit_tax_rate)=(select sum(decode(itd.sa SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- les_tax_code,'NT',null,(nvl(dtl.invoice_qty,0)*nvl(dtl.net_price,0)/nvl(dtl.conv 2,165,599 10 0.09 2x9kbf93zsb2z Module: ? @atlas (TNS interface) update s.invoice_tax_detail itd set(itd.city_taxable_amount,itd.city_excess_taxa ble_amount,itd.city_tax_rate,itd.city_excess_tax_rate,itd.city_transit_tax_rate, itd.exempt_reason,itd.exempt_amount,itd.exempt_freight_amount,itd.exempt_expense _amount,itd.exempt_parts_amount,itd.exempt_labor_amount)=(select sum(decode(itd. 2,158,910 47 0.09 8s1gg426b4agq Module: ? @atlas (TNS interface) insert into s.work_carousel_interface(document_type,document_number,order_number ,seq_number,inventory_key,quantity,ship_instr_code,item_number,bin_operator,entr y_date_time,entry_form)select'PL',:1,:2,tp.seq_number,tp.inv_key,sum(nvl(tp.ship _qty,0)),tp.shipping_instruction_code,max(i.item_number),max('-'),sysdate,'PK001 1,961,329 52 0.08 d2zxpdg93y57n Module: ? @atlas (TNS interface) select distinct pssf.formid,to_char(hdr.order_number),hdr.major_type,inv2.pull_t icket_printer_code,decode(hdr.print_pull_ticket,'R','Y','N'),decode(hdr.print_pu ll_ticket,'R',to_char(iss.pt_number),'0'),nvl(hdr.pull_complete,'N'),to_char(dtl .inventory_translation_key)from s.installation_control ic,s.pd_site_specific_for 1,940,962 5 0.08 25kjs9yp2xrkr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT PRODUCT_PRICING_CLASS, PPCL.DESCRIPTION, 'Stock' SHIP_TYPE, BREAK, DECODE (PRICE_BREAK_TYPE,'Q','Quantity','L','List Price Total', 'N','Net Price Total') BREAK_TYPE, '' CPC, DECODE(PRICE_FACTOR_TYPE, 'D', 'List price minus '||TO_CHAR( 100-(VALUE*100))||'%', 'C', 'Our Cost plus '||TO_CHAR(ROUND(100*(100-(VALUE*100) 1,930,146 2,720 0.08 6z8r7gd3atg1b Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'S' ORDER_TYPE, SOD.ORDER_NUMBER ORDER_NUMBER, SOD.SEQ_NUMBER SEQ_NUMBER, DECODE(SOD.STATUS, 'P',DECODE(SS.PACKING_LIST_NUMBER,'',NVL(SS.QTY_TO_SHIP,0), (NVL(SS.QTY_TO_SHIP,0) - NVL(SS.SHIP_QTY,0))), 'S',DECODE(SS.PACKING_LIST_NUMBER ,'',NVL(SS.QTY_TO_SHIP,0), NVL(SS.QTY_BACKORDERED,0)), 'I',DECODE(SS.PACKING_LIS 1,855,901 8 0.07 9w2c9dryp96cc Module: SQL*Plus insert into s.vro_address@centralVRO (po_number, sellers_vrp_key, k ey, address_name, address_line1, address_line2, country, state, county, c ity, geo_city_key, geo_county_key, geo_state_key, zip_code, zip_co de2, address_type, business_area_code, business_phone_number, fax_ 1,809,902 40 0.07 g9t0gypcnh55g Module: ? @atlas (TNS interface) insert into s.work_pk016(formid,order_number,packing_list_number,address_key,pri ce_pk_list,order_priority,process_flag,customer_key)select distinct pssf.formid, to_char(h.order_number),to_char(nvl(s.packing_list_number,0)),nvl(h.ship_to_addr ess_key,h.bill_to_address_key),decode(h.price_pk_list,'Y',0,5),nvl(h.order_prior 1,804,505 10 0.07 977u7sq9147ud Module: WorldShipTD.exe select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 1,804,360 10 0.07 f1d6vzx9mjuxs Module: WorldShipTD.exe SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- select /*+ RULE */ * from (select /*+ RULE */ null table_qualifier, o1.owner tab le_owner, o1.object_name table_name, decode(o1.owner,'SYS', decode(o1.object_typ e,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decod e(o1.object_type,'TABLE','SYSTEM TABLE','VIEW', 'SYSTEM VIEW', o1.object_type), 1,722,879 2,779 0.07 1jc1ymz5qq44z Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT DECODE( :B2 , 'R', DECODE( RUSH_VALUE, NULL, DECODE( PRICE_FACTOR_TYPE, ' $', DECODE(:B3 , 'N',SOURCE_NAME, 'D',DECODE(:B2 , 'E', DECODE(EMERGENCY_VALUE,N ULL,'LIST-PRICE',SOURCE_NAME), SOURCE_NAME), SOURCE_NAME), 'D', DECODE(:B3 , 'N' ,SOURCE_NAME, 'D',DECODE(:B2 , 'E', DECODE(EMERGENCY_VALUE,NULL,'LIST-PRICE',SOU 1,695,879 10 0.07 f4bqxbp43uuz4 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT V.VENDOR||' '||V.NAME VENDOR_SUPPINV, V.NAME VEND_SUPP_NAME, SPS.SHIP_TYP E SHIP_TYPE, DECODE(SPS.SHIP_TYPE,'DIRECT','',IT.INVENTORY_NUMBER||' '||IT.NAME) RECV_INV, IT.NAME INVENTORY_NAME, DECODE(SPS.SHIP_TYPE, 'DIRECT', SPS.ORDER_INV , DECODE(SPS.HANDLING_CODE,'*',SPS.ORDER_INV,'')) ORDER_NUMBER, SPS.PURCHASE_CLA 1,666,460 31 0.07 gmhfq16tr7nch Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 1,666,381 31 0.07 3q8vccjyfjqg1 Module: WorldShipTD.exe select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner,'SYS',decode(o 1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTE M',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_t 1,665,272 504 0.07 agpknm9q409rv Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'ALL' NAME, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SELECT DISTINCT NVL(SMN.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)), DECODE(NVL(SM N.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)),REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 1,658,713 11 0.07 5zj484fyq0s87 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT SPO.PURCHASE_CLASS, DECODE(SPO.SHIP_TYPE,'D','Direct','N','Nonstock','S', 'Stock') SHIP_TYPE, SPO.FOR_ORDER_NUMBER, SPO.FOR_ORDER_SEQ_NO, NVL(SOD.MFG_PART _NO,NVL(IPS.MFG_ITEM_NO,I.ITEM_NUMBER)) ITEM_NUMBER, NVL(WORK.RECEIPT_DATE,SPO.R ECEIPT_DATE) RECEIPT_DATE, TO_CHAR(SPO.ORIGINAL_RECEIPT_DATE,'sssss') RECEIPT_DA 1,383,542 30 0.06 fw7vfssv46nst Module: f45run@atlas (TNS V1-V2) INSERT INTO S.PURCHASE_ORDER_DETAIL(ORDER_NUMBER,SEQ_NUMBER,DETAIL_TYPE,SALES_OR DER_NUMBER,SALES_ORDER_SEQ_NO,WORK_ORDER_NUMBER,WORK_ORDER_SEQ_NO,UNIT_COST,COST _FIXED_ON_ENTRY,PURCHASE_COST_DISCOUNT_GROUP,PO_VOLUME_DISCOUNT_GROUP,ITEM_GETS_ PO_VOL_DISCOUNT,ORDER_QUANTITY,EDI_MISC,ADDED_DESC_COMMENT,PRINT_ON_PO,STOCK_SEL 1,116,636 64 0.04 22mym4knbqv79 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT C.CUSTOMER CUSTOMER , CREATED_BY , WSQ.QUOTE_NUMBER QUOTE_NUMBER , CON.FO RMAL_NAME , INTERNAL_EXTERNAL , NOTES , WSQ.ENTRY_DATE ENTRY_DATE , DECODE(NVL(C ONVERTED_TO_ORDER,'N'),'Y','Yes','No') CONVERTED_TO_ORDER, C.NAME CUST_NAME, DEC ODE(NVL(:B1 ,'~'),'Q',WSQ.QUOTE_NUMBER,TO_NUMBER(NULL)) SORT1, DECODE(NVL(:B1 ,' SQL ordered by Sharable Memory DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 1,112,596 64 0.04 22mym4knbqv79 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT C.CUSTOMER CUSTOMER , CREATED_BY , WSQ.QUOTE_NUMBER QUOTE_NUMBER , CON.FO RMAL_NAME , INTERNAL_EXTERNAL , NOTES , WSQ.ENTRY_DATE ENTRY_DATE , DECODE(NVL(C ONVERTED_TO_ORDER,'N'),'Y','Yes','No') CONVERTED_TO_ORDER, C.NAME CUST_NAME, DEC ODE(NVL(:B1 ,'~'),'Q',WSQ.QUOTE_NUMBER,TO_NUMBER(NULL)) SORT1, DECODE(NVL(:B1 ,' ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 94 8 8x8b1txjxsz3p Module: SQL*Plus insert into s.vro_order_header@centralVRO (po_number, shippers_vrp_key, sellers_ vrp_key, status, so_number, ordered_by, ordered_by_area_code, ordered_by_phone_ no,create_date, seller_cust_po_no) (select po_number, shippers_vrp_key, sellers _vrp_key, 'N', so_number, ordered_by, ordered_by_area_code, ordered_by_phone_no 94 8 9w2c9dryp96cc Module: SQL*Plus insert into s.vro_address@centralVRO (po_number, sellers_vrp_key, k ey, address_name, address_line1, address_line2, country, state, county, c ity, geo_city_key, geo_county_key, geo_state_key, zip_code, zip_co de2, address_type, business_area_code, business_phone_number, fax_ 29 625 3y8n581q1zc72 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT COUNT(*) FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 A ND CUSTOMER_KEY = :B1 AND DETAIL_TYPE = 'I' 29 151 693xn5dyf3gz9 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT WCSC.WEB_ORDER_NUMBER , WCSC.SEQ_NUMBER , WCSC.CUSTOMER_KEY , WCSC.ITEM_K EY , WCSC.NET_PRICE , WCSC.ORDER_QUANTITY , DECODE(:B6 ,'Y',:B18 ,NVL(WCSC.MFG_I TEM_NO,WCSC.ITEM_NUMBER)) ITEM_NUMBER, WCSC.ITEM_DESCRIPTION , WCSC.INVENTORY_TR ANSLATION_KEY, WCSC.AVAILABLE_QUANTITY , DECODE(:B6 ,'Y',:B29 ,WCSC.STOCK_SELL_U 28 554 29ddcntc0jgrt Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NVL(SUM(NVL(SPECIAL_CHARGE_QUANTITY,1) * NVL(SPECIAL_CHARGE_PRICE,0)),0) FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 AND CUSTOMER_KEY = :B1 AND DETAIL_TYPE = 'S' 28 1,057 a4y66gq5n84jg Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FROM_SO_NO FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 AND CUSTOMER_KEY = :B1 AND FROM_SO_NO IS NOT NULL AND ROWNUM = 1 27 504 9jg3pdysb0mhu Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NOTE_DATE, SMN.NOTE NOTE,UI.NAME NAME, FORMAL_NAME,VENDOR_CONTACT, DECODE (VENDOR,'','','VENDOR '||TO_CHAR(VENDOR)) VENDOR, SMN.ENTRY_FORM ENTRY_FORM, AC. CODE, AC.COLOR_ATTRIBUTE COLOR,TO_CHAR(SMN.DOCUMENT_NUMBER) DOCUMENT_NUMBER, SMN .SALES_MGMT_NOTE_KEY, SMN.ACTIVITY_CODE, TO_CHAR(SMN.REFERENCE_NOTE_NUMBER) REFE 27 504 9jg3pdysb0mhu Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NOTE_DATE, SMN.NOTE NOTE,UI.NAME NAME, FORMAL_NAME,VENDOR_CONTACT, DECODE (VENDOR,'','','VENDOR '||TO_CHAR(VENDOR)) VENDOR, SMN.ENTRY_FORM ENTRY_FORM, AC. CODE, AC.COLOR_ATTRIBUTE COLOR,TO_CHAR(SMN.DOCUMENT_NUMBER) DOCUMENT_NUMBER, SMN .SALES_MGMT_NOTE_KEY, SMN.ACTIVITY_CODE, TO_CHAR(SMN.REFERENCE_NOTE_NUMBER) REFE 27 504 9jg3pdysb0mhu Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT NOTE_DATE, SMN.NOTE NOTE,UI.NAME NAME, FORMAL_NAME,VENDOR_CONTACT, DECODE (VENDOR,'','','VENDOR '||TO_CHAR(VENDOR)) VENDOR, SMN.ENTRY_FORM ENTRY_FORM, AC. CODE, AC.COLOR_ATTRIBUTE COLOR,TO_CHAR(SMN.DOCUMENT_NUMBER) DOCUMENT_NUMBER, SMN .SALES_MGMT_NOTE_KEY, SMN.ACTIVITY_CODE, TO_CHAR(SMN.REFERENCE_NOTE_NUMBER) REFE 27 504 d9khn5yjabbp6 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SQL ordered by Version Count DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- SELECT 'NO CONTACT' CONTACT, DECODE('~', :B1 ,'Y') SELECTED, 1 FROM S.DUAL UNION SELECT 'ALL' CONTACT, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SEL ECT DISTINCT CT.FORMAL_NAME, DECODE(CT.FORMAL_NAME,REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 27 504 d9khn5yjabbp6 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'NO CONTACT' CONTACT, DECODE('~', :B1 ,'Y') SELECTED, 1 FROM S.DUAL UNION SELECT 'ALL' CONTACT, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SEL ECT DISTINCT CT.FORMAL_NAME, DECODE(CT.FORMAL_NAME,REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 27 581 fyqbhmkub3hbr Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'x' FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 AND IT EM_KEY = :B1 AND EXISTS (SELECT 'x' FROM S.WORK_CUSTOM_WORK_ORDER CW WHERE CW.WE B_ORDER_NUMBER = :B2 AND CW.ITEM_KEY = :B1 ) 26 363 0bdqw7j9a293t Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT COUNT(*) FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 A ND CUSTOMER_KEY = :B1 AND FINAL_SO_CREATED IS NULL 26 90 faach545nnj14 Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT COUNT(*) FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE WEB_ORDER_NUMBER = :B2 A ND CUSTOMER_KEY = :B1 AND DETAIL_TYPE = 'I' AND FINAL_SO_CREATED IS NULL 26 82 ggmq0k6ah382h Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) UPDATE S.WEB_CUSTOMER_SHOPPING_CART SET SALES_ORDER_NUMBER = :B2 WHERE WEB_ORDER _NUMBER = :B1 25 504 agpknm9q409rv Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'ALL' NAME, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SELECT DISTINCT NVL(SMN.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)), DECODE(NVL(SM N.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)),REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 25 504 agpknm9q409rv Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT 'ALL' NAME, DECODE('ALL', :B1 ,'Y') SELECTED, 0 FROM S.DUAL UNION SELECT DISTINCT NVL(SMN.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)), DECODE(NVL(SM N.VENDOR_CONTACT,NVL(TO_CHAR(SMN.VENDOR),UI.NAME)),REPLACE(:B1 ,'~',' '),'Y') SE LECTED, 999 FROM S.SALES_MGMT_NOTES SMN, S.USER_INITIALS UI, S.CONTACT CT, S.ACT 25 30 fw7vfssv46nst Module: f45run@atlas (TNS V1-V2) INSERT INTO S.PURCHASE_ORDER_DETAIL(ORDER_NUMBER,SEQ_NUMBER,DETAIL_TYPE,SALES_OR DER_NUMBER,SALES_ORDER_SEQ_NO,WORK_ORDER_NUMBER,WORK_ORDER_SEQ_NO,UNIT_COST,COST _FIXED_ON_ENTRY,PURCHASE_COST_DISCOUNT_GROUP,PO_VOLUME_DISCOUNT_GROUP,ITEM_GETS_ PO_VOL_DISCOUNT,ORDER_QUANTITY,EDI_MISC,ADDED_DESC_COMMENT,PRINT_ON_PO,STOCK_SEL 25 1,164 fz582k5mqx2cs Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT FINAL_SO_CREATED, SALES_ORDER_NUMBER FROM S.WEB_CUSTOMER_SHOPPING_CART WH ERE WEB_ORDER_NUMBER = :B2 AND CUSTOMER_KEY = :B1 AND ROWNUM = 1 24 1,117 8hxmgw29fffn7 SQL ordered by Version Count DB/Inst: PROD/Prod Snaps: 476-478 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT MAX(TRUNC(SEQ_NUMBER)) FROM S.WEB_CUSTOMER_SHOPPING_CART WHERE CUSTOMER_K EY = :B2 AND WEB_ORDER_NUMBER = :B1 23 91 616vrsz7y2prx Module: ? @atlas (TNS interface) delete from s.temp_pull_ticket where order_number=:1 and major_type=:2 and inv_k ey=:3 23 91 616vrsz7y2prx Module: ? @atlas (TNS interface) delete from s.temp_pull_ticket where order_number=:1 and major_type=:2 and inv_k ey=:3 23 2,073 f9hdzcqfs1u9d Module: httpd.worker@poseidon.airlinehyd.com (TNS V1-V3) SELECT KEY FROM S.USER_INITIALS WHERE CODE = UPPER(:B1 ) AND INTRANET_PASSWD IS NOT NULL AND NVL(STATUS,'~') != 'X' 22 72 9pwcj8d6wgqcw Module: ? @atlas (TNS interface) delete from s.temp_pull_ticket where order_number=:1 and major_type=:2 and inv_k ey=:3 and order_by_seq_no in(select order_by_seq_no from s.temp_pull_ticket wher e order_number=:1 and major_type=:2 and inv_key=:3 and nvl(available,0)=0 and li netype='100') 21 4 69k5bhm12sz98 SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_ name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as beg in_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((ca 21 72 dxdvb3vp9kkrw Module: ? @atlas (TNS interface) select linetype,order_number,order_by_seq_no,order_by_sub_seq_no,to_char(seq_num ber),item,qty_per_unit,uom,to_char(inventory),available,bin_location from s.temp _pull_ticket where order_number=:1 and major_type=:2 and inv_key=:3 and linetype not in('115','120')union select linetype,order_number,order_by_seq_no,order_by_ ------------------------------------------------------------- Instance Activity Stats DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- Batched IO (bound) vector count 9,332 1.3 0.5 Batched IO (full) vector count 3 0.0 0.0 Batched IO (space) vector count 0 0.0 0.0 Batched IO block miss count 34,202 4.7 1.9 Batched IO buffer defrag count 386 0.1 0.0 Batched IO double miss count 1,258 0.2 0.1 Batched IO same unit count 9,515 1.3 0.5 Batched IO single block count 4,475 0.6 0.3 Batched IO slow jump count 52 0.0 0.0 Batched IO vector block count 24,420 3.4 1.4 Batched IO vector read count 6,088 0.8 0.3 Block Cleanout Optim referenced 0 0.0 0.0 CCursor + sql area evicted 77 0.0 0.0 CPU used by this session 450,376 62.4 25.4 CPU used when call started 443,989 61.5 25.1 CR blocks created 3,283 0.5 0.2 Cached Commit SCN referenced 20,885 2.9 1.2 Commit SCN cached 254 0.0 0.0 DB time 4,753,677 658.7 268.2 DBWR checkpoint buffers written 2,413 0.3 0.1 DBWR checkpoints 179 0.0 0.0 DBWR object drop buffers written 882 0.1 0.1 DBWR revisited being-written buf 0 0.0 0.0 DBWR tablespace checkpoint buffe 133 0.0 0.0 DBWR thread checkpoint buffers w 0 0.0 0.0 DBWR transaction table writes 381 0.1 0.0 DBWR undo block writes 6,175 0.9 0.4 DFO trees parallelized 0 0.0 0.0 Effective IO time 611,240 84.7 34.5 HSC Heap Segment Block Changes 134,881 18.7 7.6 HSC IDL Compressed Blocks 0 0.0 0.0 Heap Segment Array Inserts 5,231 0.7 0.3 Heap Segment Array Updates 1,834 0.3 0.1 IMU CR rollbacks 0 0.0 0.0 IMU Flushes 7 0.0 0.0 IMU Redo allocation size 15,136 2.1 0.9 IMU commits 9 0.0 0.0 IMU contention 2 0.0 0.0 IMU ktichg flush 0 0.0 0.0 IMU pool not allocated 19,313 2.7 1.1 IMU recursive-transaction flush 0 0.0 0.0 IMU undo allocation size 42,824 5.9 2.4 IMU- failed to get a private str 19,313 2.7 1.1 LOB table id lookup cache misses 0 0.0 0.0 Misses for writing mapping 0 0.0 0.0 Number of read IOs issued 0 0.0 0.0 PX local messages recv'd 0 0.0 0.0 PX local messages sent 0 0.0 0.0 Parallel operations not downgrad 0 0.0 0.0 RowCR - row contention 35 0.0 0.0 RowCR attempts 6,364 0.9 0.4 RowCR hits 6,289 0.9 0.4 SMON posted for undo segment rec 0 0.0 0.0 SMON posted for undo segment shr 1 0.0 0.0 SQL*Net roundtrips to/from clien 544,304 75.4 30.7 SQL*Net roundtrips to/from dblin 2,899 0.4 0.2 TBS Extension: bytes extended 2,097,152 290.6 118.3 TBS Extension: files extended 2 0.0 0.0 TBS Extension: tasks created 12 0.0 0.0 TBS Extension: tasks executed 12 0.0 0.0 Instance Activity Stats DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- active txn count during cleanout 5,043 0.7 0.3 application wait time 15,692 2.2 0.9 background checkpoints completed 3 0.0 0.0 background checkpoints started 3 0.0 0.0 background timeouts 30,512 4.2 1.7 branch node splits 1 0.0 0.0 buffer is not pinned count 42,491,983 5,888.3 2,397.2 buffer is pinned count 149,264,080 20,684.3 8,420.6 bytes received via SQL*Net from 119,112,553 16,506.1 6,719.7 bytes received via SQL*Net from 992,494 137.5 56.0 bytes sent via SQL*Net to client 345,567,011 47,887.1 19,494.9 bytes sent via SQL*Net to dblink 832,021 115.3 46.9 calls to get snapshot scn: kcmgs 1,072,527 148.6 60.5 calls to kcmgas 58,465 8.1 3.3 calls to kcmgcs 5,654,143 783.5 319.0 cell physical IO interconnect by 25,994,234,880 3,602,161.0 1,466,446.7 change write time 1,973 0.3 0.1 cleanout - number of ktugct call 6,053 0.8 0.3 cleanouts and rollbacks - consis 2,858 0.4 0.2 cleanouts only - consistent read 1,288 0.2 0.1 cluster key scan block gets 6,548,491 907.5 369.4 cluster key scans 6,528,866 904.7 368.3 commit batch performed 135 0.0 0.0 commit batch requested 135 0.0 0.0 commit batch/immediate performed 212 0.0 0.0 commit batch/immediate requested 212 0.0 0.0 commit cleanout failures: block 480 0.1 0.0 commit cleanout failures: buffer 11 0.0 0.0 commit cleanout failures: callba 104 0.0 0.0 commit cleanout failures: cannot 6 0.0 0.0 commit cleanout failures: hot ba 6 0.0 0.0 commit cleanouts 64,574 9.0 3.6 commit cleanouts successfully co 63,967 8.9 3.6 commit immediate performed 77 0.0 0.0 commit immediate requested 77 0.0 0.0 commit txn count during cleanout 2,090 0.3 0.1 concurrency wait time 983,812 136.3 55.5 consistent changes 12,691 1.8 0.7 consistent gets 89,558,339 12,410.6 5,052.4 consistent gets - examination 10,013,739 1,387.7 564.9 consistent gets direct 1 0.0 0.0 consistent gets from cache 89,558,338 12,410.6 5,052.4 consistent gets from cache (fast 63,994,573 8,868.1 3,610.2 cursor authentications 1,505 0.2 0.1 data blocks consistent reads - u 7,583 1.1 0.4 db block changes 642,969 89.1 36.3 db block gets 653,787 90.6 36.9 db block gets direct 996 0.1 0.1 db block gets from cache 652,791 90.5 36.8 db block gets from cache (fastpa 154,991 21.5 8.7 deferred (CURRENT) block cleanou 40,585 5.6 2.3 dirty buffers inspected 33,806 4.7 1.9 enqueue conversions 8,933 1.2 0.5 enqueue deadlocks 1 0.0 0.0 enqueue releases 177,139 24.6 10.0 enqueue requests 177,165 24.6 10.0 enqueue timeouts 16 0.0 0.0 enqueue waits 207 0.0 0.0 exchange deadlocks 0 0.0 0.0 execute count 1,068,203 148.0 60.3 Instance Activity Stats DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- failed probes on index block rec 1 0.0 0.0 file io service time 0 0.0 0.0 file io wait time 4,972,723,053 689,097.0 280,532.7 frame signature mismatch 0 0.0 0.0 free buffer inspected 4,289,855 594.5 242.0 free buffer requested 3,069,796 425.4 173.2 global undo segment hints helped 0 0.0 0.0 heap block compress 3,304 0.5 0.2 hot buffers moved to head of LRU 4,281,851 593.4 241.6 immediate (CR) block cleanout ap 4,146 0.6 0.2 immediate (CURRENT) block cleano 11,009 1.5 0.6 index crx upgrade (positioned) 11,077 1.5 0.6 index crx upgrade (prefetch) 10 0.0 0.0 index fast full scans (full) 814 0.1 0.1 index fast full scans (rowid ran 0 0.0 0.0 index fetch by key 12,271,812 1,700.6 692.3 index scans kdiixs1 17,144,667 2,375.8 967.2 leaf node 90-10 splits 104 0.0 0.0 leaf node splits 420 0.1 0.0 lob reads 1,702 0.2 0.1 lob writes 1,863 0.3 0.1 lob writes unaligned 1,863 0.3 0.1 logons cumulative 2,873 0.4 0.2 max cf enq hold time 2,154 0.3 0.1 messages received 27,980 3.9 1.6 messages sent 27,980 3.9 1.6 min active SCN optimization appl 2 0.0 0.0 no buffer to keep pinned count 10 0.0 0.0 no work - consistent read gets 73,619,430 10,201.8 4,153.2 non-idle wait count 3,598,480 498.7 203.0 non-idle wait time 1,133,342 157.1 63.9 opened cursors cumulative 899,833 124.7 50.8 parse count (describe) 13 0.0 0.0 parse count (failures) 4,037 0.6 0.2 parse count (hard) 8,641 1.2 0.5 parse count (total) 575,978 79.8 32.5 parse time cpu 26,868 3.7 1.5 parse time elapsed 134,759 18.7 7.6 physical read IO requests 1,725,240 239.1 97.3 physical read bytes 24,858,615,808 3,444,792.2 1,402,381.6 physical read total IO requests 1,738,177 240.9 98.1 physical read total bytes 25,199,934,976 3,492,090.6 1,421,636.9 physical read total multi block 15,184 2.1 0.9 physical reads 3,034,177 420.5 171.2 physical reads cache 3,031,944 420.2 171.1 physical reads cache prefetch 1,336,785 185.3 75.4 physical reads direct 2,233 0.3 0.1 physical reads direct (lob) 322 0.0 0.0 physical reads direct temporary 2,175 0.3 0.1 physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 34,343 4.8 1.9 physical write bytes 403,701,760 55,943.1 22,774.6 physical write total IO requests 58,528 8.1 3.3 physical write total bytes 794,299,904 110,070.4 44,809.9 physical write total multi block 526 0.1 0.0 physical writes 49,280 6.8 2.8 physical writes direct 3,228 0.5 0.2 physical writes direct (lob) 3 0.0 0.0 physical writes direct temporary 3,019 0.4 0.2 physical writes from cache 46,052 6.4 2.6 Instance Activity Stats DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical writes non checkpoint 46,252 6.4 2.6 pinned buffers inspected 588 0.1 0.0 pinned cursors current 117 0.0 0.0 prefetch clients - default 7 0.0 0.0 prefetch warmup blocks aged out 0 0.0 0.0 prefetched blocks aged out befor 342 0.1 0.0 process last non-idle time 7,233 1.0 0.4 queries parallelized 0 0.0 0.0 recursive calls 3,408,022 472.3 192.3 recursive cpu usage 213,574 29.6 12.1 redo blocks checksummed by FG (e 65,986 9.1 3.7 redo blocks written 251,705 34.9 14.2 redo buffer allocation retries 12 0.0 0.0 redo entries 340,559 47.2 19.2 redo k-bytes read total 128,562 17.8 7.3 redo log space requests 5 0.0 0.0 redo log space wait time 31 0.0 0.0 redo ordering marks 5,171 0.7 0.3 redo size 120,165,100 16,651.9 6,779.0 redo size for direct writes 1,250,700 173.3 70.6 redo subscn max counts 18,187 2.5 1.0 redo synch time 13,495 1.9 0.8 redo synch writes 7,512 1.0 0.4 redo wastage 4,391,572 608.6 247.8 redo write time 23,118 3.2 1.3 redo writes 15,965 2.2 0.9 remote Oradebug requests 0 0.0 0.0 rollback changes - undo records 3,400 0.5 0.2 rollbacks only - consistent read 509 0.1 0.0 root node splits 0 0.0 0.0 rows fetched via callback 4,719,986 654.1 266.3 scheduler wait time 0 0.0 0.0 securefile direct read bytes 2,637,824 365.5 148.8 securefile direct read ops 322 0.0 0.0 session connect time 0 0.0 0.0 session cursor cache hits 495,787 68.7 28.0 session logical reads 90,212,126 12,501.2 5,089.3 shared hash latch upgrades - no 321,737 44.6 18.2 shared hash latch upgrades - wai 5 0.0 0.0 shared io pool buffer get succes 322 0.0 0.0 sorts (memory) 1,114,723 154.5 62.9 sorts (rows) 9,975,210 1,382.3 562.7 sql area evicted 544 0.1 0.0 sql area purged 4,149 0.6 0.2 summed dirty queue length 214,378 29.7 12.1 switch current to new buffer 26,477 3.7 1.5 table fetch by rowid 84,155,684 11,661.9 4,747.6 table fetch continued row 18,980 2.6 1.1 table scan blocks gotten 25,460,706 3,528.2 1,436.4 table scan rows gotten 1,604,254,300 222,310.2 90,502.9 table scans (direct read) 0 0.0 0.0 table scans (long tables) 7 0.0 0.0 table scans (rowid ranges) 0 0.0 0.0 table scans (short tables) 2,791,241 386.8 157.5 temp space allocated (bytes) 3,145,728 435.9 177.5 total cf enq hold time 7,561 1.1 0.4 total number of cf enq holders 423 0.1 0.0 total number of times SMON poste 13 0.0 0.0 transaction rollbacks 212 0.0 0.0 transaction tables consistent re 0 0.0 0.0 Instance Activity Stats DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by statistic name Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- transaction tables consistent re 0 0.0 0.0 undo change vector size 36,422,772 5,047.3 2,054.8 user I/O wait time 37,642 5.2 2.1 user calls 583,789 80.9 32.9 user commits 14,093 2.0 0.8 user rollbacks 3,633 0.5 0.2 workarea executions - onepass 8 0.0 0.0 workarea executions - optimal 1,051,445 145.7 59.3 write clones created in backgrou 834 0.1 0.1 write clones created in foregrou 159 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute Values DB/Inst: PROD/Prod Snaps: 476-478 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session pga memory max 91,181,631,240 91,631,125,904 session cursor cache count 4,138,698 4,177,818 session uga memory 1.430151514E+14 1.436810261E+14 opened cursors current 5,913 6,652 workarea memory allocated 12,047 15,037 logons current 156 164 session uga memory max 3.139641790E+11 3.165976428E+11 session pga memory 77,201,326,536 77,571,112,368 ------------------------------------------------------------- Instance Activity Stats - Thread Activity DB/Inst: PROD/Prod Snaps: 476-478 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 3 1.50 ------------------------------------------------------------- IOStat by Function summary DB/Inst: PROD/Prod Snaps: 476-478 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> ordered by (Data Read + Write) desc Reads: Reqs Data Writes: Reqs Data Waits: Avg Function Name Data per sec per sec Data per sec per sec Count Tm(ms) --------------- ------- ------- ------- ------- ------- ------- ------- ------- Buffer Cache Re 23.1G 239.0 3.28215 0M 0.0 0M 1695K 0.2 Others 325M 1.8 .045036 252M 1.1 .034920 15.4K 5.5 DBWR 0M 0.0 0M 359M 4.7 .049748 12 0.0 LGWR 1M 0.0 .000138 123M 2.3 .017044 90 9.4 Direct Writes 0M 0.0 0M 23M 0.0 .003187 0 N/A Direct Reads 20M 0.1 .002771 0M 0.0 0M 0 N/A Streams AQ 0M 0.0 0M 0M 0.0 0M 55 0.4 TOTAL: 23.5G 240.9 3.33010 757M 8.1 .104901 1710.5K 0.2 ------------------------------------------------------------- IOStat by Filetype summary DB/Inst: PROD/Prod Snaps: 476-478 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> Small Read and Large Read are average service times, in milliseconds -> Ordered by (Data Read + Write) desc Reads: Reqs Data Writes: Reqs Data Small Large Filetype Name Data per sec per sec Data per sec per sec Read Read --------------- ------- ------- ------- ------- ------- ------- ------- ------- Data File 23.1G 239.0 3.28118 353M 4.7 .048917 0.2 1.2 Control File 200M 1.8 .027715 122M 1.1 .016906 0.0 4.7 Log File 126M 0.0 .017460 122M 2.2 .016906 1.1 107.9 Archive Log 0M 0.0 0M 126M 0.0 .017460 N/A N/A Temp File 27M 0.1 .003741 29M 0.1 .004018 1.7 1.3 TOTAL: 23.5G 240.9 3.33010 752M 8.1 .104208 0.2 2.1 ------------------------------------------------------------- IOStat by Function/Filetype summary DB/Inst: PROD/Prod Snaps: 476-478 -> 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000 -> Ordered by (Data Read + Write) desc for each function Reads: Reqs Data Writes: Reqs Data Waits: Avg Data per sec per sec Data per sec per sec Count Tm(ms) ------- ------- ------- ------- ------- ------- ------- ------- Buffer Cache Reads (Data File) 23.1G 239.0 3.28229 0M 0.0 0M 1688.5K 0.2 Buffer Cache Reads 23.1G 239.0 3.28229 0M 0.0 0M 1688.5K 0.2 Others 326M 1.8 .045175 252M 1.1 .034920 12.8K 0.1 Others (Control File) 199M 1.8 .027576 121M 1.1 .016767 12.7K 0.0 Others (Log File) 126M 0.0 .017460 0M 0.0 0M 12 0.0 Others (Archive Log) 0M 0.0 0M 126M 0.0 .017460 0 N/A Others (Data File) 1M 0.0 .000138 5M 0.0 .000692 117 7.8 DBWR (Data File) 0M 0.0 0M 359M 4.7 .049748 0 N/A DBWR 0M 0.0 0M 359M 4.7 .049748 12 0.0 DBWR (Control File) 0M 0.0 0M 0M 0.0 0M 12 0.0 LGWR 1M 0.0 .000138 123M 2.3 .017044 60 2.0 LGWR (Log File) 0M 0.0 0M 122M 2.2 .016906 12 9.8 LGWR (Control File) 1M 0.0 .000138 1M 0.0 .000138 48 0.0 Direct Writes (Data File) 0M 0.0 0M 23M 0.0 .003187 0 N/A Direct Writes 0M 0.0 0M 23M 0.0 .003187 0 N/A Direct Reads (Data File) 20M 0.1 .002771 0M 0.0 0M 0 N/A Direct Reads 20M 0.1 .002771 0M 0.0 0M 0 N/A Streams AQ (Data File) 0M 0.0 0M 0M 0.0 0M 55 0.4 Streams AQ 0M 0.0 0M 0M 0.0 0M 55 0.4 TOTAL: 23.5G 240.9 3.33038 757M 8.1 .104901 1701.4K 0.2 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: PROD/Prod Snaps: 476-478 -> 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) -------------- ------- ------- ------- ------------ -------- ---------- ------- DMS_TAB3 532,595 74 0.1 2.0 3,632 1 17 2.9 DMS_TAB2 366,001 51 0.1 1.7 3,766 1 438 0.2 TSIDH 279,818 39 0.1 1.0 1,337 0 562 1.1 DMS_TAB1 206,843 29 0.1 1.8 3,974 1 95 0.5 DMS_IDX6 143,276 20 0.5 1.0 7,508 1 171 0.7 DMS_TAB5 53,431 7 0.3 5.0 1,353 0 242 19.9 TSAHCLARGE 49,912 7 0.6 2.9 1,705 0 22 0.9 SYSTEM 41,425 6 0.4 1.4 1,151 0 9 2.2 SYSAUX 24,002 3 0.5 1.3 5,997 1 0 0.0 DMS_TAB6 13,125 2 0.3 1.1 629 0 1 0.0 AHC_TAB1 5,988 1 1.6 1.9 141 0 0 0.0 AHC_IDX6 5,357 1 0.9 1.7 355 0 0 0.0 TSUNDO 645 0 3.5 1.0 2,126 0 14 0.0 TSTEMP 623 0 1.7 5.6 599 0 0 0.0 USERS 1,140 0 0.5 1.3 55 0 0 0.0 TSIMAGES 464 0 0.1 1.5 3 0 0 0.0 TS_INDEX 317 0 0.4 1.0 3 0 0 0.0 TS7 233 0 0.2 1.0 3 0 0 0.0 AHC_IDX 17 0 3.5 1.0 3 0 0 0.0 APEX_1250507884972956 17 0 2.4 1.0 3 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: PROD/Prod Snaps: 476-478 -> 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) -------------- ------- ------- ------- ------------ -------- ---------- ------- AHC_IDX /data2/oracle/Prod/ahc_idxProd.dbf 17 0 3.5 1.0 3 0 0 0.0 AHC_IDX6 /data3/oracle/Prod/ahc_idx6Prod.dbf 5,357 1 0.9 1.7 355 0 0 0.0 AHC_TAB1 /data8/oracle/Prod/ahc_tab1Prod.dbf 5,988 1 1.6 1.9 141 0 0 0.0 APEX_1250507884972956 /data8/oracle/Prod/APEX_1250507884972956.dbf 17 0 2.4 1.0 3 0 0 0.0 DMS_IDX6 /data7/oracle/Prod/dms_idx6Prod.dbf 143,276 20 0.5 1.0 7,508 1 171 0.7 DMS_TAB1 /data5/oracle/Prod/dms_tab1Prod.dbf 206,843 29 0.1 1.8 3,974 1 95 0.5 DMS_TAB2 /data3/oracle/Prod/dms_tab2Prod.dbf 366,001 51 0.1 1.7 3,766 1 438 0.2 DMS_TAB3 /data4/oracle/Prod/dms_tab3Prod.dbf 532,595 74 0.1 2.0 3,632 1 17 2.9 DMS_TAB5 /data3/oracle/Prod/dms_tab5Prod.dbf 53,431 7 0.3 5.0 1,353 0 242 19.9 DMS_TAB6 /data4/oracle/Prod/dms_tab6Prod.dbf 13,125 2 0.3 1.1 629 0 1 0.0 SYSAUX /data8/oracle/Prod/sysauxProd.dbf 24,002 3 0.5 1.3 5,997 1 0 0.0 SYSTEM /data1/oracle/Prod/systemProd.dbf 41,425 6 0.4 1.4 1,151 0 9 2.2 TS7 /data8/oracle/Prod/ts7Prod.dbf 233 0 0.2 1.0 3 0 0 0.0 TSAHCLARGE /data4/oracle/Prod/tsahclargeProd.dbf 49,912 7 0.6 2.9 1,705 0 22 0.9 TSIDH /data5/oracle/Prod/tsidhProd.dbf 279,818 39 0.1 1.0 1,337 0 562 1.1 TSIMAGES /data7/oracle/Prod/tsimagesProd.dbf 464 0 0.1 1.5 3 0 0 0.0 TSTEMP /data6/oracle/Prod/tstempProd.dbf 623 0 1.7 5.6 599 0 0 N/A TSUNDO /data2/oracle/Prod/tsundoProd.dbf 645 0 3.5 1.0 2,126 0 14 0.0 TS_INDEX /data8/oracle/Prod/ts_indexProd.dbf 317 0 0.4 1.0 3 0 0 0.0 USERS /data8/oracle/Prod/usersProd.dbf 1,140 0 0.5 1.3 55 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: PROD/Prod Snaps: 476-478 -> 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 88,650 97 90,192,023 3,031,921 46,052 0 0 1,571 ------------------------------------------------------------- Checkpoint Activity DB/Inst: PROD/Prod Snaps: 476-478 -> Total Physical Writes: 49,280 Other Autotune Thread MTTR Log Size Log Ckpt Settings Ckpt Ckpt Writes Writes Writes Writes Writes Writes ----------- ----------- ----------- ----------- ----------- ----------- 0 0 0 0 2,280 0 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: PROD/Prod Snaps: 476-478 -> B: Begin Snapshot, E: End Snapshot Estd Targt Estd Log Ckpt Log Ckpt Opt RAC MTTR MTTR Recovery Actual Target Log Sz Timeout Interval Log Avail (s) (s) Estd IOs RedoBlks RedoBlks RedoBlks RedoBlks RedoBlks Sz(M) Time - ----- ----- -------- -------- -------- -------- -------- -------- ------ ----- B 0 17 1258 13311 41304 746496 41304 500000 N/A N/A E 0 17 1884 19124 66809 746496 66809 500000 N/A N/A ------------------------------------------------------------- MTTR Advisory DB/Inst: PROD/Prod Snap: 478 No data exists for this section of the report. ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: PROD/Prod Snap: 478 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Estimated Est Size for Size Buffers Read Phys Reads Est Phys %DBtime P Est (M) Factor (thousands) Factor (thousands) Read Time for Rds --- -------- ------ ------------ ------ -------------- ------------ ------- D 64 .1 8 6.0 2,423,227 1 3.6E+05 D 128 .2 16 3.9 1,586,280 1 2.2E+05 D 192 .3 24 3.4 1,376,818 1 1.8E+05 D 256 .3 32 3.0 1,198,563 1 1.5E+05 D 320 .4 39 2.6 1,058,249 1 1.3E+05 D 384 .5 47 2.3 911,742 1 1.1E+05 D 448 .6 55 2.0 812,745 1 9.0E+04 D 512 .7 63 1.8 716,185 1 7.4E+04 D 576 .8 71 1.6 636,485 1 6.0E+04 D 640 .9 79 1.3 532,710 1 4.3E+04 D 704 1.0 87 1.1 432,922 1 2.7E+04 D 736 1.0 91 1.0 403,465 1 2.2E+04 D 768 1.0 95 0.9 359,603 1 1.5E+04 D 832 1.1 102 0.8 313,586 1 7248.0 D 896 1.2 110 0.7 278,347 1 5974.0 D 960 1.3 118 0.6 252,768 1 5968.0 D 1,024 1.4 126 0.6 232,894 1 5962.0 D 1,088 1.5 134 0.5 214,535 1 5957.0 D 1,152 1.6 142 0.5 196,378 1 5952.0 D 1,216 1.7 150 0.4 178,013 1 5948.0 D 1,280 1.7 158 0.4 160,693 1 5943.0 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: PROD/Prod Snaps: 476-478 -> 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 --------------- ------------------ -------------------------- 99.2 6,734 54 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: PROD/Prod Snaps: 476-478 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 1,045,723 1,045,723 0 0 64K 128K 565 565 0 0 128K 256K 113 113 0 0 256K 512K 158 158 0 0 512K 1024K 3,971 3,971 0 0 1M 2M 784 784 0 0 2M 4M 122 122 0 0 4M 8M 12 4 8 0 16M 32M 2 2 0 0 32M 64M 1 1 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: PROD/Prod Snap: 478 -> 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 ---------- ------- ---------------- ---------------- ------ -------- ------- 268 0.1 479,812.2 6,904.2 99.0 405 3.2E+08 536 0.3 479,812.2 172.8 100.0 2 3.1E+08 1,072 0.5 479,812.2 30.2 100.0 0 3.1E+08 1,608 0.8 479,812.2 30.2 100.0 0 3.1E+08 2,144 1.0 479,812.2 30.2 100.0 0 3.1E+08 2,573 1.2 479,812.2 0.0 100.0 0 3.1E+08 3,002 1.4 479,812.2 0.0 100.0 0 3.1E+08 3,430 1.6 479,812.2 0.0 100.0 0 3.1E+08 3,859 1.8 479,812.2 0.0 100.0 0 3.1E+08 4,288 2.0 479,812.2 0.0 100.0 0 3.1E+08 6,432 3.0 479,812.2 0.0 100.0 0 3.1E+08 8,576 4.0 479,812.2 0.0 100.0 0 3.1E+08 12,864 6.0 479,812.2 0.0 100.0 0 3.1E+08 17,152 8.0 479,812.2 0.0 100.0 0 3.1E+08 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: PROD/Prod Snap: 478 -> 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) -------- ----- -------- ------------ -------- ------ ------- ------ ------------ 1,184 .5 115 7,036 1.84E+06 1.0 1.6E+05 1.2 71,371 1,424 .6 356 17,744 1.85E+06 1.0 1.5E+05 1.1 150,255 1,664 .7 594 24,417 1.86E+06 1.0 1.4E+05 1.0 150,743 1,904 .8 834 31,586 1.87E+06 1.0 1.4E+05 1.0 150,885 2,144 .9 1,074 37,267 1.87E+06 1.0 1.4E+05 1.0 150,968 2,384 1.0 1,313 39,998 1.87E+06 1.0 1.3E+05 1.0 151,013 2,624 1.1 1,551 40,884 1.87E+06 1.0 1.3E+05 1.0 151,046 2,864 1.2 1,791 46,400 1.87E+06 1.0 1.3E+05 1.0 151,081 3,104 1.3 2,031 59,145 1.87E+06 1.0 1.3E+05 1.0 151,126 3,344 1.4 2,270 70,243 1.87E+06 1.0 1.3E+05 1.0 151,193 3,584 1.5 2,510 77,402 1.87E+06 1.0 1.3E+05 1.0 151,260 3,824 1.6 2,750 83,114 1.87E+06 1.0 1.3E+05 1.0 151,295 4,064 1.7 2,989 85,602 1.87E+06 1.0 1.3E+05 1.0 151,307 4,304 1.8 3,229 92,002 1.87E+06 1.0 1.3E+05 1.0 151,318 4,544 1.9 3,469 102,154 1.87E+06 1.0 1.3E+05 1.0 151,338 4,784 2.0 3,708 109,175 1.87E+06 1.0 1.3E+05 1.0 151,360 ------------------------------------------------------------- SGA Target Advisory DB/Inst: PROD/Prod Snap: 478 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 2,000 0.5 1,450,322 3,512,486,772 3,000 0.8 1,086,676 454,543,821 4,000 1.0 1,065,473 403,465,135 5,000 1.3 1,062,277 366,386,689 6,000 1.5 1,060,572 366,386,689 7,000 1.8 1,059,933 232,920,422 8,000 2.0 1,059,933 232,920,422 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: PROD/Prod Snap: 478 Size for Size Est Spill Est Spill Est Unspill Est Unspill Est (MB) Factor Count Time (s) Count Time (s) ---------- --------- ----------- ----------- ----------- ----------- 16 0.5 0 0 0 0 32 1.0 0 0 0 0 48 1.5 0 0 0 0 64 2.0 0 0 0 0 80 2.5 0 0 0 0 96 3.0 0 0 0 0 112 3.5 0 0 0 0 128 4.0 0 0 0 0 144 4.5 0 0 0 0 160 5.0 0 0 0 0 176 5.5 0 0 0 0 192 6.0 0 0 0 0 208 6.5 0 0 0 0 224 7.0 0 0 0 0 240 7.5 0 0 0 0 256 8.0 0 0 0 0 272 8.5 0 0 0 0 288 9.0 0 0 0 0 304 9.5 0 0 0 0 320 10.0 0 0 0 0 ------------------------------------------------------------- Java Pool Advisory DB/Inst: PROD/Prod Snap: 478 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: PROD/Prod Snaps: 476-478 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 1,556 6 4 undo header 10 0 0 undo block 4 0 0 1st level bmb 1 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: PROD/Prod Snaps: 476-478 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- TX-Transaction (row lock contention) 62 51 10 52 151 2,899.31 RO-Multiple Object Reuse (fast object reuse) 1,512 1,512 0 148 6 39.51 TC-Tablespace Checkpoint 24 24 0 7 0 50.57 ------------------------------------------------------------- Undo Segment Summary DB/Inst: PROD/Prod Snaps: 476-478 -> 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 ---- ---------- --------------- -------- -------- --------- ----- -------------- 2 4.9 19,475 2,646 10 3361.5/34 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: PROD/Prod Snaps: 476-478 -> 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 ------------ ----------- ------------ ------- ------- ------- ----- ------------ 16-Mar 15:54 533 1,892 1,844 7 3,397 0/0 0/0/0/0/0/0 16-Mar 15:44 363 1,888 2,237 7 3,392 0/0 0/0/0/0/0/0 16-Mar 15:34 284 1,454 1,602 7 3,386 0/0 0/0/0/0/0/0 16-Mar 15:24 168 1,257 1,740 9 3,378 0/0 0/0/0/0/0/0 16-Mar 15:14 184 1,453 1,709 8 3,370 0/0 0/0/0/0/0/0 16-Mar 15:04 1,319 2,057 1,808 8 3,361 0/0 0/0/0/0/0/0 16-Mar 14:54 496 1,636 1,372 7 3,420 0/0 0/0/0/0/0/0 16-Mar 14:44 166 1,813 2,646 8 3,419 0/0 0/0/0/0/0/0 16-Mar 14:34 149 1,344 2,045 8 3,412 0/0 0/0/0/0/0/0 16-Mar 14:24 155 1,020 2,562 10 3,403 0/0 0/0/0/0/0/0 16-Mar 14:14 184 1,710 1,962 7 3,395 0/0 0/0/0/0/0/0 16-Mar 14:04 943 1,951 1,360 7 3,386 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ AQ deq hash table latch 118 0.0 0 0 N/A AQ deq log cmt cbk chunk 8 0.0 0 0 N/A AQ deq log statistics la 4 0.0 0 0 N/A AQ dequeue txn counter l 6,264 0.0 0 0 N/A AQ ht cmt cbk chunk latc 16 0.0 0 0 N/A ASM db client latch 5,175 0.0 0 0 N/A ASM map operation hash t 2 0.0 0 0 N/A ASM network state latch 154 0.0 0 0 N/A AWR Alerted Metric Eleme 67,671 0.0 0 0 N/A Change Notification Hash 2,414 0.0 0 0 N/A Consistent RBA 15,971 0.0 0 0 N/A DML lock allocation 78,810,765 0.0 0.0 0 0 N/A Event Group Locks 2,718 0.0 0 0 N/A FAL Queue 198 0.0 0 0 N/A FIB s.o chain latch 22 0.0 0 0 N/A FOB s.o list latch 13,246 0.0 0 0 N/A File State Object Pool P 2 0.0 0 0 N/A IPC stats buffer allocat 2 0.0 0 0 N/A In memory undo latch 800 0.0 0 19,332 0.0 JS Sh mem access 38 0.0 0 0 N/A JS mem alloc latch 90 0.0 0 0 N/A JS queue access latch 92 0.0 0 0 N/A JS queue state obj latch 54,186 0.0 0 0 N/A JS slv state obj latch 1,458 0.2 0.0 0 0 N/A KFC FX Hash Latch 2 0.0 0 0 N/A KFC Hash Latch 2 0.0 0 0 N/A KFCL LE Freelist 2 0.0 0 0 N/A KGNFS-NFS:SHM structure 2 0.0 0 0 N/A KGNFS-NFS:SVR LIST 2 0.0 0 0 N/A KJC message pool free li 2 0.0 0 0 N/A KJCT flow control latch 2 0.0 0 0 N/A KMG MMAN ready and start 2,407 0.0 0 0 N/A KTF sga latch 42 0.0 0 2,044 0.0 KWQMN job cache list lat 36 0.0 0 0 N/A KWQP Prop Status 4 0.0 0 0 N/A KWQS pqsubs latch 16 0.0 0 0 N/A KWQS pqueue ctx latch 234 0.0 0 0 N/A Locator state objects po 2 0.0 0 0 N/A Lsod array latch 2 0.0 0 0 N/A MQL Tracking Latch 0 N/A 0 144 0.0 Memory Management Latch 2 0.0 0 2,407 0.0 Memory Queue 2 0.0 0 0 N/A Memory Queue Message Sub 2 0.0 0 0 N/A Memory Queue Message Sub 2 0.0 0 0 N/A Memory Queue Message Sub 2 0.0 0 0 N/A Memory Queue Message Sub 2 0.0 0 0 N/A Memory Queue Subscriber 2 0.0 0 0 N/A Mutex 2 0.0 0 0 N/A Mutex Stats 2 0.0 0 0 N/A OS process 9,719 0.0 0 0 N/A OS process allocation 8,893 0.0 0 0 N/A OS process: request allo 5,426 0.0 0 0 N/A PL/SQL warning settings 55,034 0.0 0 0 N/A PX hash array latch 2 0.0 0 0 N/A QMT 2 0.0 0 0 N/A Real-time plan statistic 8,730 0.0 0 0 N/A Result Cache: RC Latch 29 0.0 0 0 N/A Result Cache: SO Latch 2 0.0 0 0 N/A SGA IO buffer pool latch 86 0.0 0 109 0.0 SGA blob parent 2 0.0 0 0 N/A Latch Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "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 bucket locks 2 0.0 0 0 N/A SGA heap locks 2 0.0 0 0 N/A SGA pool locks 2 0.0 0 0 N/A SQL memory manager latch 242 0.0 0 2,379 0.0 SQL memory manager worka 6,447,453 0.0 0.0 0 0 N/A Shared B-Tree 927 0.0 0 0 N/A Streams Generic 2 0.0 0 0 N/A Testing 2 0.0 0 0 N/A Token Manager 2 0.0 0 0 N/A WCR: sync 2 0.0 0 0 N/A Write State Object Pool 2 0.0 0 0 N/A X$KSFQP 2 0.0 0 0 N/A XDB NFS Security Latch 2 0.0 0 0 N/A XDB unused session pool 2 0.0 0 0 N/A XDB used session pool 2 0.0 0 0 N/A active checkpoint queue 14,275 0.0 0.0 0 0 N/A active service list 43,947 0.0 0.2 0 457,180 0.0 alert log latch 6 0.0 0 0 N/A archive control 563 0.0 0 0 N/A archive process latch 597 0.0 0 0 N/A begin backup scn array 19 0.0 0 0 N/A buffer pool 2 0.0 0 0 N/A business card 2 0.0 0 0 N/A cache buffer handles 13,117,526 0.1 0.0 0 0 N/A cache buffers chains 175,059,500 0.0 0.0 0 54,310,545 0.0 cache buffers lru chain 150,473 0.3 0.1 0 53,032,445 0.1 cache table scan latch 213,699 0.0 0.1 0 213,699 0.0 call allocation 11,384 0.1 0.5 0 0 N/A cas latch 2 0.0 0 0 N/A change notification clie 2 0.0 0 0 N/A channel handle pool latc 5,568 0.0 0 0 N/A channel operations paren 54,197 0.0 0 0 N/A checkpoint queue latch 445,749 0.0 0.1 0 45,949 0.0 client/application info 35,728 0.0 0 0 N/A compile environment latc 2,874 0.0 0 0 N/A corrupted undo seg latch 10,412 0.0 0 0 N/A cp cmon/server latch 2 0.0 0 0 N/A cp pool latch 2 0.0 0 0 N/A cp server hash latch 2 0.0 0 0 N/A cp sga latch 154 0.0 0 0 N/A cvmap freelist lock 2 0.0 0 0 N/A deferred cleanup latch 154 0.0 0 0 N/A dml lock allocation 156 0.0 0 0 N/A done queue latch 2 0.0 0 0 N/A dummy allocation 5,744 0.0 0.0 0 0 N/A enqueue hash chains 364,552 0.0 0.1 0 58 0.0 enqueues 215,537 0.0 0.0 0 0 N/A fifth spare latch 2 0.0 0 0 N/A file cache latch 790 0.0 0 0 N/A flashback copy 2 0.0 0 0 N/A gc element 2 0.0 0 0 N/A gcs commit scn state 2 0.0 0 0 N/A gcs partitioned table ha 2 0.0 0 0 N/A gcs pcm hashed value buc 2 0.0 0 0 N/A gcs resource freelist 2 0.0 0 0 N/A gcs resource hash 2 0.0 0 0 N/A gcs resource scan list 2 0.0 0 0 N/A gcs shadows freelist 2 0.0 0 0 N/A ges domain table 2 0.0 0 0 N/A ges enqueue table freeli 2 0.0 0 0 N/A Latch Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "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 group table 2 0.0 0 0 N/A ges process hash list 2 0.0 0 0 N/A ges process parent latch 2 0.0 0 0 N/A ges resource hash list 2 0.0 0 0 N/A ges resource scan list 2 0.0 0 0 N/A ges resource table freel 2 0.0 0 0 N/A ges value block free lis 2 0.0 0 0 N/A global KZLD latch for me 878 0.0 0 0 N/A global ctx hash table la 11 0.0 0 0 N/A global tx hash mapping 24,075 0.0 0 0 N/A granule operation 2 0.0 0 0 N/A hash table column usage 1,535 0.0 0 5,576,308 0.0 hash table modification 558 0.0 0 0 N/A heartbeat check 2 0.0 0 0 N/A internal temp table obje 15 0.0 0 0 N/A intra txn parallel recov 2 0.0 0 0 N/A io pool granule list 642 0.0 0 0 N/A io pool granule metadata 1,288 0.0 0 0 N/A job workq parent latch 157 0.0 0 155 1.3 job_queue_processes free 381 0.0 0 0 N/A job_queue_processes para 1,730 0.0 0 0 N/A k2q lock allocation 2 0.0 0 0 N/A kcbtsemkid latch 3 0.0 0 0 N/A kdlx hb parent latch 2 0.0 0 0 N/A kgb parent 2 0.0 0 0 N/A kks stats 8,221 0.0 0.5 0 0 N/A kokc descriptor allocati 3,292 0.0 0 0 N/A ksfv messages 2 0.0 0 0 N/A kss move lock 50 0.0 0 0 N/A ksuosstats global area 496 0.0 0 0 N/A ksv allocation latch 250 0.0 0 0 N/A ksv class latch 98 0.0 0 0 N/A ksv msg queue latch 2 0.0 0 0 N/A ksz_so allocation latch 5,426 0.0 0 0 N/A ktm global data 62 0.0 0 0 N/A kwqbsn:qsga 405 0.0 0 0 N/A lgwr LWN SCN 16,174 0.0 0.0 0 0 N/A list of block allocation 4,015 0.0 0 0 N/A loader state object free 84 0.0 0 0 N/A lob segment dispenser la 2 0.0 0 0 N/A lob segment hash table l 26 0.0 0 0 N/A lob segment query latch 2 0.0 0 0 N/A lock DBA buffer during m 2 0.0 0 0 N/A logical standby cache 2 0.0 0 0 N/A logminer context allocat 4 0.0 0 0 N/A logminer work area 2 0.0 0 0 N/A longop free list parent 42 0.0 0 80 0.0 managed standby latch 195 0.0 0 0 N/A mapped buffers lru chain 2 0.0 0 0 N/A message pool operations 812 0.0 0 0 N/A messages 141,912 0.0 0.0 0 0 N/A mostly latch-free SCN 16,196 0.1 0.0 0 0 N/A msg queue latch 2 0.0 0 0 N/A multiblock read objects 830,524 0.0 0.0 0 4 0.0 name-service namespace b 2 0.0 0 0 N/A ncodef allocation latch 154 0.0 0 0 N/A object queue header heap 96,857 0.0 0.0 0 40,545 0.0 object queue header oper 6,343,350 0.0 0.0 0 0 N/A object stats modificatio 1,387 0.0 0 0 N/A parallel query alloc buf 950 0.0 0 0 N/A Latch Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ parallel query stats 2 0.0 0 0 N/A parameter list 4,117 0.0 0 0 N/A parameter table manageme 5,791 0.0 0 0 N/A peshm 2 0.0 0 0 N/A pesom_free_list 2 0.0 0 0 N/A pesom_hash_node 2 0.0 0 0 N/A post/wait queue 11,945 0.0 0.0 0 7,490 0.0 process allocation 5,691 0.0 0 2,717 0.0 process group creation 5,426 0.0 0 0 N/A process queue 2 0.0 0 0 N/A process queue reference 2 0.0 0 0 N/A qmn task queue latch 2,305 0.8 0.1 0 0 N/A query server freelists 2 0.0 0 0 N/A queued dump request 25 0.0 0 0 N/A queuing load statistics 2 0.0 0 0 N/A recovery domain hash lis 2 0.0 0 0 N/A redo allocation 49,244 0.0 0.0 0 340,578 0.0 redo copy 2 0.0 0 340,614 0.1 redo writing 67,158 0.0 0.0 0 0 N/A resmgr group change latc 6,524 0.0 0 0 N/A resmgr:active threads 5,847 0.0 0 0 N/A resmgr:actses change gro 2,543 0.0 0 0 N/A resmgr:actses change sta 102 0.0 0 0 N/A resmgr:free threads list 5,742 0.0 0.0 0 0 N/A resmgr:plan CPU method 2 0.0 0 0 N/A resmgr:resource group CP 2 0.0 0 0 N/A resmgr:schema config 165 0.0 0 0 N/A resmgr:session queuing 2 0.0 0 0 N/A rm cas latch 2 0.0 0 0 N/A row cache objects 27,741,645 0.0 0.0 0 14,956 0.2 rules engine aggregate s 4 0.0 0 0 N/A rules engine rule set st 208 0.0 0 0 N/A second spare latch 2 0.0 0 0 N/A sequence cache 12,081 0.0 0 0 N/A session allocation 148,213 0.0 0.3 0 49,409 0.0 session idle bit 1,214,196 0.0 0.0 0 0 N/A session queue latch 2 0.0 0 0 N/A session state list latch 2,756 0.0 0 0 N/A session switching 13,701 0.0 0 0 N/A session timer 3,231 0.0 0 0 N/A shared pool 815,642 0.1 0.1 0 0 N/A shared pool sim alloc 2 0.0 0 0 N/A shared pool simulator 40,900 0.0 0 0 N/A sim partition latch 2 0.0 0 0 N/A simulator hash latch 7,024,691 0.0 0.0 0 0 N/A simulator lru latch 14,053 0.2 0.0 0 6,929,334 0.1 sort extent pool 601 0.0 0 0 N/A space background task la 5,419 0.3 0.5 0 4,814 0.0 state object free list 4 0.0 0 0 N/A statistics aggregation 1,120 0.0 0 0 N/A tablespace key chain 3 0.0 0 0 N/A temp lob duration state 53 0.0 0 0 N/A temporary table state ob 15 0.0 0 0 N/A test excl. parent l0 2 0.0 0 0 N/A test excl. parent2 l0 2 0.0 0 0 N/A third spare latch 2 0.0 0 0 N/A threshold alerts latch 578 0.0 0 0 N/A transaction allocation 60,159,477 0.0 0.0 0 0 N/A transaction branch alloc 3,917 0.0 0 0 N/A undo global data 78,225 0.0 0.0 0 0 N/A Latch Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ virtual circuit buffers 2 0.0 0 0 N/A virtual circuit holder 2 0.0 0 0 N/A virtual circuit queues 2 0.0 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: PROD/Prod Snaps: 476-478 -> ordered by misses desc Get Spin Latch Name Requests Misses Sleeps Gets -------------------------- --------------- ------------ ----------- ----------- row cache objects 27,741,645 12,552 59 12,494 cache buffer handles 13,117,526 10,973 3 10,970 cache buffers chains 175,059,500 4,340 113 4,227 shared pool 815,642 499 36 465 DML lock allocation 78,810,765 420 1 419 cache buffers lru chain 150,473 377 20 357 object queue header operat 6,343,350 315 5 311 transaction allocation 60,159,477 117 1 116 multiblock read objects 830,524 75 2 73 simulator hash latch 7,024,691 31 1 30 simulator lru latch 14,053 23 1 22 cache table scan latch 213,699 20 1 19 qmn task queue latch 2,305 19 2 18 enqueue hash chains 364,552 18 1 17 space background task latc 5,419 15 8 7 active service list 43,947 13 3 10 call allocation 11,384 10 5 5 checkpoint queue latch 445,749 8 1 7 session allocation 148,213 3 1 2 kks stats 8,221 2 1 1 ------------------------------------------------------------- Latch Miss Sources DB/Inst: PROD/Prod Snaps: 476-478 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- DML lock allocation ktadmc 0 1 0 active service list kswslogon: session logout 0 3 2 cache buffer handles kcbzfs 0 3 1 cache buffers chains kcbgtcr_2 0 70 58 cache buffers chains kcbgtcr: fast path (cr pin 0 48 56 cache buffers chains kcbchg1: kslbegin: bufs no 0 14 4 cache buffers chains kcbrls_1 0 7 19 cache buffers chains kcbgtcr: kslbegin shared 0 6 5 cache buffers chains kcbzibmlt: multi-block rea 0 6 0 cache buffers chains kcbgcur_2 0 4 0 cache buffers chains kcbgtcr: fast path 0 3 1 cache buffers chains kcbrls_2 0 1 3 cache buffers chains kcbzibmlt: finish free buf 0 1 0 cache buffers lru chain kcbzgws 0 19 0 cache buffers lru chain kcbzgm 0 1 0 cache table scan latch kcbz_find_table_scan_read_ 0 1 0 call allocation ksuxds 0 4 2 call allocation ksudlp: top call 0 1 3 checkpoint queue latch kcbbwdl: thread checkpoint 0 1 0 enqueue hash chains ksqcmi: kslgpl 0 1 0 kks stats kksAllocChildStat 0 1 1 multiblock read objects kcbzibmlt 0 1 1 multiblock read objects kcbzibmlt: normal mbr free 0 1 1 object queue header oper kcbo_switch_mq_bg 0 2 0 object queue header oper kcbo_switch_q_bg 0 2 0 object queue header oper kcbo_ivbo 0 1 0 qmn task queue latch kwqmndntsk: task done but 0 1 2 qmn task queue latch kwqmngettsk: get task 0 1 0 row cache objects kqrget2 0 38 0 row cache objects kqreqd: reget 0 16 0 row cache objects kqrpre: find obj 0 5 55 session allocation ksuxds_int 0 1 0 shared pool kghalo 0 24 18 shared pool kghfre 0 8 0 shared pool kghupr1 0 3 9 shared pool kghalp 0 1 7 simulator hash latch kcbsacc: lookup dba 0 1 1 simulator lru latch kcbs_simulate: simulate se 0 1 0 space background task la ktsj_grab_task 0 8 8 transaction allocation ktcxbr 0 1 0 ------------------------------------------------------------- Mutex Sleep Summary DB/Inst: PROD/Prod Snaps: 476-478 -> ordered by number of sleeps desc Wait Mutex Type Location Sleeps Time (ms) --------------------- -------------------------------- ------------ ------------ Cursor Pin kkslce [KKSCHLPIN2] 2,557 -7,697 Library Cache kgllkdl1 85 1,157 5 Library Cache kglhdgn2 106 433 4 Library Cache kglget2 2 15 5 Library Cache kgllkc1 57 7 0 Library Cache kglpin1 4 6 -0 Library Cache kglpndl1 95 5 -0 Library Cache kglIsOwnerVersionable 121 4 -0 Library Cache kglpnal1 90 3 -14 Library Cache kgldtin1 42 1 -0 Cursor Parent kkscsPruneChild [KKSPRTLOC35] 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: PROD/Prod Snaps: 476-478 -> Total Logical Reads: 90,212,126 -> Captured Segments account for 87.8% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 ITEM_PURCHASE_SOURCE TABLE 10,491,008 11.63 S DMS_TAB2 SALES_ORDER_HEADER TABLE 8,759,552 9.71 SYS SYSTEM USER$ TABLE 6,723,232 7.45 SYS SYSTEM I_OBJAUTH1 INDEX 5,216,656 5.78 S DMS_TAB3 SALES_ORDER_DETAIL TABLE 5,111,936 5.67 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: PROD/Prod Snaps: 476-478 -> Total Physical Reads: 3,034,177 -> Captured Segments account for 61.4% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 SALES_ORDER_DETAIL TABLE 675,798 22.27 S DMS_TAB2 SALES_ORDER_HEADER TABLE 193,863 6.39 S DMS_TAB1 SHIPMENT_SCHEDULE TABLE 172,275 5.68 S DMS_TAB2 WORK_ORDER_DETAIL TABLE 117,756 3.88 S DMS_TAB2 PURCHASE_ORDER_DETAI TABLE 110,878 3.65 ------------------------------------------------------------- Segments by Physical Read Requests DB/Inst: PROD/Prod Snaps: 476-478 -> Total Physical Read Requests: 1,725,240 -> Captured Segments account for 53.3% of Total Tablespace Subobject Obj. Phys Read Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 SALES_ORDER_DETAIL TABLE 275,074 15.94 S DMS_TAB2 SALES_ORDER_HEADER TABLE 119,845 6.95 S DMS_TAB2 WORK_ORDER_DETAIL TABLE 98,993 5.74 S DMS_TAB2 PURCHASE_ORDER_DETAI TABLE 82,009 4.75 S TSIDH SALES_MGMT_NOTES TABLE 71,419 4.14 ------------------------------------------------------------- Segments by UnOptimized Reads DB/Inst: PROD/Prod Snaps: 476-478 -> Total UnOptimized Read Requests: 1,725,240 -> Captured Segments account for 53.3% of Total Tablespace Subobject Obj. UnOptimized Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 SALES_ORDER_DETAIL TABLE 275,074 15.94 S DMS_TAB2 SALES_ORDER_HEADER TABLE 119,845 6.95 S DMS_TAB2 WORK_ORDER_DETAIL TABLE 98,993 5.74 S DMS_TAB2 PURCHASE_ORDER_DETAI TABLE 82,009 4.75 S TSIDH SALES_MGMT_NOTES TABLE 71,419 4.14 ------------------------------------------------------------- Segments by Optimized Reads DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Segments by Direct Physical Reads DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Segments by Physical Writes DB/Inst: PROD/Prod Snaps: 476-478 -> Total Physical Writes: 49,280 -> Captured Segments account for 28.5% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 SALES_ORDER_DETAIL TABLE 2,825 5.73 SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 2,053 4.17 S DMS_TAB1 SHIPMENT_SCHEDULE TABLE 2,005 4.07 SYS SYSAUX I_WRI$_OPTSTAT_HH_OB INDEX 1,026 2.08 S DMS_TAB5 WEB_CUSTOMER_SHOPPIN TABLE 685 1.39 ------------------------------------------------------------- Segments by Physical Write Requests DB/Inst: PROD/Prod Snaps: 476-478 -> Total Physical Write Requestss: 34,343 -> Captured Segments account for 31.3% of Total Tablespace Subobject Obj. Phys Write Owner Name Object Name Name Type Requests %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB3 SALES_ORDER_DETAIL TABLE 2,479 7.22 S DMS_TAB1 SHIPMENT_SCHEDULE TABLE 1,509 4.39 SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 799 2.33 SYS SYSAUX I_WRI$_OPTSTAT_HH_OB INDEX 743 2.16 S DMS_TAB5 WEB_CUSTOMER_SHOPPIN TABLE 666 1.94 ------------------------------------------------------------- Segments by Direct Physical Writes DB/Inst: PROD/Prod Snaps: 476-478 -> Total Direct Physical Writes: 3,228 -> Captured Segments account for 4.7% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_ACTIVE_SESSION_ 795046_466 TABLE 149 4.62 SYS SYSAUX SYS_LOB0000006213C00 LOB 3 .09 ------------------------------------------------------------- Segments by Table Scans DB/Inst: PROD/Prod Snaps: 476-478 -> Total Table Scans: 821 -> Captured Segments account for 15.2% of Total Tablespace Subobject Obj. Table Owner Name Object Name Name Type Scans %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM I_USER2 INDEX 120 14.62 S DMS_IDX6 UIWCSC_ORDER_SEQ INDEX 2 .24 S DMS_TAB2 WORK_ORDER_DETAIL TABLE 2 .24 S TSIDH SALES_MGMT_NOTES TABLE 1 .12 ------------------------------------------------------------- Segments by DB Blocks Changes DB/Inst: PROD/Prod Snaps: 476-478 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB1 SHIPMENT_SCHEDULE TABLE 11,440 12.46 S DMS_TAB3 SALES_ORDER_DETAIL TABLE 8,416 9.17 S DMS_TAB6 WORK_WWW_SHOPCARTLOG TABLE 8,208 8.94 S DMS_TAB2 WORK_ORDER_DETAIL TABLE 7,056 7.69 S DMS_TAB5 WEB_CUSTOMER_SHOPPIN TABLE 5,632 6.14 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: PROD/Prod Snaps: 476-478 -> % of Capture shows % of row lock waits for each top segment compared -> with total row lock waits for all segments captured by the Snapshot Row Tablespace Subobject Obj. Lock % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB5 WEB_CUSTOMER_SHOPPIN TABLE 22 35.48 S DMS_TAB2 PURCHASE_ORDER_DETAI TABLE 10 16.13 S DMS_TAB2 SALES_ORDER_HEADER TABLE 7 11.29 S DMS_IDX6 UIWCSC_ORDER_SEQ INDEX 5 8.06 S DMS_TAB1 CONTACT TABLE 3 4.84 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: PROD/Prod Snaps: 476-478 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- S DMS_TAB5 WEB_CUSTOMER_SHOPPIN TABLE 8 47.06 S DMS_IDX6 UIWCSC_ORDER_SEQ INDEX 3 17.65 S DMS_IDX6 IISO_DTL_SHIP_SCHED_ INDEX 1 5.88 S DMS_TAB2 ISSUE_SCHEDULE TABLE 1 5.88 S DMS_TAB2 SALES_ORDER_HEADER TABLE 1 5.88 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: PROD/Prod Snaps: 476-478 -> "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 134 0.0 0 N/A 4 1 dc_files 171 0.0 0 N/A 0 19 dc_free_extents 69 0.0 0 N/A 0 5 dc_global_oids 12,170 0.1 0 N/A 0 286 dc_histogram_data 403,563 0.1 0 N/A 2,155 7,145 dc_histogram_defs 180,608 0.5 0 N/A 1,664 12,781 dc_object_grants 772,190 0.0 0 N/A 0 1,100 dc_objects 758,599 0.1 0 N/A 172 8,413 dc_profiles 2,624 0.0 0 N/A 0 1 dc_rollback_segments 1,719 0.0 0 N/A 0 22 dc_segments 72,297 0.1 0 N/A 103 3,968 dc_sequences 1,785 0.1 0 N/A 1,785 50 dc_table_scns 4 100.0 0 N/A 0 0 dc_tablespaces 3,816,213 0.0 0 N/A 0 21 dc_users 4,029,012 0.0 0 N/A 293 691 global database name 7,150 0.0 0 N/A 0 2 outstanding_alerts 215 0.9 0 N/A 4 19 sch_lj_oids 80 0.0 0 N/A 0 15 ------------------------------------------------------------- Library Cache Activity DB/Inst: PROD/Prod Snaps: 476-478 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- APP CONTEXT 2,457 0.0 2,457 0.0 0 0 BODY 262,868 0.0 302,109 0.0 17 0 CLUSTER 1,035 0.1 131 0.8 0 0 DBLINK 8,038 0.0 0 N/A 0 0 EDITION 2,340 0.0 4,640 0.0 0 0 INDEX 583 3.8 512 8.6 0 0 OBJECT ID 7 100.0 0 N/A 0 0 PIPE 286 0.0 415 0.0 0 0 QUEUE 17,290 0.0 20,742 0.0 0 0 RULESET 4 0.0 4 0.0 0 0 SCHEMA 4,707 0.0 0 N/A 0 0 SQL AREA 109,945 7.8 1,258,665 1.5 5,209 4,589 SUBSCRIPTION 26 0.0 26 0.0 0 0 TABLE/PROCEDURE 354,070 0.2 741,081 0.2 525 0 TRIGGER 5,514 0.0 14,307 0.0 3 0 XDB ACL 554 0.0 554 0.0 0 0 XDB CONFIG 21 0.0 21 0.0 0 0 XML SCHEMA 105 0.0 189 0.0 0 0 ------------------------------------------------------------- Memory Dynamic Components DB/Inst: PROD/Prod Snaps: 476-478 -> 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 720.00 720.00 720.00 2,816.00 0 SHR/IMM KEEP buffer cac .00 .00 .00 .00 0 STA/ PGA Target 2,144.00 2,144.00 2,144.00 2,608.00 0 SHR/MAN RECYCLE buffer .00 .00 .00 .00 0 STA/ SGA Target 4,000.00 4,000.00 3,536.00 4,000.00 0 GRO/DEF Shared IO Pool 672.00 672.00 .00 672.00 0 GRO/IMM java pool 144.00 144.00 144.00 144.00 0 STA/ large pool 16.00 16.00 .00 16.00 0 GRO/IMM shared pool 2,384.00 2,384.00 672.00 2,384.00 0 GRO/IMM streams pool 32.00 32.00 .00 32.00 0 GRO/IMM ------------------------------------------------------------- Memory Resize Operations Summary DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Memory Resize Ops DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Process Memory Summary DB/Inst: PROD/Prod Snaps: 476-478 -> 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 485.4 N/A 3.1 4.4 28 28 158 158 Freeable 152.1 .0 1.2 2.5 28 N/A 130 130 PL/SQL 36.1 11.7 .2 .8 9 9 156 156 SQL 31.2 8.6 .2 .3 1 69 141 131 E Other 458.7 N/A 2.8 4.1 28 28 166 166 Freeable 159.9 .0 1.2 2.5 28 N/A 138 138 PL/SQL 40.9 18.2 .2 .8 9 10 164 164 SQL 36.9 10.9 .3 .3 1 69 147 138 ------------------------------------------------------------- SGA Memory Summary DB/Inst: PROD/Prod Snaps: 476-478 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 754,974,720 Fixed Size 2,160,072 Redo Buffers 4,538,368 Variable Size 5,653,924,408 ------------------- sum 6,415,597,568 ------------------------------------------------------------- SGA breakdown difference DB/Inst: PROD/Prod Snaps: 476-478 -> 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 144.0 144.0 0.00 large PX msg pool 7.5 7.5 0.00 large free memory 8.5 8.5 0.00 shared CCUR 392.5 426.4 8.64 shared KGLHD 41.0 43.4 5.70 shared PCUR 99.2 106.6 7.50 shared PLMCD N/A 24.7 N/A shared SQLA 972.0 1,062.5 9.31 shared SQLP 28.7 30.9 7.69 shared free memory 504.2 357.1 -29.17 shared kglsim object batch 26.7 26.7 0.00 stream KTG hash buckets .6 .6 0.00 stream free memory 31.3 31.3 0.00 buffer_cache 720.0 720.0 0.00 fixed_sga 2.1 2.1 0.00 log_buffer 4.3 4.3 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: PROD/Prod Snaps: 476-478 -> Streams processes ordered by Foreground CPU Time, descending Foreground User IO SYS IO Session Type First Logon CPU time(s) Wait time(s) Wait time(s) -------------------- ------------- ------------ ------------ ------------ QMON Slaves 0226 15:35:03 0.6 0.0 0.0 QMON Coordinator 0226 15:34:53 0.2 0.0 0.0 ------------------------------------------------------------- Streams Capture DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture Rate DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply Rate DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queue Subscribers DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: PROD/Prod Snaps: 476-478 -> Rule Sets ordered by Evaluations -> * indicates Rule Set activity (re)started between Begin/End snaps -> SQL per Eval - average # of SQL statements executed for non-SQL free evals -> CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals SQL Ela(s) CPU(s) No-SQL SQL Eval per per per Evals Eval% Execs CPU(s) Ela(s) /Sec Eval Eval Eval ---------- ------ ------- --------- --------- ------- ------- -------- -------- SYS.ALERT_QUE_R 4 0.0 0 0.0 0.0 0.0 0.0 0.00 0.00 ------------------------------------------------------------- Persistent Queues DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by Queue Name -> * indicates queue (re)started between Begin/End snaps -> %Exp Msgs - % of msgs enqueued with expiry -> %Delay Msgs - % of msgs enqueued with delay -> %Trasf Time - % of Enqueue time spent in transformation -> %Eval Time - % of Enqueue time spent in rule evaluation Enq Deq %Exp %Delay Enq Deq %Transf %Eval Msgs Msgs Msgs Msgs Time(s) Time(s) Time Time ---------- ---------- ------ ------- -------- -------- --------- ------- SYS.ALERT_QUE(12343) 4 4 100.0 0.0 0.0 4.9 0.0 4.7 SYSMAN.MGMT_NOTIFY_Q(64625) 0 0 N/A N/A 0.0 0.0 N/A N/A SYSMAN.MGMT_TASK_Q(64295) 128 128 0.0 0.0 0.2 0.5 0.0 0.0 ------------------------------------------------------------- Persistent Queues Rate DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by Queue Name -> * indicates queue (re)started between Begin/End snaps Enqueue Dequeue Avg Enqueue Avg Dequeue Msgs/sec Msgs/sec sec / msg sec / msg ---------- ---------- ------------- ------------- SYS.ALERT_QUE(12343) 0.00 0.00 0.01 1.22 SYSMAN.MGMT_NOTIFY_Q(64625) 0.00 0.00 N/A N/A SYSMAN.MGMT_TASK_Q(64295) 0.02 0.02 0.00 0.00 ------------------------------------------------------------- Persistent Queue Subscribers DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by Queue Name, Subscriber Name -> * indicates Subscriber activity (re)started between Begin/End snaps Enqueue Dequeue Expire Enqueue Dequeue Expire Msgs Msgs Msgs Msgs/sec Msgs/sec Msgs/sec ---------- ---------- ---------- ---------- ---------- ---------- ATLAS_AIRLINE_1831_PROD(22)/SYS.ALERT_QUE 4 4 0 0.00 0.00 0.00 HAE_SUB(1)/SYS.ALERT_QUE 0 0 0 N/A N/A N/A ------------------------------------------------------------- Resource Limit Stats DB/Inst: PROD/Prod Snap: 478 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Activity DB/Inst: PROD/Prod Snaps: 476-478 -> Values represent averages for all samples Avg Total Avg Active Avg Total Avg Active Avg Total Avg Active Connections Connections Shared Srvrs Shared Srvrs Dispatchers Dispatchers ------------ ------------ ------------ ------------ ------------ ------------ 0 0 1 0 1 0 ------------------------------------------------------------- Shared Servers Rates DB/Inst: PROD/Prod Snaps: 476-478 Common Disp Common Disp Server Queue Queue Server Server Queue Queue Total Server Per Sec Per Sec Msgs/Sec KB/Sec Total Total Msgs Total(KB) -------- -------- -------- --------- ---------- ---------- ---------- ---------- 0 0 0 0.0 0 0 0 0 ------------------------------------------------------------- Shared Servers Utilization DB/Inst: PROD/Prod Snaps: 476-478 -> Statistics are combined for all servers -> Incoming and Outgoing Net % are included in %Busy Total Server Incoming Outgoing Time (s) %Busy %Idle Net % Net % -------------- -------- -------- --------- --------- 7,221 0.0 100.0 0.0 0.0 ------------------------------------------------------------- Shared Servers Common Queue DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- Shared Servers Dispatchers DB/Inst: PROD/Prod Snaps: 476-478 -> Ordered by %Busy, descending -> Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue -> Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots Avg Total Disp Total Total Queue Avg Queue Name Conns Time (s) %Busy %Idle Queued Wait (s) Wait (ms) ------- --------- ---------- -------- -------- ---------- ----------- ---------- D000 0.0 7,221 0.0 100.0 0 0 ------------------------------------------------------------- init.ora Parameters DB/Inst: PROD/Prod Snaps: 476-478 -> if IP/Public/Source at End snap is different a '*' is displayed End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- compatible 11.2.0.0.0 control_files /oracle/oracle11g_db/11.2.0/dbs/c db_block_size 8192 db_domain airlinehyd.com db_files 300 db_name Prod dispatchers (PROTOCOL=TCP) (SERVICE=ProdXDB) dml_locks 1000 java_pool_size 150994944 log_archive_dest /backup/arch log_archive_format arch_%t_%s_%r.dbf log_buffer 1703936 log_checkpoint_interval 500000 max_dump_file_size 10240 memory_target 6442450944 nls_length_semantics BYTE open_cursors 750 optimizer_mode FIRST_ROWS processes 300 remote_os_authent TRUE sessions 752 undo_tablespace TSUNDO ------------------------------------------------------------- Dynamic Remastering Stats DB/Inst: PROD/Prod Snaps: 476-478 No data exists for this section of the report. ------------------------------------------------------------- End of Report