WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 1412883651 VIS 1 10.2.0.3.0 NO r12db.sanmateo.ibm.com

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 696 27-Sep-09 21:26:42 87 31.2
End Snap: 697 27-Sep-09 21:56:33 91 29.2
Elapsed:   29.85 (mins)    
DB Time:   172.98 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 8,160M 8,112M Std Block Size: 8K
Shared Pool Size: 2,000M 2,000M Log Buffer: 30,724K

Load Profile

  Per Second Per Transaction
Redo size: 11,454,877.07 32,277.59
Logical reads: 835,778.96 2,355.06
Block changes: 70,313.95 198.13
Physical reads: 268.76 0.76
Physical writes: 859.66 2.42
User calls: 90.00 0.25
Parses: 1,118.01 3.15
Hard parses: 1.88 0.01
Sorts: 2,181.52 6.15
Logons: 0.41 0.00
Executes: 25,438.08 71.68
Transactions: 354.89  

% Blocks changed per Read: 8.41 Recursive Call %: 99.81
Rollback per transaction %: 0.09 Rows per Sort: 15.36

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.90 Redo NoWait %: 100.00
Buffer Hit %: 99.99 In-memory Sort %: 100.00
Library Hit %: 100.05 Soft Parse %: 99.83
Execute to Parse %: 95.60 Latch Hit %: 97.46
Parse CPU to Parse Elapsd %: 39.10 % Non-Parse CPU: 99.76

Shared Pool Statistics

  Begin End
Memory Usage %: 47.33 55.20
% SQL with executions>1: 75.41 90.22
% Memory for SQL w/exec>1: 76.06 93.19

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   9,459   91.1  
log file parallel write 293,442 554 2 5.3 System I/O
log file sync 180,126 462 3 4.5 Commit
db file sequential read 113,135 142 1 1.4 User I/O
buffer busy waits 1,409,983 82 0 .8 Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 10,362.00 99.84
DB CPU 9,458.80 91.14
PL/SQL execution elapsed time 2,201.17 21.21
Java execution elapsed time 496.71 4.79
parse time elapsed 77.43 0.75
hard parse elapsed time 23.27 0.22
sequence load elapsed time 6.86 0.07
repeated bind elapsed time 3.95 0.04
PL/SQL compilation elapsed time 3.28 0.03
connection management call elapsed time 0.99 0.01
hard parse (sharing criteria) elapsed time 0.46 0.00
hard parse (bind mismatch) elapsed time 0.12 0.00
inbound PL/SQL rpc elapsed time 0.02 0.00
failed parse elapsed time 0.01 0.00
DB time 10,378.76  
background elapsed time 1,002.22  
background cpu time 148.92  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
System I/O 298,119 0.00 563 2 0.47
Commit 180,126 0.00 462 3 0.28
User I/O 223,405 0.00 220 1 0.35
Concurrency 1,867,073 0.10 188 0 2.94
Application 5,468 0.00 62 11 0.01
Configuration 21,159 21.53 55 3 0.03
Other 131,655 36.10 34 0 0.21
Network 150,047 0.00 0 0 0.24

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 293,442 0.00 554 2 0.46
log file sync 180,126 0.00 462 3 0.28
db file sequential read 113,135 0.00 142 1 0.18
buffer busy waits 1,409,983 0.00 82 0 2.22
enq: TX - row lock contention 4,625 0.00 61 13 0.01
read by other session 30,856 0.00 55 2 0.05
library cache load lock 2,301 0.00 51 22 0.00
log file switch (checkpoint incomplete) 113 28.32 43 385 0.00
enq: TX - index contention 25,378 0.00 25 1 0.04
db file scattered read 6,949 0.00 22 3 0.01
cursor: pin S wait on X 2,071 91.45 20 10 0.00
kksfbc child completion 254 78.74 10 39 0.00
control file parallel write 1,628 0.00 8 5 0.00
buffer deadlock 47,372 99.28 8 0 0.07
log file switch completion 458 0.00 7 16 0.00
latch: cache buffers chains 415,551 0.00 5 0 0.65
enq: TX - contention 12,263 0.00 4 0 0.02
enq: HW - contention 9,138 0.00 4 0 0.01
enq: US - contention 25,565 0.00 3 0 0.04
PX Deq Credit: send blkd 6,285 0.00 2 0 0.01
latch: library cache 1,510 0.00 2 1 0.00
latch free 2,183 0.00 1 1 0.00
rdbms ipc reply 12,109 0.00 1 0 0.02
SGA: allocation forcing component growth 94 95.74 1 11 0.00
latch: In memory undo latch 6,580 0.00 1 0 0.01
PX Deq: Signal ACK 98 17.35 1 8 0.00
latch: enqueue hash chains 760 0.00 1 1 0.00
enq: RO - fast object reuse 24 0.00 1 32 0.00
enq: SQ - contention 6,787 0.00 1 0 0.01
latch: row cache objects 1,289 0.00 1 0 0.00
LGWR wait for redo copy 16,226 0.04 1 0 0.03
enq: KO - fast object checkpoint 11 0.00 1 52 0.00
latch: library cache pin 213 0.00 0 2 0.00
wait list latch free 39 0.00 0 11 0.00
enq: FB - contention 3,009 0.00 0 0 0.00
os thread startup 28 0.00 0 14 0.00
latch: shared pool 357 0.00 0 1 0.00
latch: session allocation 108 0.00 0 2 0.00
row cache lock 1,217 0.00 0 0 0.00
latch: undo global data 1,114 0.00 0 0 0.00
latch: library cache lock 50 0.00 0 3 0.00
local write wait 44 0.00 0 3 0.00
latch: cache buffers lru chain 110 0.00 0 1 0.00
SQL*Net more data to client 9,174 0.00 0 0 0.01
SQL*Net message to client 133,778 0.00 0 0 0.21
SQL*Net more data from client 7,095 0.00 0 0 0.01
direct path read 69,917 0.00 0 0 0.11
latch: redo allocation 156 0.00 0 0 0.00
SQL*Net break/reset to client 808 0.00 0 0 0.00
cursor: pin S 3,466 0.00 0 0 0.01
latch: checkpoint queue latch 23 0.00 0 1 0.00
control file sequential read 2,969 0.00 0 0 0.00
log file single write 40 0.00 0 1 0.00
cursor: mutex S 297 0.00 0 0 0.00
log buffer space 17 0.00 0 1 0.00
enq: TX - allocate ITL entry 82 0.00 0 0 0.00
latch: object queue header operation 73 0.00 0 0 0.00
undo segment extension 4,553 99.34 0 0 0.01
PX qref latch 228 77.63 0 0 0.00
latch: cache buffer handles 34 0.00 0 0 0.00
log file sequential read 40 0.00 0 0 0.00
reliable message 38 0.00 0 0 0.00
enq: CU - contention 2 0.00 0 1 0.00
enq: PS - contention 26 0.00 0 0 0.00
direct path write 2,476 0.00 0 0 0.00
cursor: mutex X 237 0.00 0 0 0.00
latch: redo writing 11 0.00 0 0 0.00
latch: messages 15 0.00 0 0 0.00
kkdlgon 1 0.00 0 1 0.00
library cache pin 10 0.00 0 0 0.00
library cache lock 1 0.00 0 0 0.00
direct path write temp 21 0.00 0 0 0.00
direct path read temp 7 0.00 0 0 0.00
L1 validation 4 0.00 0 0 0.00
SQL*Net message from client 133,773 0.00 70,633 528 0.21
PX Idle Wait 5,220 94.52 9,622 1843 0.01
Streams AQ: waiting for messages in the queue 998 93.19 6,976 6990 0.00
pipe get 1,263 98.57 5,251 4157 0.00
Streams AQ: qmn slave idle wait 853 0.00 3,483 4084 0.00
PL/SQL lock timer 330 96.36 2,027 6142 0.00
Streams AQ: waiting for time management or cleanup tasks 56 37.50 1,882 33612 0.00
Streams AQ: qmn coordinator idle wait 809 35.11 1,748 2161 0.00
PX Deq: Execution Msg 4,714 0.59 107 23 0.01
PX Deq: Execute Reply 2,546 0.00 13 5 0.00
PX Deq: Table Q Normal 6,899 0.00 1 0 0.01
PX Deq Credit: need buffer 2,142 0.00 0 0 0.00
PX Deq: Msg Fragment 1,807 0.00 0 0 0.00
PX Deq: Parse Reply 142 0.00 0 0 0.00
PX Deq: Join ACK 273 0.00 0 0 0.00
PX Deq: Table Q Sample 70 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 293,442 0.00 554 2 0.46
control file parallel write 1,628 0.00 8 5 0.00
events in waitclass Other 22,662 0.03 1 0 0.04
db file sequential read 444 0.00 1 2 0.00
log file single write 40 0.00 0 1 0.00
log buffer space 17 0.00 0 1 0.00
control file sequential read 1,282 0.00 0 0 0.00
direct path read 11,726 0.00 0 0 0.02
log file sequential read 40 0.00 0 0 0.00
buffer busy waits 228 0.00 0 0 0.00
latch: cache buffers chains 38 0.00 0 0 0.00
direct path write 2,442 0.00 0 0 0.00
latch: redo writing 11 0.00 0 0 0.00
undo segment extension 379 98.42 0 0 0.00
enq: TX - index contention 3 0.00 0 0 0.00
enq: HW - contention 6 0.00 0 0 0.00
latch: library cache 3 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 659,196 0.84 16,197 25 1.04
Streams AQ: qmn slave idle wait 853 0.00 3,483 4084 0.00
Streams AQ: waiting for time management or cleanup tasks 56 37.50 1,882 33612 0.00
smon timer 3,515 0.00 1,760 501 0.01
Streams AQ: qmn coordinator idle wait 809 35.11 1,748 2161 0.00
pmon timer 647 98.30 1,748 2702 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 979,662
IDLE_TIME 1,885,431
IOWAIT_TIME 94,301
NICE_TIME 1
SYS_TIME 81,375
USER_TIME 889,466
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 3,291,548
NUM_CPUS 16
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 10,377.60 9,457.90 469,023 1,493,992,314
SYS$USERS 1.10 0.90 108 10,644
SYS$BACKGROUND 0.00 0.00 12,170 2,765,280

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
VIS 207652 21860 1866628 18786 0 0 148823 21
SYS$USERS 400 21 104 8 0 0 5 0
SYS$BACKGROUND 14612 97 273 1 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,466 2,947 10 346.63 33.40 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
3,206 3,146 20 160.30 30.89 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
1,371 1,308 49,929 0.03 13.21 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
1,124 1,069 100 11.24 10.83 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,062 1,011 12 88.50 10.23 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
617 573 49,979 0.01 5.94 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
484 439 12 40.30 4.66 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
398 378 149,575 0.00 3.84 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
339 335 49,966 0.01 3.27 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
244 241 49,843 0.00 2.35 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
220 215 204,745 0.00 2.12 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
217 212 2,815,682 0.00 2.09 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
202 202 354,906 0.00 1.94 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
202 191 1,689,629 0.00 1.94 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
169 160 49,916 0.00 1.63 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
136 121 1,344,552 0.00 1.31 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
129 124 99,529 0.00 1.24 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
126 123 3 41.84 1.21 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
113 113 495,933 0.00 1.09 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
111 86 4 27.80 1.07 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
109 97 4 27.18 1.05 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,146 3,206 20 157.32 30.89 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,947 3,466 10 294.72 33.40 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,308 1,371 49,929 0.03 13.21 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
1,069 1,124 100 10.69 10.83 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,011 1,062 12 84.24 10.23 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
573 617 49,979 0.01 5.94 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
439 484 12 36.55 4.66 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
378 398 149,575 0.00 3.84 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
335 339 49,966 0.01 3.27 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
241 244 49,843 0.00 2.35 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
215 220 204,745 0.00 2.12 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
212 217 2,815,682 0.00 2.09 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
202 202 354,906 0.00 1.94 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
191 202 1,689,629 0.00 1.94 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
160 169 49,916 0.00 1.63 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
124 129 99,529 0.00 1.24 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
123 126 3 40.89 1.21 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
121 136 1,344,552 0.00 1.31 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
113 113 495,933 0.00 1.09 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
97 109 4 24.20 1.05 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
86 111 4 21.59 1.07 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
614,740,072 20 30,737,003.60 41.07 3146.40 3205.91 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
285,220,792 10 28,522,079.20 19.06 2947.16 3466.29 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
277,770,421 12 23,147,535.08 18.56 1010.86 1061.99 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
121,851,214 49,929 2,440.49 8.14 1308.47 1370.70 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
105,813,195 354,906 298.14 7.07 201.56 201.76 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
89,985,520 100 899,855.20 6.01 1068.93 1124.22 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
84,476,001 149,575 564.77 5.64 378.48 398.27 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
73,812,995 2,815,682 26.21 4.93 212.49 216.72 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
70,083,265 495,933 141.32 4.68 112.80 112.97 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
67,126,732 49,966 1,343.45 4.48 334.63 339.04 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
60,170,660 12 5,014,221.67 4.02 438.58 483.62 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
54,840,608 1,689,629 32.46 3.66 191.05 201.62 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
25,896,528 49,979 518.15 1.73 573.01 617.00 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
25,152,959 99,854 251.90 1.68 55.50 55.50 0wfry4rz1ygfk WSHPSGL_SUB SELECT /*+index (WDD WSH_DELIV...
25,139,420 309,850 81.13 1.68 71.70 73.04 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
24,643,730 1,344,552 18.33 1.65 121.26 135.68 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
23,882,495 54,895 435.06 1.60 79.07 79.56 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
22,077,837 149,502 147.68 1.48 53.45 53.88 6z9c18cxpxfq0 WSHPSGL_SUB SELECT NVL(COMMS_NL_TRACKABLE_...
20,428,586 4 5,107,146.50 1.36 96.79 108.71 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
19,643,682 29,989 655.03 1.31 69.66 69.78 6uwctg1cdb25v WSHPSGL_SUB SELECT DG.DELIVERY_LEG_ID LEG_...
18,865,361 99,529 189.55 1.26 124.49 128.94 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
18,178,942 50,000 363.58 1.21 42.55 42.60 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
17,772,947 3 5,924,315.67 1.19 122.68 125.51 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
36,091 10 3,609.10 7.50 2947.16 3466.29 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
33,415 49,929 0.67 6.94 1308.47 1370.70 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
26,746 20 1,337.30 5.56 3146.40 3205.91 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
14,847 12 1,237.25 3.08 438.58 483.62 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
13,941 4 3,485.25 2.90 86.35 111.20 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
9,589 12 799.08 1.99 1010.86 1061.99 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
8,085 3 2,695.00 1.68 122.68 125.51 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
4,986 99,529 0.05 1.04 124.49 128.94 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
3,758 1,689,629 0.00 0.78 191.05 201.62 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
3,330 100 33.30 0.69 1068.93 1124.22 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
2,815,682 1,527,614 0.54 0.00 0.00 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
1,689,629 1,689,539 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
1,344,552 1,344,490 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
495,933 49,991 0.10 0.00 0.00 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
354,906 0 0.00 0.00 0.00 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
309,850 309,718 1.00 0.00 0.00 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
204,745 204,723 1.00 0.00 0.00 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
199,920 199,896 1.00 0.00 0.00 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,766 199,747 1.00 0.00 0.00 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,980 149,971 1.00 0.00 0.00 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
199,856 199,920 9.98 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,757 199,766 9.98 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,462 149,980 7.46 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
99,850 99,463 4.99 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
99,243 99,855 4.96 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
59,922 59,986 2.99 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
59,916 59,976 2.99 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
59,906 59,998 2.99 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
59,892 59,991 2.99 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
54,711 54,895 2.73 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
49,988 49,995 2.50 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN...
49,975 49,979 2.50 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
49,970 49,993 2.50 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO...
49,961 49,929 2.50 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
49,949 49,990 2.49 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI...
49,928 49,992 2.49 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
49,928 50,000 2.49 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
49,862 49,843 2.49 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
49,718 49,622 2.48 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
49,570 49,833 2.48 bsuw7pmwrufpy INCTCW SELECT reservation_...
48,892 49,986 2.44 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
48,871 49,697 2.44 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
44,943 44,931 2.24 2skwhauh2cwky   select o.name, u.name from ob...
44,793 44,885 2.24 7gtztzv329wg0   select c.name, u.name from co...
39,835 39,838 1.99 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
30,740 30,742 1.54 bsa0wjtftg3uw   select file# from file$ where ...
20,746 20,747 1.04 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,054,630 5,001 0.05 gnr7tdv74ua5d ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0074pdmwb7fmv BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0r0gvtarcjwzz insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
0wfry4rz1ygfk SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/ OH.ORDER_TYPE_ID FROM OE_ORDER_HEADERS_ALL OH, WSH_DELIVERY_DETAILS WDD WHERE OH.HEADER_ID = WDD.SOURCE_HEADER_ID AND WDD.RELEASED_STATUS = 'S' AND WDD.SOURCE_CODE = 'OE' AND WDD.MOVE_ORDER_LINE_ID = :B1
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1v818hwxjxy58 select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54q BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfk BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52zwqr7xyrc2m SELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT
5t39uchjqpyfm BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6h228dtb8hp1t SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT .ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
6uwctg1cdb25v SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1
6z9c18cxpxfq0 SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1
72yyswsqkzkrm BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7mrs575bj7a41 begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4 BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8zfgv4ck11dw9 BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23 select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
assndb4wqnd6r BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09 SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uw select file# from file$ where ts#=:1
bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
cdjud36xbtuu5 SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE'
cw171rvngr1w9 begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fvcbstf9s6a5r begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
g2qs4xk48vcwy select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggr begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ghmx8n7wgqvfr begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gnng1rmpjxzsx begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;
gnr7tdv74ua5d INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID, ORG_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER. EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, HEADER.ORG_ID FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND ASS.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 952,735 532.00 1.50
CPU used when call started 956,460 534.08 1.50
CR blocks created 14,225,369 7,943.29 22.38
Cached Commit SCN referenced 2,489,114 1,389.89 3.92
Commit SCN cached 422 0.24 0.00
DB time 2,538,327 1,417.37 3.99
DBWR checkpoint buffers written 1,531,443 855.14 2.41
DBWR checkpoints 55 0.03 0.00
DBWR object drop buffers written 1,918 1.07 0.00
DBWR parallel query checkpoint buffers written 1,596 0.89 0.00
DBWR revisited being-written buffer 39 0.02 0.00
DBWR thread checkpoint buffers written 1,290,782 720.76 2.03
DBWR transaction table writes 228 0.13 0.00
DBWR undo block writes 1,003,495 560.34 1.58
DFO trees parallelized 23 0.01 0.00
DML statements parallelized 0 0.00 0.00
IMU CR rollbacks 5,138,137 2,869.08 8.08
IMU Flushes 369,444 206.29 0.58
IMU Redo allocation size 1,262,344,064 704,879.13 1,986.21
IMU commits 298,964 166.94 0.47
IMU contention 104,781 58.51 0.16
IMU ktichg flush 342 0.19 0.00
IMU pool not allocated 18,180 10.15 0.03
IMU recursive-transaction flush 263 0.15 0.00
IMU undo allocation size 2,011,669,016 1,123,293.99 3,165.22
IMU- failed to get a private strand 18,180 10.15 0.03
PX local messages recv'd 32,551 18.18 0.05
PX local messages sent 32,551 18.18 0.05
Parallel operations downgraded 25 to 50 pct 22 0.01 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations not downgraded 1 0.00 0.00
SMON posted for undo segment shrink 148 0.08 0.00
SQL*Net roundtrips to/from client 132,559 74.02 0.21
active txn count during cleanout 64,939,110 36,261.29 102.18
application wait time 6,231 3.48 0.01
auto extends on undo tablespace 73 0.04 0.00
background checkpoints completed 19 0.01 0.00
background checkpoints started 20 0.01 0.00
background timeouts 6,304 3.52 0.01
branch node splits 545 0.30 0.00
buffer is not pinned count 312,132,557 174,291.41 491.12
buffer is pinned count 423,092,260 236,250.09 665.71
bytes received via SQL*Net from client 48,187,651 26,907.46 75.82
bytes sent via SQL*Net to client 47,623,730 26,592.57 74.93
calls to get snapshot scn: kcmgss 55,560,123 31,024.17 87.42
calls to kcmgas 17,064,553 9,528.66 26.85
calls to kcmgcs 3,132,827 1,749.34 4.93
change write time 26,934 15.04 0.04
cleanout - number of ktugct calls 18,196,047 10,160.47 28.63
cleanouts and rollbacks - consistent read gets 13,155,209 7,345.72 20.70
cleanouts only - consistent read gets 61,336 34.25 0.10
cluster key scan block gets 196,105 109.50 0.31
cluster key scans 92,705 51.77 0.15
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 49,642 27.72 0.08
commit batch/immediate requested 49,642 27.72 0.08
commit cleanout failures: block lost 178,692 99.78 0.28
commit cleanout failures: buffer being written 489 0.27 0.00
commit cleanout failures: callback failure 86,910 48.53 0.14
commit cleanout failures: cannot pin 60,565 33.82 0.10
commit cleanouts 7,411,719 4,138.62 11.66
commit cleanouts successfully completed 7,085,063 3,956.22 11.15
commit immediate performed 49,642 27.72 0.08
commit immediate requested 49,642 27.72 0.08
commit txn count during cleanout 876,097 489.20 1.38
concurrency wait time 18,787 10.49 0.03
consistent changes 764,974,127 427,153.19 1,203.63
consistent gets 1,353,300,307 755,668.10 2,129.32
consistent gets - examination 1,011,502,587 564,811.99 1,591.53
consistent gets direct 307,281 171.58 0.48
consistent gets from cache 1,352,993,026 755,496.52 2,128.84
cursor authentications 2,311 1.29 0.00
data blocks consistent reads - undo records applied 759,563,413 424,131.91 1,195.12
db block changes 125,922,867 70,313.95 198.13
db block gets 143,467,814 80,110.86 225.74
db block gets direct 375 0.21 0.00
db block gets from cache 143,467,439 80,110.65 225.74
deferred (CURRENT) block cleanout applications 1,322,335 738.38 2.08
dirty buffers inspected 137 0.08 0.00
doubling up with imu segment 25 0.01 0.00
drop segment calls in space pressure 461 0.26 0.00
enqueue conversions 932,450 520.67 1.47
enqueue releases 6,650,730 3,713.69 10.46
enqueue requests 6,943,472 3,877.16 10.93
enqueue timeouts 292,742 163.46 0.46
enqueue waits 68,844 38.44 0.11
exchange deadlocks 47,391 26.46 0.07
execute count 45,556,192 25,438.08 71.68
failed probes on index block reclamation 619,266 345.79 0.97
free buffer inspected 3,265,115 1,823.20 5.14
free buffer requested 17,026,346 9,507.33 26.79
global undo segment hints helped 20 0.01 0.00
global undo segment hints were stale 8 0.00 0.00
heap block compress 26,770,991 14,948.63 42.12
hot buffers moved to head of LRU 445,817 248.94 0.70
immediate (CR) block cleanout applications 13,216,551 7,379.98 20.80
immediate (CURRENT) block cleanout applications 761,383 425.15 1.20
index crx upgrade (found) 76,351 42.63 0.12
index crx upgrade (positioned) 2,833,813 1,582.37 4.46
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 592 0.33 0.00
index fetch by key 98,626,976 55,072.23 155.18
index scans kdiixs1 30,637,368 17,107.57 48.21
java call heap collected bytes 1,134,160,648 633,302.91 1,784.52
java call heap collected count 14,265,378 7,965.63 22.45
java call heap gc count 2,509 1.40 0.00
java call heap live object count 543,339 303.39 0.85
java call heap live object count max 548,523 306.29 0.86
java call heap live size 206,042,712 115,052.00 324.19
java call heap live size max 206,926,144 115,545.30 325.58
java call heap object count 1,419,522 792.65 2.23
java call heap object count max 1,439,390 803.74 2.26
java call heap total size 288,358,400 161,016.18 453.71
java call heap total size max 288,358,400 161,016.18 453.71
java call heap used size 265,688,200 148,357.39 418.04
java call heap used size max 267,877,280 149,579.75 421.49
leaf node 90-10 splits 8,898 4.97 0.01
leaf node splits 129,863 72.51 0.20
lob reads 3,052,751 1,704.62 4.80
lob writes 1,310,110 731.55 2.06
lob writes unaligned 1,310,110 731.55 2.06
local undo segment hints helped 149 0.08 0.00
local undo segment hints were stale 139 0.08 0.00
logons cumulative 729 0.41 0.00
messages received 854,747 477.28 1.34
messages sent 854,747 477.28 1.34
no buffer to keep pinned count 8 0.00 0.00
no work - consistent read gets 310,931,948 173,621.00 489.23
opened cursors cumulative 825,906 461.18 1.30
parse count (failures) 3 0.00 0.00
parse count (hard) 3,360 1.88 0.01
parse count (total) 2,002,204 1,118.01 3.15
parse time cpu 2,226 1.24 0.00
parse time elapsed 5,693 3.18 0.01
physical read IO requests 189,770 105.97 0.30
physical read bytes 3,942,989,824 2,201,722.42 6,204.02
physical read total IO requests 193,037 107.79 0.30
physical read total bytes 3,993,767,936 2,230,076.36 6,283.92
physical read total multi block requests 46,007 25.69 0.07
physical reads 481,322 268.76 0.76
physical reads cache 162,203 90.57 0.26
physical reads cache prefetch 42,389 23.67 0.07
physical reads direct 319,119 178.19 0.50
physical reads direct (lob) 48 0.03 0.00
physical reads direct temporary tablespace 105 0.06 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 224,857 125.56 0.35
physical write bytes 12,611,928,064 7,042,362.78 19,843.99
physical write total IO requests 758,487 423.53 1.19
physical write total bytes 33,990,313,984 18,979,819.81 53,481.39
physical write total multi block requests 665,876 371.82 1.05
physical writes 1,539,542 859.66 2.42
physical writes direct 3,012 1.68 0.00
physical writes direct (lob) 36 0.02 0.00
physical writes direct temporary tablespace 500 0.28 0.00
physical writes from cache 1,536,530 857.98 2.42
physical writes non checkpoint 1,397,753 780.49 2.20
pinned buffers inspected 4,321 2.41 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 8 0.00 0.00
process last non-idle time 1,844 1.03 0.00
queries parallelized 23 0.01 0.00
recursive aborts on index block reclamation 8 0.00 0.00
recursive calls 83,236,386 46,478.29 130.97
recursive cpu usage 781,494 436.38 1.23
redo blocks written 41,702,556 23,286.25 65.62
redo buffer allocation retries 182 0.10 0.00
redo entries 68,381,636 38,183.56 107.59
redo log space requests 589 0.33 0.00
redo log space wait time 5,192 2.90 0.01
redo ordering marks 813,302 454.14 1.28
redo size 20,514,149,876 11,454,877.07 32,277.59
redo subscn max counts 1,458,600 814.47 2.30
redo synch time 47,931 26.76 0.08
redo synch writes 130,416 72.82 0.21
redo wastage 135,532,748 75,680.01 213.25
redo write time 57,268 31.98 0.09
redo writer latching time 52 0.03 0.00
redo writes 293,442 163.85 0.46
rollback changes - undo records applied 102,636 57.31 0.16
rollbacks only - consistent read gets 1,143,199 638.35 1.80
rows fetched via callback 34,736,257 19,396.35 54.66
session connect time 0 0.00 0.00
session cursor cache hits 1,868,903 1,043.58 2.94
session logical reads 1,496,768,121 835,778.96 2,355.06
session pga memory 391,418,800 218,563.98 615.87
session pga memory max 4,569,666,480 2,551,651.82 7,190.05
session uga memory 34,626,856 19,335.26 54.48
session uga memory max 8,091,564,832 4,518,241.36 12,731.51
shared hash latch upgrades - no wait 23,628,601 13,193.95 37.18
shared hash latch upgrades - wait 169,206 94.48 0.27
sorts (disk) 0 0.00 0.00
sorts (memory) 3,906,806 2,181.52 6.15
sorts (rows) 60,002,648 33,504.82 94.41
space was found by tune down 450 0.25 0.00
space was not found by tune down 7 0.00 0.00
sql area evicted 147 0.08 0.00
sql area purged 66 0.04 0.00
steps of tune down ret. in space pressure 471 0.26 0.00
summed dirty queue length 3,993 2.23 0.01
switch current to new buffer 1,189,178 664.02 1.87
table fetch by rowid 304,852,794 170,226.47 479.66
table fetch continued row 17,030,705 9,509.76 26.80
table scan blocks gotten 8,449,556 4,718.14 13.29
table scan rows gotten 374,234,578 208,968.50 588.83
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 1,133 0.63 0.00
table scans (long tables) 1,658 0.93 0.00
table scans (rowid ranges) 1,658 0.93 0.00
table scans (short tables) 1,383,188 772.36 2.18
total number of times SMON posted 3,515 1.96 0.01
transaction rollbacks 49,642 27.72 0.08
transaction tables consistent read rollbacks 74 0.04 0.00
transaction tables consistent reads - undo records applied 43,442 24.26 0.07
tune down retentions in space pressure 457 0.26 0.00
undo change vector size 7,443,832,024 4,156,554.44 11,712.35
user I/O wait time 21,979 12.27 0.03
user calls 161,169 90.00 0.25
user commits 634,967 354.56 1.00
user rollbacks 587 0.33 0.00
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 1,575,480 879.73 2.48
write clones created in background 48 0.03 0.00
write clones created in foreground 2,397 1.34 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 11,824 34,384
opened cursors current 2,713 2,657
logons current 87 91

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 20 40.20

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_TS_TX_DATA 100,047 56 0.62 3.79 26,826 15 252,097 0.11
APPS_UNDOTS1 16 0 1.88 1.00 121,250 68 667,449 0.03
APPS_TS_TX_IDX 54,707 31 1.20 1.01 49,906 28 230,593 0.22
APPS_TS_INTERFACE 11,715 7 1.33 2.01 6,083 3 105,833 0.02
SYSTEM 15,340 9 2.59 1.00 955 1 7,760 0.09
APPS_TS_QUEUES 3,056 2 1.90 1.00 12,275 7 131,060 0.24
APPS_TS_SUMMARY 920 1 0.79 1.00 6,312 4 44,634 0.07
APPS_TS_SEED 1,316 1 2.34 1.06 61 0 1,032 2.37
SYSAUX 177 0 1.86 1.00 445 0 0 0.00
APPS_TS_MEDIA 236 0 0.04 1.00 70 0 0 0.00
APPS_TS_ARCHIVE 88 0 2.73 1.00 108 0 3 6.67
TEMP 54 0 0.37 7.65 93 0 0 0.00
CTXSYS 106 0 0.00 1.00 18 0 0 0.00
CWMLITE 99 0 0.00 1.00 18 0 0 0.00
DCM 92 0 0.11 1.00 18 0 0 0.00
GEOR_TBS 92 0 0.00 1.00 18 0 0 0.00
APPS_CALCLIP 40 0 0.00 1.00 40 0 0 0.00
APPS_TS_NOLOGGING 50 0 1.40 1.00 22 0 183 0.60
B2B_DT 54 0 0.00 1.00 9 0 0 0.00
B2B_IDX 54 0 0.00 1.00 9 0 0 0.00
B2B_LOB 53 0 0.00 1.00 9 0 0 0.00
B2B_RT 53 0 0.00 1.00 9 0 0 0.00
BAM 53 0 0.00 1.00 9 0 0 0.00
ODM_DATA 50 0 0.00 1.00 9 0 0 0.00
OLTS_ATTRSTORE 50 0 0.00 1.00 9 0 0 0.00
OLTS_BATTRSTORE 50 0 0.00 1.00 9 0 0 0.00
OLTS_CT_STORE 50 0 0.00 1.00 9 0 0 0.00
OLTS_DEFAULT 50 0 0.00 1.00 9 0 0 0.00
OLTS_SVRMGSTORE 50 0 0.00 1.00 9 0 0 0.00
APPS_TS_TOOLS 48 0 0.21 1.00 10 0 0 0.00
DISCO_PTM5_CACHE 46 0 0.00 1.00 9 0 0 0.00
DISCO_PTM5_META 46 0 0.00 1.00 9 0 0 0.00
DSGATEWAY_TAB 46 0 0.00 1.00 9 0 0 0.00
HTMLDB 46 0 0.00 1.00 9 0 0 0.00
IAS_META 46 0 0.00 1.00 9 0 0 0.00
MTR 46 0 0.00 1.00 9 0 0 0.00
NOETIX 46 0 0.00 1.00 9 0 0 0.00
NON_APPS_TS_DATA 46 0 0.00 1.00 9 0 0 0.00
OCATS 46 0 0.00 1.00 9 0 0 0.00
OPMOR 44 0 0.23 1.00 9 0 0 0.00
ORABPEL 44 0 0.00 1.00 9 0 0 0.00
OWAPUB 44 0 0.00 1.00 9 0 0 0.00
PORTAL 44 0 0.00 1.00 9 0 0 0.00
PORTAL_DOC 44 0 0.00 1.00 9 0 0 0.00
PORTAL_IDX 44 0 0.00 1.00 9 0 0 0.00
PORTAL_LOG 44 0 0.00 1.00 9 0 0 0.00
RE 44 0 0.00 1.00 9 0 0 0.00
SYNCSERVER 44 0 0.00 1.00 9 0 0 0.00
UDDISYS_TS 44 0 0.00 1.00 9 0 0 0.00
WCRSYS_TS 44 0 0.00 1.00 9 0 0 0.00
XDB 44 0 0.00 1.00 9 0 0 0.00
APPS_OMO 10 0 0.00 1.00 10 0 0 0.00
APPS_TS_DISCO 10 0 0.00 1.00 10 0 0 0.00
APPS_TS_DISCO_OLAP 10 0 0.00 1.00 10 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip1.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip2.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_CALCLIP /ds2/oracle/VIS/db/apps_st/data/apps_calclip3.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_OMO /ds2/oracle/VIS/db/apps_st/data/omo1.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_TS_ARCHIVE /ds2/oracle/VIS/db/apps_st/data/archive1.dbf 88 0 2.73 1.00 108 0 3 6.67
APPS_TS_DISCO /ds2/oracle/VIS/db/apps_st/data/disco1.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_TS_DISCO_OLAP /ds2/oracle/VIS/db/apps_st/data/disco_drake1.dbf 10 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface.db 554 0 1.62 2.15 313 0 5,298 0.03
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface1.d 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface10. 562 0 1.44 2.12 253 0 5,369 0.03
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface11. 553 0 0.98 2.10 274 0 5,408 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface12. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface13. 557 0 1.53 2.07 300 0 7,073 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface14. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface15. 559 0 1.29 2.02 280 0 6,141 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface16. 540 0 1.52 2.05 270 0 5,632 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface17. 537 0 1.25 2.07 245 0 5,574 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface18. 528 0 0.83 2.09 235 0 5,697 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface19. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface2.d 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface20. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface21. 504 0 1.37 2.16 260 0 4,661 0.04
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface22. 164 0 1.59 1.82 81 0 203 0.49
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface23. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface24. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface25. 20 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface26. 45 0 1.56 3.69 17 0 6 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface27. 135 0 3.56 2.36 171 0 705 0.14
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface28. 609 0 2.20 2.06 369 0 5,055 0.06
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface29. 613 0 1.37 2.01 374 0 4,435 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface3.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface30. 640 0 1.03 1.93 324 0 5,992 0.04
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface31. 601 0 1.45 1.95 306 0 7,001 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface32. 617 0 1.04 1.97 302 0 6,006 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface33. 627 0 1.23 1.95 345 0 5,525 0.02
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface34. 614 0 1.50 1.96 305 0 4,851 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface35. 600 0 1.17 2.02 298 0 5,272 0.02
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface36. 608 0 1.05 2.01 308 0 5,388 0.01
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface4.d 600 0 1.52 2.02 303 0 4,541 0.04
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface5.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface6.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface7.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface8.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_INTERFACE /ds2/oracle/VIS/db/apps_st/data/apps_ts_interface9.d 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media1.dbf 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media2.dbf 28 0 0.36 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media3.dbf 28 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media4.dbf 38 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media5.dbf 38 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media6.dbf 38 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA /ds2/oracle/VIS/db/apps_st/data/media7.dbf 38 0 0.00 1.00 10 0 0 0.00
APPS_TS_NOLOGGING /ds2/oracle/VIS/db/apps_st/data/nologging1.dbf 50 0 1.40 1.00 22 0 183 0.60
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues1.dbf 458 0 1.94 1.00 1,911 1 19,994 0.17
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues2.dbf 432 0 1.60 1.00 949 1 14,402 0.28
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues3.dbf 499 0 1.52 1.00 1,861 1 21,321 0.26
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues4.dbf 451 0 1.75 1.00 1,889 1 20,328 0.16
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues5.dbf 403 0 2.18 1.00 1,862 1 17,937 0.57
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues6.dbf 355 0 2.45 1.00 1,860 1 17,010 0.13
APPS_TS_QUEUES /ds2/oracle/VIS/db/apps_st/data/queues7.dbf 458 0 2.05 1.00 1,943 1 20,068 0.16
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference1.dbf 449 0 2.98 1.06 18 0 297 2.96
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference2.dbf 212 0 1.70 1.06 10 0 176 2.73
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference3.dbf 220 0 2.05 1.06 10 0 183 2.08
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference4.dbf 225 0 2.13 1.06 11 0 197 1.88
APPS_TS_SEED /ds2/oracle/VIS/db/apps_st/data/reference5.dbf 210 0 2.14 1.06 12 0 179 1.90
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary1.dbf 64 0 0.78 1.00 595 0 3,689 0.05
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary10.dbf 55 0 0.73 1.00 634 0 3,731 0.08
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary11.dbf 70 0 1.71 1.00 608 0 3,656 0.07
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary12.dbf 79 0 0.51 1.00 594 0 4,277 0.08
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary13.dbf 77 0 0.52 1.00 644 0 5,592 0.05
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary2.dbf 87 0 1.03 1.00 607 0 5,440 0.08
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary3.dbf 69 0 0.58 1.00 642 0 3,734 0.08
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary4.dbf 66 0 1.21 1.00 57 0 2,471 0.06
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary5.dbf 49 0 0.41 1.00 10 0 0 0.00
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary6.dbf 61 0 0.49 1.00 459 0 2,535 0.05
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary7.dbf 74 0 1.22 1.00 637 0 3,842 0.10
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary8.dbf 81 0 0.37 1.00 218 0 2,266 0.09
APPS_TS_SUMMARY /ds2/oracle/VIS/db/apps_st/data/summary9.dbf 88 0 0.68 1.00 607 0 3,401 0.04
APPS_TS_TOOLS /ds2/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf 48 0 0.21 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data1.dbf 49 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data10.dbf 183 0 0.77 3.34 29 0 1 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data11.dbf 2,175 1 0.67 3.82 613 0 9,351 0.19
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data12.dbf 2,174 1 0.45 3.82 591 0 6,895 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data13.dbf 2,197 1 0.63 3.80 588 0 6,002 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data14.dbf 48 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data15.dbf 211 0 1.04 3.10 58 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data16.dbf 216 0 0.51 3.05 61 0 7 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data17.dbf 212 0 1.27 3.09 42 0 6 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data18.dbf 192 0 1.20 3.23 44 0 8 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data19.dbf 1,126 1 0.21 4.31 67 0 88 0.68
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data2.dbf 2,163 1 0.40 3.83 651 0 5,754 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data20.dbf 58 0 0.17 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data21.dbf 2,171 1 0.54 3.79 620 0 6,382 0.11
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data22.dbf 1,296 1 0.66 4.29 89 0 170 1.41
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data23.dbf 58 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data24.dbf 218 0 0.64 3.03 80 0 1,001 0.01
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data25.dbf 58 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data26.dbf 58 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data27.dbf 226 0 0.84 2.96 68 0 7 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data28.dbf 223 0 2.47 1.69 56 0 2,083 0.18
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data29.dbf 167 0 2.51 1.37 56 0 541 0.33
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data3.dbf 58 0 0.00 1.00 10 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data30.dbf 77 0 0.39 1.00 18 0 26 1.54
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data31.dbf 80 0 1.50 1.04 26 0 283 0.21
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data32.dbf 1,383 1 1.13 4.11 120 0 1,315 0.27
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data33.dbf 219 0 1.60 3.00 83 0 70 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data34.dbf 216 0 1.44 3.05 74 0 19 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data35.dbf 216 0 0.93 3.00 73 0 4 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data36.dbf 224 0 0.80 2.98 72 0 26 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data37.dbf 251 0 0.96 2.78 85 0 21 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data38.dbf 252 0 0.60 2.74 76 0 11 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data39.dbf 1,340 1 0.81 4.23 102 0 179 1.23
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data4.dbf 100 0 0.10 2.43 9 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data40.dbf 232 0 0.65 2.88 45 0 20 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data41.dbf 256 0 0.27 3.23 58 0 113 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data42.dbf 249 0 0.84 3.30 52 0 23 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data43.dbf 2,320 1 0.66 3.78 666 0 6,637 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data44.dbf 2,345 1 0.48 3.75 635 0 7,136 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data45.dbf 2,326 1 0.78 3.77 610 0 5,704 0.13
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data46.dbf 2,327 1 0.51 3.75 632 0 5,336 0.09
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data47.dbf 2,332 1 0.41 3.73 648 0 6,020 0.25
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data48.dbf 2,321 1 0.73 3.77 631 0 6,644 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data49.dbf 2,316 1 0.86 3.78 599 0 6,627 0.09
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data5.dbf 59 0 0.00 1.00 9 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data50.dbf 2,265 1 0.46 3.81 571 0 7,070 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data51.dbf 2,297 1 0.71 3.77 643 0 5,799 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data52.dbf 1,036 1 0.61 4.70 58 0 18 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data53.dbf 2,281 1 0.68 3.80 661 0 5,923 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data54.dbf 2,323 1 0.56 3.74 682 0 6,578 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data55.dbf 2,281 1 0.63 3.78 662 0 6,177 0.37
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data56.dbf 2,265 1 0.53 3.80 650 0 5,921 0.10
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data57.dbf 2,307 1 0.67 3.76 621 0 6,072 0.24
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data58.dbf 2,247 1 0.74 3.77 719 0 6,553 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data59.dbf 2,207 1 0.58 3.80 675 0 6,317 0.09
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data6.dbf 59 0 0.17 1.00 9 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data60.dbf 2,189 1 0.56 3.83 702 0 6,813 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data61.dbf 2,206 1 0.55 3.82 749 0 6,353 0.10
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data62.dbf 2,211 1 0.49 3.82 668 0 5,799 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data63.dbf 2,172 1 0.70 3.84 643 0 5,062 0.15
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data64.dbf 2,136 1 0.64 3.90 627 0 5,629 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data65.dbf 2,166 1 0.45 3.87 633 0 5,323 0.26
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data66.dbf 2,145 1 0.60 3.91 591 0 5,796 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data67.dbf 2,151 1 0.44 3.86 578 0 5,595 0.09
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data68.dbf 2,178 1 0.56 3.84 615 0 5,920 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data69.dbf 2,187 1 0.50 3.84 598 0 5,863 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data7.dbf 224 0 0.98 2.92 64 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data70.dbf 2,151 1 0.43 3.89 567 0 5,129 0.12
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data71.dbf 2,128 1 0.74 3.91 571 0 6,057 0.07
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data72.dbf 2,172 1 0.55 3.84 595 0 5,596 0.12
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data73.dbf 2,150 1 0.80 3.88 620 0 6,011 0.08
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data74.dbf 2,130 1 0.60 3.91 589 0 6,270 0.11
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data75.dbf 2,111 1 0.71 3.91 560 0 5,887 0.06
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data76.dbf 2,164 1 0.69 3.84 607 0 5,739 0.10
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data77.dbf 2,211 1 0.63 3.78 582 0 6,583 0.13
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data78.dbf 2,203 1 0.68 3.80 592 0 5,734 0.13
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data8.dbf 58 0 0.00 1.00 9 0 0 0.00
APPS_TS_TX_DATA /ds2/oracle/VIS/db/apps_st/data/tx_data9.dbf 58 0 0.17 1.00 9 0 0 0.00
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx1.dbf 1,045 1 1.43 1.01 1,000 1 3,534 0.27
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx10.dbf 1,054 1 1.26 1.01 1,036 1 3,490 0.26
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx11.dbf 1,011 1 1.21 1.01 960 1 3,621 0.31
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx12.dbf 996 1 1.06 1.01 904 1 3,473 0.29
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx13.dbf 994 1 1.01 1.01 888 0 3,462 0.34
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx14.dbf 976 1 0.74 1.00 862 0 3,440 0.80
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx15.dbf 940 1 1.09 1.00 823 0 3,655 0.37
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx16.dbf 950 1 0.82 1.00 803 0 3,474 0.50
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx17.dbf 866 0 0.83 1.01 823 0 2,952 0.19
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx18.dbf 862 0 0.93 1.00 836 0 2,622 0.37
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx19.dbf 898 1 0.52 1.00 851 0 3,261 0.33
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx2.dbf 1,148 1 1.26 1.01 880 0 3,043 0.23
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx20.dbf 970 1 1.13 1.01 927 1 2,653 0.32
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx21.dbf 1,023 1 0.83 1.01 875 0 3,613 0.29
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx22.dbf 989 1 0.76 1.01 926 1 3,463 0.35
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx23.dbf 1,099 1 2.87 1.00 538 0 4,106 0.24
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx24.dbf 919 1 1.03 1.00 883 0 5,769 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx25.dbf 851 0 2.44 1.01 583 0 4,121 0.22
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx26.dbf 1,278 1 1.08 1.02 1,210 1 5,802 0.08
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx27.dbf 1,256 1 1.58 1.01 1,059 1 4,678 0.30
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx28.dbf 294 0 2.48 1.04 122 0 2,699 0.03
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx29.dbf 1,272 1 1.23 1.01 1,093 1 6,316 0.14
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx3.dbf 1,285 1 1.07 1.02 1,098 1 3,902 0.24
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx30.dbf 1,173 1 1.32 1.02 1,073 1 4,141 0.19
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx31.dbf 1,564 1 1.65 1.01 1,494 1 6,559 0.17
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx32.dbf 1,350 1 1.39 1.02 1,212 1 6,247 0.63
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx33.dbf 1,462 1 1.61 1.01 1,338 1 3,652 0.29
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx34.dbf 1,277 1 1.53 1.01 1,279 1 8,022 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx35.dbf 1,423 1 1.19 1.02 1,308 1 39,761 0.05
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx36.dbf 1,356 1 1.01 1.01 1,271 1 4,530 0.19
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx37.dbf 1,324 1 1.16 1.02 1,277 1 3,424 0.15
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx38.dbf 1,324 1 1.10 1.02 1,244 1 5,274 0.12
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx39.dbf 1,339 1 1.02 1.01 1,243 1 3,520 0.35
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx4.dbf 1,349 1 1.24 1.01 1,117 1 3,488 0.32
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx40.dbf 1,355 1 1.20 1.01 1,281 1 3,651 0.21
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx41.dbf 1,322 1 1.04 1.02 1,217 1 3,417 0.32
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx42.dbf 1,241 1 0.89 1.01 1,179 1 3,106 0.27
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx43.dbf 1,160 1 1.22 1.01 1,161 1 3,997 0.20
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx44.dbf 1,142 1 1.08 1.01 1,140 1 3,372 0.30
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx45.dbf 1,139 1 1.47 1.02 1,161 1 3,606 0.20
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx46.dbf 1,180 1 1.42 1.01 1,132 1 3,645 0.27
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx47.dbf 1,216 1 1.03 1.01 1,157 1 3,955 0.20
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx48.dbf 1,121 1 1.04 1.01 1,143 1 3,978 0.10
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx49.dbf 1,199 1 1.31 1.01 1,088 1 4,139 0.23
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx5.dbf 864 0 0.87 1.00 857 0 3,786 0.28
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx6.dbf 1,057 1 0.98 1.01 1,002 1 3,631 0.26
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx7.dbf 1,100 1 1.18 1.01 1,020 1 3,312 0.26
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx8.dbf 829 0 0.68 1.01 795 0 3,508 0.13
APPS_TS_TX_IDX /ds2/oracle/VIS/db/apps_st/data/tx_idx9.dbf 865 0 0.72 1.01 737 0 3,723 0.37
APPS_UNDOTS1 /ds2/oracle/VIS/db/apps_st/data/undo.dbf 16 0 1.88 1.00 121,250 68 667,449 0.03
B2B_DT /ds2/oracle/VIS/db/apps_st/data/b2b_dt.dbf 54 0 0.00 1.00 9 0 0 0.00
B2B_IDX /ds2/oracle/VIS/db/apps_st/data/b2b_idx.dbf 54 0 0.00 1.00 9 0 0 0.00
B2B_LOB /ds2/oracle/VIS/db/apps_st/data/b2b_lob.dbf 53 0 0.00 1.00 9 0 0 0.00
B2B_RT /ds2/oracle/VIS/db/apps_st/data/b2b_rt.dbf 53 0 0.00 1.00 9 0 0 0.00
BAM /ds2/oracle/VIS/db/apps_st/data/bam.dbf 53 0 0.00 1.00 9 0 0 0.00
CTXSYS /ds2/oracle/VIS/db/apps_st/data/ctx1.dbf 53 0 0.00 1.00 9 0 0 0.00
CTXSYS /ds2/oracle/VIS/db/apps_st/data/ctx2.dbf 53 0 0.00 1.00 9 0 0 0.00
CWMLITE /ds2/oracle/VIS/db/apps_st/data/cwmlite01.dbf 53 0 0.00 1.00 9 0 0 0.00
CWMLITE /ds2/oracle/VIS/db/apps_st/data/cwmlite02.dbf 46 0 0.00 1.00 9 0 0 0.00
DCM /ds2/oracle/VIS/db/apps_st/data/dcm.dbf 46 0 0.22 1.00 9 0 0 0.00
DCM /ds2/oracle/VIS/db/apps_st/data/dcm1.dbf 46 0 0.00 1.00 9 0 0 0.00
DISCO_PTM5_CACHE /ds2/oracle/VIS/db/apps_st/data/discopltc1.dbf 46 0 0.00 1.00 9 0 0 0.00
DISCO_PTM5_META /ds2/oracle/VIS/db/apps_st/data/discopltm1.dbf 46 0 0.00 1.00 9 0 0 0.00
DSGATEWAY_TAB /ds2/oracle/VIS/db/apps_st/data/oss_sys01.dbf 46 0 0.00 1.00 9 0 0 0.00
GEOR_TBS /ds2/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf 46 0 0.00 1.00 9 0 0 0.00
GEOR_TBS /ds2/oracle/VIS/db/apps_st/data/geor_tbs02.dbf 46 0 0.00 1.00 9 0 0 0.00
HTMLDB /ds2/oracle/VIS/db/apps_st/data/htmldb.dbf 46 0 0.00 1.00 9 0 0 0.00
IAS_META /ds2/oracle/VIS/db/apps_st/data/ias_meta01.dbf 46 0 0.00 1.00 9 0 0 0.00
MTR /ds2/oracle/VIS/db/apps_st/data/opmtr01.dbf 46 0 0.00 1.00 9 0 0 0.00
NOETIX /ds2/oracle/VIS/db/apps_st/data/noetix.dbf 46 0 0.00 1.00 9 0 0 0.00
NON_APPS_TS_DATA /ds2/oracle/VIS/db/apps_st/data/non_apps_data1.dbf 46 0 0.00 1.00 9 0 0 0.00
OCATS /ds2/oracle/VIS/db/apps_st/data/oca.dbf 46 0 0.00 1.00 9 0 0 0.00
ODM_DATA /ds2/oracle/VIS/db/apps_st/data/odm.dbf 50 0 0.00 1.00 9 0 0 0.00
OLTS_ATTRSTORE /ds2/oracle/VIS/db/apps_st/data/attrs1_oid.dbf 50 0 0.00 1.00 9 0 0 0.00
OLTS_BATTRSTORE /ds2/oracle/VIS/db/apps_st/data/battrs1_oid.dbf 50 0 0.00 1.00 9 0 0 0.00
OLTS_CT_STORE /ds2/oracle/VIS/db/apps_st/data/gcats1_oid.dbf 50 0 0.00 1.00 9 0 0 0.00
OLTS_DEFAULT /ds2/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf 50 0 0.00 1.00 9 0 0 0.00
OLTS_SVRMGSTORE /ds2/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf 50 0 0.00 1.00 9 0 0 0.00
OPMOR /ds2/oracle/VIS/db/apps_st/data/opmor01.dbf 44 0 0.23 1.00 9 0 0 0.00
ORABPEL /ds2/oracle/VIS/db/apps_st/data/orabpel.dbf 44 0 0.00 1.00 9 0 0 0.00
OWAPUB /ds2/oracle/VIS/db/apps_st/data/owa1.dbf 44 0 0.00 1.00 9 0 0 0.00
PORTAL /ds2/oracle/VIS/db/apps_st/data/portal.dbf 44 0 0.00 1.00 9 0 0 0.00
PORTAL_DOC /ds2/oracle/VIS/db/apps_st/data/ptldoc.dbf 44 0 0.00 1.00 9 0 0 0.00
PORTAL_IDX /ds2/oracle/VIS/db/apps_st/data/ptlidx.dbf 44 0 0.00 1.00 9 0 0 0.00
PORTAL_LOG /ds2/oracle/VIS/db/apps_st/data/ptllog.dbf 44 0 0.00 1.00 9 0 0 0.00
RE /ds2/oracle/VIS/db/apps_st/data/opre01.dbf 44 0 0.00 1.00 9 0 0 0.00
SYNCSERVER /ds2/oracle/VIS/db/apps_st/data/mobile01.dbf 44 0 0.00 1.00 9 0 0 0.00
SYSAUX /ds2/oracle/VIS/db/apps_st/data/sysaux01.dbf 177 0 1.86 1.00 445 0 0 0.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys1.dbf 1,421 1 2.39 1.00 199 0 274 0.07
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys10.dbf 1,583 1 2.78 1.00 135 0 100 0.10
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys2.dbf 1,226 1 2.85 1.00 28 0 124 0.48
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys3.dbf 1,465 1 2.59 1.00 130 0 282 0.18
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys4.dbf 1,686 1 2.50 1.01 83 0 724 0.04
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys5.dbf 1,782 1 2.64 1.00 51 0 1,257 0.05
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys6.dbf 1,372 1 2.68 1.00 56 0 15 2.00
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys7.dbf 1,686 1 2.24 1.00 53 0 818 0.07
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys8.dbf 1,492 1 2.51 1.00 45 0 3,622 0.05
SYSTEM /ds2/oracle/VIS/db/apps_st/data/sys9.dbf 1,627 1 2.78 1.00 175 0 544 0.39
TEMP /ds2/oracle/VIS/db/apps_st/data/temp_01.dbf 54 0 0.37 7.65 63 0 0  
TEMP /ds2/oracle/VIS/db/apps_st/data/temp_02.dbf 0 0     30 0 0  
UDDISYS_TS /ds2/oracle/VIS/db/apps_st/data/uddisys01.dbf 44 0 0.00 1.00 9 0 0 0.00
WCRSYS_TS /ds2/oracle/VIS/db/apps_st/data/wcrsys01.dbf 44 0 0.00 1.00 9 0 0 0.00
XDB /ds2/oracle/VIS/db/apps_st/data/xdb01.dbf 44 0 0.00 1.00 9 0 0 0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 1,003,350 100 1,494,047,521 162,200 1,536,530 0 0 1,440,824


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 29 8390 218731 218428 3774870 218428  
E 0 197 108427 2820796 3774870 3774870 10889671  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 800 0.10 98,950 1.04 22,798,262
D 1,600 0.20 197,900 1.02 22,491,424
D 2,400 0.30 296,850 1.01 22,306,063
D 3,200 0.39 395,800 1.01 22,200,127
D 4,000 0.49 494,750 1.01 22,168,012
D 4,800 0.59 593,700 1.01 22,128,272
D 5,600 0.69 692,650 1.00 22,109,594
D 6,400 0.79 791,600 1.00 22,091,110
D 7,200 0.89 890,550 1.00 22,067,540
D 8,000 0.99 989,500 1.00 22,024,998
D 8,112 1.00 1,003,353 1.00 22,014,697
D 8,800 1.08 1,088,450 1.00 21,950,703
D 9,600 1.18 1,187,400 0.99 21,901,373
D 10,400 1.28 1,286,350 0.99 21,883,601
D 11,200 1.38 1,385,300 0.99 21,859,180
D 12,000 1.48 1,484,250 0.99 21,808,735
D 12,800 1.58 1,583,200 0.99 21,761,788
D 13,600 1.68 1,682,150 0.99 21,721,226
D 14,400 1.78 1,781,100 0.99 21,683,800
D 15,200 1.87 1,880,050 0.98 21,662,836
D 16,000 1.97 1,979,000 0.98 21,629,717

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
99.98 88,329 15

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 6,144 5,404 280.95 0.00 0.00 0.00 0.00 629,140
E 6,144 5,374 306.65 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 1,480,679 1,480,679 0 0
64K 128K 1,476 1,476 0 0
128K 256K 120 120 0 0
256K 512K 766 766 0 0
512K 1024K 40,755 40,755 0 0
1M 2M 46,031 46,031 0 0
2M 4M 595 591 4 0
4M 8M 133 133 0 0
8M 16M 38 38 0 0
16M 32M 8 8 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
768 0.13 227,086.70 1,937.17 99.00 36
1,536 0.25 227,086.70 1,928.15 99.00 20
3,072 0.50 227,086.70 1,767.43 99.00 0
4,608 0.75 227,086.70 1,767.43 99.00 0
6,144 1.00 227,086.70 1,767.43 99.00 0
7,373 1.20 227,086.70 0.00 100.00 0
8,602 1.40 227,086.70 0.00 100.00 0
9,830 1.60 227,086.70 0.00 100.00 0
11,059 1.80 227,086.70 0.00 100.00 0
12,288 2.00 227,086.70 0.00 100.00 0
18,432 3.00 227,086.70 0.00 100.00 0
24,576 4.00 227,086.70 0.00 100.00 0
36,864 6.00 227,086.70 0.00 100.00 0
49,152 8.00 227,086.70 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
752 0.38 236 11,495 666,995 0.98 14,364 27.05 54,941,338
960 0.48 441 18,347 668,656 0.98 12,703 23.92 54,944,951
1,168 0.58 648 25,462 676,188 0.99 5,171 9.74 54,946,075
1,376 0.69 855 32,013 677,275 0.99 4,084 7.69 54,946,435
1,584 0.79 1,061 39,297 677,333 0.99 4,026 7.58 54,946,721
1,792 0.90 1,268 48,049 679,892 1.00 1,467 2.76 54,946,996
2,000 1.00 1,475 56,661 680,828 1.00 531 1.00 54,947,209
2,208 1.10 1,682 65,744 681,555 1.00 1 0.00 54,947,348
2,416 1.21 1,889 72,653 681,610 1.00 1 0.00 54,947,431
2,624 1.31 2,096 79,623 681,610 1.00 1 0.00 54,947,533
2,832 1.42 2,302 87,346 681,610 1.00 1 0.00 54,947,715
3,040 1.52 2,509 96,766 682,590 1.00 1 0.00 54,949,437
3,248 1.62 2,716 104,716 685,737 1.01 1 0.00 54,952,270
3,456 1.73 2,923 116,392 685,992 1.01 1 0.00 54,954,118
3,664 1.83 3,130 126,144 688,526 1.01 1 0.00 54,956,486
3,872 1.94 3,337 134,925 688,846 1.01 1 0.00 54,985,206
4,080 2.04 3,544 146,131 688,873 1.01 1 0.00 54,998,781

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
2,560 0.25 62,691 22,798,379
5,120 0.50 58,174 22,305,250
7,680 0.75 57,995 22,109,320
10,240 1.00 57,908 22,014,657
12,800 1.25 57,786 21,882,569
15,360 1.50 57,642 21,721,862
17,920 1.75 57,555 21,629,401
20,480 2.00 57,555 21,629,401

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 11 326 5 1.00 531 1.00 242
32 0.50 11 326 5 1.00 531 1.00 242
48 0.75 11 326 5 1.00 531 1.00 242
64 1.00 11 326 5 1.00 531 1.00 242
80 1.25 11 326 5 1.00 531 1.00 242
96 1.50 11 326 5 1.00 531 1.00 242
112 1.75 11 326 5 1.00 531 1.00 242
128 2.00 11 326 5 1.00 531 1.00 242

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 739,200 119 0
undo block 600,395 20 0
undo header 65,892 2 0
1st level bmb 22,200 1 0
segment header 11,146 1 0
file header block 1,175 0 0
2nd level bmb 594 0 0
3rd level bmb 40 0 1
extent map 35 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TX-Transaction (row lock contention) 295,046 3,092 291,953 3,090 62 20.07
TX-Transaction (index contention) 20,351 20,351 0 19,376 25 1.31
TX-Transaction 913,419 913,373 0 7,595 5 0.63
HW-Segment High Water Mark 1,950,779 1,948,074 14 7,399 4 0.53
US-Undo Segment 937,602 937,490 0 25,359 3 0.13
RO-Multiple Object Reuse (fast object reuse) 216 216 0 24 1 32.08
SQ-Sequence Cache 29,033 29,033 0 4,211 1 0.18
KO-Multiple Object Checkpoint (fast object checkpoint) 99 99 0 11 1 53.64
FB-Format Block 21,660 21,660 0 1,682 0 0.21
TX-Transaction (allocate ITL entry) 96 96 0 73 0 0.27
PS-PX Process Reservation 1,638 1,330 308 21 0 0.00
CU-Cursor 3,178 3,178 0 2 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,083.70 909,668 1,826 24 13.05/2338.83333333333333333333333333333333333 0/0 11/8/8/1503/516305/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
27-Sep 21:54 189,705 63,823 1,826 14 20 0/0 0/0/0/0/0/0
27-Sep 21:44 394,050 339,944 1,226 24 13 0/0 11/8/8/1156/188736/0
27-Sep 21:34 499,943 505,901 626 19 2,339 0/0 0/0/0/347/327569/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 13,002 0.00   0 0  
AWR Alerted Metric Element list 12,993 0.00   0 0  
Consistent RBA 293,965 0.07 0.00 0 0  
FOB s.o list latch 25,701 0.62 0.00 0 0  
In memory undo latch 736,154,176 1.52 0.00 1 691,322 0.03
JOX SGA heap latch 1,728,881 0.00 1.00 0 4,557 0.00
JS queue state obj latch 10,740 0.00   0 0  
KMG MMAN ready and startup request latch 824 0.00   0 0  
KMG resize request state object freelist 10 0.00   0 0  
KTF sga latch 6 0.00   0 567 0.00
KWQMN job cache list latch 205,950 0.49 0.03 0 0  
KWQP Prop Status 222 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 306 0.33 0.00 0 820 0.00
OS process 1,503 0.00   0 0  
OS process allocation 1,589 0.06 0.00 0 0  
OS process: request allocation 880 0.23 0.00 0 0  
PL/SQL warning settings 1,282,688 0.00   0 0  
Policy Hash Table Latch 11 0.00   0 0  
SGA IO buffer pool latch 5,341 0.02 0.00 0 13,179 0.19
SQL memory manager latch 1 0.00   0 593 0.00
SQL memory manager workarea list latch 1,339,000 0.02 0.00 0 0  
Shared B-Tree 1,139 0.00   0 0  
Undo Hint Latch 0     0 1,570 0.00
active checkpoint queue latch 550,661 7.70 0.00 0 0  
active service list 7,596 5.85 0.01 0 644 0.00
begin backup scn array 41 0.00   0 0  
bq:time manger info latch 63 0.00   0 0  
buffer pool 7 0.00   0 0  
bufq statistics 10 0.00   0 0  
cache buffer handles 6,109,150 1.30 0.00 0 0  
cache buffers chains 3,800,408,110 3.02 0.00 5 14,381,101 4.35
cache buffers lru chain 5,544,259 0.49 0.00 0 30,960,202 0.53
cache table scan latch 0     0 6,917 0.46
channel handle pool latch 10,226 0.07 0.00 0 0  
channel operations parent latch 96,660 0.61 0.00 0 0  
checkpoint queue latch 12,483,723 0.02 0.01 0 1,639,396 0.02
client/application info 5,208 0.00   0 0  
commit callback allocation 222,316 0.11 0.00 0 0  
compile environment latch 40,355 0.00   0 0  
dictionary lookup 39 0.00   0 0  
dml lock allocation 5,044,238 3.07 0.00 0 0  
dummy allocation 1,538 4.16 0.00 0 0  
enqueue hash chains 14,620,989 2.75 0.00 1 141 0.00
enqueues 7,014,204 27.13 0.00 1 0  
error message lists 667 4.95 0.00 0 0  
event group latch 435 0.00   0 0  
file cache latch 41,458 0.00 0.00 0 0  
global KZLD latch for mem in SGA 406 0.00   0 0  
global ctx hash table latch 271,017 0.00   0 0  
hash table column usage latch 1,097 1.28 0.00 0 487,602 0.00
hash table modification latch 169 0.59 0.00 0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job_queue_processes parameter latch 30 0.00   0 0  
kks stats 6,568 0.08 0.00 0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 3,814 0.00   0 0  
kwqbsn:qsga 1,082 0.00   0 0  
kwqbsn:qxl 1 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 294,665 0.29 0.00 0 0  
library cache 89,441,406 1.42 0.00 2 8,568 0.63
library cache load lock 14,955 1.18 0.01 0 53 0.00
library cache lock 12,803,387 1.36 0.00 0 0  
library cache lock allocation 47,619 0.00   0 0  
library cache pin 57,258,744 0.90 0.00 0 0  
library cache pin allocation 31,918 0.00   0 0  
list of block allocation 297,212 0.15 0.00 0 0  
loader state object freelist 9,726 0.10 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 5 0.00   0 5 0.00
message pool operations parent latch 9,903 0.14 0.00 0 0  
messages 2,491,644 0.82 0.00 0 0  
mostly latch-free SCN 331,700 9.76 0.00 0 0  
multiblock read objects 16,036 0.06 0.00 0 0  
ncodef allocation latch 40 0.00   0 0  
object queue header heap 2,215,286 0.00 0.00 0 13,228 0.02
object queue header operation 14,023,647 0.05 0.01 0 3,710 0.03
object stats modification 9,750 0.02 0.00 0 0  
parallel query alloc buffer 9,924 3.64 0.00 0 0  
parallel query stats 391 31.46 0.03 0 0  
parameter list 1,370 0.00   0 0  
parameter table allocation management 784 29.97 0.34 0 0  
post/wait queue 342,103 0.17 0.01 0 179,813 0.49
process allocation 903 0.44 0.25 0 432 0.69
process group creation 880 0.00   0 0  
process queue 6,360 0.74 0.00 0 0  
process queue reference 700,025 0.02 0.00 0 43,914 0.52
qmn task queue latch 2,264 12.28 0.10 0 0  
query server freelists 5,739 12.13 0.00 0 0  
query server process 28 0.00   0 42 0.00
redo allocation 2,578,979 1.47 0.00 0 68,314,003 1.60
redo copy 0     0 68,383,622 0.03
redo writing 1,687,437 1.75 0.00 0 0  
resmgr group change latch 2,919 0.00   0 0  
resmgr:actses active list 1,943 0.26 0.00 0 0  
resmgr:actses change group 1,537 0.00   0 0  
resmgr:free threads list 1,538 8.71 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 44,783,589 5.14 0.00 1 2,628 0.00
rules engine aggregate statistics 105,001 2.04 0.00 0 0  
rules engine evaluation context statistics 2 0.00   0 0  
rules engine rule set statistics 419,921 0.92 0.00 0 0  
rules engine rule statistics 209,861 0.00   0 0  
sequence cache 5,710,775 0.96 0.00 0 0  
session allocation 7,137,190 1.07 0.00 0 0  
session idle bit 362,025 0.00 0.00 0 0  
session state list latch 3,166 3.13 0.01 0 0  
session switching 40 0.00   0 0  
session timer 644 0.00   0 0  
shared pool 12,992,532 0.75 0.00 0 0  
shared pool sim alloc 33 3.03 0.00 0 0  
shared pool simulator 1,578,535 0.02 0.03 0 0  
simulator hash latch 88,435,895 0.01 0.00 0 0  
simulator lru latch 88,148,601 1.74 0.00 0 103,461 0.01
sort extent pool 33,083 0.18 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temporary table state object allocation 422 0.47 0.00 0 0  
threshold alerts latch 431 0.00   0 0  
trace latch 6 0.00   0 0  
transaction allocation 27,000 0.01 0.00 0 0  
transaction branch allocation 40 0.00   0 0  
undo global data 867,908,571 1.74 0.00 0 8,606 0.46
user lock 1,616 0.56 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 3,800,408,110 114,893,324 415,550 114,494,158 0 0 0
undo global data 867,908,571 15,144,993 1,114 15,144,114 0 0 0
In memory undo latch 736,154,176 11,167,811 6,580 11,161,720 0 0 0
row cache objects 44,783,589 2,303,872 1,289 2,302,667 0 0 0
enqueues 7,014,204 1,902,902 1,477 1,901,469 0 0 0
simulator lru latch 88,148,601 1,531,777 442 1,531,423 0 0 0
library cache 89,441,406 1,273,253 1,510 1,272,198 0 0 0
library cache pin 57,258,744 515,583 213 515,417 0 0 0
enqueue hash chains 14,620,989 402,267 760 401,549 0 0 0
library cache lock 12,803,387 174,069 50 174,032 0 0 0
dml lock allocation 5,044,238 154,670 27 154,647 0 0 0
shared pool 12,992,532 97,544 357 97,237 0 0 0
cache buffer handles 6,109,150 79,710 34 79,683 0 0 0
session allocation 7,137,190 76,526 108 76,436 0 0 0
sequence cache 5,710,775 54,542 7 54,535 0 0 0
active checkpoint queue latch 550,661 42,396 17 42,379 0 0 0
redo allocation 2,578,979 37,886 156 37,760 0 0 0
mostly latch-free SCN 331,700 32,365 39 32,331 0 0 0
redo writing 1,687,437 29,450 11 29,439 0 0 0
cache buffers lru chain 5,544,259 27,410 110 27,309 0 0 0
messages 2,491,644 20,346 15 20,331 0 0 0
object queue header operation 14,023,647 7,390 73 7,320 0 0 0
simulator hash latch 88,435,895 5,798 2 5,796 0 0 0
checkpoint queue latch 12,483,723 1,881 23 1,859 0 0 0
KWQMN job cache list latch 205,950 1,016 29 989 0 0 0
post/wait queue 342,103 567 5 562 0 0 0
active service list 7,596 444 3 441 0 0 0
list of block allocation 297,212 444 2 443 0 0 0
shared pool simulator 1,578,535 393 13 384 0 0 0
qmn task queue latch 2,264 278 29 249 0 0 0
parameter table allocation management 784 235 81 158 0 0 0
library cache load lock 14,955 177 2 175 0 0 0
parallel query stats 391 123 4 119 0 0 0
session state list latch 3,166 99 1 98 0 0 0
process allocation 903 4 1 3 0 0 0
JOX SGA heap latch 1,728,881 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 5,056 2,687
In memory undo latch kturbk 0 1,022 1,653
In memory undo latch ktichg: child 0 267 1,818
In memory undo latch kticmt: child 0 165 4
In memory undo latch ktiTxnPoolFree 0 46 1
In memory undo latch ktbgfc 0 23 418
In memory undo latch ktiBRacquire 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 525 524
active checkpoint queue latch kcbbacq: scan active checkpoints 0 17 17
active service list ksws_event: ksws event 0 32 27
cache buffer handles kcbzgs 0 24 20
cache buffer handles kcbzfs 0 9 14
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,687,145 1,644,169
cache buffers chains kcbchg: kslbegin: call CR func 0 595,144 1,078,795
cache buffers chains kcbgtcr: fast path 0 323,967 10,832
cache buffers chains kcbgtcr: kslbegin excl 0 176,359 54,684
cache buffers chains kcbgcur: kslbegin 0 42,110 11,492
cache buffers chains kcbget: pin buffer 0 15,550 3,802
cache buffers chains kcbzwb 0 9,790 8,985
cache buffers chains kcbzgb: scan from tail. nowait 0 7,373 0
cache buffers chains kcbrls: kslbegin 0 4,832 39,830
cache buffers chains kcbcge 0 1,292 10,518
cache buffers chains kcb_is_private 0 329 4,293
cache buffers chains kcbnlc 0 172 1,363
cache buffers chains kcbget: exchange 0 165 242
cache buffers chains kcbget: exchange rls 0 144 155
cache buffers chains kcbesc: escalate 0 66 42
cache buffers chains kcbbxsv 0 60 59
cache buffers chains kcbnew: new latch again 0 49 0
cache buffers chains kcbgtcr: kslbegin shared 0 13 6
cache buffers chains kcb_post_apply: kcbhq62 0 9 75
cache buffers chains kcb_pre_apply: kcbhq61 0 9 1,541
cache buffers chains kcbbic1 0 7 0
cache buffers chains kcbw_next_free 0 4 0
cache buffers chains kcb_post_apply: kcbhq63 0 1 114
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcbso1: set no access 0 1 8
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 7
cache buffers lru chain kcbbxsv: move to being written 0 46 72
cache buffers lru chain kcbzgws 0 34 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 15 0
cache buffers lru chain kcbzgb: posted for free bufs 0 8 27
cache buffers lru chain kcbzswcu 0 4 3
cache buffers lru chain kcbbic2 0 2 8
cache buffers lru chain kcbw_activate_granule 0 1 0
checkpoint queue latch kcbkubc 0 15 2
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 5 15
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
checkpoint queue latch kcbswcu: Switch buffers 0 1 5
dml lock allocation ktaiam 0 16 19
dml lock allocation ktaidm 0 11 8
enqueue hash chains ksqgtl3 0 401 538
enqueue hash chains ksqrcl 0 300 200
enqueue hash chains ksqcnl 0 38 11
enqueue hash chains ksqcmi: get hash chain latch after wait 0 20 10
enqueues ksqgel: create enqueue 0 868 819
enqueues ksqdel 0 608 657
enqueues ksqies 0 1 0
event range base latch No latch 0 31 31
lgwr LWN SCN kcs023 0 17 0
library cache kglpndl: child: after processing 0 531 8
library cache kglpnp: child 0 377 744
library cache kglpndl: child: before processing 0 362 336
library cache kglobpn: child: 0 146 339
library cache kglLockCursor 0 14 20
library cache kglget: unpin heap 0 0 14 17
library cache kgldte: child 0 0 9 17
library cache kglhdgn: child: 0 8 8
library cache kglpin 0 8 0
library cache kgldti: 2child 0 1 1
library cache kglivl: child 0 1 0
library cache kglrtl 0 1 0
library cache load lock kglllal: llatch: in loop 0 2 0
library cache lock kgllkdl: child: cleanup 0 33 33
library cache lock kgllkal: child: multiinstance 0 17 17
library cache lock kgllkdl: child: no lock handle 0 4 2
library cache pin kglpndl 0 113 54
library cache pin kglpnp: child 0 97 124
library cache pin kglpnal: child: alloc space 0 3 35
list of block allocation ktlabl 0 2 2
messages ksarcv 0 8 2
messages ksarcv: after wait 0 4 11
messages ksaamb: after wakeup 0 3 2
mostly latch-free SCN kcslcu3 0 22 54
object queue header operation kcbo_switch_mq_bg 0 26 10
object queue header operation kcbw_unlink_q 0 18 9
object queue header operation kcbw_link_q 0 13 8
object queue header operation kcbo_switch_q_bg 0 11 4
object queue header operation kcbo_ivbo 0 7 3
object queue header operation kcbo_switch_cq 0 5 5
object queue header operation kcbo_swap_buf_bg 0 3 46
object queue header operation kcbo_swap_buf 0 2 3
object queue header operation kcbo_write_q 0 1 0
parallel query stats kxfprst: KSLBEGIN:1 0 4 4
parameter table allocation management ksp_param_table_free 0 81 81
post/wait queue ksliwat:remove 0 5 5
process allocation ksudlp 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 130 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 18 124
redo allocation kcrfw_redo_write: before write 0 5 15
redo allocation kcrfw_redo_gen: redo allocation 2 0 3 0
redo writing kcrfwcr 0 8 10
redo writing kcrfw_post: rba scn pair 0 2 0
redo writing kcrfw_post: after write 0 1 0
row cache objects kqrpre: find obj 0 621 942
row cache objects kqreqd: reget 0 592 52
row cache objects kqreqd 0 74 293
row cache objects kqrpre: init complete 0 2 7
sequence cache kdnssd 0 6 0
sequence cache kdnnxt: cached seq 0 1 0
session allocation ksuprc 0 53 57
session allocation ksuxds: KSUSFCLC not set 0 26 23
session allocation ksudlc 0 16 17
session allocation ksucri 0 5 4
session allocation ksursi 0 4 6
session allocation kxfpqidqr 0 2 1
session allocation ksuxds: not user session 0 1 0
session allocation kxfprdp 0 1 0
session state list latch kpseqd 0 1 0
shared pool kghalo 0 221 267
shared pool kghfre 0 63 68
shared pool kghupr1 0 59 16
shared pool kghfrunp: clatch: wait 0 26 27
shared pool kghfrunp: alloc: session dur 0 14 5
shared pool kghfrunp: clatch: nowait 0 8 0
shared pool simulator kglsim_unpin_simhp 0 13 13
simulator hash latch kcbsacc: lookup dba 0 2 3
simulator lru latch kcbs_simulate: simulate set 0 398 431
simulator lru latch kcbs_simbufseq 0 37 11
simulator lru latch kcbs_shrink_pool 0 5 0
simulator lru latch kcbs_free_granule_sim_buffers 0 1 0
simulator lru latch kcbs_resize_pool : interpolation 0 1 0
undo global data kturimugur: child 0 834 477
undo global data ktudba: KSLBEGIN 0 189 613
undo global data ktusm_stealext: KSLBEGIN 0 47 5
undo global data ktusmasp: ktugd_tuux 0 19 3
undo global data ktusmupst: KSLBEGIN 0 16 2
undo global data ktudnx:child 0 5 8
undo global data ktuGetRetentionDuration 0 4 3

Back to Latch Statistics
Back to Top

 

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 103,075,648 6.89
APPLSYS APPS_TS_SEED WF_ACTIVITIES_PK   INDEX 43,708,800 2.92
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 42,927,184 2.87
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 30,766,208 2.06
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_PK WF_ITEM49 INDEX PARTITION 29,486,016 1.97

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 307,137 63.81
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 14,659 3.05
AR APPS_TS_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 13,915 2.89
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 10,534 2.19
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 5,421 1.13

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_QUEUES SYS_IOT_TOP_155922   INDEX 706,516 36.64
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 616,154 31.95
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 583,069 30.23
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 8,969 0.47
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 4,552 0.24

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_N3   INDEX 5 26.32
AR APPS_TS_TX_IDX AR_PAYMENT_SCHEDULES_N6   INDEX 3 15.79
ASO APPS_TS_QUEUES SYS_IOT_TOP_115246   INDEX 3 15.79
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N4   INDEX 3 15.79
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 2 10.53

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_QUEUES SYS_IOT_TOP_155922   INDEX 81,193 12.58
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 77,370 11.98
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 68,291 10.58
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 66,170 10.25
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 65,210 10.10

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 35 0.00 0   2 3
dc_constraints 143 48.25 0   143 33
dc_global_oids 1,205,236 0.00 0   4 79
dc_histogram_data 5,175 1.86 0   26 11,723
dc_histogram_defs 81,344 5.37 0   775 235,631
dc_object_grants 560 16.25 0   0 250
dc_object_ids 3,553,636 0.01 0   20 58,248
dc_objects 244,501 1.23 0   161 37,916
dc_profiles 406 0.00 0   0 1
dc_rollback_segments 3,725,610 0.00 0   22 728
dc_segments 83,615 0.99 0   20,757 36,792
dc_sequences 39,837 0.12 0   39,837 71
dc_table_scns 225,859 0.01 0   0 15
dc_tablespace_quotas 21,916 0.13 0   0 35
dc_tablespaces 1,827,781 0.00 0   0 55
dc_usernames 519,520 0.00 0   0 204
dc_users 4,815,557 0.00 0   0 165
outstanding_alerts 187 0.00 0   0 54


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 18,503 2.14 10,107,360 -0.01 1 0
CLUSTER 35 0.00 69 0.00 0 0
INDEX 463 3.46 785 3.31 1 0
JAVA DATA 113 2.65 1,036 0.77 0 0
PIPE 270 0.00 270 0.00 0 0
SQL AREA 9,293 94.16 48,796,110 -0.09 57 170
TABLE/PROCEDURE 43,445 8.54 15,044,193 0.04 204 0
TRIGGER 904 1.77 788,080 0.01 3 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 188.38   1.88 2.34 22 31 100 100
  Freeable 72.63 0.00 1.02 1.81 10   71 71
  SQL 13.83 6.48 0.15 0.23 1 5 94 78
  PL/SQL 6.18 2.42 0.06 0.05 0 0 100 86
E Other 245.54   2.73 4.35 28 31 90 90
  Freeable 36.88 0.00 0.71 1.28 9   52 52
  SQL 18.10 9.32 0.22 0.52 4 20 84 82
  PL/SQL 6.20 2.45 0.07 0.05 0 0 90 90

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,556,380,160 8,506,048,512
Fixed Size 2,090,528  
Redo Buffers 31,461,376  
Variable Size 2,147,486,176 2,197,817,824

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 16.00 49.15 207.16
java joxlod exec hp   14.18  
java joxs heap   0.67  
large PX msg pool 0.39 0.39 0.00
large free memory 15.61 15.61 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 49.21 57.73 17.31
shared Heap0: KGL 38.48 43.48 12.98
shared KGLS heap 162.24 132.93 -18.07
shared KQR L PO 37.66 37.05 -1.61
shared KQR M PO 164.35 162.30 -1.25
shared PCursor 40.73 47.44 16.48
shared PL/SQL MPCODE   41.49  
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 1,053.37 896.08 -14.93
shared kglsim object batch 22.82 22.91 0.39
shared ktcmvcb   26.34  
shared library cache 99.81 110.89 11.11
shared obj stat memo 28.67 28.70 0.10
shared private strands 22.17 22.17 0.00
shared sql area 39.13 152.84 290.63
streams KGH: NO ACCESS 15.98 15.98 0.00
streams free memory 16.00 16.00 -0.00
  buffer_cache 8,160.00 8,112.00 -0.59
  fixed_sga 1.99 1.99 0.00
  log_buffer 30.00 30.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,064,554 516,681 0
QMON Coordinator 39,509 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_20610 0 0 0
WFBESCL_20636 0 0 0
WFBESCL_20641 0 0 0
WFBESCL_20649 0 0 0
WFBESCL_20651 0 0 0
WFBESCL_20674 0 0 0
WFBESCL_20677 0 0 0
WFBESCL_20691 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,817 0 104,884 748 720
APPLSYS.FND_CP_GSM_OPP_AQ_R 1 0 0 0 0
SYS.ALERT_QUE_R 0 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   
_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 /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/bdump   
compatible 10.2.0.3   
core_dump_dest /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_file_multiblock_read_count 8   
db_files 512   
db_name VIS   
dml_locks 10000   
ifile /ds2/oracle/VIS/db/tech_st/10.2.0/dbs/VIS_r12db_ifile.ora   
job_queue_processes 2   
log_buffer 30507008   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size 20480   
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 14   
parallel_min_servers 0   
pga_aggregate_target 6442450944   
plsql_code_type INTERPRETED   
plsql_native_library_dir /ds2/oracle/VIS/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 800   
session_cached_cursors 500   
sessions 1600   
sga_target 10737418240   
shared_pool_size 2097152000   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 36000   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/udump   
utl_file_dir /usr/tmp, /ds2/oracle/VIS/db/tech_st/10.2.0/appsutil/outbound/VIS_r12db, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report