|
|
|
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 09:35:04 | 2011 | 149.9 |
| End Snap: | 968 | 16-Jan-08 10:35:05 | 2019 | 163.5 |
| Elapsed: | | 60.02 (mins) | | |
| DB Time: | | 127.58 (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,334,306.57 | 22,038.34 |
| Logical reads: | 117,636.65 | 1,110.62 |
| Block changes: | 14,509.56 | 136.99 |
| Physical reads: | 78.06 | 0.74 |
| Physical writes: | 220.17 | 2.08 |
| User calls: | 4,592.43 | 43.36 |
| Parses: | 2,642.80 | 24.95 |
| Hard parses: | 2.00 | 0.02 |
| Sorts: | 1,304.09 | 12.31 |
| Logons: | 1.00 | 0.01 |
| Executes: | 10,238.30 | 96.66 |
| Transactions: | 105.92 | |
| % Blocks changed per Read: | 12.33 | Recursive Call %: | 81.03 |
| Rollback per transaction %: | 23.60 | Rows per Sort: | 13.64 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.94 | In-memory Sort %: | 100.00 |
| Library Hit %: | 100.00 | Soft Parse %: | 99.92 |
| Execute to Parse %: | 74.19 | Latch Hit %: | 99.80 |
| Parse CPU to Parse Elapsd %: | 97.31 | % Non-Parse CPU: | 94.69 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 46.75 | 59.18 |
| % SQL with executions>1: | 86.25 | 83.42 |
| % Memory for SQL w/exec>1: | 83.28 | 65.45 |
Top 5 Timed Events
| Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
|---|
| CPU time | | 6,788 | 88.67 | |
| db file sequential read | 156,100 | 646 | 8.44 | User I/O |
| log file parallel write | 605,408 | 126 | 1.65 | System I/O |
| log file sync | 163,854 | 82 | 1.07 | Commit |
| enq: TX - row lock contention | 263 | 71 | .92 | Application |
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 | 156,100 | 0 | 646 | 4 | 0.41 |
| log file parallel write | 605,408 | 0 | 126 | 0 | 1.59 |
| log file sync | 163,854 | 0 | 82 | 0 | 0.43 |
| enq: TX - row lock contention | 263 | 1 | 71 | 268 | 0.00 |
| db file parallel write | 99,662 | 0 | 50 | 1 | 0.26 |
| db file scattered read | 11,859 | 0 | 49 | 4 | 0.03 |
| enq: TM - contention | 15 | 1 | 33 | 2,188 | 0.00 |
| read by other session | 9,923 | 0 | 23 | 2 | 0.03 |
| enq: TX - index contention | 4,690 | 0 | 19 | 4 | 0.01 |
| buffer busy waits | 38,807 | 2 | 14 | 0 | 0.10 |
| library cache pin | 1,349 | 0 | 14 | 10 | 0.00 |
| SQL*Net more data from client | 851,227 | 0 | 13 | 0 | 2.23 |
| SQL*Net message to client | 17,320,364 | 0 | 10 | 0 | 45.40 |
| enq: UL - contention | 367 | 1 | 10 | 27 | 0.00 |
| rdbms ipc reply | 3,119 | 2 | 8 | 2 | 0.01 |
| SQL*Net more data to client | 689,649 | 0 | 7 | 0 | 1.81 |
| latch: library cache | 13,226 | 0 | 5 | 0 | 0.03 |
| SQL*Net break/reset to client | 37,138 | 0 | 5 | 0 | 0.10 |
| direct path read temp | 1,660 | 0 | 4 | 3 | 0.00 |
| PX Deq: Signal ACK | 264 | 84 | 4 | 15 | 0.00 |
| control file sequential read | 1,066 | 0 | 3 | 3 | 0.00 |
| library cache load lock | 152 | 0 | 1 | 10 | 0.00 |
| enq: DV - contention | 89 | 0 | 1 | 12 | 0.00 |
| enq: HW - contention | 52 | 0 | 1 | 20 | 0.00 |
| control file parallel write | 1,573 | 0 | 1 | 1 | 0.00 |
| PX Deq Credit: send blkd | 1,948 | 0 | 1 | 0 | 0.01 |
| latch: library cache pin | 1,375 | 0 | 1 | 0 | 0.00 |
| direct path write temp | 1,760 | 0 | 1 | 0 | 0.00 |
| enq: RO - fast object reuse | 211 | 0 | 0 | 2 | 0.00 |
| local write wait | 1,204 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 1,058 | 0 | 0 | 0 | 0.00 |
| latch: shared pool | 2,123 | 0 | 0 | 0 | 0.01 |
| PX qref latch | 54 | 28 | 0 | 6 | 0.00 |
| process startup | 18 | 0 | 0 | 15 | 0.00 |
| enq: SQ - contention | 1,434 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 651 | 0 | 0 | 0 | 0.00 |
| LGWR wait for redo copy | 5,444 | 0 | 0 | 0 | 0.01 |
| latch: In memory undo latch | 1,223 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 1,191 | 0 | 0 | 0 | 0.00 |
| latch free | 283 | 0 | 0 | 0 | 0.00 |
| direct path read | 200 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 112 | 0 | 0 | 0 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| enq: CU - contention | 11 | 0 | 0 | 3 | 0.00 |
| enq: TX - contention | 41 | 0 | 0 | 1 | 0.00 |
| latch: redo allocation | 58 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 53 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 30 | 0 | 0 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 11 | 0 | 0 | 1 | 0.00 |
| latch: row cache objects | 20 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 21 | 0 | 0 | 0 | 0.00 |
| direct path write | 1,376 | 0 | 0 | 0 | 0.00 |
| undo segment extension | 2,745 | 2,730 | 0 | 0 | 0.01 |
| enq: PS - contention | 33 | 0 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 13 | 0 | 0 | 0 | 0.00 |
| enq: FB - contention | 13 | 0 | 0 | 0 | 0.00 |
| latch: parallel query alloc buffer | 1 | 0 | 0 | 1 | 0.00 |
| row cache lock | 4 | 0 | 0 | 0 | 0.00 |
| PX Deq: Table Q qref | 5 | 0 | 0 | 0 | 0.00 |
| buffer deadlock | 666 | 666 | 0 | 0 | 0.00 |
| latch: messages | 3 | 0 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 1 | 0 | 0 | 0 | 0.00 |
| SQL*Net message from client | 17,320,354 | 0 | 4,078,868 | 235 | 45.40 |
| pipe get | 13,267 | 6,699 | 17,564 | 1,324 | 0.03 |
| queue messages | 1,283 | 970 | 10,179 | 7,934 | 0.00 |
| PX Idle Wait | 2,736 | 2,400 | 4,708 | 1,721 | 0.01 |
| Queue Monitor Wait | 120 | 120 | 3,511 | 29,255 | 0.00 |
| wakeup time manager | 1,475 | 706 | 3,134 | 2,125 | 0.00 |
| PL/SQL lock timer | 54 | 51 | 1,231 | 22,787 | 0.00 |
| PX Deq: Execution Msg | 7,022 | 27 | 152 | 22 | 0.02 |
| jobq slave wait | 20 | 20 | 59 | 2,930 | 0.00 |
| PX Deq: Execute Reply | 5,135 | 1 | 17 | 3 | 0.01 |
| PX Deq: Msg Fragment | 1,977 | 1 | 8 | 4 | 0.01 |
| class slave wait | 1 | 1 | 5 | 4,883 | 0.00 |
| PX Deq Credit: need buffer | 886 | 0 | 2 | 2 | 0.00 |
| PX Deq: Table Q Normal | 1,636 | 0 | 1 | 0 | 0.00 |
| PX Deq: Parse Reply | 141 | 0 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 182 | 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 | 605,400 | 0 | 126 | 0 | 1.59 |
| db file parallel write | 99,662 | 0 | 50 | 1 | 0.26 |
| db file scattered read | 2,597 | 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.00 |
| buffer busy waits | 380 | 0 | 1 | 1 | 0.00 |
| db file sequential read | 657 | 0 | 1 | 1 | 0.00 |
| rdbms ipc reply | 2,773 | 0 | 0 | 0 | 0.01 |
| latch: library cache | 902 | 0 | 0 | 0 | 0.00 |
| LGWR wait for redo copy | 5,444 | 0 | 0 | 0 | 0.01 |
| direct path read | 200 | 0 | 0 | 0 | 0.00 |
| latch: shared pool | 331 | 0 | 0 | 0 | 0.00 |
| control file single write | 124 | 0 | 0 | 0 | 0.00 |
| process startup | 2 | 0 | 0 | 14 | 0.00 |
| latch free | 90 | 0 | 0 | 0 | 0.00 |
| latch: redo allocation | 54 | 0 | 0 | 0 | 0.00 |
| latch: library cache lock | 40 | 0 | 0 | 0 | 0.00 |
| latch: library cache pin | 55 | 0 | 0 | 0 | 0.00 |
| latch: session allocation | 96 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 11 | 0 | 0 | 1 | 0.00 |
| direct path write | 150 | 0 | 0 | 0 | 0.00 |
| latch: cache buffers lru chain | 18 | 0 | 0 | 0 | 0.00 |
| latch: enqueue hash chains | 16 | 0 | 0 | 0 | 0.00 |
| latch: undo global data | 10 | 0 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 18 | 0 | 0 | 0 | 0.00 |
| latch: object queue header operation | 7 | 0 | 0 | 0 | 0.00 |
| latch: messages | 3 | 0 | 0 | 0 | 0.00 |
| latch: row cache objects | 1 | 0 | 0 | 0 | 0.00 |
| rdbms ipc message | 353,975 | 9,862 | 27,312 | 77 | 0.93 |
| Queue Monitor Wait | 120 | 120 | 3,511 | 29,255 | 0.00 |
| smon timer | 12,408 | 0 | 3,445 | 278 | 0.03 |
| wakeup time manager | 1,475 | 706 | 3,134 | 2,125 | 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,654.67 | 100.00 |
| DB CPU | 6,787.76 | 88.67 |
| sql execute elapsed time | 6,363.12 | 83.13 |
| PL/SQL execution elapsed time | 1,923.24 | 25.13 |
| inbound PL/SQL rpc elapsed time | 1,684.77 | 22.01 |
| background elapsed time | 673.46 | 8.80 |
| background cpu time | 490.79 | 6.41 |
| parse time elapsed | 322.29 | 4.21 |
| hard parse elapsed time | 179.39 | 2.34 |
| Java execution elapsed time | 138.86 | 1.81 |
| connection management call elapsed time | 6.13 | 0.08 |
| sequence load elapsed time | 5.29 | 0.07 |
| PL/SQL compilation elapsed time | 2.80 | 0.04 |
| failed parse elapsed time | 1.34 | 0.02 |
| hard parse (sharing criteria) elapsed time | 0.54 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.51 | 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,100.70 | 5,440.50 | 173,641 | 347,644,193 |
| SYS$USERS | 1,555.10 | 1,348.30 | 64,287 | 46,515,071 |
| SYS$BACKGROUND | 0.00 | 0.00 | 25,715 | 29,262,908 |
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 |
137,105 | 51,633 | 57,933 | 5,283 | 0 | 0 | 13,455,494 | 2,610 |
| SYS$USERS |
41,276 | 19,804 | 2,655 | 113 | 0 | 0 | 5,400,286 | 381 |
| SYS$BACKGROUND |
5,835 | 903 | 1,407 | 73 | 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 |
|---|
| 339 | 335 | 52,445 | 0.01 | 4.42 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 263 | 263 | 2 | 131.61 | 3.44 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 245 | 245 | 54,286 | 0.00 | 3.20 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 218 | 218 | 4 | 54.38 | 2.84 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 188 | 187 | 37,239 | 0.01 | 2.46 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 153 | 152 | 63 | 2.44 | 2.00 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 147 | 147 | 4 | 36.75 | 1.92 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 140 | 78 | 5,000 | 0.03 | 1.84 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 131 | 131 | 100,537 | 0.00 | 1.72 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 129 | 127 | 481 | 0.27 | 1.68 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 119 | 6 | 801 | 0.15 | 1.55 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 110 | 39 | 211 | 0.52 | 1.44 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 97 | 68 | 7,202 | 0.01 | 1.27 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 90 | 83 | 3 | 29.85 | 1.17 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 88 | 88 | 1,490,417 | 0.00 | 1.15 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 85 | 85 | 3,139,478 | 0.00 | 1.12 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 83 | 83 | 2,422,127 | 0.00 | 1.08 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 81 | 36 | 801 | 0.10 | 1.06 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 79 | 9 | 8,344 | 0.01 | 1.04 | gmrwcu0hdcp8b |
JDBC Thin Client
|
begin :v1 := CS_SR_CHILD_AUDIT... |
| 79 | 78 | 1,000 | 0.08 | 1.03 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 77 | 31 | 16,937 | 0.00 | 1.01 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
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 |
|---|
| 335 | 339 | 52,445 | 0.01 | 4.42 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 263 | 263 | 2 | 131.61 | 3.44 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 245 | 245 | 54,286 | 0.00 | 3.20 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 218 | 218 | 4 | 54.38 | 2.84 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 187 | 188 | 37,239 | 0.01 | 2.46 | 6h2tpcxpymqu7 |
JDBC Thin Client
|
BEGIN :1 := FND_AOLJ_UTIL.is_V... |
| 152 | 153 | 63 | 2.41 | 2.00 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 147 | 147 | 4 | 36.75 | 1.92 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 131 | 131 | 100,537 | 0.00 | 1.72 | 4dqasqjrvudqn |
JDBC Thin Client
|
begin dbms_session.reset_packa... |
| 127 | 129 | 481 | 0.26 | 1.68 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 88 | 88 | 1,490,417 | 0.00 | 1.15 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 85 | 85 | 3,139,478 | 0.00 | 1.12 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 83 | 90 | 3 | 27.62 | 1.17 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 83 | 83 | 2,422,127 | 0.00 | 1.08 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 78 | 140 | 5,000 | 0.02 | 1.84 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 78 | 79 | 1,000 | 0.08 | 1.03 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 68 | 97 | 7,202 | 0.01 | 1.27 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 39 | 110 | 211 | 0.19 | 1.44 | g0g2sj2by3p75 |
JDBC Thin Client
|
BEGIN WF_EVENT.LISTEN ( p_ag... |
| 36 | 81 | 801 | 0.05 | 1.06 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 31 | 77 | 16,937 | 0.00 | 1.01 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 9 | 79 | 8,344 | 0.00 | 1.04 | gmrwcu0hdcp8b |
JDBC Thin Client
|
begin :v1 := CS_SR_CHILD_AUDIT... |
| 6 | 119 | 801 | 0.01 | 1.55 | 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: 423,659,797
- Captured SQL accounts for 19.6% of Total Buffer Gets
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 26,280,222 | 4 | 6,570,055.50 | 6.20 | 217.51 | 217.51 | bkxrrs52m7d8p |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 23,285,878 | 4 | 5,821,469.50 | 5.50 | 147.00 | 147.00 | 7g05xfvc5vp74 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 21,133,378 | 2 | 10,566,689.00 | 4.99 | 263.22 | 263.22 | ghw9svn8x4vzu |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 11,923,332 | 1,490,417 | 8.00 | 2.81 | 88.38 | 88.38 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 11,858,732 | 5,000 | 2,371.75 | 2.80 | 77.99 | 140.46 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 10,694,314 | 52,445 | 203.91 | 2.52 | 335.46 | 338.55 | 3prk3vg9u0abb |
JDBC Thin Client
|
BEGIN FND_GLOBAL.APPS_INITIA... |
| 10,689,384 | 3,139,478 | 3.40 | 2.52 | 85.40 | 85.42 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 10,423,368 | 3 | 3,474,456.00 | 2.46 | 82.87 | 89.55 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 9,579,483 | 481 | 19,915.77 | 2.26 | 126.90 | 128.53 | bt0w082dfrm8v |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 9,293,217 | 1,000 | 9,293.22 | 2.19 | 77.66 | 78.58 | 2fjd6cndjby9p |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
| 8,783,987 | 63 | 139,428.37 | 2.07 | 151.71 | 153.41 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 6,782,897 | 2,422,127 | 2.80 | 1.60 | 82.59 | 82.59 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 6,460,098 | 54,286 | 119.00 | 1.52 | 244.64 | 244.84 | 9sf243fdjmdmh |
JDBC Thin Client
|
begin fnd_global.apps_initiali... |
| 6,326,849 | 12,394 | 510.48 | 1.49 | 63.37 | 64.42 | 4yak7x2zqz0dh |
WSHFRREL
|
BEGIN inv_transfer_order_pvt.f... |
| 5,206,913 | 37,239 | 139.82 | 1.23 | 187.35 | 187.98 | 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: 281,115
- Captured SQL accounts for 34.9% of Total Disk Reads
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 31,898 | 801 | 39.82 | 11.35 | 5.62 | 119.02 | 3dssuqfjsynrk |
asn.lead.server.LeadUwqAM
|
SELECT count(1) FROM (SELECT *... |
| 27,615 | 5,000 | 5.52 | 9.82 | 77.99 | 140.46 | 64qc329wgjv39 |
PYUSLV
|
select /*+ ORDERED INDEX(ASS... |
| 17,487 | 16,937 | 1.03 | 6.22 | 31.14 | 76.95 | 3vy5h9xkfv1s5 |
OEXOETEL
|
INSERT INTO WF_ITEM_ATTRIBUTE_... |
| 10,046 | 801 | 12.54 | 3.57 | 36.24 | 81.40 | 8c8cf4vtv4tx2 |
asn.lead.server.LeadUwqAM
|
SELECT * FROM ( SELECT LeadEO.... |
| 9,555 | 1 | 9,555.00 | 3.40 | 14.05 | 16.45 | bb995vqx5y1zd |
SQL*Plus
|
select /*+ cursor_sharing_exa... |
| 7,537 | 7,202 | 1.05 | 2.68 | 67.64 | 97.42 | 1q78dwnrrkf6c |
asn.lead.server.LeadUwqAM
|
BEGIN ASN_SALES_PVT.Lead_Proce... |
| 7,080 | 3 | 2,360.00 | 2.52 | 82.87 | 89.55 | 8c30hkqv9n7cr |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,702 | 400 | 4.26 | 0.61 | 59.37 | 65.92 | 3cb7xm8ykx1qh |
icx.por.req.server.RequisitionAM
|
begin :1 := POR_UTIL_PKG.subm... |
| 1,410 | 5,004 | 0.28 | 0.50 | 57.98 | 64.74 | 00y09j4jtwps1 |
JDBC Thin Client
|
declare sid number; l_enc_ke... |
| 985 | 120 | 8.21 | 0.35 | 50.37 | 53.86 | fumydqvpk1g21 |
qotSCopOverview.jsp
|
BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 36,872,500
- Captured SQL accounts for 37.6% of Total Executions
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 3,139,478 | 1,262,863 | 0.40 | 0.00 | 0.00 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 2,422,127 | 1,938,699 | 0.80 | 0.00 | 0.00 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 1,490,417 | 1,490,417 | 1.00 | 0.00 | 0.00 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,490,225 | 1,490,225 | 1.00 | 0.00 | 0.00 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 981,569 | 981,570 | 1.00 | 0.00 | 0.00 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 947,729 | 947,726 | 1.00 | 0.00 | 0.00 | 9dvfguzd15kpv |
JDBC Thin Client
|
SELECT VALUE FROM V$NLS_PARAME... |
| 314,550 | 129,296 | 0.41 | 0.00 | 0.00 | 4g5vzcyf68n9w |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 201,630 | 201,630 | 1.00 | 0.00 | 0.00 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 164,052 | 164,052 | 1.00 | 0.00 | 0.00 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 163,597 | 92,010 | 0.56 | 0.00 | 0.00 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 9,517,845
- Captured SQL accounts for 70.4% of Total Parse Calls
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 1,490,417 | 1,490,417 | 15.66 | cgb6kp2umq52a |
|
select t.schema, t.name, t.f... |
| 1,490,225 | 700 | 15.66 | 20rc3cmapyvnz |
|
select q_name, state, delay,... |
| 1,490,225 | 1,490,225 | 15.66 | 8bsm049u7thjd |
|
select min(next_date) from "AP... |
| 208,449 | 2,422,127 | 2.19 | 6cjfxb1c4kx16 |
|
SELECT PROFILE_OPTION_ID, APP... |
| 201,631 | 201,630 | 2.12 | avc1jqzz04wpr |
JDBC Thin Client
|
SELECT 'x' FROM DUAL |
| 191,622 | 3,139,478 | 2.01 | c4y7jp0q2awbf |
|
SELECT PROFILE_OPTION_VALUE FR... |
| 110,828 | 110,828 | 1.16 | fmfdkztk8vx23 |
|
SELECT CATEGORY, SEVERITY, F... |
| 104,196 | 164,052 | 1.09 | 0w785m9gmw41a |
|
SELECT USERENV('SESSIONID') FR... |
| 103,741 | 163,596 | 1.09 | 29x3dahwzdj8b |
|
SELECT U.USER_NAME, NVL(U.EMP... |
| 103,741 | 163,597 | 1.09 | 5as61q63aqmts |
|
SELECT A.APPLICATION_SHORT_NAM... |
| 103,741 | 163,596 | 1.09 | 95pbs94n69z3d |
|
SELECT NVL(MULTI_ORG_FLAG, 'N... |
| 103,741 | 981,569 | 1.09 | bc7t6t6jfx2n7 |
|
SELECT VERSION FROM FND_CACHE_... |
| 103,741 | 163,596 | 1.09 | bvyqm6268u2as |
|
SELECT NODE_NAME FROM FND_NODE... |
| 103,741 | 103,741 | 1.09 | fhqzxap2n0ybj |
|
select NAME from HR_OPERATING_... |
| 97,099 | 97,099 | 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,627 | 2,395 | 0.07 | 8ay7m8qubw98j |
POXBWVRP
|
select * from PO_TAX_LINES_SUM... |
| 2,054,169 | 138 | 0.06 | azfadzhfxbxj3 |
ARXTWMAI
|
SELECT ROW_ID, APBA_INACTIVE_D... |
| 1,999,032 | 81 | 0.06 | 2fr5f5xzmffd8 |
POXPRPOP
|
SELECT decode ( : P_sortby , ... |
| 1,849,292 | 19 | 0.06 | 9trqpr8qyg7xm |
POXPRPOP
|
SELECT distinct pol . line_num... |
| 1,753,326 | 6,960 | 0.05 | 8q8zmrwmrccz4 |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(adj ... |
| 1,666,073 | 2,400 | 0.05 | bf4kcv5v66czb |
ibuSRDetails.jsp
|
SELECT 'NOTE', '2', b.creat... |
| 1,566,077 | 2,399 | 0.05 | bk9zgysk994av |
OEXOETEL
|
SELECT /*+ ORDERED USE_NL(qpq ... |
| 1,398,445 | 1 | 0.04 | 0tdy0gjxn6wrb |
RAXMTR
|
select /*+ cursor_sharing_exa... |
| 1,370,522 | 1 | 0.04 | |
|
