|
|
|
AWR Report
WORKLOAD REPOSITORY report for
| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|
| VIS | 193532335 | VIS | 1 | 10.2.0.3.0 | NO | db |
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|
| Begin Snap: | 2593 | 10-Sep-08 18:56:00 | 91 | 29.5 |
| End Snap: | 2594 | 10-Sep-08 19:44:41 | 92 | 29.6 |
| Elapsed: | | 48.69 (mins) | | |
| DB Time: | | 305.61 (mins) | | |
Report Summary
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 8,192M | 8,192M | Std Block Size: | 8K |
| Shared Pool Size: | 2,048M | 2,048M | Log Buffer: | 14,340K |
Load Profile
| Per Second | Per Transaction |
|---|
| Redo size: | 7,112,301.32 | 34,003.35 |
| Logical reads: | 461,064.18 | 2,204.31 |
| Block changes: | 43,185.47 | 206.47 |
| Physical reads: | 20.17 | 0.10 |
| Physical writes: | 536.93 | 2.57 |
| User calls: | 58.26 | 0.28 |
| Parses: | 673.93 | 3.22 |
| Hard parses: | 0.22 | 0.00 |
| Sorts: | 1,614.12 | 7.72 |
| Logons: | 0.15 | 0.00 |
| Executes: | 15,595.63 | 74.56 |
| Transactions: | 209.16 | |
| % Blocks changed per Read: | 9.37 | Recursive Call %: | 99.79 |
| Rollback per transaction %: | 0.15 | Rows per Sort: | 3.17 |
Instance Efficiency Percentages (Target 100%)
| Buffer Nowait %: | 99.92 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 100.00 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.99 | Soft Parse %: | 99.97 |
| Execute to Parse %: | 95.68 | Latch Hit %: | 98.00 |
| Parse CPU to Parse Elapsd %: | 25.44 | % Non-Parse CPU: | 99.85 |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 33.24 | 33.80 |
| % SQL with executions>1: | 94.64 | 91.51 |
| % Memory for SQL w/exec>1: | 95.50 | 95.21 |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|
| CPU time | | 8,481 | | 46.3 | |
| log file parallel write | 451,803 | 374 | 1 | 2.0 | System I/O |
| log file sync | 101,895 | 357 | 4 | 1.9 | Commit |
| buffer busy waits | 1,051,355 | 357 | 0 | 1.9 | Concurrency |
| db file sequential read | 43,580 | 168 | 4 | .9 | 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): 18336.8s
- Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
- Ordered by % or DB time desc, Statistic name
| Statistic Name | Time (s) | % of DB Time |
|---|
| sql execute elapsed time | 18,326.16 | 99.94 |
| DB CPU | 8,481.13 | 46.25 |
| PL/SQL execution elapsed time | 4,200.96 | 22.91 |
| Java execution elapsed time | 543.84 | 2.97 |
| parse time elapsed | 64.99 | 0.35 |
| sequence load elapsed time | 11.18 | 0.06 |
| hard parse elapsed time | 7.56 | 0.04 |
| repeated bind elapsed time | 5.76 | 0.03 |
| connection management call elapsed time | 0.93 | 0.01 |
| PL/SQL compilation elapsed time | 0.57 | 0.00 |
| hard parse (sharing criteria) elapsed time | 0.49 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.02 | 0.00 |
| inbound PL/SQL rpc elapsed time | 0.01 | 0.00 |
| DB time | 18,336.84 | |
| background elapsed time | 771.86 | |
| background cpu time | 126.80 | |
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 |
|---|
| Concurrency | 1,115,431 | 0.03 | 554 | 0 | 1.83 |
| System I/O | 568,869 | 0.00 | 509 | 1 | 0.93 |
| Commit | 101,895 | 0.00 | 357 | 4 | 0.17 |
| User I/O | 53,160 | 0.00 | 184 | 3 | 0.09 |
| Application | 15,137 | 0.00 | 135 | 9 | 0.02 |
| Other | 156,592 | 37.00 | 65 | 0 | 0.26 |
| Configuration | 20,019 | 43.13 | 10 | 0 | 0.03 |
| Network | 304,801 | 0.00 | 2 | 0 | 0.50 |
Back to Wait Events Statistics
Back to Top
Wait Events
- s - second
- cs - centisecond - 100th of a second
- ms - millisecond - 1000th of a second
- us - microsecond - 1000000th of a second
- ordered by wait time desc, waits desc (idle events last)
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
|---|
| log file parallel write | 451,803 | 0.00 | 374 | 1 | 0.74 |
| log file sync | 101,895 | 0.00 | 357 | 4 | 0.17 |
| buffer busy waits | 1,051,355 | 0.00 | 357 | 0 | 1.72 |
| db file sequential read | 43,580 | 0.00 | 168 | 4 | 0.07 |
| enq: TX - row lock contention | 14,319 | 0.00 | 134 | 9 | 0.02 |
| db file parallel write | 113,275 | 0.00 | 133 | 1 | 0.19 |
| latch: cache buffers chains | 34,293 | 0.00 | 73 | 2 | 0.06 |
| enq: TX - index contention | 20,634 | 0.00 | 42 | 2 | 0.03 |
| latch: library cache | 2,850 | 0.00 | 40 | 14 | 0.00 |
| latch free | 2,184 | 0.00 | 19 | 9 | 0.00 |
| read by other session | 6,251 | 0.00 | 14 | 2 | 0.01 |
| enq: TX - contention | 8,417 | 0.00 | 14 | 2 | 0.01 |
| latch: library cache pin | 1,020 | 0.00 | 13 | 13 | 0.00 |
| latch: In memory undo latch | 2,631 | 0.00 | 9 | 3 | 0.00 |
| enq: HW - contention | 6,204 | 0.00 | 9 | 1 | 0.01 |
| latch: shared pool | 674 | 0.00 | 6 | 9 | 0.00 |
| LGWR wait for redo copy | 22,028 | 0.27 | 6 | 0 | 0.04 |
| latch: row cache objects | 564 | 0.00 | 6 | 10 | 0.00 |
| cursor: pin S wait on X | 366 | 88.80 | 5 | 15 | 0.00 |
| latch: undo global data | 2,006 | 0.00 | 5 | 2 | 0.00 |
| latch: redo allocation | 934 | 0.00 | 4 | 5 | 0.00 |
| buffer deadlock | 32,123 | 99.57 | 4 | 0 | 0.05 |
| latch: session allocation | 251 | 0.00 | 3 | 12 | 0.00 |
| latch: library cache lock | 130 | 0.00 | 3 | 21 | 0.00 |
| latch: enqueue hash chains | 189 | 0.00 | 3 | 14 | 0.00 |
| db file scattered read | 1,898 | 0.00 | 3 | 1 | 0.00 |
| enq: FB - contention | 2,005 | 0.00 | 2 | 1 | 0.00 |
| control file parallel write | 1,420 | 0.00 | 2 | 1 | 0.00 |
| rdbms ipc reply | 1,001 | 0.00 | 2 | 2 | 0.00 |
| latch: cache buffers lru chain | 270 | 0.00 | 2 | 6 | 0.00 |
| SQL*Net more data to client | 152,186 | 0.00 | 1 | 0 | 0.25 |
| enq: SQ - contention | 5,121 | 0.00 | 1 | 0 | 0.01 |
| cursor: pin S | 57,089 | 0.00 | 1 | 0 | 0.09 |
| kksfbc child completion | 14 | 92.86 | 1 | 45 | 0.00 |
| control file sequential read | 2,371 | 0.00 | 0 | 0 | 0.00 |
| PX Deq Credit: send blkd | 2,028 | 0.00 | 0 | 0 | 0.00 |
| os thread startup | 17 | 0.00 | 0 | 20 | 0.00 |
| PX Deq: Signal ACK | 22 | 50.00 | 0 | 13 | 0.00 |
| SQL*Net break/reset to client | 790 | 0.00 | 0 | 0 | 0.00 |
| row cache lock | 890 | 0.00 | 0 | 0 | 0.00 |
| latch: object queue header operation | 55 | 0.00 | 0 | 2 | 0.00 |
| latch: checkpoint queue latch | 7 | 0.00 | 0 | 18 | 0.00 |
| direct path read | 1,118 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net more data from client | 7,278 | 0.00 | 0 | 0 | 0.01 |
| enq: RO - fast object reuse | 28 | 0.00 | 0 | 3 | 0.00 |
| SQL*Net message to client | 145,337 | 0.00 | 0 | 0 | 0.24 |
| local write wait | 44 | 0.00 | 0 | 2 | 0.00 |
| undo segment extension | 8,648 | 99.84 | 0 | 0 | 0.01 |
| library cache lock | 3 | 0.00 | 0 | 11 | 0.00 |
| PX qref latch | 25,923 | 99.81 | 0 | 0 | 0.04 |
| direct path write | 265 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 8 | 0.00 | 0 | 3 | 0.00 |
| reliable message | 20 | 0.00 | 0 | 1 | 0.00 |
| wait list latch free | 1 | 0.00 | 0 | 10 | 0.00 |
| L1 validation | 4 | 25.00 | 0 | 2 | 0.00 |
| latch: cache buffer handles | 7 | 0.00 | 0 | 1 | 0.00 |
| latch: messages | 6 | 0.00 | 0 | 1 | 0.00 |
| enq: TX - allocate ITL entry | 38 | 0.00 | 0 | 0 | 0.00 |
| direct path write temp | 4 | 0.00 | 0 | 0 | 0.00 |
| enq: PS - contention | 8 | 0.00 | 0 | 0 | 0.00 |
| cursor: mutex X | 4 | 0.00 | 0 | 0 | 0.00 |
| SQL*Net message from client | 145,336 | 0.00 | 96,438 | 664 | 0.24 |
| Streams AQ: waiting for messages in the queue | 1,552 | 98.97 | 11,426 | 7362 | 0.00 |
| pipe get | 1,849 | 100.00 | 5,703 | 3084 | 0.00 |
| Streams AQ: waiting for time management or cleanup tasks | 88 | 39.77 | 3,520 | 40002 | 0.00 |
| PL/SQL lock timer | 531 | 99.44 | 3,212 | 6048 | 0.00 |
| Streams AQ: qmn slave idle wait | 444 | 0.00 | 2,842 | 6401 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,135 | 39.12 | 2,842 | 2504 | 0.00 |
| PX Idle Wait | 1,241 | 96.70 | 2,358 | 1900 | 0.00 |
| jobq slave wait | 206 | 98.06 | 600 | 2911 | 0.00 |
| PX Deq: Execution Msg | 506 | 0.00 | 5 | 10 | 0.00 |
| PX Deq: Execute Reply | 228 | 0.00 | 0 | 2 | 0.00 |
| PX Deq: Msg Fragment | 343 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Table Q Normal | 1,248 | 0.00 | 0 | 0 | 0.00 |
| PX Deq Credit: need buffer | 617 | 0.00 | 0 | 0 | 0.00 |
| PX Deq: Parse Reply | 23 | 0.00 | 0 | 1 | 0.00 |
| PX Deq: Join ACK | 21 | 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 | 451,803 | 0.00 | 374 | 1 | 0.74 |
| db file parallel write | 113,275 | 0.00 | 133 | 1 | 0.19 |
| events in waitclass Other | 23,646 | 0.25 | 9 | 0 | 0.04 |
| control file parallel write | 1,420 | 0.00 | 2 | 1 | 0.00 |
| db file scattered read | 400 | 0.00 | 1 | 1 | 0.00 |
| db file sequential read | 276 | 0.00 | 1 | 2 | 0.00 |
| control file sequential read | 686 | 0.00 | 0 | 0 | 0.00 |
| os thread startup | 9 | 0.00 | 0 | 22 | 0.00 |
| buffer busy waits | 117 | 0.00 | 0 | 0 | 0.00 |
| latch: cache buffers chains | 6 | 0.00 | 0 | 7 | 0.00 |
| direct path write | 258 | 0.00 | 0 | 0 | 0.00 |
| latch: redo writing | 8 | 0.00 | 0 | 3 | 0.00 |
| latch: shared pool | 1 | 0.00 | 0 | 2 | 0.00 |
| direct path read | 1,106 | 0.00 | 0 | 0 | 0.00 |
| latch: library cache | 1 | 0.00 | 0 | 1 | 0.00 |
| latch: In memory undo latch | 1 | 0.00 | 0 | 0 | 0.00 |
| rdbms ipc message | 401,516 | 2.21 | 24,448 | 61 | 0.66 |
| Streams AQ: waiting for time management or cleanup tasks | 88 | 39.77 | 3,520 | 40002 | 0.00 |
| smon timer | 2,213 | 0.00 | 2,945 | 1331 | 0.00 |
| pmon timer | 1,007 | 100.00 | 2,848 | 2828 | 0.00 |
| Streams AQ: qmn slave idle wait | 444 | 0.00 | 2,842 | 6401 | 0.00 |
| Streams AQ: qmn coordinator idle wait | 1,135 | 39.12 | 2,842 | 2504 | 0.00 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
| Statistic | Total |
|---|
| NUM_LCPUS | 0 |
| NUM_VCPUS | 0 |
| AVG_BUSY_TIME | 197,917 |
| AVG_IDLE_TIME | 94,436 |
| AVG_IOWAIT_TIME | 1,398 |
| AVG_SYS_TIME | 6,568 |
| AVG_USER_TIME | 191,262 |
| BUSY_TIME | 1,583,977 |
| IDLE_TIME | 756,184 |
| IOWAIT_TIME | 11,755 |
| SYS_TIME | 53,198 |
| USER_TIME | 1,530,779 |
| LOAD | 0 |
| OS_CPU_WAIT_TIME | 1,720,800 |
| RSRC_MGR_CPU_WAIT_TIME | 0 |
| PHYSICAL_MEMORY_BYTES | 33,420,214,272 |
| NUM_CPUS | 8 |
| NUM_CPU_CORES | 4 |
Back to Wait Events Statistics
Back to Top
Service Statistics
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
|---|
| VIS | 18,290.80 | 8,456.80 | 54,145 | 1,331,975,456 |
| SYS$USERS | 46.10 | 24.30 | 467 | 12,048,640 |
| SYS$BACKGROUND | 0.00 | 0.00 | 4,276 | 2,830,037 |
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 |
50383 | 18160 | 1115291 | 55353 | 0 | 0 | 303660 | 155 |
| SYS$USERS |
733 | 156 | 5 | 1 | 0 | 0 | 45 | 0 |
| SYS$BACKGROUND |
2040 | 110 | 135 | 30 | 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 |
|---|
| 6,713 | 2,554 | 8 | 839.19 | 36.61 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 5,175 | 2,589 | 16 | 323.43 | 28.22 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,454 | 1,166 | 49,788 | 0.05 | 13.38 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 2,318 | 724 | 100 | 23.18 | 12.64 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 1,967 | 1,018 | 10 | 196.73 | 10.73 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 1,571 | 461 | 49,993 | 0.03 | 8.57 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 772 | 613 | 149,967 | 0.01 | 4.21 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 711 | 396 | 49,998 | 0.01 | 3.88 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 710 | 361 | 10 | 71.01 | 3.87 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 523 | 450 | 204,624 | 0.00 | 2.85 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 458 | 406 | 49,774 | 0.01 | 2.50 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 432 | 423 | 354,854 | 0.00 | 2.36 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 373 | 228 | 49,999 | 0.01 | 2.03 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 361 | 338 | 2,817,790 | 0.00 | 1.97 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 332 | 286 | 1,689,788 | 0.00 | 1.81 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 322 | 321 | 399,498 | 0.00 | 1.75 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 221 | 202 | 1,344,406 | 0.00 | 1.21 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 195 | 151 | 54,983 | 0.00 | 1.07 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
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 |
|---|
| 2,589 | 5,175 | 16 | 161.84 | 28.22 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 2,554 | 6,713 | 8 | 319.21 | 36.61 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 1,166 | 2,454 | 49,788 | 0.02 | 13.38 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 1,018 | 1,967 | 10 | 101.82 | 10.73 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 724 | 2,318 | 100 | 7.24 | 12.64 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 613 | 772 | 149,967 | 0.00 | 4.21 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 461 | 1,571 | 49,993 | 0.01 | 8.57 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 450 | 523 | 204,624 | 0.00 | 2.85 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 423 | 432 | 354,854 | 0.00 | 2.36 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 406 | 458 | 49,774 | 0.01 | 2.50 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 396 | 711 | 49,998 | 0.01 | 3.88 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 361 | 710 | 10 | 36.14 | 3.87 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 338 | 361 | 2,817,790 | 0.00 | 1.97 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 321 | 322 | 399,498 | 0.00 | 1.75 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 286 | 332 | 1,689,788 | 0.00 | 1.81 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 228 | 373 | 49,999 | 0.00 | 2.03 | assndb4wqnd6r |
INCTCW
|
BEGIN INV_TXN_MANAGER_PUB.rel_... |
| 202 | 221 | 1,344,406 | 0.00 | 1.21 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 151 | 195 | 54,983 | 0.00 | 1.07 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
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,346,854,232
- Captured SQL account for 37.3% of Total
| Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 577,609,853 | 16 | 36,100,615.81 | 42.89 | 2589.45 | 5174.86 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 233,130,880 | 8 | 29,141,360.00 | 17.31 | 2553.69 | 6713.48 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 231,447,575 | 10 | 23,144,757.50 | 17.18 | 1018.17 | 1967.30 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 103,824,973 | 354,854 | 292.59 | 7.71 | 422.72 | 431.83 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 88,093,572 | 399,498 | 220.51 | 6.54 | 321.44 | 321.56 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 80,018,767 | 100 | 800,187.67 | 5.94 | 723.56 | 2318.43 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
| 70,331,043 | 149,967 | 468.98 | 5.22 | 613.29 | 771.91 | 3b3psftuyks81 |
WSHPSGL_SUB
|
BEGIN INV_TXNSTUB_PUB.postTran... |
| 68,126,450 | 49,998 | 1,362.58 | 5.06 | 396.33 | 711.00 | 4yak7x2zqz0dh |
WSHPSGL_SUB
|
BEGIN inv_transfer_order_pvt.f... |
| 63,915,901 | 49,788 | 1,283.76 | 4.75 | 1165.61 | 2454.03 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 59,017,401 | 2,817,790 | 20.94 | 4.38 | 337.94 | 360.70 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 53,748,695 | 10 | 5,374,869.50 | 3.99 | 361.42 | 710.13 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 46,427,419 | 1,689,788 | 27.48 | 3.45 | 286.25 | 332.41 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 25,838,066 | 49,993 | 516.83 | 1.92 | 461.42 | 1571.19 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 25,328,793 | 309,854 | 81.74 | 1.88 | 148.61 | 155.58 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 24,809,841 | 1,344,406 | 18.45 | 1.84 | 201.88 | 221.15 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 22,322,815 | 4 | 5,580,703.75 | 1.66 | 149.01 | 156.88 | 7ptvbaycjtbg4 |
ARTERRPW
|
BEGIN arp_run.revenue_recognit... |
| 21,799,556 | 54,983 | 396.48 | 1.62 | 151.18 | 195.36 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 19,328,037 | 29,908 | 646.25 | 1.44 | 95.47 | 96.13 | 6uwctg1cdb25v |
WSHPSGL_SUB
|
SELECT DG.DELIVERY_LEG_ID LEG_... |
| 17,469,736 | 149,552 | 116.81 | 1.30 | 94.77 | 99.40 | 6z9c18cxpxfq0 |
WSHPSGL_SUB
|
SELECT NVL(COMMS_NL_TRACKABLE_... |
| 15,897,514 | 99,636 | 159.56 | 1.18 | 94.03 | 96.08 | 6h228dtb8hp1t |
WSHPSGL_SUB
|
SELECT X.ORGANIZATION_ID ORGAN... |
| 15,211,473 | 49,992 | 304.28 | 1.13 | 78.90 | 78.90 | fvcbstf9s6a5r |
OEHVIMP
|
begin WF_STANDARD.WAITFORFLOW ... |
| 14,478,960 | 3 | 4,826,320.00 | 1.08 | 177.10 | 177.57 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 14,252,509 | 2 | 7,126,254.50 | 1.06 | 136.98 | 136.98 | cqc8bmqp529tz |
RAXTRX
|
begin arp_etax_autoinv_util . ... |
| 14,226,352 | 56 | 254,042.00 | 1.06 | 61.66 | 109.45 | by0sg8ccaazuk |
OEHVIMP
|
UPDATE MRP_ATP_SCHEDULE_TEMP S... |
| 14,030,847 | 4 | 3,507,711.75 | 1.04 | 132.61 | 138.90 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- Total Disk Reads: 58,915
- Captured SQL account for 1.8% of Total
| Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
|---|
| 32,522 | 8 | 4,065.25 | 55.20 | 2553.69 | 6713.48 | 8zfgv4ck11dw9 |
FNDWFBG
|
BEGIN WF_ENGINE.BACKGROUNDCONC... |
| 31,741 | 49,788 | 0.64 | 53.88 | 1165.61 | 2454.03 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 8,951 | 4 | 2,237.75 | 15.19 | 132.61 | 138.90 | 5t39uchjqpyfm |
XLAACCUP
|
BEGIN xla_accounting_pkg.unit_... |
| 3,048 | 16 | 190.50 | 5.17 | 2589.45 | 5174.86 | 4y08a52989vfk |
WSHPSGL_SUB
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 1,772 | 10 | 177.20 | 3.01 | 361.42 | 710.13 | 0074pdmwb7fmv |
WSHINTERFACE
|
BEGIN WSH_SHIP_CONFIRM_ACTIONS... |
| 1,258 | 10 | 125.80 | 2.14 | 1018.17 | 1967.30 | 72yyswsqkzkrm |
OEHVIMP
|
BEGIN OE_BULK_ORDER_IMPORT_PVT... |
| 719 | 3 | 239.67 | 1.22 | 177.10 | 177.57 | 1wnq9qthbb54q |
WSHPSRS
|
BEGIN WSH_PICK_LIST.RELEASE_BA... |
| 579 | 54,983 | 0.01 | 0.98 | 151.18 | 195.36 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 360 | 1,689,788 | 0.00 | 0.61 | 286.25 | 332.41 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 265 | 100 | 2.65 | 0.45 | 723.56 | 2318.43 | 0z318y6g3uagc |
INCTCW
|
declare l_retstat varchar2 ( 3... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- Total Executions: 45,557,722
- Captured SQL account for 24.3% of Total
| Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
|---|
| 2,817,790 | 1,527,481 | 0.54 | 0.00 | 0.00 | 66tmsr3446uqn |
OEHVIMP
|
SELECT WIAS.ACTIVITY_STATUS, ... |
| 1,689,788 | 1,689,606 | 1.00 | 0.00 | 0.00 | cd9mbmqyf4qhp |
OEHVIMP
|
UPDATE WF_ITEM_ACTIVITY_STATUS... |
| 1,344,406 | 1,344,184 | 1.00 | 0.00 | 0.00 | gnhmcahkmrnzs |
OEHVIMP
|
INSERT INTO WF_ITEM_ACTIVITY_S... |
| 399,498 | 49,998 | 0.13 | 0.00 | 0.00 | 52zwqr7xyrc2m |
WSHPSGL_SUB
|
SELECT 'Y' FROM WSH_PR_WORKERS... |
| 398,209 | 396,187 | 0.99 | 0.00 | 0.00 | 7bdg2fscmus2h |
WSHINTERFACES
|
SELECT ACCOUNTING_RULE_ID , A... |
| 354,854 | 0 | 0.00 | 0.00 | 0.00 | cdjud36xbtuu5 |
OEHVIMP
|
SELECT WIAS.PROCESS_ACTIVITY, ... |
| 309,854 | 308,490 | 1.00 | 0.00 | 0.00 | b73h3md2wvs09 |
OEHVIMP
|
SELECT C.INSTANCE_ID FROM WF_P... |
| 204,624 | 204,010 | 1.00 | 0.00 | 0.00 | 0r0gvtarcjwzz |
WSHINTERFACES
|
insert into "ASO"."ASO_ORDER_F... |
| 199,847 | 199,446 | 1.00 | 0.00 | 0.00 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 199,831 | 199,445 | 1.00 | 0.00 | 0.00 | ghmx8n7wgqvfr |
WSHINTERFACES
|
begin WF_STANDARD.DEFER (:v1, ... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 1,968,668
- Captured SQL account for 93.7% of Total
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|
| 199,727 | 199,831 | 10.15 | ghmx8n7wgqvfr |
WSHINTERFACES
|
begin WF_STANDARD.DEFER (:v1, ... |
| 199,631 | 199,847 | 10.14 | fb13x9qx0ftks |
OEHVIMP
|
begin OE_STANDARD_WF.OEOL_SELE... |
| 149,581 | 149,987 | 7.60 | 0mdnts20d60yr |
WSHPSGL_SUB
|
declare
v_ret number := 0... |
| 99,573 | 99,839 | 5.06 | 1c0b7sas42w2z |
WSHPSGL_SUB
|
SELECT NVL(ITEM_COST, 0), ... |
| 99,332 | 99,628 | 5.05 | 1v818hwxjxy58 |
WSHINTERFACES
|
select FND_FLEX_VALUES_VL.FLEX... |
| 59,978 | 59,984 | 3.05 | bf7uwg5pa3pj6 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.V... |
| 59,964 | 59,967 | 3.05 | 76sw2a4vnc89j |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.S... |
| 59,958 | 59,971 | 3.05 | 608c0n36kaw62 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.C... |
| 59,958 | 59,976 | 3.05 | dcvv68fju01g4 |
WSHINTERFACES
|
begin FND_FLEX_WORKFLOW_APIS.E... |
| 53,964 | 54,983 | 2.74 | g8102j8yynbwz |
OEHVIMP
|
begin WF_STANDARD.CONTINUEFLOW... |
| 49,994 | 49,993 | 2.54 | 9wdrypwkpf607 |
FNDWFBG
|
begin OE_FULFILL_WF.START_FULF... |
| 49,983 | 49,788 | 2.54 | gksvm8wmzk8w0 |
FNDWFBG
|
begin OE_INVOICE_WF.INVOICE_IN... |
| 49,949 | 49,979 | 2.54 | bfbyqwbr4vwms |
OEHVIMP
|
begin OE_OEOL_SCH.SCHEDULE_LIN... |
| 49,902 | 49,980 | 2.53 | cw171rvngr1w9 |
WSHINTERFACES
|
begin OE_FLEX_COGS_PUB.GET_COS... |
| 49,880 | 49,920 | 2.53 | gdnwgx9fcxggr |
OEHVIMP
|
begin OE_SHIPPING_WF.START_SHI... |
| 49,861 | 49,908 | 2.53 | 7mrs575bj7a41 |
OEHVIMP
|
begin OE_OEOL_SCH.BRANCH_ON_SO... |
| 49,825 | 49,992 | 2.53 | fvcbstf9s6a5r |
OEHVIMP
|
begin WF_STANDARD.WAITFORFLOW ... |
| 49,779 | 49,955 | 2.53 | g2qs4xk48vcwy |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 49,730 | 49,774 | 2.53 | gnng1rmpjxzsx |
FNDWFBG
|
begin OE_CLOSE_WF.CLOSE_LINE (... |
| 49,614 | 49,742 | 2.52 | 7mz96k4qtxrzr |
WSHPSGL_SUB
|
SELECT BASE.REVISION , BASE.LO... |
| 49,577 | 49,942 | 2.52 | bsuw7pmwrufpy |
INCTCW
|
SELECT
reservation_... |
| 49,440 | 49,796 | 2.51 | a40f9h91scg23 |
WSHINTERFACES
|
select to_char(CODE_COMBINATIO... |
| 44,970 | 44,981 | 2.28 | 7gtztzv329wg0 |
|
select c.name, u.name from co... |
| 44,962 | 44,981 | 2.28 | 2skwhauh2cwky |
|
select o.name, u.name from ob... |
| 41,751 | 41,752 | 2.12 | 4m7m0t6fjcs5x |
|
update seq$ set increment$=:2,... |
| 22,348 | 22,348 | 1.14 | bsa0wjtftg3uw |
|
select file# from file$ where ... |
| 21,531 | 21,531 | 1.09 | 9qgtwh66xg6nz |
|
update seg$ set type#=:4, bloc... |
Back to SQL Statistics
Back to Top
SQL ordered by Sharable Memory
- Only Statements with Sharable Memory greater than 1048576 are displayed
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|
| 1,473,584 | 398,209 | 0.07 | 7bdg2fscmus2h |
WSHINTERFACES
|
SELECT ACCOUNTING_RULE_ID , A... |
| 1,118,534 | 512 | 0.05 | g345hj2ua4pf9 |
WSHPSGL_SUB
|
INSERT INTO MTL_TRANSACTION_LO... |
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# |
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4y08a52989vfk | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 52zwqr7xyrc2m | SELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 5t39uchjqpyfm | BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END; |
| 608c0n36kaw62 | begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 66tmsr3446uqn | SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1 |
| 6h228dtb8hp1t |
SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE
TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO
DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT
.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN
VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID |
| 6uwctg1cdb25v | SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1 |
| 6z9c18cxpxfq0 | SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1 |
| 72yyswsqkzkrm | BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END; |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 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# |
| 7mrs575bj7a41 | begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end; |
| 7mz96k4qtxrzr |
SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED ,
X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I
D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE
R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC |
| 7ptvbaycjtbg4 | BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END; |
| 8zfgv4ck11dw9 | BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END; |
| 9qgtwh66xg6nz | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 |
| 9wdrypwkpf607 | begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end; |
| a40f9h91scg23 | select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2 |
| assndb4wqnd6r | BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END; |
| b73h3md2wvs09 | SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID) |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| bfbyqwbr4vwms | begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| bsuw7pmwrufpy |
SELECT
reservation_id
, primary_reservation_quantity - NVL(detailed_quantity, 0)
, NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV
FROM mtl_reservations
WHERE demand_source_header_id = :demand_source_header_id
AND demand_source_line_id = :demand_source_line_id
AND demand_source_type_id = :demand_source_type_id
AND supply_source_type_id = :supply_source_type_id
AND (:demand_source_delivery = :l_miss_num
OR :demand_source_delivery IS NULL
AND demand_source_delivery IS NULL
OR :demand_source_delivery = demand_source_delivery)
AND (:organization_id = :l_miss_num
OR :organization_id IS NULL
AND organization_id IS NULL
OR :organization_id = organization_id)
AND (:inventory_item_id = :l_miss_num
OR :inventory_item_id IS NULL
AND inventory_item_id IS NULL
OR :inventory_item_id = inventory_item_id)
AND (:subinventory_code = :l_miss_char
OR :subinventory_code IS NULL
AND subinventory_code IS NULL
OR :subinventory_code = subinventory_code)
AND (:locator_id = :l_miss_num
OR :locator_id IS NULL
AND locator_id IS NULL
OR :locator_id = locator_id)
AND (:lot_number = :l_miss_char
OR :lot_number IS NULL
AND lot_number IS NULL
OR :lot_number = lot_number)
AND (:revision = :l_miss_char
OR :revision
IS NULL
AND revision IS NULL
OR :revision = revision)
AND (:lpn_id = :l_miss_num
OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id)))
AND (:demand_source_name = :l_miss_char
OR :demand_source_name IS NULL
AND demand_source_name IS NULL
OR :demand_source_name = demand_source_name)
AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0
ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE |
| by0sg8ccaazuk |
UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO
DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A
VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B4 , NULL), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1) |
| 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; |
| 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) |
| g345hj2ua4pf9 |
INSERT INTO MTL_TRANSACTION_LOTS_TEMP ( TRANSACTION_TEMP_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, TRANSACTION_QUANTITY, PRIMARY_QUANTITY, LOT_NUMBER, LOT_EXPIRATION_DATE, GROUP_HEADER_ID, SERIAL_TRANSACTION_TEMP_ID, STATUS_ID , LOT_ATTRIBUTE_CATEGORY , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , C_ATTRIBUTE1 , C_ATTRIBUTE2 , C_ATTRIBUTE3 , C_ATTRIBUTE4 , C_ATTRIBUTE5 , C_ATTRIBUTE6 , C_ATTRIBUTE7 , C_ATTRIBUTE8 , C_ATTRIBUTE9 , C_ATTRIBUTE10 , C_ATTRIBUTE11 , C_ATTRIBUTE12 , C_ATTRIBUTE13 , C_ATTRIBUTE14 , C_ATTRIBUTE15 , C_ATTRIBUTE16 , C_ATTRIBUTE17 , C_ATTRIBUTE18 , C_ATTRIBUTE19 , C_ATTRIBUTE20 , N_ATTRIBUTE1 , N_ATTRIBUTE2 , N_ATTRIBUTE3 , N_ATTRIBUTE4 , N_ATTRIBUTE5 , N_ATTRIBUTE6 , N_ATTRIBUTE7 , N_ATTRIBUTE8 , N_ATTRIBUTE9 , N_ATTRIBUTE10 , D_ATTRIBUTE1 , D_ATTRIBUTE2 , D_ATTRIBUTE3 , D_ATTRIBUTE4 , D_ATTRIBUTE5 , D_ATTRIBUTE6 , D_ATTRIBUTE7 , D_ATTRIBUTE8 , D_ATTRIBUTE9 , D_ATTRIBUTE10 , GRADE_CODE , ORIGINATION_DATE , DATE_CODE , CHANGE_DATE , AGE , RETEST_DATE , MATURITY_DATE , ITEM_SIZE , COLOR , VOLUME , VOLUME_UOM , PLACE_OF_ORIGIN , BEST_BY_DATE , LENGTH , LENGTH_UOM , RECYCLED_CONTENT ,
THICKNESS , THICKNESS_UOM , WIDTH , WIDTH_UOM , TERRITORY_CODE , SUPPLIER_LOT_NUMBER , VENDOR_NAME , SECONDARY_QUANTITY , PARENT_LOT_NUMBER , ORIGINATION_TYPE , EXPIRATION_ACTION_CODE , EXPIRATION_ACTION_DATE , HOLD_DATE , REASON_ID ) (SELECT MMTT.TRANSACTION_TEMP_ID, MMTT.LAST_UPDATE_DATE, MMTT.LAST_UPDATED_BY, MMTT.CREATION_DATE, MMTT.CREATED_BY, MMTT.LAST_UPDATE_LOGIN, MMTT.REQUEST_ID, MMTT.PROGRAM_APPLICATION_ID, MMTT.PROGRAM_ID, MMTT.PROGRAM_UPDATE_DATE, MMTT.TRANSACTION_QUANTITY, MMTT.PRIMARY_QUANTITY, MMTT.LOT_NUMBER, NVL(MMTT.LOT_EXPIRATION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 2, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + SHELF_LIFE_DAYS, NULL)), MMTT.TRANSACTION_HEADER_ID, MMTT.TRANSACTION_TEMP_ID, NVL(MLN.STATUS_ID, MSI.DEFAULT_LOT_STATUS_ID) , MLN.LOT_ATTRIBUTE_CATEGORY , MLN.ATTRIBUTE_CATEGORY , MLN.ATTRIBUTE1 , MLN.ATTRIBUTE2 , MLN.ATTRIBUTE3 , MLN.ATTRIBUTE4 , MLN.ATTRIBUTE5 , MLN.ATTRIBUTE6 , MLN.ATTRIBUTE7 , MLN.ATTRIBUTE8 , MLN.ATTRIBUTE9 , MLN.ATTRIBUTE10 , MLN.ATTRIBUTE11 , MLN.ATTRIBUTE12 , MLN.ATTRIBUTE13 , MLN.ATTRIBUTE14 , MLN.ATTRIBUTE15 , MLN.C_ATTRIBUTE1 , MLN.C_ATTRIBUTE2 , MLN.C_ATTRIBUTE3 , MLN.C_ATTRIBUTE4 , MLN.C_ATTRIBUTE5 , MLN.C_ATTRIBUTE6 , MLN.C_ATTRIBUTE7 , MLN.C_ATTRIBUTE8 , MLN.C_ATTRIBUTE9 , MLN.C_ATTRIBUTE10 , MLN.C_ATTRIBUTE11 , MLN.C_ATTRIBUTE12 , MLN.C_ATTRIBUTE13 , MLN.C_ATTRIBUTE14 , MLN.C_ATTRIBUTE15 , MLN.C_ATTRIBUTE16 , MLN.C_ATTRIBUTE17 , MLN.C_ATTRIBUTE18 , MLN.C_ATTRIBUTE19 , MLN.C_ATTRIB
UTE20 , MLN.N_ATTRIBUTE1 , MLN.N_ATTRIBUTE2 , MLN.N_ATTRIBUTE3 , MLN.N_ATTRIBUTE4 , MLN.N_ATTRIBUTE5 , MLN.N_ATTRIBUTE6 , MLN.N_ATTRIBUTE7 , MLN.N_ATTRIBUTE8 , MLN.N_ATTRIBUTE9 , MLN.N_ATTRIBUTE10 , MLN.D_ATTRIBUTE1 , MLN.D_ATTRIBUTE2 , MLN.D_ATTRIBUTE3 , MLN.D_ATTRIBUTE4 , MLN.D_ATTRIBUTE5 , MLN.D_ATTRIBUTE6 , MLN.D_ATTRIBUTE7 , MLN.D_ATTRIBUTE8 , MLN.D_ATTRIBUTE9 , MLN.D_ATTRIBUTE10 , NVL(MLN.GRADE_CODE, DECODE(MSI.GRADE_CONTROL_FLAG, 'Y', MSI.DEFAULT_GRADE, NULL)) , NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) , MLN.DATE_CODE , MLN.CHANGE_DATE , MLN.AGE , NVL(MLN.RETEST_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + MSI.RETEST_INTERVAL) , NVL(MLN.MATURITY_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + MSI.MATURITY_DAYS) , MLN.ITEM_SIZE , MLN.COLOR , MLN.VOLUME , MLN.VOLUME_UOM , MLN.PLACE_OF_ORIGIN , MLN.BEST_BY_DATE , MLN.LENGTH , MLN.LENGTH_UOM , MLN.RECYCLED_CONTENT , MLN.THICKNESS , MLN.THICKNESS_UOM , MLN.WIDTH , MLN.WIDTH_UOM , MLN.TERRITORY_CODE , MLN.SUPPLIER_LOT_NUMBER , MLN.VENDOR_NAME , MMTT.SECONDARY_TRANSACTION_QUANTITY , MLN.PARENT_LOT_NUMBER , NVL(MLN.ORIGINATION_TYPE, DECODE(MMTT.TRANSACTION_SOURCE_TYPE_ID, 1, 3, 7, 3, 13, 4, 6, 4, 12, 4, 31, 1, 6)) , NVL(MLN.EXPIRATION_ACTION_CODE, DECODE(MSI.SHELF_LIFE_CODE, 1, NULL, MSI.EXPIRATION_ACTION_CODE)) , NVL(MLN.EXPIRATION_ACTION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 1, NULL, NVL(MMTT.LOT_EXPIRATION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 2, NVL(MLN.ORIGINATION
_DATE, MMTT.TRANSACTION_DATE) + SHELF_LIFE_DAYS, NULL)) + MSI.EXPIRATION_ACTION_INTERVAL)) , NVL(MLN.HOLD_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + HOLD_DAYS) , MMTT.REASON_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_SYSTEM_ITEMS MSI, MTL_LOT_NUMBERS MLN WHERE MMTT.TRANSACTION_HEADER_ID = :B1 AND MMTT.LOT_NUMBER IS NOT NULL AND MMTT.TRANSACTION_HEADER_ID IS NOT NULL AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID(+) = MMTT.INVENTORY_ITEM_ID AND MLN.ORGANIZATION_ID(+) = MMTT.ORGANIZATION_ID AND MLN.LOT_NUMBER(+) =MMTT.LOT_NUMBER) |
| g8102j8yynbwz | begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end; |
| gdnwgx9fcxggr | begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end; |
| ghmx8n7wgqvfr | begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end; |
| gksvm8wmzk8w0 | begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end; |
| gnhmcahkmrnzs | INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 ) |
| gnng1rmpjxzsx | begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end; |
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 | 846,094 | 289.64 | 1.38 |
| CPU used when call started | 844,568 | 289.12 | 1.38 |
| CR blocks created | 14,575,661 | 4,989.64 | 23.86 |
| Cached Commit SCN referenced | 153,154 | 52.43 | 0.25 |
| Commit SCN cached | 66 | 0.02 | 0.00 |
| DB time | 4,033,773 | 1,380.87 | 6.60 |
| DBWR checkpoint buffers written | 1,563,510 | 535.23 | 2.56 |
| DBWR checkpoints | 24 | 0.01 | 0.00 |
| DBWR object drop buffers written | 1,867 | 0.64 | 0.00 |
| DBWR revisited being-written buffer | 25 | 0.01 | 0.00 |
| DBWR transaction table writes | 225 | 0.08 | 0.00 |
| DBWR undo block writes | 1,039,257 | 355.77 | 1.70 |
| DFO trees parallelized | 5 | 0.00 | 0.00 |
| IMU CR rollbacks | 5,709,494 | 1,954.51 | 9.34 |
| IMU Flushes | 354,833 | 121.47 | 0.58 |
| IMU Redo allocation size | 1,339,173,480 | 458,434.85 | 2,191.74 |
| IMU commits | 307,646 | 105.32 | 0.50 |
| IMU contention | 90,388 | 30.94 | 0.15 |
| IMU ktichg flush | 323 | 0.11 | 0.00 |
| IMU pool not allocated | 0 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 123 | 0.04 | 0.00 |
| IMU undo allocation size | 2,122,620,776 | 726,629.79 | 3,473.96 |
| IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
| PX local messages recv'd | 6,276 | 2.15 | 0.01 |
| PX local messages sent | 6,276 | 2.15 | 0.01 |
| Parallel operations downgraded 25 to 50 pct | 4 | 0.00 | 0.00 |
| Parallel operations not downgraded | 1 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 200 | 0.07 | 0.00 |
| SQL*Net roundtrips to/from client | 144,241 | 49.38 | 0.24 |
| active txn count during cleanout | 57,644,327 | 19,733.19 | 94.34 |
| application wait time | 13,473 | 4.61 | 0.02 |
| background checkpoints completed | 2 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 9,340 | 3.20 | 0.02 |
| branch node splits | 610 | 0.21 | 0.00 |
| buffer is not pinned count | 315,582,781 | 108,032.42 | 516.49 |
| buffer is pinned count | 471,043,636 | 161,250.82 | 770.93 |
| bytes received via SQL*Net from client | 47,001,269 | 16,089.79 | 76.92 |
| bytes sent via SQL*Net to client | 338,926,028 | 116,023.43 | 554.70 |
| calls to get snapshot scn: kcmgss | 55,342,486 | 18,945.21 | 90.58 |
| calls to kcmgas | 17,416,080 | 5,961.99 | 28.50 |
| calls to kcmgcs | 2,879,781 | 985.83 | 4.71 |
| change write time | 39,097 | 13.38 | 0.06 |
| cleanout - number of ktugct calls | 18,344,492 | 6,279.81 | 30.02 |
| cleanouts and rollbacks - consistent read gets | 13,561,607 | 4,642.50 | 22.20 |
| cleanouts only - consistent read gets | 61,433 | 21.03 | 0.10 |
| cluster key scan block gets | 150,238 | 51.43 | 0.25 |
| cluster key scans | 80,577 | 27.58 | 0.13 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 49,886 | 17.08 | 0.08 |
| commit batch/immediate requested | 49,886 | 17.08 | 0.08 |
| commit cleanout failures: block lost | 178,508 | 61.11 | 0.29 |
| commit cleanout failures: buffer being written | 15 | 0.01 | 0.00 |
| commit cleanout failures: callback failure | 93,108 | 31.87 | 0.15 |
| commit cleanout failures: cannot pin | 44,116 | 15.10 | 0.07 |
| commit cleanouts | 7,260,230 | 2,485.37 | 11.88 |
| commit cleanouts successfully completed | 6,944,483 | 2,377.28 | 11.37 |
| commit immediate performed | 49,886 | 17.08 | 0.08 |
| commit immediate requested | 49,886 | 17.08 | 0.08 |
| commit txn count during cleanout | 981,797 | 336.10 | 1.61 |
| concurrency wait time | 55,383 | 18.96 | 0.09 |
| consistent changes | 685,396,347 | 234,629.48 | 1,121.75 |
| consistent gets | 1,205,233,330 | 412,583.56 | 1,972.53 |
| consistent gets - examination | 917,667,094 | 314,141.96 | 1,501.89 |
| consistent gets direct | 46 | 0.02 | 0.00 |
| consistent gets from cache | 1,205,233,284 | 412,583.55 | 1,972.53 |
| cursor authentications | 702 | 0.24 | 0.00 |
| data blocks consistent reads - undo records applied | 679,784,303 | 232,708.33 | 1,112.56 |
| db block changes | 126,152,797 | 43,185.47 | 206.47 |
| db block gets | 141,620,902 | 48,480.62 | 231.78 |
| db block gets direct | 344 | 0.12 | 0.00 |
| db block gets from cache | 141,620,558 | 48,480.50 | 231.78 |
| deferred (CURRENT) block cleanout applications | 1,092,104 | 373.86 | 1.79 |
| dirty buffers inspected | 1,529 | 0.52 | 0.00 |
| enqueue conversions | 1,674 | 0.57 | 0.00 |
| enqueue releases | 3,767,964 | 1,289.87 | 6.17 |
| enqueue requests | 3,990,432 | 1,366.03 | 6.53 |
| enqueue timeouts | 222,466 | 76.16 | 0.36 |
| enqueue waits | 46,662 | 15.97 | 0.08 |
| exchange deadlocks | 32,163 | 11.01 | 0.05 |
| execute count | 45,557,722 | 15,595.63 | 74.56 |
| failed probes on index block reclamation | 963,089 | 329.69 | 1.58 |
| free buffer inspected | 1,755,232 | 600.86 | 2.87 |
| free buffer requested | 16,610,455 | 5,686.20 | 27.19 |
| heap block compress | 23,558,609 | 8,064.74 | 38.56 |
| hot buffers moved to head of LRU | 694,044 | 237.59 | 1.14 |
| immediate (CR) block cleanout applications | 13,623,054 | 4,663.54 | 22.30 |
| immediate (CURRENT) block cleanout applications | 806,336 | 276.03 | 1.32 |
| index crx upgrade (found) | 96,990 | 33.20 | 0.16 |
| index crx upgrade (positioned) | 2,904,495 | 994.29 | 4.75 |
| index fast full scans (rowid ranges) | 96 | 0.03 | 0.00 |
| index fetch by key | 96,889,026 | 33,167.70 | 158.57 |
| index scans kdiixs1 | 28,765,572 | 9,847.22 | 47.08 |
| java call heap collected bytes | 808,146,840 | 276,650.25 | 1,322.64 |
| java call heap collected count | 11,160,798 | 3,820.64 | 18.27 |
| java call heap gc count | 2,546 | 0.87 | 0.00 |
| java call heap live object count | 510,474 | 174.75 | 0.84 |
| java call heap live object count max | 528,281 | 180.84 | 0.86 |
| java call heap live size | 185,142,160 | 63,379.11 | 303.01 |
| java call heap live size max | 186,546,560 | 63,859.87 | 305.31 |
| java call heap object count | 1,192,140 | 408.10 | 1.95 |
| java call heap object count max | 1,242,726 | 425.42 | 2.03 |
| java call heap total size | 255,080,448 | 87,320.85 | 417.47 |
| java call heap total size max | 255,080,448 | 87,320.85 | 417.47 |
| java call heap used size | 230,390,328 | 78,868.76 | 377.07 |
| java call heap used size max | 235,592,328 | 80,649.55 | 385.58 |
| leaf node 90-10 splits | 9,870 | 3.38 | 0.02 |
| leaf node splits | 142,613 | 48.82 | 0.23 |
| lob reads | 3,075,037 | 1,052.67 | 5.03 |
| lob writes | 1,310,023 | 448.46 | 2.14 |
| lob writes unaligned | 1,310,023 | 448.46 | 2.14 |
| logons cumulative | 427 | 0.15 | 0.00 |
| messages received | 566,303 | 193.86 | 0.93 |
| messages sent | 566,303 | 193.86 | 0.93 |
| no buffer to keep pinned count | 8 | 0.00 | 0.00 |
| no work - consistent read gets | 256,531,205 | 87,817.48 | 419.85 |
| opened cursors cumulative | 788,222 | 269.83 | 1.29 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 648 | 0.22 | 0.00 |
| parse count (total) | 1,968,668 | 673.93 | 3.22 |
| parse time cpu | 1,283 | 0.44 | 0.00 |
| parse time elapsed | 5,043 | 1.73 | 0.01 |
| physical read IO requests | 46,360 | 15.87 | 0.08 |
| physical read bytes | 482,631,680 | 165,217.72 | 789.89 |
| physical read total IO requests | 48,989 | 16.77 | 0.08 |
| physical read total bytes | 523,591,680 | 179,239.42 | 856.93 |
| physical read total multi block requests | 1,910 | 0.65 | 0.00 |
| physical reads | 58,915 | 20.17 | 0.10 |
| physical reads cache | 57,756 | 19.77 | 0.09 |
| physical reads cache prefetch | 12,519 | 4.29 | 0.02 |
| physical reads direct | 1,159 | 0.40 | 0.00 |
| physical reads direct (lob) | 48 | 0.02 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 131,807 | 45.12 | 0.22 |
| physical write bytes | 12,848,939,008 | 4,398,535.05 | 21,029.05 |
| physical write total IO requests | 979,771 | 335.40 | 1.60 |
| physical write total bytes | 34,615,090,688 | 11,849,670.20 | 56,652.34 |
| physical write total multi block requests | 923,241 | 316.05 | 1.51 |
| physical writes | 1,568,474 | 536.93 | 2.57 |
| physical writes direct | 602 | 0.21 | 0.00 |
| physical writes direct (lob) | 5 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 286 | 0.10 | 0.00 |
| physical writes from cache | 1,567,872 | 536.72 | 2.57 |
| physical writes non checkpoint | 824,488 | 282.24 | 1.35 |
| pinned buffers inspected | 5,166 | 1.77 | 0.01 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 13 | 0.00 | 0.00 |
| process last non-idle time | 3,048 | 1.04 | 0.00 |
| queries parallelized | 5 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 19 | 0.01 | 0.00 |
| recursive calls | 82,459,675 | 28,228.15 | 134.96 |
| recursive cpu usage | 709,369 | 242.84 | 1.16 |
| redo blocks written | 42,375,791 | 14,506.37 | 69.35 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 68,622,296 | 23,491.24 | 112.31 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 900,664 | 308.32 | 1.47 |
| redo size | 20,776,355,056 | 7,112,301.32 | 34,003.35 |
| redo subscn max counts | 1,491,409 | 510.55 | 2.44 |
| redo synch time | 34,151 | 11.69 | 0.06 |
| redo synch writes | 122,794 | 42.04 | 0.20 |
| redo wastage | 207,575,084 | 71,058.50 | 339.73 |
| redo write time | 42,012 | 14.38 | 0.07 |
| redo writer latching time | 704 | 0.24 | 0.00 |
| redo writes | 451,803 | 154.66 | 0.74 |
| rollback changes - undo records applied | 69,768 | 23.88 | 0.11 |
| rollbacks only - consistent read gets | 1,078,971 | 369.36 | 1.77 |
| rows fetched via callback | 33,457,506 | 11,453.40 | 54.76 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 1,834,111 | 627.87 | 3.00 |
| session logical reads | 1,346,854,232 | 461,064.18 | 2,204.31 |
| session pga memory | 77,346,104 | 26,477.64 | 126.59 |
| session pga memory max | 203,633,976 | 69,709.35 | 333.27 |
| session uga memory | 51,553,711,016 | 17,648,212.41 | 84,374.72 |
| session uga memory max | 7,294,750,320 | 2,497,187.90 | 11,938.86 |
| shared hash latch upgrades - no wait | 22,998,755 | 7,873.09 | 37.64 |
| shared hash latch upgrades - wait | 202,180 | 69.21 | 0.33 |
| sorts (memory) | 4,715,158 | 1,614.12 | 7.72 |
| sorts (rows) | 14,930,837 | 5,111.22 | 24.44 |
| sql area evicted | 315 | 0.11 | 0.00 |
| sql area purged | 62 | 0.02 | 0.00 |
| summed dirty queue length | 8,657 | 2.96 | 0.01 |
| switch current to new buffer | 1,100,882 | 376.86 | 1.80 |
| table fetch by rowid | 328,911,453 | 112,595.18 | 538.31 |
| table fetch continued row | 18,977,315 | 6,496.44 | 31.06 |
| table scan blocks gotten | 5,945,121 | 2,035.17 | 9.73 |
| table scan rows gotten | 268,891,902 | 92,048.88 | 440.08 |
| table scans (long tables) | 195 | 0.07 | 0.00 |
| table scans (rowid ranges) | 195 | 0.07 | 0.00 |
| table scans (short tables) | 1,379,934 | 472.39 | 2.26 |
| total number of times SMON posted | 2,213 | 0.76 | 0.00 |
| transaction rollbacks | 49,886 | 17.08 | 0.08 |
| transaction tables consistent read rollbacks | 189 | 0.06 | 0.00 |
| transaction tables consistent reads - undo records applied | 295,211 | 101.06 | 0.48 |
| undo change vector size | 7,554,105,168 | 2,585,971.99 | 12,363.33 |
| user I/O wait time | 18,432 | 6.31 | 0.03 |
| user calls | 170,198 | 58.26 | 0.28 |
| user commits | 610,069 | 208.84 | 1.00 |
| user rollbacks | 940 | 0.32 | 0.00 |
| workarea executions - optimal | 1,884,799 | 645.22 | 3.08 |
| write clones created in background | 45 | 0.02 | 0.00 |
| write clones created in foreground | 61 | 0.02 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
| Statistic | Begin Value | End Value |
|---|
| logons current | 91 | 92 |
| session cursor cache count | 27,427 | 45,434 |
| opened cursors current | 2,680 | 2,727 |
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_UNDOTS1 |
1 | 0 | 0.00 | 1.00 | 70,185 | 24 | 513,805 | 0.29 |
| APPS_TS_TX_IDX |
20,321 | 7 | 4.07 | 1.00 | 28,467 | 10 | 178,360 | 0.31 |
| APPS_TS_TX_DATA |
14,973 | 5 | 3.71 | 1.64 | 14,912 | 5 | 198,905 | 0.31 |
| APPS_TS_INTERFACE |
8,675 | 3 | 3.34 | 1.01 | 3,354 | 1 | 23,794 | 0.30 |
| APPS_TS_QUEUES |
190 | 0 | 3.37 | 1.00 | 9,444 | 3 | 86,138 | 0.73 |
| APPS_TS_SUMMARY |
144 | 0 | 2.36 | 1.00 | 4,421 | 2 | 44,429 | 0.45 |
| SYSTEM |
987 | 0 | 2.40 | 3.55 | 475 | 0 | 11,822 | 0.13 |
| SYSAUX |
308 | 0 | 2.24 | 1.00 | 274 | 0 | 0 | 0.00 |
| APPS_TS_SEED |
337 | 0 | 3.83 | 1.26 | 5 | 0 | 118 | 2.88 |
| APPS_TS_ARCHIVE |
38 | 0 | 5.26 | 1.00 | 64 | 0 | 29 | 0.00 |
| TEMP |
41 | 0 | 0.73 | 7.05 | 32 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA |
21 | 0 | 3.33 | 1.00 | 7 | 0 | 0 | 0.00 |
| GEOR_TBS |
14 | 0 | 4.29 | 1.00 | 2 | 0 | 0 | 0.00 |
| IAS_META |
15 | 0 | 4.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE |
15 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| CWMLITE |
12 | 0 | 3.33 | 1.00 | 2 | 0 | 0 | 0.00 |
| DCM |
12 | 0 | 3.33 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING |
7 | 0 | 2.86 | 1.00 | 4 | 0 | 84 | 0.00 |
| OLTS_CT_STORE |
10 | 0 | 4.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| CTXSYS |
8 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
| OLTS_DEFAULT |
9 | 0 | 5.56 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP |
4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| DISCO_PTM5_META |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| HTMLDB |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_DOC |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_IDX |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_LOG |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| RE |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| SYNCSERVER |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_DT |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_IDX |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_LOB |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_RT |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| BAM |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| MTR |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NOETIX |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OCATS |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| ODM_DATA |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OPMOR |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| ORABPEL |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OWAPUB |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| UDDISYS_TS |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| WCRSYS_TS |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| XDB |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TOOLS |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_OMO |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP |
1 | 0 | 0.00 | 1.00 | 1 | 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/apps_st/data/apps_calclip.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/apps_st/data/apps_calclip1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/apps_st/data/apps_calclip2.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_CALCLIP | /ds1/oracle/VIS/db/apps_st/data/apps_calclip3.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_OMO | /ds1/oracle/VIS/db/apps_st/data/omo1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_ARCHIVE | /ds1/oracle/VIS/db/apps_st/data/archive1.dbf |
38 | 0 | 5.26 | 1.00 | 64 | 0 | 29 | 0.00 |
| APPS_TS_DISCO | /ds1/oracle/VIS/db/apps_st/data/disco1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_DISCO_OLAP | /ds1/oracle/VIS/db/apps_st/data/disco_drake1.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface.db |
113 | 0 | 1.33 | 1.31 | 96 | 0 | 846 | 0.08 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface1.d |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface10. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface11. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface12. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface13. |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface14. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface15. |
64 | 0 | 0.63 | 1.00 | 7 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface16. |
63 | 0 | 0.32 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface17. |
39 | 0 | 3.85 | 1.00 | 22 | 0 | 104 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface18. |
2 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface19. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface2.d |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface20. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface21. |
3 | 0 | 3.33 | 1.00 | 9 | 0 | 37 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface22. |
2 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface23. |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface24. |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface25. |
17 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface26. |
2 | 0 | 0.00 | 1.00 | 20 | 0 | 40 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface27. |
891 | 0 | 3.11 | 1.01 | 366 | 0 | 1,934 | 0.47 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface28. |
905 | 0 | 3.03 | 1.01 | 360 | 0 | 2,656 | 0.23 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface29. |
845 | 0 | 3.51 | 1.02 | 322 | 0 | 2,786 | 0.31 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface3.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface30. |
834 | 0 | 3.99 | 1.01 | 319 | 0 | 1,579 | 0.41 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface31. |
806 | 0 | 3.15 | 1.01 | 309 | 0 | 1,507 | 0.48 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface32. |
842 | 0 | 3.92 | 1.02 | 316 | 0 | 1,437 | 0.53 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface33. |
785 | 0 | 3.31 | 1.01 | 304 | 0 | 2,594 | 0.19 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface34. |
809 | 0 | 3.45 | 1.00 | 302 | 0 | 1,805 | 0.45 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface35. |
798 | 0 | 3.63 | 1.00 | 280 | 0 | 3,256 | 0.25 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface36. |
812 | 0 | 3.23 | 1.00 | 287 | 0 | 3,213 | 0.13 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface4.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface5.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface6.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface7.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface8.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_INTERFACE | /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface9.d |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media1.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media2.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media3.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media4.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media5.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media6.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_MEDIA | /ds1/oracle/VIS/db/apps_st/data/media7.dbf |
3 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_NOLOGGING | /ds1/oracle/VIS/db/apps_st/data/nologging1.dbf |
7 | 0 | 2.86 | 1.00 | 4 | 0 | 84 | 0.00 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues1.dbf |
6 | 0 | 5.00 | 1.00 | 52 | 0 | 1,056 | 1.23 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues2.dbf |
18 | 0 | 2.78 | 1.00 | 71 | 0 | 2,425 | 0.44 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues3.dbf |
41 | 0 | 2.93 | 1.00 | 1,851 | 1 | 16,717 | 0.71 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues4.dbf |
55 | 0 | 3.09 | 1.00 | 1,895 | 1 | 16,501 | 0.77 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues5.dbf |
27 | 0 | 4.81 | 1.00 | 1,805 | 1 | 16,800 | 0.78 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues6.dbf |
18 | 0 | 3.89 | 1.00 | 1,902 | 1 | 16,440 | 0.74 |
| APPS_TS_QUEUES | /ds1/oracle/VIS/db/apps_st/data/queues7.dbf |
25 | 0 | 2.80 | 1.00 | 1,868 | 1 | 16,199 | 0.68 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/apps_st/data/reference1.dbf |
105 | 0 | 4.29 | 1.12 | 1 | 0 | 35 | 4.00 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/apps_st/data/reference2.dbf |
137 | 0 | 3.72 | 1.25 | 1 | 0 | 59 | 2.03 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/apps_st/data/reference3.dbf |
84 | 0 | 3.81 | 1.31 | 1 | 0 | 16 | 2.50 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/apps_st/data/reference4.dbf |
7 | 0 | 0.00 | 2.86 | 1 | 0 | 8 | 5.00 |
| APPS_TS_SEED | /ds1/oracle/VIS/db/apps_st/data/reference5.dbf |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary1.dbf |
4 | 0 | 2.50 | 1.00 | 392 | 0 | 3,160 | 0.50 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary10.dbf |
6 | 0 | 3.33 | 1.00 | 390 | 0 | 3,358 | 0.55 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary11.dbf |
4 | 0 | 2.50 | 1.00 | 403 | 0 | 3,460 | 0.44 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary12.dbf |
12 | 0 | 4.17 | 1.00 | 404 | 0 | 5,084 | 0.34 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary13.dbf |
34 | 0 | 2.35 | 1.00 | 398 | 0 | 5,151 | 0.38 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary2.dbf |
4 | 0 | 2.50 | 1.00 | 402 | 0 | 4,787 | 0.38 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary3.dbf |
6 | 0 | 3.33 | 1.00 | 33 | 0 | 1,771 | 0.08 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary4.dbf |
6 | 0 | 3.33 | 1.00 | 406 | 0 | 4,024 | 0.44 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary5.dbf |
35 | 0 | 1.71 | 1.00 | 398 | 0 | 3,377 | 0.46 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary6.dbf |
4 | 0 | 2.50 | 1.00 | 396 | 0 | 3,260 | 0.81 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary7.dbf |
19 | 0 | 1.05 | 1.00 | 401 | 0 | 3,621 | 0.51 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary8.dbf |
5 | 0 | 4.00 | 1.00 | 5 | 0 | 1 | 10.00 |
| APPS_TS_SUMMARY | /ds1/oracle/VIS/db/apps_st/data/summary9.dbf |
5 | 0 | 2.00 | 1.00 | 393 | 0 | 3,375 | 0.42 |
| APPS_TS_TOOLS | /ds1/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data1.dbf |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data10.dbf |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data11.dbf |
75 | 0 | 1.07 | 6.33 | 1 | 0 | 167 | 0.36 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data12.dbf |
67 | 0 | 1.19 | 6.96 | 1 | 0 | 170 | 0.71 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data13.dbf |
70 | 0 | 1.14 | 6.70 | 4 | 0 | 173 | 0.46 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data14.dbf |
4 | 0 | 2.50 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data15.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data16.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data17.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data18.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data19.dbf |
58 | 0 | 0.52 | 7.21 | 1 | 0 | 168 | 0.60 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data2.dbf |
62 | 0 | 0.48 | 7.21 | 1 | 0 | 179 | 0.50 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data20.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data21.dbf |
67 | 0 | 1.04 | 6.76 | 2 | 0 | 168 | 0.06 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data22.dbf |
62 | 0 | 1.13 | 7.10 | 1 | 0 | 172 | 0.47 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data23.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data24.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data25.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data26.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data27.dbf |
70 | 0 | 4.57 | 1.81 | 74 | 0 | 2,838 | 0.05 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data28.dbf |
14 | 0 | 4.29 | 1.29 | 19 | 0 | 243 | 0.08 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data29.dbf |
12 | 0 | 3.33 | 1.00 | 1 | 0 | 1 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data3.dbf |
5 | 0 | 2.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data30.dbf |
6 | 0 | 3.33 | 1.00 | 6 | 0 | 29 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data31.dbf |
20 | 0 | 2.00 | 1.00 | 10 | 0 | 1,042 | 0.06 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data32.dbf |
98 | 0 | 2.35 | 5.11 | 8 | 0 | 170 | 0.35 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data33.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data34.dbf |
7 | 0 | 5.71 | 1.43 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data35.dbf |
9 | 0 | 5.56 | 2.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data36.dbf |
12 | 0 | 3.33 | 2.25 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data37.dbf |
8 | 0 | 3.75 | 1.75 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data38.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data39.dbf |
77 | 0 | 2.08 | 6.14 | 7 | 0 | 173 | 0.98 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data4.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data40.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data41.dbf |
58 | 0 | 0.52 | 7.16 | 1 | 0 | 170 | 0.88 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data42.dbf |
58 | 0 | 0.86 | 7.16 | 1 | 0 | 167 | 0.96 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data43.dbf |
78 | 0 | 1.79 | 6.44 | 3 | 0 | 172 | 0.70 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data44.dbf |
79 | 0 | 1.27 | 6.37 | 8 | 0 | 175 | 0.69 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data45.dbf |
73 | 0 | 2.19 | 6.62 | 2 | 0 | 168 | 1.07 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data46.dbf |
69 | 0 | 0.72 | 6.96 | 2 | 0 | 166 | 0.66 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data47.dbf |
79 | 0 | 1.65 | 6.22 | 8 | 0 | 167 | 0.48 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data48.dbf |
68 | 0 | 1.62 | 7.07 | 1 | 0 | 171 | 0.70 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data49.dbf |
84 | 0 | 2.38 | 5.90 | 5 | 0 | 179 | 0.89 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data5.dbf |
6 | 0 | 1.67 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data50.dbf |
73 | 0 | 1.37 | 6.47 | 1 | 0 | 185 | 0.16 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data51.dbf |
158 | 0 | 3.48 | 3.70 | 88 | 0 | 197 | 0.91 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data52.dbf |
59 | 0 | 1.02 | 7.07 | 1 | 0 | 181 | 0.66 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data53.dbf |
572 | 0 | 4.42 | 1.11 | 677 | 0 | 7,119 | 0.33 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data54.dbf |
532 | 0 | 3.14 | 1.09 | 635 | 0 | 7,764 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data55.dbf |
508 | 0 | 3.41 | 1.08 | 596 | 0 | 6,951 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data56.dbf |
515 | 0 | 5.15 | 1.08 | 616 | 0 | 7,410 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data57.dbf |
516 | 0 | 4.30 | 1.08 | 629 | 0 | 7,222 | 0.34 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data58.dbf |
524 | 0 | 3.87 | 1.08 | 622 | 0 | 8,689 | 0.19 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data59.dbf |
505 | 0 | 2.93 | 1.08 | 587 | 0 | 7,484 | 0.25 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data6.dbf |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data60.dbf |
514 | 0 | 3.79 | 1.10 | 571 | 0 | 8,065 | 0.26 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data61.dbf |
501 | 0 | 3.71 | 1.11 | 583 | 0 | 7,505 | 0.23 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data62.dbf |
513 | 0 | 4.00 | 1.11 | 566 | 0 | 6,843 | 0.26 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data63.dbf |
504 | 0 | 3.71 | 1.10 | 591 | 0 | 7,127 | 0.31 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data64.dbf |
502 | 0 | 4.36 | 1.10 | 542 | 0 | 6,931 | 0.37 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data65.dbf |
497 | 0 | 3.86 | 1.08 | 532 | 0 | 7,328 | 0.32 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data66.dbf |
520 | 0 | 4.15 | 1.08 | 539 | 0 | 7,768 | 0.22 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data67.dbf |
498 | 0 | 4.20 | 1.08 | 534 | 0 | 7,416 | 0.42 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data68.dbf |
505 | 0 | 4.42 | 1.08 | 525 | 0 | 7,586 | 0.21 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data69.dbf |
507 | 0 | 3.81 | 1.08 | 506 | 0 | 6,824 | 0.43 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data7.dbf |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data70.dbf |
500 | 0 | 4.36 | 1.08 | 521 | 0 | 7,659 | 0.37 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data71.dbf |
480 | 0 | 4.48 | 1.09 | 538 | 0 | 8,045 | 0.27 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data72.dbf |
493 | 0 | 3.53 | 1.08 | 527 | 0 | 6,636 | 0.62 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data73.dbf |
489 | 0 | 4.05 | 1.09 | 547 | 0 | 6,996 | 0.32 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data74.dbf |
499 | 0 | 3.45 | 1.08 | 530 | 0 | 7,877 | 0.28 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data75.dbf |
477 | 0 | 4.44 | 1.09 | 519 | 0 | 6,991 | 0.33 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data76.dbf |
474 | 0 | 4.32 | 1.09 | 529 | 0 | 6,900 | 0.48 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data77.dbf |
492 | 0 | 3.41 | 1.09 | 532 | 0 | 6,471 | 0.34 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data78.dbf |
484 | 0 | 3.93 | 1.08 | 535 | 0 | 7,507 | 0.35 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data8.dbf |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_DATA | /ds1/oracle/VIS/db/apps_st/data/tx_data9.dbf |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx1.dbf |
93 | 0 | 3.87 | 1.00 | 340 | 0 | 3,335 | 0.20 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx10.dbf |
135 | 0 | 3.26 | 1.00 | 220 | 0 | 307 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx11.dbf |
31 | 0 | 4.52 | 1.00 | 31 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx12.dbf |
13 | 0 | 3.85 | 1.00 | 15 | 0 | 4 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx13.dbf |
20 | 0 | 2.00 | 1.00 | 18 | 0 | 4 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx14.dbf |
34 | 0 | 5.00 | 1.00 | 17 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx15.dbf |
21 | 0 | 2.86 | 1.00 | 31 | 0 | 39 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx16.dbf |
64 | 0 | 5.47 | 1.00 | 79 | 0 | 33 | 1.21 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx17.dbf |
37 | 0 | 5.14 | 1.00 | 34 | 0 | 25 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx18.dbf |
28 | 0 | 4.29 | 1.00 | 33 | 0 | 24 | 0.42 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx19.dbf |
23 | 0 | 1.74 | 1.00 | 27 | 0 | 2 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx2.dbf |
29 | 0 | 3.10 | 1.00 | 65 | 0 | 33 | 0.30 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx20.dbf |
22 | 0 | 1.82 | 1.00 | 9 | 0 | 84 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx21.dbf |
22 | 0 | 2.27 | 1.00 | 9 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx22.dbf |
90 | 0 | 5.56 | 1.00 | 69 | 0 | 86 | 0.47 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx23.dbf |
25 | 0 | 3.20 | 1.00 | 33 | 0 | 3 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx24.dbf |
30 | 0 | 2.33 | 1.00 | 19 | 0 | 0 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx25.dbf |
934 | 0 | 3.98 | 1.00 | 1,340 | 0 | 8,370 | 0.31 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx26.dbf |
827 | 0 | 4.53 | 1.00 | 1,278 | 0 | 6,119 | 0.26 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx27.dbf |
883 | 0 | 4.00 | 1.00 | 1,299 | 0 | 5,549 | 0.32 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx28.dbf |
951 | 0 | 4.16 | 1.00 | 1,239 | 0 | 5,258 | 0.25 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx29.dbf |
928 | 0 | 3.45 | 1.00 | 1,234 | 0 | 5,414 | 0.28 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx3.dbf |
20 | 0 | 3.00 | 1.00 | 61 | 0 | 15 | 0.67 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx30.dbf |
897 | 0 | 4.35 | 1.00 | 1,151 | 0 | 6,006 | 0.24 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx31.dbf |
889 | 0 | 3.46 | 1.00 | 1,075 | 0 | 5,754 | 0.18 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx32.dbf |
782 | 0 | 3.73 | 1.00 | 1,089 | 0 | 35,473 | 0.26 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx33.dbf |
813 | 0 | 3.41 | 1.00 | 1,120 | 0 | 5,021 | 0.31 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx34.dbf |
748 | 0 | 4.09 | 1.02 | 1,055 | 0 | 5,138 | 0.21 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx35.dbf |
771 | 0 | 4.28 | 1.02 | 1,034 | 0 | 4,875 | 0.63 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx36.dbf |
734 | 0 | 3.86 | 1.01 | 1,057 | 0 | 4,859 | 0.33 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx37.dbf |
748 | 0 | 3.38 | 1.00 | 1,015 | 0 | 6,002 | 0.32 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx38.dbf |
732 | 0 | 3.95 | 1.00 | 988 | 0 | 5,574 | 0.35 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx39.dbf |
744 | 0 | 4.23 | 1.00 | 1,057 | 0 | 5,666 | 0.34 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx4.dbf |
13 | 0 | 4.62 | 1.00 | 15 | 0 | 1 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx40.dbf |
728 | 0 | 4.57 | 1.00 | 1,032 | 0 | 8,160 | 0.26 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx41.dbf |
701 | 0 | 3.89 | 1.00 | 1,006 | 0 | 5,322 | 0.36 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx42.dbf |
742 | 0 | 3.53 | 1.00 | 1,013 | 0 | 5,640 | 0.39 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx43.dbf |
713 | 0 | 4.77 | 1.00 | 1,014 | 0 | 6,471 | 0.39 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx44.dbf |
743 | 0 | 4.99 | 1.00 | 965 | 0 | 5,038 | 0.44 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx45.dbf |
695 | 0 | 4.59 | 1.00 | 1,028 | 0 | 4,939 | 0.41 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx46.dbf |
682 | 0 | 4.13 | 1.00 | 1,008 | 0 | 4,714 | 0.27 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx47.dbf |
661 | 0 | 3.90 | 1.00 | 1,045 | 0 | 7,294 | 0.39 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx48.dbf |
687 | 0 | 4.54 | 1.00 | 916 | 0 | 4,705 | 0.28 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx49.dbf |
697 | 0 | 4.13 | 1.00 | 958 | 0 | 4,910 | 0.33 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx5.dbf |
16 | 0 | 5.63 | 1.00 | 29 | 0 | 2,042 | 0.04 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx6.dbf |
10 | 0 | 7.00 | 1.00 | 11 | 0 | 1 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx7.dbf |
58 | 0 | 5.00 | 1.00 | 225 | 0 | 25 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx8.dbf |
28 | 0 | 5.00 | 1.00 | 45 | 0 | 9 | 0.00 |
| APPS_TS_TX_IDX | /ds1/oracle/VIS/db/apps_st/data/tx_idx9.dbf |
29 | 0 | 5.52 | 1.00 | 16 | 0 | 17 | 0.00 |
| APPS_UNDOTS1 | /ds1/oracle/VIS/db/apps_st/data/undo.dbf |
1 | 0 | 0.00 | 1.00 | 70,185 | 24 | 513,805 | 0.29 |
| B2B_DT | /ds1/oracle/VIS/db/apps_st/data/b2b_dt.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_IDX | /ds1/oracle/VIS/db/apps_st/data/b2b_idx.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_LOB | /ds1/oracle/VIS/db/apps_st/data/b2b_lob.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| B2B_RT | /ds1/oracle/VIS/db/apps_st/data/b2b_rt.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| BAM | /ds1/oracle/VIS/db/apps_st/data/bam.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| CTXSYS | /ds1/oracle/VIS/db/apps_st/data/ctx1.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| CTXSYS | /ds1/oracle/VIS/db/apps_st/data/ctx2.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| CWMLITE | /ds1/oracle/VIS/db/apps_st/data/cwmlite01.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| CWMLITE | /ds1/oracle/VIS/db/apps_st/data/cwmlite02.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| DCM | /ds1/oracle/VIS/db/apps_st/data/dcm.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| DCM | /ds1/oracle/VIS/db/apps_st/data/dcm1.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| DISCO_PTM5_CACHE | /ds1/oracle/VIS/db/apps_st/data/discopltc1.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| DISCO_PTM5_META | /ds1/oracle/VIS/db/apps_st/data/discopltm1.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| DSGATEWAY_TAB | /ds1/oracle/VIS/db/apps_st/data/oss_sys01.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds1/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| GEOR_TBS | /ds1/oracle/VIS/db/apps_st/data/geor_tbs02.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| HTMLDB | /ds1/oracle/VIS/db/apps_st/data/htmldb.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| IAS_META | /ds1/oracle/VIS/db/apps_st/data/ias_meta01.dbf |
15 | 0 | 4.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| MTR | /ds1/oracle/VIS/db/apps_st/data/opmtr01.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NOETIX | /ds1/oracle/VIS/db/apps_st/data/noetix.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| NON_APPS_TS_DATA | /ds1/oracle/VIS/db/apps_st/data/non_apps_data1.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OCATS | /ds1/oracle/VIS/db/apps_st/data/oca.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| ODM_DATA | /ds1/oracle/VIS/db/apps_st/data/odm.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_ATTRSTORE | /ds1/oracle/VIS/db/apps_st/data/attrs1_oid.dbf |
15 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_BATTRSTORE | /ds1/oracle/VIS/db/apps_st/data/battrs1_oid.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_CT_STORE | /ds1/oracle/VIS/db/apps_st/data/gcats1_oid.dbf |
10 | 0 | 4.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_DEFAULT | /ds1/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf |
9 | 0 | 5.56 | 1.00 | 1 | 0 | 0 | 0.00 |
| OLTS_SVRMGSTORE | /ds1/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OPMOR | /ds1/oracle/VIS/db/apps_st/data/opmor01.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| ORABPEL | /ds1/oracle/VIS/db/apps_st/data/orabpel.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| OWAPUB | /ds1/oracle/VIS/db/apps_st/data/owa1.dbf |
6 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL | /ds1/oracle/VIS/db/apps_st/data/portal.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_DOC | /ds1/oracle/VIS/db/apps_st/data/ptldoc.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_IDX | /ds1/oracle/VIS/db/apps_st/data/ptlidx.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| PORTAL_LOG | /ds1/oracle/VIS/db/apps_st/data/ptllog.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| RE | /ds1/oracle/VIS/db/apps_st/data/opre01.dbf |
7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
| SYNCSERVER | /ds1/oracle/VIS/db/apps_st/data/mobile01.dbf |
7 | 0 | 2.86 | 1.00 | 1 | 0 | 0 | 0.00 |
| SYSAUX | /ds1/oracle/VIS/db/apps_st/data/sysaux01.dbf |
308 | 0 | 2.24 | 1.00 | 274 | 0 | 0 | 0.00 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys1.dbf |
66 | 0 | 1.97 | 4.32 | 46 | 0 | 2,357 | 0.09 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys10.dbf |
65 | 0 | 2.62 | 4.31 | 49 | 0 | 3,103 | 0.11 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys2.dbf |
65 | 0 | 2.31 | 4.22 | 39 | 0 | 2,389 | 0.08 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys3.dbf |
121 | 0 | 3.31 | 3.27 | 90 | 0 | 1,472 | 0.12 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys4.dbf |
113 | 0 | 2.57 | 3.03 | 64 | 0 | 7 | 1.43 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys5.dbf |
111 | 0 | 2.79 | 3.12 | 50 | 0 | 67 | 2.24 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys6.dbf |
120 | 0 | 2.08 | 3.49 | 41 | 0 | 311 | 0.19 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys7.dbf |
117 | 0 | 2.22 | 3.56 | 21 | 0 | 190 | 0.32 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys8.dbf |
128 | 0 | 2.50 | 3.38 | 48 | 0 | 805 | 0.14 |
| SYSTEM | /ds1/oracle/VIS/db/apps_st/data/sys9.dbf |
81 | 0 | 1.11 | 3.83 | 27 | 0 | 1,121 | 0.19 |
| TEMP | /ds1/oracle/VIS/db/apps_st/data/tempx01.dbf |
38 | 0 | 0.53 | 7.53 | 24 | 0 | 0 | |
| TEMP | /ds1/oracle/VIS/db/apps_st/data/tempx02.dbf |
3 | 0 | 3.33 | 1.00 | 8 | 0 | 0 | |
| UDDISYS_TS | /ds1/oracle/VIS/db/apps_st/data/uddisys01.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| WCRSYS_TS | /ds1/oracle/VIS/db/apps_st/data/wcrsys01.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
| XDB | /ds1/oracle/VIS/db/apps_st/data/xdb01.dbf |
6 | 0 | 3.33 | 1.00 | 1 | 0 | 0 | 0.00 |
Back to IO Stats
Back to Top
Buffer Pool Statistics
- Standard block size Pools D: default, K: keep, R: recycle
- Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|
| D | 1,013,248 | 100 | 1,343,716,845 | 57,742 | 1,566,336 | 0 | 0 | 1,057,602 |
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 | 37 | 7037 | 199734 | 2039162 | 92152620 | 2039162 | |
| E | 0 | 82 | 92785 | 2345046 | 10117796 | 92152620 | 10117796 | |
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 | 816 | 0.10 | 100,929 | 1.33 | 1,114,924 |
| D | 1,632 | 0.20 | 201,858 | 1.16 | 970,308 |
| D | 2,448 | 0.30 | 302,787 | 1.09 | 915,180 |
| D | 3,264 | 0.40 | 403,716 | 1.06 | 890,050 |
| D | 4,080 | 0.50 | 504,645 | 1.05 | 878,245 |
| D | 4,896 | 0.60 | 605,574 | 1.04 | 865,957 |
| D | 5,712 | 0.70 | 706,503 | 1.03 | 857,195 |
| D | 6,528 | 0.80 | 807,432 | 1.01 | 847,495 |
| D | 7,344 | 0.90 | 908,361 | 1.00 | 839,754 |
| D | 8,160 | 1.00 | 1,009,290 | 1.00 | 836,016 |
| D | 8,192 | 1.00 | 1,013,248 | 1.00 | 835,943 |
| D | 8,976 | 1.10 | 1,110,219 | 1.00 | 831,929 |
| D | 9,792 | 1.20 | 1,211,148 | 0.98 | 819,794 |
| D | 10,608 | 1.29 | 1,312,077 | 0.97 | 814,641 |
| D | 11,424 | 1.39 | 1,413,006 | 0.96 | 801,146 |
| D | 12,240 | 1.49 | 1,513,935 | 0.96 | 801,107 |
| D | 13,056 | 1.59 | 1,614,864 | 0.96 | 801,101 |
| D | 13,872 | 1.69 | 1,715,793 | 0.96 | 801,073 |
| D | 14,688 | 1.79 | 1,816,722 | 0.96 | 801,045 |
| D | 15,504 | 1.89 | 1,917,651 | 0.96 | 800,074 |
| D | 16,320 | 1.99 | 2,018,580 | 0.95 | 792,457 |
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 |
|---|
| 100.00 | 64,271 | 0 |
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 | 2,048 | 1,702 | 275.78 | 0.00 | 0.00 | 0.00 | 0.00 | 209,710 |
| E | 2,048 | 1,697 | 272.68 | 0.00 | 0.00 | 0.00 | 0.00 | 209,710 |
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,825,140 | 1,825,140 | 0 | 0 |
| 64K | 128K | 1,488 | 1,488 | 0 | 0 |
| 128K | 256K | 98 | 98 | 0 | 0 |
| 256K | 512K | 778 | 778 | 0 | 0 |
| 512K | 1024K | 10,500 | 10,500 | 0 | 0 |
| 1M | 2M | 45,335 | 45,335 | 0 | 0 |
| 2M | 4M | 382 | 382 | 0 | 0 |
| 4M | 8M | 65 | 65 | 0 | 0 |
| 8M | 16M | 10 | 10 | 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 |
|---|
| 256 | 0.13 | 129,393.02 | 1,633.17 | 99.00 | 292 |
| 512 | 0.25 | 129,393.02 | 523.22 | 100.00 | 75 |
| 1,024 | 0.50 | 129,393.02 | 451.26 | 100.00 | 53 |
| 1,536 | 0.75 | 129,393.02 | 333.95 | 100.00 | 28 |
| 2,048 | 1.00 | 129,393.02 | 0.00 | 100.00 | 8 |
| 2,458 | 1.20 | 129,393.02 | 0.00 | 100.00 | 0 |
| 2,867 | 1.40 | 129,393.02 | 0.00 | 100.00 | 0 |
| 3,277 | 1.60 | 129,393.02 | 0.00 | 100.00 | 0 |
| 3,686 | 1.80 | 129,393.02 | 0.00 | 100.00 | 0 |
| 4,096 | 2.00 | 129,393.02 | 0.00 | 100.00 | 0 |
| 6,144 | 3.00 | 129,393.02 | 0.00 | 100.00 | 0 |
| 8,192 | 4.00 | 129,393.02 | 0.00 | 100.00 | 0 |
| 12,288 | 6.00 | 129,393.02 | 0.00 | 100.00 | 0 |
| 16,384 | 8.00 | 129,393.02 | 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 |
|---|
| 592 | 0.29 | 237 | 10,391 | 1,296,806 | 1.00 | 294 | 1.14 | 93,697,758 |
| 800 | 0.39 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 1,008 | 0.49 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 1,216 | 0.59 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 1,424 | 0.70 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 1,632 | 0.80 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 1,840 | 0.90 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 2,048 | 1.00 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 2,256 | 1.10 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 2,464 | 1.20 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 2,672 | 1.30 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 2,880 | 1.41 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 3,088 | 1.51 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 3,296 | 1.61 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 3,504 | 1.71 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 3,712 | 1.81 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 3,920 | 1.91 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
| 4,128 | 2.02 | 331 | 16,650 | 1,296,842 | 1.00 | 258 | 1.00 | 93,700,254 |
Back to Advisory Statistics
Back to Top
|
