AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
| VIS | 200195696 | VIS2 | 2 | 10.2.0.3.0 | YES | hprac2.ebs.hp.com |
| Snap Id | Snap Time | Sessions | Cursors/Session |
| Begin Snap: | 1 | 08-Mar-08 07:49:59 | 3259 | 167.9 |
| End Snap: | 2 | 08-Mar-08 08:50:08 | 3253 | 174.6 |
| Elapsed: | | 60.15 (mins) | | |
| DB Time: | | 211.57 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
| Buffer Cache: | 22,480M | 22,480M | Std Block Size: | 8K |
| Shared Pool Size: | 3,008M | 3,008M | Log Buffer: | 30,696K |
Load Profile
| Per Second | Per Transaction |
| Redo size: | 595,945.38 | 3,234.48 |
| Logical reads: | 70,071.43 | 380.31 |
| Block changes: | 3,776.66 | 20.50 |
| Physical reads: | 67.96 | 0.37 |
| Physical writes: | 93.89 | 0.51 |
| User calls: | 9,478.70 | 51.45 |
| Parses: | 2,615.08 | 14.19 |
| Hard parses: | 1.40 | 0.01 |
| Sorts: | 1,256.26 | 6.82 |
| Logons: | 0.90 | 0.00 |
| Executes: | 13,169.02 | 71.47 |
| Transactions: | 184.25 | |
| % Blocks changed per Read: | 5.39 | Recursive Call %: | 72.32 |
| Rollback per transaction %: | 33.27 | Rows per Sort: | 17.75 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.90 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.98 | Soft Parse %: | 99.95 |
| Execute to Parse %: | 80.14 | Latch Hit %: | 99.83 |
| Parse CPU to Parse Elapsd %: | 57.51 | % Non-Parse CPU: | 96.80 |
Shared Pool Statistics
| Begin | End |
| Memory Usage %: | 72.44 | 81.89 |
| % SQL with executions>1: | 84.62 | 84.41 |
| % Memory for SQL w/exec>1: | 69.66 | 70.26 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
| CPU time | | 10,504 | | 82.7 | |
| log file sync | 375,854 | 696 | 2 | 5.5 | Commit |
| db file scattered read | 25,306 | 573 | 23 | 4.5 | User I/O |
| gc buffer busy | 8,039 | 430 | 53 | 3.4 | Cluster |
| wait for scn ack | 353,502 | 207 | 1 | 1.6 | Other |
RAC Statistics
| Begin | End |
| Number of Instances: | 2 | 2 |
Global Cache Load Profile
| Per Second | Per Transaction |
| Global Cache blocks received: | 116.13 | 0.63 |
| Global Cache blocks served: | 81.83 | 0.44 |
| GCS/GES messages received: | 695.02 | 3.77 |
| GCS/GES messages sent: | 651.14 | 3.53 |
| DBWR Fusion writes: | 3.99 | 0.02 |
| Estd Interconnect traffic (KB) | 1,846.63 | |
Global Cache Efficiency Percentages (Target local+remote 100%)
| Buffer access - local cache %: | 99.74 |
| Buffer access - remote cache %: | 0.17 |
| Buffer access - disk %: | 0.10 |
Global Cache and Enqueue Services - Workload Characteristics
| Avg global enqueue get time (ms): | 0.0 |
| Avg global cache cr block receive time (ms): | 1.0 |
| Avg global cache current block receive time (ms): | 0.9 |
| Avg global cache cr block build time (ms): | 0.0 |
| Avg global cache cr block send time (ms): | 0.0 |
| Global cache log flushes for cr blocks served %: | 16.7 |
| Avg global cache cr block flush time (ms): | 1.9 |
| Avg global cache current block pin time (ms): | 7,121.0 |
| Avg global cache current block send time (ms): | 0.0 |
| Global cache log flushes for current blocks served %: | 1.3 |
| Avg global cache current block flush time (ms): | 115.6 |
Global Cache and Enqueue Services - Messaging Statistics
| Avg message sent queue time (ms): | -4,314.0 |
| Avg message sent queue time on ksxp (ms): | 0.2 |
| Avg message received queue time (ms): | 0.1 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.0 |
| % of direct sent messages: | 36.88 |
| % of indirect sent messages: | 12.41 |
| % of flow controlled messages: | 50.70 |
Main Report
More RAC Statistics
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 12694.2s
- 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 | 10,515.53 | 82.84 |
| DB CPU | 10,504.03 | 82.75 |
| PL/SQL execution elapsed time | 3,184.91 | 25.09 |
| inbound PL/SQL rpc elapsed time | 1,819.39 | 14.33 |
| parse time elapsed | 641.81 | 5.06 |
| repeated bind elapsed time | 85.54 | 0.67 |
| hard parse elapsed time | 54.22 | 0.43 |
| sequence load elapsed time | 17.37 | 0.14 |
| Java execution elapsed time | 13.47 | 0.11 |
| hard parse (sharing criteria) elapsed time | 6.35 | 0.05 |
| connection management call elapsed time | 4.45 | 0.04 |
| PL/SQL compilation elapsed time | 3.66 | 0.03 |
| failed parse elapsed time | 2.17 | 0.02 |
| hard parse (bind mismatch) elapsed time | 0.00 | 0.00 |
| DB time | 12,694.24 | |
| background elapsed time | 1,180.00 | |
| background cpu time | 665.62 | |
Back to Wait Events Statistics
Back to Top
Wait Class
- s - second
- cs - centisecond - 100th of a second
- ms - millisecond - 1000th of a second
- us - microsecond - 1000000th of a second
- ordered by wait time desc, waits desc
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
| Cluster | 558,143 | 1.38 | 881 | 2 | 0.84 |
| Commit | 375,854 | 0.00 | 696 | 2 | 0.57 |
| User I/O | 48,118 | 0.00 | 695 | 14 | 0.07 |
| Other | 892,870 | 42.87 | 345 | 0 | 1.34 |
| Concurrency | 66,996 | 24.86 | 220 | 3 | 0.10 |
| System I/O | 585,567 | 0.00 | 167 | 0 | 0.88 |
| Network | 36,358,035 | 0.00 | 60 | 0 | 54.67 |
| Application | 66,704 | 0.00 | 20 | 0 | 0.10 |
| Configuration | 5,800 | 0.00 | 6 | 1 | 0.01 |
Back to Wait Events Statistics
Back to Top
Wait Events
- s - second
- cs - centisecond - 100th of a second
- ms - millisecond - 1000th of a second
- us - microsecond - 1000000th of a second
- ordered by wait time desc, waits desc (idle events last)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
| log file sync | 375,854 | 0.00 | 696 | 2 | 0.57 |
| db file scattered read | 25,306 | 0.00 | 573 | 23 | 0.04 |
| gc buffer busy | 8,039 | 2.35 | 430 | 53 | 0.01 |
| wait for scn ack | 353,502 | 0.00 | 207 | 1 | 0.53 |
| cursor: pin S wait on X | 16,654 | 99.98 | 182 | 11 | 0.03 |
| gc cr multi block request | 114,626 | 4.49 | 149 | 1 | 0.17 |
| db file sequential read | 21,226 | 0.00 | 121 | 6 | 0.03 |
| log file parallel write | 447,611 | 0.00 | 109 | 0 | 0.67 |
| gc cr block 2-way | 197,001 | 0.84 | 94 | 0 | 0.30 |
| gc cr block busy | 35,339 | 0.80 | 71 | 2 | 0.05 |
| gcs log flush sync | 54,121 | 24.30 | 64 | 1 | 0.08 |
| db file parallel write | 127,050 | 0.00 | 49 | 0 | 0.19 |
| gc current block 2-way | 74,976 | 0.46 | 37 | 0 | 0.11 |
| SQL*Net message to client | 35,930,156 | 0.00 | 34 | 0 | 54.03 |
| gc current grant busy | 35,739 | 0.00 | 32 | 1 | 0.05 |
| gc current multi block request | 50,657 | 0.00 | 31 | 1 | 0.08 |
| PX Deq Credit: send blkd | 19,743 | 30.49 | 20 | 1 | 0.03 |
| SQL*Net more data from client | 124,753 | 0.00 | 19 | 0 | 0.19 |
| row cache lock | 26,802 | 0.00 | 18 | 1 | 0.04 |
| SQL*Net break/reset to client | 65,128 | 0.00 | 17 | 0 | 0.10 |
| gc current block busy | 1,034 | 0.00 | 17 | 16 | 0.00 |
| Streams AQ: qmn coordinator waiting for slave to start | 2 | 100.00 | 13 | 6538 | 0.00 |
| gc current grant 2-way | 29,960 | 0.00 | 11 | 0 | 0.05 |
| latch: library cache | 12,277 | 0.00 | 10 | 1 | 0.02 |
| control file sequential read | 9,007 | 0.00 | 7 | 1 | 0.01 |
| SQL*Net more data to client | 303,126 | 0.00 | 6 | 0 | 0.46 |
| enq: HW - contention | 5,650 | 0.00 | 6 | 1 | 0.01 |
| cr request retry | 8 | 100.00 | 6 | 733 | 0.00 |
| gc cr grant 2-way | 10,243 | 0.00 | 4 | 0 | 0.02 |
| enq: US - contention | 10,202 | 0.00 | 4 | 0 | 0.02 |
| gc current retry | 93 | 0.00 | 4 | 41 | 0.00 |
| name-service call wait | 66 | 0.00 | 3 | 51 | 0.00 |
| DFS lock handle | 7,303 | 0.00 | 3 | 0 | 0.01 |
| IPC send completion sync | 2,408 | 98.92 | 3 | 1 | 0.00 |
| os thread startup | 49 | 0.00 | 3 | 51 | 0.00 |
| latch: library cache pin | 3,184 | 0.00 | 2 | 1 | 0.00 |
| PX Deq: reap credit | 131,212 | 93.10 | 2 | 0 | 0.20 |
| control file parallel write | 1,899 | 0.00 | 2 | 1 | 0.00 |
| latch free | 3,366 | 0.00 | 2 | 1 | 0.01 |
| enq: WF - contention | 11 | 18.18 | 2 | 151 | 0.00 |
| enq: TX - index contention | 260 | 0.38 | 2 | 6 | 0.00 |
| kksfbc child completion | 32 | 100.00 | 2 | 50 | 0.00 |
| latch: ges resource hash list | 2,616 | 0.00 | 1 | 1 | 0.00 |
| enq: TX - contention | 103 | 0.00 | 1 | 13 | 0.00 |
| gcs drm freeze in enter server mode | 4 | 25.00 | 1 | 335 | 0.00 |
| enq: UL - contention | 1,273 | 0.00 | 1 | 1 | 0.00 |
| latch: object queue header operation | 2,478 | 0.00 | 1 | 0 | 0.00 |
| ksxr poll remote instances | 106,696 | 59.07 | 1 | 0 | 0.16 |
| enq: FB - contention | 1,252 | 0.00 | 1 | 1 | 0.00 |
| enq: PS - contention | 832 | 0.00 | 1 | 1 | 0.00 |
| gc recovery quiesce | 5 | 20.00 | 1 | 196 | 0.00 |
| kjbdrmcvtq lmon drm quiesce: ping completion | 19 | 31.58 | 1 | 49 | 0.00 |
| latch: library cache lock | 1,296 | 0.00 | 1 | 1 | 0.00 |
| latch: cache buffers lru chain | 758 | 0.00 | 1 | 1 | 0.00 |
| CGS wait for IPC msg | 174,388 | 99.93 | 1 | 0 | 0.26 |
| latch: cache buffers chains | 2,529 | 0.00 | 1 | 0 | 0.00 |
| latch: session allocation | 740 | 0.00 | 1 | 1 | 0.00 |
| enq: TM - contention | 85 | 0.00 | 1 | 9 | 0.00 |
| latch: row cache objects | 999 | 0.00 | 1 | 1 | 0.00 |
| local write wait | 691 | 0.00 | 1 | 1 | 0.00 |
| LGWR wait for redo copy | 5,676 | 0.00 | 1 | 0 | 0.01 |
| read by other session | 76 | 0.00 | 1 | 8 | 0.00 |
| library cache lock | 756 | 0.00 | 1 | 1 | 0.00 |
| gc cr block congested | 276 | 17.75 | 0 | 2 | 0.00 |
| buffer busy waits | 1,695 | 0.18 | 0 | 0 | 0.00 |
| gc remaster | 2 | 0.00 | 0 | 194 | 0.00 |
| enq: TX - row lock contention | 163 | 0.00 | 0 | 2 | 0.00 |
| latch: gcs resource hash | 778 | 0.00 | 0 | 0 | 0.00 |
| library cache load lock | 58 | 0.00 | 0 | 5 | 0.00 |
| db file parallel read | 17 | 0.00 | 0 | 16 | 0.00 |
| cursor: pin S | 11,456 | 0.00 | 0 | 0 | 0.02 |
| ges global resource directory to be frozen | 19 | 100.00 | 0 | 11 | 0.00 |
| enq: SQ - contention | 140 | 0.00 | 0 | 1 | 0.00 |
| latch: KCL gc element parent latch | 404 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 278 | 0.00 | 0 | 1 | 0.00 |
| gc current block congested | 90 | 10.00 | 0 | 2 | 0.00 |
| enq: CF - contention | 138 | 0.00 | 0 | 1 | 0.00 |
| latch: enqueue hash chains | 76 | 0.00 | 0 | 1 | 0.00 |
| enq: TT - contention | 114 | 0.00 | 0 | 1 | 0.00 |
| gc current split | 8 | 0.00 | 0 | 11 | 0.00 |
| latch: shared pool | 127 | 0.00 | 0 | 1 | 0.00 |
| rdbms ipc reply | 210 | 0.00 | 0 | 0 | 0.00 |
| gc current grant congested | 35 | 0.00 | 0 | 2 | 0.00 |
| global enqueue expand wait | 5 | 100.00 | 0 | 11 | 0.00 |
| latch: redo allocation | 71 | 0.00 | 0 | 1 | 0.00 |
| wait list latch free | 4 | 0.00 | 0 | 12 | 0.00 |
| ges inquiry response | 34 | 0.00 | 0 | 1 | 0.00 |
| enq: RO - fast object reuse | 55 | 0.00 | 0 | 1 | 0.00 |
| buffer deadlock | 112 | 98.21 | 0 | 0 | 0.00 |
| enq: TO - contention | 32 | 0.00 | 0 | 1 | 0.00 |
| latch: cache buffer handles | 7 | 0.00 | 0 | 3 | 0.00 |
| PX qref latch | 1,476 | 99.53 | 0 | 0 | 0.00 |
| reliable message | 24 | 0.00 | 0 | 1 | 0.00 |
| enq: PI - contention | 26 | 0.00 | 0 | 1 | 0.00 |
| direct path read | 475 | 0.00 | 0 | 0 | 0.00 |
| lock escalate retry | 93 | 87.10 | 0 | 0 | 0.00 |
| gc cr grant congested | 11 | 0.00 | 0 | 2 | 0.00 |
| latch: messages | 99 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header heap | 26 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 19 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex X | 13 | 0.00 | 0 | 1 | 0.00 |
| enq: TD - KTF dump entries | 51 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 7 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Signal ACK | 22 | 22.73 | 0 | 0 | 0.00 |
| enq: TA - contention | 21 | 0.00 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 9 | 0.00 | 0 | 0 | 0.00 |
| lock deadlock retry | 1 | 100.00 | 0 | 3 | 0.00 |
| gc current block unknown | 2 | 0.00 | 0 | 1 | 0.00 |
| direct path write | 326 | 0.00 | 0 | 0 | 0.00 |
| gc cr failure | 7 | 0.00 | 0 | 0 | 0.00 |
| enq: DR - contention | 2 | 0.00 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 3 | 0.00 | 0 | 0 | 0.00 |
| latch: undo global data | 5 | 0.00 | 0 | 0 | 0.00 |
| ges2 LMON to wake up LMD - mrcvr | 5 | 20.00 | 0 | 0 | 0.00 |
| db file single write | 1 | 0.00 | 0 | 0 | 0.00 |
| enq: IR - contention | 1 | 0.00 | 0 | 0 | 0.00 |
| KJC: Wait for msg sends to complete | 9 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 2 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 35,930,172 | 0.00 | 6,343,106 | 177 | 54.03 |
| PX Idle Wait | 3,920 | 79.01 | 8,104 | 2067 | 0.01 |
| gcs remote message | 1,966,884 | 77.18 | 6,728 | 3 | 2.96 |
| Streams AQ: qmn slave idle wait | 145 | 2.07 | 3,716 | 25628 | 0.00 |
| DIAG idle wait | 17,881 | 0.00 | 3,522 | 197 | 0.03 |
| ges remote message | 225,321 | 86.26 | 3,503 | 16 | 0.34 |
| Streams AQ: qmn coordinator idle wait | 262 | 48.85 | 3,499 | 13354 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 63 | 49.21 | 3,350 | 53181 | 0.00 |
| PX Deq: Execution Msg | 16,343 | 31.36 | 219 | 13 | 0.02 |
| PX Deq: Msg Fragment | 19,139 | 45.60 | 13 | 1 | 0.03 |
| PX Deq: Table Q Normal | 4,958 | 30.60 | 7 | 1 | 0.01 |
| PX Deq Credit: need buffer | 2,453 | 28.41 | 2 | 1 | 0.00 |
| PX Deq: Parse Reply | 30 | 43.33 | 0 | 2 | 0.00 |
| PX Deq: Join ACK | 28 | 46.43 | 0 | 1 | 0.00 |
| PX Deq: Execute Reply | 30 | 33.33 | 0 | 0 | 0.00 |
| Streams AQ: RAC qmn coordinator idle wait | 262 | 100.00 | 0 | 0 | 0.00 |
| class slave wait | 2 | 0.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
| events in waitclass Other | 715,455 | 35.04 | 296 | 0 | 1.08 |
| log file parallel write | 447,611 | 0.00 | 109 | 0 | 0.67 |
| db file parallel write | 127,047 | 0.00 | 49 | 0 | 0.19 |
| gc cr block busy | 17,101 | 0.00 | 24 | 1 | 0.03 |
| gc cr multi block request | 5,154 | 0.00 | 6 | 1 | 0.01 |
| control file sequential read | 7,679 | 0.00 | 6 | 1 | 0.01 |
| os thread startup | 49 | 0.00 | 3 | 51 | 0.00 |
| control file parallel write | 1,899 | 0.00 | 2 | 1 | 0.00 |
| gc cr block 2-way | 1,190 | 0.00 | 0 | 0 | 0.00 |
| gc current multi block request | 231 | 0.00 | 0 | 2 | 0.00 |
| enq: HW - contention | 735 | 0.00 | 0 | 0 | 0.00 |
| gc current block 2-way | 390 | 0.00 | 0 | 0 | 0.00 |
| gc current grant busy | 301 | 0.00 | 0 | 0 | 0.00 |
| enq: TM - contention | 29 | 0.00 | 0 | 3 | 0.00 |
| enq: RO - fast object reuse | 55 | 0.00 | 0 | 1 | 0.00 |
| gc current block busy | 1 | 0.00 | 0 | 31 | 0.00 |
| db file scattered read | 2 | 0.00 | 0 | 9 | 0.00 |
| direct path read | 475 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 145 | 2.07 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 168 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 7 | 0.00 | 0 | 1 | 0.00 |
| db file parallel read | 1 | 0.00 | 0 | 9 | 0.00 |
| latch: row cache objects | 6 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 241 | 0.00 | 0 | 0 | 0.00 |
| db file single write | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache pin | 1 | 0.00 | 0 | 0 | 0.00 |
| enq: TX - index contention | 1 | 0.00 | 0 | 0 | 0.00 |
| library cache lock | 2 | 0.00 | -0 | -6 | 0.00 |
| rdbms ipc message | 841,556 | 7.79 | 38,000 | 45 | 1.27 |
| gcs remote message | 1,966,898 | 77.18 | 6,728 | 3 | 2.96 |
| DIAG idle wait | 17,882 | 0.00 | 3,522 | 197 | 0.03 |
| pmon timer | 2,386 | 99.83 | 3,515 | 1473 | 0.00 |
| ges remote message | 225,343 | 86.26 | 3,503 | 16 | 0.34 |
| Streams AQ: qmn coordinator idle wait | 262 | 48.85 | 3,499 | 13354 | 0.00 |
| smon timer | 134,753 | 0.00 | 3,493 | 26 | 0.20 |
| Streams AQ: waiting for time management or cleanup tasks | 63 | 49.21 | 3,350 | 53181 | 0.00 |
| PX Deq: Parse Reply | 27 | 44.44 | 0 | 2 | 0.00 |
| PX Deq: Join ACK | 26 | 46.15 | 0 | 1 | 0.00 |
| PX Deq: Execute Reply | 28 | 35.71 | 0 | 0 | 0.00 |
| Streams AQ: RAC qmn coordinator idle wait | 262 | 100.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
| BUSY_TIME | 1,282,064 |
| IDLE_TIME | 1,600,996 |
| IOWAIT_TIME | 66,699 |
| NICE_TIME | 0 |
| SYS_TIME | 140,373 |
| USER_TIME | 1,067,377 |
| LOAD | 4 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 8,043,612 |
| NUM_CPUS | 8 |
| NUM_CPU_SOCKETS | 2 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
| VIS | 12,697.60 | 10,507.80 | 244,895 | 251,986,958 |
| SYS$USERS | 1.30 | 0.40 | 0 | 0 |
| SYS$BACKGROUND | 0.00 | 0.00 | 520 | 992,520 |
Back to Wait Events Statistics
Back to Top
Service Wait Class Stats
- 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 centisecond (100th of a second)
| Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
| VIS |
47186 | 69482 | 64577 | 21664 | 0 | 0 | 36351768 | 5969 |
| SYS$USERS |
0 | 0 | 1 | 0 | 0 | 0 | 3748 | 0 |
| SYS$BACKGROUND |
948 | 41 | 2428 | 352 | 0 | 0 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
SQL Statistics
Back to Top
SQL ordered by Elapsed Time
- 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
| Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
| 1,185 | 1,150 | 146,039 | 0.01 | 9.34 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 678 | 624 | 91,423 | 0.01 | 5.34 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 553 | 542 | 89,787 | 0.01 | 4.36 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 452 | 231 | 359 | 1.26 | 3.56 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
| 374 | 339 | 205,468 | 0.00 | 2.94 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 363 | 243 | 21,627 | 0.02 | 2.86 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 350 | 349 | 211,642 | 0.00 | 2.76 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 293 | 289 | 3,596 | 0.08 | 2.31 | 9auhvwk6aatuq |
qotSCopProduct.jsp
|
BEGIN ASO_QUOTE_PUB_W.UPDATE_Q... |
| 276 | 274 | 220,523 | 0.00 | 2.17 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 239 | 153 | 724 | 0.33 | 1.88 | dk0sqcvc2xjvs |
qotSCopHdrUpd.jsp
|
BEGIN ASO_QUOTE_PUB_W.Create_Q... |
| 233 | 184 | 7,204 | 0.03 | 1.83 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 227 | 225 | 134,325 | 0.00 | 1.78 | 9jwgp69cmydgp |
JDBC Thin Client
|
begin fnd_session_management.I... |
| 221 | 220 | 4,753,431 | 0.00 | 1.74 | 6cjfxb1c4kx16 |
? @blade3.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 209 | 176 | 11,712 | 0.02 | 1.65 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 192 | 190 | 6,785,964 | 0.00 | 1.51 | c4y7jp0q2awbf |
? @blade3.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 183 | 172 | 2,403 | 0.08 | 1.44 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 181 | 181 | 83,159 | 0.00 | 1.43 | gpbusp26z6qhc |
qotSAppApvlInit.jsp
|
SELECT upgrade_tz_id, timezone... |
| 171 | 171 | 266,691 | 0.00 | 1.35 | b5jqxnpqu8624 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 163 | 161 | 100,874 | 0.00 | 1.28 | 7dtkxnqpkqszw |
jtfavald.jsp
|
SELECT DISTINCT a.PERMISSION_... |
| 161 | 116 | 266,696 | 0.00 | 1.27 | 25wzrzwd46a44 |
asn.dashboard.server.DashboardAM
|
SELECT 1 FROM DUAL WHERE EXIST... |
| 133 | 85 | 357 | 0.37 | 1.05 | g8102j8yynbwz |
qotSCopOverview.jsp
|
begin WF_STANDARD.CONTINUEFLOW... |
| 132 | 132 | 121,698 | 0.00 | 1.04 | 7ujfmgb1j83a3 |
JDBC Thin Client
|
BEGIN FND_AOLJ_UTIL.SET_NLS_C... |
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
- 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
| CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
| 1,150 | 1,185 | 146,039 | 0.01 | 9.34 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 624 | 678 | 91,423 | 0.01 | 5.34 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 542 | 553 | 89,787 | 0.01 | 4.36 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 349 | 350 | 211,642 | 0.00 | 2.76 | a29grr748ghc4 |
fnd.framework.navigate.server.OANavigatePortletA
|
BEGIN jdr_custom_internal.getA... |
| 339 | 374 | 205,468 | 0.00 | 2.94 | 473dq7tb653mp |
CSCCCCRC
|
declare p varchar2(32767); ... |
| 289 | 293 | 3,596 | 0.08 | 2.31 | 9auhvwk6aatuq |
qotSCopProduct.jsp
|
BEGIN ASO_QUOTE_PUB_W.UPDATE_Q... |
| 274 | 276 | 220,523 | 0.00 | 2.17 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 243 | 363 | 21,627 | 0.01 | 2.86 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 231 | 452 | 359 | 0.64 | 3.56 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
| 225 | 227 | 134,325 | 0.00 | 1.78 | 9jwgp69cmydgp |
JDBC Thin Client
|
begin fnd_session_management.I... |
| 220 | 221 | 4,753,431 | 0.00 | 1.74 | 6cjfxb1c4kx16 |
? @blade3.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_ID, APP... |
| 190 | 192 | 6,785,964 | 0.00 | 1.51 | c4y7jp0q2awbf |
? @blade3.ebs.hp.com (TNS V1-V3)
|
SELECT PROFILE_OPTION_VALUE FR... |
| 184 | 233 | 7,204 | 0.03 | 1.83 | 8jb36w62w5hqf |
ibuSRDetailsActions.jsp
|
BEGIN IBU_REQ_PKG.UpdateServic... |
| 181 | 181 | 83,159 | 0.00 | 1.43 | gpbusp26z6qhc |
qotSAppApvlInit.jsp
|
SELECT upgrade_tz_id, timezone... |
| 176 | 209 | 11,712 | 0.02 | 1.65 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 172 | 183 | 2,403 | 0.07 | 1.44 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
|
|