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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  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

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 % 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

  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

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

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

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

 

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 0.33 0 0 0 0
32 0.67 0 0 0 0
48 1.00 0 0 0 0
64 1.33 0 0 0 0
80 1.67 0 0 0 0
96 2.00 0 0 0 0
112 2.33 0 0 0 0
128 2.67 0 0 0 0
144 3.00 0 0 0 0
160 3.33 0 0 0 0
176 3.67 0 0 0 0
192 4.00 0 0 0 0
208 4.33 0 0 0 0
224 4.67 0 0 0 0
240 5.00 0 0 0 0
256 5.33 0 0 0 0
272 5.67 0 0 0 0
288 6.00 0 0 0 0
304 6.33 0 0 0 0
320 6.67 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.10 6 271 13 1.00 258 1.00 271
32 0.20 6 271 13 1.00 258 1.00 271
48 0.30 6 271 13 1.00 258 1.00 271
64 0.40 6 271 13 1.00 258 1.00 271
80 0.50 6 271 13 1.00 258 1.00 271
96 0.60 6 271 13 1.00 258 1.00 271
112 0.70 6 271 13 1.00 258 1.00 271
128 0.80 6 271 13 1.00 258 1.00 271
144 0.90 6 271 13 1.00 258 1.00 271
160 1.00 6 271 13 1.00 258 1.00 271
176 1.10 6 271 13 1.00 258 1.00 271
192 1.20 6 271 13 1.00 258 1.00 271
208 1.30 6 271 13 1.00 258 1.00 271
224 1.40 6 271 13 1.00 258 1.00 271
240 1.50 6 271 13 1.00 258 1.00 271
256 1.60 6 271 13 1.00 258 1.00 271
272 1.70 6 271 13 1.00 258 1.00 271
288 1.80 6 271 13 1.00 258 1.00 271
304 1.90 6 271 13 1.00 258 1.00 271
320 2.00 6 271 13 1.00 258 1.00 271

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 513,623 204 0
undo block 478,229 128 0
undo header 35,588 23 1
1st level bmb 21,434 4 0
segment header 8,290 1 0
2nd level bmb 301 0 0
extent map 29 0 0
3rd level bmb 15 0 1
file header block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TX-Transaction (row lock contention) 233,870 11,907 221,967 11,901 138 11.59
TX-Transaction (index contention) 18,858 18,858 0 18,289 43 2.34
TX-Transaction 901,730 901,977 0 6,080 14 2.29
HW-Segment High Water Mark 83,231 83,220 11 5,245 9 1.70
FB-Format Block 22,129 22,129 0 1,357 2 1.56
SQ-Sequence Cache 30,482 30,482 0 3,728 1 0.23
RO-Multiple Object Reuse (fast object reuse) 216 216 0 23 0 4.00
TX-Transaction (allocate ITL entry) 49 49 0 31 0 0.13
PS-PX Process Reservation 200 168 32 5 0 0.20

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,051.28 886,914 1,702 20   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
10-Sep 19:41 109,463 34,646 318 6 14 0/0 0/0/0/0/0/0
10-Sep 19:31 204,246 143,686 300 19 10 0/0 0/0/0/0/0/0
10-Sep 19:21 226,425 192,696 0 20 10 0/0 0/0/0/0/0/0
10-Sep 19:11 255,845 410,879 1,702 14 9 0/0 0/0/0/0/0/0
10-Sep 19:01 255,301 105,007 1,100 17 9 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,993 0.00   0 0  
AWR Alerted Metric Element list 21,217 0.00   0 0  
Consistent RBA 452,957 0.04 0.00 0 0  
FOB s.o list latch 12,078 0.12 0.00 0 0  
In memory undo latch 675,223,022 0.71 0.00 9 666,187 0.03
JOX SGA heap latch 1,722,873 0.00   0 0  
JS queue state obj latch 17,520 0.00   0 0  
JS slv state obj latch 27 0.00   0 0  
KMG MMAN ready and startup request latch 974 0.00   0 0  
KTF sga latch 9 0.00   0 950 0.00
KWQMN job cache list latch 206,709 0.16 0.22 0 0  
KWQP Prop Status 364 0.00   0 0  
MQL Tracking Latch 0     0 59 0.00
Memory Management Latch 0     0 974 0.00
OS process 1,248 0.00   0 0  
OS process allocation 1,807 0.06 0.00 0 0  
OS process: request allocation 765 0.13 0.00 0 0  
PL/SQL warning settings 1,283,618 0.00   0 0  
SGA IO buffer pool latch 172 0.00   0 172 0.00
SQL memory manager latch 1 0.00   0 973 0.00
SQL memory manager workarea list latch 476,646 0.01 0.00 0 0  
Shared B-Tree 1,894 0.00   0 0  
active checkpoint queue latch 114,437 0.00   0 0  
active service list 7,169 0.66 0.00 0 1,007 0.00
begin backup scn array 8 0.00   0 0  
bq:time manger info latch 105 0.00   0 0  
bufq statistics 3 0.00   0 0  
cache buffer handles 4,685,870 0.73 0.00 0 0  
cache buffers chains 3,436,299,369 2.01 0.00 73 12,037,570 4.22
cache buffers lru chain 5,410,942 0.48 0.01 2 31,327,929 0.70
cache table scan latch 0     0 1,898 0.00
channel handle pool latch 10,003 0.07 0.00 0 0  
channel operations parent latch 54,339 0.58 0.00 0 0  
checkpoint queue latch 3,943,708 0.01 0.02 0 1,650,546 0.03
client/application info 3,478 0.00   0 0  
commit callback allocation 222,264 0.28 0.00 0 0  
compile environment latch 42,075 0.00   0 0  
dictionary lookup 37 0.00   0 0  
dml lock allocation 4,953,567 3.55 0.00 2 0  
dummy allocation 869 1.27 0.00 0 0  
enqueue hash chains 7,819,634 1.18 0.00 3 316 0.00
enqueues 1,216,426 0.34 0.00 0 0  
error message lists 85 18.82 0.00 0 0  
event group latch 383 0.00   0 0  
file cache latch 23,973 0.01 0.00 0 0  
global KZLD latch for mem in SGA 365 0.00   0 0  
global ctx hash table latch 271,064 0.00   0 0  
hash table column usage latch 524 0.00   0 136,351 0.00
hash table modification latch 125 0.00   0 0  
job workq parent latch 0     0 24 0.00
job_queue_processes parameter latch 58 0.00   0 0  
kks stats 2,588 0.00   0 0  
ksuosstats global area 197 0.00   0 0  
ktm global data 2,613 0.00   0 0  
kwqbsn:qsga 1,785 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 454,874 0.23 0.00 0 0  
library cache 89,173,978 1.66 0.00 40 158 0.00
library cache load lock 184 0.54 0.00 0 0  
library cache lock 12,675,606 0.71 0.00 3 0  
library cache lock allocation 41,098 0.01 0.00 0 0  
library cache pin 57,191,593 1.06 0.00 13 0  
library cache pin allocation 20,048 0.00   0 0  
list of block allocation 287,758 0.10 0.03 0 0  
loader state object freelist 5,922 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 3 0.00   0 3 0.00
message pool operations parent latch 9,730 0.12 0.00 0 0  
messages 1,674,519 0.38 0.00 0 0  
mostly latch-free SCN 486,314 4.21 0.00 0 0  
multiblock read objects 3,938 0.00   0 0  
ncodef allocation latch 48 0.00   0 0  
object queue header heap 466,365 0.00 0.00 0 9,037 0.00
object queue header operation 10,524,837 0.06 0.01 0 0  
object stats modification 9,632 0.00   0 0  
parallel query alloc buffer 1,172 1.71 0.00 0 0  
parallel query stats 55 40.00 0.00 0 0  
parameter list 1,248 0.00   0 0  
parameter table allocation management 441 5.44 0.08 0 0  
post/wait queue 248,656 0.30 0.00 0 100,513 1.56
process allocation 770 0.26 0.50 0 383 0.00
process group creation 765 0.13 0.00 0 0  
process queue 522 2.87 0.00 0 0  
process queue reference 94,803 0.07 0.00 0 9,484 273.33
qmn task queue latch 2,764 7.16 0.14 0 0  
query server freelists 447 9.84 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 3,150,528 1.89 0.02 4 68,545,848 1.37
redo copy 0     0 68,622,366 0.03
redo writing 1,859,918 0.01 0.04 0 0  
resmgr group change latch 2,402 0.00   0 0  
resmgr:actses active list 1,235 0.40 0.00 0 0  
resmgr:actses change group 1,148 0.00   0 0  
resmgr:free threads list 869 2.76 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 29,986,060 1.90 0.00 6 0  
rules engine aggregate statistics 105,002 1.60 0.00 0 0  
rules engine rule set statistics 419,998 0.80 0.00 0 0  
rules engine rule statistics 209,885 0.00   0 0  
sequence cache 5,807,331 0.69 0.00 0 0  
session allocation 6,623,818 1.05 0.00 3 0  
session idle bit 382,056 0.01 0.00 0 0  
session state list latch 2,342 0.81 0.00 0 0  
session switching 48 0.00   0 0  
session timer 1,007 0.00   0 0  
shared pool 12,526,615 1.32 0.00 6 0  
shared pool sim alloc 25 0.00   0 0  
shared pool simulator 3,255,185 0.00 0.00 0 0  
simulator hash latch 76,488,199 0.01 0.00 0 0  
simulator lru latch 76,333,699 1.91 0.00 16 58,992 0.13
sort extent pool 31,387 0.09 0.04 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temporary table state object allocation 381 0.26 0.00 0 0  
threshold alerts latch 604 0.00   0 0  
transaction allocation 27,676 0.01 0.00 0 0  
transaction branch allocation 48 0.00   0 0  
undo global data 774,557,784 3.56 0.00 5 72 0.00
user lock 1,482 0.20 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 3,436,299,369 69,080,526 34,293 69,050,891 0 0 0
undo global data 774,557,784 27,570,694 2,010 27,569,069 0 0 0
In memory undo latch 675,223,022 4,791,948 2,631 4,789,574 0 0 0
library cache 89,173,978 1,477,656 2,850 1,475,116 0 0 0
simulator lru latch 76,333,699 1,456,839 1,868 1,455,217 0 0 0
library cache pin 57,191,593 607,121 1,020 606,194 0 0 0
row cache objects 29,986,060 569,171 564 568,682 0 0 0
dml lock allocation 4,953,567 176,096 167 175,945 0 0 0
shared pool 12,526,615 165,827 674 165,218 0 0 0
enqueue hash chains 7,819,634 92,116 189 91,948 0 0 0
library cache lock 12,675,606 90,570 130 90,451 0 0 0
session allocation 6,623,818 69,675 251 69,451 0 0 0
redo allocation 3,150,528 59,602 934 58,729 0 0 0
sequence cache 5,807,331 39,829 10 39,820 0 0 0
cache buffer handles 4,685,870 34,021 7 34,014 0 0 0
cache buffers lru chain 5,410,942 25,821 270 25,575 0 0 0
simulator hash latch 76,488,199 7,786 11 7,775 0 0 0
messages 1,674,519 6,344 6 6,339 0 0 0
object queue header operation 10,524,837 6,000 55 5,951 0 0 0
enqueues 1,216,426 4,170 8 4,163 0 0 0
rules engine rule set statistics 419,998 3,371 5 3,366 0 0 0
checkpoint queue latch 3,943,708 458 7 452 0 0 0
KWQMN job cache list latch 206,709 338 74 269 0 0 0
channel operations parent latch 54,339 315 1 314 0 0 0
list of block allocation 287,758 302 9 293 0 0 0
redo writing 1,859,918 208 8 200 0 0 0
qmn task queue latch 2,764 198 27 171 0 0 0
sort extent pool 31,387 27 1 26 0 0 0
parameter table allocation management 441 24 2 22 0 0 0
process allocation 770 2 1 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 1,301 1,444
In memory undo latch ktiFlush: child 0 884 568
In memory undo latch ktiTxnPoolFree 0 185 0
In memory undo latch ktichg: child 0 120 569
In memory undo latch kticmt: child 0 117 0
In memory undo latch ktiBRacquire 0 14 0
In memory undo latch ktbgfc 0 8 48
KWQMN job cache list latch kwqmnuji: update job item 0 77 73
active service list ksws_event: ksws event 0 2 1
cache buffer handles kcbzgs 0 4 3
cache buffer handles kcbzfs 0 3 4
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 235,646 221,411
cache buffers chains kcbgtcr: fast path 0 66,996 19,690
cache buffers chains kcbgtcr: kslbegin excl 0 34,465 16,173
cache buffers chains kcbgcur: kslbegin 0 30,042 5,781
cache buffers chains kcbchg: kslbegin: call CR func 0 15,312 113,531
cache buffers chains kcbget: pin buffer 0 8,189 1,732
cache buffers chains kcbzwb 0 4,346 1,358
cache buffers chains kcbrls: kslbegin 0 1,831 11,303
cache buffers chains kcbzgb: scan from tail. nowait 0 801 0
cache buffers chains kcbget: exchange rls 0 242 47
cache buffers chains kcbget: exchange 0 233 74
cache buffers chains kcbnlc 0 162 537
cache buffers chains kcbcge 0 133 2,549
cache buffers chains kcbgtcr: kslbegin shared 0 64 46
cache buffers chains kcb_is_private 0 60 4,989
cache buffers chains kcbnew: new latch again 0 21 1
cache buffers chains kcb_pre_apply: kcbhq61 0 6 522
cache buffers chains kcbbic1 0 4 2
cache buffers chains kcbbic2 0 3 1
cache buffers chains kcbesc: escalate 0 3 1
cache buffers chains kcb_post_apply: kcbhq62 0 2 22
cache buffers chains kcbso1: set no access 0 2 7
cache buffers chains kcb_post_apply: kcbhq63 0 1 11
cache buffers lru chain kcbzgws 0 143 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 81 0
cache buffers lru chain kcbzswcu 0 32 4
cache buffers lru chain kcbzgb: posted for free bufs 0 9 194
cache buffers lru chain kcbbxsv: move to being written 0 4 14
cache buffers lru chain kcbbic2 0 1 102
channel operations parent latch ksrssonsume() 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 0
checkpoint queue latch kcbswcu: Switch buffers 0 3 5
dml lock allocation ktaiam 0 119 126
dml lock allocation ktaidm 0 48 41
enqueue hash chains ksqgtl3 0 131 122
enqueue hash chains ksqrcl 0 58 67
enqueues ksqgel: create enqueue 0 7 7
enqueues ksqdel 0 1 1
event range base latch No latch 0 27 27
library cache kglpnp: child 0 1,262 1,733
library cache kglpndl: child: after processing 0 1,139 10
library cache kglobpn: child: 0 181 465
library cache kglpndl: child: before processing 0 154 556
library cache kglScanDependency 0 50 0
library cache kglLockCursor 0 24 34
library cache kglget: unpin heap 0 0 8 11
library cache kglhdgn: child: 0 5 39
library cache kglpin 0 2 2
library cache lock kgllkdl: child: cleanup 0 92 66
library cache lock kgllkal: child: multiinstance 0 38 64
library cache lock kgllkdl: child: no lock handle 0 25 0
library cache pin kglpndl 0 504 237
library cache pin kglpnp: child 0 459 612
library cache pin kglpnal: child: alloc space 0 57 171
list of block allocation ktlabl 0 8 8
list of block allocation ktlbbl 0 1 1
messages ksaamb: after wakeup 0 5 3
messages ksarcv 0 1 2
object queue header operation kcbo_switch_cq 0 27 25
object queue header operation kcbw_link_q 0 11 12
object queue header operation kcbw_unlink_q 0 11 14
object queue header operation kcbo_swap_buf 0 8 0
object queue header operation kcbo_ivbo 0 6 0
object queue header operation kcbo_switch_mq_bg 0 1 9
parameter table allocation management ksp_param_table_free 0 2 2
process allocation ksucrp 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 777 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 90 535
redo allocation kcrfw_redo_write: before write 0 30 129
redo allocation kcrfw_redo_write: more space 0 23 268
redo allocation kcrfw_redo_gen: redo allocation 2 0 12 0
redo allocation kcrf_pvt_strand_unbind 0 2 0
redo writing kcrfw_post: rba scn pair 0 8 0
row cache objects kqreqd: reget 0 470 0
row cache objects kqrpre: find obj 0 77 560
row cache objects kqreqd 0 17 4
rules engine rule set statistics kwrsoef: find ectx stats 0 5 1
sequence cache kdnssd 0 7 0
sequence cache kdnnxt: cached seq 0 2 0
sequence cache kdnss 0 1 24
session allocation ksudlc 0 143 51
session allocation ksuprc 0 102 193
session allocation ksuxds: KSUSFCLC not set 0 5 5
session allocation ksuxds: not user session 0 1 3
shared pool kghalo 0 380 516
shared pool kghfre 0 208 79
shared pool kghupr1 0 86 79
simulator hash latch kcbsacc: lookup dba 0 10 11
simulator hash latch kcbs_lookup_setid: lookup dba 0 1 0
simulator lru latch kcbs_simulate: simulate set 0 1,848 1,779
simulator lru latch kcbs_simbufseq 0 20 89
sort extent pool ktstdt: dealloc sort extent 0 1 0
undo global data kturimugur: child 0 1,592 692
undo global data ktudba: KSLBEGIN 0 385 1,283
undo global data ktudnx:child 0 20 11
undo global data ktubnd:child 0 5 0
undo global data ktucof: at start 0 4 0
undo global data ktufrbs: child 0 3 23
undo global data kturar: KSLBEGIN 0 1 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_IDX RA_INTERFACE_LINES_C01   INDEX 44,706,336 3.32
APPLSYS APPS_TS_SEED WF_ACTIVITIES_PK   INDEX 43,702,592 3.24
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 42,894,592 3.18
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_PK WF_ITEM49 INDEX PARTITION 29,625,648 2.20
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 29,582,720 2.20

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 15,420 26.17
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 10,798 18.33
AR APPS_TS_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 4,546 7.72
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 1,617 2.74
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 384 0.65

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 965,936 49.00
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_153630   INDEX 525,545 26.66
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 443,401 22.49
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 22,931 1.16
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 3,650 0.19

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_PK WF_ITEM49 INDEX PARTITION 3 50.00
ASO APPS_TS_QUEUES SYS_IOT_TOP_114472   INDEX 2 33.33
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 1 16.67

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 62,777 13.30
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 47,891 10.15
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 42,915 9.09
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 42,477 9.00
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_153630   INDEX 31,680 6.71

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 53 0.00 0   2 1
dc_constraints 128 50.00 0   128 65
dc_global_oids 1,203,851 0.00 0   4 94
dc_histogram_data 826 1.94 0   0 1,988
dc_histogram_defs 23,923 3.06 0   491 17,500
dc_object_grants 241 0.00 0   0 606
dc_object_ids 3,285,898 0.00 0   19 4,296
dc_objects 206,332 0.04 0   159 5,415
dc_profiles 377 0.00 0   0 1
dc_rollback_segments 23,461 0.00 0   0 509
dc_segments 36,698 0.09 0   21,545 5,015
dc_sequences 41,752 0.00 0   41,752 75
dc_table_scns 201,625 0.00 0   0 15
dc_tablespace_quotas 22,716 0.00 0   0 34
dc_tablespaces 360,931 0.00 0   0 57
dc_usernames 485,263 0.00 0   0 73
dc_users 4,307,422 0.00 0   0 246
outstanding_alerts 277 0.00 0   1 54


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 16,805 0.02 10,092,784 -0.00 0 0
CLUSTER 1 0.00 1 0.00 0 0
INDEX 132 12.12 270 8.89 0 0
JAVA DATA 108 0.00 0   0 0
PIPE 1,023 0.00 1,023 0.00 0 0
SQL AREA 277 90.61 48,940,731 0.02 339 337
TABLE/PROCEDURE 16,993 0.37 15,012,742 -0.00 8 0
TRIGGER 831 0.00 787,917 -0.00 0 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 179.43   1.99 2.34 22 35 90 90
  Freeable 70.31 0.00 1.60 3.30 14   44 44
  SQL 19.79 10.01 0.23 0.57 5 5 85 81
  PL/SQL 6.30 2.45 0.07 0.05 0 0 90 90
E Other 175.53   1.93 2.33 22 35 91 91
  Freeable 70.75 0.00 1.61 3.29 14   44 44
  SQL 20.01 10.15 0.23 0.58 5 5 86 83
  PL/SQL 6.45 2.45 0.07 0.05 0 0 91 91

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,589,934,592  
Fixed Size 2,091,120  
Redo Buffers 14,684,160  
Variable Size 2,365,589,392  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 147.44 147.44 0.00
java joxlod exec hp 11.89 11.89 0.00
shared CCursor 23.02 24.29 5.49
shared KGLS heap 32.19 32.27 0.24
shared KTI-UNDO 32.56 32.56 0.00
shared PL/SQL MPCODE 41.95 42.06 0.25
shared db_block_hash_buckets 45.00 45.00 0.00
shared event statistics per sess 35.16 35.16 0.00
shared free memory 1,367.33 1,355.82 -0.84
shared ktcmvcb 23.55 46.92 99.28
shared library cache 32.85 33.36 1.53
shared private strands 55.43 55.43 0.00
shared sql area 177.71 185.40 4.32
streams free memory 47.99 47.99 0.00
  buffer_cache 8,192.00 8,192.00 0.00
  fixed_sga 1.99 1.99 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 13,002,821 23,519 0
QMON Coordinator 189,080 0 0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue Schema and Name Incoming per second Outgoing per second Spilled per second Diff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber Name Incoming per second Outgoing per second Spilled per second
WFBESCL_20628 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
APPLSYS.WF_DEFERRED_QUEUE_M_R 104,821 0 104,980 477 1,502
SYS.ALERT_QUE_R 1 0 0 0 0
APPLSYS.FND_CP_GSM_OPP_AQ_R 1 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_gby_hash_aggregation_enabled FALSE   
_index_join_enabled FALSE   
_kks_use_mutex_pin TRUE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
aq_tm_processes 1   
background_dump_dest /r12/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db/bdump   
compatible 10.2.0   
control_files /r12/oracle/VIS/db/apps_st/data/cntrl01.dbf, /r12/oracle/VIS/db/apps_st/data/cntrl02.dbf, /r12/oracle/VIS/db/apps_st/data/cntrl03.dbf   
core_dump_dest /r12/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_cache_size 8589934592   
db_file_multiblock_read_count 8   
db_files 512   
db_name VIS   
dml_locks 10000   
java_pool_size 167772160   
job_queue_processes 10   
lock_sga TRUE   
log_buffer 14238720   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 600   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
parallel_min_servers 0   
pga_aggregate_target 2147483648   
plsql_code_type INTERPRETED   
plsql_native_library_dir /r12/oracle/VIS/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 2000   
query_rewrite_enabled true   
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 500   
session_max_open_files 20   
sessions 4000   
shared_pool_reserved_size 41943040   
shared_pool_size 2147483648   
streams_pool_size 50331648   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 94400   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /r12/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db/udump   
utl_file_dir /usr/tmp, /r12/oracle/VIS/db/tech_st/10.2.0/appsutil/outbound/VIS_db   
workarea_size_policy AUTO   


Back to Top

End of Report