|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 1412883651 | VIS | 1 | 10.2.0.3.0 | NO | r12db.sanmateo.ibm.com |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 696 | 27-Sep-09 21:26:42 | 87 | 31.2 |
| End Snap: | 697 | 27-Sep-09 21:56:33 | 91 | 29.2 |
| Elapsed: | | 29.85 (mins) | | |
| DB Time: | | 172.98 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 8,160M | 8,112M | Std Block Size: | 8K |
| Shared Pool Size: | 2,000M | 2,000M | Log Buffer: | 30,724K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 11,454,877.07 | 32,277.59 |
| Logical reads: | 835,778.96 | 2,355.06 |
| Block changes: | 70,313.95 | 198.13 |
| Physical reads: | 268.76 | 0.76 |
| Physical writes: | 859.66 | 2.42 |
| User calls: | 90.00 | 0.25 |
| Parses: | 1,118.01 | 3.15 |
| Hard parses: | 1.88 | 0.01 |
| Sorts: | 2,181.52 | 6.15 |
| Logons: | 0.41 | 0.00 |
| Executes: | 25,438.08 | 71.68 |
| Transactions: | 354.89 | |
| % Blocks changed per Read: | 8.41 | Recursive Call %: | 99.81 |
| Rollback per transaction %: | 0.09 | Rows per Sort: | 15.36 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.90 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
| Library Hit %: | 100.05 | Soft Parse %: | 99.83 |
| Execute to Parse %: | 95.60 | Latch Hit %: | 97.46 |
| Parse CPU to Parse Elapsd %: | 39.10 | % Non-Parse CPU: | 99.76 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 47.33 | 55.20 |
| % SQL with executions>1: | 75.41 | 90.22 |
| % Memory for SQL w/exec>1: | 76.06 | 93.19 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 9,459 | | 91.1 | |
| log file parallel write | 293,442 | 554 | 2 | 5.3 | System I/O |
| log file sync | 180,126 | 462 | 3 | 4.5 | Commit |
| db file sequential read | 113,135 | 142 | 1 | 1.4 | User I/O |
| buffer busy waits | 1,409,983 | 82 | 0 | .8 | Concurrency |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 10378.8s
- Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
- Ordered by % or DB time desc, Statistic name
| Statistic Name | Time (s) | % of DB Time |
|---|
| sql execute elapsed time | 10,362.00 | 99.84 |
| DB CPU | 9,458.80 | 91.14 |
| PL/SQL execution elapsed time | 2,201.17 | 21.21 |
| Java execution elapsed time | 496.71 | 4.79 |
| parse time elapsed | 77.43 | 0.75 |
| hard parse elapsed time | 23.27 | 0.22 |
| sequence load elapsed time | 6.86 | 0.07 |
| repeated bind elapsed time | 3.95 | 0.04 |
| PL/SQL compilation elapsed time | 3.28 | 0.03 |
| connection management call elapsed time | 0.99 | 0.01 |
| hard parse (sharing criteria) elapsed time | 0.46 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.12 | 0.00 |
| inbound PL/SQL rpc elapsed time | 0.02 | 0.00 |
| failed parse elapsed time | 0.01 | 0.00 |
| DB time | 10,378.76 | |
| background elapsed time | 1,002.22 | |
| background cpu time | 148.92 | |
Back to Wait Events Statistics
Back to Top
Wait Class
- 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
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| System I/O | 298,119 | 0.00 | 563 | 2 | 0.47 |
| Commit | 180,126 | 0.00 | 462 | 3 | 0.28 |
| User I/O | 223,405 | 0.00 | 220 | 1 | 0.35 |
| Concurrency | 1,867,073 | 0.10 | 188 | 0 | 2.94 |
| Application | 5,468 | 0.00 | 62 | 11 | 0.01 |
| Configuration | 21,159 | 21.53 | 55 | 3 | 0.03 |
| Other | 131,655 | 36.10 | 34 | 0 | 0.21 |
| Network | 150,047 | 0.00 | 0 | 0 | 0.24 |
Back to 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 | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 293,442 | 0.00 | 554 | 2 | 0.46 |
| log file sync | 180,126 | 0.00 | 462 | 3 | 0.28 |
| db file sequential read | 113,135 | 0.00 | 142 | 1 | 0.18 |
| buffer busy waits | 1,409,983 | 0.00 | 82 | 0 | 2.22 |
| enq: TX - row lock contention | 4,625 | 0.00 | 61 | 13 | 0.01 |
| read by other session | 30,856 | 0.00 | 55 | 2 | 0.05 |
| library cache load lock | 2,301 | 0.00 | 51 | 22 | 0.00 |
| log file switch (checkpoint incomplete) | 113 | 28.32 | 43 | 385 | 0.00 |
| enq: TX - index contention | 25,378 | 0.00 | 25 | 1 | 0.04 |
| db file scattered read | 6,949 | 0.00 | 22 | 3 | 0.01 |
| cursor: pin S wait on X | 2,071 | 91.45 | 20 | 10 | 0.00 |
| kksfbc child completion | 254 | 78.74 | 10 | 39 | 0.00 |
| control file parallel write | 1,628 | 0.00 | 8 | 5 | 0.00 |
| buffer deadlock | 47,372 | 99.28 | 8 | 0 | 0.07 |
| log file switch completion | 458 | 0.00 | 7 | 16 | 0.00 |
| latch: cache buffers chains | 415,551 | 0.00 | 5 | 0 | 0.65 |
| enq: TX - contention | 12,263 | 0.00 | 4 | 0 | 0.02 |
| enq: HW - contention | 9,138 | 0.00 | 4 | 0 | 0.01 |
| enq: US - contention | 25,565 | 0.00 | 3 | 0 | 0.04 |
| PX Deq Credit: send blkd | 6,285 | 0.00 | 2 | 0 | 0.01 |
| latch: library cache | 1,510 | 0.00 | 2 | 1 | 0.00 |
| latch free | 2,183 | 0.00 | 1 | 1 | 0.00 |
| rdbms ipc reply | 12,109 | 0.00 | 1 | 0 | 0.02 |
| SGA: allocation forcing component growth | 94 | 95.74 | 1 | 11 | 0.00 |
| latch: In memory undo latch | 6,580 | 0.00 | 1 | 0 | 0.01 |
| PX Deq: Signal ACK | 98 | 17.35 | 1 | 8 | 0.00 |
| latch: enqueue hash chains | 760 | 0.00 | 1 | 1 | 0.00 |
| enq: RO - fast object reuse | 24 | 0.00 | 1 | 32 | 0.00 |
| enq: SQ - contention | 6,787 | 0.00 | 1 | 0 | 0.01 |
| latch: row cache objects | 1,289 | 0.00 | 1 | 0 | 0.00 |
| LGWR wait for redo copy | 16,226 | 0.04 | 1 | 0 | 0.03 |
| enq: KO - fast object checkpoint | 11 | 0.00 | 1 | 52 | 0.00 |
| latch: library cache pin | 213 | 0.00 | 0 | 2 | 0.00 |
| wait list latch free | 39 | 0.00 | 0 | 11 | 0.00 |
| enq: FB - contention | 3,009 | 0.00 | 0 | 0 | 0.00 |
| os thread startup | 28 | 0.00 | 0 | 14 | 0.00 |
| latch: shared pool | 357 | 0.00 | 0 | 1 | 0.00 |
| latch: session allocation | 108 | 0.00 | 0 | 2 | 0.00 |
| row cache lock | 1,217 | 0.00 | 0 | 0 | 0.00 |
| latch: undo global data | 1,114 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache lock | 50 | 0.00 | 0 | 3 | 0.00 |
| local write wait | 44 | 0.00 | 0 | 3 | 0.00 |
| latch: cache buffers lru chain | 110 | 0.00 | 0 | 1 | 0.00 |
| SQL*Net more data to client | 9,174 | 0.00 | 0 | 0 | 0.01 |
| SQL*Net message to client | 133,778 | 0.00 | 0 | 0 | 0.21 |
| SQL*Net more data from client | 7,095 | 0.00 | 0 | 0 | 0.01 |
| direct path read | 69,917 | 0.00 | 0 | 0 | 0.11 |
| latch: redo allocation | 156 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net break/reset to client | 808 | 0.00 | 0 | 0 | 0.00 |
| cursor: pin S | 3,466 | 0.00 | 0 | 0 | 0.01 |
| latch: checkpoint queue latch | 23 | 0.00 | 0 | 1 | 0.00 |
| control file sequential read | 2,969 | 0.00 | 0 | 0 | 0.00 |
| log file single write | 40 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 297 | 0.00 | 0 | 0 | 0.00 |
| log buffer space | 17 | 0.00 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 82 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header operation | 73 | 0.00 | 0 | 0 | 0.00 |
| undo segment extension | 4,553 | 99.34 | 0 | 0 | 0.01 |
| PX qref latch | 228 | 77.63 | 0 | 0 | 0.00 |
| latch: cache buffer handles | 34 | 0.00 | 0 | 0 | 0.00 |
| log file sequential read | 40 | 0.00 | 0 | 0 | 0.00 |
| reliable message | 38 | 0.00 | 0 | 0 | 0.00 |
| enq: CU - contention | 2 | 0.00 | 0 | 1 | 0.00 |
| enq: PS - contention | 26 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 2,476 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 237 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 11 | 0.00 | 0 | 0 | 0.00 |
| latch: messages | 15 | 0.00 | 0 | 0 | 0.00 |
| kkdlgon | 1 | 0.00 | 0 | 1 | 0.00 |
| library cache pin | 10 | 0.00 | 0 | 0 | 0.00 |
| library cache lock | 1 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 21 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 7 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 4 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 133,773 | 0.00 | 70,633 | 528 | 0.21 |
| PX Idle Wait | 5,220 | 94.52 | 9,622 | 1843 | 0.01 |
| Streams AQ: waiting for messages in the queue | 998 | 93.19 | 6,976 | 6990 | 0.00 |
| pipe get | 1,263 | 98.57 | 5,251 | 4157 | 0.00 |
| Streams AQ: qmn slave idle wait | 853 | 0.00 | 3,483 | 4084 | 0.00 |
| PL/SQL lock timer | 330 | 96.36 | 2,027 | 6142 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 56 | 37.50 | 1,882 | 33612 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 809 | 35.11 | 1,748 | 2161 | 0.00 |
| PX Deq: Execution Msg | 4,714 | 0.59 | 107 | 23 | 0.01 |
| PX Deq: Execute Reply | 2,546 | 0.00 | 13 | 5 | 0.00 |
| PX Deq: Table Q Normal | 6,899 | 0.00 | 1 | 0 | 0.01 |
| PX Deq Credit: need buffer | 2,142 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Msg Fragment | 1,807 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Parse Reply | 142 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Join ACK | 273 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Table Q Sample | 70 | 0.00 | 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 | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 293,442 | 0.00 | 554 | 2 | 0.46 |
| control file parallel write | 1,628 | 0.00 | 8 | 5 | 0.00 |
| events in waitclass Other | 22,662 | 0.03 | 1 | 0 | 0.04 |
| db file sequential read | 444 | 0.00 | 1 | 2 | 0.00 |
| log file single write | 40 | 0.00 | 0 | 1 | 0.00 |
| log buffer space | 17 | 0.00 | 0 | 1 | 0.00 |
| control file sequential read | 1,282 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 11,726 | 0.00 | 0 | 0 | 0.02 |
| log file sequential read | 40 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 228 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 38 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 2,442 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 11 | 0.00 | 0 | 0 | 0.00 |
| undo segment extension | 379 | 98.42 | 0 | 0 | 0.00 |
| enq: TX - index contention | 3 | 0.00 | 0 | 0 | 0.00 |
| enq: HW - contention | 6 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 3 | 0.00 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 659,196 | 0.84 | 16,197 | 25 | 1.04 |
| Streams AQ: qmn slave idle wait | 853 | 0.00 | 3,483 | 4084 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 56 | 37.50 | 1,882 | 33612 | 0.00 |
| smon timer | 3,515 | 0.00 | 1,760 | 501 | 0.01 |
| Streams AQ: qmn coordinator idle wait | 809 | 35.11 | 1,748 | 2161 | 0.00 |
| pmon timer | 647 | 98.30 | 1,748 | 2702 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 979,662 |
| IDLE_TIME | 1,885,431 |
| IOWAIT_TIME | 94,301 |
| NICE_TIME | 1 |
| SYS_TIME | 81,375 |
| USER_TIME | 889,466 |
| LOAD | 1 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 3,291,548 |
| NUM_CPUS | 16 |
| NUM_CPU_SOCKETS | 2 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| VIS | 10,377.60 | 9,457.90 | 469,023 | 1,493,992,314 |
| SYS$USERS | 1.10 | 0.90 | 108 | 10,644 |
| SYS$BACKGROUND | 0.00 | 0.00 | 12,170 | 2,765,280 |
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 |
207652 | 21860 | 1866628 | 18786 | 0 | 0 | 148823 | 21 |
| SYS$USERS |
400 | 21 | 104 | 8 | 0 | 0 | 5 | 0 |
| SYS$BACKGROUND |
14612 | 97 | 273 | 1 | 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 |
|---|
| 3,466 | 2,947 | 10 | 346.63 | 33.40 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 3,206 | 3,146 | 20 | 160.30 | 30.89 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 1,371 | 1,308 | 49,929 | 0.03 | 13.21 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 1,124 | 1,069 | 100 | 11.24 | 10.83 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,062 | 1,011 | 12 | 88.50 | 10.23 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 617 | 573 | 49,979 | 0.01 | 5.94 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 484 | 439 | 12 | 40.30 | 4.66 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 398 | 378 | 149,575 | 0.00 | 3.84 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 339 | 335 | 49,966 | 0.01 | 3.27 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 244 | 241 | 49,843 | 0.00 | 2.35 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 220 | 215 | 204,745 | 0.00 | 2.12 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 217 | 212 | 2,815,682 | 0.00 | 2.09 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 202 | 202 | 354,906 | 0.00 | 1.94 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 202 | 191 | 1,689,629 | 0.00 | 1.94 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 169 | 160 | 49,916 | 0.00 | 1.63 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 136 | 121 | 1,344,552 | 0.00 | 1.31 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 129 | 124 | 99,529 | 0.00 | 1.24 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 126 | 123 | 3 | 41.84 | 1.21 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 113 | 113 | 495,933 | 0.00 | 1.09 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 111 | 86 | 4 | 27.80 | 1.07 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
| 109 | 97 | 4 | 27.18 | 1.05 | 7ptvbaycjtbg4 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
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 |
|---|
| 3,146 | 3,206 | 20 | 157.32 | 30.89 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,947 | 3,466 | 10 | 294.72 | 33.40 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 1,308 | 1,371 | 49,929 | 0.03 | 13.21 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 1,069 | 1,124 | 100 | 10.69 | 10.83 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,011 | 1,062 | 12 | 84.24 | 10.23 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 573 | 617 | 49,979 | 0.01 | 5.94 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 439 | 484 | 12 | 36.55 | 4.66 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 378 | 398 | 149,575 | 0.00 | 3.84 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 335 | 339 | 49,966 | 0.01 | 3.27 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 241 | 244 | 49,843 | 0.00 | 2.35 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 215 | 220 | 204,745 | 0.00 | 2.12 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 212 | 217 | 2,815,682 | 0.00 | 2.09 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 202 | 202 | 354,906 | 0.00 | 1.94 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 191 | 202 | 1,689,629 | 0.00 | 1.94 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 160 | 169 | 49,916 | 0.00 | 1.63 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 124 | 129 | 99,529 | 0.00 | 1.24 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 123 | 126 | 3 | 40.89 | 1.21 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 121 | 136 | 1,344,552 | 0.00 | 1.31 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 113 | 113 | 495,933 | 0.00 | 1.09 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 97 | 109 | 4 | 24.20 | 1.05 | 7ptvbaycjtbg4 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 86 | 111 | 4 | 21.59 | 1.07 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
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: 1,496,768,121
- Captured SQL account for 35.0% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 614,740,072 | 20 | 30,737,003.60 | 41.07 | 3146.40 | 3205.91 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 285,220,792 | 10 | 28,522,079.20 | 19.06 | 2947.16 | 3466.29 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 277,770,421 | 12 | 23,147,535.08 | 18.56 | 1010.86 | 1061.99 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 121,851,214 | 49,929 | 2,440.49 | 8.14 | 1308.47 | 1370.70 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 105,813,195 | 354,906 | 298.14 | 7.07 | 201.56 | 201.76 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 89,985,520 | 100 | 899,855.20 | 6.01 | 1068.93 | 1124.22 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 84,476,001 | 149,575 | 564.77 | 5.64 | 378.48 | 398.27 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 73,812,995 | 2,815,682 | 26.21 | 4.93 | 212.49 | 216.72 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 70,083,265 | 495,933 | 141.32 | 4.68 | 112.80 | 112.97 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 67,126,732 | 49,966 | 1,343.45 | 4.48 | 334.63 | 339.04 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 60,170,660 | 12 | 5,014,221.67 | 4.02 | 438.58 | 483.62 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 54,840,608 | 1,689,629 | 32.46 | 3.66 | 191.05 | 201.62 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 25,896,528 | 49,979 | 518.15 | 1.73 | 573.01 | 617.00 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 25,152,959 | 99,854 | 251.90 | 1.68 | 55.50 | 55.50 | 0wfry4rz1ygfk |
WSHPSGL_SUB
|
SELECT /*+index (WDD WSH_DELIV... |
| 25,139,420 | 309,850 | 81.13 | 1.68 | 71.70 | 73.04 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 24,643,730 | 1,344,552 | 18.33 | 1.65 | 121.26 | 135.68 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 23,882,495 | 54,895 | 435.06 | 1.60 | 79.07 | 79.56 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 22,077,837 | 149,502 | 147.68 | 1.48 | 53.45 | 53.88 | 6z9c18cxpxfq0 |
WSHPSGL_SUB
|
SELECT NVL(COMMS_NL_TRACKABLE_... |
| 20,428,586 | 4 | 5,107,146.50 | 1.36 | 96.79 | 108.71 | 7ptvbaycjtbg4 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 19,643,682 | 29,989 | 655.03 | 1.31 | 69.66 | 69.78 | 6uwctg1cdb25v |
WSHPSGL_SUB
|
SELECT DG.DELIVERY_LEG_ID LEG_... |
| 18,865,361 | 99,529 | 189.55 | 1.26 | 124.49 | 128.94 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 18,178,942 | 50,000 | 363.58 | 1.21 | 42.55 | 42.60 | fvcbstf9s6a5r |
OEHVIMP
|
begin WF_STANDARD.WAITFORFLOW ... |
| 17,772,947 | 3 | 5,924,315.67 | 1.19 | 122.68 | 125.51 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 481,322
- Captured SQL account for 2.8% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 36,091 | 10 | 3,609.10 | 7.50 | 2947.16 | 3466.29 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 33,415 | 49,929 | 0.67 | 6.94 | 1308.47 | 1370.70 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 26,746 | 20 | 1,337.30 | 5.56 | 3146.40 | 3205.91 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 14,847 | 12 | 1,237.25 | 3.08 | 438.58 | 483.62 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 13,941 | 4 | 3,485.25 | 2.90 | 86.35 | 111.20 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
| 9,589 | 12 | 799.08 | 1.99 | 1010.86 | 1061.99 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 8,085 | 3 | 2,695.00 | 1.68 | 122.68 | 125.51 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 4,986 | 99,529 | 0.05 | 1.04 | 124.49 | 128.94 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 3,758 | 1,689,629 | 0.00 | 0.78 | 191.05 | 201.62 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 3,330 | 100 | 33.30 | 0.69 | 1068.93 | 1124.22 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 45,556,192
- Captured SQL account for 23.4% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,815,682 | 1,527,614 | 0.54 | 0.00 | 0.00 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 1,689,629 | 1,689,539 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 1,344,552 | 1,344,490 | 1.00 | 0.00 | 0.00 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 495,933 | 49,991 | 0.10 | 0.00 | 0.00 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 354,906 | 0 | 0.00 | 0.00 | 0.00 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 309,850 | 309,718 | 1.00 | 0.00 | 0.00 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 204,745 | 204,723 | 1.00 | 0.00 | 0.00 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 199,920 | 199,896 | 1.00 | 0.00 | 0.00 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 199,766 | 199,747 | 1.00 | 0.00 | 0.00 | ghmx8n7wgqvfr |
WSHINTERFACES
|
begin WF_STANDARD.DEFER (:v1, ... |
| 149,980 | 149,971 | 1.00 | 0.00 | 0.00 | 0mdnts20d60yr |
WSHPSGL_SUB
|
declare
v_ret number := 0... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 2,002,204
- Captured SQL account for 92.4% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 199,856 | 199,920 | 9.98 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 199,757 | 199,766 | 9.98 | ghmx8n7wgqvfr |
WSHINTERFACES
|
begin WF_STANDARD.DEFER (:v1, ... |
| 149,462 | 149,980 | 7.46 | 0mdnts20d60yr |
WSHPSGL_SUB
|
declare
v_ret number := 0... |
| 99,850 | 99,463 | 4.99 | 1c0b7sas42w2z |
WSHPSGL_SUB
|
SELECT NVL(ITEM_COST, 0), ... |
| 99,243 | 99,855 | 4.96 | 1v818hwxjxy58 |
WSHINTERFACES
|
select FND_FLEX_VALUES_VL.FLEX... |
| 59,922 | 59,986 | 2.99 | 76sw2a4vnc89j |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 59,916 | 59,976 | 2.99 | dcvv68fju01g4 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.E... |
| 59,906 | 59,998 | 2.99 | 608c0n36kaw62 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 59,892 | 59,991 | 2.99 | bf7uwg5pa3pj6 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 54,711 | 54,895 | 2.73 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 49,988 | 49,995 | 2.50 | bfbyqwbr4vwms |
OEHVIMP
|
begin OE_OEOL_SCH.SCHEDULE_LIN... |
| 49,975 | 49,979 | 2.50 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 49,970 | 49,993 | 2.50 | 7mrs575bj7a41 |
OEHVIMP
|
begin OE_OEOL_SCH.BRANCH_ON_SO... |
| 49,961 | 49,929 | 2.50 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 49,949 | 49,990 | 2.49 | gdnwgx9fcxggr |
OEHVIMP
|
begin OE_SHIPPING_WF.START_SHI... |
| 49,928 | 49,992 | 2.49 | cw171rvngr1w9 |
WSHINTERFACES
|
begin OE_FLEX_COGS_PUB.GET_COS... |
| 49,928 | 50,000 | 2.49 | fvcbstf9s6a5r |
OEHVIMP
|
begin WF_STANDARD.WAITFORFLOW ... |
| 49,862 | 49,843 | 2.49 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 49,718 | 49,622 | 2.48 | 7mz96k4qtxrzr |
WSHPSGL_SUB
|
SELECT BASE.REVISION , BASE.LO... |
| 49,570 | 49,833 | 2.48 | bsuw7pmwrufpy |
INCTCW
|
SELECT
reservation_... |
| 48,892 | 49,986 | 2.44 | g2qs4xk48vcwy |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 48,871 | 49,697 | 2.44 | a40f9h91scg23 |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 44,943 | 44,931 | 2.24 | 2skwhauh2cwky |
|
select o.name, u.name from ob... |
| 44,793 | 44,885 | 2.24 | 7gtztzv329wg0 |
|
select c.name, u.name from co... |
| 39,835 | 39,838 | 1.99 | 4m7m0t6fjcs5x |
|
update seq$ set increment$=:2,... |
| 30,740 | 30,742 | 1.54 | bsa0wjtftg3uw |
|
select file# from file$ where ... |
| 20,746 | 20,747 | 1.04 | 9qgtwh66xg6nz |
|
update seg$ set type#=:4, bloc... |
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 |
|---|
| 1,054,630 | 5,001 | 0.05 | gnr7tdv74ua5d |
ARTERRPW
|
INSERT INTO RA_CUST_TRX_LINE_G... |
Back to SQL Statistics
Back to Top
|
SQL ordered by Version Count
No data exists for this section of the report.
Back to SQL Statistics
Back to Top
Complete List of SQL Text
| SQL Id | SQL Text |
|---|
| 0074pdmwb7fmv | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| 0mdnts20d60yr | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8))
then
v_ret := 1;
end if;
:9 := v_ret;
end;
|
| 0r0gvtarcjwzz | insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25) |
| 0wfry4rz1ygfk | SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ OH.ORDER_TYPE_ID FROM OE_ORDER_HEADERS_ALL OH, WSH_DELIVERY_DETAILS WDD WHERE OH.HEADER_ID = WDD.SOURCE_HEADER_ID AND WDD.RELEASED_STATUS = 'S' AND WDD.SOURCE_CODE = 'OE' AND WDD.MOVE_ORDER_LINE_ID = :B1 |
| 0z318y6g3uagc | declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ; |
| 1c0b7sas42w2z | SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3 |
| 1v818hwxjxy58 | select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND (
((1=1)
AND /* GL_COA_BS_TAG */
(GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y')
)
)) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3 |
| 1wnq9qthbb54q | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END; |
| 2skwhauh2cwky | select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user# |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4y08a52989vfk | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 52zwqr7xyrc2m | SELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 5t39uchjqpyfm | BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END; |
| 608c0n36kaw62 | begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6h228dtb8hp1t |
SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE
TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO
DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT
.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN
VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID |
| 6uwctg1cdb25v | SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1 |
| 6z9c18cxpxfq0 | SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1 |
| 72yyswsqkzkrm | BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END; |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 7gtztzv329wg0 | select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
| 7mrs575bj7a41 | begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end; |
| 7mz96k4qtxrzr |
SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED ,
X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I
D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE
R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC |
| 7ptvbaycjtbg4 | BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END; |
| 8zfgv4ck11dw9 | BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END; |
| 9qgtwh66xg6nz | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a40f9h91scg23 | select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2 |
| assndb4wqnd6r | BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END; |
| b73h3md2wvs09 | SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID) |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| bfbyqwbr4vwms | begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| bsuw7pmwrufpy |
SELECT
reservation_id
, primary_reservation_quantity - NVL(detailed_quantity, 0)
, NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV
FROM mtl_reservations
WHERE demand_source_header_id = :demand_source_header_id
AND demand_source_line_id = :demand_source_line_id
AND demand_source_type_id = :demand_source_type_id
AND supply_source_type_id = :supply_source_type_id
AND (:demand_source_delivery = :l_miss_num
OR :demand_source_delivery IS NULL
AND demand_source_delivery IS NULL
OR :demand_source_delivery = demand_source_delivery)
AND (:organization_id = :l_miss_num
OR :organization_id IS NULL
AND organization_id IS NULL
OR :organization_id = organization_id)
AND (:inventory_item_id = :l_miss_num
OR :inventory_item_id IS NULL
AND inventory_item_id IS NULL
OR :inventory_item_id = inventory_item_id)
AND (:subinventory_code = :l_miss_char
OR :subinventory_code IS NULL
AND subinventory_code IS NULL
OR :subinventory_code = subinventory_code)
AND (:locator_id = :l_miss_num
OR :locator_id IS NULL
AND locator_id IS NULL
OR :locator_id = locator_id)
AND (:lot_number = :l_miss_char
OR :lot_number IS NULL
AND lot_number IS NULL
OR :lot_number = lot_number)
AND (:revision = :l_miss_char
OR :revision
IS NULL
AND revision IS NULL
OR :revision = revision)
AND (:lpn_id = :l_miss_num
OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id)))
AND (:demand_source_name = :l_miss_char
OR :demand_source_name IS NULL
AND demand_source_name IS NULL
OR :demand_source_name = demand_source_name)
AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0
ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE |
| cd9mbmqyf4qhp | UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1 |
| cdjud36xbtuu5 | SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE' |
| cw171rvngr1w9 | begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end; |
| dcvv68fju01g4 | begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| fb13x9qx0ftks | begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end; |
| fvcbstf9s6a5r | begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| g2qs4xk48vcwy | select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6) |
| g8102j8yynbwz | begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| gdnwgx9fcxggr | begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end; |
| ghmx8n7wgqvfr | begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end; |
| gksvm8wmzk8w0 | begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end; |
| gnhmcahkmrnzs | INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 ) |
| gnng1rmpjxzsx | begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
| gnr7tdv74ua5d |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID, ORG_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.
EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, HEADER.ORG_ID FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND ASS.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 ,
DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )
|
Back to SQL Statistics
Back to Top
Instance Activity Statistics
Back to Top
Instance Activity Stats
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 952,735 | 532.00 | 1.50 |
| CPU used when call started | 956,460 | 534.08 | 1.50 |
| CR blocks created | 14,225,369 | 7,943.29 | 22.38 |
| Cached Commit SCN referenced | 2,489,114 | 1,389.89 | 3.92 |
| Commit SCN cached | 422 | 0.24 | 0.00 |
| DB time | 2,538,327 | 1,417.37 | 3.99 |
| DBWR checkpoint buffers written | 1,531,443 | 855.14 | 2.41 |
| DBWR checkpoints | 55 | 0.03 | 0.00 |
| DBWR object drop buffers written | 1,918 | 1.07 | 0.00 |
| DBWR parallel query checkpoint buffers written | 1,596 | 0.89 | 0.00 |
| DBWR revisited being-written buffer | 39 | 0.02 | 0.00 |
| DBWR thread checkpoint buffers written | 1,290,782 | 720.76 | 2.03 |
| DBWR transaction table writes | 228 | 0.13 | 0.00 |
| DBWR undo block writes | 1,003,495 | 560.34 | 1.58 |
| DFO trees parallelized | 23 | 0.01 | 0.00 |
| DML statements parallelized | 0 | 0.00 | 0.00 |
| IMU CR rollbacks | 5,138,137 | 2,869.08 | 8.08 |
| IMU Flushes | 369,444 | 206.29 | 0.58 |
| IMU Redo allocation size | 1,262,344,064 | 704,879.13 | 1,986.21 |
| IMU commits | 298,964 | 166.94 | 0.47 |
| IMU contention | 104,781 | 58.51 | 0.16 |
| IMU ktichg flush | 342 | 0.19 | 0.00 |
| IMU pool not allocated | 18,180 | 10.15 | 0.03 |
| IMU recursive-transaction flush | 263 | 0.15 | 0.00 |
| IMU undo allocation size | 2,011,669,016 | 1,123,293.99 | 3,165.22 |
| IMU- failed to get a private strand | 18,180 | 10.15 | 0.03 |
| PX local messages recv'd | 32,551 | 18.18 | 0.05 |
| PX local messages sent | 32,551 | 18.18 | 0.05 |
| Parallel operations downgraded 25 to 50 pct | 22 | 0.01 | 0.00 |
| Parallel operations downgraded 75 to 99 pct | 0 | 0.00 | 0.00 |
| Parallel operations not downgraded | 1 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 148 | 0.08 | 0.00 |
| SQL*Net roundtrips to/from client | 132,559 | 74.02 | 0.21 |
| active txn count during cleanout | 64,939,110 | 36,261.29 | 102.18 |
| application wait time | 6,231 | 3.48 | 0.01 |
| auto extends on undo tablespace | 73 | 0.04 | 0.00 |
| background checkpoints completed | 19 | 0.01 | 0.00 |
| background checkpoints started | 20 | 0.01 | 0.00 |
| background timeouts | 6,304 | 3.52 | 0.01 |
| branch node splits | 545 | 0.30 | 0.00 |
| buffer is not pinned count | 312,132,557 | 174,291.41 | 491.12 |
| buffer is pinned count | 423,092,260 | 236,250.09 | 665.71 |
| bytes received via SQL*Net from client | 48,187,651 | 26,907.46 | 75.82 |
| bytes sent via SQL*Net to client | 47,623,730 | 26,592.57 | 74.93 |
| calls to get snapshot scn: kcmgss | 55,560,123 | 31,024.17 | 87.42 |
| calls to kcmgas | 17,064,553 | 9,528.66 | 26.85 |
| calls to kcmgcs | 3,132,827 | 1,749.34 | 4.93 |
| change write time | 26,934 | 15.04 | 0.04 |
| cleanout - number of ktugct calls | 18,196,047 | 10,160.47 | 28.63 |
| cleanouts and rollbacks - consistent read gets | 13,155,209 | 7,345.72 | 20.70 |
| cleanouts only - consistent read gets | 61,336 | 34.25 | 0.10 |
| cluster key scan block gets | 196,105 | 109.50 | 0.31 |
| cluster key scans | 92,705 | 51.77 | 0.15 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 49,642 | 27.72 | 0.08 |
| commit batch/immediate requested | 49,642 | 27.72 | 0.08 |
| commit cleanout failures: block lost | 178,692 | 99.78 | 0.28 |
| commit cleanout failures: buffer being written | 489 | 0.27 | 0.00 |
| commit cleanout failures: callback failure | 86,910 | 48.53 | 0.14 |
| commit cleanout failures: cannot pin | 60,565 | 33.82 | 0.10 |
| commit cleanouts | 7,411,719 | 4,138.62 | 11.66 |
| commit cleanouts successfully completed | 7,085,063 | 3,956.22 | 11.15 |
| commit immediate performed | 49,642 | 27.72 | 0.08 |
| commit immediate requested | 49,642 | 27.72 | 0.08 |
| commit txn count during cleanout | 876,097 | 489.20 | 1.38 |
| concurrency wait time | 18,787 | 10.49 | 0.03 |
| consistent changes | 764,974,127 | 427,153.19 | 1,203.63 |
| consistent gets | 1,353,300,307 | 755,668.10 | 2,129.32 |
| consistent gets - examination | 1,011,502,587 | 564,811.99 | 1,591.53 |
| consistent gets direct | 307,281 | 171.58 | 0.48 |
| consistent gets from cache | 1,352,993,026 | 755,496.52 | 2,128.84 |
| cursor authentications | 2,311 | 1.29 | 0.00 |
| data blocks consistent reads - undo records applied | 759,563,413 | 424,131.91 | 1,195.12 |
| db block changes | 125,922,867 | 70,313.95 | 198.13 |
| db block gets | 143,467,814 | 80,110.86 | 225.74 |
| db block gets direct | 375 | 0.21 | 0.00 |
| db block gets from cache | 143,467,439 | 80,110.65 | 225.74 |
| deferred (CURRENT) block cleanout applications | 1,322,335 | 738.38 | 2.08 |
| dirty buffers inspected | 137 | 0.08 | 0.00 |
| doubling up with imu segment | 25 | 0.01 | 0.00 |
| drop segment calls in space pressure | 461 | 0.26 | 0.00 |
| enqueue conversions | 932,450 | 520.67 | 1.47 |
| enqueue releases | 6,650,730 | 3,713.69 | 10.46 |
| enqueue requests | 6,943,472 | 3,877.16 | 10.93 |
| enqueue timeouts | 292,742 | 163.46 | 0.46 |
| enqueue waits | 68,844 | 38.44 | 0.11 |
| exchange deadlocks | 47,391 | 26.46 | 0.07 |
| execute count | 45,556,192 | 25,438.08 | 71.68 |
| failed probes on index block reclamation | 619,266 | 345.79 | 0.97 |
| free buffer inspected | 3,265,115 | 1,823.20 | 5.14 |
| free buffer requested | 17,026,346 | 9,507.33 | 26.79 |
| global undo segment hints helped | 20 | 0.01 | 0.00 |
| global undo segment hints were stale | 8 | 0.00 | 0.00 |
| heap block compress | 26,770,991 | 14,948.63 | 42.12 |
| hot buffers moved to head of LRU | 445,817 | 248.94 | 0.70 |
| immediate (CR) block cleanout applications | 13,216,551 | 7,379.98 | 20.80 |
| immediate (CURRENT) block cleanout applications | 761,383 | 425.15 | 1.20 |
| index crx upgrade (found) | 76,351 | 42.63 | 0.12 |
| index crx upgrade (positioned) | 2,833,813 | 1,582.37 | 4.46 |
| index fast full scans (direct read) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 0 | 0.00 | 0.00 |
| index fast full scans (rowid ranges) | 592 | 0.33 | 0.00 |
| index fetch by key | 98,626,976 | 55,072.23 | 155.18 |
| index scans kdiixs1 | 30,637,368 | 17,107.57 | 48.21 |
| java call heap collected bytes | 1,134,160,648 | 633,302.91 | 1,784.52 |
| java call heap collected count | 14,265,378 | 7,965.63 | 22.45 |
| java call heap gc count | 2,509 | 1.40 | 0.00 |
| java call heap live object count | 543,339 | 303.39 | 0.85 |
| java call heap live object count max | 548,523 | 306.29 | 0.86 |
| java call heap live size | 206,042,712 | 115,052.00 | 324.19 |
| java call heap live size max | 206,926,144 | 115,545.30 | 325.58 |
| java call heap object count | 1,419,522 | 792.65 | 2.23 |
| java call heap object count max | 1,439,390 | 803.74 | 2.26 |
| java call heap total size | 288,358,400 | 161,016.18 | 453.71 |
| java call heap total size max | 288,358,400 | 161,016.18 | 453.71 |
| java call heap used size | 265,688,200 | 148,357.39 | 418.04 |
| java call heap used size max | 267,877,280 | 149,579.75 | 421.49 |
| leaf node 90-10 splits | 8,898 | 4.97 | 0.01 |
| leaf node splits | 129,863 | 72.51 | 0.20 |
| lob reads | 3,052,751 | 1,704.62 | 4.80 |
| lob writes | 1,310,110 | 731.55 | 2.06 |
| lob writes unaligned | 1,310,110 | 731.55 | 2.06 |
| local undo segment hints helped | 149 | 0.08 | 0.00 |
| local undo segment hints were stale | 139 | 0.08 | 0.00 |
| logons cumulative | 729 | 0.41 | 0.00 |
| messages received | 854,747 | 477.28 | 1.34 |
| messages sent | 854,747 | 477.28 | 1.34 |
| no buffer to keep pinned count | 8 | 0.00 | 0.00 |
| no work - consistent read gets | 310,931,948 | 173,621.00 | 489.23 |
| opened cursors cumulative | 825,906 | 461.18 | 1.30 |
| parse count (failures) | 3 | 0.00 | 0.00 |
| parse count (hard) | 3,360 | 1.88 | 0.01 |
| parse count (total) | 2,002,204 | 1,118.01 | 3.15 |
| parse time cpu | 2,226 | 1.24 | 0.00 |
| parse time elapsed | 5,693 | 3.18 | 0.01 |
| physical read IO requests | 189,770 | 105.97 | 0.30 |
| physical read bytes | 3,942,989,824 | 2,201,722.42 | 6,204.02 |
| physical read total IO requests | 193,037 | 107.79 | 0.30 |
| physical read total bytes | 3,993,767,936 | 2,230,076.36 | 6,283.92 |
| physical read total multi block requests | 46,007 | 25.69 | 0.07 |
| physical reads | 481,322 | 268.76 | 0.76 |
| physical reads cache | 162,203 | 90.57 | 0.26 |
| physical reads cache prefetch | 42,389 | 23.67 | 0.07 |
| physical reads direct | 319,119 | 178.19 | 0.50 |
| physical reads direct (lob) | 48 | 0.03 | 0.00 |
| physical reads direct temporary tablespace | 105 | 0.06 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 224,857 | 125.56 | 0.35 |
| physical write bytes | 12,611,928,064 | 7,042,362.78 | 19,843.99 |
| physical write total IO requests | 758,487 | 423.53 | 1.19 |
| physical write total bytes | 33,990,313,984 | 18,979,819.81 | 53,481.39 |
| physical write total multi block requests | 665,876 | 371.82 | 1.05 |
| physical writes | 1,539,542 | 859.66 | 2.42 |
| physical writes direct | 3,012 | 1.68 | 0.00 |
| physical writes direct (lob) | 36 | 0.02 | 0.00 |
| physical writes direct temporary tablespace | 500 | 0.28 | 0.00 |
| physical writes from cache | 1,536,530 | 857.98 | 2.42 |
| physical writes non checkpoint | 1,397,753 | 780.49 | 2.20 |
| pinned buffers inspected | 4,321 | 2.41 | 0.01 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 8 | 0.00 | 0.00 |
| process last non-idle time | 1,844 | 1.03 | 0.00 |
| queries parallelized | 23 | 0.01 | 0.00 |
| recursive aborts on index block reclamation | 8 | 0.00 | 0.00 |
| recursive calls | 83,236,386 | 46,478.29 | 130.97 |
| recursive cpu usage | 781,494 | 436.38 | 1.23 |
| redo blocks written | 41,702,556 | 23,286.25 | 65.62 |
| redo buffer allocation retries | 182 | 0.10 | 0.00 |
| redo entries | 68,381,636 | 38,183.56 | 107.59 |
| redo log space requests | 589 | 0.33 | 0.00 |
| redo log space wait time | 5,192 | 2.90 | 0.01 |
| redo ordering marks | 813,302 | 454.14 | 1.28 |
| redo size | 20,514,149,876 | 11,454,877.07 | 32,277.59 |
| redo subscn max counts | 1,458,600 | 814.47 | 2.30 |
| redo synch time | 47,931 | 26.76 | 0.08 |
| redo synch writes | 130,416 | 72.82 | 0.21 |
| redo wastage | 135,532,748 | 75,680.01 | 213.25 |
| redo write time | 57,268 | 31.98 | 0.09 |
| redo writer latching time | 52 | 0.03 | 0.00 |
| redo writes | 293,442 | 163.85 | 0.46 |
| rollback changes - undo records applied | 102,636 | 57.31 | 0.16 |
| rollbacks only - consistent read gets | 1,143,199 | 638.35 | 1.80 |
| rows fetched via callback | 34,736,257 | 19,396.35 | 54.66 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 1,868,903 | 1,043.58 | 2.94 |
| session logical reads | 1,496,768,121 | 835,778.96 | 2,355.06 |
| session pga memory | 391,418,800 | 218,563.98 | 615.87 |
| session pga memory max | 4,569,666,480 | 2,551,651.82 | 7,190.05 |
| session uga memory | 34,626,856 | 19,335.26 | 54.48 |
| session uga memory max | 8,091,564,832 | 4,518,241.36 | 12,731.51 |
| shared hash latch upgrades - no wait | 23,628,601 | 13,193.95 | 37.18 |
| shared hash latch upgrades - wait | 169,206 | 94.48 | 0.27 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 3,906,806 | 2,181.52 | 6.15 |
| sorts (rows) | 60,002,648 | 33,504.82 | 94.41 |
| space was found by tune down | 450 | 0.25 | 0.00 |
| space was not found by tune down | 7 | 0.00 | 0.00 |
| sql area evicted | 147 | 0.08 | 0.00 |
| sql area purged | 66 | 0.04 | 0.00 |
| steps of tune down ret. in space pressure | 471 | 0.26 | 0.00 |
| summed dirty queue length | 3,993 | 2.23 | 0.01 |
| switch current to new buffer | 1,189,178 | 664.02 | 1.87 |
| table fetch by rowid | 304,852,794 | 170,226.47 | 479.66 |
| table fetch continued row | 17,030,705 | 9,509.76 | 26.80 |
| table scan blocks gotten | 8,449,556 | 4,718.14 | 13.29 |
| table scan rows gotten | 374,234,578 | 208,968.50 | 588.83 |
| table scans (cache partitions) | 0 | 0.00 | 0.00 |
| table scans (direct read) | 1,133 | 0.63 | 0.00 |
| table scans (long tables) | 1,658 | 0.93 | 0.00 |
| table scans (rowid ranges) | 1,658 | 0.93 | 0.00 |
| table scans (short tables) | 1,383,188 | 772.36 | 2.18 |
| total number of times SMON posted | 3,515 | 1.96 | 0.01 |
| transaction rollbacks | 49,642 | 27.72 | 0.08 |
| transaction tables consistent read rollbacks | 74 | 0.04 | 0.00 |
| transaction tables consistent reads - undo records applied | 43,442 | 24.26 | 0.07 |
| tune down retentions in space pressure | 457 | 0.26 | 0.00 |
| undo change vector size | 7,443,832,024 | 4,156,554.44 | 11,712.35 |
| user I/O wait time | 21,979 | 12.27 | 0.03 |
| user calls | 161,169 | 90.00 | 0.25 |
| user commits | 634,967 | 354.56 | 1.00 |
| user rollbacks | 587 | 0.33 | 0.00 |
| workarea executions - onepass | 4 | 0.00 | 0.00 |
| workarea executions - optimal | 1,575,480 | 879.73 | 2.48 |
| write clones created in background | 48 | 0.03 | 0.00 |
| write clones created in foreground | 2,397 | 1.34 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|
| session cursor cache count | 11,824 | 34,384 |
| opened cursors current | 2,713 | 2,657 |
| logons current | 87 | 91 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Thread Activity
- Statistics identified by '(derived)' come from sources other than SYSSTAT
| Statistic | Total | per Hour |
|---|
| log switches (derived) | 20 | 40.20 |
Back to Instance Activity Statistics
Back to Top
IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_TS_TX_DATA |
100,047 | 56 | 0.62 | 3.79 | 26,826 | 15 | 252,097 | 0.11 |
| APPS_UNDOTS1 |
16 | 0 | 1.88 | 1.00 | 121,250 | 68 | 667,449 | 0.03 |
| APPS_TS_TX_IDX |
54,707 | 31 | 1.20 | 1.01 | 49,906 | 28 | 230,593 | 0.22 |
| APPS_TS_INTERFACE |
11,715 | 7 | 1.33 | 2.01 | 6,083 | 3 | 105,833 | 0.02 |
| SYSTEM |
15,340 | 9 | 2.59 | 1.00 | 955 | 1 | 7,760 | 0.09 |
| APPS_TS_QUEUES |
3,056 | 2 | 1.90 | 1.00 | 12,275 | 7 | 131,060 | 0.24 |
| APPS_TS_SUMMARY |
920 | 1 | 0.79 | 1.00 | 6,312 | 4 | 44,634 | 0.07 |
| APPS_TS_SEED |
1,316 | 1 | 2.34 | 1.06 | 61 | 0 | 1,032 | 2.37 |
| SYSAUX |
177 | 0 | 1.86 | 1.00 | 445 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
236 | 0 | 0.04 | 1.00 | 70 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE |
88 | 0 | 2.73 | 1.00 | 108 | 0 | 3 | 6.67 |
| TEMP |
54 | 0 | 0.37 | 7.65 | 93 | 0 | 0 | 0.00 |
| CTXSYS |
106 | 0 | 0.00 | 1.00 | 18 | 0 | 0 | 0.00 |
| CWMLITE |
99 | 0 | 0.00 | 1.00 | 18 | 0 | 0 | 0.00 |
| DCM |
92 | 0 | 0.11 | 1.00 | 18 | 0 | 0 | 0.00 |
| GEOR_TBS |
92 | 0 | 0.00 | 1.00 | 18 | 0 | 0 | 0.00 |
| APPS_CALCLIP |
40 | 0 | 0.00 | 1.00 | 40 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
50 | 0 | 1.40 | 1.00 | 22 | 0 | 183 | 0.60 |
| B2B_DT |
54 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_IDX |
54 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_LOB |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_RT |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| BAM |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM_DATA |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_CT_STORE |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_DEFAULT |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS |
48 | 0 | 0.21 | 1.00 | 10 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DISCO_PTM5_META |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| HTMLDB |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| IAS_META |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| MTR |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| NOETIX |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OCATS |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OPMOR |
44 | 0 | 0.23 | 1.00 | 9 | 0 | 0 | 0.00 |
| ORABPEL |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OWAPUB |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_DOC |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_IDX |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_LOG |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| RE |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| SYNCSERVER |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| UDDISYS_TS |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| WCRSYS_TS |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| XDB |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_OMO |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_DISCO |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
File IO Stats
- ordered by Tablespace, File
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| APPS_CALCLIP | /ds2/oracle/VIS/db/apps_st/data/apps_calclip.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds2/oracle/VIS/db/apps_st/data/apps_calclip1.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds2/oracle/VIS/db/apps_st/data/apps_calclip2.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds2/oracle/VIS/db/apps_st/data/apps_calclip3.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_OMO | /ds2/oracle/VIS/db/apps_st/data/omo1.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /ds2/oracle/VIS/db/apps_st/data/archive1.dbf |
88 | 0 | 2.73 | 1.00 | 108 | 0 | 3 | 6.67 |
| APPS_TS_DISCO | /ds2/oracle/VIS/db/apps_st/data/disco1.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP | /ds2/oracle/VIS/db/apps_st/data/disco_drake1.dbf |
10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface.db |
554 | 0 | 1.62 | 2.15 | 313 | 0 | 5,298 | 0.03 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface1.d |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface10. |
562 | 0 | 1.44 | 2.12 | 253 | 0 | 5,369 | 0.03 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface11. |
553 | 0 | 0.98 | 2.10 | 274 | 0 | 5,408 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface12. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface13. |
557 | 0 | 1.53 | 2.07 | 300 | 0 | 7,073 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface14. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface15. |
559 | 0 | 1.29 | 2.02 | 280 | 0 | 6,141 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface16. |
540 | 0 | 1.52 | 2.05 | 270 | 0 | 5,632 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface17. |
537 | 0 | 1.25 | 2.07 | 245 | 0 | 5,574 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface18. |
528 | 0 | 0.83 | 2.09 | 235 | 0 | 5,697 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface19. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface2.d |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface20. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface21. |
504 | 0 | 1.37 | 2.16 | 260 | 0 | 4,661 | 0.04 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface22. |
164 | 0 | 1.59 | 1.82 | 81 | 0 | 203 | 0.49 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface23. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface24. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface25. |
20 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface26. |
45 | 0 | 1.56 | 3.69 | 17 | 0 | 6 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface27. |
135 | 0 | 3.56 | 2.36 | 171 | 0 | 705 | 0.14 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface28. |
609 | 0 | 2.20 | 2.06 | 369 | 0 | 5,055 | 0.06 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface29. |
613 | 0 | 1.37 | 2.01 | 374 | 0 | 4,435 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface3.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface30. |
640 | 0 | 1.03 | 1.93 | 324 | 0 | 5,992 | 0.04 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface31. |
601 | 0 | 1.45 | 1.95 | 306 | 0 | 7,001 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface32. |
617 | 0 | 1.04 | 1.97 | 302 | 0 | 6,006 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface33. |
627 | 0 | 1.23 | 1.95 | 345 | 0 | 5,525 | 0.02 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface34. |
614 | 0 | 1.50 | 1.96 | 305 | 0 | 4,851 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface35. |
600 | 0 | 1.17 | 2.02 | 298 | 0 | 5,272 | 0.02 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface36. |
608 | 0 | 1.05 | 2.01 | 308 | 0 | 5,388 | 0.01 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface4.d |
600 | 0 | 1.52 | 2.02 | 303 | 0 | 4,541 | 0.04 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface5.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface6.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface7.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface8.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface9.d |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media1.dbf |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media2.dbf |
28 | 0 | 0.36 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media3.dbf |
28 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media4.dbf |
38 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media5.dbf |
38 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media6.dbf |
38 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds2/oracle/VIS/db/apps_st/data/media7.dbf |
38 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /ds2/oracle/VIS/db/apps_st/data/nologging1.dbf |
50 | 0 | 1.40 | 1.00 | 22 | 0 | 183 | 0.60 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues1.dbf |
458 | 0 | 1.94 | 1.00 | 1,911 | 1 | 19,994 | 0.17 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues2.dbf |
432 | 0 | 1.60 | 1.00 | 949 | 1 | 14,402 | 0.28 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues3.dbf |
499 | 0 | 1.52 | 1.00 | 1,861 | 1 | 21,321 | 0.26 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues4.dbf |
451 | 0 | 1.75 | 1.00 | 1,889 | 1 | 20,328 | 0.16 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues5.dbf |
403 | 0 | 2.18 | 1.00 | 1,862 | 1 | 17,937 | 0.57 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues6.dbf |
355 | 0 | 2.45 | 1.00 | 1,860 | 1 | 17,010 | 0.13 |
| APPS_TS_QUEUES | /ds2/oracle/VIS/db/apps_st/data/queues7.dbf |
458 | 0 | 2.05 | 1.00 | 1,943 | 1 | 20,068 | 0.16 |
| APPS_TS_SEED | /ds2/oracle/VIS/db/apps_st/data/reference1.dbf |
449 | 0 | 2.98 | 1.06 | 18 | 0 | 297 | 2.96 |
| APPS_TS_SEED | /ds2/oracle/VIS/db/apps_st/data/reference2.dbf |
212 | 0 | 1.70 | 1.06 | 10 | 0 | 176 | 2.73 |
| APPS_TS_SEED | /ds2/oracle/VIS/db/apps_st/data/reference3.dbf |
220 | 0 | 2.05 | 1.06 | 10 | 0 | 183 | 2.08 |
| APPS_TS_SEED | /ds2/oracle/VIS/db/apps_st/data/reference4.dbf |
225 | 0 | 2.13 | 1.06 | 11 | 0 | 197 | 1.88 |
| APPS_TS_SEED | /ds2/oracle/VIS/db/apps_st/data/reference5.dbf |
210 | 0 | 2.14 | 1.06 | 12 | 0 | 179 | 1.90 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary1.dbf |
64 | 0 | 0.78 | 1.00 | 595 | 0 | 3,689 | 0.05 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary10.dbf |
55 | 0 | 0.73 | 1.00 | 634 | 0 | 3,731 | 0.08 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary11.dbf |
70 | 0 | 1.71 | 1.00 | 608 | 0 | 3,656 | 0.07 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary12.dbf |
79 | 0 | 0.51 | 1.00 | 594 | 0 | 4,277 | 0.08 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary13.dbf |
77 | 0 | 0.52 | 1.00 | 644 | 0 | 5,592 | 0.05 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary2.dbf |
87 | 0 | 1.03 | 1.00 | 607 | 0 | 5,440 | 0.08 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary3.dbf |
69 | 0 | 0.58 | 1.00 | 642 | 0 | 3,734 | 0.08 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary4.dbf |
66 | 0 | 1.21 | 1.00 | 57 | 0 | 2,471 | 0.06 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary5.dbf |
49 | 0 | 0.41 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary6.dbf |
61 | 0 | 0.49 | 1.00 | 459 | 0 | 2,535 | 0.05 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary7.dbf |
74 | 0 | 1.22 | 1.00 | 637 | 0 | 3,842 | 0.10 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary8.dbf |
81 | 0 | 0.37 | 1.00 | 218 | 0 | 2,266 | 0.09 |
| APPS_TS_SUMMARY | /ds2/oracle/VIS/db/apps_st/data/summary9.dbf |
88 | 0 | 0.68 | 1.00 | 607 | 0 | 3,401 | 0.04 |
| APPS_TS_TOOLS | /ds2/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf |
48 | 0 | 0.21 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data1.dbf |
49 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data10.dbf |
183 | 0 | 0.77 | 3.34 | 29 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data11.dbf |
2,175 | 1 | 0.67 | 3.82 | 613 | 0 | 9,351 | 0.19 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data12.dbf |
2,174 | 1 | 0.45 | 3.82 | 591 | 0 | 6,895 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data13.dbf |
2,197 | 1 | 0.63 | 3.80 | 588 | 0 | 6,002 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data14.dbf |
48 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data15.dbf |
211 | 0 | 1.04 | 3.10 | 58 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data16.dbf |
216 | 0 | 0.51 | 3.05 | 61 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data17.dbf |
212 | 0 | 1.27 | 3.09 | 42 | 0 | 6 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data18.dbf |
192 | 0 | 1.20 | 3.23 | 44 | 0 | 8 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data19.dbf |
1,126 | 1 | 0.21 | 4.31 | 67 | 0 | 88 | 0.68 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data2.dbf |
2,163 | 1 | 0.40 | 3.83 | 651 | 0 | 5,754 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data20.dbf |
58 | 0 | 0.17 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data21.dbf |
2,171 | 1 | 0.54 | 3.79 | 620 | 0 | 6,382 | 0.11 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data22.dbf |
1,296 | 1 | 0.66 | 4.29 | 89 | 0 | 170 | 1.41 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data23.dbf |
58 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data24.dbf |
218 | 0 | 0.64 | 3.03 | 80 | 0 | 1,001 | 0.01 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data25.dbf |
58 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data26.dbf |
58 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data27.dbf |
226 | 0 | 0.84 | 2.96 | 68 | 0 | 7 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data28.dbf |
223 | 0 | 2.47 | 1.69 | 56 | 0 | 2,083 | 0.18 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data29.dbf |
167 | 0 | 2.51 | 1.37 | 56 | 0 | 541 | 0.33 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data3.dbf |
58 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data30.dbf |
77 | 0 | 0.39 | 1.00 | 18 | 0 | 26 | 1.54 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data31.dbf |
80 | 0 | 1.50 | 1.04 | 26 | 0 | 283 | 0.21 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data32.dbf |
1,383 | 1 | 1.13 | 4.11 | 120 | 0 | 1,315 | 0.27 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data33.dbf |
219 | 0 | 1.60 | 3.00 | 83 | 0 | 70 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data34.dbf |
216 | 0 | 1.44 | 3.05 | 74 | 0 | 19 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data35.dbf |
216 | 0 | 0.93 | 3.00 | 73 | 0 | 4 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data36.dbf |
224 | 0 | 0.80 | 2.98 | 72 | 0 | 26 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data37.dbf |
251 | 0 | 0.96 | 2.78 | 85 | 0 | 21 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data38.dbf |
252 | 0 | 0.60 | 2.74 | 76 | 0 | 11 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data39.dbf |
1,340 | 1 | 0.81 | 4.23 | 102 | 0 | 179 | 1.23 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data4.dbf |
100 | 0 | 0.10 | 2.43 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data40.dbf |
232 | 0 | 0.65 | 2.88 | 45 | 0 | 20 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data41.dbf |
256 | 0 | 0.27 | 3.23 | 58 | 0 | 113 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data42.dbf |
249 | 0 | 0.84 | 3.30 | 52 | 0 | 23 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data43.dbf |
2,320 | 1 | 0.66 | 3.78 | 666 | 0 | 6,637 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data44.dbf |
2,345 | 1 | 0.48 | 3.75 | 635 | 0 | 7,136 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data45.dbf |
2,326 | 1 | 0.78 | 3.77 | 610 | 0 | 5,704 | 0.13 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data46.dbf |
2,327 | 1 | 0.51 | 3.75 | 632 | 0 | 5,336 | 0.09 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data47.dbf |
2,332 | 1 | 0.41 | 3.73 | 648 | 0 | 6,020 | 0.25 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data48.dbf |
2,321 | 1 | 0.73 | 3.77 | 631 | 0 | 6,644 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data49.dbf |
2,316 | 1 | 0.86 | 3.78 | 599 | 0 | 6,627 | 0.09 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data5.dbf |
59 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data50.dbf |
2,265 | 1 | 0.46 | 3.81 | 571 | 0 | 7,070 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data51.dbf |
2,297 | 1 | 0.71 | 3.77 | 643 | 0 | 5,799 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data52.dbf |
1,036 | 1 | 0.61 | 4.70 | 58 | 0 | 18 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data53.dbf |
2,281 | 1 | 0.68 | 3.80 | 661 | 0 | 5,923 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data54.dbf |
2,323 | 1 | 0.56 | 3.74 | 682 | 0 | 6,578 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data55.dbf |
2,281 | 1 | 0.63 | 3.78 | 662 | 0 | 6,177 | 0.37 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data56.dbf |
2,265 | 1 | 0.53 | 3.80 | 650 | 0 | 5,921 | 0.10 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data57.dbf |
2,307 | 1 | 0.67 | 3.76 | 621 | 0 | 6,072 | 0.24 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data58.dbf |
2,247 | 1 | 0.74 | 3.77 | 719 | 0 | 6,553 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data59.dbf |
2,207 | 1 | 0.58 | 3.80 | 675 | 0 | 6,317 | 0.09 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data6.dbf |
59 | 0 | 0.17 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data60.dbf |
2,189 | 1 | 0.56 | 3.83 | 702 | 0 | 6,813 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data61.dbf |
2,206 | 1 | 0.55 | 3.82 | 749 | 0 | 6,353 | 0.10 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data62.dbf |
2,211 | 1 | 0.49 | 3.82 | 668 | 0 | 5,799 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data63.dbf |
2,172 | 1 | 0.70 | 3.84 | 643 | 0 | 5,062 | 0.15 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data64.dbf |
2,136 | 1 | 0.64 | 3.90 | 627 | 0 | 5,629 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data65.dbf |
2,166 | 1 | 0.45 | 3.87 | 633 | 0 | 5,323 | 0.26 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data66.dbf |
2,145 | 1 | 0.60 | 3.91 | 591 | 0 | 5,796 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data67.dbf |
2,151 | 1 | 0.44 | 3.86 | 578 | 0 | 5,595 | 0.09 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data68.dbf |
2,178 | 1 | 0.56 | 3.84 | 615 | 0 | 5,920 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data69.dbf |
2,187 | 1 | 0.50 | 3.84 | 598 | 0 | 5,863 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data7.dbf |
224 | 0 | 0.98 | 2.92 | 64 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data70.dbf |
2,151 | 1 | 0.43 | 3.89 | 567 | 0 | 5,129 | 0.12 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data71.dbf |
2,128 | 1 | 0.74 | 3.91 | 571 | 0 | 6,057 | 0.07 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data72.dbf |
2,172 | 1 | 0.55 | 3.84 | 595 | 0 | 5,596 | 0.12 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data73.dbf |
2,150 | 1 | 0.80 | 3.88 | 620 | 0 | 6,011 | 0.08 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data74.dbf |
2,130 | 1 | 0.60 | 3.91 | 589 | 0 | 6,270 | 0.11 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data75.dbf |
2,111 | 1 | 0.71 | 3.91 | 560 | 0 | 5,887 | 0.06 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data76.dbf |
2,164 | 1 | 0.69 | 3.84 | 607 | 0 | 5,739 | 0.10 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data77.dbf |
2,211 | 1 | 0.63 | 3.78 | 582 | 0 | 6,583 | 0.13 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data78.dbf |
2,203 | 1 | 0.68 | 3.80 | 592 | 0 | 5,734 | 0.13 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data8.dbf |
58 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds2/oracle/VIS/db/apps_st/data/tx_data9.dbf |
58 | 0 | 0.17 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx1.dbf |
1,045 | 1 | 1.43 | 1.01 | 1,000 | 1 | 3,534 | 0.27 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx10.dbf |
1,054 | 1 | 1.26 | 1.01 | 1,036 | 1 | 3,490 | 0.26 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx11.dbf |
1,011 | 1 | 1.21 | 1.01 | 960 | 1 | 3,621 | 0.31 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx12.dbf |
996 | 1 | 1.06 | 1.01 | 904 | 1 | 3,473 | 0.29 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx13.dbf |
994 | 1 | 1.01 | 1.01 | 888 | 0 | 3,462 | 0.34 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx14.dbf |
976 | 1 | 0.74 | 1.00 | 862 | 0 | 3,440 | 0.80 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx15.dbf |
940 | 1 | 1.09 | 1.00 | 823 | 0 | 3,655 | 0.37 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx16.dbf |
950 | 1 | 0.82 | 1.00 | 803 | 0 | 3,474 | 0.50 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx17.dbf |
866 | 0 | 0.83 | 1.01 | 823 | 0 | 2,952 | 0.19 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx18.dbf |
862 | 0 | 0.93 | 1.00 | 836 | 0 | 2,622 | 0.37 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx19.dbf |
898 | 1 | 0.52 | 1.00 | 851 | 0 | 3,261 | 0.33 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx2.dbf |
1,148 | 1 | 1.26 | 1.01 | 880 | 0 | 3,043 | 0.23 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx20.dbf |
970 | 1 | 1.13 | 1.01 | 927 | 1 | 2,653 | 0.32 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx21.dbf |
1,023 | 1 | 0.83 | 1.01 | 875 | 0 | 3,613 | 0.29 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx22.dbf |
989 | 1 | 0.76 | 1.01 | 926 | 1 | 3,463 | 0.35 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx23.dbf |
1,099 | 1 | 2.87 | 1.00 | 538 | 0 | 4,106 | 0.24 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx24.dbf |
919 | 1 | 1.03 | 1.00 | 883 | 0 | 5,769 | 0.12 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx25.dbf |
851 | 0 | 2.44 | 1.01 | 583 | 0 | 4,121 | 0.22 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx26.dbf |
1,278 | 1 | 1.08 | 1.02 | 1,210 | 1 | 5,802 | 0.08 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx27.dbf |
1,256 | 1 | 1.58 | 1.01 | 1,059 | 1 | 4,678 | 0.30 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx28.dbf |
294 | 0 | 2.48 | 1.04 | 122 | 0 | 2,699 | 0.03 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx29.dbf |
1,272 | 1 | 1.23 | 1.01 | 1,093 | 1 | 6,316 | 0.14 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx3.dbf |
1,285 | 1 | 1.07 | 1.02 | 1,098 | 1 | 3,902 | 0.24 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx30.dbf |
1,173 | 1 | 1.32 | 1.02 | 1,073 | 1 | 4,141 | 0.19 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx31.dbf |
1,564 | 1 | 1.65 | 1.01 | 1,494 | 1 | 6,559 | 0.17 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx32.dbf |
1,350 | 1 | 1.39 | 1.02 | 1,212 | 1 | 6,247 | 0.63 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx33.dbf |
1,462 | 1 | 1.61 | 1.01 | 1,338 | 1 | 3,652 | 0.29 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx34.dbf |
1,277 | 1 | 1.53 | 1.01 | 1,279 | 1 | 8,022 | 0.12 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx35.dbf |
1,423 | 1 | 1.19 | 1.02 | 1,308 | 1 | 39,761 | 0.05 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx36.dbf |
1,356 | 1 | 1.01 | 1.01 | 1,271 | 1 | 4,530 | 0.19 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx37.dbf |
1,324 | 1 | 1.16 | 1.02 | 1,277 | 1 | 3,424 | 0.15 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx38.dbf |
1,324 | 1 | 1.10 | 1.02 | 1,244 | 1 | 5,274 | 0.12 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx39.dbf |
1,339 | 1 | 1.02 | 1.01 | 1,243 | 1 | 3,520 | 0.35 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx4.dbf |
1,349 | 1 | 1.24 | 1.01 | 1,117 | 1 | 3,488 | 0.32 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx40.dbf |
1,355 | 1 | 1.20 | 1.01 | 1,281 | 1 | 3,651 | 0.21 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx41.dbf |
1,322 | 1 | 1.04 | 1.02 | 1,217 | 1 | 3,417 | 0.32 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx42.dbf |
1,241 | 1 | 0.89 | 1.01 | 1,179 | 1 | 3,106 | 0.27 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx43.dbf |
1,160 | 1 | 1.22 | 1.01 | 1,161 | 1 | 3,997 | 0.20 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx44.dbf |
1,142 | 1 | 1.08 | 1.01 | 1,140 | 1 | 3,372 | 0.30 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx45.dbf |
1,139 | 1 | 1.47 | 1.02 | 1,161 | 1 | 3,606 | 0.20 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx46.dbf |
1,180 | 1 | 1.42 | 1.01 | 1,132 | 1 | 3,645 | 0.27 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx47.dbf |
1,216 | 1 | 1.03 | 1.01 | 1,157 | 1 | 3,955 | 0.20 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx48.dbf |
1,121 | 1 | 1.04 | 1.01 | 1,143 | 1 | 3,978 | 0.10 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx49.dbf |
1,199 | 1 | 1.31 | 1.01 | 1,088 | 1 | 4,139 | 0.23 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx5.dbf |
864 | 0 | 0.87 | 1.00 | 857 | 0 | 3,786 | 0.28 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx6.dbf |
1,057 | 1 | 0.98 | 1.01 | 1,002 | 1 | 3,631 | 0.26 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx7.dbf |
1,100 | 1 | 1.18 | 1.01 | 1,020 | 1 | 3,312 | 0.26 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx8.dbf |
829 | 0 | 0.68 | 1.01 | 795 | 0 | 3,508 | 0.13 |
| APPS_TS_TX_IDX | /ds2/oracle/VIS/db/apps_st/data/tx_idx9.dbf |
865 | 0 | 0.72 | 1.01 | 737 | 0 | 3,723 | 0.37 |
| APPS_UNDOTS1 | /ds2/oracle/VIS/db/apps_st/data/undo.dbf |
16 | 0 | 1.88 | 1.00 | 121,250 | 68 | 667,449 | 0.03 |
| B2B_DT | /ds2/oracle/VIS/db/apps_st/data/b2b_dt.dbf |
54 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_IDX | /ds2/oracle/VIS/db/apps_st/data/b2b_idx.dbf |
54 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_LOB | /ds2/oracle/VIS/db/apps_st/data/b2b_lob.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| B2B_RT | /ds2/oracle/VIS/db/apps_st/data/b2b_rt.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| BAM | /ds2/oracle/VIS/db/apps_st/data/bam.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| CTXSYS | /ds2/oracle/VIS/db/apps_st/data/ctx1.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| CTXSYS | /ds2/oracle/VIS/db/apps_st/data/ctx2.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| CWMLITE | /ds2/oracle/VIS/db/apps_st/data/cwmlite01.dbf |
53 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| CWMLITE | /ds2/oracle/VIS/db/apps_st/data/cwmlite02.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DCM | /ds2/oracle/VIS/db/apps_st/data/dcm.dbf |
46 | 0 | 0.22 | 1.00 | 9 | 0 | 0 | 0.00 |
| DCM | /ds2/oracle/VIS/db/apps_st/data/dcm1.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE | /ds2/oracle/VIS/db/apps_st/data/discopltc1.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DISCO_PTM5_META | /ds2/oracle/VIS/db/apps_st/data/discopltm1.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB | /ds2/oracle/VIS/db/apps_st/data/oss_sys01.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds2/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds2/oracle/VIS/db/apps_st/data/geor_tbs02.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| HTMLDB | /ds2/oracle/VIS/db/apps_st/data/htmldb.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| IAS_META | /ds2/oracle/VIS/db/apps_st/data/ias_meta01.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| MTR | /ds2/oracle/VIS/db/apps_st/data/opmtr01.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| NOETIX | /ds2/oracle/VIS/db/apps_st/data/noetix.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA | /ds2/oracle/VIS/db/apps_st/data/non_apps_data1.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OCATS | /ds2/oracle/VIS/db/apps_st/data/oca.dbf |
46 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| ODM_DATA | /ds2/oracle/VIS/db/apps_st/data/odm.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE | /ds2/oracle/VIS/db/apps_st/data/attrs1_oid.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE | /ds2/oracle/VIS/db/apps_st/data/battrs1_oid.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_CT_STORE | /ds2/oracle/VIS/db/apps_st/data/gcats1_oid.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_DEFAULT | /ds2/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE | /ds2/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf |
50 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OPMOR | /ds2/oracle/VIS/db/apps_st/data/opmor01.dbf |
44 | 0 | 0.23 | 1.00 | 9 | 0 | 0 | 0.00 |
| ORABPEL | /ds2/oracle/VIS/db/apps_st/data/orabpel.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| OWAPUB | /ds2/oracle/VIS/db/apps_st/data/owa1.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL | /ds2/oracle/VIS/db/apps_st/data/portal.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_DOC | /ds2/oracle/VIS/db/apps_st/data/ptldoc.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_IDX | /ds2/oracle/VIS/db/apps_st/data/ptlidx.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| PORTAL_LOG | /ds2/oracle/VIS/db/apps_st/data/ptllog.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| RE | /ds2/oracle/VIS/db/apps_st/data/opre01.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| SYNCSERVER | /ds2/oracle/VIS/db/apps_st/data/mobile01.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| SYSAUX | /ds2/oracle/VIS/db/apps_st/data/sysaux01.dbf |
177 | 0 | 1.86 | 1.00 | 445 | 0 | 0 | 0.00 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys1.dbf |
1,421 | 1 | 2.39 | 1.00 | 199 | 0 | 274 | 0.07 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys10.dbf |
1,583 | 1 | 2.78 | 1.00 | 135 | 0 | 100 | 0.10 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys2.dbf |
1,226 | 1 | 2.85 | 1.00 | 28 | 0 | 124 | 0.48 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys3.dbf |
1,465 | 1 | 2.59 | 1.00 | 130 | 0 | 282 | 0.18 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys4.dbf |
1,686 | 1 | 2.50 | 1.01 | 83 | 0 | 724 | 0.04 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys5.dbf |
1,782 | 1 | 2.64 | 1.00 | 51 | 0 | 1,257 | 0.05 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys6.dbf |
1,372 | 1 | 2.68 | 1.00 | 56 | 0 | 15 | 2.00 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys7.dbf |
1,686 | 1 | 2.24 | 1.00 | 53 | 0 | 818 | 0.07 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys8.dbf |
1,492 | 1 | 2.51 | 1.00 | 45 | 0 | 3,622 | 0.05 |
| SYSTEM | /ds2/oracle/VIS/db/apps_st/data/sys9.dbf |
1,627 | 1 | 2.78 | 1.00 | 175 | 0 | 544 | 0.39 |
| TEMP | /ds2/oracle/VIS/db/apps_st/data/temp_01.dbf |
54 | 0 | 0.37 | 7.65 | 63 | 0 | 0 | |
| TEMP | /ds2/oracle/VIS/db/apps_st/data/temp_02.dbf |
0 | 0 | | | 30 | 0 | 0 | |
| UDDISYS_TS | /ds2/oracle/VIS/db/apps_st/data/uddisys01.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| WCRSYS_TS | /ds2/oracle/VIS/db/apps_st/data/wcrsys01.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| XDB | /ds2/oracle/VIS/db/apps_st/data/xdb01.dbf |
44 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
Buffer Pool Statistics
- Standard block size Pools D: default, K: keep, R: recycle
- Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|
| D | 1,003,350 | 100 | 1,494,047,521 | 162,200 | 1,536,530 | 0 | 0 | 1,440,824 |
Back to Top
Advisory Statistics
Back to Top
Instance Recovery Stats
- B: Begin snapshot, E: End snapshot
| Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks |
|---|
| B | 0 | 29 | 8390 | 218731 | 218428 | 3774870 | 218428 | |
| E | 0 | 197 | 108427 | 2820796 | 3774870 | 3774870 | 10889671 | |
Back to Advisory Statistics
Back to Top
Buffer Pool Advisory
- Only rows with estimated physical reads >0 are displayed
- ordered by Block Size, Buffers For Estimate
| P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
|---|
| D | 800 | 0.10 | 98,950 | 1.04 | 22,798,262 |
| D | 1,600 | 0.20 | 197,900 | 1.02 | 22,491,424 |
| D | 2,400 | 0.30 | 296,850 | 1.01 | 22,306,063 |
| D | 3,200 | 0.39 | 395,800 | 1.01 | 22,200,127 |
| D | 4,000 | 0.49 | 494,750 | 1.01 | 22,168,012 |
| D | 4,800 | 0.59 | 593,700 | 1.01 | 22,128,272 |
| D | 5,600 | 0.69 | 692,650 | 1.00 | 22,109,594 |
| D | 6,400 | 0.79 | 791,600 | 1.00 | 22,091,110 |
| D | 7,200 | 0.89 | 890,550 | 1.00 | 22,067,540 |
| D | 8,000 | 0.99 | 989,500 | 1.00 | 22,024,998 |
| D | 8,112 | 1.00 | 1,003,353 | 1.00 | 22,014,697 |
| D | 8,800 | 1.08 | 1,088,450 | 1.00 | 21,950,703 |
| D | 9,600 | 1.18 | 1,187,400 | 0.99 | 21,901,373 |
| D | 10,400 | 1.28 | 1,286,350 | 0.99 | 21,883,601 |
| D | 11,200 | 1.38 | 1,385,300 | 0.99 | 21,859,180 |
| D | 12,000 | 1.48 | 1,484,250 | 0.99 | 21,808,735 |
| D | 12,800 | 1.58 | 1,583,200 | 0.99 | 21,761,788 |
| D | 13,600 | 1.68 | 1,682,150 | 0.99 | 21,721,226 |
| D | 14,400 | 1.78 | 1,781,100 | 0.99 | 21,683,800 |
| D | 15,200 | 1.87 | 1,880,050 | 0.98 | 21,662,836 |
| D | 16,000 | 1.97 | 1,979,000 | 0.98 | 21,629,717 |
Back to Advisory Statistics
Back to Top
PGA Aggr Summary
- PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|
| 99.98 | 88,329 | 15 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Stats
- B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
- Auto PGA Target - actual workarea memory target
- W/A PGA Used - amount of memory used for all Workareas (manual + auto)
- %PGA W/A Mem - percentage of PGA memory allocated to workareas
- %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
- %Man W/A Mem - percentage of workarea memory under manual control
| PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) |
|---|
| B | 6,144 | 5,404 | 280.95 | 0.00 | 0.00 | 0.00 | 0.00 | 629,140 |
| E | 6,144 | 5,374 | 306.65 | 0.00 | 0.00 | 0.00 | 0.00 | 629,140 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Histogram
- Optimal Executions are purely in-memory operations
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|
| 2K | 4K | 1,480,679 | 1,480,679 | 0 | 0 |
| 64K | 128K | 1,476 | 1,476 | 0 | 0 |
| 128K | 256K | 120 | 120 | 0 | 0 |
| 256K | 512K | 766 | 766 | 0 | 0 |
| 512K | 1024K | 40,755 | 40,755 | 0 | 0 |
| 1M | 2M | 46,031 | 46,031 | 0 | 0 |
| 2M | 4M | 595 | 591 | 4 | 0 |
| 4M | 8M | 133 | 133 | 0 | 0 |
| 8M | 16M | 38 | 38 | 0 | 0 |
| 16M | 32M | 8 | 8 | 0 | 0 |
Back to Advisory Statistics
Back to Top
PGA Memory Advisory
- When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
| PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count |
|---|
| 768 | 0.13 | 227,086.70 | 1,937.17 | 99.00 | 36 |
| 1,536 | 0.25 | 227,086.70 | 1,928.15 | 99.00 | 20 |
| 3,072 | 0.50 | 227,086.70 | 1,767.43 | 99.00 | 0 |
| 4,608 | 0.75 | 227,086.70 | 1,767.43 | 99.00 | 0 |
| 6,144 | 1.00 | 227,086.70 | 1,767.43 | 99.00 | 0 |
| 7,373 | 1.20 | 227,086.70 | 0.00 | 100.00 | 0 |
| 8,602 | 1.40 | 227,086.70 | 0.00 | 100.00 | 0 |
| 9,830 | 1.60 | 227,086.70 | 0.00 | 100.00 | 0 |
| 11,059 | 1.80 | 227,086.70 | 0.00 | 100.00 | 0 |
| 12,288 | 2.00 | 227,086.70 | 0.00 | 100.00 | 0 |
| 18,432 | 3.00 | 227,086.70 | 0.00 | 100.00 | 0 |
| 24,576 | 4.00 | 227,086.70 | 0.00 | 100.00 | 0 |
| 36,864 | 6.00 | 227,086.70 | 0.00 | 100.00 | 0 |
| 49,152 | 8.00 | 227,086.70 | 0.00 | 100.00 | 0 |
Back to Advisory Statistics
Back to Top
Shared Pool Advisory
- SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
- Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid.
| Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
|---|
| 752 | 0.38 | 236 | 11,495 | 666,995 | 0.98 | 14,364 | 27.05 | 54,941,338 |
| 960 | 0.48 | 441 | 18,347 | 668,656 | 0.98 | 12,703 | 23.92 | 54,944,951 |
| 1,168 | 0.58 | 648 | 25,462 | 676,188 | 0.99 | 5,171 | 9.74 | 54,946,075 |
| 1,376 | 0.69 | 855 | 32,013 | 677,275 | 0.99 | 4,084 | 7.69 | 54,946,435 |
| 1,584 | 0.79 | 1,061 | 39,297 | 677,333 | 0.99 | 4,026 | 7.58 | 54,946,721 |
| 1,792 | 0.90 | 1,268 | 48,049 | 679,892 | 1.00 | 1,467 | 2.76 | 54,946,996 |
| 2,000 | 1.00 | 1,475 | 56,661 | 680,828 | 1.00 | 531 | 1.00 | 54,947,209 |
| 2,208 | 1.10 | 1,682 | 65,744 | 681,555 | 1.00 | 1 | 0.00 | 54,947,348 |
| 2,416 | 1.21 | 1,889 | 72,653 | 681,610 | 1.00 | 1 | 0.00 | 54,947,431 |
| 2,624 | 1.31 | 2,096 | 79,623 | 681,610 | 1.00 | 1 | 0.00 | 54,947,533 |
| 2,832 | 1.42 | 2,302 | 87,346 | 681,610 | 1.00 | 1 | 0.00 | 54,947,715 |
| 3,040 | 1.52 | 2,509 | 96,766 | 682,590 | 1.00 | 1 | 0.00 | 54,949,437 |
| 3,248 | 1.62 | 2,716 | 104,716 | 685,737 | 1.01 | 1 | 0.00 | 54,952,270 |
| 3,456 | 1.73 | 2,923 | 116,392 | 685,992 | 1.01 | 1 | 0.00 | 54,954,118 |
| 3,664 | 1.83 | 3,130 | 126,144 | 688,526 | 1.01 | 1 | 0.00 | 54,956,486 |
| 3,872 | 1.94 | 3,337 | 134,925 | 688,846 | 1.01 | 1 | 0.00 | 54,985,206 |
| 4,080 | 2.04 | 3,544 | 146,131 | 688,873 | 1.01 | 1 | 0.00 | 54,998,781 |
Back to Advisory Statistics
Back to Top
SGA Target Advisory
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|
| 2,560 | 0.25 | 62,691 | 22,798,379 |
| 5,120 | 0.50 | 58,174 | 22,305,250 |
| 7,680 | 0.75 | 57,995 | 22,109,320 |
| 10,240 | 1.00 | 57,908 | 22,014,657 |
| 12,800 | 1.25 | 57,786 | 21,882,569 |
| 15,360 | 1.50 | 57,642 | 21,721,862 |
| 17,920 | 1.75 | 57,555 | 21,629,401 |
| 20,480 | 2.00 | 57,555 | 21,629,401 |
Back to Advisory Statistics
Back to Top
Streams Pool Advisory
| Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
|---|
| 16 | 1.00 | 0 | 0 | 0 | 0 |
| 32 | 2.00 | 0 | 0 | 0 | 0 |
| 48 | 3.00 | 0 | 0 | 0 | 0 |
| 64 | 4.00 | 0 | 0 | 0 | 0 |
| 80 | 5.00 | 0 | 0 | 0 | 0 |
| 96 | 6.00 | 0 | 0 | 0 | 0 |
| 112 | 7.00 | 0 | 0 | 0 | 0 |
| 128 | 8.00 | 0 | 0 | 0 | 0 |
| 144 | 9.00 | 0 | 0 | 0 | 0 |
| 160 | 10.00 | 0 | 0 | 0 | 0 |
| 176 | 11.00 | 0 | 0 | 0 | 0 |
| 192 | 12.00 | 0 | 0 | 0 | 0 |
| 208 | 13.00 | 0 | 0 | 0 | 0 |
| 224 | 14.00 | 0 | 0 | 0 | 0 |
| 240 | 15.00 | 0 | 0 | 0 | 0 |
| 256 | 16.00 | 0 | 0 | 0 | 0 |
| 272 | 17.00 | 0 | 0 | 0 | 0 |
| 288 | 18.00 | 0 | 0 | 0 | 0 |
| 304 | 19.00 | 0 | 0 | 0 | 0 |
| 320 | 20.00 | 0 | 0 | 0 | 0 |
Back to Advisory Statistics
Back to Top
Java Pool Advisory
| Java Pool Size(M) | JP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
|---|
| 16 | 0.25 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 32 | 0.50 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 48 | 0.75 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 64 | 1.00 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 80 | 1.25 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 96 | 1.50 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 112 | 1.75 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
| 128 | 2.00 | 11 | 326 | 5 | 1.00 | 531 | 1.00 | 242 |
Back to Advisory Statistics
Back to Top
Wait Statistics
Back to Top
Buffer Wait Statistics
- ordered by wait time desc, waits desc
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|
| data block | 739,200 | 119 | 0 |
| undo block | 600,395 | 20 | 0 |
| undo header | 65,892 | 2 | 0 |
| 1st level bmb | 22,200 | 1 | 0 |
| segment header | 11,146 | 1 | 0 |
| file header block | 1,175 | 0 | 0 |
| 2nd level bmb | 594 | 0 | 0 |
| 3rd level bmb | 40 | 0 | 1 |
| extent map | 35 | 0 | 0 |
Back to Wait Statistics
Back to Top
Enqueue Activity
- only enqueues with waits are shown
- Enqueue stats gathered prior to 10g should not be compared with 10g data
- ordered by Wait Time desc, Waits desc
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|
| TX-Transaction (row lock contention) |
295,046 | 3,092 | 291,953 | 3,090 | 62 | 20.07 |
| TX-Transaction (index contention) |
20,351 | 20,351 | 0 | 19,376 | 25 | 1.31 |
| TX-Transaction |
913,419 | 913,373 | 0 | 7,595 | 5 | 0.63 |
| HW-Segment High Water Mark |
1,950,779 | 1,948,074 | 14 | 7,399 | 4 | 0.53 |
| US-Undo Segment |
937,602 | 937,490 | 0 | 25,359 | 3 | 0.13 |
| RO-Multiple Object Reuse (fast object reuse) |
216 | 216 | 0 | 24 | 1 | 32.08 |
| SQ-Sequence Cache |
29,033 | 29,033 | 0 | 4,211 | 1 | 0.18 |
| KO-Multiple Object Checkpoint (fast object checkpoint) |
99 | 99 | 0 | 11 | 1 | 53.64 |
| FB-Format Block |
21,660 | 21,660 | 0 | 1,682 | 0 | 0.21 |
| TX-Transaction (allocate ITL entry) |
96 | 96 | 0 | 73 | 0 | 0.27 |
| PS-PX Process Reservation |
1,638 | 1,330 | 308 | 21 | 0 | 0.00 |
| CU-Cursor |
3,178 | 3,178 | 0 | 2 | 0 | 0.00 |
Back to Wait Statistics
Back to Top
Undo Statistics
Back to Top
Undo Segment Summary
- Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
- STO - Snapshot Too Old count, OOS - Out of Space count
- Undo segment block stats:
- uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
- eS - expired Stolen, eR - expired Released, eU - expired reUsed
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|
| 1 | 1,083.70 | 909,668 | 1,826 | 24 | 13.05/2338.83333333333333333333333333333333333 | 0/0 | 11/8/8/1503/516305/0 |
Back to Undo Statistics
Back to Top
Undo Segment Stats
- Most recent 35 Undostat rows, ordered by Time desc
| End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|
| 27-Sep 21:54 | 189,705 | 63,823 | 1,826 | 14 | 20 | 0/0 | 0/0/0/0/0/0 |
| 27-Sep 21:44 | 394,050 | 339,944 | 1,226 | 24 | 13 | 0/0 | 11/8/8/1156/188736/0 |
| 27-Sep 21:34 | 499,943 | 505,901 | 626 | 19 | 2,339 | 0/0 | 0/0/0/347/327569/0 |
Back to Undo Statistics
Back to Top
Latch Statistics
Back to Top
Latch Activity
- "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
- "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
- "Pct Misses" for both should be very close to 0.0
| Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
|---|
| ASM db client latch | 13,002 | 0.00 | | 0 | 0 | |
| AWR Alerted Metric Element list | 12,993 | 0.00 | | 0 | 0 | |
| Consistent RBA | 293,965 | 0.07 | 0.00 | 0 | 0 | |
| FOB s.o list latch | 25,701 | 0.62 | 0.00 | 0 | 0 | |
| In memory undo latch | 736,154,176 | 1.52 | 0.00 | 1 | 691,322 | 0.03 |
| JOX SGA heap latch | 1,728,881 | 0.00 | 1.00 | 0 | 4,557 | 0.00 |
| JS queue state obj latch | 10,740 | 0.00 | | 0 | 0 | |
| KMG MMAN ready and startup request latch | 824 | 0.00 | | 0 | 0 | |
| KMG resize request state object freelist | 10 | 0.00 | | 0 | 0 | |
| KTF sga latch | 6 | 0.00 | | 0 | 567 | 0.00 |
| KWQMN job cache list latch | 205,950 | 0.49 | 0.03 | 0 | 0 | |
| KWQP Prop Status | 222 | 0.00 | | 0 | 0 | |
| MQL Tracking Latch | 0 | | | 0 | 36 | 0.00 |
| Memory Management Latch | 306 | 0.33 | 0.00 | 0 | 820 | 0.00 |
| OS process | 1,503 | 0.00 | | 0 | 0 | |
| OS process allocation | 1,589 | 0.06 | 0.00 | 0 | 0 | |
| OS process: request allocation | 880 | 0.23 | 0.00 | 0 | 0 | |
| PL/SQL warning settings | 1,282,688 | 0.00 | | 0 | 0 | |
| Policy Hash Table Latch | 11 | 0.00 | | 0 | 0 | |
| SGA IO buffer pool latch | 5,341 | 0.02 | 0.00 | 0 | 13,179 | 0.19 |
| SQL memory manager latch | 1 | 0.00 | | 0 | 593 | 0.00 |
| SQL memory manager workarea list latch | 1,339,000 | 0.02 | 0.00 | 0 | 0 | |
| Shared B-Tree | 1,139 | 0.00 | | 0 | 0 | |
| Undo Hint Latch | 0 | | | 0 | 1,570 | 0.00 |
| active checkpoint queue latch | 550,661 | 7.70 | 0.00 | 0 | 0 | |
| active service list | 7,596 | 5.85 | 0.01 | 0 | 644 | 0.00 |
| begin backup scn array | 41 | 0.00 | | 0 | 0 | |
| bq:time manger info latch | 63 | 0.00 | | 0 | 0 | |
| buffer pool | 7 | 0.00 | | 0 | 0 | |
| bufq statistics | 10 | 0.00 | | 0 | 0 | |
| cache buffer handles | 6,109,150 | 1.30 | 0.00 | 0 | 0 | |
| cache buffers chains | 3,800,408,110 | 3.02 | 0.00 | 5 | 14,381,101 | 4.35 |
| cache buffers lru chain | 5,544,259 | 0.49 | 0.00 | 0 | 30,960,202 | 0.53 |
| cache table scan latch | 0 | | | 0 | 6,917 | 0.46 |
| channel handle pool latch | 10,226 | 0.07 | 0.00 | 0 | 0 | |
| channel operations parent latch | 96,660 | 0.61 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 12,483,723 | 0.02 | 0.01 | 0 | 1,639,396 | 0.02 |
| client/application info | 5,208 | 0.00 | | 0 | 0 | |
| commit callback allocation | 222,316 | 0.11 | 0.00 | 0 | 0 | |
| compile environment latch | 40,355 | 0.00 | | 0 | 0 | |
| dictionary lookup | 39 | 0.00 | | 0 | 0 | |
| dml lock allocation | 5,044,238 | 3.07 | 0.00 | 0 | 0 | |
| dummy allocation | 1,538 | 4.16 | 0.00 | 0 | 0 | |
| enqueue hash chains | 14,620,989 | 2.75 | 0.00 | 1 | 141 | 0.00 |
| enqueues | 7,014,204 | 27.13 | 0.00 | 1 | 0 | |
| error message lists | 667 | 4.95 | 0.00 | 0 | 0 | |
| event group latch | 435 | 0.00 | | 0 | 0 | |
| file cache latch | 41,458 | 0.00 | 0.00 | 0 | 0 | |
| global KZLD latch for mem in SGA | 406 | 0.00 | | 0 | 0 | |
| global ctx hash table latch | 271,017 | 0.00 | | 0 | 0 | |
| hash table column usage latch | 1,097 | 1.28 | 0.00 | 0 | 487,602 | 0.00 |
| hash table modification latch | 169 | 0.59 | 0.00 | 0 | 0 | |
| internal temp table object number allocation latc | 3 | 0.00 | | 0 | 0 | |
| job_queue_processes parameter latch | 30 | 0.00 | | 0 | 0 | |
| kks stats | 6,568 | 0.08 | 0.00 | 0 | 0 | |
| ksuosstats global area | 122 | 0.00 | | 0 | 0 | |
| ktm global data | 3,814 | 0.00 | | 0 | 0 | |
| kwqbsn:qsga | 1,082 | 0.00 | | 0 | 0 | |
| kwqbsn:qxl | 1 | 0.00 | | 0 | 0 | |
| kwqi:kchunk latch | 2 | 0.00 | | 0 | 0 | |
| lgwr LWN SCN | 294,665 | 0.29 | 0.00 | 0 | 0 | |
| library cache | 89,441,406 | 1.42 | 0.00 | 2 | 8,568 | 0.63 |
| library cache load lock | 14,955 | 1.18 | 0.01 | 0 | 53 | 0.00 |
| library cache lock | 12,803,387 | 1.36 | 0.00 | 0 | 0 | |
| library cache lock allocation | 47,619 | 0.00 | | 0 | 0 | |
| library cache pin | 57,258,744 | 0.90 | 0.00 | 0 | 0 | |
| library cache pin allocation | 31,918 | 0.00 | | 0 | 0 | |
| list of block allocation | 297,212 | 0.15 | 0.00 | 0 | 0 | |
| loader state object freelist | 9,726 | 0.10 | 0.00 | 0 | 0 | |
| logminer context allocation | 1 | 0.00 | | 0 | 0 | |
| longop free list parent | 5 | 0.00 | | 0 | 5 | 0.00 |
| message pool operations parent latch | 9,903 | 0.14 | 0.00 | 0 | 0 | |
| messages | 2,491,644 | 0.82 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 331,700 | 9.76 | 0.00 | 0 | 0 | |
| multiblock read objects | 16,036 | 0.06 | 0.00 | 0 | 0 | |
| ncodef allocation latch | 40 | 0.00 | | 0 | 0 | |
| object queue header heap | 2,215,286 | 0.00 | 0.00 | 0 | 13,228 | 0.02 |
| object queue header operation | 14,023,647 | 0.05 | 0.01 | 0 | 3,710 | 0.03 |
| object stats modification | 9,750 | 0.02 | 0.00 | 0 | 0 | |
| parallel query alloc buffer | 9,924 | 3.64 | 0.00 | 0 | 0 | |
| parallel query stats | 391 | 31.46 | 0.03 | 0 | 0 | |
| parameter list | 1,370 | 0.00 | | 0 | 0 | |
| parameter table allocation management | 784 | 29.97 | 0.34 | 0 | 0 | |
| post/wait queue | 342,103 | 0.17 | 0.01 | 0 | 179,813 | 0.49 |
| process allocation | 903 | 0.44 | 0.25 | 0 | 432 | 0.69 |
| process group creation | 880 | 0.00 | | 0 | 0 | |
| process queue | 6,360 | 0.74 | 0.00 | 0 | 0 | |
| process queue reference | 700,025 | 0.02 | 0.00 | 0 | 43,914 | 0.52 |
| qmn task queue latch | 2,264 | 12.28 | 0.10 | 0 | 0 | |
| query server freelists | 5,739 | 12.13 | 0.00 | 0 | 0 | |
| query server process | 28 | 0.00 | | 0 | 42 | 0.00 |
| redo allocation | 2,578,979 | 1.47 | 0.00 | 0 | 68,314,003 | 1.60 |
| redo copy | 0 | | | 0 | 68,383,622 | 0.03 |
| redo writing | 1,687,437 | 1.75 | 0.00 | 0 | 0 | |
| resmgr group change latch | 2,919 | 0.00 | | 0 | 0 | |
| resmgr:actses active list | 1,943 | 0.26 | 0.00 | 0 | 0 | |
| resmgr:actses change group | 1,537 | 0.00 | | 0 | 0 | |
| resmgr:free threads list | 1,538 | 8.71 | 0.00 | 0 | 0 | |
| resmgr:schema config | 1 | 0.00 | | 0 | 0 | |
| row cache objects | 44,783,589 | 5.14 | 0.00 | 1 | 2,628 | 0.00 |
| rules engine aggregate statistics | 105,001 | 2.04 | 0.00 | 0 | 0 | |
| rules engine evaluation context statistics | 2 | 0.00 | | 0 | 0 | |
| rules engine rule set statistics | 419,921 | 0.92 | 0.00 | 0 | 0 | |
| rules engine rule statistics | 209,861 | 0.00 | | 0 | 0 | |
| sequence cache | 5,710,775 | 0.96 | 0.00 | 0 | 0 | |
| session allocation | 7,137,190 | 1.07 | 0.00 | 0 | 0 | |
| session idle bit | 362,025 | 0.00 | 0.00 | 0 | 0 | |
| session state list latch | 3,166 | 3.13 | 0.01 | 0 | 0 | |
| session switching | 40 | 0.00 | | 0 | 0 | |
| session timer | 644 | 0.00 | | 0 | 0 | |
| shared pool | 12,992,532 | 0.75 | 0.00 | 0 | 0 | |
| shared pool sim alloc | 33 | 3.03 | 0.00 | 0 | 0 | |
| shared pool simulator | 1,578,535 | 0.02 | 0.03 | 0 | 0 | |
| simulator hash latch | 88,435,895 | 0.01 | 0.00 | 0 | 0 | |
| simulator lru latch | 88,148,601 | 1.74 | 0.00 | 0 | 103,461 | 0.01 |
| sort extent pool | 33,083 | 0.18 | 0.00 | 0 | 0 | |
| state object free list | 2 | 0.00 | | 0 | 0 | |
| statistics aggregation | 84 | 0.00 | | 0 | 0 | |
| temporary table state object allocation | 422 | 0.47 | 0.00 | 0 | 0 | |
| threshold alerts latch | 431 | 0.00 | | 0 | 0 | |
| trace latch | 6 | 0.00 | | 0 | 0 | |
| transaction allocation | 27,000 | 0.01 | 0.00 | 0 | 0 | |
| transaction branch allocation | 40 | 0.00 | | 0 | 0 | |
| undo global data | 867,908,571 | 1.74 | 0.00 | 0 | 8,606 | 0.46 |
| user lock | 1,616 | 0.56 | 0.00 | 0 | 0 | |
Back to Latch Statistics
Back to Top
Latch Sleep Breakdown
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
|---|
| cache buffers chains |
3,800,408,110 | 114,893,324 | 415,550 | 114,494,158 | 0 | 0 | 0 |
| undo global data |
867,908,571 | 15,144,993 | 1,114 | 15,144,114 | 0 | 0 | 0 |
| In memory undo latch |
736,154,176 | 11,167,811 | 6,580 | 11,161,720 | 0 | 0 | 0 |
| row cache objects |
44,783,589 | 2,303,872 | 1,289 | 2,302,667 | 0 | 0 | 0 |
| enqueues |
7,014,204 | 1,902,902 | 1,477 | 1,901,469 | 0 | 0 | 0 |
| simulator lru latch |
88,148,601 | 1,531,777 | 442 | 1,531,423 | 0 | 0 | 0 |
| library cache |
89,441,406 | 1,273,253 | 1,510 | 1,272,198 | 0 | 0 | 0 |
| library cache pin |
57,258,744 | 515,583 | 213 | 515,417 | 0 | 0 | 0 |
| enqueue hash chains |
14,620,989 | 402,267 | 760 | 401,549 | 0 | 0 | 0 |
| library cache lock |
12,803,387 | 174,069 | 50 | 174,032 | 0 | 0 | 0 |
| dml lock allocation |
5,044,238 | 154,670 | 27 | 154,647 | 0 | 0 | 0 |
| shared pool |
12,992,532 | 97,544 | 357 | 97,237 | 0 | 0 | 0 |
| cache buffer handles |
6,109,150 | 79,710 | 34 | 79,683 | 0 | 0 | 0 |
| session allocation |
7,137,190 | 76,526 | 108 | 76,436 | 0 | 0 | 0 |
| sequence cache |
5,710,775 | 54,542 | 7 | 54,535 | 0 | 0 | 0 |
| active checkpoint queue latch |
550,661 | 42,396 | 17 | 42,379 | 0 | 0 | 0 |
| redo allocation |
2,578,979 | 37,886 | 156 | 37,760 | 0 | 0 | 0 |
| mostly latch-free SCN |
331,700 | 32,365 | 39 | 32,331 | 0 | 0 | 0 |
| redo writing |
1,687,437 | 29,450 | 11 | 29,439 | 0 | 0 | 0 |
| cache buffers lru chain |
5,544,259 | 27,410 | 110 | 27,309 | 0 | 0 | 0 |
| messages |
2,491,644 | 20,346 | 15 | 20,331 | 0 | 0 | 0 |
| object queue header operation |
14,023,647 | 7,390 | 73 | 7,320 | 0 | 0 | 0 |
| simulator hash latch |
88,435,895 | 5,798 | 2 | 5,796 | 0 | 0 | 0 |
| checkpoint queue latch |
12,483,723 | 1,881 | 23 | 1,859 | 0 | 0 | 0 |
| KWQMN job cache list latch |
205,950 | 1,016 | 29 | 989 | 0 | 0 | 0 |
| post/wait queue |
342,103 | 567 | 5 | 562 | 0 | 0 | 0 |
| active service list |
7,596 | 444 | 3 | 441 | 0 | 0 | 0 |
| list of block allocation |
297,212 | 444 | 2 | 443 | 0 | 0 | 0 |
| shared pool simulator |
1,578,535 | 393 | 13 | 384 | 0 | 0 | 0 |
| qmn task queue latch |
2,264 | 278 | 29 | 249 | 0 | 0 | 0 |
| parameter table allocation management |
784 | 235 | 81 | 158 | 0 | 0 | 0 |
| library cache load lock |
14,955 | 177 | 2 | 175 | 0 | 0 | 0 |
| parallel query stats |
391 | 123 | 4 | 119 | 0 | 0 | 0 |
| session state list latch |
3,166 | 99 | 1 | 98 | 0 | 0 | 0 |
| process allocation |
903 | 4 | 1 | 3 | 0 | 0 | 0 |
| JOX SGA heap latch |
1,728,881 | 2 | 2 | 0 | 0 | 0 | 0 |
Back to Latch Statistics
Back to Top
Latch Miss Sources
- only latches with sleeps are shown
- ordered by name, sleeps desc
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|
| In memory undo latch | ktiFlush: child | 0 | 5,056 | 2,687 |
| In memory undo latch | kturbk | 0 | 1,022 | 1,653 |
| In memory undo latch | ktichg: child | 0 | 267 | 1,818 |
| In memory undo latch | kticmt: child | 0 | 165 | 4 |
| In memory undo latch | ktiTxnPoolFree | 0 | 46 | 1 |
| In memory undo latch | ktbgfc | 0 | 23 | 418 |
| In memory undo latch | ktiBRacquire | 0 | 1 | 0 |
| KWQMN job cache list latch | kwqmnuji: update job item | 0 | 525 | 524 |
| active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 17 | 17 |
| active service list | ksws_event: ksws event | 0 | 32 | 27 |
| cache buffer handles | kcbzgs | 0 | 24 | 20 |
| cache buffer handles | kcbzfs | 0 | 9 | 14 |
| cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 1,687,145 | 1,644,169 |
| cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 595,144 | 1,078,795 |
| cache buffers chains | kcbgtcr: fast path | 0 | 323,967 | 10,832 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 176,359 | 54,684 |
| cache buffers chains | kcbgcur: kslbegin | 0 | 42,110 | 11,492 |
| cache buffers chains | kcbget: pin buffer | 0 | 15,550 | 3,802 |
| cache buffers chains | kcbzwb | 0 | 9,790 | 8,985 |
| cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 7,373 | 0 |
| cache buffers chains | kcbrls: kslbegin | 0 | 4,832 | 39,830 |
| cache buffers chains | kcbcge | 0 | 1,292 | 10,518 |
| cache buffers chains | kcb_is_private | 0 | 329 | 4,293 |
| cache buffers chains | kcbnlc | 0 | 172 | 1,363 |
| cache buffers chains | kcbget: exchange | 0 | 165 | 242 |
| cache buffers chains | kcbget: exchange rls | 0 | 144 | 155 |
| cache buffers chains | kcbesc: escalate | 0 | 66 | 42 |
| cache buffers chains | kcbbxsv | 0 | 60 | 59 |
| cache buffers chains | kcbnew: new latch again | 0 | 49 | 0 |
| cache buffers chains | kcbgtcr: kslbegin shared | 0 | 13 | 6 |
| cache buffers chains | kcb_post_apply: kcbhq62 | 0 | 9 | 75 |
| cache buffers chains | kcb_pre_apply: kcbhq61 | 0 | 9 | 1,541 |
| cache buffers chains | kcbbic1 | 0 | 7 | 0 |
| cache buffers chains | kcbw_next_free | 0 | 4 | 0 |
| cache buffers chains | kcb_post_apply: kcbhq63 | 0 | 1 | 114 |
| cache buffers chains | kcbgtcr | 0 | 1 | 0 |
| cache buffers chains | kcbso1: set no access | 0 | 1 | 8 |
| cache buffers chains | kcbzhngcbk1: get hash chain latch no wait | 0 | 1 | 0 |
| cache buffers chains | kcbzib: finish free bufs | 0 | 1 | 7 |
| cache buffers lru chain | kcbbxsv: move to being written | 0 | 46 | 72 |
| cache buffers lru chain | kcbzgws | 0 | 34 | 0 |
| cache buffers lru chain | kcbgtcr:CR Scan:KCBRSKIP | 0 | 15 | 0 |
| cache buffers lru chain | kcbzgb: posted for free bufs | 0 | 8 | 27 |
| cache buffers lru chain | kcbzswcu | 0 | 4 | 3 |
| cache buffers lru chain | kcbbic2 | 0 | 2 | 8 |
| cache buffers lru chain | kcbw_activate_granule | 0 | 1 | 0 |
| checkpoint queue latch | kcbkubc | 0 | 15 | 2 |
| checkpoint queue latch | kcbbwthc: thread checkpoint buffers | 0 | 5 | 15 |
| checkpoint queue latch | kcbklbc: Link buffer into ckpt queue | 0 | 2 | 0 |
| checkpoint queue latch | kcbswcu: Switch buffers | 0 | 1 | 5 |
| dml lock allocation | ktaiam | 0 | 16 | 19 |
| dml lock allocation | ktaidm | 0 | 11 | 8 |
| enqueue hash chains | ksqgtl3 | 0 | 401 | 538 |
| enqueue hash chains | ksqrcl | 0 | 300 | 200 |
| enqueue hash chains | ksqcnl | 0 | 38 | 11 |
| enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 20 | 10 |
| enqueues | ksqgel: create enqueue | 0 | 868 | 819 |
| enqueues | ksqdel | 0 | 608 | 657 |
| enqueues | ksqies | 0 | 1 | 0 |
| event range base latch | No latch | 0 | 31 | 31 |
| lgwr LWN SCN | kcs023 | 0 | 17 | 0 |
| library cache | kglpndl: child: after processing | 0 | 531 | 8 |
| library cache | kglpnp: child | 0 | 377 | 744 |
| library cache | kglpndl: child: before processing | 0 | 362 | 336 |
| library cache | kglobpn: child: | 0 | 146 | 339 |
| library cache | kglLockCursor | 0 | 14 | 20 |
| library cache | kglget: unpin heap 0 | 0 | 14 | 17 |
| library cache | kgldte: child 0 | 0 | 9 | 17 |
| library cache | kglhdgn: child: | 0 | 8 | 8 |
| library cache | kglpin | 0 | 8 | 0 |
| library cache | kgldti: 2child | 0 | 1 | 1 |
| library cache | kglivl: child | 0 | 1 | 0 |
| library cache | kglrtl | 0 | 1 | 0 |
| library cache load lock | kglllal: llatch: in loop | 0 | 2 | 0 |
| library cache lock | kgllkdl: child: cleanup | 0 | 33 | 33 |
| library cache lock | kgllkal: child: multiinstance | 0 | 17 | 17 |
| library cache lock | kgllkdl: child: no lock handle | 0 | 4 | 2 |
| library cache pin | kglpndl | 0 | 113 | 54 |
| library cache pin | kglpnp: child | 0 | 97 | 124 |
| library cache pin | kglpnal: child: alloc space | 0 | 3 | 35 |
| list of block allocation | ktlabl | 0 | 2 | 2 |
| messages | ksarcv | 0 | 8 | 2 |
| messages | ksarcv: after wait | 0 | 4 | 11 |
| messages | ksaamb: after wakeup | 0 | 3 | 2 |
| mostly latch-free SCN | kcslcu3 | 0 | 22 | 54 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 26 | 10 |
| object queue header operation | kcbw_unlink_q | 0 | 18 | 9 |
| object queue header operation | kcbw_link_q | 0 | 13 | 8 |
| object queue header operation | kcbo_switch_q_bg | 0 | 11 | 4 |
| object queue header operation | kcbo_ivbo | 0 | 7 | 3 |
| object queue header operation | kcbo_switch_cq | 0 | 5 | 5 |
| object queue header operation | kcbo_swap_buf_bg | 0 | 3 | 46 |
| object queue header operation | kcbo_swap_buf | 0 | 2 | 3 |
| object queue header operation | kcbo_write_q | 0 | 1 | 0 |
| parallel query stats | kxfprst: KSLBEGIN:1 | 0 | 4 | 4 |
| parameter table allocation management | ksp_param_table_free | 0 | 81 | 81 |
| post/wait queue | ksliwat:remove | 0 | 5 | 5 |
| process allocation | ksudlp | 0 | 1 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 130 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 18 | 124 |
| redo allocation | kcrfw_redo_write: before write | 0 | 5 | 15 |
| redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 3 | 0 |
| redo writing | kcrfwcr | 0 | 8 | 10 |
| redo writing | kcrfw_post: rba scn pair | 0 | 2 | 0 |
| redo writing | kcrfw_post: after write | 0 | 1 | 0 |
| row cache objects | kqrpre: find obj | 0 | 621 | 942 |
| row cache objects | kqreqd: reget | 0 | 592 | 52 |
| row cache objects | kqreqd | 0 | 74 | 293 |
| row cache objects | kqrpre: init complete | 0 | 2 | 7 |
| sequence cache | kdnssd | 0 | 6 | 0 |
| sequence cache | kdnnxt: cached seq | 0 | 1 | 0 |
| session allocation | ksuprc | 0 | 53 | 57 |
| session allocation | ksuxds: KSUSFCLC not set | 0 | 26 | 23 |
| session allocation | ksudlc | 0 | 16 | 17 |
| session allocation | ksucri | 0 | 5 | 4 |
| session allocation | ksursi | 0 | 4 | 6 |
| session allocation | kxfpqidqr | 0 | 2 | 1 |
| session allocation | ksuxds: not user session | 0 | 1 | 0 |
| session allocation | kxfprdp | 0 | 1 | 0 |
| session state list latch | kpseqd | 0 | 1 | 0 |
| shared pool | kghalo | 0 | 221 | 267 |
| shared pool | kghfre | 0 | 63 | 68 |
| shared pool | kghupr1 | 0 | 59 | 16 |
| shared pool | kghfrunp: clatch: wait | 0 | 26 | 27 |
| shared pool | kghfrunp: alloc: session dur | 0 | 14 | 5 |
| shared pool | kghfrunp: clatch: nowait | 0 | 8 | 0 |
| shared pool simulator | kglsim_unpin_simhp | 0 | 13 | 13 |
| simulator hash latch | kcbsacc: lookup dba | 0 | 2 | 3 |
| simulator lru latch | kcbs_simulate: simulate set | 0 | 398 | 431 |
| simulator lru latch | kcbs_simbufseq | 0 | 37 | 11 |
| simulator lru latch | kcbs_shrink_pool | 0 | 5 | 0 |
| simulator lru latch | kcbs_free_granule_sim_buffers | 0 | 1 | 0 |
| simulator lru latch | kcbs_resize_pool : interpolation | 0 | 1 | 0 |
| undo global data | kturimugur: child | 0 | 834 | 477 |
| undo global data | ktudba: KSLBEGIN | 0 | 189 | 613 |
| undo global data | ktusm_stealext: KSLBEGIN | 0 | 47 | 5 |
| undo global data | ktusmasp: ktugd_tuux | 0 | 19 | 3 |
| undo global data | ktusmupst: KSLBEGIN | 0 | 16 | 2 |
| undo global data | ktudnx:child | 0 | 5 | 8 |
| undo global data | ktuGetRetentionDuration | 0 | 4 | 3 |
Back to Latch Statistics
Back to Top
|
