|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | Cluster | Host |
|---|
| VIS | 118468335 | VIS | 1 | 10.1.0.4.0 | NO | oasb-db.oasb.hp |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 966 | 07-Nov-07 16:10:57 | 1840 | 146.2 |
| End Snap: | 967 | 07-Nov-07 17:10:58 | 1836 | 161.1 |
| Elapsed: | | 60.02 (mins) | | |
| DB Time: | | 122.52 (mins) | | |
Report Summary
Cache Sizes (end)
| Buffer Cache: | 5,024M | Std Block Size: | 8K |
| Shared Pool Size: | 3,104M | Log Buffer: | 2,048K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 2,263,452.83 | 23,287.49 |
| Logical reads: | 109,008.95 | 1,121.54 |
| Block changes: | 14,018.71 | 144.23 |
| Physical reads: | 78.01 | 0.80 |
| Physical writes: | 212.99 | 2.19 |
| User calls: | 4,148.56 | 42.68 |
| Parses: | 2,355.74 | 24.24 |
| Hard parses: | 1.91 | 0.02 |
| Sorts: | 1,198.54 | 12.33 |
| Logons: | 0.92 | 0.01 |
| Executes: | 9,420.66 | 96.92 |
| Transactions: | 97.20 | |
| % Blocks changed per Read: | 12.86 | Recursive Call %: | 81.24 |
| Rollback per transaction %: | 23.10 | Rows per Sort: | 14.10 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.93 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.99 | Soft Parse %: | 99.92 |
| Execute to Parse %: | 74.99 | Latch Hit %: | 99.81 |
| Parse CPU to Parse Elapsd %: | 98.64 | % Non-Parse CPU: | 94.90 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 45.01 | 56.65 |
| % SQL with executions>1: | 85.07 | 83.91 |
| % Memory for SQL w/exec>1: | 83.41 | 66.58 |
Top 5 Timed Events
| Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
|---|
| CPU time | | 6,393 | 86.96 | |
| db file sequential read | 152,214 | 622 | 8.46 | User I/O |
| SQL*Net more data from client | 769,246 | 152 | 2.07 | Network |
| log file parallel write | 562,697 | 138 | 1.88 | System I/O |
| log file sync | 149,494 | 83 | 1.13 | Commit |
Main Report
Back to Top
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 | Timeouts | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| db file sequential read | 152,214 | 0 | 622 | 4 | 0.43 |
| SQL*Net more data from client | 769,246 | 0 | 152 | 0 | 2.20 |
| log file parallel write | 562,697 | 0 | 138 | 0 | 1.61 |
| log file sync | 149,494 | 0 | 83 | 1 | 0.43 |
| db file scattered read | 12,352 | 0 | 54 | 4 | 0.04 |
| db file parallel write | 92,091 | 0 | 51 | 1 | 0.26 |
| enq: TX - row lock contention | 236 | 0 | 50 | 214 | 0.00 |
| enq: TM - contention | 17 | 7 | 29 | 1,721 | 0.00 |
| read by other session | 10,189 | 0 | 22 | 2 | 0.03 |
| enq: TX - index contention | 4,418 | 0 | 18 | 4 | 0.01 |
| enq: UL - contention | 321 | 3 | 15 | 46 | 0.00 |
| SQL*Net message to client | 15,647,593 | 0 | 14 | 0 | 44.70 |
| library cache pin | 1,498 | 0 | 14 | 9 | 0.00 |
| buffer busy waits | 34,182 | 2 | 13 | 0 | 0.10 |
| rdbms ipc reply | 2,716 | 3 | 8 | 3 | 0.01 |
| SQL*Net more data to client | 642,230 | 0 | 7 | 0 | 1.83 |
| latch: library cache | 12,167 | 0 | 5 | 0 | 0.03 |
| direct path read temp | 1,654 | 0 | 4 | 3 | 0.00 |
| PX Deq: Signal ACK | 239 | 84 | 4 | 17 | 0.00 |
| SQL*Net break/reset to client | 25,804 | 0 | 3 | 0 | 0.07 |
| library cache load lock | 156 | 0 | 2 | 13 | 0.00 |
| enq: RO - fast object reuse | 208 | 0 | 1 | 6 | 0.00 |
| enq: DV - contention | 83 | 0 | 1 | 11 | 0.00 |
| control file parallel write | 1,574 | 0 | 1 | 1 | 0.00 |
| local write wait | 1,254 | 0 | 1 | 1 | 0.00 |
| log buffer space | 7 | 0 | 1 | 97 | 0.00 |
| PX Deq Credit: send blkd | 1,785 | 0 | 1 | 0 | 0.01 |
| direct path write temp | 1,592 | 0 | 1 | 0 | 0.00 |
| latch: library cache pin | 1,281 | 0 | 1 | 0 | 0.00 |
| PX qref latch | 55 | 30 | 0 | 7 | 0.00 |
| latch: shared pool | 1,970 | 0 | 0 | 0 | 0.01 |
| control file sequential read | 1,068 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 884 | 0 | 0 | 0 | 0.00 |
| process startup | 18 | 0 | 0 | 14 | 0.00 |
| enq: CU - contention | 10 | 0 | 0 | 22 | 0.00 |
| enq: SQ - contention | 1,495 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 641 | 0 | 0 | 0 | 0.00 |
| LGWR wait for redo copy | 4,690 | 1 | 0 | 0 | 0.01 |
| latch: In memory undo latch | 1,180 | 0 | 0 | 0 | 0.00 |
| direct path read | 200 | 0 | 0 | 1 | 0.00 |
| kksfbc child completion | 2 | 2 | 0 | 50 | 0.00 |
| latch: undo global data | 994 | 0 | 0 | 0 | 0.00 |
| latch free | 257 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 97 | 0 | 0 | 1 | 0.00 |
| enq: TX - contention | 46 | 0 | 0 | 1 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| enq: HW - contention | 33 | 0 | 0 | 1 | 0.00 |
| latch: row cache objects | 28 | 0 | 0 | 1 | 0.00 |
| latch: redo allocation | 43 | 0 | 0 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 11 | 0 | 0 | 1 | 0.00 |
| latch: object queue header operation | 20 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 29 | 0 | 0 | 0 | 0.00 |
| direct path write | 1,322 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q qref | 24 | 0 | 0 | 0 | 0.00 |
| undo segment extension | 3,090 | 3,075 | 0 | 0 | 0.01 |
| latch: cache buffer handles | 11 | 0 | 0 | 0 | 0.00 |
| enq: PS - contention | 39 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 10 | 0 | 0 | 0 | 0.00 |
| enq: FB - contention | 14 | 0 | 0 | 0 | 0.00 |
| latch: messages | 3 | 0 | 0 | 0 | 0.00 |
| buffer deadlock | 654 | 652 | 0 | 0 | 0.00 |
| row cache lock | 1 | 0 | 0 | 0 | 0.00 |
| SQL*Net message from client | 15,647,593 | 0 | 3,681,297 | 235 | 44.70 |
| pipe get | 12,694 | 6,734 | 17,561 | 1,383 | 0.04 |
| queue messages | 1,253 | 972 | 10,168 | 8,115 | 0.00 |
| PX Idle Wait | 2,736 | 2,400 | 4,710 | 1,721 | 0.01 |
| Queue Monitor Wait | 120 | 120 | 3,493 | 29,110 | 0.00 |
| wakeup time manager | 1,404 | 692 | 3,174 | 2,260 | 0.00 |
| PL/SQL lock timer | 56 | 52 | 1,240 | 22,148 | 0.00 |
| PX Deq: Execution Msg | 6,976 | 21 | 123 | 18 | 0.02 |
| jobq slave wait | 20 | 20 | 59 | 2,931 | 0.00 |
| PX Deq: Execute Reply | 5,014 | 0 | 12 | 2 | 0.01 |
| class slave wait | 1 | 1 | 5 | 4,883 | 0.00 |
| PX Deq: Msg Fragment | 2,031 | 0 | 2 | 1 | 0.01 |
| PX Deq: Parse Reply | 158 | 0 | 2 | 13 | 0.00 |
| PX Deq: Table Q Normal | 1,828 | 0 | 1 | 0 | 0.01 |
| PX Deq Credit: need buffer | 857 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q Sample | 71 | 0 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 165 | 0 | 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 | Timeouts | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 562,691 | 0 | 138 | 0 | 1.61 |
| db file parallel write | 92,091 | 0 | 51 | 1 | 0.26 |
| db file scattered read | 2,652 | 0 | 6 | 2 | 0.01 |
| control file parallel write | 1,574 | 0 | 1 | 1 | 0.00 |
| db file sequential read | 636 | 0 | 1 | 1 | 0.00 |
| buffer busy waits | 403 | 0 | 0 | 1 | 0.00 |
| rdbms ipc reply | 2,380 | 0 | 0 | 0 | 0.01 |
| LGWR wait for redo copy | 4,690 | 1 | 0 | 0 | 0.01 |
| latch: library cache | 724 | 0 | 0 | 0 | 0.00 |
| control file sequential read | 632 | 0 | 0 | 0 | 0.00 |
| direct path read | 200 | 0 | 0 | 1 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| process startup | 2 | 0 | 0 | 15 | 0.00 |
| latch: shared pool | 276 | 0 | 0 | 0 | 0.00 |
| latch: redo allocation | 37 | 0 | 0 | 0 | 0.00 |
| latch free | 71 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 52 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 96 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 19 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 28 | 0 | 0 | 0 | 0.00 |
| direct path write | 150 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 14 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 5 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 8 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 1 | 0 | 0 | 1 | 0.00 |
| latch: cache buffers lru chain | 9 | 0 | 0 | 0 | 0.00 |
| latch: messages | 2 | 0 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 13 | 0 | 0 | 0 | 0.00 |
| rdbms ipc message | 327,064 | 9,897 | 27,905 | 85 | 0.93 |
| Queue Monitor Wait | 120 | 120 | 3,493 | 29,110 | 0.00 |
| smon timer | 11,092 | 0 | 3,448 | 311 | 0.03 |
| wakeup time manager | 1,404 | 692 | 3,174 | 2,260 | 0.00 |
Back to Wait Events Statistics
Back to Top
Time Model Statistics
- ordered by Time (seconds) desc
| Statistic Name | Time (seconds) | % Total DB Time |
|---|
| DB time | 7,351.20 | 100.00 |
| DB CPU | 6,392.69 | 86.96 |
| sql execute elapsed time | 6,006.76 | 81.71 |
| PL/SQL execution elapsed time | 1,928.57 | 26.23 |
| inbound PL/SQL rpc elapsed time | 1,682.18 | 22.88 |
| background elapsed time | 640.67 | 8.72 |
| background cpu time | 447.20 | 6.08 |
| parse time elapsed | 298.76 | 4.06 |
| hard parse elapsed time | 164.53 | 2.24 |
| Java execution elapsed time | 135.38 | 1.84 |
| connection management call elapsed time | 5.66 | 0.08 |
| sequence load elapsed time | 5.02 | 0.07 |
| PL/SQL compilation elapsed time | 2.92 | 0.04 |
| failed parse elapsed time | 1.21 | 0.02 |
| hard parse (sharing criteria) elapsed time | 0.57 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.55 | 0.01 |
| failed parse (out of shared memory) elapsed t | 0.00 | 0.00 |
Back to Wait Events Statistics
Back to Top
|
Operating System Statistics
No data exists for this section of the report.
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| VIS | 5,948.40 | 5,200.20 | 169,760 | 325,912,027 |
| SYS$USERS | 1,402.70 | 1,192.30 | 68,136 | 39,921,609 |
| SYS$BACKGROUND | 0.00 | 0.00 | 25,478 | 26,488,838 |
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 |
131,537 | 49,059 | 52,213 | 5,094 | 0 | 0 | 12,269,963 | 16,796 |
| SYS$USERS |
43,478 | 20,207 | 2,410 | 90 | 0 | 0 | 4,784,726 | 501 |
| SYS$BACKGROUND |
5,859 | 1,068 | 1,239 | 48 | 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 |
|---|
| 312 | 309 | 47,216 | 0.01 | 4.25 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 267 | 267 | 2 | 133.31 | 3.63 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 226 | 226 | 49,162 | 0.00 | 3.07 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 216 | 216 | 4 | 53.91 | 2.93 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 172 | 172 | 33,477 | 0.01 | 2.34 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 153 | 152 | 62 | 2.46 | 2.08 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 148 | 146 | 4 | 37.06 | 2.02 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 146 | 78 | 5,000 | 0.03 | 1.98 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 138 | 5 | 720 | 0.19 | 1.88 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 117 | 117 | 90,804 | 0.00 | 1.59 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 116 | 114 | 432 | 0.27 | 1.57 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 91 | 61 | 6,485 | 0.01 | 1.24 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 90 | 83 | 3 | 30.04 | 1.23 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 88 | 38 | 214 | 0.41 | 1.20 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 81 | 77 | 1,000 | 0.08 | 1.10 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 79 | 79 | 1,301,104 | 0.00 | 1.08 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 79 | 79 | 2,827,319 | 0.00 | 1.07 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 76 | 76 | 2,181,975 | 0.00 | 1.04 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
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 |
|---|
| 309 | 312 | 47,216 | 0.01 | 4.25 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 267 | 267 | 2 | 133.31 | 3.63 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 226 | 226 | 49,162 | 0.00 | 3.07 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 216 | 216 | 4 | 53.91 | 2.93 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 172 | 172 | 33,477 | 0.01 | 2.34 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 152 | 153 | 62 | 2.45 | 2.08 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 146 | 148 | 4 | 36.48 | 2.02 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 117 | 117 | 90,804 | 0.00 | 1.59 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 114 | 116 | 432 | 0.26 | 1.57 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 83 | 90 | 3 | 27.62 | 1.23 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 79 | 79 | 1,301,104 | 0.00 | 1.08 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 79 | 79 | 2,827,319 | 0.00 | 1.07 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 78 | 146 | 5,000 | 0.02 | 1.98 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 77 | 81 | 1,000 | 0.08 | 1.10 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 76 | 76 | 2,181,975 | 0.00 | 1.04 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 61 | 91 | 6,485 | 0.01 | 1.24 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 38 | 88 | 214 | 0.18 | 1.20 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 5 | 138 | 720 | 0.01 | 1.88 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
Back to SQL Statistics
Back to Top
SQL ordered by Gets
- Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
- Total Buffer Gets: 392,592,779
- Captured SQL accounts for 19.7% of Total Buffer Gets
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 25,240,816 | 4 | 6,310,204.00 | 6.43 | 215.63 | 215.63 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 22,205,602 | 4 | 5,551,400.50 | 5.66 | 145.94 | 148.24 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 21,279,042 | 2 | 10,639,521.00 | 5.42 | 266.62 | 266.62 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 11,858,394 | 5,000 | 2,371.68 | 3.02 | 78.33 | 145.86 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 10,408,828 | 1,301,104 | 8.00 | 2.65 | 79.37 | 79.37 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 9,629,088 | 47,216 | 203.94 | 2.45 | 309.12 | 312.33 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 9,627,966 | 2,827,319 | 3.41 | 2.45 | 78.93 | 78.96 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 9,259,469 | 1,000 | 9,259.47 | 2.36 | 76.74 | 80.95 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 9,163,998 | 3 | 3,054,666.00 | 2.33 | 82.87 | 90.11 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 8,921,994 | 62 | 143,903.13 | 2.27 | 151.82 | 152.77 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 7,760,064 | 432 | 17,963.11 | 1.98 | 114.43 | 115.55 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 7,106,093 | 12,165 | 584.14 | 1.81 | 65.52 | 67.56 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 6,107,223 | 2,181,975 | 2.80 | 1.56 | 76.27 | 76.28 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 5,850,326 | 49,162 | 119.00 | 1.49 | 225.84 | 226.01 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 4,658,611 | 33,477 | 139.16 | 1.19 | 171.65 | 172.23 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 3,939,063 | 16,356 | 240.83 | 1.00 | 28.99 | 67.89 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 280,947
- Captured SQL accounts for 35.4% of Total Disk Reads
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 33,590 | 720 | 46.65 | 11.96 | 5.29 | 138.10 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 27,617 | 5,000 | 5.52 | 9.83 | 78.33 | 145.86 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 16,649 | 16,356 | 1.02 | 5.93 | 28.99 | 67.89 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 10,450 | 720 | 14.51 | 3.72 | 33.46 | 46.83 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 9,554 | 1 | 9,554.00 | 3.40 | 15.43 | 18.47 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 7,717 | 3 | 2,572.33 | 2.75 | 82.87 | 90.11 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 7,006 | 6,485 | 1.08 | 2.49 | 61.22 | 91.35 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 1,885 | 360 | 5.24 | 0.67 | 54.97 | 61.00 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 1,447 | 4,504 | 0.32 | 0.52 | 53.06 | 59.06 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 900 | 108 | 8.33 | 0.32 | 46.50 | 49.73 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 33,928,254
- Captured SQL accounts for 36.5% of Total Executions
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,827,319 | 1,138,566 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 2,181,975 | 1,743,326 | 0.80 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 1,301,104 | 1,301,104 | 1.00 | 0.00 | 0.00 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,300,927 | 1,300,927 | 1.00 | 0.00 | 0.00 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 885,583 | 885,582 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 852,710 | 852,706 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 283,631 | 116,560 | 0.41 | 0.00 | 0.00 | 4g5vzcyf68n9w |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 181,224 | 181,224 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 148,029 | 148,029 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 147,598 | 147,598 | 1.00 | 0.00 | 0.00 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 8,484,127
- Captured SQL accounts for 69.8% of Total Parse Calls
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 1,301,104 | 1,301,104 | 15.34 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,300,927 | 630 | 15.33 | 20rc3cmapyvnz |
|
select q_name, state, delay,... |
| 1,300,927 | 1,300,927 | 15.33 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 188,302 | 2,181,975 | 2.22 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 181,223 | 181,224 | 2.14 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 173,157 | 2,827,319 | 2.04 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 101,707 | 101,708 | 1.20 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 94,147 | 148,029 | 1.11 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 93,716 | 147,598 | 1.10 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 93,716 | 147,598 | 1.10 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
| 93,716 | 147,597 | 1.10 | 95pbs94n69z3d |
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 93,716 | 885,583 | 1.10 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 93,716 | 147,598 | 1.10 | bvyqm6268u2as |
|
SELECT NODE_NAME FROM FND_NODE... |
| 93,716 | 93,716 | 1.10 | fhqzxap2n0ybj |
|
select NAME from HR_OPERATING_... |
| 87,365 | 87,365 | 1.03 | cwyx16zn1hpfb |
JDBC Thin Client
|
select parameter, value from ... |
Back to SQL Statistics
Back to Top
SQL ordered by Sharable Memory
- Only Statements with Sharable Memory greater than 1048576 are displayed
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|
| 2,274,115 | 2,166 | 0.07 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
| 2,054,465 | 125 | 0.06 | azfadzhfxbxj3 |
ARXTWMAI
|
SELECT ROW_ID, APBA_INACTIVE_D... |
| 1,998,112 | 72 | 0.06 | 2fr5f5xzmffd8 |
POXPRPOP
|
SELECT decode ( : P_sortby , ... |
| 1,848,052 | 12 | 0.06 | 9trqpr8qyg7xm |
POXPRPOP
|
SELECT distinct pol . line_num... |
| 1,753,230 | 6,276 | 0.05 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,666,697 | 2,161 | 0.05 | bf4kcv5v66czb |
ibuSRDetails.jsp
|
SELECT 'NOTE', '2', b.creat... |
| 1,562,117 | 2,165 | 0.05 | bk9zgysk994av |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
| 1,399,621 | 1 | 0.04 | 0tdy0gjxn6wrb |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,364,377 | 1 | 0.04 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 1,362,050 | 1 | 0.04 | dkvvgc7c1wksu |
RAXTRX
|
select
CONTRACT_ID||'~'||L.AGR... |
| 1,309,501 | 4,330 | 0.04 | fc74w8q18dtdu |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(QPQ ... |
| 1,276,376 | 361 | 0.04 | 2nfc4vng01c8t |
POXPOVPO
|
SELECT END_DATE, START_DATE, R... |
| 1,240,254 | 72 | 0.04 | 3c086a4sm741b |
ARXAGE
|
select decode ( UPPER ( : p_or... |
| 1,233,817 | 1 | 0.04 | 496za9aq6dd71 |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,218,519 | 360 | 0.04 | 0nr5vc1336tr9 |
APXINWKB
|
|
