|
|
|
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: | 969 | 14-Mar-08 18:19:13 | 2025 | 148.6 |
| End Snap: | 970 | 14-Mar-08 19:19:15 | 2032 | 161.1 |
| Elapsed: | | 60.03 (mins) | | |
| DB Time: | | 143.94 (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,336,444.57 | 22,021.83 |
| Logical reads: | 116,698.96 | 1,099.93 |
| Block changes: | 14,557.23 | 137.21 |
| Physical reads: | 76.47 | 0.72 |
| Physical writes: | 221.96 | 2.09 |
| User calls: | 4,643.04 | 43.76 |
| Parses: | 2,217.62 | 20.90 |
| Hard parses: | 1.94 | 0.02 |
| Sorts: | 1,337.61 | 12.61 |
| Logons: | 1.00 | 0.01 |
| Executes: | 10,015.19 | 94.40 |
| Transactions: | 106.10 | |
| % Blocks changed per Read: | 12.47 | Recursive Call %: | 80.22 |
| Rollback per transaction %: | 23.56 | Rows per Sort: | 13.27 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.94 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.98 | Soft Parse %: | 99.91 |
| Execute to Parse %: | 77.86 | Latch Hit %: | 99.83 |
| Parse CPU to Parse Elapsd %: | 97.45 | % Non-Parse CPU: | 95.12 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 46.90 | 58.96 |
| % SQL with executions>1: | 81.02 | 84.18 |
| % Memory for SQL w/exec>1: | 80.62 | 65.72 |
Top 5 Timed Events
| Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
|---|
| CPU time | | 7,710 | 89.27 | |
| db file sequential read | 153,047 | 649 | 7.52 | User I/O |
| log file parallel write | 598,878 | 127 | 1.47 | System I/O |
| enq: TX - row lock contention | 235 | 93 | 1.08 | Application |
| log file sync | 161,861 | 88 | 1.02 | 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 | 153,047 | 0 | 649 | 4 | 0.40 |
| log file parallel write | 598,878 | 0 | 127 | 0 | 1.57 |
| enq: TX - row lock contention | 235 | 1 | 93 | 396 | 0.00 |
| log file sync | 161,861 | 0 | 88 | 1 | 0.42 |
| db file scattered read | 11,323 | 0 | 50 | 4 | 0.03 |
| db file parallel write | 93,179 | 0 | 40 | 0 | 0.24 |
| SQL*Net break/reset to client | 86,232 | 0 | 36 | 0 | 0.23 |
| enq: TM - contention | 14 | 0 | 34 | 2,456 | 0.00 |
| SQL*Net message to client | 17,502,598 | 0 | 27 | 0 | 45.80 |
| buffer busy waits | 35,040 | 2 | 27 | 1 | 0.09 |
| latch: cache buffers chains | 4,362 | 0 | 22 | 5 | 0.01 |
| read by other session | 9,054 | 0 | 21 | 2 | 0.02 |
| SQL*Net more data from client | 849,990 | 0 | 15 | 0 | 2.22 |
| rdbms ipc reply | 2,876 | 5 | 13 | 4 | 0.01 |
| enq: TX - index contention | 4,073 | 0 | 12 | 3 | 0.01 |
| latch: library cache | 13,754 | 0 | 10 | 1 | 0.04 |
| library cache pin | 1,189 | 0 | 10 | 8 | 0.00 |
| SQL*Net more data to client | 689,552 | 0 | 7 | 0 | 1.80 |
| enq: UL - contention | 252 | 0 | 5 | 21 | 0.00 |
| PX Deq Credit: send blkd | 1,727 | 0 | 5 | 3 | 0.00 |
| direct path read temp | 1,659 | 0 | 4 | 3 | 0.00 |
| PX Deq: Signal ACK | 232 | 77 | 4 | 18 | 0.00 |
| control file sequential read | 1,437 | 0 | 3 | 2 | 0.00 |
| latch: library cache pin | 1,488 | 0 | 2 | 1 | 0.00 |
| library cache load lock | 117 | 0 | 2 | 13 | 0.00 |
| latch: enqueue hash chains | 221 | 0 | 1 | 6 | 0.00 |
| enq: DV - contention | 60 | 0 | 1 | 15 | 0.00 |
| latch free | 443 | 0 | 1 | 2 | 0.00 |
| control file parallel write | 1,573 | 0 | 1 | 1 | 0.00 |
| local write wait | 1,140 | 0 | 1 | 1 | 0.00 |
| enq: SQ - contention | 2,356 | 0 | 1 | 0 | 0.01 |
| direct path write temp | 1,802 | 0 | 1 | 0 | 0.00 |
| enq: RO - fast object reuse | 198 | 0 | 1 | 3 | 0.00 |
| latch: shared pool | 1,952 | 0 | 0 | 0 | 0.01 |
| PX qref latch | 62 | 37 | 0 | 7 | 0.00 |
| direct path read | 200 | 0 | 0 | 2 | 0.00 |
| latch: In memory undo latch | 700 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 1,755 | 0 | 0 | 0 | 0.00 |
| process startup | 17 | 0 | 0 | 15 | 0.00 |
| LGWR wait for redo copy | 5,124 | 0 | 0 | 0 | 0.01 |
| latch: session allocation | 560 | 0 | 0 | 0 | 0.00 |
| enq: HW - contention | 46 | 0 | 0 | 1 | 0.00 |
| enq: CU - contention | 11 | 0 | 0 | 5 | 0.00 |
| latch: library cache lock | 88 | 0 | 0 | 1 | 0.00 |
| kksfbc child completion | 1 | 1 | 0 | 50 | 0.00 |
| enq: TX - contention | 58 | 0 | 0 | 1 | 0.00 |
| wait list latch free | 4 | 0 | 0 | 11 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 59 | 0 | 0 | 1 | 0.00 |
| latch: object queue header operation | 20 | 0 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 7 | 0 | 0 | 2 | 0.00 |
| latch: redo allocation | 65 | 0 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 14 | 0 | 0 | 0 | 0.00 |
| direct path write | 1,646 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 23 | 0 | 0 | 0 | 0.00 |
| undo segment extension | 1,778 | 1,766 | 0 | 0 | 0.00 |
| log buffer space | 1 | 0 | 0 | 1 | 0.00 |
| enq: PS - contention | 43 | 0 | 0 | 0 | 0.00 |
| enq: FB - contention | 15 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q qref | 13 | 0 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 1 | 0 | 0 | 1 | 0.00 |
| buffer deadlock | 325 | 324 | 0 | 0 | 0.00 |
| row cache lock | 11 | 0 | 0 | 0 | 0.00 |
| latch: redo writing | 2 | 0 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 2 | 0 | 0 | 0 | 0.00 |
| latch: messages | 1 | 0 | 0 | 0 | 0.00 |
| SQL*Net message from client | 17,502,596 | 0 | 4,092,378 | 234 | 45.80 |
| pipe get | 13,327 | 6,697 | 17,578 | 1,319 | 0.03 |
| queue messages | 1,291 | 971 | 10,185 | 7,889 | 0.00 |
| PX Idle Wait | 2,738 | 2,400 | 4,702 | 1,717 | 0.01 |
| Queue Monitor Wait | 120 | 120 | 3,497 | 29,139 | 0.00 |
| wakeup time manager | 1,487 | 733 | 3,139 | 2,111 | 0.00 |
| PL/SQL lock timer | 58 | 55 | 1,388 | 23,930 | 0.00 |
| PX Deq: Execution Msg | 7,084 | 37 | 174 | 25 | 0.02 |
| jobq slave wait | 20 | 20 | 59 | 2,930 | 0.00 |
| PX Deq: Execute Reply | 5,024 | 2 | 22 | 4 | 0.01 |
| PX Deq: Table Q Normal | 2,784 | 0 | 1 | 0 | 0.01 |
| PX Deq: Msg Fragment | 1,987 | 0 | 0 | 0 | 0.01 |
| PX Deq Credit: need buffer | 579 | 0 | 0 | 0 | 0.00 |
| PX Deq: Parse Reply | 160 | 0 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 209 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q Sample | 68 | 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 | 598,898 | 0 | 127 | 0 | 1.57 |
| db file parallel write | 93,200 | 0 | 40 | 0 | 0.24 |
| db file scattered read | 2,630 | 0 | 5 | 2 | 0.01 |
| control file sequential read | 632 | 0 | 2 | 3 | 0.00 |
| buffer busy waits | 491 | 1 | 1 | 3 | 0.00 |
| control file parallel write | 1,573 | 0 | 1 | 1 | 0.00 |
| db file sequential read | 623 | 0 | 0 | 1 | 0.00 |
| direct path read | 200 | 0 | 0 | 2 | 0.00 |
| rdbms ipc reply | 2,513 | 0 | 0 | 0 | 0.01 |
| LGWR wait for redo copy | 5,124 | 0 | 0 | 0 | 0.01 |
| latch: library cache | 590 | 0 | 0 | 0 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| latch: shared pool | 203 | 0 | 0 | 0 | 0.00 |
| latch free | 46 | 0 | 0 | 0 | 0.00 |
| process startup | 1 | 0 | 0 | 15 | 0.00 |
| latch: session allocation | 55 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 24 | 0 | 0 | 1 | 0.00 |
| latch: cache buffers chains | 17 | 0 | 0 | 1 | 0.00 |
| latch: redo allocation | 62 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 46 | 0 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 12 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 20 | 0 | 0 | 0 | 0.00 |
| direct path write | 150 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 7 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 27 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 10 | 0 | 0 | 0 | 0.00 |
| enq: TX - index contention | 2 | 0 | 0 | 0 | 0.00 |
| latch: redo writing | 2 | 0 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 1 | 0 | 0 | 0 | 0.00 |
| latch: messages | 1 | 0 | 0 | 0 | 0.00 |
| rdbms ipc message | 342,259 | 9,867 | 27,494 | 80 | 0.90 |
| Queue Monitor Wait | 120 | 120 | 3,497 | 29,139 | 0.00 |
| smon timer | 12,296 | 0 | 3,442 | 280 | 0.03 |
| wakeup time manager | 1,487 | 733 | 3,139 | 2,111 | 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 | 8,636.20 | 100.00 |
| DB CPU | 7,709.54 | 89.27 |
| sql execute elapsed time | 7,174.32 | 83.07 |
| PL/SQL execution elapsed time | 2,173.69 | 25.17 |
| inbound PL/SQL rpc elapsed time | 1,890.47 | 21.89 |
| background elapsed time | 671.50 | 7.78 |
| background cpu time | 497.34 | 5.76 |
| parse time elapsed | 349.93 | 4.05 |
| Java execution elapsed time | 220.60 | 2.55 |
| hard parse elapsed time | 169.64 | 1.96 |
| sequence load elapsed time | 7.06 | 0.08 |
| connection management call elapsed time | 6.25 | 0.07 |
| PL/SQL compilation elapsed time | 2.70 | 0.03 |
| failed parse elapsed time | 1.25 | 0.01 |
| hard parse (sharing criteria) elapsed time | 0.67 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.63 | 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 | 6,997.20 | 6,315.80 | 166,362 | 351,486,652 |
| SYS$USERS | 1,637.80 | 1,392.60 | 72,489 | 45,534,013 |
| SYS$BACKGROUND | 0.00 | 0.00 | 19,085 | 23,009,230 |
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 |
128,928 | 49,127 | 56,913 | 8,149 | 0 | 0 | 13,533,065 | 3,992 |
| SYS$USERS |
47,690 | 22,865 | 2,730 | 135 | 0 | 0 | 5,503,538 | 920 |
| SYS$BACKGROUND |
3,603 | 607 | 1,178 | 152 | 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 |
|---|
| 401 | 401 | 2 | 200.51 | 4.64 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 347 | 341 | 52,464 | 0.01 | 4.01 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 311 | 311 | 4 | 77.86 | 3.61 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 253 | 252 | 54,279 | 0.00 | 2.93 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 229 | 229 | 63 | 3.63 | 2.65 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 192 | 186 | 4 | 48.00 | 2.22 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 191 | 190 | 37,228 | 0.01 | 2.22 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 159 | 156 | 482 | 0.33 | 1.84 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 152 | 59 | 219 | 0.69 | 1.76 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 138 | 138 | 100,551 | 0.00 | 1.60 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 124 | 5 | 800 | 0.16 | 1.44 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 123 | 58 | 5,000 | 0.02 | 1.42 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 116 | 107 | 3 | 38.78 | 1.35 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 108 | 15 | 8,444 | 0.01 | 1.25 | gmrwcu0hdcp8b |
JDBC Thin Client
|
begin :v1 := CS_SR_CHILD_AUDIT... |
| 105 | 97 | 1,000 | 0.10 | 1.21 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 102 | 71 | 7,203 | 0.01 | 1.18 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 95 | 2 | 8,435 | 0.01 | 1.10 | 2spgk3k0f7quz |
CSCCCCRC
|
SELECT * FROM CS_INCIDENTS_ALL... |
| 93 | 93 | 2,425,133 | 0.00 | 1.08 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 91 | 91 | 978,390 | 0.00 | 1.05 | 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 |
|---|
| 401 | 401 | 2 | 200.51 | 4.64 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 341 | 347 | 52,464 | 0.01 | 4.01 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 311 | 311 | 4 | 77.86 | 3.61 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 252 | 253 | 54,279 | 0.00 | 2.93 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 229 | 229 | 63 | 3.63 | 2.65 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 190 | 191 | 37,228 | 0.01 | 2.22 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 186 | 192 | 4 | 46.58 | 2.22 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 156 | 159 | 482 | 0.32 | 1.84 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 138 | 138 | 100,551 | 0.00 | 1.60 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 107 | 116 | 3 | 35.76 | 1.35 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 97 | 105 | 1,000 | 0.10 | 1.21 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 93 | 93 | 2,425,133 | 0.00 | 1.08 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 91 | 91 | 978,390 | 0.00 | 1.05 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 71 | 102 | 7,203 | 0.01 | 1.18 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 59 | 152 | 219 | 0.27 | 1.76 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 58 | 123 | 5,000 | 0.01 | 1.42 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 15 | 108 | 8,444 | 0.00 | 1.25 | gmrwcu0hdcp8b |
JDBC Thin Client
|
begin :v1 := CS_SR_CHILD_AUDIT... |
| 5 | 124 | 800 | 0.01 | 1.44 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 2 | 95 | 8,435 | 0.00 | 1.10 | 2spgk3k0f7quz |
CSCCCCRC
|
SELECT * FROM CS_INCIDENTS_ALL... |
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: 420,321,518
- Captured SQL accounts for 18.6% of Total Buffer Gets
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 25,727,321 | 4 | 6,431,830.25 | 6.12 | 311.43 | 311.44 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 25,355,604 | 4 | 6,338,901.00 | 6.03 | 186.31 | 192.01 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 21,127,131 | 2 | 10,563,565.50 | 5.03 | 401.01 | 401.01 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 11,858,663 | 5,000 | 2,371.73 | 2.82 | 57.55 | 122.88 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 10,702,658 | 3,143,610 | 3.40 | 2.55 | 80.80 | 80.83 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 10,702,229 | 52,464 | 203.99 | 2.55 | 341.30 | 346.54 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 9,683,214 | 482 | 20,089.66 | 2.30 | 156.29 | 158.83 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 9,211,038 | 1,000 | 9,211.04 | 2.19 | 97.22 | 104.54 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 9,017,868 | 3 | 3,005,956.00 | 2.15 | 107.29 | 116.34 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 8,966,991 | 63 | 142,333.19 | 2.13 | 228.58 | 228.70 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 7,827,118 | 978,390 | 8.00 | 1.86 | 90.50 | 90.54 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 6,791,782 | 2,425,133 | 2.80 | 1.62 | 93.43 | 93.48 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 6,459,277 | 54,279 | 119.00 | 1.54 | 252.21 | 253.02 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 5,987,687 | 12,407 | 482.61 | 1.42 | 84.36 | 84.52 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 5,215,915 | 37,228 | 140.11 | 1.24 | 190.26 | 191.43 | 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: 275,437
- Captured SQL accounts for 35.6% of Total Disk Reads
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 30,144 | 800 | 37.68 | 10.94 | 5.50 | 124.13 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 27,609 | 5,000 | 5.52 | 10.02 | 57.55 | 122.88 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 17,106 | 16,951 | 1.01 | 6.21 | 28.66 | 72.14 | 3vy5h9xkfv1s5 |
hxc.selfservice.timecard.server.TimecardAM
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 12,016 | 800 | 15.02 | 4.36 | 36.19 | 82.90 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 9,554 | 1 | 9,554.00 | 3.47 | 17.69 | 20.64 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 8,522 | 3 | 2,840.67 | 3.09 | 107.29 | 116.34 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 8,001 | 7,203 | 1.11 | 2.90 | 71.07 | 101.66 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 1,850 | 400 | 4.63 | 0.67 | 66.63 | 73.16 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 1,375 | 5,004 | 0.27 | 0.50 | 59.13 | 65.47 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 985 | 120 | 8.21 | 0.36 | 65.84 | 68.79 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 36,072,297
- Captured SQL accounts for 35.5% of Total Executions
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 3,143,610 | 1,263,551 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 2,425,133 | 1,941,516 | 0.80 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 981,936 | 981,936 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 978,390 | 978,390 | 1.00 | 0.00 | 0.00 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 978,178 | 978,178 | 1.00 | 0.00 | 0.00 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 945,935 | 945,935 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 315,052 | 129,485 | 0.41 | 0.00 | 0.00 | 4g5vzcyf68n9w |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 201,661 | 201,661 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 164,136 | 164,136 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 163,656 | 163,656 | 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,987,334
- Captured SQL accounts for 64.6% of Total Parse Calls
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 978,390 | 978,390 | 12.25 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 978,178 | 701 | 12.25 | 20rc3cmapyvnz |
|
select q_name, state, delay,... |
| 978,178 | 978,178 | 12.25 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 208,488 | 2,425,133 | 2.61 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 201,661 | 201,661 | 2.52 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 191,650 | 3,143,610 | 2.40 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 111,002 | 111,002 | 1.39 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 104,241 | 164,136 | 1.31 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 103,761 | 163,656 | 1.30 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 103,761 | 163,656 | 1.30 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
| 103,761 | 163,656 | 1.30 | 95pbs94n69z3d |
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 103,761 | 981,936 | 1.30 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 103,761 | 163,656 | 1.30 | bvyqm6268u2as |
|
SELECT NODE_NAME FROM FND_NODE... |
| 103,761 | 103,761 | 1.30 | fhqzxap2n0ybj |
|
select NAME from HR_OPERATING_... |
| 97,113 | 97,113 | 1.22 | 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,276,803 | 2,412 | 0.07 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
| 2,053,033 | 135 | 0.06 | azfadzhfxbxj3 |
ARXTWMAI
|
SELECT ROW_ID, APBA_INACTIVE_D... |
| 1,999,784 | 81 | 0.06 | 2fr5f5xzmffd8 |
POXPRPOP
|
SELECT decode ( : P_sortby , ... |
| 1,852,796 | 9 | 0.06 | 9trqpr8qyg7xm |
POXPRPOP
|
SELECT distinct pol . line_num... |
| 1,753,366 | 6,971 | 0.05 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,666,465 | 2,400 | 0.05 | bf4kcv5v66czb |
ibuSRDetails.jsp
|
SELECT 'NOTE', '2', b.creat... |
| 1,563,981 | 2,402 | 0.05 | bk9zgysk994av |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
| 1,400,077 | 1 | 0.04 | 0tdy0gjxn6wrb |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,364,497 | 1 | 0.04 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 1,363,194 | 1 | 0.04 |
|
