|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 210556022 | VIS | 1 | 10.2.0.3.0 | NO | vega7242.cup.hp.com |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 79 | 25-Aug-08 13:58:55 | 86 | 31.7 |
| End Snap: | 80 | 25-Aug-08 14:41:05 | 86 | 29.9 |
| Elapsed: | | 42.17 (mins) | | |
| DB Time: | | 244.79 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 23,472M | 23,456M | Std Block Size: | 8K |
| Shared Pool Size: | 1,024M | 1,024M | Log Buffer: | 14,312K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 8,048,031.45 | 32,682.79 |
| Logical reads: | 492,191.30 | 1,998.77 |
| Block changes: | 49,192.06 | 199.77 |
| Physical reads: | 28.19 | 0.11 |
| Physical writes: | 886.51 | 3.60 |
| User calls: | 75.23 | 0.31 |
| Parses: | 815.55 | 3.31 |
| Hard parses: | 1.32 | 0.01 |
| Sorts: | 1,639.23 | 6.66 |
| Logons: | 0.34 | 0.00 |
| Executes: | 18,145.60 | 73.69 |
| Transactions: | 246.25 | |
| % Blocks changed per Read: | 9.99 | Recursive Call %: | 99.77 |
| Rollback per transaction %: | 0.13 | Rows per Sort: | 3.12 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.91 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.78 | Soft Parse %: | 99.84 |
| Execute to Parse %: | 95.51 | Latch Hit %: | 98.04 |
| Parse CPU to Parse Elapsd %: | 53.80 | % Non-Parse CPU: | 99.75 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 38.02 | 62.35 |
| % SQL with executions>1: | 85.86 | 83.03 |
| % Memory for SQL w/exec>1: | 83.81 | 86.61 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 13,232 | | 90.1 | |
| log file sync | 167,967 | 745 | 4 | 5.1 | Commit |
| log file parallel write | 215,806 | 568 | 3 | 3.9 | System I/O |
| buffer busy waits | 1,057,405 | 177 | 0 | 1.2 | Concurrency |
| db file sequential read | 20,815 | 79 | 4 | .5 | User I/O |
Main Report
Back to Top
Wait Events Statistics
Back to Top
Time Model Statistics
- Total time in database user-calls (DB Time): 14687.7s
- 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 | 14,651.68 | 99.76 |
| DB CPU | 13,232.49 | 90.09 |
| PL/SQL execution elapsed time | 2,668.91 | 18.17 |
| Java execution elapsed time | 538.49 | 3.67 |
| parse time elapsed | 101.63 | 0.69 |
| hard parse elapsed time | 37.54 | 0.26 |
| sequence load elapsed time | 11.84 | 0.08 |
| repeated bind elapsed time | 8.44 | 0.06 |
| PL/SQL compilation elapsed time | 3.53 | 0.02 |
| connection management call elapsed time | 1.94 | 0.01 |
| hard parse (sharing criteria) elapsed time | 0.49 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.13 | 0.00 |
| inbound PL/SQL rpc elapsed time | 0.03 | 0.00 |
| failed parse elapsed time | 0.01 | 0.00 |
| DB time | 14,687.66 | |
| background elapsed time | 1,266.70 | |
| background cpu time | 130.19 | |
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 |
|---|
| Commit | 167,967 | 0.00 | 745 | 4 | 0.27 |
| System I/O | 219,311 | 0.00 | 575 | 3 | 0.35 |
| Concurrency | 2,618,903 | 0.08 | 370 | 0 | 4.20 |
| User I/O | 34,331 | 0.00 | 132 | 4 | 0.06 |
| Other | 96,560 | 44.87 | 59 | 1 | 0.15 |
| Application | 9,698 | 0.00 | 58 | 6 | 0.02 |
| Configuration | 12,679 | 0.00 | 5 | 0 | 0.02 |
| Network | 319,132 | 0.00 | 3 | 0 | 0.51 |
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 sync | 167,967 | 0.00 | 745 | 4 | 0.27 |
| log file parallel write | 215,806 | 0.00 | 568 | 3 | 0.35 |
| buffer busy waits | 1,057,405 | 0.00 | 177 | 0 | 1.70 |
| db file sequential read | 20,815 | 0.00 | 79 | 4 | 0.03 |
| library cache load lock | 3,307 | 0.00 | 71 | 21 | 0.01 |
| latch: cache buffers chains | 1,515,007 | 0.00 | 66 | 0 | 2.43 |
| enq: TX - row lock contention | 9,180 | 0.00 | 57 | 6 | 0.01 |
| db file scattered read | 5,885 | 0.00 | 29 | 5 | 0.01 |
| cursor: pin S wait on X | 2,430 | 90.00 | 24 | 10 | 0.00 |
| read by other session | 5,961 | 0.00 | 24 | 4 | 0.01 |
| buffer deadlock | 43,456 | 99.37 | 23 | 1 | 0.07 |
| enq: TX - index contention | 16,930 | 0.00 | 14 | 1 | 0.03 |
| latch: In memory undo latch | 18,561 | 0.00 | 9 | 0 | 0.03 |
| LGWR wait for redo copy | 11,861 | 0.07 | 7 | 1 | 0.02 |
| control file parallel write | 1,237 | 0.00 | 7 | 5 | 0.00 |
| enq: TX - contention | 8,742 | 0.00 | 6 | 1 | 0.01 |
| os thread startup | 49 | 2.04 | 5 | 109 | 0.00 |
| kksfbc child completion | 126 | 82.54 | 5 | 41 | 0.00 |
| rdbms ipc reply | 205 | 0.49 | 4 | 20 | 0.00 |
| latch free | 4,788 | 0.00 | 4 | 1 | 0.01 |
| enq: HW - contention | 5,971 | 0.00 | 4 | 1 | 0.01 |
| SQL*Net more data to client | 152,819 | 0.00 | 3 | 0 | 0.25 |
| wait list latch free | 198 | 0.00 | 2 | 11 | 0.00 |
| latch: undo global data | 7,478 | 0.00 | 2 | 0 | 0.01 |
| latch: library cache | 1,485 | 0.00 | 2 | 1 | 0.00 |
| latch: cache buffers lru chain | 323 | 0.00 | 2 | 5 | 0.00 |
| enq: SQ - contention | 6,636 | 0.00 | 1 | 0 | 0.01 |
| SQL*Net break/reset to client | 512 | 0.00 | 1 | 2 | 0.00 |
| latch: redo allocation | 1,220 | 0.00 | 1 | 1 | 0.00 |
| enq: FB - contention | 1,837 | 0.00 | 1 | 0 | 0.00 |
| row cache lock | 2,155 | 0.00 | 1 | 0 | 0.00 |
| latch: library cache pin | 528 | 0.00 | 1 | 1 | 0.00 |
| PX Deq Credit: send blkd | 1,948 | 0.00 | 1 | 0 | 0.00 |
| latch: shared pool | 289 | 0.00 | 0 | 2 | 0.00 |
| cursor: pin S | 13,858 | 0.00 | 0 | 0 | 0.02 |
| latch: row cache objects | 377 | 0.00 | 0 | 1 | 0.00 |
| latch: enqueue hash chains | 122 | 0.00 | 0 | 2 | 0.00 |
| enq: RO - fast object reuse | 6 | 0.00 | 0 | 39 | 0.00 |
| latch: redo writing | 52 | 0.00 | 0 | 4 | 0.00 |
| latch: object queue header operation | 81 | 0.00 | 0 | 2 | 0.00 |
| SQL*Net message to client | 159,003 | 0.00 | 0 | 0 | 0.26 |
| SQL*Net more data from client | 7,310 | 0.00 | 0 | 0 | 0.01 |
| latch: session allocation | 158 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Signal ACK | 15 | 20.00 | 0 | 7 | 0.00 |
| control file sequential read | 2,268 | 0.00 | 0 | 0 | 0.00 |
| latch: checkpoint queue latch | 26 | 0.00 | 0 | 3 | 0.00 |
| latch: cache buffer handles | 46 | 0.00 | 0 | 1 | 0.00 |
| latch: library cache lock | 54 | 0.00 | 0 | 1 | 0.00 |
| cursor: mutex S | 213 | 0.00 | 0 | 0 | 0.00 |
| local write wait | 11 | 0.00 | 0 | 2 | 0.00 |
| SGA: allocation forcing component growth | 2 | 50.00 | 0 | 11 | 0.00 |
| latch: messages | 16 | 0.00 | 0 | 1 | 0.00 |
| PX qref latch | 45 | 48.89 | 0 | 0 | 0.00 |
| cursor: mutex X | 107 | 0.00 | 0 | 0 | 0.00 |
| direct path read | 1,122 | 0.00 | 0 | 0 | 0.00 |
| library cache pin | 6 | 0.00 | 0 | 0 | 0.00 |
| enq: TX - allocate ITL entry | 20 | 0.00 | 0 | 0 | 0.00 |
| direct path write | 527 | 0.00 | 0 | 0 | 0.00 |
| reliable message | 6 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 1 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 7 | 0.00 | 0 | 0 | 0.00 |
| direct path read temp | 3 | 0.00 | 0 | 0 | 0.00 |
| L1 validation | 2 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 158,997 | 0.00 | 97,003 | 610 | 0.26 |
| Streams AQ: waiting for messages in the queue | 1,344 | 98.29 | 9,924 | 7384 | 0.00 |
| pipe get | 1,772 | 99.32 | 7,412 | 4183 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 115 | 32.17 | 2,796 | 24317 | 0.00 |
| PL/SQL lock timer | 210 | 98.57 | 2,649 | 12612 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,100 | 34.09 | 2,465 | 2241 | 0.00 |
| Streams AQ: qmn slave idle wait | 725 | 0.00 | 2,465 | 3400 | 0.00 |
| PX Idle Wait | 1,233 | 97.32 | 2,359 | 1914 | 0.00 |
| jobq slave wait | 468 | 96.79 | 1,365 | 2917 | 0.00 |
| PX Deq: Execution Msg | 421 | 0.00 | 3 | 8 | 0.00 |
| PX Deq: Execute Reply | 183 | 0.00 | 1 | 3 | 0.00 |
| PX Deq Credit: need buffer | 685 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Msg Fragment | 328 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Table Q Normal | 1,201 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Parse Reply | 19 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 24 | 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 | 215,806 | 0.00 | 568 | 3 | 0.35 |
| events in waitclass Other | 13,029 | 0.06 | 11 | 1 | 0.02 |
| control file parallel write | 1,237 | 0.00 | 7 | 5 | 0.00 |
| os thread startup | 41 | 2.44 | 5 | 124 | 0.00 |
| db file sequential read | 122 | 0.00 | 0 | 3 | 0.00 |
| latch: redo writing | 52 | 0.00 | 0 | 4 | 0.00 |
| latch: cache buffers chains | 72 | 0.00 | 0 | 2 | 0.00 |
| db file scattered read | 2 | 0.00 | 0 | 47 | 0.00 |
| control file sequential read | 610 | 0.00 | 0 | 0 | 0.00 |
| latch: In memory undo latch | 10 | 0.00 | 0 | 2 | 0.00 |
| latch: library cache | 2 | 0.00 | 0 | 2 | 0.00 |
| direct path read | 1,110 | 0.00 | 0 | 0 | 0.00 |
| buffer busy waits | 34 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache pin | 1 | 0.00 | 0 | 1 | 0.00 |
| direct path write | 518 | 0.00 | 0 | 0 | 0.00 |
| enq: TX - index contention | 1 | 0.00 | 0 | 0 | 0.00 |
| latch: shared pool | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 344,843 | 2.09 | 20,291 | 59 | 0.55 |
| Streams AQ: waiting for time management or cleanup tasks | 115 | 32.17 | 2,796 | 24317 | 0.00 |
| smon timer | 3,989 | 0.05 | 2,492 | 625 | 0.01 |
| pmon timer | 931 | 99.25 | 2,471 | 2654 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,100 | 34.09 | 2,465 | 2241 | 0.00 |
| Streams AQ: qmn slave idle wait | 725 | 0.00 | 2,465 | 3400 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| BUSY_TIME | 1,352,379 |
| IDLE_TIME | 672,484 |
| IOWAIT_TIME | 18,147 |
| NICE_TIME | 0 |
| SYS_TIME | 29,486 |
| USER_TIME | 1,320,643 |
| LOAD | 1 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 41,564 |
| NUM_CPUS | 8 |
| 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 | 14,665.60 | 13,221.60 | 62,885 | 1,238,748,928 |
| SYS$USERS | 22.10 | 10.90 | 2,880 | 3,944,390 |
| SYS$BACKGROUND | 0.00 | 0.00 | 5,575 | 2,626,062 |
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 |
30066 | 11556 | 2618738 | 36470 | 0 | 0 | 316828 | 323 |
| SYS$USERS |
981 | 398 | 3 | 0 | 0 | 0 | 82 | 0 |
| SYS$BACKGROUND |
3284 | 1221 | 162 | 528 | 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 |
|---|
| 5,647 | 4,872 | 8 | 705.88 | 38.45 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 4,012 | 3,920 | 16 | 250.75 | 27.32 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 3,782 | 3,628 | 49,930 | 0.08 | 25.75 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 2,356 | 2,281 | 49,562 | 0.05 | 16.04 | 4h6x64v79na0t |
FNDWFBG
|
SELECT COUNT(1) FROM RA_CUSTOM... |
| 1,222 | 1,124 | 251 | 4.87 | 8.32 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,130 | 1,081 | 10 | 113.00 | 7.69 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 940 | 757 | 26 | 36.14 | 6.40 | d1swc9auhtxwd |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 651 | 612 | 49,253 | 0.01 | 4.43 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 610 | 482 | 10 | 61.02 | 4.15 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 547 | 538 | 49,990 | 0.01 | 3.72 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 504 | 469 | 149,673 | 0.00 | 3.43 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 296 | 284 | 49,726 | 0.01 | 2.01 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 229 | 207 | 2,812,577 | 0.00 | 1.56 | 66tmsr3446uqn |
SQL*Plus
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 228 | 213 | 48,541 | 0.00 | 1.55 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 222 | 200 | 1,689,295 | 0.00 | 1.51 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 220 | 214 | 202,765 | 0.00 | 1.50 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 194 | 189 | 98,120 | 0.00 | 1.32 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 168 | 163 | 354,599 | 0.00 | 1.14 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 156 | 145 | 1,343,455 | 0.00 | 1.06 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 152 | 143 | 249,243 | 0.00 | 1.04 | ggak0dvtsppv3 |
WSHINTERFACES
|
SELECT /*+ leading(wias) index... |
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 |
|---|
| 4,872 | 5,647 | 8 | 608.97 | 38.45 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 3,920 | 4,012 | 16 | 244.97 | 27.32 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 3,628 | 3,782 | 49,930 | 0.07 | 25.75 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 2,281 | 2,356 | 49,562 | 0.05 | 16.04 | 4h6x64v79na0t |
FNDWFBG
|
SELECT COUNT(1) FROM RA_CUSTOM... |
| 1,124 | 1,222 | 251 | 4.48 | 8.32 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,081 | 1,130 | 10 | 108.07 | 7.69 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 757 | 940 | 26 | 29.12 | 6.40 | d1swc9auhtxwd |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 612 | 651 | 49,253 | 0.01 | 4.43 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 538 | 547 | 49,990 | 0.01 | 3.72 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 482 | 610 | 10 | 48.15 | 4.15 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 469 | 504 | 149,673 | 0.00 | 3.43 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 284 | 296 | 49,726 | 0.01 | 2.01 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 214 | 220 | 202,765 | 0.00 | 1.50 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 213 | 228 | 48,541 | 0.00 | 1.55 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 207 | 229 | 2,812,577 | 0.00 | 1.56 | 66tmsr3446uqn |
SQL*Plus
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 200 | 222 | 1,689,295 | 0.00 | 1.51 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 189 | 194 | 98,120 | 0.00 | 1.32 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 163 | 168 | 354,599 | 0.00 | 1.14 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 145 | 156 | 1,343,455 | 0.00 | 1.06 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 143 | 152 | 249,243 | 0.00 | 1.04 | ggak0dvtsppv3 |
WSHINTERFACES
|
SELECT /*+ leading(wias) index... |
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,245,319,302
- Captured SQL account for 31.1% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 532,371,753 | 16 | 33,273,234.56 | 42.75 | 3919.58 | 4011.95 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 224,536,727 | 8 | 28,067,090.88 | 18.03 | 4871.76 | 5647.07 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 179,668,703 | 10 | 17,966,870.30 | 14.43 | 1080.66 | 1129.98 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 104,270,587 | 49,930 | 2,088.34 | 8.37 | 3627.79 | 3782.08 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 75,586,025 | 149,673 | 505.01 | 6.07 | 469.29 | 503.50 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 71,568,685 | 49,990 | 1,431.66 | 5.75 | 537.93 | 547.11 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 68,842,018 | 251 | 274,270.99 | 5.53 | 1124.35 | 1221.81 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 61,070,332 | 354,599 | 172.22 | 4.90 | 163.36 | 168.13 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 59,262,797 | 49,562 | 1,195.73 | 4.76 | 2281.29 | 2356.25 | 4h6x64v79na0t |
FNDWFBG
|
SELECT COUNT(1) FROM RA_CUSTOM... |
| 54,570,440 | 2,812,577 | 19.40 | 4.38 | 206.81 | 228.84 | 66tmsr3446uqn |
SQL*Plus
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 40,136,776 | 10 | 4,013,677.60 | 3.22 | 481.52 | 610.21 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 37,057,367 | 1,689,295 | 21.94 | 2.98 | 200.14 | 221.67 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 32,542,892 | 26 | 1,251,649.69 | 2.61 | 757.05 | 939.74 | d1swc9auhtxwd |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 25,198,629 | 309,529 | 81.41 | 2.02 | 94.42 | 96.07 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 23,769,731 | 98,120 | 242.25 | 1.91 | 189.48 | 193.85 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 22,955,229 | 1,343,455 | 17.09 | 1.84 | 145.02 | 155.77 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 21,124,339 | 10 | 2,112,433.90 | 1.70 | 126.44 | 132.11 | 7ptvbaycjtbg4 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 20,732,034 | 49,253 | 420.93 | 1.66 | 612.25 | 650.93 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 19,999,956 | 148,917 | 134.30 | 1.61 | 71.85 | 74.72 | 6z9c18cxpxfq0 |
WSHPSGL_SUB
|
SELECT NVL(COMMS_NL_TRACKABLE_... |
| 19,598,284 | 54,998 | 356.35 | 1.57 | 94.61 | 109.86 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 17,083,224 | 3 | 5,694,408.00 | 1.37 | 133.41 | 138.60 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 13,464,518 | 1 | 13,464,518.00 | 1.08 | 91.80 | 98.10 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
| 13,023,413 | 49,998 | 260.48 | 1.05 | 61.60 | 62.60 | 7mz96k4qtxrzr |
WSHPSGL_SUB
|
SELECT BASE.REVISION , BASE.LO... |
| 12,607,278 | 2 | 6,303,639.00 | 1.01 | 97.52 | 100.02 | cqc8bmqp529tz |
RAXTRX
|
begin arp_etax_autoinv_util . ... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 71,326
- Captured SQL account for 13.2% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 16,518 | 1 | 16,518.00 | 23.16 | 91.80 | 98.10 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
| 10,795 | 16 | 674.69 | 15.13 | 3919.58 | 4011.95 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 7,558 | 3 | 2,519.33 | 10.60 | 133.41 | 138.60 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 5,972 | 10 | 597.20 | 8.37 | 1080.66 | 1129.98 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 2,234 | 8 | 279.25 | 3.13 | 4871.76 | 5647.07 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 2,003 | 10 | 200.30 | 2.81 | 481.52 | 610.21 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,891 | 49,930 | 0.04 | 2.65 | 3627.79 | 3782.08 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 1,769 | 251 | 7.05 | 2.48 | 1124.35 | 1221.81 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,516 | 98,120 | 0.02 | 2.13 | 189.48 | 193.85 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 1,294 | 49,562 | 0.03 | 1.81 | 2281.29 | 2356.25 | 4h6x64v79na0t |
FNDWFBG
|
SELECT COUNT(1) FROM RA_CUSTOM... |
| 1,254 | 2 | 627.00 | 1.76 | 97.52 | 100.02 | cqc8bmqp529tz |
RAXTRX
|
begin arp_etax_autoinv_util . ... |
| 1,049 | 98,915 | 0.01 | 1.47 | 23.01 | 30.62 | 7h2mgwhpy4qym |
WSHPSGL_SUB
|
INSERT INTO MTL_ONHAND_QUANTI... |
| 1,022 | 99,938 | 0.01 | 1.43 | 8.04 | 9.53 | 39wym7tugc2sk |
WSHPSGL_SUB
|
SELECT PRIMARY_UOM_CODE, ... |
| 1,016 | 99,990 | 0.01 | 1.42 | 6.03 | 7.82 | 1c0b7sas42w2z |
WSHPSGL_SUB
|
SELECT NVL(ITEM_COST, 0), ... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 45,911,137
- Captured SQL account for 23.8% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,812,577 | 1,527,994 | 0.54 | 0.00 | 0.00 | 66tmsr3446uqn |
SQL*Plus
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 1,689,295 | 1,689,294 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 1,343,455 | 1,343,349 | 1.00 | 0.00 | 0.00 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 397,768 | 399,207 | 1.00 | 0.00 | 0.00 | 7bdg2fscmus2h |
WSHINTERFACES
|
SELECT ACCOUNTING_RULE_ID , A... |
| 354,599 | 0 | 0.00 | 0.00 | 0.00 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 309,529 | 309,790 | 1.00 | 0.00 | 0.00 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 249,243 | 249,723 | 1.00 | 0.00 | 0.00 | ggak0dvtsppv3 |
WSHINTERFACES
|
SELECT /*+ leading(wias) index... |
| 202,765 | 202,362 | 1.00 | 0.00 | 0.00 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 202,714 | 1,228,630 | 6.06 | 0.00 | 0.00 | 8upd356sbxqat |
WSHINTERFACES
|
SELECT LOOKUP_CODE FROM ASO_LO... |
| 199,965 | 199,955 | 1.00 | 0.00 | 0.00 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 2,063,463
- Captured SQL account for 89.3% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 198,879 | 199,892 | 9.64 | ghmx8n7wgqvfr |
WSHINTERFACES
|
begin WF_STANDARD.DEFER (:v1, ... |
| 198,803 | 199,965 | 9.63 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 147,523 | 149,883 | 7.15 | 0mdnts20d60yr |
WSHPSGL_SUB
|
declare
v_ret number := 0... |
| 99,286 | 99,423 | 4.81 | 1v818hwxjxy58 |
WSHINTERFACES
|
select FND_FLEX_VALUES_VL.FLEX... |
| 98,454 | 99,990 | 4.77 | 1c0b7sas42w2z |
WSHPSGL_SUB
|
SELECT NVL(ITEM_COST, 0), ... |
| 59,949 | 59,993 | 2.91 | 76sw2a4vnc89j |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 59,941 | 59,997 | 2.90 | 608c0n36kaw62 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 59,940 | 59,997 | 2.90 | dcvv68fju01g4 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.E... |
| 59,916 | 60,000 | 2.90 | bf7uwg5pa3pj6 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 53,608 | 54,998 | 2.60 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 49,965 | 49,992 | 2.42 | cw171rvngr1w9 |
WSHINTERFACES
|
begin OE_FLEX_COGS_PUB.GET_COS... |
| 49,951 | 49,930 | 2.42 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 49,948 | 49,253 | 2.42 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 49,946 | 49,989 | 2.42 | fvcbstf9s6a5r |
OEHVIMP
|
begin WF_STANDARD.WAITFORFLOW ... |
| 49,930 | 49,999 | 2.42 | 7mrs575bj7a41 |
OEHVIMP
|
begin OE_OEOL_SCH.BRANCH_ON_SO... |
| 49,930 | 49,983 | 2.42 | gdnwgx9fcxggr |
OEHVIMP
|
begin OE_SHIPPING_WF.START_SHI... |
| 49,922 | 49,987 | 2.42 | bfbyqwbr4vwms |
OEHVIMP
|
begin OE_OEOL_SCH.SCHEDULE_LIN... |
| 49,769 | 49,723 | 2.41 | g2qs4xk48vcwy |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 49,332 | 49,998 | 2.39 | 7mz96k4qtxrzr |
WSHPSGL_SUB
|
SELECT BASE.REVISION , BASE.LO... |
| 48,988 | 49,726 | 2.37 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 48,350 | 49,638 | 2.34 | a40f9h91scg23 |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 47,493 | 49,943 | 2.30 | bsuw7pmwrufpy |
INCTCW
|
SELECT
reservation_... |
| 46,859 | 46,859 | 2.27 | 4m7m0t6fjcs5x |
|
update seq$ set increment$=:2,... |
| 44,718 | 44,996 | 2.17 | 7gtztzv329wg0 |
|
select c.name, u.name from co... |
| 44,644 | 44,992 | 2.16 | 2skwhauh2cwky |
|
select o.name, u.name from ob... |
| 21,757 | 21,756 | 1.05 | bsa0wjtftg3uw |
|
select file# from file$ where ... |
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,264,320 | 397,768 | 0.12 | 7bdg2fscmus2h |
WSHINTERFACES
|
SELECT ACCOUNTING_RULE_ID , A... |
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) |
| 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# |
| 39wym7tugc2sk | SELECT PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE, LOT_CONTROL_CODE, SERIAL_NUMBER_CONTROL_CODE, AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER, INVENTORY_ASSET_FLAG, DESCRIPTION, CONCATENATED_SEGMENTS, SHELF_LIFE_CODE, SHELF_LIFE_DAYS, REVISION_QTY_CONTROL_CODE, LOCATION_CONTROL_CODE, DEFAULT_SERIAL_STATUS_ID, DEFAULT_LOT_STATUS_ID, nvl(RECEIVING_ROUTING_ID, -1) RECEIVING_ROUTING_ID, BOM_ITEM_TYPE, BASE_ITEM_ID, EAM_ITEM_TYPE, TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND, CHILD_LOT_FLAG, DEFAULT_GRADE, RETEST_INTERVAL, EXPIRATION_ACTION_INTERVAL, EXPIRATION_ACTION_CODE, MATURITY_DAYS, HOLD_DAYS, SECONDARY_UOM_CODE, GRADE_CONTROL_FLAG, nvl(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS_VL WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 4h6x64v79na0t | SELECT COUNT(1) FROM RA_CUSTOMER_TRX_LINES_ALL RCTL WHERE RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND RCTL.LINE_TYPE = 'LINE' AND RCTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(:B1 ) |
| 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; |
| 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 |
| 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; |
| 7bdg2fscmus2h |
SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB
AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT
EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED
ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI
BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
|
| 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# |
| 7h2mgwhpy4qym | INSERT INTO MTL_ONHAND_QUANTITIES_DETAIL (ONHAND_QUANTITIES_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID, OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE, DATE_RECEIVED, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, PRIMARY_TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE, TRANSACTION_QUANTITY, SECONDARY_UOM_CODE, SECONDARY_TRANSACTION_QUANTITY, SUBINVENTORY_CODE, LOT_NUMBER, REVISION, LOCATOR_ID, CREATE_TRANSACTION_ID, UPDATE_TRANSACTION_ID, ORIG_DATE_RECEIVED, COST_GROUP_ID, LPN_ID, CONTAINERIZED_FLAG, IS_CONSIGNED, PROJECT_ID, TASK_ID) VALUES (MTL_ONHAND_QUANTITIES_S.nextval, :1, :2, decode(nvl(:3, 0), 0, 2, :4), decode(nvl(:5, 0), 0, :6, :7), decode(nvl(:8, 0), 0, 2, :9), nvl(:10, :11), nvl(:12, 2), :13, SYSDATE, :14, SYSDATE, :15, :16, round(:17, 5), :18, round(((:19*:20)/:21), 5), :22, round( NVL(:23, :24), :25) + :26, :27, :28, :29, DECODE(:30, 0, '', :31), :32, :33, :34, :35, :36, nvl(:37, 2), :38, :39, :40) |
| 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; |
| 8upd356sbxqat | SELECT LOOKUP_CODE FROM ASO_LOOKUPS WHERE LOOKUP_TYPE = 'ASO_ORDER_FEEDBACK_CRM_APPS' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE) |
| 8zfgv4ck11dw9 | BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END; |
| 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' |
| cqc8bmqp529tz | begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures ) ; END ; |
| cw171rvngr1w9 | begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end; |
| d1swc9auhtxwd | BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); 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; |
| ggak0dvtsppv3 | SELECT /*+ leading(wias) index(wias, WF_ITEM_ACTIVITY_STATUSES_PK) */ WPA.INSTANCE_ID FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA WHERE WPA.ACTIVITY_ITEM_TYPE = :B2 AND WPA.ACTIVITY_NAME = :B1 AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B4 AND WIAS.ITEM_KEY = :B3 |
| 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; |
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 | 1,329,873 | 525.61 | 2.13 |
| CPU used when call started | 1,328,206 | 524.95 | 2.13 |
| CR blocks created | 13,445,862 | 5,314.25 | 21.58 |
| Cached Commit SCN referenced | 30,126,663 | 11,907.05 | 48.35 |
| Commit SCN cached | 1,317 | 0.52 | 0.00 |
| DB time | 3,686,490 | 1,457.02 | 5.92 |
| DBWR checkpoint buffers written | 2,240,627 | 885.57 | 3.60 |
| DBWR checkpoints | 8 | 0.00 | 0.00 |
| DBWR object drop buffers written | 1,477 | 0.58 | 0.00 |
| DBWR revisited being-written buffer | 59 | 0.02 | 0.00 |
| DBWR thread checkpoint buffers written | 2,240,627 | 885.57 | 3.60 |
| DBWR transaction table writes | 11,178 | 4.42 | 0.02 |
| DBWR undo block writes | 1,076,550 | 425.49 | 1.73 |
| DFO trees parallelized | 4 | 0.00 | 0.00 |
| IMU CR rollbacks | 5,642,455 | 2,230.08 | 9.06 |
| IMU Flushes | 370,526 | 146.44 | 0.59 |
| IMU Redo allocation size | 1,389,088,480 | 549,013.63 | 2,229.53 |
| IMU commits | 303,737 | 120.05 | 0.49 |
| IMU contention | 105,194 | 41.58 | 0.17 |
| IMU ktichg flush | 648 | 0.26 | 0.00 |
| IMU recursive-transaction flush | 95 | 0.04 | 0.00 |
| IMU undo allocation size | 1,978,379,048 | 781,920.72 | 3,175.35 |
| PX local messages recv'd | 5,943 | 2.35 | 0.01 |
| PX local messages sent | 5,943 | 2.35 | 0.01 |
| Parallel operations downgraded 25 to 50 pct | 3 | 0.00 | 0.00 |
| Parallel operations downgraded 50 to 75 pct | 0 | 0.00 | 0.00 |
| Parallel operations not downgraded | 1 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 156,776 | 61.96 | 0.25 |
| active txn count during cleanout | 49,457,492 | 19,547.23 | 79.38 |
| application wait time | 5,816 | 2.30 | 0.01 |
| background checkpoints completed | 2 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 8,058 | 3.18 | 0.01 |
| branch node splits | 538 | 0.21 | 0.00 |
| buffer is not pinned count | 255,798,819 | 101,100.14 | 410.56 |
| buffer is pinned count | 469,608,160 | 185,604.65 | 753.73 |
| bytes received via SQL*Net from client | 53,525,561 | 21,155.07 | 85.91 |
| bytes sent via SQL*Net to client | 343,827,793 | 135,892.10 | 551.85 |
| calls to get snapshot scn: kcmgss | 55,515,103 | 21,941.40 | 89.10 |
| calls to kcmgas | 16,361,750 | 6,466.70 | 26.26 |
| calls to kcmgcs | 2,533,961 | 1,001.51 | 4.07 |
| change write time | 31,558 | 12.47 | 0.05 |
| cleanout - number of ktugct calls | 16,248,737 | 6,422.04 | 26.08 |
| cleanouts and rollbacks - consistent read gets | 12,660,118 | 5,003.70 | 20.32 |
| cleanouts only - consistent read gets | 61,259 | 24.21 | 0.10 |
| cluster key scan block gets | 155,183 | 61.33 | 0.25 |
| cluster key scans | 85,023 | 33.60 | 0.14 |
| commit batch performed | 1 | 0.00 | 0.00 |
| commit batch requested | 1 | 0.00 | 0.00 |
| commit batch/immediate performed | 48,113 | 19.02 | 0.08 |
| commit batch/immediate requested | 48,113 | 19.02 | 0.08 |
| commit cleanout failures: block lost | 179,468 | 70.93 | 0.29 |
| commit cleanout failures: buffer being written | 6,254 | 2.47 | 0.01 |
| commit cleanout failures: callback failure | 79,291 | 31.34 | 0.13 |
| commit cleanout failures: cannot pin | 43,503 | 17.19 | 0.07 |
| commit cleanouts | 7,140,162 | 2,822.03 | 11.46 |
| commit cleanouts successfully completed | 6,831,646 | 2,700.09 | 10.96 |
| commit immediate performed | 48,112 | 19.02 | 0.08 |
| commit immediate requested | 48,112 | 19.02 | 0.08 |
| commit txn count during cleanout | 674,323 | 266.51 | 1.08 |
| concurrency wait time | 36,998 | 14.62 | 0.06 |
| consistent changes | 628,699,407 | 248,482.76 | 1,009.08 |
| consistent gets | 1,116,911,898 | 441,440.46 | 1,792.68 |
| consistent gets - examination | 821,674,132 | 324,752.74 | 1,318.81 |
| consistent gets direct | 41 | 0.02 | 0.00 |
| consistent gets from cache | 1,116,911,857 | 441,440.44 | 1,792.68 |
| cursor authentications | 1,893 | 0.75 | 0.00 |
| data blocks consistent reads - undo records applied | 623,145,737 | 246,287.77 | 1,000.17 |
| db block changes | 124,463,440 | 49,192.06 | 199.77 |
| db block gets | 128,407,404 | 50,750.85 | 206.10 |
| db block gets direct | 345 | 0.14 | 0.00 |
| db block gets from cache | 128,407,059 | 50,750.71 | 206.10 |
| deferred (CURRENT) block cleanout applications | 1,259,483 | 497.79 | 2.02 |
| enqueue conversions | 2,176 | 0.86 | 0.00 |
| enqueue releases | 3,779,346 | 1,493.72 | 6.07 |
| enqueue requests | 3,998,431 | 1,580.31 | 6.42 |
| enqueue timeouts | 219,086 | 86.59 | 0.35 |
| enqueue waits | 34,875 | 13.78 | 0.06 |
| exchange deadlocks | 43,456 | 17.18 | 0.07 |
| execute count | 45,911,137 | 18,145.60 | 73.69 |
| failed probes on index block reclamation | 199,200 | 78.73 | 0.32 |
| free buffer inspected | 552,102 | 218.21 | 0.89 |
| free buffer requested | 16,184,555 | 6,396.67 | 25.98 |
| global undo segment hints helped | 1 | 0.00 | 0.00 |
| heap block compress | 24,462,753 | 9,668.49 | 39.26 |
| immediate (CR) block cleanout applications | 12,721,387 | 5,027.91 | 20.42 |
| immediate (CURRENT) block cleanout applications | 764,358 | 302.10 | 1.23 |
| index crx upgrade (found) | 93,840 | 37.09 | 0.15 |
| index crx upgrade (positioned) | 2,929,656 | 1,157.90 | 4.70 |
| index fast full scans (rowid ranges) | 52 | 0.02 | 0.00 |
| index fetch by key | 73,999,515 | 29,247.05 | 118.77 |
| index scans kdiixs1 | 30,158,160 | 11,919.50 | 48.40 |
| java call heap collected bytes | 817,736,560 | 323,196.49 | 1,312.49 |
| java call heap collected count | 11,070,566 | 4,375.45 | 17.77 |
| java call heap gc count | 2,949 | 1.17 | 0.00 |
| java call heap live object count | 1,215,763 | 480.51 | 1.95 |
| java call heap live object count max | 1,217,412 | 481.16 | 1.95 |
| java call heap live size | 484,854,840 | 191,630.64 | 778.21 |
| java call heap live size max | 484,992,216 | 191,684.94 | 778.43 |
| java call heap object count | 3,239,607 | 1,280.40 | 5.20 |
| java call heap object count max | 3,242,810 | 1,281.67 | 5.20 |
| java call heap total size | 677,511,168 | 267,774.78 | 1,087.42 |
| java call heap total size max | 677,511,168 | 267,774.78 | 1,087.42 |
| java call heap used size | 617,678,016 | 244,126.74 | 991.39 |
| java call heap used size max | 617,957,440 | 244,237.18 | 991.84 |
| leaf node 90-10 splits | 9,571 | 3.78 | 0.02 |
| leaf node splits | 128,199 | 50.67 | 0.21 |
| lob reads | 3,000,748 | 1,185.99 | 4.82 |
| lob writes | 1,310,063 | 517.78 | 2.10 |
| lob writes unaligned | 1,310,063 | 517.78 | 2.10 |
| logons cumulative | 864 | 0.34 | 0.00 |
| messages received | 429,352 | 169.69 | 0.69 |
| messages sent | 429,352 | 169.69 | 0.69 |
| no buffer to keep pinned count | 2 | 0.00 | 0.00 |
| no work - consistent read gets | 265,301,116 | 104,855.76 | 425.82 |
| opened cursors cumulative | 903,358 | 357.04 | 1.45 |
| parse count (failures) | 2 | 0.00 | 0.00 |
| parse count (hard) | 3,340 | 1.32 | 0.01 |
| parse count (total) | 2,063,463 | 815.55 | 3.31 |
| parse time cpu | 3,246 | 1.28 | 0.01 |
| parse time elapsed | 6,034 | 2.38 | 0.01 |
| physical read IO requests | 27,564 | 10.89 | 0.04 |
| physical read bytes | 584,302,592 | 230,935.68 | 937.82 |
| physical read total IO requests | 30,091 | 11.89 | 0.05 |
| physical read total bytes | 623,583,232 | 246,460.68 | 1,000.87 |
| physical read total multi block requests | 5,897 | 2.33 | 0.01 |
| physical reads | 71,326 | 28.19 | 0.11 |
| physical reads cache | 70,123 | 27.71 | 0.11 |
| physical reads cache prefetch | 43,684 | 17.27 | 0.07 |
| physical reads direct | 1,203 | 0.48 | 0.00 |
| physical reads direct (lob) | 48 | 0.02 | 0.00 |
| physical reads direct temporary tablespace | 45 | 0.02 | 0.00 |
| physical reads prefetch warmup | 22,238 | 8.79 | 0.04 |
| physical write IO requests | 757,156 | 299.25 | 1.22 |
| physical write bytes | 18,374,680,576 | 7,262,280.41 | 29,491.88 |
| physical write total IO requests | 957,349 | 378.38 | 1.54 |
| physical write total bytes | 39,592,632,320 | 15,648,315.47 | 63,547.29 |
| physical write total multi block requests | 613,191 | 242.35 | 0.98 |
| physical writes | 2,243,003 | 886.51 | 3.60 |
| physical writes direct | 908 | 0.36 | 0.00 |
| physical writes direct (lob) | 8 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 336 | 0.13 | 0.00 |
| physical writes from cache | 2,242,095 | 886.15 | 3.60 |
| physical writes non checkpoint | 1,416,309 | 559.77 | 2.27 |
| pinned buffers inspected | 2 | 0.00 | 0.00 |
| process last non-idle time | 2,540 | 1.00 | 0.00 |
| queries parallelized | 4 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 5 | 0.00 | 0.00 |
| recursive calls | 83,776,907 | 33,111.40 | 134.46 |
| recursive cpu usage | 1,129,881 | 446.57 | 1.81 |
| redo blocks written | 41,322,560 | 16,332.04 | 66.32 |
| redo entries | 67,288,517 | 26,594.64 | 108.00 |
| redo ordering marks | 848,372 | 335.30 | 1.36 |
| redo size | 20,362,750,928 | 8,048,031.45 | 32,682.79 |
| redo subscn max counts | 1,629,397 | 643.99 | 2.62 |
| redo synch time | 76,557 | 30.26 | 0.12 |
| redo synch writes | 129,847 | 51.32 | 0.21 |
| redo wastage | 97,860,004 | 38,677.50 | 157.07 |
| redo write time | 59,463 | 23.50 | 0.10 |
| redo writer latching time | 751 | 0.30 | 0.00 |
| redo writes | 215,806 | 85.29 | 0.35 |
| rollback changes - undo records applied | 61,227 | 24.20 | 0.10 |
| rollbacks only - consistent read gets | 841,977 | 332.78 | 1.35 |
| rows fetched via callback | 29,470,358 | 11,647.66 | 47.30 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 1,885,421 | 745.18 | 3.03 |
| session logical reads | 1,245,319,302 | 492,191.30 | 1,998.77 |
| session pga memory | 125,962,312 | 49,784.46 | 202.17 |
| session pga memory max | 209,913,928 | 82,964.91 | 336.92 |
| session uga memory | ############### | 83,189,609.23 | 337,830.26 |
| session uga memory max | 9,265,749,832 | 3,662,130.25 | 14,871.79 |
| shared hash latch upgrades - no wait | 22,012,339 | 8,700.00 | 35.33 |
| shared hash latch upgrades - wait | 208,869 | 82.55 | 0.34 |
| sorts (memory) | 4,147,500 | 1,639.23 | 6.66 |
| sorts (rows) | 12,939,417 | 5,114.08 | 20.77 |
| sql area evicted | 38 | 0.02 | 0.00 |
| sql area purged | 20 | 0.01 | 0.00 |
| switch current to new buffer | 1,161,943 | 459.24 | 1.86 |
| table fetch by rowid | 315,762,623 | 124,799.81 | 506.81 |
| table fetch continued row | 10,481,897 | 4,142.79 | 16.82 |
| table scan blocks gotten | 7,182,780 | 2,838.87 | 11.53 |
| table scan rows gotten | 318,844,672 | 126,017.94 | 511.75 |
| table scans (long tables) | 187 | 0.07 | 0.00 |
| table scans (rowid ranges) | 187 | 0.07 | 0.00 |
| table scans (short tables) | 1,382,837 | 546.54 | 2.22 |
| total number of times SMON posted | 3,987 | 1.58 | 0.01 |
| transaction rollbacks | 48,113 | 19.02 | 0.08 |
| transaction tables consistent read rollbacks | 169 | 0.07 | 0.00 |
| transaction tables consistent reads - undo records applied | 244,888 | 96.79 | 0.39 |
| undo change vector size | 7,389,080,036 | 2,920,408.38 | 11,859.68 |
| user I/O wait time | 13,173 | 5.21 | 0.02 |
| user calls | 190,342 | 75.23 | 0.31 |
| user commits | 622,213 | 245.92 | 1.00 |
| user rollbacks | 829 | 0.33 | 0.00 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 1,425,644 | 563.46 | 2.29 |
| write clones created in background | 52 | 0.02 | 0.00 |
| write clones created in foreground | 53,397 | 21.10 | 0.09 |
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 | 7,586 | 45,735 |
| opened cursors current | 2,723 | 2,575 |
| logons current | 86 | 86 |
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) | 0 | 0.00 |
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_IDX |
4,084 | 2 | 5.63 | 3.23 | 273,114 | 108 | 227,027 | 0.16 |
| APPS_UNDOTS1 |
9 | 0 | 2.22 | 1.00 | 187,633 | 74 | 493,645 | 0.14 |
| APPS_TS_TX_DATA |
5,567 | 2 | 3.23 | 5.59 | 151,569 | 60 | 136,194 | 0.29 |
| APPS_TS_INTERFACE |
704 | 0 | 3.78 | 5.78 | 76,950 | 30 | 27,133 | 0.25 |
| APPS_TS_QUEUES |
167 | 0 | 5.09 | 1.58 | 34,269 | 14 | 112,449 | 0.43 |
| APPS_TS_SUMMARY |
102 | 0 | 4.41 | 1.00 | 23,288 | 9 | 41,300 | 0.11 |
| SYSTEM |
14,140 | 6 | 3.36 | 1.02 | 8,368 | 3 | 23,473 | 0.22 |
| SYSAUX |
1,613 | 1 | 7.42 | 2.81 | 1,025 | 0 | 0 | 0.00 |
| APPS_TS_SEED |
858 | 0 | 5.48 | 3.52 | 203 | 0 | 1,735 | 3.88 |
| APPS_TS_ARCHIVE |
32 | 0 | 5.94 | 2.09 | 479 | 0 | 51 | 3.14 |
| APPS_TS_NOLOGGING |
9 | 0 | 3.33 | 1.00 | 131 | 0 | 312 | 0.54 |
| TEMP |
44 | 0 | 0.45 | 7.68 | 17 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
28 | 0 | 2.14 | 1.00 | 14 | 0 | 0 | 0.00 |
| APPS_CALCLIP |
8 | 0 | 5.00 | 1.00 | 8 | 0 | 0 | 0.00 |
| CTXSYS |
12 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| CWMLITE |
10 | 0 | 2.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| DCM |
8 | 0 | 2.50 | 1.00 | 4 | 0 | 0 | 0.00 |
| GEOR_TBS |
8 | 0 | 1.25 | 1.00 | 4 | 0 | 0 | 0.00 |
| B2B_DT |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_IDX |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_LOB |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_RT |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| BAM |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_DOC |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_IDX |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_LOG |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| RE |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYNCSERVER |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| UDDISYS_TS |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| WCRSYS_TS |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| XDB |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| DISCO_PTM5_META |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| HTMLDB |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| IAS_META |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| MTR |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| NOETIX |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OCATS |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| ODM_DATA |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_CT_STORE |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_DEFAULT |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OPMOR |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| ORABPEL |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OWAPUB |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_OMO |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_DISCO |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP |
2 | 0 | 5.00 | 1.00 | 2 | 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 | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip.d |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip1. |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip2. |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip3. |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_OMO | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/omo1.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/archive1.dbf |
32 | 0 | 5.94 | 2.09 | 479 | 0 | 51 | 3.14 |
| APPS_TS_DISCO | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/disco1.dbf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/disco_drake1.d |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
23 | 0 | 3.04 | 6.91 | 3,995 | 2 | 922 | 0.39 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
22 | 0 | 4.55 | 7.18 | 3,694 | 1 | 545 | 0.39 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
24 | 0 | 5.42 | 6.67 | 3,395 | 1 | 877 | 0.38 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
20 | 0 | 2.00 | 7.15 | 3,543 | 1 | 825 | 0.06 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
24 | 0 | 3.75 | 7.17 | 3,487 | 1 | 744 | 0.23 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
24 | 0 | 3.75 | 6.33 | 2,906 | 1 | 577 | 0.26 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
20 | 0 | 4.50 | 7.15 | 3,114 | 1 | 714 | 0.42 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 5.20 | 6.84 | 3,030 | 1 | 403 | 0.92 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
23 | 0 | 3.91 | 6.48 | 3,291 | 1 | 788 | 0.23 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 5.60 | 6.92 | 3,003 | 1 | 1,258 | 0.21 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
30 | 0 | 4.67 | 2.90 | 1,064 | 0 | 372 | 0.13 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
120 | 0 | 4.50 | 3.73 | 1,282 | 1 | 1,465 | 0.24 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
37 | 0 | 2.97 | 6.81 | 4,965 | 2 | 3,179 | 0.14 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
32 | 0 | 2.50 | 7.31 | 3,965 | 2 | 1,844 | 0.30 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 5.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
39 | 0 | 2.82 | 6.36 | 4,341 | 2 | 2,122 | 0.34 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 2.80 | 6.92 | 3,974 | 2 | 2,158 | 0.17 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 3.20 | 6.92 | 3,933 | 2 | 1,481 | 0.18 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 3.60 | 6.72 | 4,073 | 2 | 2,209 | 0.22 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
23 | 0 | 2.61 | 7.04 | 4,304 | 2 | 1,503 | 0.24 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
25 | 0 | 4.40 | 6.88 | 3,833 | 2 | 1,355 | 0.21 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
26 | 0 | 4.62 | 6.27 | 3,736 | 1 | 761 | 0.50 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
27 | 0 | 3.33 | 6.19 | 3,992 | 2 | 1,031 | 0.22 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media1.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media2.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media3.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media4.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media5.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media6.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media7.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/nologging1.dbf |
9 | 0 | 3.33 | 1.00 | 131 | 0 | 312 | 0.54 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues1.dbf |
13 | 0 | 5.38 | 1.62 | 4,584 | 2 | 16,292 | 0.42 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues2.dbf |
13 | 0 | 5.38 | 1.00 | 4,956 | 2 | 16,481 | 0.48 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues3.dbf |
9 | 0 | 6.67 | 1.00 | 5,090 | 2 | 15,151 | 0.40 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues4.dbf |
16 | 0 | 5.63 | 1.44 | 4,314 | 2 | 15,098 | 0.38 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues5.dbf |
15 | 0 | 5.33 | 1.93 | 3,965 | 2 | 15,013 | 0.39 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues6.dbf |
86 | 0 | 5.00 | 1.66 | 6,718 | 3 | 17,454 | 0.44 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues7.dbf |
15 | 0 | 3.33 | 1.73 | 4,642 | 2 | 16,960 | 0.46 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference1.dbf |
193 | 0 | 3.52 | 1.07 | 43 | 0 | 298 | 2.92 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference2.dbf |
124 | 0 | 5.73 | 3.85 | 39 | 0 | 235 | 3.32 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference3.dbf |
106 | 0 | 6.60 | 4.40 | 38 | 0 | 245 | 4.78 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference4.dbf |
117 | 0 | 5.81 | 4.57 | 32 | 0 | 349 | 3.84 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference5.dbf |
318 | 0 | 6.07 | 4.19 | 51 | 0 | 608 | 4.23 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary1.dbf |
5 | 0 | 4.00 | 1.00 | 2,199 | 1 | 4,642 | 0.09 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary10.dbf |
8 | 0 | 3.75 | 1.00 | 1,826 | 1 | 3,089 | 0.12 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary11.dbf |
6 | 0 | 5.00 | 1.00 | 1,841 | 1 | 3,012 | 0.13 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary12.dbf |
5 | 0 | 4.00 | 1.00 | 1,883 | 1 | 2,753 | 0.08 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary13.dbf |
4 | 0 | 2.50 | 1.00 | 1,854 | 1 | 3,269 | 0.17 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary2.dbf |
5 | 0 | 4.00 | 1.00 | 1,649 | 1 | 3,126 | 0.10 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary3.dbf |
32 | 0 | 5.00 | 1.00 | 1,142 | 0 | 1,448 | 0.09 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary4.dbf |
7 | 0 | 4.29 | 1.00 | 1,737 | 1 | 2,451 | 0.09 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary5.dbf |
5 | 0 | 4.00 | 1.00 | 1,640 | 1 | 3,052 | 0.11 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary6.dbf |
9 | 0 | 3.33 | 1.00 | 1,831 | 1 | 3,308 | 0.09 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary7.dbf |
7 | 0 | 5.71 | 1.00 | 1,977 | 1 | 3,017 | 0.11 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary8.dbf |
4 | 0 | 2.50 | 1.00 | 1,773 | 1 | 3,360 | 0.12 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary9.dbf |
5 | 0 | 6.00 | 1.00 | 1,936 | 1 | 4,773 | 0.15 |
| APPS_TS_TOOLS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_tools0 |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data1.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data10.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data11.dbf |
85 | 0 | 3.06 | 7.21 | 3,325 | 1 | 2,578 | 0.33 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data12.dbf |
91 | 0 | 3.63 | 6.90 | 3,473 | 1 | 3,460 | 0.17 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data13.dbf |
248 | 0 | 2.26 | 2.50 | 3,572 | 1 | 2,961 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data14.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data15.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data16.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data17.dbf |
4 | 0 | 0.00 | 1.00 | 239 | 0 | 38 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data18.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data19.dbf |
51 | 0 | 2.55 | 6.73 | 316 | 0 | 21 | 0.48 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data2.dbf |
96 | 0 | 3.02 | 6.52 | 3,519 | 1 | 3,479 | 0.16 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data20.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data21.dbf |
97 | 0 | 3.61 | 6.38 | 3,524 | 1 | 3,336 | 0.32 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data22.dbf |
92 | 0 | 2.93 | 6.76 | 1,327 | 1 | 1,139 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data23.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data24.dbf |
9 | 0 | 3.33 | 2.44 | 301 | 0 | 61 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data25.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data26.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data27.dbf |
173 | 0 | 5.20 | 2.83 | 1,385 | 1 | 2,097 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data28.dbf |
79 | 0 | 5.57 | 2.75 | 429 | 0 | 112 | 2.14 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data29.dbf |
27 | 0 | 6.30 | 2.30 | 260 | 0 | 272 | 1.10 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data3.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data30.dbf |
22 | 0 | 4.55 | 1.64 | 141 | 0 | 47 | 1.28 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data31.dbf |
26 | 0 | 4.23 | 1.27 | 287 | 0 | 108 | 1.67 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data32.dbf |
165 | 0 | 4.30 | 5.73 | 1,311 | 1 | 1,362 | 0.54 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data33.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data34.dbf |
10 | 0 | 4.00 | 2.30 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data35.dbf |
8 | 0 | 2.50 | 2.63 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data36.dbf |
9 | 0 | 3.33 | 2.44 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data37.dbf |
10 | 0 | 5.00 | 2.80 | 318 | 0 | 110 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data38.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data39.dbf |
131 | 0 | 4.05 | 6.41 | 1,486 | 1 | 1,316 | 0.56 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data4.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data40.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data41.dbf |
12 | 0 | 5.83 | 2.58 | 317 | 0 | 50 | 0.20 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data42.dbf |
7 | 0 | 4.29 | 2.86 | 314 | 0 | 13 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data43.dbf |
144 | 0 | 3.75 | 6.00 | 4,225 | 2 | 3,841 | 0.36 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data44.dbf |
137 | 0 | 4.60 | 6.46 | 4,161 | 2 | 4,657 | 0.29 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data45.dbf |
127 | 0 | 3.54 | 6.80 | 4,384 | 2 | 4,077 | 0.33 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data46.dbf |
119 | 0 | 4.37 | 6.99 | 4,024 | 2 | 3,304 | 0.37 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data47.dbf |
122 | 0 | 3.69 | 6.56 | 3,712 | 1 | 3,718 | 0.24 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data48.dbf |
110 | 0 | 3.27 | 6.92 | 3,755 | 1 | 3,489 | 0.29 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data49.dbf |
106 | 0 | 3.30 | 6.83 | 3,736 | 1 | 3,349 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data5.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data50.dbf |
116 | 0 | 3.36 | 6.71 | 3,438 | 1 | 3,472 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data51.dbf |
109 | 0 | 3.39 | 6.61 | 3,424 | 1 | 3,584 | 0.22 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data52.dbf |
6 | 0 | 3.33 | 3.33 | 272 | 0 | 70 | 0.14 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data53.dbf |
241 | 0 | 1.70 | 2.86 | 3,456 | 1 | 3,372 | 0.15 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data54.dbf |
108 | 0 | 3.70 | 6.82 | 3,384 | 1 | 2,803 | 0.19 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data55.dbf |
97 | 0 | 3.20 | 7.01 | 3,269 | 1 | 2,514 | 0.59 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data56.dbf |
246 | 0 | 1.83 | 2.68 | 3,375 | 1 | 3,110 | 0.22 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data57.dbf |
102 | 0 | 4.02 | 6.97 | 3,427 | 1 | 2,625 | 0.30 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data58.dbf |
101 | 0 | 3.07 | 6.93 | 3,397 | 1 | 2,899 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data59.dbf |
95 | 0 | 3.05 | 6.91 | 3,516 | 1 | 2,766 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data6.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data60.dbf |
99 | 0 | 3.43 | 6.81 | 3,769 | 1 | 3,314 | 0.51 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data61.dbf |
97 | 0 | 3.71 | 7.08 | 3,575 | 1 | 3,993 | 0.24 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data62.dbf |
91 | 0 | 3.30 | 7.21 | 3,553 | 1 | 3,202 | 0.23 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data63.dbf |
94 | 0 | 2.66 | 6.99 | 3,440 | 1 | 3,242 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data64.dbf |
100 | 0 | 3.00 | 6.60 | 3,361 | 1 | 3,889 | 0.16 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data65.dbf |
97 | 0 | 3.20 | 6.93 | 3,425 | 1 | 3,091 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data66.dbf |
97 | 0 | 2.99 | 6.94 | 3,509 | 1 | 2,787 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data67.dbf |
95 | 0 | 2.95 | 6.85 | 3,306 | 1 | 2,527 | 0.29 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data68.dbf |
99 | 0 | 2.93 | 6.63 | 3,324 | 1 | 3,103 | 0.22 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data69.dbf |
245 | 0 | 1.84 | 2.65 | 3,566 | 1 | 3,696 | 0.22 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data7.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data70.dbf |
92 | 0 | 3.37 | 7.02 | 3,486 | 1 | 2,930 | 0.23 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data71.dbf |
92 | 0 | 4.02 | 6.66 | 3,715 | 1 | 2,724 | 0.99 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data72.dbf |
98 | 0 | 2.96 | 6.20 | 3,578 | 1 | 3,387 | 0.17 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data73.dbf |
87 | 0 | 3.45 | 6.86 | 3,672 | 1 | 2,734 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data74.dbf |
87 | 0 | 2.41 | 6.95 | 3,455 | 1 | 2,900 | 0.89 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data75.dbf |
83 | 0 | 2.77 | 7.08 | 3,374 | 1 | 2,768 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data76.dbf |
91 | 0 | 2.86 | 6.42 | 3,520 | 1 | 3,006 | 0.18 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data77.dbf |
92 | 0 | 3.91 | 6.67 | 3,746 | 1 | 3,853 | 0.20 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data78.dbf |
87 | 0 | 2.76 | 6.86 | 3,350 | 1 | 2,838 | 0.12 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data8.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data9.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx1.dbf |
38 | 0 | 7.63 | 4.34 | 5,430 | 2 | 4,098 | 0.16 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx10.dbf |
49 | 0 | 7.14 | 4.98 | 4,994 | 2 | 3,785 | 0.10 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx11.dbf |
45 | 0 | 7.11 | 5.18 | 5,267 | 2 | 4,004 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx12.dbf |
36 | 0 | 5.83 | 4.75 | 5,201 | 2 | 4,244 | 0.15 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx13.dbf |
41 | 0 | 7.56 | 4.56 | 5,290 | 2 | 4,474 | 0.17 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx14.dbf |
42 | 0 | 8.57 | 3.57 | 5,266 | 2 | 4,218 | 0.09 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx15.dbf |
39 | 0 | 6.67 | 5.10 | 5,369 | 2 | 3,817 | 0.08 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx16.dbf |
42 | 0 | 6.67 | 4.67 | 5,056 | 2 | 3,678 | 0.15 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx17.dbf |
108 | 0 | 2.41 | 1.00 | 5,090 | 2 | 3,679 | 0.12 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx18.dbf |
96 | 0 | 3.65 | 1.00 | 4,899 | 2 | 3,323 | 0.09 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx19.dbf |
41 | 0 | 6.34 | 3.46 | 5,106 | 2 | 3,169 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx2.dbf |
32 | 0 | 6.56 | 5.59 | 5,045 | 2 | 28,051 | 0.30 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx20.dbf |
40 | 0 | 4.25 | 4.65 | 5,245 | 2 | 2,842 | 0.19 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx21.dbf |
36 | 0 | 6.39 | 4.14 | 4,493 | 2 | 3,317 | 0.21 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx22.dbf |
34 | 0 | 5.59 | 4.62 | 4,611 | 2 | 3,448 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx23.dbf |
27 | 0 | 7.04 | 5.19 | 4,694 | 2 | 3,664 | 0.11 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx24.dbf |
25 | 0 | 8.80 | 5.80 | 4,932 | 2 | 3,568 | 0.08 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx25.dbf |
30 | 0 | 6.67 | 4.73 | 4,337 | 2 | 2,961 | 0.08 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx26.dbf |
29 | 0 | 7.59 | 4.31 | 4,579 | 2 | 11,179 | 0.09 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx27.dbf |
934 | 0 | 4.96 | 2.22 | 11,815 | 5 | 15,638 | 0.21 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx28.dbf |
391 | 0 | 2.86 | 1.00 | 3,362 | 1 | 943 | 0.51 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx29.dbf |
235 | 0 | 5.57 | 2.94 | 9,934 | 4 | 10,224 | 0.10 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx3.dbf |
78 | 0 | 9.49 | 5.06 | 7,768 | 3 | 4,104 | 0.13 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx30.dbf |
67 | 0 | 6.57 | 4.66 | 7,027 | 3 | 4,064 | 0.09 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx31.dbf |
83 | 0 | 8.19 | 4.31 | 7,536 | 3 | 4,511 | 0.22 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx32.dbf |
92 | 0 | 6.63 | 4.05 | 7,629 | 3 | 4,050 | 0.08 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx33.dbf |
109 | 0 | 6.24 | 4.01 | 8,059 | 3 | 3,862 | 0.17 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx34.dbf |
71 | 0 | 6.90 | 4.89 | 7,334 | 3 | 4,197 | 0.12 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx35.dbf |
215 | 0 | 2.33 | 1.00 | 7,938 | 3 | 7,730 | 0.13 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx36.dbf |
52 | 0 | 7.31 | 4.63 | 6,722 | 3 | 4,587 | 0.16 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx37.dbf |
67 | 0 | 5.82 | 3.22 | 7,112 | 3 | 5,141 | 0.07 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx38.dbf |
49 | 0 | 6.73 | 4.73 | 6,655 | 3 | 3,783 | 0.09 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx39.dbf |
60 | 0 | 5.33 | 4.03 | 6,168 | 2 | 3,474 | 0.10 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx4.dbf |
41 | 0 | 7.32 | 5.68 | 5,116 | 2 | 3,051 | 0.17 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx40.dbf |
57 | 0 | 8.25 | 4.33 | 5,444 | 2 | 3,380 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx41.dbf |
52 | 0 | 7.50 | 4.52 | 5,314 | 2 | 3,137 | 0.13 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx42.dbf |
54 | 0 | 6.85 | 4.89 | 5,123 | 2 | 3,049 | 0.16 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx43.dbf |
53 | 0 | 7.17 | 4.81 | 5,482 | 2 | 3,459 | 0.10 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx44.dbf |
52 | 0 | 6.54 | 4.88 | 5,631 | 2 | 3,339 | 0.11 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx45.dbf |
54 | 0 | 5.74 | 5.19 | 5,150 | 2 | 3,684 | 0.13 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx46.dbf |
44 | 0 | 6.59 | 4.45 | 5,234 | 2 | 3,716 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx47.dbf |
36 | 0 | 8.06 | 4.72 | 4,875 | 2 | 3,969 | 0.15 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx48.dbf |
42 | 0 | 12.14 | 5.26 | 5,301 | 2 | 3,944 | 0.14 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx49.dbf |
42 | 0 | 5.24 | 3.86 | 5,364 | 2 | 4,041 | 0.15 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx5.dbf |
42 | 0 | 8.33 | 4.90 | 1,898 | 1 | 635 | 0.11 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx6.dbf |
46 | 0 | 6.30 | 4.46 | 5,136 | 2 | 4,278 | 0.20 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx7.dbf |
54 | 0 | 6.48 | 3.69 | 4,818 | 2 | 4,284 | 0.11 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx8.dbf |
42 | 0 | 5.95 | 5.24 | 1,705 | 1 | 590 | 0.58 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx9.dbf |
40 | 0 | 9.75 | 4.85 | 1,560 | 1 | 644 | 0.12 |
| APPS_UNDOTS1 | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/undo.dbf |
3 | 0 | 6.67 | 1.00 | 93,870 | 37 | 239,588 | 0.14 |
| APPS_UNDOTS1 | /oracle/visdata/undo1.dbf |
6 | 0 | 0.00 | 1.00 | 93,763 | 37 | 254,057 | 0.13 |
| B2B_DT | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_dt.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_idx.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_LOB | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_lob.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| B2B_RT | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_rt.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| BAM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/bam.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| CTXSYS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ctx1.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| CTXSYS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ctx2.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| CWMLITE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/cwmlite01.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| CWMLITE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/cwmlite02.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| DCM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/dcm.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| DCM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/dcm1.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/discopltc1.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| DISCO_PTM5_META | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/discopltm1.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/oss_sys01.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_spatia |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/geor_tbs02.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| HTMLDB | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/htmldb.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| IAS_META | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ias_meta01.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| MTR | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opmtr01.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| NOETIX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/noetix.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/non_apps_data1 |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OCATS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/oca.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| ODM_DATA | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/odm.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/attrs1_oid.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/battrs1_oid.db |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_CT_STORE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/gcats1_oid.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_DEFAULT | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/gdefault1_oid. |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/svrmg1_oid.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OPMOR | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opmor01.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| ORABPEL | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/orabpel.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OWAPUB | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/owa1.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/portal.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_DOC | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptldoc.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_IDX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptlidx.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| PORTAL_LOG | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptllog.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| RE | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opre01.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYNCSERVER | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/mobile01.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| SYSAUX | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sysaux01.dbf |
1,613 | 1 | 7.42 | 2.81 | 1,025 | 0 | 0 | 0.00 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys1.dbf |
1,341 | 1 | 3.01 | 1.00 | 501 | 0 | 176 | 1.25 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys10.dbf |
2,115 | 1 | 3.02 | 1.00 | 746 | 0 | 34 | 0.59 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys2.dbf |
2,234 | 1 | 2.60 | 1.01 | 281 | 0 | 458 | 0.41 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys3.dbf |
1,261 | 0 | 4.23 | 1.09 | 1,644 | 1 | 6,145 | 0.22 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys4.dbf |
1,160 | 0 | 3.66 | 1.03 | 1,739 | 1 | 5,963 | 0.21 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys5.dbf |
1,297 | 1 | 3.17 | 1.00 | 1,576 | 1 | 4,497 | 0.15 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys6.dbf |
882 | 0 | 3.89 | 1.01 | 611 | 0 | 1,872 | 0.17 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys7.dbf |
1,473 | 1 | 3.74 | 1.02 | 548 | 0 | 3,258 | 0.22 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys8.dbf |
1,086 | 0 | 3.79 | 1.01 | 251 | 0 | 469 | 0.43 |
| SYSTEM | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys9.dbf |
1,291 | 1 | 3.49 | 1.00 | 471 | 0 | 601 | 0.25 |
| TEMP | /oracle/visdata/temp1.dbf |
4 | 0 | 2.50 | 11.50 | 3 | 0 | 0 | |
| TEMP | /oracle/visdata/temp2.dbf |
40 | 0 | 0.25 | 7.30 | 14 | 0 | 0 | |
| UDDISYS_TS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/uddisys01.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
| WCRSYS_TS | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/wcrsys01.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| XDB | /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/xdb01.dbf |
6 | 0 | 1.67 | 1.00 | 2 | 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 | 2,901,214 | 100 | 1,232,577,851 | 70,130 | 2,242,095 | 0 | 0 | 1,063,313 |
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 | 26 | 3548 | 99363 | 100000 | 45298440 | | 100000 |
| E | 0 | 27 | 4886 | 99099 | 100000 | 45298440 | 11883173 | 100000 |
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 | 2,336 | 0.10 | 288,934 | 1.06 | 459,106 |
| D | 4,672 | 0.20 | 577,868 | 1.03 | 446,226 |
| D | 7,008 | 0.30 | 866,802 | 1.03 | 443,356 |
| D | 9,344 | 0.40 | 1,155,736 | 1.00 | 433,680 |
| D | 11,680 | 0.50 | 1,444,670 | 1.00 | 432,051 |
| D | 14,016 | 0.60 | 1,733,604 | 1.00 | 431,630 |
| D | 16,352 | 0.70 | 2,022,538 | 1.00 | 431,630 |
| D | 18,688 | 0.80 | 2,311,472 | 1.00 | 431,630 |
| D | 21,024 | 0.90 | 2,600,406 | 1.00 | 431,630 |
| D | 23,360 | 1.00 | 2,889,340 | 1.00 | 431,630 |
| D | 23,456 | 1.00 | 2,901,214 | 1.00 | 431,630 |
| D | 25,696 | 1.10 | 3,178,274 | 1.00 | 431,630 |
| D | 28,032 | 1.20 | 3,467,208 | 1.00 | 431,630 |
| D | 30,368 | 1.29 | 3,756,142 | 1.00 | 431,630 |
| D | 32,704 | 1.39 | 4,045,076 | 1.00 | 431,630 |
| D | 35,040 | 1.49 | 4,334,010 | 1.00 | 431,630 |
| D | 37,376 | 1.59 | 4,622,944 | 1.00 | 431,630 |
| D | 39,712 | 1.69 | 4,911,878 | 1.00 | 431,630 |
| D | 42,048 | 1.79 | 5,200,812 | 1.00 | 431,630 |
| D | 44,384 | 1.89 | 5,489,746 | 1.00 | 431,630 |
| D | 46,720 | 1.99 | 5,778,680 | 0.99 | 429,188 |
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.99 | 80,158 | 8 |
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 | 4,096 | 3,539 | 298.73 | 0.00 | 0.00 | 0.00 | 0.00 | 419,430 |
| E | 4,096 | 3,535 | 295.43 | 0.00 | 0.00 | 0.00 | 0.00 | 419,430 |
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,341,124 | 1,341,124 | 0 | 0 |
| 64K | 128K | 1,759 | 1,759 | 0 | 0 |
| 128K | 256K | 1,083 | 1,083 | 0 | 0 |
| 256K | 512K | 152 | 152 | 0 | 0 |
| 512K | 1024K | 31,124 | 31,124 | 0 | 0 |
| 1M | 2M | 46,752 | 46,752 | 0 | 0 |
| 2M | 4M | 287 | 285 | 2 | 0 |
| 4M | 8M | 17 | 17 | 0 | 0 |
| 8M | 16M | 12 | 12 | 0 | 0 |
| 16M | 32M | 4 | 4 | 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 |
|---|
| 512 | 0.13 | 86,821.57 | 215.87 | 100.00 | 54 |
| 1,024 | 0.25 | 86,821.57 | 179.02 | 100.00 | 40 |
| 2,048 | 0.50 | 86,821.57 | 106.84 | 100.00 | 7 |
| 3,072 | 0.75 | 86,821.57 | 0.00 | 100.00 | 0 |
| 4,096 | 1.00 | 86,821.57 | 0.00 | 100.00 | 0 |
| 4,915 | 1.20 | 86,821.57 | 0.00 | 100.00 | 0 |
| 5,734 | 1.40 | 86,821.57 | 0.00 | 100.00 | 0 |
| 6,554 | 1.60 | 86,821.57 | 0.00 | 100.00 | 0 |
| 7,373 | 1.80 | 86,821.57 | 0.00 | 100.00 | 0 |
| 8,192 | 2.00 | 86,821.57 | 0.00 | 100.00 | 0 |
| 12,288 | 3.00 | 86,821.57 | 0.00 | 100.00 | 0 |
| 16,384 | 4.00 | 86,821.57 | 0.00 | 100.00 | 0 |
| 24,576 | 6.00 | 86,821.57 | 0.00 | 100.00 | 0 |
| 32,768 | 8.00 | 86,821.57 | 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 |
|---|
| 464 | 0.45 | 122 | 6,985 | 810,404 | 1.00 | 157 | 1.16 | 45,940,799 |
| 576 | 0.56 | 231 | 11,794 | 810,425 | 1.00 | 136 | 1.01 | 45,942,455 |
| 688 | 0.67 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 800 | 0.78 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 912 | 0.89 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,024 | 1.00 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,136 | 1.11 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,248 | 1.22 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,360 | 1.33 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,472 | 1.44 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,584 | 1.55 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,696 | 1.66 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,808 | 1.77 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 1,920 | 1.88 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 2,032 | 1.98 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
| 2,144 | 2.09 | 283 | 16,013 | 810,426 | 1.00 | 135 | 1.00 | 45,942,558 |
Back to Advisory Statistics
Back to Top
SGA Target Advisory
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|
| 6,144 | 0.25 | 15,037 | 446,156 |
| 12,288 | 0.50 | 15,009 | 431,999 |
| 18,432 | 0.75 | 15,007 | 431,611 |
| 24,576 | 1.00 | 15,007 | 431,611 |
| 30,720 | 1.25 | 15,007 | 431,611 |
| 36,864 | 1.50 | 15,007 | 431,611 |
| 43,008 | 1.75 | 15,007 | 431,611 |
| 49,152 | 2.00 | 15,002 | 429,151 |
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 | 0.50 | 0 | 0 | 0 | 0 |
| 32 | 1.00 | 0 | 0 | 0 | 0 |
| 48 | 1.50 | 0 | 0 | 0 | 0 |
| 64 | 2.00 | 0 | 0 | 0 | 0 |
| 80 | 2.50 | 0 | 0 | 0 | 0 |
| 96 | 3.00 | 0 | 0 | 0 | 0 |
| 112 | 3.50 | 0 | 0 | 0 | 0 |
| 128 | 4.00 | 0 | 0 | 0 | 0 |
| 144 | 4.50 | 0 | 0 | 0 | 0 |
| 160 | 5.00 | 0 | 0 | 0 | 0 |
| 176 | 5.50 | 0 | 0 | 0 | 0 |
| 192 | 6.00 | 0 | 0 | 0 | 0 |
| 208 | 6.50 | 0 | 0 | 0 | 0 |
| 224 | 7.00 | 0 | 0 | 0 | 0 |
| 240 | 7.50 | 0 | 0 | 0 | 0 |
| 256 | 8.00 | 0 | 0 | 0 | 0 |
| 272 | 8.50 | 0 | 0 | 0 | 0 |
| 288 | 9.00 | 0 | 0 | 0 | 0 |
| 304 | 9.50 | 0 | 0 | 0 | 0 |
| 320 | 10.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.50 | 8 | 274 | 6 | 1.00 | 135 | 1.00 | 360 |
| 32 | 1.00 | 8 | 274 | 6 | 1.00 | 135 | 1.00 | 360 |
| 48 | 1.50 | 8 | 274 | 6 | 1.00 | 135 | 1.00 | 360 |
| 64 | 2.00 | 8 | 274 | 6 | 1.00 | 135 | 1.00 | 360 |
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 | 539,442 | 143 | 0 |
| undo block | 448,160 | 49 | 0 |
| undo header | 45,487 | 17 | 0 |
| 1st level bmb | 23,771 | 3 | 0 |
| segment header | 5,988 | 1 | 0 |
| 2nd level bmb | 404 | 0 | 1 |
| extent map | 68 | 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) |
224,662 | 6,102 | 218,568 | 6,102 | 58 | 9.54 |
| TX-Transaction (index contention) |
13,219 | 13,219 | 0 | 13,187 | 14 | 1.03 |
| TX-Transaction |
899,503 | 899,531 | 0 | 5,181 | 6 | 1.13 |
| HW-Segment High Water Mark |
79,056 | 79,046 | 10 | 5,014 | 4 | 0.78 |
| SQ-Sequence Cache |
36,127 | 36,127 | 0 | 4,256 | 1 | 0.27 |
| FB-Format Block |
21,255 | 21,255 | 0 | 1,114 | 1 | 0.79 |
| RO-Multiple Object Reuse (fast object reuse) |
54 | 54 | 0 | 6 | 0 | 38.33 |
| TX-Transaction (allocate ITL entry) |
17 | 17 | 0 | 14 | 0 | 0.00 |
| PS-PX Process Reservation |
160 | 136 | 24 | 1 | 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,019.33 | 886,177 | 1,225 | 20 | 47.9/52.2166666666666666666666666666666666667 | 0/0 | 0/0/0/17/52672/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 |
|---|
| 25-Aug 14:36 | 146,489 | 58,079 | 0 | 13 | 52 | 0/0 | 0/0/0/17/52672/0 |
| 25-Aug 14:26 | 225,506 | 169,122 | 256 | 15 | 48 | 0/0 | 0/0/0/0/0/0 |
| 25-Aug 14:16 | 246,809 | 299,381 | 1,225 | 16 | 48 | 0/0 | 0/0/0/0/0/0 |
| 25-Aug 14:06 | 400,527 | 359,595 | 619 | 20 | 49 | 0/0 | 0/0/0/0/0/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 | 1,970 | 0.00 | | 0 | 0 | |
| AWR Alerted Metric Element list | 22,199 | 0.00 | | 0 | 0 | |
| Consistent RBA | 215,880 | 0.01 | 0.00 | 0 | 0 | |
| FOB s.o list latch | 17,426 | 0.08 | 0.00 | 0 | 0 | |
| In memory undo latch | 610,347,012 | 0.82 | 0.00 | 9 | 680,431 | 0.13 |
| JOX SGA heap latch | 1,819,192 | 0.00 | 0.30 | 0 | 4,553 | 0.09 |
| JS queue state obj latch | 15,120 | 0.00 | | 0 | 0 | |
| JS slv state obj latch | 117 | 0.00 | | 0 | 0 | |
| KMG MMAN ready and startup request latch | 1,177 | 0.00 | | 0 | 0 | |
| KMG resize request state object freelist | 2 | 0.00 | | 0 | 0 | |
| KTF sga latch | 8 | 0.00 | | 0 | 816 | 0.00 |
| KWQMN job cache list latch | 206,455 | 1.28 | 0.24 | 0 | 0 | |
| KWQP Prop Status | 315 | 0.00 | | 0 | 0 | |
| MQL Tracking Latch | 0 | | | 0 | 50 | 0.00 |
| Memory Management Latch | 355 | 0.00 | | 0 | 1,175 | 0.09 |
| Mutex Stats | 1 | 0.00 | | 0 | 0 | |
| NLS data objects | 11 | 81.82 | 1.00 | 0 | 0 | |
| OS process | 2,661 | 0.00 | | 0 | 0 | |
| OS process allocation | 2,616 | 0.00 | | 0 | 0 | |
| OS process: request allocation | 1,582 | 0.06 | 0.00 | 0 | 0 | |
| PL/SQL warning settings | 1,279,569 | 0.00 | | 0 | 0 | |
| Policy Hash Table Latch | 9 | 0.00 | | 0 | 0 | |
| SGA IO buffer pool latch | 43,306 | 0.00 | | 0 | 48,278 | 0.00 |
| SQL memory manager latch | 1 | 0.00 | | 0 | 839 | 0.00 |
| SQL memory manager workarea list latch | 1,962,890 | 0.03 | 0.00 | 0 | 0 | |
| Shared B-Tree | 1,634 | 0.00 | | 0 | 0 | |
| Undo Hint Latch | 0 | | | 0 | 16 | 0.00 |
| active checkpoint queue latch | 210,451 | 0.00 | | 0 | 0 | |
| active service list | 8,177 | 0.45 | 0.03 | 0 | 930 | 0.00 |
| begin backup scn array | 14 | 0.00 | | 0 | 0 | |
| bq:time manger info latch | 90 | 0.00 | | 0 | 0 | |
| buffer pool | 2 | 0.00 | | 0 | 0 | |
| bufq statistics | 3 | 0.00 | | 0 | 0 | |
| cache buffer handles | 4,713,860 | 0.65 | 0.00 | 0 | 0 | |
| cache buffers chains | 3,203,511,034 | 2.17 | 0.02 | 66 | 11,636,552 | 4.74 |
| cache buffers lru chain | 6,979,658 | 0.60 | 0.01 | 2 | 29,326,843 | 1.10 |
| cache table scan latch | 0 | | | 0 | 3,246 | 0.03 |
| channel handle pool latch | 11,520 | 0.05 | 0.00 | 0 | 0 | |
| channel operations parent latch | 62,658 | 0.11 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 6,894,524 | 0.02 | 0.02 | 0 | 2,261,586 | 0.03 |
| client/application info | 7,717 | 0.04 | 0.00 | 0 | 0 | |
| commit callback allocation | 222,228 | 0.23 | 0.00 | 0 | 0 | |
| compile environment latch | 23,530 | 0.00 | | 0 | 0 | |
| dictionary lookup | 12 | 0.00 | | 0 | 0 | |
| dml lock allocation | 5,010,220 | 2.26 | 0.00 | 0 | 0 | |
| dummy allocation | 1,744 | 0.86 | 0.00 | 0 | 0 | |
| enqueue hash chains | 7,831,112 | 1.39 | 0.00 | 0 | 225 | 0.00 |
| enqueues | 1,143,338 | 0.49 | 0.00 | 0 | 0 | |
| error message lists | 68 | 16.18 | 0.00 | 0 | 0 | |
| event group latch | 791 | 0.00 | | 0 | 0 | |
| file cache latch | 22,573 | 0.01 | 0.00 | 0 | 0 | |
| first spare latch | 746,485 | 3.65 | 0.00 | 0 | 0 | |
| global KZLD latch for mem in SGA | 742 | 0.00 | | 0 | 0 | |
| global ctx hash table latch | 271,704 | 0.00 | | 0 | 0 | |
| hash table column usage latch | 1,950 | 0.00 | | 0 | 518,725 | 0.00 |
| hash table modification latch | 133 | 1.50 | 0.00 | 0 | 0 | |
| internal temp table object number allocation latc | 3 | 0.00 | | 0 | 0 | |
| job workq parent latch | 0 | | | 0 | 98 | 0.00 |
| job_queue_processes parameter latch | 91 | 0.00 | | 0 | 0 | |
| kks stats | 5,832 | 0.00 | | 0 | 0 | |
| ksuosstats global area | 170 | 0.00 | | 0 | 0 | |
| ktm global data | 3,989 | 0.00 | | 0 | 0 | |
| kwqbsn:qsga | 1,540 | 0.00 | | 0 | 0 | |
| kwqi:kchunk latch | 2 | 0.00 | | 0 | 0 | |
| lgwr LWN SCN | 216,774 | 0.15 | 0.00 | 0 | 0 | |
| library cache | 90,642,461 | 2.01 | 0.00 | 2 | 75 | 0.00 |
| library cache load lock | 18,839 | 0.84 | 0.08 | 0 | 97 | 0.00 |
| library cache lock | 13,203,788 | 1.20 | 0.00 | 0 | 0 | |
| library cache lock allocation | 85,060 | 0.01 | 0.00 | 0 | 0 | |
| library cache pin | 57,888,940 | 1.57 | 0.00 | 1 | 0 | |
| library cache pin allocation | 28,456 | 0.00 | | 0 | 0 | |
| list of block allocation | 262,035 | 0.16 | 0.00 | 0 | 0 | |
| loader state object freelist | 6,226 | 0.00 | | 0 | 0 | |
| logminer context allocation | 1 | 0.00 | | 0 | 0 | |
| longop free list parent | 3 | 0.00 | | 0 | 3 | 0.00 |
| message pool operations parent latch | 10,688 | 0.04 | 0.00 | 0 | 0 | |
| messages | 1,280,500 | 0.47 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 227,376 | 3.98 | 0.01 | 0 | 0 | |
| multiblock read objects | 12,234 | 0.01 | 0.00 | 0 | 0 | |
| ncodef allocation latch | 48 | 0.00 | | 0 | 0 | |
| object queue header heap | 869,003 | 0.00 | 0.00 | 0 | 11,473 | 0.01 |
| object queue header operation | 12,749,159 | 0.08 | 0.01 | 0 | 1,967 | 0.00 |
| object stats modification | 11,470 | 0.02 | 0.00 | 0 | 0 | |
| parallel query alloc buffer | 944 | 1.69 | 0.00 | 0 | 0 | |
| parallel query stats | 44 | 38.64 | 0.00 | 0 | 0 | |
| parameter list | 2,405 | 0.00 | | 0 | 0 | |
| parameter table allocation management | 884 | 2.60 | 0.35 | 0 | 0 | |
| post/wait queue | 337,895 | 0.07 | 0.05 | 0 | 166,014 | 1.20 |
| process allocation | 1,586 | 0.00 | | 0 | 791 | 0.00 |
| process group creation | 1,582 | 0.00 | | 0 | 0 | |
| process queue | 408 | 2.21 | 0.00 | 0 | 0 | |
| process queue reference | 88,507 | 0.09 | 0.00 | 0 | 8,989 | 0.50 |
| qmn task queue latch | 2,715 | 0.00 | | 0 | 0 | |
| query server freelists | 348 | 7.18 | 0.00 | 0 | 0 | |
| query server process | 8 | 0.00 | | 0 | 8 | 0.00 |
| redo allocation | 2,245,886 | 1.87 | 0.03 | 1 | 67,225,886 | 1.49 |
| redo copy | 0 | | | 0 | 67,289,204 | 0.02 |
| redo writing | 1,042,163 | 0.01 | 0.44 | 0 | 0 | |
| resmgr group change latch | 5,055 | 0.00 | | 0 | 0 | |
| resmgr:actses active list | 2,480 | 0.00 | | 0 | 0 | |
| resmgr:actses change group | 2,298 | 0.00 | | 0 | 0 | |
| resmgr:free threads list | 1,742 | 1.32 | 0.00 | 0 | 0 | |
| resmgr:schema config | 1 | 0.00 | | 0 | 0 | |
| row cache objects | 35,948,163 | 1.48 | 0.00 | 0 | 4 | 0.00 |
| rules engine aggregate statistics | 105,001 | 4.67 | 0.00 | 0 | 0 | |
| rules engine evaluation context statistics | 2 | 0.00 | | 0 | 0 | |
| rules engine rule set statistics | 418,144 | 2.10 | 0.00 | 0 | 0 | |
| rules engine rule statistics | 209,926 | 0.00 | | 0 | 0 | |
| sequence cache | 6,426,683 | 1.82 | 0.00 | 0 | 0 | |
| session allocation | 7,418,157 | 1.34 | 0.00 | 0 | 0 | |
| session idle bit | 403,368 | 0.00 | 0.00 | 0 | 0 | |
| session state list latch | 4,705 | 0.47 | 0.00 | 0 | 0 | |
| session switching | 48 | 0.00 | | 0 | 0 | |
| session timer | 930 | 0.00 | | 0 | 0 | |
| shared pool | 13,192,368 | 1.26 | 0.00 | 0 | 0 | |
| shared pool sim alloc | 401 | 0.00 | | 0 | 0 | |
| shared pool simulator | 5,350,802 | 0.01 | 0.00 | 0 | 0 | |
| simulator hash latch | 95,931,221 | 0.01 | 0.00 | 0 | 0 | |
| simulator lru latch | 95,648,342 | 2.07 | 0.00 | 4 | 96,277 | 0.25 |
| slave class | 1 | 0.00 | | 0 | 0 | |
| slave class create | 4 | 0.00 | | 0 | 0 | |
| sort extent pool | 36,086 | 0.05 | 0.05 | 0 | 0 | |
| state object free list | 2 | 0.00 | | 0 | 0 | |
| statistics aggregation | 84 | 0.00 | | 0 | 0 | |
| temporary table state object allocation | 754 | 0.00 | | 0 | 0 | |
| threshold alerts latch | 986 | 0.00 | | 0 | 0 | |
| trace latch | 4 | 0.00 | | 0 | 0 | |
| transaction allocation | 19,875 | 0.00 | | 0 | 0 | |
| transaction branch allocation | 48 | 0.00 | | 0 | 0 | |
| undo global data | 707,514,732 | 2.42 | 0.00 | 2 | 0 | |
| user lock | 3,066 | 0.07 | 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,203,511,034 | 69,637,312 | 1,515,007 | 68,187,654 | 0 | 0 | 0 |
| undo global data |
707,514,732 | 17,148,113 | 7,481 | 17,142,159 | 0 | 0 | 0 |
| In memory undo latch |
610,347,012 | 5,005,911 | 18,561 | 4,988,977 | 0 | 0 | 0 |
| simulator lru latch |
95,648,342 | 1,975,912 | 3,799 | 1,972,858 | 0 | 0 | 0 |
| library cache |
90,642,461 | 1,819,292 | 1,485 | 1,818,100 | 0 | 0 | 0 |
| library cache pin |
57,888,940 | 911,156 | 528 | 910,725 | 0 | 0 | 0 |
| row cache objects |
35,948,163 | 532,065 | 377 | 531,766 | 0 | 0 | 0 |
| shared pool |
13,192,368 | 166,803 | 289 | 166,556 | 0 | 0 | 0 |
| library cache lock |
13,203,788 | 158,396 | 54 | 158,351 | 0 | 0 | 0 |
| sequence cache |
6,426,683 | 116,805 | 28 | 116,781 | 0 | 0 | 0 |
| dml lock allocation |
5,010,220 | 113,063 | 101 | 112,977 | 0 | 0 | 0 |
| enqueue hash chains |
7,831,112 | 108,669 | 122 | 108,565 | 0 | 0 | 0 |
| session allocation |
7,418,157 | 99,676 | 158 | 99,540 | 0 | 0 | 0 |
| redo allocation |
2,245,886 | 42,062 | 1,220 | 40,983 | 0 | 0 | 0 |
| cache buffers lru chain |
6,979,658 | 42,020 | 323 | 41,711 | 0 | 0 | 0 |
| cache buffer handles |
4,713,860 | 30,623 | 46 | 30,578 | 0 | 0 | 0 |
| first spare latch |
746,485 | 27,215 | 64 | 27,164 | 0 | 0 | 0 |
| simulator hash latch |
95,931,221 | 12,230 | 25 | 12,210 | 0 | 0 | 0 |
| object queue header operation |
12,749,159 | 10,395 | 81 | 10,321 | 0 | 0 | 0 |
| mostly latch-free SCN |
227,376 | 9,050 | 68 | 8,993 | 0 | 0 | 0 |
| rules engine rule set statistics |
418,144 | 8,790 | 1 | 8,789 | 0 | 0 | 0 |
| messages |
1,280,500 | 6,057 | 16 | 6,042 | 0 | 0 | 0 |
| enqueues |
1,143,338 | 5,630 | 6 | 5,625 | 0 | 0 | 0 |
| KWQMN job cache list latch |
206,455 | 2,647 | 647 | 2,003 | 0 | 0 | 0 |
| checkpoint queue latch |
6,894,524 | 1,580 | 26 | 1,554 | 0 | 0 | 0 |
| shared pool simulator |
5,350,802 | 657 | 2 | 655 | 0 | 0 | 0 |
| SQL memory manager workarea list latch |
1,962,890 | 539 | 1 | 538 | 0 | 0 | 0 |
| post/wait queue |
337,895 | 249 | 12 | 237 | 0 | 0 | 0 |
| library cache load lock |
18,839 | 158 | 12 | 146 | 0 | 0 | 0 |
| redo writing |
1,042,163 | 119 | 52 | 67 | 0 | 0 | 0 |
| active service list |
8,177 | 37 | 1 | 36 | 0 | 0 | 0 |
| parameter table allocation management |
884 | 23 | 8 | 15 | 0 | 0 | 0 |
| sort extent pool |
36,086 | 19 | 1 | 18 | 0 | 0 | 0 |
| JOX SGA heap latch |
1,819,192 | 10 | 3 | 7 | 0 | 0 | 0 |
| NLS data objects |
11 | 9 | 9 | 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 | 9,879 | 7,201 |
| In memory undo latch | kturbk | 0 | 4,747 | 5,967 |
| In memory undo latch | ktichg: child | 0 | 1,989 | 3,739 |
| In memory undo latch | kticmt: child | 0 | 1,593 | 461 |
| In memory undo latch | ktiTxnPoolFree | 0 | 269 | 2 |
| In memory undo latch | ktbgfc | 0 | 58 | 1,190 |
| In memory undo latch | ktiBRacquire | 0 | 24 | 0 |
| In memory undo latch | ktuswr | 0 | 2 | 1 |
| KWQMN job cache list latch | kwqmnuji: update job item | 0 | 1,636 | 1,636 |
| NLS data objects | klcslod | 0 | 9 | 9 |
| SQL memory manager workarea list latch | qesmmIUnRegisterWorkArea | 0 | 1 | 0 |
| active service list | ksws_event: ksws event | 0 | 15 | 13 |
| cache buffer handles | kcbzgs | 0 | 32 | 27 |
| cache buffer handles | kcbzfs | 0 | 14 | 19 |
| cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 2,070,278 | 2,296,893 |
| cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 684,302 | 1,300,140 |
| cache buffers chains | kcbgtcr: fast path | 0 | 518,445 | 21,182 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 483,541 | 250,101 |
| cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 121,351 | 0 |
| cache buffers chains | kcbgcur: kslbegin | 0 | 45,783 | 23,364 |
| cache buffers chains | kcbget: pin buffer | 0 | 19,101 | 8,199 |
| cache buffers chains | kcbzwb | 0 | 7,758 | 15,247 |
| cache buffers chains | kcbrls: kslbegin | 0 | 5,700 | 56,261 |
| cache buffers chains | kcbnlc | 0 | 2,174 | 4,112 |
| cache buffers chains | kcbcge | 0 | 2,145 | 11,432 |
| cache buffers chains | kcbget: exchange rls | 0 | 1,024 | 1,209 |
| cache buffers chains | kcbget: exchange | 0 | 903 | 1,414 |
| cache buffers chains | kcb_is_private | 0 | 302 | 4,176 |
| cache buffers chains | kcbbxsv | 0 | 78 | 35 |
| cache buffers chains | kcbbic2 | 0 | 31 | 17 |
| cache buffers chains | kcbbic1 | 0 | 28 | 27 |
| cache buffers chains | kcbso1: set no access | 0 | 24 | 34 |
| cache buffers chains | kcbesc: escalate | 0 | 16 | 3 |
| cache buffers chains | kcbgtcr: kslbegin shared | 0 | 14 | 8 |
| cache buffers chains | kcbnew: new latch again | 0 | 13 | 1 |
| cache buffers chains | kcb_post_apply: kcbhq62 | 0 | 11 | 183 |
| cache buffers chains | kcb_pre_apply: kcbhq61 | 0 | 8 | 1,215 |
| cache buffers chains | kcbzhngcbk1: get hash chain latch no wait | 0 | 2 | 0 |
| cache buffers chains | kcbgkcbcr | 0 | 1 | 0 |
| cache buffers lru chain | kcbzgws | 0 | 181 | 0 |
| cache buffers lru chain | kcbgtcr:CR Scan:KCBRSKIP | 0 | 106 | 0 |
| cache buffers lru chain | kcbzgb: posted for free bufs | 0 | 28 | 74 |
| cache buffers lru chain | kcbzswcu | 0 | 3 | 15 |
| cache buffers lru chain | kcbbxsv: move to being written | 0 | 2 | 52 |
| cache buffers lru chain | kcbbic2 | 0 | 1 | 182 |
| cache buffers lru chain | kcbzgpwb: KSLBEGIN use prewarm buffers | 0 | 1 | 0 |
| cache buffers lru chain | kcbzib | 0 | 1 | 0 |
| channel handle pool latch | ksrchconnect() | 0 | 2 | 1 |
| channel operations parent latch | ksrchdelete() | 0 | 2 | 1 |
| checkpoint queue latch | kcbswcu: Switch buffers | 0 | 13 | 4 |
| checkpoint queue latch | kcbklbc: Link buffer into ckpt queue | 0 | 12 | 0 |
| checkpoint queue latch | kcbbwthc: thread checkpoint buffers | 0 | 1 | 11 |
| dml lock allocation | ktaiam | 0 | 80 | 75 |
| dml lock allocation | ktaidm | 0 | 21 | 26 |
| enqueue hash chains | ksqgtl3 | 0 | 87 | 72 |
| enqueue hash chains | ksqrcl | 0 | 30 | 50 |
| enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 5 | 0 |
| enqueues | ksqgel: create enqueue | 0 | 5 | 6 |
| enqueues | ksqdel | 0 | 1 | 0 |
| event range base latch | No latch | 0 | 67 | 67 |
| lgwr LWN SCN | kcs023 | 0 | 26 | 0 |
| library cache | kglpnp: child | 0 | 525 | 710 |
| library cache | kglpndl: child: after processing | 0 | 449 | 46 |
| library cache | kglpndl: child: before processing | 0 | 235 | 350 |
| library cache | kglobpn: child: | 0 | 157 | 315 |
| library cache | kglScanDependency | 0 | 39 | 0 |
| library cache | kglLockCursor | 0 | 24 | 26 |
| library cache | kglget: unpin heap 0 | 0 | 17 | 7 |
| library cache | kglhdgn: child: | 0 | 13 | 15 |
| library cache | kgldti: 2child | 0 | 6 | 3 |
| library cache | kglpin | 0 | 6 | 1 |
| library cache | kglhdgc: child: | 0 | 3 | 4 |
| library cache | kglhdgh: child: | 0 | 2 | 6 |
| library cache | kglati | 0 | 1 | 0 |
| library cache | kgldte: child 0 | 0 | 1 | 0 |
| library cache | kglkep: child | 0 | 1 | 0 |
| library cache load lock | kglllal: llatch: in loop | 0 | 7 | 8 |
| library cache load lock | kglllal: llatch | 0 | 5 | 4 |
| library cache lock | kgllkal: child: multiinstance | 0 | 28 | 30 |
| library cache lock | kgllkdl: child: cleanup | 0 | 26 | 24 |
| library cache lock | kgllkdl: child: no lock handle | 0 | 6 | 3 |
| library cache pin | kglpnp: child | 0 | 268 | 288 |
| library cache pin | kglpndl | 0 | 220 | 143 |
| library cache pin | kglpnal: child: alloc space | 0 | 39 | 97 |
| library cache pin | kglpnck | 0 | 1 | 0 |
| messages | ksaamb: after wakeup | 0 | 14 | 10 |
| messages | ksarcv | 0 | 1 | 5 |
| messages | ksarcv: after wait | 0 | 1 | 1 |
| mostly latch-free SCN | kcslcu3 | 0 | 41 | 67 |
| object queue header operation | kcbw_link_q | 0 | 751 | 45 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 86 | 273 |
| object queue header operation | kcbo_switch_cq | 0 | 35 | 324 |
| object queue header operation | kcbo_switch_q_bg | 0 | 34 | 4 |
| object queue header operation | kcbo_swap_buf | 0 | 14 | 119 |
| object queue header operation | kcbw_unlink_q | 0 | 14 | 27 |
| object queue header operation | kcbo_ivbo | 0 | 2 | 13 |
| object queue header operation | kcbo_swap_buf_bg | 0 | 2 | 133 |
| parameter table allocation management | ksp_param_table_free | 0 | 8 | 8 |
| post/wait queue | ksliwat:remove | 0 | 7 | 5 |
| post/wait queue | ksliwat:add:nowait | 0 | 3 | 0 |
| post/wait queue | kslpstevent:get | 0 | 1 | 5 |
| post/wait queue | kslpstevent:reget | 0 | 1 | 2 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 1,028 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 134 | 643 |
| redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 34 | 0 |
| redo allocation | kcrfw_redo_write: before write | 0 | 14 | 165 |
| redo allocation | kcrfw_redo_write: more space | 0 | 10 | 421 |
| redo writing | kcrfw_post: rba scn pair | 0 | 28 | 0 |
| redo writing | kcrfw_cal_target_rba | 0 | 15 | 0 |
| redo writing | kcrfw_post: after write | 0 | 9 | 0 |
| row cache objects | kqrpre: find obj | 0 | 182 | 305 |
| row cache objects | kqreqd: reget | 0 | 158 | 3 |
| row cache objects | kqreqd | 0 | 35 | 70 |
| row cache objects | kqrcmt: while loop | 0 | 2 | 0 |
| rules engine rule set statistics | kwrsosb: begin collect rs stats | 0 | 1 | 1 |
| sequence cache | kdnssd | 0 | 13 | 2 |
| sequence cache | kdnnxt: cached seq | 0 | 9 | 4 |
| sequence cache | kdnss | 0 | 6 | 21 |
| session allocation | ksuprc | 0 | 61 | 61 |
| session allocation | ksuxds: KSUSFCLC not set | 0 | 46 | 20 |
| session allocation | ksudlc | 0 | 41 | 62 |
| session allocation | ksucri | 0 | 4 | 5 |
| session allocation | ksursi | 0 | 2 | 1 |
| session allocation | kxfpqidqr | 0 | 2 | 5 |
| session allocation | ksucrp | 0 | 1 | 0 |
| session allocation | ksudlp | 0 | 1 | 2 |
| shared pool | kghalo | 0 | 178 | 171 |
| shared pool | kghfre | 0 | 79 | 67 |
| shared pool | kghupr1 | 0 | 30 | 53 |
| shared pool | kghalp | 0 | 2 | 0 |
| shared pool simulator | kglsim_unpin_simhp | 0 | 2 | 2 |
| simulator hash latch | kcbsacc: lookup dba | 0 | 25 | 21 |
| simulator lru latch | kcbs_simulate: simulate set | 0 | 3,772 | 3,548 |
| simulator lru latch | kcbs_simbufseq | 0 | 23 | 251 |
| simulator lru latch | kcbs_shrink_pool | 0 | 3 | 0 |
| simulator lru latch | kcbs_resize_pool : interpolation | 0 | 1 | 0 |
| sort extent pool | ktstdt: dealloc sort extent | 0 | 1 | 0 |
| undo global data | kturimugur: child | 0 | 6,390 | 4,438 |
| undo global data | ktudba: KSLBEGIN | 0 | 1,030 | 2,957 |
| undo global data | ktudnx:child | 0 | 34 | 43 |
| undo global data | ktubnd:child | 0 | 15 | 2 |
| undo global data | ktufrbs: child | 0 | 10 | 40 |
| undo global data | ktusmasp: ktugd_tuux | 0 | 1 | 0 |
Back to Latch Statistics
Back to Top
|
