WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 193532335 VIS 1 10.2.0.3.0 NO db

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 2578 19-Mar-09 09:55:51 68 22.9
End Snap: 2579 19-Mar-09 10:40:35 69 23.3
Elapsed:   44.74 (mins)    
DB Time:   291.50 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 8,192M 8,192M Std Block Size: 8K
Shared Pool Size: 2,048M 2,048M Log Buffer: 14,340K

Load Profile

  Per Second Per Transaction
Redo size: 7,656,751.59 33,518.62
Logical reads: 513,391.72 2,247.45
Block changes: 47,037.78 205.92
Physical reads: 21.59 0.09
Physical writes: 550.45 2.41
User calls: 63.78 0.28
Parses: 734.07 3.21
Hard parses: 0.27 0.00
Sorts: 1,758.79 7.70
Logons: 0.17 0.00
Executes: 17,031.93 74.56
Transactions: 228.43  

% Blocks changed per Read: 9.16 Recursive Call %: 99.79
Rollback per transaction %: 0.10 Rows per Sort: 3.22

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.93 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.98 Soft Parse %: 99.96
Execute to Parse %: 95.69 Latch Hit %: 97.25
Parse CPU to Parse Elapsd %: 25.27 % Non-Parse CPU: 99.88

Shared Pool Statistics

  Begin End
Memory Usage %: 25.24 25.90
% SQL with executions>1: 95.22 92.65
% Memory for SQL w/exec>1: 95.84 95.49

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   8,053   46.0  
log file parallel write 405,082 661 2 3.8 System I/O
log file sync 135,303 493 4 2.8 Commit
buffer busy waits 965,901 319 0 1.8 Concurrency
db file parallel write 103,382 193 2 1.1 System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 17,476.53 99.92
DB CPU 8,053.11 46.04
PL/SQL execution elapsed time 3,492.10 19.97
Java execution elapsed time 404.59 2.31
parse time elapsed 53.72 0.31
sequence load elapsed time 8.63 0.05
hard parse elapsed time 6.63 0.04
repeated bind elapsed time 4.05 0.02
connection management call elapsed time 0.67 0.00
hard parse (sharing criteria) elapsed time 0.19 0.00
PL/SQL compilation elapsed time 0.16 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
inbound PL/SQL rpc elapsed time 0.01 0.00
DB time 17,490.02  
background elapsed time 960.63  
background cpu time 53.70  

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 512,110 0.00 857 2 0.84
Concurrency 1,066,160 0.02 515 0 1.74
Commit 135,303 0.00 493 4 0.22
User I/O 53,958 0.00 162 3 0.09
Application 16,605 0.00 147 9 0.03
Other 171,599 42.90 71 0 0.28
Configuration 24,578 64.25 12 0 0.04
Network 305,146 0.00 3 0 0.50

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 405,082 0.00 661 2 0.66
log file sync 135,303 0.00 493 4 0.22
buffer busy waits 965,901 0.00 319 0 1.58
db file parallel write 103,382 0.00 193 2 0.17
db file sequential read 42,674 0.00 146 3 0.07
enq: TX - row lock contention 16,292 0.00 146 9 0.03
latch: cache buffers chains 75,464 0.00 62 1 0.12
latch: library cache 2,764 0.00 48 17 0.00
enq: TX - index contention 16,606 0.00 36 2 0.03
latch free 1,681 0.00 19 11 0.00
latch: library cache pin 1,021 0.00 18 17 0.00
enq: TX - contention 8,814 0.00 14 2 0.01
read by other session 7,985 0.01 12 2 0.01
enq: HW - contention 5,798 0.00 11 2 0.01
latch: In memory undo latch 2,222 0.00 9 4 0.00
latch: row cache objects 621 0.00 8 13 0.00
LGWR wait for redo copy 21,269 0.62 8 0 0.03
latch: redo allocation 1,314 0.00 8 6 0.00
latch: undo global data 1,655 0.00 7 4 0.00
latch: shared pool 546 0.00 6 11 0.00
latch: library cache lock 215 0.00 5 25 0.00
cursor: pin S wait on X 282 89.36 3 12 0.00
db file scattered read 1,908 0.00 3 2 0.00
SQL*Net more data to client 152,124 0.00 3 0 0.25
buffer deadlock 18,592 99.60 3 0 0.03
latch: enqueue hash chains 155 0.00 2 16 0.00
latch: session allocation 224 0.00 2 11 0.00
control file parallel write 1,313 0.00 2 2 0.00
enq: FB - contention 1,627 0.00 2 1 0.00
latch: cache buffers lru chain 261 0.00 2 7 0.00
rdbms ipc reply 1,842 0.00 2 1 0.00
PX Deq Credit: send blkd 2,582 0.00 1 0 0.00
cursor: pin S 56,429 0.00 1 0 0.09
control file sequential read 2,333 0.00 1 0 0.00
kksfbc child completion 16 81.25 1 40 0.00
enq: SQ - contention 2,833 0.00 1 0 0.00
SQL*Net break/reset to client 276 0.00 0 1 0.00
os thread startup 15 0.00 0 21 0.00
PX Deq: Signal ACK 25 40.00 0 12 0.00
wait list latch free 13 0.00 0 20 0.00
enq: RO - fast object reuse 37 0.00 0 4 0.00
latch: object queue header operation 50 0.00 0 2 0.00
local write wait 66 0.00 0 2 0.00
SQL*Net message to client 145,588 0.00 0 0 0.24
latch: redo writing 19 0.00 0 4 0.00
row cache lock 500 0.00 0 0 0.00
PX qref latch 54,997 99.92 0 0 0.09
SQL*Net more data from client 7,434 0.00 0 0 0.01
direct path read 1,050 0.00 0 0 0.00
undo segment extension 15,825 99.79 0 0 0.03
latch: checkpoint queue latch 6 0.00 0 4 0.00
direct path write 271 0.00 0 0 0.00
enq: TX - allocate ITL entry 102 0.00 0 0 0.00
log buffer space 1 0.00 0 10 0.00
direct path write temp 4 0.00 0 1 0.00
reliable message 35 0.00 0 0 0.00
latch: messages 2 0.00 0 0 0.00
enq: PS - contention 6 0.00 0 0 0.00
latch: cache buffer handles 4 0.00 0 0 0.00
cursor: mutex X 3 0.00 0 0 0.00
SQL*Net message from client 145,587 0.00 57,358 394 0.24
Streams AQ: waiting for messages in the queue 836 97.97 5,325 6370 0.00
PL/SQL lock timer 267 100.00 2,933 10984 0.00
PX Idle Wait 1,376 97.09 2,622 1906 0.00
pipe get 1,073 100.00 2,619 2441 0.00
Streams AQ: qmn coordinator idle wait 969 42.41 2,616 2699 0.00
Streams AQ: qmn slave idle wait 470 0.00 2,616 5565 0.00
Streams AQ: waiting for time management or cleanup tasks 75 41.33 2,076 27674 0.00
jobq slave wait 140 100.00 410 2930 0.00
PX Deq: Execution Msg 497 0.00 5 10 0.00
PX Deq: Execute Reply 250 0.00 1 2 0.00
PX Deq: Msg Fragment 306 0.00 0 0 0.00
PX Deq Credit: need buffer 394 0.00 0 0 0.00
PX Deq: Parse Reply 21 0.00 0 1 0.00
PX Deq: Table Q Normal 808 0.00 0 0 0.00
PX Deq: Join ACK 27 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 405,082 0.00 661 2 0.66
db file parallel write 103,382 0.00 193 2 0.17
events in waitclass Other 23,715 0.55 11 0 0.04
control file parallel write 1,313 0.00 2 2 0.00
control file sequential read 638 0.00 1 1 0.00
db file sequential read 47 0.00 0 5 0.00
os thread startup 7 0.00 0 26 0.00
latch: redo writing 19 0.00 0 4 0.00
buffer busy waits 145 0.00 0 0 0.00
direct path write 258 0.00 0 0 0.00
latch: library cache 2 0.00 0 11 0.00
log buffer space 1 0.00 0 10 0.00
latch: row cache objects 1 0.00 0 6 0.00
latch: In memory undo latch 3 0.00 0 1 0.00
direct path read 1,038 0.00 0 0 0.00
undo segment extension 776 99.48 0 0 0.00
latch: cache buffers chains 2 0.00 0 0 0.00
rdbms ipc message 395,212 2.03 20,758 53 0.64
smon timer 2,569 0.00 2,676 1042 0.00
pmon timer 946 100.00 2,619 2769 0.00
Streams AQ: qmn coordinator idle wait 969 42.41 2,616 2699 0.00
Streams AQ: qmn slave idle wait 470 0.00 2,616 5565 0.00
Streams AQ: waiting for time management or cleanup tasks 75 41.33 2,076 27674 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 94,445
AVG_IDLE_TIME 39,760
AVG_IOWAIT_TIME 679
AVG_SYS_TIME 2,948
AVG_USER_TIME 91,406
BUSY_TIME 1,512,419
IDLE_TIME 637,440
IOWAIT_TIME 11,875
SYS_TIME 48,555
USER_TIME 1,463,864
LOAD 0
OS_CPU_WAIT_TIME 1,814,200
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 66,303,557,632
NUM_CPUS 16
NUM_CPU_CORES 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 17,464.40 8,039.80 56,705 1,368,772,196
SYS$USERS 25.70 13.30 141 6,820,243
SYS$BACKGROUND 0.00 0.00 1,085 2,488,980

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 52199 16128 1065992 51449 0 0 303919 336
SYS$USERS 416 52 5 1 0 0 48 0
SYS$BACKGROUND 1343 24 160 24 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
5,948 3,027 16 371.77 34.01 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
5,630 2,144 8 703.77 32.19 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
2,246 609 100 22.46 12.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
2,040 986 49,865 0.04 11.67 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
1,986 1,052 50,000 0.04 11.35 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN...
1,720 884 10 171.95 9.83 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,356 352 50,000 0.03 7.75 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
590 300 10 58.95 3.37 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
579 411 149,995 0.00 3.31 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
541 356 50,000 0.01 3.09 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
493 410 204,893 0.00 2.82 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
387 386 399,995 0.00 2.21 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
374 373 354,946 0.00 2.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
356 347 49,926 0.01 2.03 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
337 182 50,000 0.01 1.93 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
316 300 2,819,752 0.00 1.81 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
273 240 1,689,899 0.00 1.56 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
179 166 1,344,886 0.00 1.02 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...

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,027 5,948 16 189.18 34.01 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,144 5,630 8 267.94 32.19 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,052 1,986 50,000 0.02 11.35 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN...
986 2,040 49,865 0.02 11.67 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
884 1,720 10 88.41 9.83 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
609 2,246 100 6.09 12.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
411 579 149,995 0.00 3.31 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
410 493 204,893 0.00 2.82 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
386 387 399,995 0.00 2.21 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
373 374 354,946 0.00 2.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
356 541 50,000 0.01 3.09 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
352 1,356 50,000 0.01 7.75 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
347 356 49,926 0.01 2.03 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
300 316 2,819,752 0.00 1.81 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
300 590 10 29.96 3.37 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
240 273 1,689,899 0.00 1.56 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
182 337 50,000 0.00 1.93 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
166 179 1,344,886 0.00 1.02 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...

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
637,364,586 16 39,835,286.63 46.25 3026.81 5948.29 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
227,037,073 8 28,379,634.13 16.47 2143.53 5630.16 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
223,335,719 10 22,333,571.90 16.21 884.11 1719.51 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
121,564,102 50,000 2,431.28 8.82 1052.11 1985.55 1mr538jsgzb45 WSHPSGL_SUB SELECT DISTINCT WDD.SOURCE_LIN...
111,682,696 399,995 279.21 8.10 386.27 386.50 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
102,943,590 354,946 290.03 7.47 373.06 374.44 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
83,993,408 100 839,934.08 6.09 608.54 2245.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
63,640,554 49,865 1,276.26 4.62 986.21 2040.35 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
60,485,391 50,000 1,209.71 4.39 356.24 541.22 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
58,011,237 2,819,752 20.57 4.21 300.22 316.50 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
50,913,979 10 5,091,397.90 3.69 299.62 589.54 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
49,321,813 149,995 328.82 3.58 411.42 578.93 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
43,584,254 1,689,899 25.79 3.16 240.34 273.50 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
25,382,009 309,967 81.89 1.84 122.40 128.40 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
24,076,515 50,000 481.53 1.75 352.18 1355.81 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
23,147,949 1,344,886 17.21 1.68 166.07 178.62 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
20,383,540 4 5,095,885.00 1.48 119.36 132.12 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
19,302,531 54,984 351.06 1.40 131.45 147.46 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
15,823,978 29,965 528.08 1.15 68.37 68.39 6uwctg1cdb25v WSHPSGL_SUB SELECT DG.DELIVERY_LEG_ID LEG_...
14,481,837 16 905,114.81 1.05 111.67 149.20 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
14,450,872 3 4,816,957.33 1.05 153.52 154.13 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
32,368 8 4,046.00 55.85 2143.53 5630.16 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
31,007 49,865 0.62 53.50 986.21 2040.35 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
11,467 16 716.69 19.79 111.67 149.20 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
2,901 16 181.31 5.01 3026.81 5948.29 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,118 10 211.80 3.65 299.62 589.54 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
758 10 75.80 1.31 884.11 1719.51 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
741 54,984 0.01 1.28 131.45 147.46 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
480 3 160.00 0.83 153.52 154.13 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
357 100 3.57 0.62 608.54 2245.63 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
307 49,926 0.01 0.53 346.70 355.69 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...

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,819,752 1,528,273 0.54 0.00 0.00 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
1,689,899 1,689,666 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
1,344,886 1,344,791 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
399,995 49,978 0.12 0.00 0.00 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
399,471 398,361 1.00 0.00 0.00 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A...
354,946 0 0.00 0.00 0.00 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
309,967 309,011 1.00 0.00 0.00 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
204,893 204,819 1.00 0.00 0.00 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
199,947 199,826 1.00 0.00 0.00 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,904 199,697 1.00 0.00 0.00 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
199,988 199,947 10.15 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,978 199,904 10.15 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,970 149,997 7.61 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
100,014 100,021 5.08 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
99,902 99,954 5.07 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
60,001 59,987 3.05 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
60,000 59,994 3.05 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
59,999 59,999 3.04 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
59,999 59,996 3.04 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
54,992 54,984 2.79 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
50,012 50,018 2.54 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
50,000 50,000 2.54 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
49,998 49,994 2.54 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN...
49,998 50,000 2.54 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
49,997 49,992 2.54 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO...
49,994 49,865 2.54 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
49,992 49,998 2.54 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
49,991 49,978 2.54 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI...
49,964 49,975 2.54 bsuw7pmwrufpy INCTCW SELECT reservation_...
49,957 49,981 2.54 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
49,941 49,987 2.53 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
49,932 49,926 2.53 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
44,998 45,000 2.28 7gtztzv329wg0   select c.name, u.name from co...
44,997 44,997 2.28 2skwhauh2cwky   select o.name, u.name from ob...
41,756 41,756 2.12 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
21,301 21,302 1.08 bsa0wjtftg3uw   select file# from file$ where ...
21,022 21,023 1.07 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0074pdmwb7fmv BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0r0gvtarcjwzz insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1mr538jsgzb45 SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE, WDD.CUSTOMER_ID FROM WSH_DELIVERY_DETAILS WDD, wsh_delivery_assignments_v WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGA NIZATION_ID = MSI.ORGANIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND WDD.INVENTORY_ITEM_ID = :X_inventory_item_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
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
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
72yyswsqkzkrm BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7mrs575bj7a41 begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4 BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8zfgv4ck11dw9 BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23 select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
assndb4wqnd6r BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09 SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uw select file# from file$ where ts#=:1
bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
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;

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 800,991 298.40 1.31
CPU used when call started 799,907 298.00 1.30
CR blocks created 16,320,864 6,080.19 26.62
Cached Commit SCN referenced 217,495 81.03 0.35
Commit SCN cached 90 0.03 0.00
DB time 2,944,483 1,096.94 4.80
DBWR checkpoint buffers written 1,423,630 530.36 2.32
DBWR checkpoints 36 0.01 0.00
DBWR object drop buffers written 1,972 0.73 0.00
DBWR revisited being-written buffer 6 0.00 0.00
DBWR thread checkpoint buffers written 258,697 96.38 0.42
DBWR transaction table writes 191 0.07 0.00
DBWR undo block writes 995,439 370.84 1.62
DFO trees parallelized 5 0.00 0.00
IMU CR rollbacks 5,738,414 2,137.79 9.36
IMU Flushes 349,073 130.04 0.57
IMU Redo allocation size 1,373,400,704 511,647.94 2,239.82
IMU bind flushes 0 0.00 0.00
IMU commits 315,021 117.36 0.51
IMU contention 89,577 33.37 0.15
IMU ktichg flush 346 0.13 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 278 0.10 0.00
IMU undo allocation size 2,150,806,024 801,263.22 3,507.65
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 6,229 2.32 0.01
PX local messages sent 6,229 2.32 0.01
Parallel operations downgraded 25 to 50 pct 4 0.00 0.00
Parallel operations downgraded 50 to 75 pct 0 0.00 0.00
Parallel operations not downgraded 1 0.00 0.00
SMON posted for undo segment shrink 107 0.04 0.00
SQL*Net roundtrips to/from client 144,407 53.80 0.24
active txn count during cleanout 61,072,598 22,752.04 99.60
application wait time 14,653 5.46 0.02
background checkpoints completed 1 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 8,585 3.20 0.01
branch node splits 559 0.21 0.00
buffer is not pinned count 381,178,308 142,004.51 621.65
buffer is pinned count 2,945,412,901 1,097,286.78 4,803.54
bytes received via SQL*Net from client 47,936,009 17,858.12 78.18
bytes sent via SQL*Net to client 338,982,879 126,284.99 552.83
calls to get snapshot scn: kcmgss 55,396,023 20,637.28 90.34
calls to kcmgas 19,123,373 7,124.24 31.19
calls to kcmgcs 2,906,978 1,082.97 4.74
change write time 36,761 13.69 0.06
cleanout - number of ktugct calls 19,123,115 7,124.14 31.19
cleanouts and rollbacks - consistent read gets 14,224,866 5,299.34 23.20
cleanouts only - consistent read gets 56,451 21.03 0.09
cluster key scan block gets 153,146 57.05 0.25
cluster key scans 80,213 29.88 0.13
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 48,583 18.10 0.08
commit batch/immediate requested 48,583 18.10 0.08
commit cleanout failures: block lost 182,158 67.86 0.30
commit cleanout failures: buffer being written 29 0.01 0.00
commit cleanout failures: callback failure 82,088 30.58 0.13
commit cleanout failures: cannot pin 32,971 12.28 0.05
commit cleanouts 7,243,802 2,698.61 11.81
commit cleanouts successfully completed 6,946,556 2,587.88 11.33
commit immediate performed 48,583 18.10 0.08
commit immediate requested 48,583 18.10 0.08
commit txn count during cleanout 858,734 319.91 1.40
concurrency wait time 51,474 19.18 0.08
consistent changes 650,737,202 242,426.23 1,061.26
consistent gets 1,243,498,574 463,254.08 2,027.97
consistent gets - examination 885,469,988 329,873.79 1,444.07
consistent gets direct 54 0.02 0.00
consistent gets from cache 1,243,498,520 463,254.06 2,027.97
cursor authentications 698 0.26 0.00
data blocks consistent reads - undo records applied 644,762,919 240,200.56 1,051.52
db block changes 126,262,053 47,037.78 205.92
db block gets 134,582,896 50,137.63 219.49
db block gets direct 351 0.13 0.00
db block gets from cache 134,582,545 50,137.50 219.48
deferred (CURRENT) block cleanout applications 1,228,921 457.82 2.00
dirty buffers inspected 24,888 9.27 0.04
doubling up with imu segment 0 0.00 0.00
enqueue conversions 1,746 0.65 0.00
enqueue releases 3,756,153 1,399.32 6.13
enqueue requests 4,095,628 1,525.79 6.68
enqueue timeouts 339,474 126.47 0.55
enqueue waits 42,827 15.95 0.07
exchange deadlocks 18,607 6.93 0.03
execute count 45,718,295 17,031.93 74.56
failed probes on index block reclamation 923,822 344.16 1.51
free buffer inspected 1,712,184 637.86 2.79
free buffer requested 18,205,303 6,782.22 29.69
heap block compress 30,519,129 11,369.62 49.77
hot buffers moved to head of LRU 759,184 282.83 1.24
immediate (CR) block cleanout applications 14,281,320 5,320.38 23.29
immediate (CURRENT) block cleanout applications 771,126 287.28 1.26
index crx upgrade (found) 112,752 42.00 0.18
index crx upgrade (positioned) 2,981,853 1,110.86 4.86
index fast full scans (rowid ranges) 96 0.04 0.00
index fetch by key 97,235,273 36,224.12 158.58
index scans kdiixs1 28,699,640 10,691.79 46.80
java call heap collected bytes 808,936,720 301,362.02 1,319.26
java call heap collected count 11,169,900 4,161.24 18.22
java call heap gc count 2,446 0.91 0.00
java call heap live object count 527,490 196.51 0.86
java call heap live object count max 528,885 197.03 0.86
java call heap live size 185,680,536 69,173.59 302.82
java call heap live size max 185,913,848 69,260.51 303.20
java call heap object count 1,224,869 456.31 2.00
java call heap object count max 1,243,548 463.27 2.03
java call heap total size 255,080,448 95,027.90 416.00
java call heap total size max 255,080,448 95,027.90 416.00
java call heap used size 232,498,144 86,615.07 379.17
java call heap used size max 234,239,480 87,263.79 382.01
leaf node 90-10 splits 7,911 2.95 0.01
leaf node splits 133,048 49.57 0.22
lob reads 3,075,037 1,145.58 5.01
lob writes 1,310,074 488.06 2.14
lob writes unaligned 1,310,074 488.06 2.14
logons cumulative 448 0.17 0.00
messages received 577,910 215.30 0.94
messages sent 577,910 215.30 0.94
no buffer to keep pinned count 12 0.00 0.00
no work - consistent read gets 325,140,128 121,128.00 530.26
opened cursors cumulative 791,326 294.80 1.29
parse count (failures) 0 0.00 0.00
parse count (hard) 722 0.27 0.00
parse count (total) 1,970,434 734.07 3.21
parse time cpu 940 0.35 0.00
parse time elapsed 3,720 1.39 0.01
physical read IO requests 45,392 16.91 0.07
physical read bytes 474,750,976 176,864.16 774.25
physical read total IO requests 47,983 17.88 0.08
physical read total bytes 515,088,384 191,891.49 840.03
physical read total multi block requests 1,920 0.72 0.00
physical reads 57,953 21.59 0.09
physical reads cache 56,854 21.18 0.09
physical reads cache prefetch 12,525 4.67 0.02
physical reads direct 1,099 0.41 0.00
physical reads direct (lob) 48 0.02 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 151,335 56.38 0.25
physical write bytes 12,104,171,520 4,509,299.00 19,740.16
physical write total IO requests 904,826 337.08 1.48
physical write total bytes 33,612,868,608 12,522,168.46 54,817.74
physical write total multi block requests 848,029 315.93 1.38
physical writes 1,477,560 550.45 2.41
physical writes direct 609 0.23 0.00
physical writes direct (lob) 13 0.00 0.00
physical writes direct temporary tablespace 288 0.11 0.00
physical writes from cache 1,476,951 550.22 2.41
physical writes non checkpoint 678,327 252.70 1.11
pinned buffers inspected 5,497 2.05 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 13 0.00 0.00
process last non-idle time 2,751 1.02 0.00
queries parallelized 5 0.00 0.00
recursive aborts on index block reclamation 6 0.00 0.00
recursive calls 82,654,265 30,792.09 134.80
recursive cpu usage 688,545 256.51 1.12
redo blocks written 41,883,126 15,603.18 68.31
redo buffer allocation retries 0 0.00 0.00
redo entries 68,776,121 25,621.92 112.16
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 900,572 335.50 1.47
redo size 20,552,780,924 7,656,751.59 33,518.62
redo subscn max counts 1,453,665 541.55 2.37
redo synch time 49,196 18.33 0.08
redo synch writes 122,344 45.58 0.20
redo wastage 186,793,948 69,588.39 304.63
redo write time 69,856 26.02 0.11
redo writer latching time 907 0.34 0.00
redo writes 405,082 150.91 0.66
rollback changes - undo records applied 62,623 23.33 0.10
rollbacks only - consistent read gets 2,178,676 811.65 3.55
rows fetched via callback 33,792,161 12,588.96 55.11
session connect time 0 0.00 0.00
session cursor cache hits 1,832,997 682.87 2.99
session logical reads 1,378,081,470 513,391.72 2,247.45
session pga memory 76,622,368 28,544.97 124.96
session pga memory max 189,868,576 70,733.81 309.65
session uga memory 30,079,822,344 11,205,964.21 49,055.85
session uga memory max 7,532,964,456 2,806,337.39 12,285.18
shared hash latch upgrades - no wait 23,619,766 8,799.33 38.52
shared hash latch upgrades - wait 179,392 66.83 0.29
sorts (memory) 4,721,068 1,758.79 7.70
sorts (rows) 15,210,422 5,666.50 24.81
sql area evicted 338 0.13 0.00
sql area purged 92 0.03 0.00
summed dirty queue length 161,137 60.03 0.26
switch current to new buffer 1,105,727 411.93 1.80
table fetch by rowid 1,600,391,271 596,211.21 2,610.01
table fetch continued row 17,368,031 6,470.30 28.32
table scan blocks gotten 6,668,355 2,484.24 10.88
table scan rows gotten 347,996,385 129,642.89 567.53
table scans (long tables) 195 0.07 0.00
table scans (rowid ranges) 195 0.07 0.00
table scans (short tables) 1,395,321 519.81 2.28
total number of times SMON posted 2,569 0.96 0.00
transaction rollbacks 48,583 18.10 0.08
transaction tables consistent read rollbacks 115 0.04 0.00
transaction tables consistent reads - undo records applied 324,737 120.98 0.53
undo change vector size 7,448,431,960 2,774,845.58 12,147.32
user I/O wait time 16,207 6.04 0.03
user calls 171,197 63.78 0.28
user commits 612,581 228.21 1.00
user rollbacks 594 0.22 0.00
workarea executions - optimal 1,883,023 701.50 3.07
write clones created in background 67 0.02 0.00
write clones created in foreground 230 0.09 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
logons current 68 69
session cursor cache count 29,528 48,810
opened cursors current 1,560 1,611

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 1 0 0.00 1.00 78,614 29 546,392 0.30
APPS_TS_TX_IDX 18,416 7 3.65 1.00 26,474 10 117,827 0.40
APPS_TS_TX_DATA 15,767 6 3.66 1.68 17,757 7 181,707 0.28
APPS_TS_QUEUES 666 0 4.26 1.00 16,626 6 51,680 1.10
APPS_TS_INTERFACE 9,350 3 2.09 1.16 2,933 1 49,670 0.11
APPS_TS_SUMMARY 121 0 3.64 1.00 7,784 3 22,405 0.44
SYSTEM 156 0 4.36 1.11 598 0 3,703 0.15
SYSAUX 208 0 3.46 1.00 351 0 0 0.00
APPS_TS_SEED 314 0 4.49 1.04 5 0 33 5.45
APPS_TS_ARCHIVE 40 0 5.25 1.00 85 0 3 0.00
TEMP 41 0 0.73 7.10 40 0 0 0.00
APPS_TS_MEDIA 21 0 6.67 1.00 7 0 0 0.00
APPS_TS_NOLOGGING 5 0 4.00 1.00 13 0 331 0.09
GEOR_TBS 14 0 1.43 1.00 2 0 0 0.00
CWMLITE 12 0 1.67 1.00 2 0 0 0.00
DCM 12 0 1.67 1.00 2 0 0 0.00
CTXSYS 9 0 1.11 1.00 2 0 0 0.00
APPS_CALCLIP 4 0 0.00 1.00 4 0 0 0.00
DISCO_PTM5_CACHE 7 0 1.43 1.00 1 0 0 0.00
DISCO_PTM5_META 7 0 1.43 1.00 1 0 0 0.00
DSGATEWAY_TAB 7 0 1.43 1.00 1 0 0 0.00
HTMLDB 7 0 1.43 1.00 1 0 0 0.00
PORTAL 7 0 1.43 1.00 1 0 0 0.00
PORTAL_DOC 7 0 1.43 1.00 1 0 0 0.00
PORTAL_IDX 7 0 1.43 1.00 1 0 0 0.00
PORTAL_LOG 7 0 1.43 1.00 1 0 0 0.00
RE 7 0 1.43 1.00 1 0 0 0.00
SYNCSERVER 7 0 2.86 1.00 1 0 0 0.00
B2B_DT 6 0 1.67 1.00 1 0 0 0.00
B2B_IDX 6 0 1.67 1.00 1 0 0 0.00
B2B_LOB 6 0 1.67 1.00 1 0 0 0.00
B2B_RT 6 0 1.67 1.00 1 0 0 0.00
BAM 6 0 1.67 1.00 1 0 0 0.00
IAS_META 6 0 1.67 1.00 1 0 0 0.00
MTR 6 0 1.67 1.00 1 0 0 0.00
NOETIX 6 0 1.67 1.00 1 0 0 0.00
NON_APPS_TS_DATA 6 0 1.67 1.00 1 0 0 0.00
OCATS 6 0 1.67 1.00 1 0 0 0.00
ODM_DATA 6 0 1.67 1.00 1 0 0 0.00
OLTS_ATTRSTORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_BATTRSTORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_CT_STORE 6 0 1.67 1.00 1 0 0 0.00
OLTS_DEFAULT 6 0 1.67 1.00 1 0 0 0.00
OLTS_SVRMGSTORE 6 0 1.67 1.00 1 0 0 0.00
OPMOR 6 0 1.67 1.00 1 0 0 0.00
ORABPEL 6 0 1.67 1.00 1 0 0 0.00
OWAPUB 6 0 1.67 1.00 1 0 0 0.00
UDDISYS_TS 6 0 1.67 1.00 1 0 0 0.00
WCRSYS_TS 6 0 1.67 1.00 1 0 0 0.00
XDB 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_TOOLS 4 0 5.00 1.00 1 0 0 0.00
APPS_OMO 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_CALCLIP /ds1/oracle/VIS/db/apps_st/data/apps_calclip.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/apps_st/data/apps_calclip1.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/apps_st/data/apps_calclip2.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/apps_st/data/apps_calclip3.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_OMO /ds1/oracle/VIS/db/apps_st/data/omo1.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_ARCHIVE /ds1/oracle/VIS/db/apps_st/data/archive1.dbf 40 0 5.25 1.00 85 0 3 0.00
APPS_TS_DISCO /ds1/oracle/VIS/db/apps_st/data/disco1.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP /ds1/oracle/VIS/db/apps_st/data/disco_drake1.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface.db 151 0 1.72 1.48 89 0 1,996 0.03
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface1.d 2 0 5.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface10. 2 0 5.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface11. 2 0 5.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface12. 2 0 5.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface13. 35 0 1.43 4.66 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface14. 2 0 5.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface15. 126 0 1.27 1.64 6 0 7 1.43
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface16. 103 0 1.07 2.46 5 0 2 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface17. 75 0 1.60 3.01 14 0 42 3.81
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface18. 48 0 2.29 4.31 2 0 14 1.43
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface19. 21 0 1.43 3.62 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface2.d 22 0 1.82 3.77 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface20. 32 0 1.56 4.28 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface21. 40 0 1.00 3.65 9 0 9 3.33
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface22. 37 0 1.89 5.00 3 0 12 3.33
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface23. 21 0 2.86 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface24. 18 0 1.11 5.17 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface25. 33 0 4.24 3.33 4 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface26. 9 0 5.56 1.78 30 0 42 0.48
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface27. 910 0 2.64 1.02 301 0 4,589 0.12
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface28. 902 0 2.05 1.01 285 0 5,421 0.09
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface29. 843 0 2.03 1.02 259 0 3,639 0.17
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface3.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface30. 874 0 2.07 1.03 294 0 2,097 0.21
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface31. 821 0 2.06 1.04 269 0 4,934 0.15
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface32. 881 0 2.29 1.02 310 0 3,400 0.24
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface33. 838 0 1.98 1.01 271 0 5,973 0.04
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface34. 866 0 1.62 1.01 275 0 7,402 0.05
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface35. 786 0 2.33 1.00 235 0 5,877 0.11
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface36. 827 0 2.01 1.00 251 0 4,214 0.08
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface4.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface5.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface6.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface7.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface8.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/apps_st/data/apps_ts_interface9.d 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media1.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media2.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media3.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media4.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media5.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media6.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/apps_st/data/media7.dbf 3 0 6.67 1.00 1 0 0 0.00
APPS_TS_NOLOGGING /ds1/oracle/VIS/db/apps_st/data/nologging1.dbf 5 0 4.00 1.00 13 0 331 0.09
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues1.dbf 5 0 4.00 1.00 92 0 376 2.74
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues2.dbf 4 0 5.00 1.00 71 0 2,765 0.35
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues3.dbf 119 0 4.37 1.00 3,340 1 10,513 1.02
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues4.dbf 161 0 4.35 1.00 3,358 1 10,212 1.05
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues5.dbf 119 0 3.95 1.00 3,298 1 9,019 1.53
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues6.dbf 120 0 4.67 1.00 3,114 1 9,106 1.14
APPS_TS_QUEUES /ds1/oracle/VIS/db/apps_st/data/queues7.dbf 138 0 3.99 1.00 3,353 1 9,689 0.93
APPS_TS_SEED /ds1/oracle/VIS/db/apps_st/data/reference1.dbf 96 0 4.69 1.00 1 0 8 6.25
APPS_TS_SEED /ds1/oracle/VIS/db/apps_st/data/reference2.dbf 117 0 4.53 1.09 1 0 15 6.00
APPS_TS_SEED /ds1/oracle/VIS/db/apps_st/data/reference3.dbf 90 0 4.56 1.00 1 0 10 4.00
APPS_TS_SEED /ds1/oracle/VIS/db/apps_st/data/reference4.dbf 5 0 2.00 1.00 1 0 0 0.00
APPS_TS_SEED /ds1/oracle/VIS/db/apps_st/data/reference5.dbf 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary1.dbf 4 0 5.00 1.00 652 0 1,795 0.63
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary10.dbf 6 0 3.33 1.00 678 0 1,693 0.41
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary11.dbf 18 0 2.22 1.00 702 0 2,780 0.57
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary12.dbf 23 0 3.04 1.00 681 0 2,695 0.38
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary13.dbf 8 0 5.00 1.00 767 0 1,951 0.25
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary2.dbf 4 0 5.00 1.00 678 0 1,622 0.51
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary3.dbf 6 0 5.00 1.00 40 0 1,678 0.05
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary4.dbf 6 0 5.00 1.00 625 0 1,707 0.66
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary5.dbf 6 0 5.00 1.00 737 0 1,624 0.30
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary6.dbf 4 0 5.00 1.00 755 0 1,762 0.64
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary7.dbf 4 0 5.00 1.00 743 0 1,458 0.54
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary8.dbf 4 0 5.00 1.00 11 0 0 0.00
APPS_TS_SUMMARY /ds1/oracle/VIS/db/apps_st/data/summary9.dbf 28 0 2.86 1.00 715 0 1,640 0.35
APPS_TS_TOOLS /ds1/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf 4 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data1.dbf 4 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data10.dbf 4 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data11.dbf 89 0 2.58 6.73 1 0 272 1.03
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data12.dbf 84 0 1.43 7.06 3 0 278 1.12
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data13.dbf 86 0 1.86 6.92 3 0 270 1.04
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data14.dbf 4 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data15.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data16.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data17.dbf 5 0 4.00 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data18.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data19.dbf 75 0 2.13 7.27 2 0 267 0.67
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data2.dbf 79 0 1.90 7.27 3 0 279 1.40
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data20.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data21.dbf 83 0 1.69 6.98 2 0 274 0.69
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data22.dbf 77 0 2.34 7.34 3 0 270 1.56
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data23.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data24.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data25.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data26.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data27.dbf 59 0 4.24 2.31 75 0 2,532 0.02
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data28.dbf 16 0 4.38 1.25 30 0 228 0.04
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data29.dbf 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data3.dbf 5 0 4.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data30.dbf 8 0 3.75 1.25 8 0 13 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data31.dbf 29 0 3.79 1.48 15 0 1,189 0.14
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data32.dbf 116 0 2.07 5.53 9 0 281 1.53
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data33.dbf 6 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data34.dbf 7 0 4.29 1.43 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data35.dbf 9 0 5.56 2.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data36.dbf 12 0 4.17 2.25 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data37.dbf 8 0 5.00 1.75 3 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data38.dbf 6 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data39.dbf 93 0 1.83 6.58 8 0 272 0.48
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data4.dbf 6 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data40.dbf 6 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data41.dbf 58 0 1.38 7.16 1 0 246 0.57
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data42.dbf 58 0 1.72 7.16 1 0 247 1.26
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data43.dbf 98 0 2.14 6.71 3 0 271 0.41
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data44.dbf 98 0 2.45 6.58 6 0 270 0.81
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data45.dbf 91 0 1.98 6.86 1 0 272 1.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data46.dbf 87 0 2.07 7.14 3 0 261 0.84
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data47.dbf 96 0 1.98 6.57 13 0 264 0.91
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data48.dbf 86 0 2.67 7.24 1 0 273 0.84
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data49.dbf 102 0 1.57 6.25 6 0 269 0.71
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data5.dbf 6 0 5.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data50.dbf 91 0 2.97 6.75 1 0 274 1.13
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data51.dbf 228 0 4.96 3.29 195 0 929 0.39
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data52.dbf 75 0 1.87 7.24 2 0 262 1.26
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data53.dbf 654 0 3.76 1.02 842 0 6,317 0.30
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data54.dbf 558 0 3.67 1.01 795 0 6,311 0.56
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data55.dbf 529 0 4.33 1.00 817 0 5,811 0.36
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data56.dbf 559 0 3.70 1.00 702 0 6,542 0.30
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data57.dbf 553 0 3.60 1.00 711 0 6,725 0.28
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data58.dbf 554 0 3.95 1.00 766 0 6,564 0.36
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data59.dbf 540 0 3.48 1.00 689 0 5,786 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data6.dbf 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data60.dbf 535 0 4.32 1.01 640 0 6,245 0.32
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data61.dbf 537 0 3.33 1.03 663 0 6,246 0.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data62.dbf 545 0 3.52 1.03 733 0 5,976 0.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data63.dbf 511 0 4.50 1.02 674 0 6,324 0.24
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data64.dbf 539 0 3.53 1.02 652 0 6,388 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data65.dbf 511 0 4.11 1.00 602 0 6,198 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data66.dbf 500 0 4.12 1.00 603 0 6,457 0.36
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data67.dbf 485 0 3.51 1.00 603 0 7,007 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data68.dbf 488 0 3.48 1.00 652 0 7,170 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data69.dbf 481 0 3.72 1.00 574 0 7,994 0.40
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data7.dbf 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data70.dbf 486 0 3.40 1.00 582 0 6,722 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data71.dbf 475 0 4.08 1.00 596 0 6,951 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data72.dbf 497 0 3.94 1.00 589 0 6,539 0.23
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data73.dbf 503 0 3.94 1.00 651 0 6,913 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data74.dbf 485 0 4.08 1.00 591 0 6,335 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data75.dbf 499 0 3.39 1.00 645 0 6,658 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data76.dbf 504 0 4.01 1.00 606 0 7,459 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data77.dbf 500 0 4.04 1.00 695 0 6,778 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data78.dbf 514 0 4.01 1.00 659 0 7,028 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data8.dbf 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/apps_st/data/tx_data9.dbf 7 0 4.29 1.00 1 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx1.dbf 47 0 5.11 1.00 412 0 1,575 0.44
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx10.dbf 165 0 3.58 1.00 278 0 152 0.39
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx11.dbf 69 0 2.75 1.00 54 0 5 200.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx12.dbf 34 0 2.94 1.00 39 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx13.dbf 39 0 4.62 1.00 33 0 104 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx14.dbf 32 0 2.81 1.00 31 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx15.dbf 30 0 4.00 1.00 75 0 29 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx16.dbf 54 0 3.15 1.00 107 0 50 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx17.dbf 54 0 3.33 1.00 58 0 50 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx18.dbf 30 0 2.33 1.00 43 0 1 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx19.dbf 15 0 4.67 1.00 39 0 5 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx2.dbf 17 0 6.47 1.00 78 0 34 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx20.dbf 8 0 6.25 1.00 22 0 122 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx21.dbf 7 0 4.29 1.00 19 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx22.dbf 100 0 4.40 1.00 108 0 110 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx23.dbf 9 0 3.33 1.00 49 0 93 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx24.dbf 36 0 5.00 1.00 40 0 20 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx25.dbf 1,016 0 3.57 1.00 1,312 0 5,119 0.43
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx26.dbf 800 0 3.29 1.00 1,137 0 3,912 0.56
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx27.dbf 716 0 4.05 1.00 1,099 0 3,299 0.45
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx28.dbf 698 0 3.68 1.00 1,027 0 3,387 0.35
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx29.dbf 729 0 3.06 1.00 994 0 3,308 0.52
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx3.dbf 30 0 1.67 1.00 97 0 24 0.42
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx30.dbf 689 0 4.24 1.00 1,016 0 3,566 0.67
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx31.dbf 725 0 3.70 1.00 1,051 0 3,286 0.37
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx32.dbf 689 0 3.18 1.00 997 0 12,471 0.12
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx33.dbf 657 0 3.52 1.00 1,045 0 20,780 0.52
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx34.dbf 683 0 3.87 1.02 1,055 0 3,461 0.26
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx35.dbf 717 0 3.29 1.02 1,039 0 3,374 0.27
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx36.dbf 729 0 3.92 1.01 1,047 0 3,105 0.39
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx37.dbf 705 0 3.56 1.00 949 0 3,127 0.34
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx38.dbf 660 0 3.47 1.00 973 0 3,143 0.60
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx39.dbf 643 0 3.90 1.00 902 0 3,420 0.15
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx4.dbf 14 0 2.86 1.00 28 0 2 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx40.dbf 661 0 3.36 1.00 913 0 3,624 0.22
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx41.dbf 684 0 4.20 1.00 924 0 3,523 0.32
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx42.dbf 637 0 4.21 1.00 899 0 3,598 0.18
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx43.dbf 650 0 3.51 1.00 934 0 4,127 0.79
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx44.dbf 664 0 3.66 1.00 895 0 3,544 0.40
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx45.dbf 673 0 3.43 1.00 890 0 3,361 0.44
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx46.dbf 650 0 2.97 1.00 873 0 3,572 0.39
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx47.dbf 657 0 4.19 1.00 804 0 3,893 0.41
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx48.dbf 640 0 3.66 1.00 814 0 3,241 0.34
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx49.dbf 644 0 3.88 1.00 845 0 3,013 0.35
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx5.dbf 12 0 3.33 1.00 43 0 1,154 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx6.dbf 8 0 3.75 1.00 16 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx7.dbf 121 0 4.38 1.00 287 0 32 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx8.dbf 26 0 3.08 1.00 52 0 6 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/apps_st/data/tx_idx9.dbf 43 0 2.79 1.00 32 0 5 0.00
APPS_UNDOTS1 /ds1/oracle/VIS/db/apps_st/data/undo.dbf 1 0 0.00 1.00 78,614 29 546,392 0.30
B2B_DT /ds1/oracle/VIS/db/apps_st/data/b2b_dt.dbf 6 0 1.67 1.00 1 0 0 0.00
B2B_IDX /ds1/oracle/VIS/db/apps_st/data/b2b_idx.dbf 6 0 1.67 1.00 1 0 0 0.00
B2B_LOB /ds1/oracle/VIS/db/apps_st/data/b2b_lob.dbf 6 0 1.67 1.00 1 0 0 0.00
B2B_RT /ds1/oracle/VIS/db/apps_st/data/b2b_rt.dbf 6 0 1.67 1.00 1 0 0 0.00
BAM /ds1/oracle/VIS/db/apps_st/data/bam.dbf 6 0 1.67 1.00 1 0 0 0.00
CTXSYS /ds1/oracle/VIS/db/apps_st/data/ctx1.dbf 6 0 1.67 1.00 1 0 0 0.00
CTXSYS /ds1/oracle/VIS/db/apps_st/data/ctx2.dbf 3 0 0.00 1.00 1 0 0 0.00
CWMLITE /ds1/oracle/VIS/db/apps_st/data/cwmlite01.dbf 6 0 1.67 1.00 1 0 0 0.00
CWMLITE /ds1/oracle/VIS/db/apps_st/data/cwmlite02.dbf 6 0 1.67 1.00 1 0 0 0.00
DCM /ds1/oracle/VIS/db/apps_st/data/dcm.dbf 6 0 1.67 1.00 1 0 0 0.00
DCM /ds1/oracle/VIS/db/apps_st/data/dcm1.dbf 6 0 1.67 1.00 1 0 0 0.00
DISCO_PTM5_CACHE /ds1/oracle/VIS/db/apps_st/data/discopltc1.dbf 7 0 1.43 1.00 1 0 0 0.00
DISCO_PTM5_META /ds1/oracle/VIS/db/apps_st/data/discopltm1.dbf 7 0 1.43 1.00 1 0 0 0.00
DSGATEWAY_TAB /ds1/oracle/VIS/db/apps_st/data/oss_sys01.dbf 7 0 1.43 1.00 1 0 0 0.00
GEOR_TBS /ds1/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf 7 0 1.43 1.00 1 0 0 0.00
GEOR_TBS /ds1/oracle/VIS/db/apps_st/data/geor_tbs02.dbf 7 0 1.43 1.00 1 0 0 0.00
HTMLDB /ds1/oracle/VIS/db/apps_st/data/htmldb.dbf 7 0 1.43 1.00 1 0 0 0.00
IAS_META /ds1/oracle/VIS/db/apps_st/data/ias_meta01.dbf 6 0 1.67 1.00 1 0 0 0.00
MTR /ds1/oracle/VIS/db/apps_st/data/opmtr01.dbf 6 0 1.67 1.00 1 0 0 0.00
NOETIX /ds1/oracle/VIS/db/apps_st/data/noetix.dbf 6 0 1.67 1.00 1 0 0 0.00
NON_APPS_TS_DATA /ds1/oracle/VIS/db/apps_st/data/non_apps_data1.dbf 6 0 1.67 1.00 1 0 0 0.00
OCATS /ds1/oracle/VIS/db/apps_st/data/oca.dbf 6 0 1.67 1.00 1 0 0 0.00
ODM_DATA /ds1/oracle/VIS/db/apps_st/data/odm.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_ATTRSTORE /ds1/oracle/VIS/db/apps_st/data/attrs1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_BATTRSTORE /ds1/oracle/VIS/db/apps_st/data/battrs1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_CT_STORE /ds1/oracle/VIS/db/apps_st/data/gcats1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_DEFAULT /ds1/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OLTS_SVRMGSTORE /ds1/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf 6 0 1.67 1.00 1 0 0 0.00
OPMOR /ds1/oracle/VIS/db/apps_st/data/opmor01.dbf 6 0 1.67 1.00 1 0 0 0.00
ORABPEL /ds1/oracle/VIS/db/apps_st/data/orabpel.dbf 6 0 1.67 1.00 1 0 0 0.00
OWAPUB /ds1/oracle/VIS/db/apps_st/data/owa1.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL /ds1/oracle/VIS/db/apps_st/data/portal.dbf 7 0 1.43 1.00 1 0 0 0.00
PORTAL_DOC /ds1/oracle/VIS/db/apps_st/data/ptldoc.dbf 7 0 1.43 1.00 1 0 0 0.00
PORTAL_IDX /ds1/oracle/VIS/db/apps_st/data/ptlidx.dbf 7 0 1.43 1.00 1 0 0 0.00
PORTAL_LOG /ds1/oracle/VIS/db/apps_st/data/ptllog.dbf 7 0 1.43 1.00 1 0 0 0.00
RE /ds1/oracle/VIS/db/apps_st/data/opre01.dbf 7 0 1.43 1.00 1 0 0 0.00
SYNCSERVER /ds1/oracle/VIS/db/apps_st/data/mobile01.dbf 7 0 2.86 1.00 1 0 0 0.00
SYSAUX /ds1/oracle/VIS/db/apps_st/data/sysaux01.dbf 208 0 3.46 1.00 351 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys1.dbf 9 0 4.44 1.00 71 0 364 0.11
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys10.dbf 14 0 5.00 1.00 60 0 620 0.06
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys2.dbf 6 0 1.67 1.00 53 0 695 0.07
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys3.dbf 45 0 4.22 1.29 104 0 582 0.15
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys4.dbf 17 0 2.94 1.00 59 0 23 0.43
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys5.dbf 26 0 5.00 1.15 67 0 22 0.45
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys6.dbf 8 0 5.00 1.00 67 0 122 0.16
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys7.dbf 9 0 6.67 1.00 21 0 413 0.15
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys8.dbf 6 0 5.00 1.00 62 0 504 0.24
SYSTEM /ds1/oracle/VIS/db/apps_st/data/sys9.dbf 16 0 3.75 1.00 34 0 358 0.34
TEMP /ds1/oracle/VIS/db/apps_st/data/tempx01.dbf 41 0 0.73 7.10 31 0 0  
TEMP /ds1/oracle/VIS/db/apps_st/data/tempx02.dbf 0 0     9 0 0  
UDDISYS_TS /ds1/oracle/VIS/db/apps_st/data/uddisys01.dbf 6 0 1.67 1.00 1 0 0 0.00
WCRSYS_TS /ds1/oracle/VIS/db/apps_st/data/wcrsys01.dbf 6 0 1.67 1.00 1 0 0 0.00
XDB /ds1/oracle/VIS/db/apps_st/data/xdb01.dbf 6 0 1.67 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 1,013,248 100 1,375,008,811 56,847 1,476,951 0 0 973,878


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 180 37 7413 201554 6565166 92152620 6565166  
E 180 93 120504 3046923 15531184 92152620 15531184  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 816 0.10 100,929 1.42 767,485
D 1,632 0.20 201,858 1.22 660,615
D 2,448 0.30 302,787 1.11 603,122
D 3,264 0.40 403,716 1.09 588,235
D 4,080 0.50 504,645 1.07 580,192
D 4,896 0.60 605,574 1.06 573,454
D 5,712 0.70 706,503 1.04 563,042
D 6,528 0.80 807,432 1.03 555,843
D 7,344 0.90 908,361 1.01 545,847
D 8,160 1.00 1,009,290 1.00 541,631
D 8,192 1.00 1,013,248 1.00 541,355
D 8,976 1.10 1,110,219 0.99 537,126
D 9,792 1.20 1,211,148 0.97 527,726
D 10,608 1.29 1,312,077 0.97 525,497
D 11,424 1.39 1,413,006 0.97 525,205
D 12,240 1.49 1,513,935 0.97 525,200
D 13,056 1.59 1,614,864 0.97 525,200
D 13,872 1.69 1,715,793 0.97 525,196
D 14,688 1.79 1,816,722 0.97 525,196
D 15,504 1.89 1,917,651 0.97 525,192
D 16,320 1.99 2,018,580 0.97 522,967

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 64,936 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 2,048 1,745 215.58 0.00 0.00 0.00 0.00 209,710
E 2,048 1,729 223.13 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 1,821,301 1,821,301 0 0
64K 128K 1,479 1,479 0 0
128K 256K 110 110 0 0
256K 512K 775 775 0 0
512K 1024K 10,542 10,542 0 0
1M 2M 45,413 45,413 0 0
2M 4M 477 477 0 0
4M 8M 118 118 0 0
8M 16M 10 10 0 0
16M 32M 4 4 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
256 0.13 131,583.83 895.05 99.00 227
512 0.25 131,583.83 458.56 100.00 62
1,024 0.50 131,583.83 392.89 100.00 43
1,536 0.75 131,583.83 334.23 100.00 28
2,048 1.00 131,583.83 0.00 100.00 10
2,458 1.20 131,583.83 0.00 100.00 0
2,867 1.40 131,583.83 0.00 100.00 0
3,277 1.60 131,583.83 0.00 100.00 0
3,686 1.80 131,583.83 0.00 100.00 0
4,096 2.00 131,583.83 0.00 100.00 0
6,144 3.00 131,583.83 0.00 100.00 0
8,192 4.00 131,583.83 0.00 100.00 0
12,288 6.00 131,583.83 0.00 100.00 0
16,384 8.00 131,583.83 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
384 0.19 234 10,826 1,048,475 1.00 1,172 4.88 79,742,168
592 0.29 333 17,783 1,049,407 1.00 240 1.00 79,744,386
800 0.39 333 17,783 1,049,407 1.00 240 1.00 79,744,386
1,008 0.49 333 17,783 1,049,407 1.00 240 1.00 79,744,386
1,216 0.59 333 17,783 1,049,407 1.00 240 1.00 79,744,386
1,424 0.70 333 17,783 1,049,407 1.00 240 1.00 79,744,386
1,632 0.80 333 17,783 1,049,407 1.00 240 1.00 79,744,386
1,840 0.90 333 17,783 1,049,407 1.00 240 1.00 79,744,386
2,048 1.00 333 17,783 1,049,407 1.00 240 1.00 79,744,386
2,256 1.10 333 17,783 1,049,407 1.00 240 1.00 79,744,386
2,464 1.20 333 17,783 1,049,407 1.00 240 1.00 79,744,386
2,672 1.30 333 17,783 1,049,407 1.00 240 1.00 79,744,386
2,880 1.41 333 17,783 1,049,407 1.00 240 1.00 79,744,386
3,088 1.51 333 17,783 1,049,407 1.00 240 1.00 79,744,386
3,296 1.61 333 17,783 1,049,407 1.00 240 1.00 79,744,386
3,504 1.71 333 17,783 1,049,407 1.00 240 1.00 79,744,386
3,712 1.81 333 17,783 1,049,407 1.00 240 1.00 79,744,386
3,920 1.91 333 17,783 1,049,407 1.00 240 1.00 79,744,386
4,128 2.02 333 17,783 1,049,407 1.00 240 1.00 79,744,386

Back to Advisory Statistics
Back to Top

 

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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

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 403,876 166 0
undo block 513,617 144 0
undo header 32,783 19 1
1st level bmb 14,581 4 0
segment header 8,538 1 0
2nd level bmb 346 0 0
extent map 22 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) 352,657 13,615 339,042 13,506 150 11.08
TX-Transaction (index contention) 15,602 15,602 0 14,716 37 2.51
TX-Transaction 888,345 888,536 0 6,053 15 2.41
HW-Segment High Water Mark 81,393 81,391 2 4,959 12 2.35
FB-Format Block 21,420 21,420 0 1,164 2 1.84
SQ-Sequence Cache 29,051 29,051 0 2,300 1 0.27
RO-Multiple Object Reuse (fast object reuse) 324 324 0 36 0 3.86
TX-Transaction (allocate ITL entry) 108 108 0 88 0 0.17
PS-PX Process Reservation 204 172 32 5 0 0.20

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,078.31 880,704 282 22 6.28333333333333333333333333333333333333/13.7 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
19-Mar 10:36 152,121 62,720 0 12 9 0/0 0/0/0/0/0/0
19-Mar 10:26 345,322 268,610 274 22 6 0/0 0/0/0/0/0/0
19-Mar 10:16 156,966 248,377 0 14 9 0/0 0/0/0/0/0/0
19-Mar 10:06 350,046 275,808 0 16 6 0/0 0/0/0/0/0/0
19-Mar 09:56 73,850 25,189 282 17 14 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 3,759 0.00   0 0  
AWR Alerted Metric Element list 19,065 0.00   0 0  
Consistent RBA 405,861 0.01 0.00 0 0  
FOB s.o list latch 12,142 0.05 0.00 0 0  
In memory undo latch 640,638,847 0.80 0.00 9 668,056 0.03
JOX SGA heap latch 1,723,762 0.00   0 0  
JS queue state obj latch 16,110 0.00   0 0  
JS slv state obj latch 21 0.00   0 0  
KMG MMAN ready and startup request latch 894 0.00   0 0  
KTF sga latch 8 0.00   0 874 0.00
KWQMN job cache list latch 206,667 0.08 0.13 0 0  
KWQP Prop Status 336 0.00   0 0  
MQL Tracking Latch 0     0 54 0.00
Memory Management Latch 0     0 894 0.00
OS process 1,326 0.00   0 0  
OS process allocation 1,775 0.11 0.00 0 0  
OS process: request allocation 821 0.12 0.00 0 0  
PL/SQL warning settings 1,284,614 0.00   0 0  
SGA IO buffer pool latch 3,886 0.00   0 3,961 0.00
SQL memory manager latch 1 0.00   0 894 0.00
SQL memory manager workarea list latch 472,171 0.00 0.00 0 0  
Shared B-Tree 1,743 0.00   0 0  
active checkpoint queue latch 171,877 0.00   0 0  
active service list 6,845 0.57 0.00 0 946 0.00
begin backup scn array 22 0.00   0 0  
bq:time manger info latch 96 0.00   0 0  
bufq statistics 2 0.00   0 0  
cache buffer handles 4,550,016 0.58 0.00 0 0  
cache buffers chains 3,456,345,171 3.20 0.00 62 13,093,372 3.91
cache buffers lru chain 5,247,674 0.42 0.01 2 34,544,390 0.57
cache table scan latch 0     0 1,908 0.00
channel handle pool latch 10,105 0.01 0.00 0 0  
channel operations parent latch 58,456 0.46 0.00 0 0  
checkpoint queue latch 4,780,480 0.01 0.01 0 1,587,868 0.02
client/application info 3,858 0.00   0 0  
commit callback allocation 222,302 0.06 0.01 0 0  
compile environment latch 40,510 0.00   0 0  
dictionary lookup 53 0.00   0 0  
dml lock allocation 4,971,241 1.51 0.00 1 0  
dummy allocation 919 1.96 0.00 0 0  
enqueue hash chains 7,907,391 0.54 0.00 2 286 0.00
enqueues 1,436,120 0.31 0.00 0 0  
error message lists 85 7.06 0.00 0 0  
event group latch 409 0.24 0.00 0 0  
file cache latch 23,815 0.01 0.00 0 0  
global KZLD latch for mem in SGA 393 0.00   0 0  
global ctx hash table latch 270,819 0.00   0 0  
hash table column usage latch 761 0.00   0 137,707 0.00
hash table modification latch 125 0.00   0 0  
job workq parent latch 0     0 14 0.00
job_queue_processes parameter latch 50 0.00   0 0  
kks stats 3,158 0.00   0 0  
ksuosstats global area 181 0.00   0 0  
ktm global data 2,785 0.00   0 0  
kwqbsn:qsga 1,644 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 407,578 0.52 0.00 0 0  
library cache 90,020,399 0.89 0.00 48 223 0.00
library cache load lock 142 0.00   0 0  
library cache lock 13,493,972 0.26 0.01 5 0  
library cache lock allocation 42,504 0.00 0.00 0 0  
library cache pin 57,180,566 0.55 0.00 18 0  
library cache pin allocation 20,933 0.01 0.00 0 0  
list of block allocation 294,050 0.06 0.00 0 0  
loader state object freelist 6,010 0.05 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 3 0.00   0 3 0.00
message pool operations parent latch 9,890 0.11 0.00 0 0  
messages 1,674,937 0.12 0.00 0 0  
mostly latch-free SCN 435,409 6.12 0.00 0 0  
multiblock read objects 4,318 0.00   0 0  
ncodef allocation latch 45 0.00   0 0  
object queue header heap 697,136 0.00 0.00 0 10,220 0.03
object queue header operation 10,193,793 0.05 0.01 0 0  
object stats modification 9,755 0.02 0.00 0 0  
parallel query alloc buffer 1,140 2.11 0.00 0 0  
parallel query stats 55 32.73 0.00 0 0  
parameter list 1,317 0.00   0 0  
parameter table allocation management 466 4.72 0.05 0 0  
post/wait queue 341,567 0.19 0.00 0 134,734 0.43
process allocation 826 0.24 0.00 0 407 0.49
process group creation 821 0.12 0.00 0 0  
process queue 526 1.33 0.00 0 0  
process queue reference 90,687 0.07 0.00 0 9,663 569.15
qmn task queue latch 2,611 0.00   0 0  
query server freelists 451 12.86 0.00 0 0  
query server process 8 0.00   0 12 0.00
redo allocation 3,003,280 2.81 0.02 8 68,676,388 1.66
redo copy 0     0 68,776,491 0.03
redo writing 1,742,951 0.01 0.08 0 0  
resmgr group change latch 2,586 0.00   0 0  
resmgr:actses active list 1,325 0.15 0.00 0 0  
resmgr:actses change group 1,251 0.00   0 0  
resmgr:free threads list 919 2.50 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 29,820,994 0.63 0.00 8 1 0.00
rules engine aggregate statistics 105,003 0.36 0.01 0 0  
rules engine rule set statistics 420,098 0.20 0.00 0 0  
rules engine rule statistics 209,991 0.00   0 0  
sequence cache 5,804,293 0.23 0.00 0 0  
session allocation 6,569,385 0.91 0.00 2 0  
session idle bit 382,470 0.00 0.00 0 0  
session state list latch 2,498 0.68 0.00 0 0  
session switching 45 0.00   0 0  
session timer 946 0.00   0 0  
shared pool 12,441,234 0.70 0.01 6 0  
shared pool sim alloc 25 0.00   0 0  
shared pool simulator 1,471,308 0.00 0.00 0 0  
sim partition latch 1 0.00   0 14,118 0.02
simulator hash latch 79,700,020 0.01 0.00 0 0  
simulator lru latch 79,571,036 3.67 0.00 17 49,414 0.13
sort extent pool 32,084 0.14 0.00 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temporary table state object allocation 413 0.48 0.00 0 0  
threshold alerts latch 601 0.00   0 0  
transaction allocation 25,568 0.00   0 0  
transaction branch allocation 45 0.00   0 0  
undo global data 749,025,503 3.28 0.00 7 1,505 0.20
user lock 1,584 0.06 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,456,345,171 110,580,036 75,464 110,516,084 0 0 0
undo global data 749,025,503 24,571,744 1,655 24,570,294 0 0 0
In memory undo latch 640,638,847 5,141,210 2,222 5,139,212 0 0 0
simulator lru latch 79,571,036 2,923,407 1,461 2,922,102 0 0 0
library cache 90,020,399 800,726 2,764 798,310 0 0 0
library cache pin 57,180,566 313,716 1,021 312,817 0 0 0
row cache objects 29,820,994 188,058 621 187,516 0 0 0
shared pool 12,441,234 87,500 546 87,013 0 0 0
redo allocation 3,003,280 84,374 1,314 83,187 0 0 0
dml lock allocation 4,971,241 75,034 144 74,910 0 0 0
session allocation 6,569,385 59,855 224 59,662 0 0 0
enqueue hash chains 7,907,391 42,572 155 42,429 0 0 0
library cache lock 13,493,972 35,443 215 35,247 0 0 0
cache buffer handles 4,550,016 26,533 4 26,530 0 0 0
cache buffers lru chain 5,247,674 21,896 261 21,671 0 0 0
sequence cache 5,804,293 13,487 12 13,476 0 0 0
simulator hash latch 79,700,020 7,047 14 7,034 0 0 0
object queue header operation 10,193,793 5,047 50 5,004 0 0 0
enqueues 1,436,120 4,434 21 4,416 0 0 0
messages 1,674,937 1,993 2 1,991 0 0 0
rules engine rule set statistics 420,098 840 3 837 0 0 0
checkpoint queue latch 4,780,480 466 6 460 0 0 0
rules engine aggregate statistics 105,003 381 3 378 0 0 0
channel operations parent latch 58,456 270 1 269 0 0 0
redo writing 1,742,951 228 19 209 0 0 0
KWQMN job cache list latch 206,667 158 20 140 0 0 0
commit callback allocation 222,302 136 2 134 0 0 0
parameter table allocation management 466 22 1 21 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 1,221 1,204
In memory undo latch ktiFlush: child 0 832 361
In memory undo latch ktichg: child 0 84 584
In memory undo latch ktiTxnPoolFree 0 41 0
In memory undo latch kticmt: child 0 33 0
In memory undo latch ktbgfc 0 6 69
In memory undo latch ktiBRacquire 0 2 0
KWQMN job cache list latch kwqmnuji: update job item 0 20 19
cache buffer handles kcbzgs 0 4 4
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 460,368 383,684
cache buffers chains kcbgtcr: kslbegin excl 0 262,751 211,618
cache buffers chains kcbgtcr: fast path 0 40,537 14,751
cache buffers chains kcbgcur: kslbegin 0 22,550 3,782
cache buffers chains kcbchg: kslbegin: call CR func 0 21,495 190,817
cache buffers chains kcbget: pin buffer 0 7,749 1,132
cache buffers chains kcbrls: kslbegin 0 5,984 15,501
cache buffers chains kcbzwb 0 5,846 2,036
cache buffers chains kcbzgb: scan from tail. nowait 0 598 0
cache buffers chains kcbcge 0 286 3,542
cache buffers chains kcbget: exchange rls 0 215 33
cache buffers chains kcbget: exchange 0 203 46
cache buffers chains kcbnlc 0 140 395
cache buffers chains kcbgtcr: kslbegin shared 0 48 40
cache buffers chains kcb_is_private 0 33 3,171
cache buffers chains kcbnew: new latch again 0 7 1
cache buffers chains kcb_pre_apply: kcbhq61 0 4 225
cache buffers chains kcbbic1 0 3 1
cache buffers chains kcbesc: escalate 0 3 0
cache buffers chains kcb_post_apply: kcbhq62 0 1 19
cache buffers chains kcbso1: set no access 0 1 5
cache buffers lru chain kcbzgws 0 154 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 74 0
cache buffers lru chain kcbzswcu 0 23 5
cache buffers lru chain kcbzgb: posted for free bufs 0 9 201
cache buffers lru chain kcbbxsv: move to being written 0 1 13
channel operations parent latch ksrmfree() 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
checkpoint queue latch kcbswcu: Switch buffers 0 2 3
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 2
checkpoint queue latch kcbkubc 0 1 2
commit callback allocation ktccaco 0 2 0
dml lock allocation ktaiam 0 89 107
dml lock allocation ktaidm 0 55 37
enqueue hash chains ksqrcl 0 87 52
enqueue hash chains ksqgtl3 0 66 98
enqueue hash chains ksqcmi: get hash chain latch after wait 0 2 5
enqueues ksqgel: create enqueue 0 16 16
enqueues ksqdel 0 5 7
library cache kglpndl: child: after processing 0 1,164 11
library cache kglpnp: child 0 1,138 1,770
library cache kglpndl: child: before processing 0 176 468
library cache kglobpn: child: 0 171 388
library cache kglLockCursor 0 39 52
library cache kglScanDependency 0 34 0
library cache kglget: unpin heap 0 0 7 16
library cache kglhdgn: child: 0 7 54
library cache kglpin 0 6 2
library cache lock kgllkdl: child: cleanup 0 143 102
library cache lock kgllkal: child: multiinstance 0 72 113
library cache lock kgllkdl: child: no lock handle 0 22 0
library cache pin kglpndl 0 488 224
library cache pin kglpnp: child 0 474 660
library cache pin kglpnal: child: alloc space 0 59 137
messages ksaamb: after wakeup 0 2 0
object queue header operation kcbw_link_q 0 17 5
object queue header operation kcbw_unlink_q 0 15 6
object queue header operation kcbo_ivbo 0 13 0
object queue header operation kcbo_switch_cq 0 13 34
object queue header operation kcbo_swap_buf_bg 0 2 2
parameter table allocation management ksp_param_table_free 0 1 1
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,087 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 126 873
redo allocation kcrfw_redo_write: before write 0 52 89
redo allocation kcrfw_redo_write: more space 0 28 352
redo allocation kcrfw_redo_gen: redo allocation 2 0 21 0
redo writing kcrfw_post: rba scn pair 0 12 0
redo writing kcrfw_cal_target_rba 0 6 0
redo writing kcrfwcr 0 1 27
row cache objects kqreqd: reget 0 516 0
row cache objects kqrpre: find obj 0 89 616
row cache objects kqreqd 0 16 5
rules engine aggregate statistics kwrsagu: update global statistics 0 3 3
rules engine rule set statistics kwrsosb: begin collect rs stats 0 3 6
rules engine rule set statistics kwrsose: end collect rs stats 0 1 0
sequence cache kdnssd 0 11 0
sequence cache kdnnxt: cached seq 0 1 0
session allocation ksudlc 0 117 39
session allocation ksuprc 0 83 167
session allocation ksuxds: KSUSFCLC not set 0 11 12
session allocation ksucri 0 4 4
session allocation ksursi 0 4 0
session allocation ksuxds: not user session 0 3 0
session allocation ksucrp 0 1 0
session allocation kxfprdp 0 1 0
shared pool kghalo 0 308 440
shared pool kghfre 0 164 51
shared pool kghupr1 0 74 55
simulator hash latch kcbsacc: lookup dba 0 14 13
simulator lru latch kcbs_simulate: simulate set 0 1,436 1,375
simulator lru latch kcbs_simbufseq 0 19 80
undo global data kturimugur: child 0 1,273 575
undo global data ktudba: KSLBEGIN 0 367 1,058
undo global data ktudnx:child 0 10 5
undo global data ktubnd:child 0 4 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 74,864,784 5.43
AR APPS_TS_TX_IDX RA_INTERFACE_LINES_C01   INDEX 44,932,000 3.26
APPLSYS APPS_TS_SEED WF_ACTIVITIES_PK   INDEX 43,694,848 3.17
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 42,928,048 3.12
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 30,171,424 2.19

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 14,761 25.47
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 10,539 18.19
AR APPS_TS_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 6,214 10.72
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 1,872 3.23
ASO APPS_TS_QUEUES SYS_IOT_TOP_114472   INDEX 441 0.76

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 923,220 42.82
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 677,824 31.44
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_153630   INDEX 515,263 23.90
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 25,670 1.19
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 6,861 0.32

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_N4   INDEX 4 30.77
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N3   INDEX 2 15.38
XLA APPS_TS_TX_IDX XLA_EVENTS_N2 AR INDEX PARTITION 2 15.38
AR APPS_TS_TX_IDX AR_PAYMENT_SCHEDULES_N10   INDEX 1 7.69
ONT APPS_TS_TX_IDX OE_ORDER_LINES_U1   INDEX 1 7.69

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
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 47,182 12.09
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 46,716 11.97
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 38,149 9.77
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 33,216 8.51
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 32,364 8.29

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 49 0.00 0   2 2
dc_constraints 192 50.00 0   192 97
dc_global_oids 1,201,214 0.00 0   4 95
dc_histogram_data 765 0.00 0   0 2,061
dc_histogram_defs 25,314 3.83 0   491 18,447
dc_object_grants 146 0.00 0   0 480
dc_object_ids 3,283,536 0.00 0   27 4,609
dc_objects 204,490 0.04 0   232 5,618
dc_profiles 400 0.00 0   0 1
dc_rollback_segments 21,555 0.00 0   0 509
dc_segments 36,336 0.05 0   21,043 5,233
dc_sequences 41,756 0.00 0   41,756 73
dc_table_scns 199,366 0.00 0   0 15
dc_tablespace_quotas 22,165 0.00 0   0 37
dc_tablespaces 352,840 0.00 0   0 57
dc_usernames 483,229 0.00 0   0 79
dc_users 4,259,098 0.00 0   0 239
outstanding_alerts 275 0.36 0   2 54


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 16,087 0.00 10,088,616 -0.00 0 0
INDEX 164 14.63 325 11.08 0 0
JAVA DATA 108 0.00 0   0 0
PIPE 804 0.00 804 0.00 0 0
SQL AREA 272 93.75 49,503,609 0.03 332 370
TABLE/PROCEDURE 16,935 0.25 15,009,471 -0.01 12 0
TRIGGER 521 0.00 788,170 -0.00 0 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 143.16   1.99 2.72 22 35 72 72
  Freeable 54.00 0.00 1.54 3.34 14   35 35
  SQL 14.39 7.63 0.21 0.63 5 5 67 61
  PL/SQL 4.08 1.69 0.06 0.04 0 0 72 68
E Other 155.85   2.26 4.09 28 35 69 69
  Freeable 48.50 0.00 1.35 3.03 14   36 36
  SQL 14.62 7.78 0.23 0.65 5 5 64 63
  PL/SQL 4.20 1.70 0.06 0.04 0 0 69 69

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 147.47 147.47 0.00
java joxlod exec hp 11.87 11.87 0.00
shared CCursor 24.59 26.56 7.98
shared KGLS heap 33.72 33.72 0.00
shared PL/SQL MPCODE 42.04 42.04 0.00
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 1,531.06 1,517.48 -0.89
shared ktcmvcb 23.45 46.55 98.51
shared library cache 32.02 32.67 2.03
shared sql area 171.36 180.95 5.60
streams free memory 47.99 47.99 0.00
  buffer_cache 8,192.00 8,192.00 0.00
  fixed_sga 1.99 1.99 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 11,170,738 12,830 0
QMON Coordinator 30,206 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

No data exists for this section of the report.

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,992 0 104,995 403 1,087
SYS.ALERT_QUE_R 2 0 0 0 0
APPLSYS.FND_CP_GSM_OPP_AQ_R 1 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report