|
|
|
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 | 09-Nov-07 21:40:43 | 1501 | 143.7 |
| End Snap: | 967 | 09-Nov-07 22:40:45 | 1496 | 159.0 |
| Elapsed: | | 60.03 (mins) | | |
| DB Time: | | 100.39 (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,132,605.68 | 26,673.58 |
| Logical reads: | 98,985.28 | 1,238.06 |
| Block changes: | 13,126.89 | 164.18 |
| Physical reads: | 78.73 | 0.98 |
| Physical writes: | 198.76 | 2.49 |
| User calls: | 3,306.20 | 41.35 |
| Parses: | 1,852.63 | 23.17 |
| Hard parses: | 1.82 | 0.02 |
| Sorts: | 1,002.54 | 12.54 |
| Logons: | 0.76 | 0.01 |
| Executes: | 7,834.12 | 97.99 |
| Transactions: | 79.95 | |
| % Blocks changed per Read: | 13.26 | Recursive Call %: | 81.74 |
| Rollback per transaction %: | 21.98 | Rows per Sort: | 15.12 |
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.90 |
| Execute to Parse %: | 76.35 | Latch Hit %: | 99.82 |
| Parse CPU to Parse Elapsd %: | 97.17 | % Non-Parse CPU: | 95.17 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 41.88 | 52.08 |
| % SQL with executions>1: | 91.06 | 84.19 |
| % Memory for SQL w/exec>1: | 89.25 | 69.53 |
Top 5 Timed Events
| Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
|---|
| CPU time | | 5,277 | 87.61 | |
| db file sequential read | 150,451 | 567 | 9.41 | User I/O |
| log file parallel write | 471,287 | 122 | 2.02 | System I/O |
| log file sync | 118,389 | 64 | 1.06 | Commit |
| db file scattered read | 13,553 | 58 | .97 | User I/O |
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 | 150,451 | 0 | 567 | 4 | 0.52 |
| log file parallel write | 471,287 | 0 | 122 | 0 | 1.64 |
| log file sync | 118,389 | 0 | 64 | 1 | 0.41 |
| db file scattered read | 13,553 | 0 | 58 | 4 | 0.05 |
| enq: TX - row lock contention | 190 | 0 | 49 | 259 | 0.00 |
| db file parallel write | 84,686 | 0 | 45 | 1 | 0.29 |
| enq: TM - contention | 9 | 0 | 23 | 2,573 | 0.00 |
| read by other session | 10,015 | 0 | 23 | 2 | 0.03 |
| buffer busy waits | 36,258 | 2 | 23 | 1 | 0.13 |
| enq: TX - index contention | 4,490 | 0 | 15 | 3 | 0.02 |
| library cache pin | 1,413 | 0 | 13 | 9 | 0.00 |
| enq: UL - contention | 326 | 3 | 12 | 37 | 0.00 |
| SQL*Net message to client | 12,470,104 | 0 | 11 | 0 | 43.31 |
| SQL*Net more data from client | 607,098 | 0 | 10 | 0 | 2.11 |
| rdbms ipc reply | 2,280 | 3 | 7 | 3 | 0.01 |
| SQL*Net break/reset to client | 39,440 | 0 | 6 | 0 | 0.14 |
| SQL*Net more data to client | 547,272 | 0 | 5 | 0 | 1.90 |
| direct path read temp | 1,648 | 0 | 4 | 3 | 0.01 |
| PX Deq: Signal ACK | 230 | 78 | 4 | 18 | 0.00 |
| latch: library cache | 7,672 | 0 | 3 | 0 | 0.03 |
| PX Deq Credit: send blkd | 1,897 | 0 | 2 | 1 | 0.01 |
| library cache load lock | 155 | 0 | 1 | 9 | 0.00 |
| enq: DV - contention | 77 | 0 | 1 | 13 | 0.00 |
| control file parallel write | 1,594 | 0 | 1 | 1 | 0.01 |
| direct path write temp | 1,697 | 0 | 1 | 0 | 0.01 |
| local write wait | 1,045 | 0 | 1 | 1 | 0.00 |
| control file sequential read | 1,178 | 0 | 0 | 0 | 0.00 |
| enq: RO - fast object reuse | 203 | 0 | 0 | 2 | 0.00 |
| latch: cache buffers chains | 921 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 775 | 0 | 0 | 0 | 0.00 |
| process startup | 19 | 0 | 0 | 14 | 0.00 |
| latch: shared pool | 1,251 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 596 | 0 | 0 | 0 | 0.00 |
| enq: SQ - contention | 1,495 | 0 | 0 | 0 | 0.01 |
| enq: CU - contention | 9 | 0 | 0 | 19 | 0.00 |
| PX qref latch | 35 | 11 | 0 | 5 | 0.00 |
| direct path read | 335 | 0 | 0 | 0 | 0.00 |
| LGWR wait for redo copy | 5,578 | 0 | 0 | 0 | 0.02 |
| latch: In memory undo latch | 891 | 0 | 0 | 0 | 0.00 |
| enq: CF - contention | 2 | 0 | 0 | 38 | 0.00 |
| latch free | 214 | 0 | 0 | 0 | 0.00 |
| kksfbc child completion | 2 | 1 | 0 | 25 | 0.00 |
| enq: HW - contention | 49 | 0 | 0 | 1 | 0.00 |
| log file switch completion | 3 | 0 | 0 | 14 | 0.00 |
| control file single write | 130 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 651 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 56 | 0 | 0 | 1 | 0.00 |
| enq: TX - contention | 57 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 54 | 0 | 0 | 0 | 0.00 |
| row cache lock | 9 | 0 | 0 | 2 | 0.00 |
| enq: TX - allocate ITL entry | 12 | 0 | 0 | 2 | 0.00 |
| latch: redo allocation | 45 | 0 | 0 | 0 | 0.00 |
| direct path write | 1,108 | 0 | 0 | 0 | 0.00 |
| log file sequential read | 2 | 0 | 0 | 3 | 0.00 |
| latch: object queue header operation | 14 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 27 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 14 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q qref | 17 | 0 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 20 | 0 | 0 | 0 | 0.00 |
| enq: PS - contention | 33 | 0 | 0 | 0 | 0.00 |
| undo segment extension | 1,624 | 1,616 | 0 | 0 | 0.01 |
| enq: FB - contention | 9 | 0 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 1 | 0 | 0 | 0 | 0.00 |
| buffer deadlock | 479 | 478 | 0 | 0 | 0.00 |
| log file single write | 2 | 0 | 0 | 0 | 0.00 |
| latch: messages | 2 | 0 | 0 | 0 | 0.00 |
| enq: US - contention | 5 | 0 | 0 | 0 | 0.00 |
| SQL*Net message from client | 12,470,110 | 0 | 3,039,661 | 244 | 43.31 |
| pipe get | 11,378 | 6,776 | 17,564 | 1,544 | 0.04 |
| queue messages | 1,212 | 979 | 10,065 | 8,305 | 0.00 |
| PX Idle Wait | 2,736 | 2,400 | 4,710 | 1,721 | 0.01 |
| Queue Monitor Wait | 120 | 120 | 3,498 | 29,149 | 0.00 |
| wakeup time manager | 1,209 | 586 | 3,257 | 2,694 | 0.00 |
| PL/SQL lock timer | 54 | 51 | 1,231 | 22,787 | 0.00 |
| PX Deq: Execution Msg | 6,983 | 21 | 131 | 19 | 0.02 |
| jobq slave wait | 20 | 20 | 59 | 2,931 | 0.00 |
| PX Deq: Execute Reply | 5,038 | 0 | 17 | 3 | 0.02 |
| PX Deq: Table Q Normal | 1,722 | 4 | 8 | 5 | 0.01 |
| PX Deq Credit: need buffer | 786 | 0 | 2 | 3 | 0.00 |
| PX Deq: Msg Fragment | 1,922 | 0 | 0 | 0 | 0.01 |
| PX Deq: Parse Reply | 152 | 0 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 203 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q Sample | 67 | 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 | 471,285 | 0 | 122 | 0 | 1.64 |
| db file parallel write | 84,686 | 0 | 45 | 1 | 0.29 |
| db file scattered read | 2,658 | 0 | 6 | 2 | 0.01 |
| control file parallel write | 1,594 | 0 | 1 | 1 | 0.01 |
| db file sequential read | 637 | 0 | 1 | 1 | 0.00 |
| control file sequential read | 669 | 0 | 0 | 0 | 0.00 |
| rdbms ipc reply | 1,937 | 0 | 0 | 0 | 0.01 |
| direct path read | 335 | 0 | 0 | 0 | 0.00 |
| buffer busy waits | 233 | 0 | 0 | 1 | 0.00 |
| LGWR wait for redo copy | 5,578 | 0 | 0 | 0 | 0.02 |
| latch: library cache | 500 | 0 | 0 | 0 | 0.00 |
| process startup | 3 | 0 | 0 | 15 | 0.00 |
| control file single write | 130 | 0 | 0 | 0 | 0.00 |
| latch: shared pool | 180 | 0 | 0 | 0 | 0.00 |
| latch free | 45 | 0 | 0 | 0 | 0.00 |
| log file sequential read | 2 | 0 | 0 | 3 | 0.00 |
| direct path write | 225 | 0 | 0 | 0 | 0.00 |
| latch: redo allocation | 38 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 27 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 64 | 0 | 0 | 0 | 0.00 |
| row cache lock | 4 | 0 | 0 | 1 | 0.00 |
| latch: cache buffers chains | 3 | 0 | 0 | 1 | 0.00 |
| latch: library cache lock | 20 | 0 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 6 | 0 | 0 | 0 | 0.00 |
| enq: CF - contention | 1 | 0 | 0 | 1 | 0.00 |
| latch: undo global data | 3 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 7 | 0 | 0 | 0 | 0.00 |
| log file single write | 2 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 6 | 0 | 0 | 0 | 0.00 |
| latch: messages | 2 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 2 | 0 | 0 | 0 | 0.00 |
| enq: US - contention | 1 | 0 | 0 | 0 | 0.00 |
| rdbms ipc message | 270,874 | 9,978 | 27,673 | 102 | 0.94 |
| Queue Monitor Wait | 120 | 120 | 3,498 | 29,149 | 0.00 |
| smon timer | 8,830 | 0 | 3,466 | 392 | 0.03 |
| wakeup time manager | 1,209 | 586 | 3,257 | 2,694 | 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 | 6,023.57 | 100.00 |
| DB CPU | 5,277.46 | 87.61 |
| sql execute elapsed time | 5,090.17 | 84.50 |
| PL/SQL execution elapsed time | 1,434.72 | 23.82 |
| inbound PL/SQL rpc elapsed time | 1,189.85 | 19.75 |
| background elapsed time | 558.56 | 9.27 |
| background cpu time | 369.35 | 6.13 |
| parse time elapsed | 239.24 | 3.97 |
| hard parse elapsed time | 132.35 | 2.20 |
| Java execution elapsed time | 124.43 | 2.07 |
| connection management call elapsed time | 4.57 | 0.08 |
| sequence load elapsed time | 4.29 | 0.07 |
| PL/SQL compilation elapsed time | 2.82 | 0.05 |
| failed parse elapsed time | 0.94 | 0.02 |
| hard parse (sharing criteria) elapsed time | 0.51 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.49 | 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,006.20 | 4,419.30 | 170,933 | 294,435,066 |
| SYS$USERS | 1,017.70 | 858.50 | 58,700 | 29,447,121 |
| SYS$BACKGROUND | 0.00 | 0.00 | 36,372 | 32,362,285 |
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 |
130,469 | 47,830 | 50,568 | 5,604 | 0 | 0 | 10,110,941 | 2,298 |
| SYS$USERS |
35,275 | 14,874 | 1,274 | 43 | 0 | 0 | 3,509,810 | 361 |
| SYS$BACKGROUND |
14,283 | 2,638 | 795 | 25 | 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 |
|---|
| 260 | 260 | 2 | 129.95 | 4.31 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 239 | 237 | 36,704 | 0.01 | 3.97 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 204 | 204 | 4 | 50.97 | 3.38 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 174 | 174 | 38,507 | 0.00 | 2.89 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 150 | 145 | 4 | 37.55 | 2.49 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 145 | 79 | 5,000 | 0.03 | 2.41 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 140 | 140 | 59 | 2.38 | 2.33 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 132 | 131 | 25,820 | 0.01 | 2.19 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 114 | 4 | 561 | 0.20 | 1.89 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 92 | 84 | 3 | 30.63 | 1.53 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 89 | 88 | 336 | 0.27 | 1.48 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 89 | 88 | 70,878 | 0.00 | 1.47 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 82 | 75 | 1,000 | 0.08 | 1.36 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 77 | 28 | 208 | 0.37 | 1.28 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 72 | 47 | 5,040 | 0.01 | 1.19 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 61 | 61 | 2,209,838 | 0.00 | 1.01 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 61 | 61 | 1,003,001 | 0.00 | 1.01 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
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 |
|---|
| 260 | 260 | 2 | 129.95 | 4.31 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 237 | 239 | 36,704 | 0.01 | 3.97 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 204 | 204 | 4 | 50.97 | 3.38 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 174 | 174 | 38,507 | 0.00 | 2.89 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 145 | 150 | 4 | 36.16 | 2.49 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 140 | 140 | 59 | 2.38 | 2.33 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 131 | 132 | 25,820 | 0.01 | 2.19 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 88 | 89 | 70,878 | 0.00 | 1.47 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 88 | 89 | 336 | 0.26 | 1.48 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 84 | 92 | 3 | 28.16 | 1.53 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 79 | 145 | 5,000 | 0.02 | 2.41 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 75 | 82 | 1,000 | 0.08 | 1.36 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 61 | 61 | 2,209,838 | 0.00 | 1.01 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 61 | 61 | 1,003,001 | 0.00 | 1.01 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 47 | 72 | 5,040 | 0.01 | 1.19 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 28 | 77 | 208 | 0.13 | 1.28 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 4 | 114 | 561 | 0.01 | 1.89 | 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: 356,502,794
- Captured SQL accounts for 21.3% of Total Buffer Gets
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 23,689,191 | 4 | 5,922,297.75 | 6.64 | 203.88 | 203.88 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 23,317,642 | 4 | 5,829,410.50 | 6.54 | 144.64 | 150.22 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 21,716,014 | 2 | 10,858,007.00 | 6.09 | 259.89 | 259.89 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 12,716,508 | 1 | 12,716,508.00 | 3.57 | 26.18 | 41.58 | 05s9358mm6vrr |
|
begin dbms_feature_usage_inter... |
| 11,858,460 | 5,000 | 2,371.69 | 3.33 | 78.73 | 145.35 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 9,740,085 | 3 | 3,246,695.00 | 2.73 | 84.48 | 91.88 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 9,271,265 | 1,000 | 9,271.27 | 2.60 | 75.04 | 81.92 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 8,394,259 | 59 | 142,275.58 | 2.35 | 140.23 | 140.25 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 8,024,004 | 1,003,001 | 8.00 | 2.25 | 60.80 | 60.80 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 7,524,781 | 2,209,838 | 3.41 | 2.11 | 60.94 | 60.94 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 7,485,770 | 36,704 | 203.95 | 2.10 | 237.05 | 239.40 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 6,339,645 | 336 | 18,867.99 | 1.78 | 88.12 | 89.18 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 6,314,878 | 11 | 574,079.82 | 1.77 | 28.64 | 28.84 | 1du9v021t8m46 |
ARGLTP
|
insert into gl_interface(creat... |
| 5,829,072 | 11,680 | 499.06 | 1.64 | 58.69 | 58.78 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 4,772,327 | 1,706,256 | 2.80 | 1.34 | 58.51 | 58.51 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 4,582,358 | 38,507 | 119.00 | 1.29 | 174.30 | 174.38 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 4,204,851 | 60,000 | 70.08 | 1.18 | 29.87 | 34.61 | 5qtxtsar19v4k |
PYUSLV
|
insert into pay_run_result_val... |
| 3,616,459 | 25,820 | 140.06 | 1.01 | 131.31 | 131.76 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 283,548
- Captured SQL accounts for 35.0% of Total Disk Reads
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 34,996 | 561 | 62.38 | 12.34 | 4.21 | 113.92 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 27,614 | 5,000 | 5.52 | 9.74 | 78.73 | 145.35 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 14,315 | 15,172 | 0.94 | 5.05 | 23.99 | 55.82 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 10,842 | 1 | 10,842.00 | 3.82 | 26.18 | 41.58 | 05s9358mm6vrr |
|
begin dbms_feature_usage_inter... |
| 10,642 | 561 | 18.97 | 3.75 | 24.43 | 39.79 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 9,554 | 1 | 9,554.00 | 3.37 | 14.89 | 17.43 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 7,184 | 3 | 2,394.67 | 2.53 | 84.48 | 91.88 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 6,002 | 5,040 | 1.19 | 2.12 | 47.20 | 71.63 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 1,726 | 280 | 6.16 | 0.61 | 42.85 | 48.62 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 1,278 | 3,502 | 0.36 | 0.45 | 40.95 | 46.01 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 28,215,150
- Captured SQL accounts for 34.7% of Total Executions
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,209,838 | 889,468 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 1,706,256 | 1,359,865 | 0.80 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 1,003,001 | 1,003,001 | 1.00 | 0.00 | 0.00 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,002,835 | 1,002,835 | 1.00 | 0.00 | 0.00 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 689,705 | 689,703 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 652,940 | 652,941 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 220,814 | 90,388 | 0.41 | 0.00 | 0.00 | 4g5vzcyf68n9w |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 141,261 | 141,261 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 115,295 | 115,294 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 114,951 | 114,951 | 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: 6,672,369
- Captured SQL accounts for 69.1% of Total Parse Calls
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 1,003,001 | 1,003,001 | 15.03 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,002,835 | 490 | 15.03 | 20rc3cmapyvnz |
|
select q_name, state, delay,... |
| 1,002,835 | 1,002,835 | 15.03 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 147,100 | 1,706,256 | 2.20 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 141,261 | 141,261 | 2.12 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 135,325 | 2,209,838 | 2.03 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 82,369 | 82,369 | 1.23 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 73,555 | 115,295 | 1.10 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 73,211 | 114,951 | 1.10 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 73,211 | 114,951 | 1.10 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
| 73,211 | 114,951 | 1.10 | 95pbs94n69z3d |
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 73,211 | 689,705 | 1.10 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 73,211 | 114,951 | 1.10 | bvyqm6268u2as |
|
SELECT NODE_NAME FROM FND_NODE... |
| 73,211 | 73,211 | 1.10 | fhqzxap2n0ybj |
|
select NAME from HR_OPERATING_... |
| 68,011 | 68,011 | 1.02 | 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,277,859 | 1,680 | 0.07 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
| 2,053,881 | 94 | 0.06 | azfadzhfxbxj3 |
ARXTWMAI
|
SELECT ROW_ID, APBA_INACTIVE_D... |
| 1,999,280 | 57 | 0.06 | 2fr5f5xzmffd8 |
POXPRPOP
|
SELECT decode ( : P_sortby , ... |
| 1,844,236 | 5 | 0.06 | 9trqpr8qyg7xm |
POXPRPOP
|
SELECT distinct pol . line_num... |
| 1,756,998 | 4,878 | 0.05 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,666,593 | 1,680 | 0.05 | bf4kcv5v66czb |
ibuSRDetails.jsp
|
SELECT 'NOTE', '2', b.creat... |
| 1,559,949 | 1,683 | 0.05 | bk9zgysk994av |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
| 1,391,413 | 1 | 0.04 | 0tdy0gjxn6wrb |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,382,8 |
|
