|
|
|
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: | 967 | 16-Jan-08 15:10:07 | 1513 | 144.2 |
| End Snap: | 968 | 16-Jan-08 16:10:08 | 1519 | 160.4 |
| Elapsed: | | 60.02 (mins) | | |
| DB Time: | | 99.70 (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,148,753.21 | 26,786.19 |
| Logical reads: | 96,409.13 | 1,201.83 |
| Block changes: | 13,190.07 | 164.43 |
| Physical reads: | 77.05 | 0.96 |
| Physical writes: | 200.35 | 2.50 |
| User calls: | 3,322.01 | 41.41 |
| Parses: | 1,960.14 | 24.43 |
| Hard parses: | 1.82 | 0.02 |
| Sorts: | 992.75 | 12.38 |
| Logons: | 0.76 | 0.01 |
| Executes: | 7,905.75 | 98.55 |
| Transactions: | 80.22 | |
| % Blocks changed per Read: | 13.68 | Recursive Call %: | 81.87 |
| Rollback per transaction %: | 22.03 | Rows per Sort: | 15.19 |
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.91 |
| Execute to Parse %: | 75.21 | Latch Hit %: | 99.82 |
| Parse CPU to Parse Elapsd %: | 95.89 | % Non-Parse CPU: | 95.05 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 41.58 | 52.20 |
| % SQL with executions>1: | 86.60 | 84.87 |
| % Memory for SQL w/exec>1: | 86.66 | 69.63 |
Top 5 Timed Events
| Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
|---|
| CPU time | | 5,189 | 86.74 | |
| db file sequential read | 145,076 | 595 | 9.94 | User I/O |
| log file parallel write | 480,291 | 107 | 1.80 | System I/O |
| log file sync | 117,697 | 57 | .95 | Commit |
| db file scattered read | 12,905 | 56 | .94 | 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 | 145,076 | 0 | 595 | 4 | 0.50 |
| log file parallel write | 480,291 | 0 | 107 | 0 | 1.66 |
| log file sync | 117,697 | 0 | 57 | 0 | 0.41 |
| db file scattered read | 12,905 | 0 | 56 | 4 | 0.04 |
| db file parallel write | 85,695 | 0 | 45 | 1 | 0.30 |
| enq: TX - row lock contention | 172 | 0 | 43 | 248 | 0.00 |
| enq: TM - contention | 15 | 1 | 33 | 2,179 | 0.00 |
| buffer busy waits | 37,882 | 2 | 23 | 1 | 0.13 |
| enq: TX - index contention | 4,791 | 0 | 23 | 5 | 0.02 |
| read by other session | 9,691 | 0 | 21 | 2 | 0.03 |
| enq: UL - contention | 743 | 3 | 14 | 18 | 0.00 |
| library cache pin | 1,455 | 0 | 13 | 9 | 0.01 |
| SQL*Net more data from client | 608,791 | 0 | 9 | 0 | 2.11 |
| SQL*Net break/reset to client | 50,988 | 0 | 8 | 0 | 0.18 |
| SQL*Net message to client | 12,529,572 | 0 | 7 | 0 | 43.37 |
| rdbms ipc reply | 1,715 | 2 | 7 | 4 | 0.01 |
| SQL*Net more data to client | 547,660 | 0 | 5 | 0 | 1.90 |
| PX Deq: Signal ACK | 237 | 87 | 4 | 17 | 0.00 |
| direct path read temp | 1,649 | 0 | 4 | 2 | 0.01 |
| latch: library cache | 7,814 | 0 | 3 | 0 | 0.03 |
| control file sequential read | 1,062 | 0 | 3 | 3 | 0.00 |
| PX Deq Credit: send blkd | 1,714 | 0 | 3 | 2 | 0.01 |
| latch: cache buffers chains | 1,583 | 0 | 1 | 1 | 0.01 |
| library cache load lock | 134 | 0 | 1 | 10 | 0.00 |
| enq: DV - contention | 70 | 0 | 1 | 13 | 0.00 |
| control file parallel write | 1,573 | 0 | 1 | 1 | 0.01 |
| latch: library cache pin | 837 | 0 | 1 | 1 | 0.00 |
| local write wait | 1,085 | 0 | 1 | 0 | 0.00 |
| direct path write temp | 1,749 | 0 | 1 | 0 | 0.01 |
| enq: RO - fast object reuse | 212 | 0 | 0 | 2 | 0.00 |
| PX qref latch | 52 | 24 | 0 | 6 | 0.00 |
| process startup | 18 | 0 | 0 | 14 | 0.00 |
| latch: shared pool | 1,213 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 611 | 0 | 0 | 0 | 0.00 |
| enq: SQ - contention | 1,462 | 0 | 0 | 0 | 0.01 |
| enq: CU - contention | 7 | 0 | 0 | 22 | 0.00 |
| latch free | 257 | 0 | 0 | 1 | 0.00 |
| LGWR wait for redo copy | 4,361 | 0 | 0 | 0 | 0.02 |
| latch: In memory undo latch | 1,154 | 0 | 0 | 0 | 0.00 |
| direct path read | 200 | 0 | 0 | 1 | 0.00 |
| latch: enqueue hash chains | 39 | 0 | 0 | 2 | 0.00 |
| latch: undo global data | 601 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 74 | 0 | 0 | 1 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| enq: TX - contention | 68 | 0 | 0 | 1 | 0.00 |
| enq: HW - contention | 44 | 0 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 7 | 0 | 0 | 2 | 0.00 |
| latch: cache buffer handles | 16 | 0 | 0 | 1 | 0.00 |
| latch: redo allocation | 45 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 22 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 10 | 0 | 0 | 1 | 0.00 |
| latch: object queue header operation | 4 | 0 | 0 | 1 | 0.00 |
| enq: FB - contention | 22 | 0 | 0 | 0 | 0.00 |
| direct path write | 1,095 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q qref | 19 | 0 | 0 | 0 | 0.00 |
| enq: PS - contention | 35 | 0 | 0 | 0 | 0.00 |
| undo segment extension | 1,370 | 1,363 | 0 | 0 | 0.00 |
| row cache lock | 5 | 0 | 0 | 0 | 0.00 |
| buffer deadlock | 826 | 824 | 0 | 0 | 0.00 |
| latch: messages | 3 | 0 | 0 | 0 | 0.00 |
| latch: redo writing | 1 | 0 | 0 | 0 | 0.00 |
| SQL*Net message from client | 12,529,567 | 0 | 3,081,420 | 246 | 43.37 |
| pipe get | 11,347 | 6,781 | 17,571 | 1,548 | 0.04 |
| queue messages | 1,173 | 983 | 10,061 | 8,577 | 0.00 |
| PX Idle Wait | 2,736 | 2,400 | 4,710 | 1,721 | 0.01 |
| Queue Monitor Wait | 120 | 120 | 3,515 | 29,291 | 0.00 |
| wakeup time manager | 1,501 | 586 | 3,247 | 2,163 | 0.01 |
| PL/SQL lock timer | 54 | 50 | 1,221 | 22,606 | 0.00 |
| PX Deq: Execution Msg | 6,905 | 14 | 90 | 13 | 0.02 |
| jobq slave wait | 20 | 20 | 59 | 2,930 | 0.00 |
| PX Deq: Execute Reply | 4,670 | 2 | 10 | 2 | 0.02 |
| class slave wait | 1 | 1 | 5 | 4,883 | 0.00 |
| PX Deq: Table Q Normal | 2,298 | 0 | 1 | 0 | 0.01 |
| PX Deq: Msg Fragment | 2,017 | 0 | 0 | 0 | 0.01 |
| PX Deq Credit: need buffer | 684 | 0 | 0 | 0 | 0.00 |
| PX Deq: Parse Reply | 161 | 0 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 189 | 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 | 480,289 | 0 | 107 | 0 | 1.66 |
| db file parallel write | 85,695 | 0 | 45 | 1 | 0.30 |
| db file scattered read | 2,643 | 0 | 5 | 2 | 0.01 |
| control file sequential read | 632 | 0 | 2 | 3 | 0.00 |
| control file parallel write | 1,573 | 0 | 1 | 1 | 0.01 |
| db file sequential read | 632 | 0 | 1 | 1 | 0.00 |
| rdbms ipc reply | 1,379 | 0 | 0 | 0 | 0.00 |
| LGWR wait for redo copy | 4,361 | 0 | 0 | 0 | 0.02 |
| direct path read | 200 | 0 | 0 | 1 | 0.00 |
| latch: library cache | 563 | 0 | 0 | 0 | 0.00 |
| buffer busy waits | 295 | 0 | 0 | 0 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| process startup | 2 | 0 | 0 | 14 | 0.00 |
| latch: shared pool | 196 | 0 | 0 | 0 | 0.00 |
| latch free | 44 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 42 | 0 | 0 | 0 | 0.00 |
| latch: redo allocation | 41 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 9 | 0 | 0 | 1 | 0.00 |
| latch: session allocation | 58 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 24 | 0 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 14 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 15 | 0 | 0 | 0 | 0.00 |
| direct path write | 150 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 6 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 2 | 0 | 0 | 0 | 0.00 |
| enq: TX - index contention | 1 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 7 | 0 | 0 | 0 | 0.00 |
| latch: messages | 3 | 0 | 0 | 0 | 0.00 |
| latch: redo writing | 1 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 1 | 0 | 0 | 0 | 0.00 |
| rdbms ipc message | 274,649 | 9,931 | 27,277 | 99 | 0.95 |
| Queue Monitor Wait | 120 | 120 | 3,515 | 29,291 | 0.00 |
| smon timer | 8,748 | 0 | 3,473 | 397 | 0.03 |
| wakeup time manager | 1,501 | 586 | 3,247 | 2,163 | 0.01 |
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 | 5,982.06 | 100.00 |
| DB CPU | 5,189.06 | 86.74 |
| sql execute elapsed time | 5,083.14 | 84.97 |
| PL/SQL execution elapsed time | 1,413.33 | 23.63 |
| inbound PL/SQL rpc elapsed time | 1,152.53 | 19.27 |
| background elapsed time | 515.65 | 8.62 |
| background cpu time | 356.19 | 5.95 |
| parse time elapsed | 237.77 | 3.97 |
| hard parse elapsed time | 133.91 | 2.24 |
| Java execution elapsed time | 125.55 | 2.10 |
| connection management call elapsed time | 4.64 | 0.08 |
| sequence load elapsed time | 4.24 | 0.07 |
| PL/SQL compilation elapsed time | 2.71 | 0.05 |
| failed parse elapsed time | 0.92 | 0.02 |
| hard parse (sharing criteria) elapsed time | 0.50 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.46 | 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 | 4,842.20 | 4,256.90 | 166,062 | 293,102,533 |
| SYS$USERS | 1,139.50 | 931.80 | 68,479 | 32,226,148 |
| SYS$BACKGROUND | 0.00 | 0.00 | 25,643 | 21,628,957 |
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 |
125,667 | 46,393 | 53,465 | 6,542 | 0 | 0 | 9,840,146 | 1,872 |
| SYS$USERS |
42,129 | 20,361 | 1,315 | 49 | 0 | 0 | 3,841,847 | 269 |
| SYS$BACKGROUND |
5,882 | 927 | 948 | 22 | 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 |
|---|
| 261 | 260 | 2 | 130.46 | 4.36 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 233 | 231 | 36,732 | 0.01 | 3.89 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 207 | 207 | 4 | 51.70 | 3.46 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 171 | 171 | 39,069 | 0.00 | 2.86 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 149 | 143 | 4 | 37.16 | 2.48 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 141 | 140 | 59 | 2.40 | 2.36 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 141 | 78 | 5,000 | 0.03 | 2.36 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 133 | 4 | 560 | 0.24 | 2.23 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 128 | 128 | 25,934 | 0.00 | 2.14 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 89 | 89 | 71,469 | 0.00 | 1.48 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 87 | 80 | 3 | 29.12 | 1.46 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 87 | 86 | 336 | 0.26 | 1.46 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 83 | 75 | 1,000 | 0.08 | 1.39 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 72 | 29 | 208 | 0.35 | 1.20 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 70 | 47 | 5,044 | 0.01 | 1.17 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 69 | 24 | 560 | 0.12 | 1.16 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 65 | 65 | 1,126,064 | 0.00 | 1.09 | 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 | 261 | 2 | 129.86 | 4.36 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 231 | 233 | 36,732 | 0.01 | 3.89 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 207 | 207 | 4 | 51.70 | 3.46 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 171 | 171 | 39,069 | 0.00 | 2.86 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 143 | 149 | 4 | 35.73 | 2.48 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 140 | 141 | 59 | 2.38 | 2.36 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 128 | 128 | 25,934 | 0.00 | 2.14 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 89 | 89 | 71,469 | 0.00 | 1.48 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 86 | 87 | 336 | 0.26 | 1.46 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 80 | 87 | 3 | 26.69 | 1.46 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 78 | 141 | 5,000 | 0.02 | 2.36 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 75 | 83 | 1,000 | 0.08 | 1.39 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 65 | 65 | 1,126,064 | 0.00 | 1.09 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 47 | 70 | 5,044 | 0.01 | 1.17 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 29 | 72 | 208 | 0.14 | 1.20 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 24 | 69 | 560 | 0.04 | 1.16 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 4 | 133 | 560 | 0.01 | 2.23 | 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: 347,216,708
- Captured SQL accounts for 20.5% of Total Buffer Gets
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 24,484,073 | 4 | 6,121,018.25 | 7.05 | 206.78 | 206.80 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 22,413,332 | 2 | 11,206,666.00 | 6.46 | 259.73 | 260.91 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 22,247,050 | 4 | 5,561,762.50 | 6.41 | 142.93 | 148.65 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 11,858,651 | 5,000 | 2,371.73 | 3.42 | 78.10 | 141.13 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 9,442,238 | 3 | 3,147,412.67 | 2.72 | 80.08 | 87.37 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 9,279,485 | 1,000 | 9,279.49 | 2.67 | 75.41 | 83.14 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 9,008,508 | 1,126,064 | 8.00 | 2.59 | 65.17 | 65.17 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 8,324,897 | 59 | 141,099.95 | 2.40 | 140.18 | 141.37 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 7,548,720 | 2,216,394 | 3.41 | 2.17 | 59.23 | 59.23 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 7,491,340 | 36,732 | 203.95 | 2.16 | 230.65 | 232.59 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 5,604,412 | 336 | 16,679.80 | 1.61 | 86.20 | 87.04 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 5,132,566 | 11,680 | 439.43 | 1.48 | 55.70 | 55.76 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 4,794,793 | 1,714,877 | 2.80 | 1.38 | 56.85 | 56.85 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 4,649,245 | 39,069 | 119.00 | 1.34 | 170.92 | 170.98 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 4,215,253 | 60,000 | 70.25 | 1.21 | 29.90 | 40.13 | 5qtxtsar19v4k |
PYUSLV
|
insert into pay_run_result_val... |
| 3,628,187 | 25,934 | 139.90 | 1.04 | 127.79 | 128.15 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 3,520,475 | 5,000 | 704.10 | 1.01 | 34.96 | 37.66 | 4ds53shhfcynn |
PYUSLV
|
declare
begin
hr_pre_pay.... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 277,480
- Captured SQL accounts for 36.1% of Total Disk Reads
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 35,549 | 560 | 63.48 | 12.81 | 4.13 | 133.35 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 27,614 | 5,000 | 5.52 | 9.95 | 78.10 | 141.13 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 14,291 | 15,174 | 0.94 | 5.15 | 24.28 | 57.15 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 11,118 | 560 | 19.85 | 4.01 | 24.12 | 69.31 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 9,554 | 1 | 9,554.00 | 3.44 | 14.60 | 17.32 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 6,981 | 3 | 2,327.00 | 2.52 | 80.08 | 87.37 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 6,319 | 5,044 | 1.25 | 2.28 | 46.62 | 70.22 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 1,865 | 280 | 6.66 | 0.67 | 41.88 | 47.35 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 1,323 | 3,502 | 0.38 | 0.48 | 40.03 | 45.21 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 905 | 84 | 10.77 | 0.33 | 35.77 | 38.44 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 28,472,492
- Captured SQL accounts for 35.1% of Total Executions
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,216,394 | 893,897 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 1,714,877 | 1,365,014 | 0.80 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 1,126,064 | 1,126,064 | 1.00 | 0.00 | 0.00 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,125,848 | 1,125,848 | 1.00 | 0.00 | 0.00 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 694,106 | 694,102 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 658,993 | 658,989 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 221,345 | 90,790 | 0.41 | 0.00 | 0.00 | 4g5vzcyf68n9w |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 142,357 | 142,357 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 116,030 | 116,029 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 115,685 | 115,685 | 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: 7,059,428
- Captured SQL accounts for 70.6% of Total Parse Calls
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 1,126,064 | 1,126,064 | 15.95 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,125,848 | 490 | 15.95 | 20rc3cmapyvnz |
|
select q_name, state, delay,... |
| 1,125,848 | 1,125,848 | 15.95 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 148,277 | 1,714,877 | 2.10 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 142,356 | 142,357 | 2.02 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 136,499 | 2,216,394 | 1.93 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 82,167 | 82,167 | 1.16 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 74,145 | 116,030 | 1.05 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 73,800 | 115,685 | 1.05 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 73,800 | 115,685 | 1.05 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
| 73,800 | 115,685 | 1.05 | 95pbs94n69z3d |
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 73,800 | 694,106 | 1.05 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 73,800 | 115,685 | 1.05 | bvyqm6268u2as |
|
SELECT NODE_NAME FROM FND_NODE... |
| 73,800 | 73,800 | 1.05 | fhqzxap2n0ybj |
|
select NAME from HR_OPERATING_... |
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,276,851 | 1,686 | 0.07 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
| 2,055,841 | 90 | 0.06 | azfadzhfxbxj3 |
ARXTWMAI
|
SELECT ROW_ID, APBA_INACTIVE_D... |
| 1,998,208 | 56 | 0.06 | 2fr5f5xzmffd8 |
POXPRPOP
|
SELECT decode ( : P_sortby , ... |
| 1,849,972 | 7 | 0.06 | 9trqpr8qyg7xm |
POXPRPOP
|
SELECT distinct pol . line_num... |
| 1,754,942 | 4,877 | 0.05 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,666,585 | 1,681 | 0.05 | bf4kcv5v66czb |
ibuSRDetails.jsp
|
SELECT 'NOTE', '2', b.creat... |
| 1,560,069 | 1,681 | 0.05 | bk9zgysk994av |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
| 1,399,557 | 1 | 0.04 | 0tdy0gjxn6wrb |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,388,258 | 12,024 | 0.04 | 3awy5jd6tdz7h |
WSHFSTRX
|
UPDATE WSH_EXCEPTIONS SET STAT... |
| 1,370,466 | 1 | 0.04 | dkvvgc7c1wksu |
RAXTRX
|
select
CONTRACT_ID||'~'||L.AGR... |
| 1,364,513 | 1 | 0.04 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 1,311,461 | 3,364 | 0.04 | fc74w8q18dtdu |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(QPQ ... |
| 1,273,896 | 280 | 0.04 | 2nfc4vng01c8t |
POXPOVPO
|
SELECT END_DATE, START_DATE, R... |
| 1,244,878 | 56 | 0.04 | 3c086a4sm741b |
ARXAGE
|
select decode ( UPPER ( : p_or... |
| 1,233,449 | 1 | 0.04 | 496za9aq6dd71 |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,218,375 | 280 | 0.04 | 0nr5vc1336tr9 |
APXINWKB
|
SELECT DESTINATION_TYPE_CODE, ... |
| 1,164,538 |
|
