WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 210556022 VIS 1 10.2.0.3.0 NO vega7242.cup.hp.com

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 79 25-Aug-08 13:58:55 86 31.7
End Snap: 80 25-Aug-08 14:41:05 86 29.9
Elapsed:   42.17 (mins)    
DB Time:   244.79 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 23,472M 23,456M Std Block Size: 8K
Shared Pool Size: 1,024M 1,024M Log Buffer: 14,312K

Load Profile

  Per Second Per Transaction
Redo size: 8,048,031.45 32,682.79
Logical reads: 492,191.30 1,998.77
Block changes: 49,192.06 199.77
Physical reads: 28.19 0.11
Physical writes: 886.51 3.60
User calls: 75.23 0.31
Parses: 815.55 3.31
Hard parses: 1.32 0.01
Sorts: 1,639.23 6.66
Logons: 0.34 0.00
Executes: 18,145.60 73.69
Transactions: 246.25  

% Blocks changed per Read: 9.99 Recursive Call %: 99.77
Rollback per transaction %: 0.13 Rows per Sort: 3.12

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 100.00
Buffer Hit %: 99.99 In-memory Sort %: 100.00
Library Hit %: 99.78 Soft Parse %: 99.84
Execute to Parse %: 95.51 Latch Hit %: 98.04
Parse CPU to Parse Elapsd %: 53.80 % Non-Parse CPU: 99.75

Shared Pool Statistics

  Begin End
Memory Usage %: 38.02 62.35
% SQL with executions>1: 85.86 83.03
% Memory for SQL w/exec>1: 83.81 86.61

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   13,232   90.1  
log file sync 167,967 745 4 5.1 Commit
log file parallel write 215,806 568 3 3.9 System I/O
buffer busy waits 1,057,405 177 0 1.2 Concurrency
db file sequential read 20,815 79 4 .5 User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 14,651.68 99.76
DB CPU 13,232.49 90.09
PL/SQL execution elapsed time 2,668.91 18.17
Java execution elapsed time 538.49 3.67
parse time elapsed 101.63 0.69
hard parse elapsed time 37.54 0.26
sequence load elapsed time 11.84 0.08
repeated bind elapsed time 8.44 0.06
PL/SQL compilation elapsed time 3.53 0.02
connection management call elapsed time 1.94 0.01
hard parse (sharing criteria) elapsed time 0.49 0.00
hard parse (bind mismatch) elapsed time 0.13 0.00
inbound PL/SQL rpc elapsed time 0.03 0.00
failed parse elapsed time 0.01 0.00
DB time 14,687.66  
background elapsed time 1,266.70  
background cpu time 130.19  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Commit 167,967 0.00 745 4 0.27
System I/O 219,311 0.00 575 3 0.35
Concurrency 2,618,903 0.08 370 0 4.20
User I/O 34,331 0.00 132 4 0.06
Other 96,560 44.87 59 1 0.15
Application 9,698 0.00 58 6 0.02
Configuration 12,679 0.00 5 0 0.02
Network 319,132 0.00 3 0 0.51

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file sync 167,967 0.00 745 4 0.27
log file parallel write 215,806 0.00 568 3 0.35
buffer busy waits 1,057,405 0.00 177 0 1.70
db file sequential read 20,815 0.00 79 4 0.03
library cache load lock 3,307 0.00 71 21 0.01
latch: cache buffers chains 1,515,007 0.00 66 0 2.43
enq: TX - row lock contention 9,180 0.00 57 6 0.01
db file scattered read 5,885 0.00 29 5 0.01
cursor: pin S wait on X 2,430 90.00 24 10 0.00
read by other session 5,961 0.00 24 4 0.01
buffer deadlock 43,456 99.37 23 1 0.07
enq: TX - index contention 16,930 0.00 14 1 0.03
latch: In memory undo latch 18,561 0.00 9 0 0.03
LGWR wait for redo copy 11,861 0.07 7 1 0.02
control file parallel write 1,237 0.00 7 5 0.00
enq: TX - contention 8,742 0.00 6 1 0.01
os thread startup 49 2.04 5 109 0.00
kksfbc child completion 126 82.54 5 41 0.00
rdbms ipc reply 205 0.49 4 20 0.00
latch free 4,788 0.00 4 1 0.01
enq: HW - contention 5,971 0.00 4 1 0.01
SQL*Net more data to client 152,819 0.00 3 0 0.25
wait list latch free 198 0.00 2 11 0.00
latch: undo global data 7,478 0.00 2 0 0.01
latch: library cache 1,485 0.00 2 1 0.00
latch: cache buffers lru chain 323 0.00 2 5 0.00
enq: SQ - contention 6,636 0.00 1 0 0.01
SQL*Net break/reset to client 512 0.00 1 2 0.00
latch: redo allocation 1,220 0.00 1 1 0.00
enq: FB - contention 1,837 0.00 1 0 0.00
row cache lock 2,155 0.00 1 0 0.00
latch: library cache pin 528 0.00 1 1 0.00
PX Deq Credit: send blkd 1,948 0.00 1 0 0.00
latch: shared pool 289 0.00 0 2 0.00
cursor: pin S 13,858 0.00 0 0 0.02
latch: row cache objects 377 0.00 0 1 0.00
latch: enqueue hash chains 122 0.00 0 2 0.00
enq: RO - fast object reuse 6 0.00 0 39 0.00
latch: redo writing 52 0.00 0 4 0.00
latch: object queue header operation 81 0.00 0 2 0.00
SQL*Net message to client 159,003 0.00 0 0 0.26
SQL*Net more data from client 7,310 0.00 0 0 0.01
latch: session allocation 158 0.00 0 1 0.00
PX Deq: Signal ACK 15 20.00 0 7 0.00
control file sequential read 2,268 0.00 0 0 0.00
latch: checkpoint queue latch 26 0.00 0 3 0.00
latch: cache buffer handles 46 0.00 0 1 0.00
latch: library cache lock 54 0.00 0 1 0.00
cursor: mutex S 213 0.00 0 0 0.00
local write wait 11 0.00 0 2 0.00
SGA: allocation forcing component growth 2 50.00 0 11 0.00
latch: messages 16 0.00 0 1 0.00
PX qref latch 45 48.89 0 0 0.00
cursor: mutex X 107 0.00 0 0 0.00
direct path read 1,122 0.00 0 0 0.00
library cache pin 6 0.00 0 0 0.00
enq: TX - allocate ITL entry 20 0.00 0 0 0.00
direct path write 527 0.00 0 0 0.00
reliable message 6 0.00 0 0 0.00
enq: PS - contention 1 0.00 0 0 0.00
direct path write temp 7 0.00 0 0 0.00
direct path read temp 3 0.00 0 0 0.00
L1 validation 2 0.00 0 0 0.00
SQL*Net message from client 158,997 0.00 97,003 610 0.26
Streams AQ: waiting for messages in the queue 1,344 98.29 9,924 7384 0.00
pipe get 1,772 99.32 7,412 4183 0.00
Streams AQ: waiting for time management or cleanup tasks 115 32.17 2,796 24317 0.00
PL/SQL lock timer 210 98.57 2,649 12612 0.00
Streams AQ: qmn coordinator idle wait 1,100 34.09 2,465 2241 0.00
Streams AQ: qmn slave idle wait 725 0.00 2,465 3400 0.00
PX Idle Wait 1,233 97.32 2,359 1914 0.00
jobq slave wait 468 96.79 1,365 2917 0.00
PX Deq: Execution Msg 421 0.00 3 8 0.00
PX Deq: Execute Reply 183 0.00 1 3 0.00
PX Deq Credit: need buffer 685 0.00 0 0 0.00
PX Deq: Msg Fragment 328 0.00 0 0 0.00
PX Deq: Table Q Normal 1,201 0.00 0 0 0.00
PX Deq: Parse Reply 19 0.00 0 1 0.00
PX Deq: Join ACK 24 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 215,806 0.00 568 3 0.35
events in waitclass Other 13,029 0.06 11 1 0.02
control file parallel write 1,237 0.00 7 5 0.00
os thread startup 41 2.44 5 124 0.00
db file sequential read 122 0.00 0 3 0.00
latch: redo writing 52 0.00 0 4 0.00
latch: cache buffers chains 72 0.00 0 2 0.00
db file scattered read 2 0.00 0 47 0.00
control file sequential read 610 0.00 0 0 0.00
latch: In memory undo latch 10 0.00 0 2 0.00
latch: library cache 2 0.00 0 2 0.00
direct path read 1,110 0.00 0 0 0.00
buffer busy waits 34 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 1 0.00
direct path write 518 0.00 0 0 0.00
enq: TX - index contention 1 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 344,843 2.09 20,291 59 0.55
Streams AQ: waiting for time management or cleanup tasks 115 32.17 2,796 24317 0.00
smon timer 3,989 0.05 2,492 625 0.01
pmon timer 931 99.25 2,471 2654 0.00
Streams AQ: qmn coordinator idle wait 1,100 34.09 2,465 2241 0.00
Streams AQ: qmn slave idle wait 725 0.00 2,465 3400 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 1,352,379
IDLE_TIME 672,484
IOWAIT_TIME 18,147
NICE_TIME 0
SYS_TIME 29,486
USER_TIME 1,320,643
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 41,564
NUM_CPUS 8
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
VIS 14,665.60 13,221.60 62,885 1,238,748,928
SYS$USERS 22.10 10.90 2,880 3,944,390
SYS$BACKGROUND 0.00 0.00 5,575 2,626,062

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
VIS 30066 11556 2618738 36470 0 0 316828 323
SYS$USERS 981 398 3 0 0 0 82 0
SYS$BACKGROUND 3284 1221 162 528 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
5,647 4,872 8 705.88 38.45 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
4,012 3,920 16 250.75 27.32 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
3,782 3,628 49,930 0.08 25.75 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
2,356 2,281 49,562 0.05 16.04 4h6x64v79na0t FNDWFBG SELECT COUNT(1) FROM RA_CUSTOM...
1,222 1,124 251 4.87 8.32 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,130 1,081 10 113.00 7.69 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
940 757 26 36.14 6.40 d1swc9auhtxwd FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
651 612 49,253 0.01 4.43 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
610 482 10 61.02 4.15 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
547 538 49,990 0.01 3.72 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
504 469 149,673 0.00 3.43 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
296 284 49,726 0.01 2.01 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
229 207 2,812,577 0.00 1.56 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
228 213 48,541 0.00 1.55 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
222 200 1,689,295 0.00 1.51 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
220 214 202,765 0.00 1.50 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
194 189 98,120 0.00 1.32 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
168 163 354,599 0.00 1.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
156 145 1,343,455 0.00 1.06 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
152 143 249,243 0.00 1.04 ggak0dvtsppv3 WSHINTERFACES SELECT /*+ leading(wias) index...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
4,872 5,647 8 608.97 38.45 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
3,920 4,012 16 244.97 27.32 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
3,628 3,782 49,930 0.07 25.75 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
2,281 2,356 49,562 0.05 16.04 4h6x64v79na0t FNDWFBG SELECT COUNT(1) FROM RA_CUSTOM...
1,124 1,222 251 4.48 8.32 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,081 1,130 10 108.07 7.69 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
757 940 26 29.12 6.40 d1swc9auhtxwd FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
612 651 49,253 0.01 4.43 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
538 547 49,990 0.01 3.72 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
482 610 10 48.15 4.15 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
469 504 149,673 0.00 3.43 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
284 296 49,726 0.01 2.01 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
214 220 202,765 0.00 1.50 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
213 228 48,541 0.00 1.55 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
207 229 2,812,577 0.00 1.56 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
200 222 1,689,295 0.00 1.51 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
189 194 98,120 0.00 1.32 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
163 168 354,599 0.00 1.14 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
145 156 1,343,455 0.00 1.06 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
143 152 249,243 0.00 1.04 ggak0dvtsppv3 WSHINTERFACES SELECT /*+ leading(wias) index...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
532,371,753 16 33,273,234.56 42.75 3919.58 4011.95 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
224,536,727 8 28,067,090.88 18.03 4871.76 5647.07 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
179,668,703 10 17,966,870.30 14.43 1080.66 1129.98 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
104,270,587 49,930 2,088.34 8.37 3627.79 3782.08 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
75,586,025 149,673 505.01 6.07 469.29 503.50 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
71,568,685 49,990 1,431.66 5.75 537.93 547.11 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
68,842,018 251 274,270.99 5.53 1124.35 1221.81 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
61,070,332 354,599 172.22 4.90 163.36 168.13 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
59,262,797 49,562 1,195.73 4.76 2281.29 2356.25 4h6x64v79na0t FNDWFBG SELECT COUNT(1) FROM RA_CUSTOM...
54,570,440 2,812,577 19.40 4.38 206.81 228.84 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
40,136,776 10 4,013,677.60 3.22 481.52 610.21 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
37,057,367 1,689,295 21.94 2.98 200.14 221.67 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
32,542,892 26 1,251,649.69 2.61 757.05 939.74 d1swc9auhtxwd FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
25,198,629 309,529 81.41 2.02 94.42 96.07 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
23,769,731 98,120 242.25 1.91 189.48 193.85 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
22,955,229 1,343,455 17.09 1.84 145.02 155.77 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
21,124,339 10 2,112,433.90 1.70 126.44 132.11 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
20,732,034 49,253 420.93 1.66 612.25 650.93 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
19,999,956 148,917 134.30 1.61 71.85 74.72 6z9c18cxpxfq0 WSHPSGL_SUB SELECT NVL(COMMS_NL_TRACKABLE_...
19,598,284 54,998 356.35 1.57 94.61 109.86 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
17,083,224 3 5,694,408.00 1.37 133.41 138.60 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
13,464,518 1 13,464,518.00 1.08 91.80 98.10 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
13,023,413 49,998 260.48 1.05 61.60 62.60 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
12,607,278 2 6,303,639.00 1.01 97.52 100.02 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
16,518 1 16,518.00 23.16 91.80 98.10 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
10,795 16 674.69 15.13 3919.58 4011.95 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
7,558 3 2,519.33 10.60 133.41 138.60 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
5,972 10 597.20 8.37 1080.66 1129.98 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
2,234 8 279.25 3.13 4871.76 5647.07 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
2,003 10 200.30 2.81 481.52 610.21 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,891 49,930 0.04 2.65 3627.79 3782.08 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
1,769 251 7.05 2.48 1124.35 1221.81 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,516 98,120 0.02 2.13 189.48 193.85 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
1,294 49,562 0.03 1.81 2281.29 2356.25 4h6x64v79na0t FNDWFBG SELECT COUNT(1) FROM RA_CUSTOM...
1,254 2 627.00 1.76 97.52 100.02 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...
1,049 98,915 0.01 1.47 23.01 30.62 7h2mgwhpy4qym WSHPSGL_SUB INSERT INTO MTL_ONHAND_QUANTI...
1,022 99,938 0.01 1.43 8.04 9.53 39wym7tugc2sk WSHPSGL_SUB SELECT PRIMARY_UOM_CODE, ...
1,016 99,990 0.01 1.42 6.03 7.82 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
2,812,577 1,527,994 0.54 0.00 0.00 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
1,689,295 1,689,294 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
1,343,455 1,343,349 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
397,768 399,207 1.00 0.00 0.00 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A...
354,599 0 0.00 0.00 0.00 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
309,529 309,790 1.00 0.00 0.00 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
249,243 249,723 1.00 0.00 0.00 ggak0dvtsppv3 WSHINTERFACES SELECT /*+ leading(wias) index...
202,765 202,362 1.00 0.00 0.00 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
202,714 1,228,630 6.06 0.00 0.00 8upd356sbxqat WSHINTERFACES SELECT LOOKUP_CODE FROM ASO_LO...
199,965 199,955 1.00 0.00 0.00 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
198,879 199,892 9.64 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
198,803 199,965 9.63 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
147,523 149,883 7.15 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
99,286 99,423 4.81 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
98,454 99,990 4.77 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
59,949 59,993 2.91 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
59,941 59,997 2.90 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
59,940 59,997 2.90 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
59,916 60,000 2.90 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
53,608 54,998 2.60 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
49,965 49,992 2.42 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
49,951 49,930 2.42 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
49,948 49,253 2.42 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
49,946 49,989 2.42 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
49,930 49,999 2.42 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO...
49,930 49,983 2.42 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI...
49,922 49,987 2.42 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN...
49,769 49,723 2.41 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
49,332 49,998 2.39 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
48,988 49,726 2.37 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
48,350 49,638 2.34 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
47,493 49,943 2.30 bsuw7pmwrufpy INCTCW SELECT reservation_...
46,859 46,859 2.27 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
44,718 44,996 2.17 7gtztzv329wg0   select c.name, u.name from co...
44,644 44,992 2.16 2skwhauh2cwky   select o.name, u.name from ob...
21,757 21,756 1.05 bsa0wjtftg3uw   select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,264,320 397,768 0.12 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0074pdmwb7fmv BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0r0gvtarcjwzz insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1v818hwxjxy58 select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54q BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
39wym7tugc2sk SELECT PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE, LOT_CONTROL_CODE, SERIAL_NUMBER_CONTROL_CODE, AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER, INVENTORY_ASSET_FLAG, DESCRIPTION, CONCATENATED_SEGMENTS, SHELF_LIFE_CODE, SHELF_LIFE_DAYS, REVISION_QTY_CONTROL_CODE, LOCATION_CONTROL_CODE, DEFAULT_SERIAL_STATUS_ID, DEFAULT_LOT_STATUS_ID, nvl(RECEIVING_ROUTING_ID, -1) RECEIVING_ROUTING_ID, BOM_ITEM_TYPE, BASE_ITEM_ID, EAM_ITEM_TYPE, TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND, CHILD_LOT_FLAG, DEFAULT_GRADE, RETEST_INTERVAL, EXPIRATION_ACTION_INTERVAL, EXPIRATION_ACTION_CODE, MATURITY_DAYS, HOLD_DAYS, SECONDARY_UOM_CODE, GRADE_CONTROL_FLAG, nvl(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS_VL WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4h6x64v79na0t SELECT COUNT(1) FROM RA_CUSTOMER_TRX_LINES_ALL RCTL WHERE RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND RCTL.LINE_TYPE = 'LINE' AND RCTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(:B1 )
4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfk BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5t39uchjqpyfm BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6h228dtb8hp1t SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT .ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
6z9c18cxpxfq0 SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1
72yyswsqkzkrm BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7h2mgwhpy4qym INSERT INTO MTL_ONHAND_QUANTITIES_DETAIL (ONHAND_QUANTITIES_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID, OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE, DATE_RECEIVED, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, PRIMARY_TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE, TRANSACTION_QUANTITY, SECONDARY_UOM_CODE, SECONDARY_TRANSACTION_QUANTITY, SUBINVENTORY_CODE, LOT_NUMBER, REVISION, LOCATOR_ID, CREATE_TRANSACTION_ID, UPDATE_TRANSACTION_ID, ORIG_DATE_RECEIVED, COST_GROUP_ID, LPN_ID, CONTAINERIZED_FLAG, IS_CONSIGNED, PROJECT_ID, TASK_ID) VALUES (MTL_ONHAND_QUANTITIES_S.nextval, :1, :2, decode(nvl(:3, 0), 0, 2, :4), decode(nvl(:5, 0), 0, :6, :7), decode(nvl(:8, 0), 0, 2, :9), nvl(:10, :11), nvl(:12, 2), :13, SYSDATE, :14, SYSDATE, :15, :16, round(:17, 5), :18, round(((:19*:20)/:21), 5), :22, round( NVL(:23, :24), :25) + :26, :27, :28, :29, DECODE(:30, 0, '', :31), :32, :33, :34, :35, :36, nvl(:37, 2), :38, :39, :40)
7mrs575bj7a41 begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4 BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8upd356sbxqat SELECT LOOKUP_CODE FROM ASO_LOOKUPS WHERE LOOKUP_TYPE = 'ASO_ORDER_FEEDBACK_CRM_APPS' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE)
8zfgv4ck11dw9 BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23 select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
assndb4wqnd6r BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09 SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uw select file# from file$ where ts#=:1
bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
cdjud36xbtuu5 SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE'
cqc8bmqp529tz begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures ) ; END ;
cw171rvngr1w9 begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
d1swc9auhtxwd BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fvcbstf9s6a5r begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
g2qs4xk48vcwy select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggr begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ggak0dvtsppv3 SELECT /*+ leading(wias) index(wias, WF_ITEM_ACTIVITY_STATUSES_PK) */ WPA.INSTANCE_ID FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA WHERE WPA.ACTIVITY_ITEM_TYPE = :B2 AND WPA.ACTIVITY_NAME = :B1 AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B4 AND WIAS.ITEM_KEY = :B3
ghmx8n7wgqvfr begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gnng1rmpjxzsx begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 1,329,873 525.61 2.13
CPU used when call started 1,328,206 524.95 2.13
CR blocks created 13,445,862 5,314.25 21.58
Cached Commit SCN referenced 30,126,663 11,907.05 48.35
Commit SCN cached 1,317 0.52 0.00
DB time 3,686,490 1,457.02 5.92
DBWR checkpoint buffers written 2,240,627 885.57 3.60
DBWR checkpoints 8 0.00 0.00
DBWR object drop buffers written 1,477 0.58 0.00
DBWR revisited being-written buffer 59 0.02 0.00
DBWR thread checkpoint buffers written 2,240,627 885.57 3.60
DBWR transaction table writes 11,178 4.42 0.02
DBWR undo block writes 1,076,550 425.49 1.73
DFO trees parallelized 4 0.00 0.00
IMU CR rollbacks 5,642,455 2,230.08 9.06
IMU Flushes 370,526 146.44 0.59
IMU Redo allocation size 1,389,088,480 549,013.63 2,229.53
IMU commits 303,737 120.05 0.49
IMU contention 105,194 41.58 0.17
IMU ktichg flush 648 0.26 0.00
IMU recursive-transaction flush 95 0.04 0.00
IMU undo allocation size 1,978,379,048 781,920.72 3,175.35
PX local messages recv'd 5,943 2.35 0.01
PX local messages sent 5,943 2.35 0.01
Parallel operations downgraded 25 to 50 pct 3 0.00 0.00
Parallel operations downgraded 50 to 75 pct 0 0.00 0.00
Parallel operations not downgraded 1 0.00 0.00
SQL*Net roundtrips to/from client 156,776 61.96 0.25
active txn count during cleanout 49,457,492 19,547.23 79.38
application wait time 5,816 2.30 0.01
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 8,058 3.18 0.01
branch node splits 538 0.21 0.00
buffer is not pinned count 255,798,819 101,100.14 410.56
buffer is pinned count 469,608,160 185,604.65 753.73
bytes received via SQL*Net from client 53,525,561 21,155.07 85.91
bytes sent via SQL*Net to client 343,827,793 135,892.10 551.85
calls to get snapshot scn: kcmgss 55,515,103 21,941.40 89.10
calls to kcmgas 16,361,750 6,466.70 26.26
calls to kcmgcs 2,533,961 1,001.51 4.07
change write time 31,558 12.47 0.05
cleanout - number of ktugct calls 16,248,737 6,422.04 26.08
cleanouts and rollbacks - consistent read gets 12,660,118 5,003.70 20.32
cleanouts only - consistent read gets 61,259 24.21 0.10
cluster key scan block gets 155,183 61.33 0.25
cluster key scans 85,023 33.60 0.14
commit batch performed 1 0.00 0.00
commit batch requested 1 0.00 0.00
commit batch/immediate performed 48,113 19.02 0.08
commit batch/immediate requested 48,113 19.02 0.08
commit cleanout failures: block lost 179,468 70.93 0.29
commit cleanout failures: buffer being written 6,254 2.47 0.01
commit cleanout failures: callback failure 79,291 31.34 0.13
commit cleanout failures: cannot pin 43,503 17.19 0.07
commit cleanouts 7,140,162 2,822.03 11.46
commit cleanouts successfully completed 6,831,646 2,700.09 10.96
commit immediate performed 48,112 19.02 0.08
commit immediate requested 48,112 19.02 0.08
commit txn count during cleanout 674,323 266.51 1.08
concurrency wait time 36,998 14.62 0.06
consistent changes 628,699,407 248,482.76 1,009.08
consistent gets 1,116,911,898 441,440.46 1,792.68
consistent gets - examination 821,674,132 324,752.74 1,318.81
consistent gets direct 41 0.02 0.00
consistent gets from cache 1,116,911,857 441,440.44 1,792.68
cursor authentications 1,893 0.75 0.00
data blocks consistent reads - undo records applied 623,145,737 246,287.77 1,000.17
db block changes 124,463,440 49,192.06 199.77
db block gets 128,407,404 50,750.85 206.10
db block gets direct 345 0.14 0.00
db block gets from cache 128,407,059 50,750.71 206.10
deferred (CURRENT) block cleanout applications 1,259,483 497.79 2.02
enqueue conversions 2,176 0.86 0.00
enqueue releases 3,779,346 1,493.72 6.07
enqueue requests 3,998,431 1,580.31 6.42
enqueue timeouts 219,086 86.59 0.35
enqueue waits 34,875 13.78 0.06
exchange deadlocks 43,456 17.18 0.07
execute count 45,911,137 18,145.60 73.69
failed probes on index block reclamation 199,200 78.73 0.32
free buffer inspected 552,102 218.21 0.89
free buffer requested 16,184,555 6,396.67 25.98
global undo segment hints helped 1 0.00 0.00
heap block compress 24,462,753 9,668.49 39.26
immediate (CR) block cleanout applications 12,721,387 5,027.91 20.42
immediate (CURRENT) block cleanout applications 764,358 302.10 1.23
index crx upgrade (found) 93,840 37.09 0.15
index crx upgrade (positioned) 2,929,656 1,157.90 4.70
index fast full scans (rowid ranges) 52 0.02 0.00
index fetch by key 73,999,515 29,247.05 118.77
index scans kdiixs1 30,158,160 11,919.50 48.40
java call heap collected bytes 817,736,560 323,196.49 1,312.49
java call heap collected count 11,070,566 4,375.45 17.77
java call heap gc count 2,949 1.17 0.00
java call heap live object count 1,215,763 480.51 1.95
java call heap live object count max 1,217,412 481.16 1.95
java call heap live size 484,854,840 191,630.64 778.21
java call heap live size max 484,992,216 191,684.94 778.43
java call heap object count 3,239,607 1,280.40 5.20
java call heap object count max 3,242,810 1,281.67 5.20
java call heap total size 677,511,168 267,774.78 1,087.42
java call heap total size max 677,511,168 267,774.78 1,087.42
java call heap used size 617,678,016 244,126.74 991.39
java call heap used size max 617,957,440 244,237.18 991.84
leaf node 90-10 splits 9,571 3.78 0.02
leaf node splits 128,199 50.67 0.21
lob reads 3,000,748 1,185.99 4.82
lob writes 1,310,063 517.78 2.10
lob writes unaligned 1,310,063 517.78 2.10
logons cumulative 864 0.34 0.00
messages received 429,352 169.69 0.69
messages sent 429,352 169.69 0.69
no buffer to keep pinned count 2 0.00 0.00
no work - consistent read gets 265,301,116 104,855.76 425.82
opened cursors cumulative 903,358 357.04 1.45
parse count (failures) 2 0.00 0.00
parse count (hard) 3,340 1.32 0.01
parse count (total) 2,063,463 815.55 3.31
parse time cpu 3,246 1.28 0.01
parse time elapsed 6,034 2.38 0.01
physical read IO requests 27,564 10.89 0.04
physical read bytes 584,302,592 230,935.68 937.82
physical read total IO requests 30,091 11.89 0.05
physical read total bytes 623,583,232 246,460.68 1,000.87
physical read total multi block requests 5,897 2.33 0.01
physical reads 71,326 28.19 0.11
physical reads cache 70,123 27.71 0.11
physical reads cache prefetch 43,684 17.27 0.07
physical reads direct 1,203 0.48 0.00
physical reads direct (lob) 48 0.02 0.00
physical reads direct temporary tablespace 45 0.02 0.00
physical reads prefetch warmup 22,238 8.79 0.04
physical write IO requests 757,156 299.25 1.22
physical write bytes 18,374,680,576 7,262,280.41 29,491.88
physical write total IO requests 957,349 378.38 1.54
physical write total bytes 39,592,632,320 15,648,315.47 63,547.29
physical write total multi block requests 613,191 242.35 0.98
physical writes 2,243,003 886.51 3.60
physical writes direct 908 0.36 0.00
physical writes direct (lob) 8 0.00 0.00
physical writes direct temporary tablespace 336 0.13 0.00
physical writes from cache 2,242,095 886.15 3.60
physical writes non checkpoint 1,416,309 559.77 2.27
pinned buffers inspected 2 0.00 0.00
process last non-idle time 2,540 1.00 0.00
queries parallelized 4 0.00 0.00
recursive aborts on index block reclamation 5 0.00 0.00
recursive calls 83,776,907 33,111.40 134.46
recursive cpu usage 1,129,881 446.57 1.81
redo blocks written 41,322,560 16,332.04 66.32
redo entries 67,288,517 26,594.64 108.00
redo ordering marks 848,372 335.30 1.36
redo size 20,362,750,928 8,048,031.45 32,682.79
redo subscn max counts 1,629,397 643.99 2.62
redo synch time 76,557 30.26 0.12
redo synch writes 129,847 51.32 0.21
redo wastage 97,860,004 38,677.50 157.07
redo write time 59,463 23.50 0.10
redo writer latching time 751 0.30 0.00
redo writes 215,806 85.29 0.35
rollback changes - undo records applied 61,227 24.20 0.10
rollbacks only - consistent read gets 841,977 332.78 1.35
rows fetched via callback 29,470,358 11,647.66 47.30
session connect time 0 0.00 0.00
session cursor cache hits 1,885,421 745.18 3.03
session logical reads 1,245,319,302 492,191.30 1,998.77
session pga memory 125,962,312 49,784.46 202.17
session pga memory max 209,913,928 82,964.91 336.92
session uga memory ############### 83,189,609.23 337,830.26
session uga memory max 9,265,749,832 3,662,130.25 14,871.79
shared hash latch upgrades - no wait 22,012,339 8,700.00 35.33
shared hash latch upgrades - wait 208,869 82.55 0.34
sorts (memory) 4,147,500 1,639.23 6.66
sorts (rows) 12,939,417 5,114.08 20.77
sql area evicted 38 0.02 0.00
sql area purged 20 0.01 0.00
switch current to new buffer 1,161,943 459.24 1.86
table fetch by rowid 315,762,623 124,799.81 506.81
table fetch continued row 10,481,897 4,142.79 16.82
table scan blocks gotten 7,182,780 2,838.87 11.53
table scan rows gotten 318,844,672 126,017.94 511.75
table scans (long tables) 187 0.07 0.00
table scans (rowid ranges) 187 0.07 0.00
table scans (short tables) 1,382,837 546.54 2.22
total number of times SMON posted 3,987 1.58 0.01
transaction rollbacks 48,113 19.02 0.08
transaction tables consistent read rollbacks 169 0.07 0.00
transaction tables consistent reads - undo records applied 244,888 96.79 0.39
undo change vector size 7,389,080,036 2,920,408.38 11,859.68
user I/O wait time 13,173 5.21 0.02
user calls 190,342 75.23 0.31
user commits 622,213 245.92 1.00
user rollbacks 829 0.33 0.00
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 1,425,644 563.46 2.29
write clones created in background 52 0.02 0.00
write clones created in foreground 53,397 21.10 0.09

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 7,586 45,735
opened cursors current 2,723 2,575
logons current 86 86

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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_TS_TX_IDX 4,084 2 5.63 3.23 273,114 108 227,027 0.16
APPS_UNDOTS1 9 0 2.22 1.00 187,633 74 493,645 0.14
APPS_TS_TX_DATA 5,567 2 3.23 5.59 151,569 60 136,194 0.29
APPS_TS_INTERFACE 704 0 3.78 5.78 76,950 30 27,133 0.25
APPS_TS_QUEUES 167 0 5.09 1.58 34,269 14 112,449 0.43
APPS_TS_SUMMARY 102 0 4.41 1.00 23,288 9 41,300 0.11
SYSTEM 14,140 6 3.36 1.02 8,368 3 23,473 0.22
SYSAUX 1,613 1 7.42 2.81 1,025 0 0 0.00
APPS_TS_SEED 858 0 5.48 3.52 203 0 1,735 3.88
APPS_TS_ARCHIVE 32 0 5.94 2.09 479 0 51 3.14
APPS_TS_NOLOGGING 9 0 3.33 1.00 131 0 312 0.54
TEMP 44 0 0.45 7.68 17 0 0 0.00
APPS_TS_MEDIA 28 0 2.14 1.00 14 0 0 0.00
APPS_CALCLIP 8 0 5.00 1.00 8 0 0 0.00
CTXSYS 12 0 0.00 1.00 4 0 0 0.00
CWMLITE 10 0 2.00 1.00 4 0 0 0.00
DCM 8 0 2.50 1.00 4 0 0 0.00
GEOR_TBS 8 0 1.25 1.00 4 0 0 0.00
B2B_DT 6 0 0.00 1.00 2 0 0 0.00
B2B_IDX 6 0 1.67 1.00 2 0 0 0.00
B2B_LOB 6 0 0.00 1.00 2 0 0 0.00
B2B_RT 6 0 1.67 1.00 2 0 0 0.00
BAM 6 0 1.67 1.00 2 0 0 0.00
PORTAL_DOC 6 0 1.67 1.00 2 0 0 0.00
PORTAL_IDX 6 0 0.00 1.00 2 0 0 0.00
PORTAL_LOG 6 0 1.67 1.00 2 0 0 0.00
RE 6 0 1.67 1.00 2 0 0 0.00
SYNCSERVER 6 0 1.67 1.00 2 0 0 0.00
UDDISYS_TS 6 0 1.67 1.00 2 0 0 0.00
WCRSYS_TS 6 0 0.00 1.00 2 0 0 0.00
XDB 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TOOLS 4 0 0.00 1.00 2 0 0 0.00
DISCO_PTM5_CACHE 4 0 2.50 1.00 2 0 0 0.00
DISCO_PTM5_META 4 0 0.00 1.00 2 0 0 0.00
DSGATEWAY_TAB 4 0 2.50 1.00 2 0 0 0.00
HTMLDB 4 0 2.50 1.00 2 0 0 0.00
IAS_META 4 0 0.00 1.00 2 0 0 0.00
MTR 4 0 2.50 1.00 2 0 0 0.00
NOETIX 4 0 2.50 1.00 2 0 0 0.00
NON_APPS_TS_DATA 4 0 0.00 1.00 2 0 0 0.00
OCATS 4 0 2.50 1.00 2 0 0 0.00
ODM_DATA 4 0 2.50 1.00 2 0 0 0.00
OLTS_ATTRSTORE 4 0 0.00 1.00 2 0 0 0.00
OLTS_BATTRSTORE 4 0 2.50 1.00 2 0 0 0.00
OLTS_CT_STORE 4 0 2.50 1.00 2 0 0 0.00
OLTS_DEFAULT 4 0 0.00 1.00 2 0 0 0.00
OLTS_SVRMGSTORE 4 0 2.50 1.00 2 0 0 0.00
OPMOR 4 0 2.50 1.00 2 0 0 0.00
ORABPEL 4 0 2.50 1.00 2 0 0 0.00
OWAPUB 4 0 0.00 1.00 2 0 0 0.00
PORTAL 4 0 2.50 1.00 2 0 0 0.00
APPS_OMO 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_DISCO 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_DISCO_OLAP 2 0 5.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_CALCLIP /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip.d 2 0 5.00 1.00 2 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip1. 2 0 5.00 1.00 2 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip2. 2 0 5.00 1.00 2 0 0 0.00
APPS_CALCLIP /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_calclip3. 2 0 5.00 1.00 2 0 0 0.00
APPS_OMO /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/omo1.dbf 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_ARCHIVE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/archive1.dbf 32 0 5.94 2.09 479 0 51 3.14
APPS_TS_DISCO /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/disco1.dbf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_DISCO_OLAP /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/disco_drake1.d 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 23 0 3.04 6.91 3,995 2 922 0.39
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 22 0 4.55 7.18 3,694 1 545 0.39
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 24 0 5.42 6.67 3,395 1 877 0.38
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 20 0 2.00 7.15 3,543 1 825 0.06
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 24 0 3.75 7.17 3,487 1 744 0.23
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 24 0 3.75 6.33 2,906 1 577 0.26
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 20 0 4.50 7.15 3,114 1 714 0.42
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 5.20 6.84 3,030 1 403 0.92
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 23 0 3.91 6.48 3,291 1 788 0.23
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 5.60 6.92 3,003 1 1,258 0.21
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 30 0 4.67 2.90 1,064 0 372 0.13
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 120 0 4.50 3.73 1,282 1 1,465 0.24
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 37 0 2.97 6.81 4,965 2 3,179 0.14
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 32 0 2.50 7.31 3,965 2 1,844 0.30
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 5.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 39 0 2.82 6.36 4,341 2 2,122 0.34
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 2.80 6.92 3,974 2 2,158 0.17
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 3.20 6.92 3,933 2 1,481 0.18
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 3.60 6.72 4,073 2 2,209 0.22
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 23 0 2.61 7.04 4,304 2 1,503 0.24
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 25 0 4.40 6.88 3,833 2 1,355 0.21
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 26 0 4.62 6.27 3,736 1 761 0.50
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 27 0 3.33 6.19 3,992 2 1,031 0.22
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 4 0 0.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 4 0 0.00 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_INTERFACE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_interf 2 0 0.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media1.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media2.dbf 4 0 0.00 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media3.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media4.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media5.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media6.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_MEDIA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/media7.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_NOLOGGING /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/nologging1.dbf 9 0 3.33 1.00 131 0 312 0.54
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues1.dbf 13 0 5.38 1.62 4,584 2 16,292 0.42
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues2.dbf 13 0 5.38 1.00 4,956 2 16,481 0.48
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues3.dbf 9 0 6.67 1.00 5,090 2 15,151 0.40
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues4.dbf 16 0 5.63 1.44 4,314 2 15,098 0.38
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues5.dbf 15 0 5.33 1.93 3,965 2 15,013 0.39
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues6.dbf 86 0 5.00 1.66 6,718 3 17,454 0.44
APPS_TS_QUEUES /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/queues7.dbf 15 0 3.33 1.73 4,642 2 16,960 0.46
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference1.dbf 193 0 3.52 1.07 43 0 298 2.92
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference2.dbf 124 0 5.73 3.85 39 0 235 3.32
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference3.dbf 106 0 6.60 4.40 38 0 245 4.78
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference4.dbf 117 0 5.81 4.57 32 0 349 3.84
APPS_TS_SEED /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/reference5.dbf 318 0 6.07 4.19 51 0 608 4.23
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary1.dbf 5 0 4.00 1.00 2,199 1 4,642 0.09
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary10.dbf 8 0 3.75 1.00 1,826 1 3,089 0.12
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary11.dbf 6 0 5.00 1.00 1,841 1 3,012 0.13
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary12.dbf 5 0 4.00 1.00 1,883 1 2,753 0.08
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary13.dbf 4 0 2.50 1.00 1,854 1 3,269 0.17
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary2.dbf 5 0 4.00 1.00 1,649 1 3,126 0.10
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary3.dbf 32 0 5.00 1.00 1,142 0 1,448 0.09
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary4.dbf 7 0 4.29 1.00 1,737 1 2,451 0.09
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary5.dbf 5 0 4.00 1.00 1,640 1 3,052 0.11
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary6.dbf 9 0 3.33 1.00 1,831 1 3,308 0.09
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary7.dbf 7 0 5.71 1.00 1,977 1 3,017 0.11
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary8.dbf 4 0 2.50 1.00 1,773 1 3,360 0.12
APPS_TS_SUMMARY /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/summary9.dbf 5 0 6.00 1.00 1,936 1 4,773 0.15
APPS_TS_TOOLS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_tools0 4 0 0.00 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data1.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data10.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data11.dbf 85 0 3.06 7.21 3,325 1 2,578 0.33
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data12.dbf 91 0 3.63 6.90 3,473 1 3,460 0.17
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data13.dbf 248 0 2.26 2.50 3,572 1 2,961 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data14.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data15.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data16.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data17.dbf 4 0 0.00 1.00 239 0 38 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data18.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data19.dbf 51 0 2.55 6.73 316 0 21 0.48
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data2.dbf 96 0 3.02 6.52 3,519 1 3,479 0.16
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data20.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data21.dbf 97 0 3.61 6.38 3,524 1 3,336 0.32
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data22.dbf 92 0 2.93 6.76 1,327 1 1,139 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data23.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data24.dbf 9 0 3.33 2.44 301 0 61 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data25.dbf 6 0 0.00 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data26.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data27.dbf 173 0 5.20 2.83 1,385 1 2,097 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data28.dbf 79 0 5.57 2.75 429 0 112 2.14
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data29.dbf 27 0 6.30 2.30 260 0 272 1.10
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data3.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data30.dbf 22 0 4.55 1.64 141 0 47 1.28
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data31.dbf 26 0 4.23 1.27 287 0 108 1.67
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data32.dbf 165 0 4.30 5.73 1,311 1 1,362 0.54
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data33.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data34.dbf 10 0 4.00 2.30 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data35.dbf 8 0 2.50 2.63 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data36.dbf 9 0 3.33 2.44 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data37.dbf 10 0 5.00 2.80 318 0 110 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data38.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data39.dbf 131 0 4.05 6.41 1,486 1 1,316 0.56
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data4.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data40.dbf 6 0 0.00 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data41.dbf 12 0 5.83 2.58 317 0 50 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data42.dbf 7 0 4.29 2.86 314 0 13 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data43.dbf 144 0 3.75 6.00 4,225 2 3,841 0.36
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data44.dbf 137 0 4.60 6.46 4,161 2 4,657 0.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data45.dbf 127 0 3.54 6.80 4,384 2 4,077 0.33
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data46.dbf 119 0 4.37 6.99 4,024 2 3,304 0.37
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data47.dbf 122 0 3.69 6.56 3,712 1 3,718 0.24
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data48.dbf 110 0 3.27 6.92 3,755 1 3,489 0.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data49.dbf 106 0 3.30 6.83 3,736 1 3,349 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data5.dbf 4 0 2.50 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data50.dbf 116 0 3.36 6.71 3,438 1 3,472 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data51.dbf 109 0 3.39 6.61 3,424 1 3,584 0.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data52.dbf 6 0 3.33 3.33 272 0 70 0.14
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data53.dbf 241 0 1.70 2.86 3,456 1 3,372 0.15
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data54.dbf 108 0 3.70 6.82 3,384 1 2,803 0.19
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data55.dbf 97 0 3.20 7.01 3,269 1 2,514 0.59
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data56.dbf 246 0 1.83 2.68 3,375 1 3,110 0.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data57.dbf 102 0 4.02 6.97 3,427 1 2,625 0.30
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data58.dbf 101 0 3.07 6.93 3,397 1 2,899 0.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data59.dbf 95 0 3.05 6.91 3,516 1 2,766 0.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data6.dbf 4 0 0.00 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data60.dbf 99 0 3.43 6.81 3,769 1 3,314 0.51
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data61.dbf 97 0 3.71 7.08 3,575 1 3,993 0.24
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data62.dbf 91 0 3.30 7.21 3,553 1 3,202 0.23
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data63.dbf 94 0 2.66 6.99 3,440 1 3,242 0.27
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data64.dbf 100 0 3.00 6.60 3,361 1 3,889 0.16
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data65.dbf 97 0 3.20 6.93 3,425 1 3,091 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data66.dbf 97 0 2.99 6.94 3,509 1 2,787 0.21
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data67.dbf 95 0 2.95 6.85 3,306 1 2,527 0.29
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data68.dbf 99 0 2.93 6.63 3,324 1 3,103 0.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data69.dbf 245 0 1.84 2.65 3,566 1 3,696 0.22
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data7.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data70.dbf 92 0 3.37 7.02 3,486 1 2,930 0.23
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data71.dbf 92 0 4.02 6.66 3,715 1 2,724 0.99
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data72.dbf 98 0 2.96 6.20 3,578 1 3,387 0.17
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data73.dbf 87 0 3.45 6.86 3,672 1 2,734 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data74.dbf 87 0 2.41 6.95 3,455 1 2,900 0.89
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data75.dbf 83 0 2.77 7.08 3,374 1 2,768 0.25
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data76.dbf 91 0 2.86 6.42 3,520 1 3,006 0.18
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data77.dbf 92 0 3.91 6.67 3,746 1 3,853 0.20
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data78.dbf 87 0 2.76 6.86 3,350 1 2,838 0.12
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data8.dbf 6 0 1.67 1.00 2 0 0 0.00
APPS_TS_TX_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_data9.dbf 6 0 0.00 1.00 2 0 0 0.00
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx1.dbf 38 0 7.63 4.34 5,430 2 4,098 0.16
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx10.dbf 49 0 7.14 4.98 4,994 2 3,785 0.10
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx11.dbf 45 0 7.11 5.18 5,267 2 4,004 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx12.dbf 36 0 5.83 4.75 5,201 2 4,244 0.15
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx13.dbf 41 0 7.56 4.56 5,290 2 4,474 0.17
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx14.dbf 42 0 8.57 3.57 5,266 2 4,218 0.09
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx15.dbf 39 0 6.67 5.10 5,369 2 3,817 0.08
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx16.dbf 42 0 6.67 4.67 5,056 2 3,678 0.15
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx17.dbf 108 0 2.41 1.00 5,090 2 3,679 0.12
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx18.dbf 96 0 3.65 1.00 4,899 2 3,323 0.09
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx19.dbf 41 0 6.34 3.46 5,106 2 3,169 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx2.dbf 32 0 6.56 5.59 5,045 2 28,051 0.30
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx20.dbf 40 0 4.25 4.65 5,245 2 2,842 0.19
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx21.dbf 36 0 6.39 4.14 4,493 2 3,317 0.21
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx22.dbf 34 0 5.59 4.62 4,611 2 3,448 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx23.dbf 27 0 7.04 5.19 4,694 2 3,664 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx24.dbf 25 0 8.80 5.80 4,932 2 3,568 0.08
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx25.dbf 30 0 6.67 4.73 4,337 2 2,961 0.08
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx26.dbf 29 0 7.59 4.31 4,579 2 11,179 0.09
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx27.dbf 934 0 4.96 2.22 11,815 5 15,638 0.21
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx28.dbf 391 0 2.86 1.00 3,362 1 943 0.51
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx29.dbf 235 0 5.57 2.94 9,934 4 10,224 0.10
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx3.dbf 78 0 9.49 5.06 7,768 3 4,104 0.13
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx30.dbf 67 0 6.57 4.66 7,027 3 4,064 0.09
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx31.dbf 83 0 8.19 4.31 7,536 3 4,511 0.22
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx32.dbf 92 0 6.63 4.05 7,629 3 4,050 0.08
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx33.dbf 109 0 6.24 4.01 8,059 3 3,862 0.17
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx34.dbf 71 0 6.90 4.89 7,334 3 4,197 0.12
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx35.dbf 215 0 2.33 1.00 7,938 3 7,730 0.13
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx36.dbf 52 0 7.31 4.63 6,722 3 4,587 0.16
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx37.dbf 67 0 5.82 3.22 7,112 3 5,141 0.07
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx38.dbf 49 0 6.73 4.73 6,655 3 3,783 0.09
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx39.dbf 60 0 5.33 4.03 6,168 2 3,474 0.10
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx4.dbf 41 0 7.32 5.68 5,116 2 3,051 0.17
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx40.dbf 57 0 8.25 4.33 5,444 2 3,380 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx41.dbf 52 0 7.50 4.52 5,314 2 3,137 0.13
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx42.dbf 54 0 6.85 4.89 5,123 2 3,049 0.16
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx43.dbf 53 0 7.17 4.81 5,482 2 3,459 0.10
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx44.dbf 52 0 6.54 4.88 5,631 2 3,339 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx45.dbf 54 0 5.74 5.19 5,150 2 3,684 0.13
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx46.dbf 44 0 6.59 4.45 5,234 2 3,716 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx47.dbf 36 0 8.06 4.72 4,875 2 3,969 0.15
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx48.dbf 42 0 12.14 5.26 5,301 2 3,944 0.14
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx49.dbf 42 0 5.24 3.86 5,364 2 4,041 0.15
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx5.dbf 42 0 8.33 4.90 1,898 1 635 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx6.dbf 46 0 6.30 4.46 5,136 2 4,278 0.20
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx7.dbf 54 0 6.48 3.69 4,818 2 4,284 0.11
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx8.dbf 42 0 5.95 5.24 1,705 1 590 0.58
APPS_TS_TX_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/tx_idx9.dbf 40 0 9.75 4.85 1,560 1 644 0.12
APPS_UNDOTS1 /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/undo.dbf 3 0 6.67 1.00 93,870 37 239,588 0.14
APPS_UNDOTS1 /oracle/visdata/undo1.dbf 6 0 0.00 1.00 93,763 37 254,057 0.13
B2B_DT /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_dt.dbf 6 0 0.00 1.00 2 0 0 0.00
B2B_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_idx.dbf 6 0 1.67 1.00 2 0 0 0.00
B2B_LOB /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_lob.dbf 6 0 0.00 1.00 2 0 0 0.00
B2B_RT /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/b2b_rt.dbf 6 0 1.67 1.00 2 0 0 0.00
BAM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/bam.dbf 6 0 1.67 1.00 2 0 0 0.00
CTXSYS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ctx1.dbf 6 0 0.00 1.00 2 0 0 0.00
CTXSYS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ctx2.dbf 6 0 0.00 1.00 2 0 0 0.00
CWMLITE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/cwmlite01.dbf 6 0 1.67 1.00 2 0 0 0.00
CWMLITE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/cwmlite02.dbf 4 0 2.50 1.00 2 0 0 0.00
DCM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/dcm.dbf 4 0 2.50 1.00 2 0 0 0.00
DCM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/dcm1.dbf 4 0 2.50 1.00 2 0 0 0.00
DISCO_PTM5_CACHE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/discopltc1.dbf 4 0 2.50 1.00 2 0 0 0.00
DISCO_PTM5_META /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/discopltm1.dbf 4 0 0.00 1.00 2 0 0 0.00
DSGATEWAY_TAB /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/oss_sys01.dbf 4 0 2.50 1.00 2 0 0 0.00
GEOR_TBS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/apps_ts_spatia 4 0 0.00 1.00 2 0 0 0.00
GEOR_TBS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/geor_tbs02.dbf 4 0 2.50 1.00 2 0 0 0.00
HTMLDB /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/htmldb.dbf 4 0 2.50 1.00 2 0 0 0.00
IAS_META /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ias_meta01.dbf 4 0 0.00 1.00 2 0 0 0.00
MTR /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opmtr01.dbf 4 0 2.50 1.00 2 0 0 0.00
NOETIX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/noetix.dbf 4 0 2.50 1.00 2 0 0 0.00
NON_APPS_TS_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/non_apps_data1 4 0 0.00 1.00 2 0 0 0.00
OCATS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/oca.dbf 4 0 2.50 1.00 2 0 0 0.00
ODM_DATA /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/odm.dbf 4 0 2.50 1.00 2 0 0 0.00
OLTS_ATTRSTORE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/attrs1_oid.dbf 4 0 0.00 1.00 2 0 0 0.00
OLTS_BATTRSTORE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/battrs1_oid.db 4 0 2.50 1.00 2 0 0 0.00
OLTS_CT_STORE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/gcats1_oid.dbf 4 0 2.50 1.00 2 0 0 0.00
OLTS_DEFAULT /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/gdefault1_oid. 4 0 0.00 1.00 2 0 0 0.00
OLTS_SVRMGSTORE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/svrmg1_oid.dbf 4 0 2.50 1.00 2 0 0 0.00
OPMOR /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opmor01.dbf 4 0 2.50 1.00 2 0 0 0.00
ORABPEL /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/orabpel.dbf 4 0 2.50 1.00 2 0 0 0.00
OWAPUB /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/owa1.dbf 4 0 0.00 1.00 2 0 0 0.00
PORTAL /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/portal.dbf 4 0 2.50 1.00 2 0 0 0.00
PORTAL_DOC /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptldoc.dbf 6 0 1.67 1.00 2 0 0 0.00
PORTAL_IDX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptlidx.dbf 6 0 0.00 1.00 2 0 0 0.00
PORTAL_LOG /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/ptllog.dbf 6 0 1.67 1.00 2 0 0 0.00
RE /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/opre01.dbf 6 0 1.67 1.00 2 0 0 0.00
SYNCSERVER /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/mobile01.dbf 6 0 1.67 1.00 2 0 0 0.00
SYSAUX /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sysaux01.dbf 1,613 1 7.42 2.81 1,025 0 0 0.00
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys1.dbf 1,341 1 3.01 1.00 501 0 176 1.25
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys10.dbf 2,115 1 3.02 1.00 746 0 34 0.59
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys2.dbf 2,234 1 2.60 1.01 281 0 458 0.41
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys3.dbf 1,261 0 4.23 1.09 1,644 1 6,145 0.22
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys4.dbf 1,160 0 3.66 1.03 1,739 1 5,963 0.21
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys5.dbf 1,297 1 3.17 1.00 1,576 1 4,497 0.15
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys6.dbf 882 0 3.89 1.01 611 0 1,872 0.17
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys7.dbf 1,473 1 3.74 1.02 548 0 3,258 0.22
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys8.dbf 1,086 0 3.79 1.01 251 0 469 0.43
SYSTEM /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/sys9.dbf 1,291 1 3.49 1.00 471 0 601 0.25
TEMP /oracle/visdata/temp1.dbf 4 0 2.50 11.50 3 0 0  
TEMP /oracle/visdata/temp2.dbf 40 0 0.25 7.30 14 0 0  
UDDISYS_TS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/uddisys01.dbf 6 0 1.67 1.00 2 0 0 0.00
WCRSYS_TS /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/wcrsys01.dbf 6 0 0.00 1.00 2 0 0 0.00
XDB /ds1/oracle/VIS/db/tech_st/10.2.0/dbf/xdb01.dbf 6 0 1.67 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,901,214 100 1,232,577,851 70,130 2,242,095 0 0 1,063,313


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 26 3548 99363 100000 45298440   100000
E 0 27 4886 99099 100000 45298440 11883173 100000

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 2,336 0.10 288,934 1.06 459,106
D 4,672 0.20 577,868 1.03 446,226
D 7,008 0.30 866,802 1.03 443,356
D 9,344 0.40 1,155,736 1.00 433,680
D 11,680 0.50 1,444,670 1.00 432,051
D 14,016 0.60 1,733,604 1.00 431,630
D 16,352 0.70 2,022,538 1.00 431,630
D 18,688 0.80 2,311,472 1.00 431,630
D 21,024 0.90 2,600,406 1.00 431,630
D 23,360 1.00 2,889,340 1.00 431,630
D 23,456 1.00 2,901,214 1.00 431,630
D 25,696 1.10 3,178,274 1.00 431,630
D 28,032 1.20 3,467,208 1.00 431,630
D 30,368 1.29 3,756,142 1.00 431,630
D 32,704 1.39 4,045,076 1.00 431,630
D 35,040 1.49 4,334,010 1.00 431,630
D 37,376 1.59 4,622,944 1.00 431,630
D 39,712 1.69 4,911,878 1.00 431,630
D 42,048 1.79 5,200,812 1.00 431,630
D 44,384 1.89 5,489,746 1.00 431,630
D 46,720 1.99 5,778,680 0.99 429,188

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
99.99 80,158 8

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 4,096 3,539 298.73 0.00 0.00 0.00 0.00 419,430
E 4,096 3,535 295.43 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 1,341,124 1,341,124 0 0
64K 128K 1,759 1,759 0 0
128K 256K 1,083 1,083 0 0
256K 512K 152 152 0 0
512K 1024K 31,124 31,124 0 0
1M 2M 46,752 46,752 0 0
2M 4M 287 285 2 0
4M 8M 17 17 0 0
8M 16M 12 12 0 0
16M 32M 4 4 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
512 0.13 86,821.57 215.87 100.00 54
1,024 0.25 86,821.57 179.02 100.00 40
2,048 0.50 86,821.57 106.84 100.00 7
3,072 0.75 86,821.57 0.00 100.00 0
4,096 1.00 86,821.57 0.00 100.00 0
4,915 1.20 86,821.57 0.00 100.00 0
5,734 1.40 86,821.57 0.00 100.00 0
6,554 1.60 86,821.57 0.00 100.00 0
7,373 1.80 86,821.57 0.00 100.00 0
8,192 2.00 86,821.57 0.00 100.00 0
12,288 3.00 86,821.57 0.00 100.00 0
16,384 4.00 86,821.57 0.00 100.00 0
24,576 6.00 86,821.57 0.00 100.00 0
32,768 8.00 86,821.57 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
464 0.45 122 6,985 810,404 1.00 157 1.16 45,940,799
576 0.56 231 11,794 810,425 1.00 136 1.01 45,942,455
688 0.67 283 16,013 810,426 1.00 135 1.00 45,942,558
800 0.78 283 16,013 810,426 1.00 135 1.00 45,942,558
912 0.89 283 16,013 810,426 1.00 135 1.00 45,942,558
1,024 1.00 283 16,013 810,426 1.00 135 1.00 45,942,558
1,136 1.11 283 16,013 810,426 1.00 135 1.00 45,942,558
1,248 1.22 283 16,013 810,426 1.00 135 1.00 45,942,558
1,360 1.33 283 16,013 810,426 1.00 135 1.00 45,942,558
1,472 1.44 283 16,013 810,426 1.00 135 1.00 45,942,558
1,584 1.55 283 16,013 810,426 1.00 135 1.00 45,942,558
1,696 1.66 283 16,013 810,426 1.00 135 1.00 45,942,558
1,808 1.77 283 16,013 810,426 1.00 135 1.00 45,942,558
1,920 1.88 283 16,013 810,426 1.00 135 1.00 45,942,558
2,032 1.98 283 16,013 810,426 1.00 135 1.00 45,942,558
2,144 2.09 283 16,013 810,426 1.00 135 1.00 45,942,558

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
6,144 0.25 15,037 446,156
12,288 0.50 15,009 431,999
18,432 0.75 15,007 431,611
24,576 1.00 15,007 431,611
30,720 1.25 15,007 431,611
36,864 1.50 15,007 431,611
43,008 1.75 15,007 431,611
49,152 2.00 15,002 429,151

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.50 8 274 6 1.00 135 1.00 360
32 1.00 8 274 6 1.00 135 1.00 360
48 1.50 8 274 6 1.00 135 1.00 360
64 2.00 8 274 6 1.00 135 1.00 360

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 539,442 143 0
undo block 448,160 49 0
undo header 45,487 17 0
1st level bmb 23,771 3 0
segment header 5,988 1 0
2nd level bmb 404 0 1
extent map 68 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TX-Transaction (row lock contention) 224,662 6,102 218,568 6,102 58 9.54
TX-Transaction (index contention) 13,219 13,219 0 13,187 14 1.03
TX-Transaction 899,503 899,531 0 5,181 6 1.13
HW-Segment High Water Mark 79,056 79,046 10 5,014 4 0.78
SQ-Sequence Cache 36,127 36,127 0 4,256 1 0.27
FB-Format Block 21,255 21,255 0 1,114 1 0.79
RO-Multiple Object Reuse (fast object reuse) 54 54 0 6 0 38.33
TX-Transaction (allocate ITL entry) 17 17 0 14 0 0.00
PS-PX Process Reservation 160 136 24 1 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,019.33 886,177 1,225 20 47.9/52.2166666666666666666666666666666666667 0/0 0/0/0/17/52672/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
25-Aug 14:36 146,489 58,079 0 13 52 0/0 0/0/0/17/52672/0
25-Aug 14:26 225,506 169,122 256 15 48 0/0 0/0/0/0/0/0
25-Aug 14:16 246,809 299,381 1,225 16 48 0/0 0/0/0/0/0/0
25-Aug 14:06 400,527 359,595 619 20 49 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 1,970 0.00   0 0  
AWR Alerted Metric Element list 22,199 0.00   0 0  
Consistent RBA 215,880 0.01 0.00 0 0  
FOB s.o list latch 17,426 0.08 0.00 0 0  
In memory undo latch 610,347,012 0.82 0.00 9 680,431 0.13
JOX SGA heap latch 1,819,192 0.00 0.30 0 4,553 0.09
JS queue state obj latch 15,120 0.00   0 0  
JS slv state obj latch 117 0.00   0 0  
KMG MMAN ready and startup request latch 1,177 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 8 0.00   0 816 0.00
KWQMN job cache list latch 206,455 1.28 0.24 0 0  
KWQP Prop Status 315 0.00   0 0  
MQL Tracking Latch 0     0 50 0.00
Memory Management Latch 355 0.00   0 1,175 0.09
Mutex Stats 1 0.00   0 0  
NLS data objects 11 81.82 1.00 0 0  
OS process 2,661 0.00   0 0  
OS process allocation 2,616 0.00   0 0  
OS process: request allocation 1,582 0.06 0.00 0 0  
PL/SQL warning settings 1,279,569 0.00   0 0  
Policy Hash Table Latch 9 0.00   0 0  
SGA IO buffer pool latch 43,306 0.00   0 48,278 0.00
SQL memory manager latch 1 0.00   0 839 0.00
SQL memory manager workarea list latch 1,962,890 0.03 0.00 0 0  
Shared B-Tree 1,634 0.00   0 0  
Undo Hint Latch 0     0 16 0.00
active checkpoint queue latch 210,451 0.00   0 0  
active service list 8,177 0.45 0.03 0 930 0.00
begin backup scn array 14 0.00   0 0  
bq:time manger info latch 90 0.00   0 0  
buffer pool 2 0.00   0 0  
bufq statistics 3 0.00   0 0  
cache buffer handles 4,713,860 0.65 0.00 0 0  
cache buffers chains 3,203,511,034 2.17 0.02 66 11,636,552 4.74
cache buffers lru chain 6,979,658 0.60 0.01 2 29,326,843 1.10
cache table scan latch 0     0 3,246 0.03
channel handle pool latch 11,520 0.05 0.00 0 0  
channel operations parent latch 62,658 0.11 0.00 0 0  
checkpoint queue latch 6,894,524 0.02 0.02 0 2,261,586 0.03
client/application info 7,717 0.04 0.00 0 0  
commit callback allocation 222,228 0.23 0.00 0 0  
compile environment latch 23,530 0.00   0 0  
dictionary lookup 12 0.00   0 0  
dml lock allocation 5,010,220 2.26 0.00 0 0  
dummy allocation 1,744 0.86 0.00 0 0  
enqueue hash chains 7,831,112 1.39 0.00 0 225 0.00
enqueues 1,143,338 0.49 0.00 0 0  
error message lists 68 16.18 0.00 0 0  
event group latch 791 0.00   0 0  
file cache latch 22,573 0.01 0.00 0 0  
first spare latch 746,485 3.65 0.00 0 0  
global KZLD latch for mem in SGA 742 0.00   0 0  
global ctx hash table latch 271,704 0.00   0 0  
hash table column usage latch 1,950 0.00   0 518,725 0.00
hash table modification latch 133 1.50 0.00 0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 98 0.00
job_queue_processes parameter latch 91 0.00   0 0  
kks stats 5,832 0.00   0 0  
ksuosstats global area 170 0.00   0 0  
ktm global data 3,989 0.00   0 0  
kwqbsn:qsga 1,540 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 216,774 0.15 0.00 0 0  
library cache 90,642,461 2.01 0.00 2 75 0.00
library cache load lock 18,839 0.84 0.08 0 97 0.00
library cache lock 13,203,788 1.20 0.00 0 0  
library cache lock allocation 85,060 0.01 0.00 0 0  
library cache pin 57,888,940 1.57 0.00 1 0  
library cache pin allocation 28,456 0.00   0 0  
list of block allocation 262,035 0.16 0.00 0 0  
loader state object freelist 6,226 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 3 0.00   0 3 0.00
message pool operations parent latch 10,688 0.04 0.00 0 0  
messages 1,280,500 0.47 0.00 0 0  
mostly latch-free SCN 227,376 3.98 0.01 0 0  
multiblock read objects 12,234 0.01 0.00 0 0  
ncodef allocation latch 48 0.00   0 0  
object queue header heap 869,003 0.00 0.00 0 11,473 0.01
object queue header operation 12,749,159 0.08 0.01 0 1,967 0.00
object stats modification 11,470 0.02 0.00 0 0  
parallel query alloc buffer 944 1.69 0.00 0 0  
parallel query stats 44 38.64 0.00 0 0  
parameter list 2,405 0.00   0 0  
parameter table allocation management 884 2.60 0.35 0 0  
post/wait queue 337,895 0.07 0.05 0 166,014 1.20
process allocation 1,586 0.00   0 791 0.00
process group creation 1,582 0.00   0 0  
process queue 408 2.21 0.00 0 0  
process queue reference 88,507 0.09 0.00 0 8,989 0.50
qmn task queue latch 2,715 0.00   0 0  
query server freelists 348 7.18 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 2,245,886 1.87 0.03 1 67,225,886 1.49
redo copy 0     0 67,289,204 0.02
redo writing 1,042,163 0.01 0.44 0 0  
resmgr group change latch 5,055 0.00   0 0  
resmgr:actses active list 2,480 0.00   0 0  
resmgr:actses change group 2,298 0.00   0 0  
resmgr:free threads list 1,742 1.32 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 35,948,163 1.48 0.00 0 4 0.00
rules engine aggregate statistics 105,001 4.67 0.00 0 0  
rules engine evaluation context statistics 2 0.00   0 0  
rules engine rule set statistics 418,144 2.10 0.00 0 0  
rules engine rule statistics 209,926 0.00   0 0  
sequence cache 6,426,683 1.82 0.00 0 0  
session allocation 7,418,157 1.34 0.00 0 0  
session idle bit 403,368 0.00 0.00 0 0  
session state list latch 4,705 0.47 0.00 0 0  
session switching 48 0.00   0 0  
session timer 930 0.00   0 0  
shared pool 13,192,368 1.26 0.00 0 0  
shared pool sim alloc 401 0.00   0 0  
shared pool simulator 5,350,802 0.01 0.00 0 0  
simulator hash latch 95,931,221 0.01 0.00 0 0  
simulator lru latch 95,648,342 2.07 0.00 4 96,277 0.25
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 36,086 0.05 0.05 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temporary table state object allocation 754 0.00   0 0  
threshold alerts latch 986 0.00   0 0  
trace latch 4 0.00   0 0  
transaction allocation 19,875 0.00   0 0  
transaction branch allocation 48 0.00   0 0  
undo global data 707,514,732 2.42 0.00 2 0  
user lock 3,066 0.07 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 3,203,511,034 69,637,312 1,515,007 68,187,654 0 0 0
undo global data 707,514,732 17,148,113 7,481 17,142,159 0 0 0
In memory undo latch 610,347,012 5,005,911 18,561 4,988,977 0 0 0
simulator lru latch 95,648,342 1,975,912 3,799 1,972,858 0 0 0
library cache 90,642,461 1,819,292 1,485 1,818,100 0 0 0
library cache pin 57,888,940 911,156 528 910,725 0 0 0
row cache objects 35,948,163 532,065 377 531,766 0 0 0
shared pool 13,192,368 166,803 289 166,556 0 0 0
library cache lock 13,203,788 158,396 54 158,351 0 0 0
sequence cache 6,426,683 116,805 28 116,781 0 0 0
dml lock allocation 5,010,220 113,063 101 112,977 0 0 0
enqueue hash chains 7,831,112 108,669 122 108,565 0 0 0
session allocation 7,418,157 99,676 158 99,540 0 0 0
redo allocation 2,245,886 42,062 1,220 40,983 0 0 0
cache buffers lru chain 6,979,658 42,020 323 41,711 0 0 0
cache buffer handles 4,713,860 30,623 46 30,578 0 0 0
first spare latch 746,485 27,215 64 27,164 0 0 0
simulator hash latch 95,931,221 12,230 25 12,210 0 0 0
object queue header operation 12,749,159 10,395 81 10,321 0 0 0
mostly latch-free SCN 227,376 9,050 68 8,993 0 0 0
rules engine rule set statistics 418,144 8,790 1 8,789 0 0 0
messages 1,280,500 6,057 16 6,042 0 0 0
enqueues 1,143,338 5,630 6 5,625 0 0 0
KWQMN job cache list latch 206,455 2,647 647 2,003 0 0 0
checkpoint queue latch 6,894,524 1,580 26 1,554 0 0 0
shared pool simulator 5,350,802 657 2 655 0 0 0
SQL memory manager workarea list latch 1,962,890 539 1 538 0 0 0
post/wait queue 337,895 249 12 237 0 0 0
library cache load lock 18,839 158 12 146 0 0 0
redo writing 1,042,163 119 52 67 0 0 0
active service list 8,177 37 1 36 0 0 0
parameter table allocation management 884 23 8 15 0 0 0
sort extent pool 36,086 19 1 18 0 0 0
JOX SGA heap latch 1,819,192 10 3 7 0 0 0
NLS data objects 11 9 9 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 9,879 7,201
In memory undo latch kturbk 0 4,747 5,967
In memory undo latch ktichg: child 0 1,989 3,739
In memory undo latch kticmt: child 0 1,593 461
In memory undo latch ktiTxnPoolFree 0 269 2
In memory undo latch ktbgfc 0 58 1,190
In memory undo latch ktiBRacquire 0 24 0
In memory undo latch ktuswr 0 2 1
KWQMN job cache list latch kwqmnuji: update job item 0 1,636 1,636
NLS data objects klcslod 0 9 9
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
active service list ksws_event: ksws event 0 15 13
cache buffer handles kcbzgs 0 32 27
cache buffer handles kcbzfs 0 14 19
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,070,278 2,296,893
cache buffers chains kcbchg: kslbegin: call CR func 0 684,302 1,300,140
cache buffers chains kcbgtcr: fast path 0 518,445 21,182
cache buffers chains kcbgtcr: kslbegin excl 0 483,541 250,101
cache buffers chains kcbzgb: scan from tail. nowait 0 121,351 0
cache buffers chains kcbgcur: kslbegin 0 45,783 23,364
cache buffers chains kcbget: pin buffer 0 19,101 8,199
cache buffers chains kcbzwb 0 7,758 15,247
cache buffers chains kcbrls: kslbegin 0 5,700 56,261
cache buffers chains kcbnlc 0 2,174 4,112
cache buffers chains kcbcge 0 2,145 11,432
cache buffers chains kcbget: exchange rls 0 1,024 1,209
cache buffers chains kcbget: exchange 0 903 1,414
cache buffers chains kcb_is_private 0 302 4,176
cache buffers chains kcbbxsv 0 78 35
cache buffers chains kcbbic2 0 31 17
cache buffers chains kcbbic1 0 28 27
cache buffers chains kcbso1: set no access 0 24 34
cache buffers chains kcbesc: escalate 0 16 3
cache buffers chains kcbgtcr: kslbegin shared 0 14 8
cache buffers chains kcbnew: new latch again 0 13 1
cache buffers chains kcb_post_apply: kcbhq62 0 11 183
cache buffers chains kcb_pre_apply: kcbhq61 0 8 1,215
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 2 0
cache buffers chains kcbgkcbcr 0 1 0
cache buffers lru chain kcbzgws 0 181 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 106 0
cache buffers lru chain kcbzgb: posted for free bufs 0 28 74
cache buffers lru chain kcbzswcu 0 3 15
cache buffers lru chain kcbbxsv: move to being written 0 2 52
cache buffers lru chain kcbbic2 0 1 182
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 0
cache buffers lru chain kcbzib 0 1 0
channel handle pool latch ksrchconnect() 0 2 1
channel operations parent latch ksrchdelete() 0 2 1
checkpoint queue latch kcbswcu: Switch buffers 0 13 4
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 12 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 11
dml lock allocation ktaiam 0 80 75
dml lock allocation ktaidm 0 21 26
enqueue hash chains ksqgtl3 0 87 72
enqueue hash chains ksqrcl 0 30 50
enqueue hash chains ksqcmi: get hash chain latch after wait 0 5 0
enqueues ksqgel: create enqueue 0 5 6
enqueues ksqdel 0 1 0
event range base latch No latch 0 67 67
lgwr LWN SCN kcs023 0 26 0
library cache kglpnp: child 0 525 710
library cache kglpndl: child: after processing 0 449 46
library cache kglpndl: child: before processing 0 235 350
library cache kglobpn: child: 0 157 315
library cache kglScanDependency 0 39 0
library cache kglLockCursor 0 24 26
library cache kglget: unpin heap 0 0 17 7
library cache kglhdgn: child: 0 13 15
library cache kgldti: 2child 0 6 3
library cache kglpin 0 6 1
library cache kglhdgc: child: 0 3 4
library cache kglhdgh: child: 0 2 6
library cache kglati 0 1 0
library cache kgldte: child 0 0 1 0
library cache kglkep: child 0 1 0
library cache load lock kglllal: llatch: in loop 0 7 8
library cache load lock kglllal: llatch 0 5 4
library cache lock kgllkal: child: multiinstance 0 28 30
library cache lock kgllkdl: child: cleanup 0 26 24
library cache lock kgllkdl: child: no lock handle 0 6 3
library cache pin kglpnp: child 0 268 288
library cache pin kglpndl 0 220 143
library cache pin kglpnal: child: alloc space 0 39 97
library cache pin kglpnck 0 1 0
messages ksaamb: after wakeup 0 14 10
messages ksarcv 0 1 5
messages ksarcv: after wait 0 1 1
mostly latch-free SCN kcslcu3 0 41 67
object queue header operation kcbw_link_q 0 751 45
object queue header operation kcbo_switch_mq_bg 0 86 273
object queue header operation kcbo_switch_cq 0 35 324
object queue header operation kcbo_switch_q_bg 0 34 4
object queue header operation kcbo_swap_buf 0 14 119
object queue header operation kcbw_unlink_q 0 14 27
object queue header operation kcbo_ivbo 0 2 13
object queue header operation kcbo_swap_buf_bg 0 2 133
parameter table allocation management ksp_param_table_free 0 8 8
post/wait queue ksliwat:remove 0 7 5
post/wait queue ksliwat:add:nowait 0 3 0
post/wait queue kslpstevent:get 0 1 5
post/wait queue kslpstevent:reget 0 1 2
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,028 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 134 643
redo allocation kcrfw_redo_gen: redo allocation 2 0 34 0
redo allocation kcrfw_redo_write: before write 0 14 165
redo allocation kcrfw_redo_write: more space 0 10 421
redo writing kcrfw_post: rba scn pair 0 28 0
redo writing kcrfw_cal_target_rba 0 15 0
redo writing kcrfw_post: after write 0 9 0
row cache objects kqrpre: find obj 0 182 305
row cache objects kqreqd: reget 0 158 3
row cache objects kqreqd 0 35 70
row cache objects kqrcmt: while loop 0 2 0
rules engine rule set statistics kwrsosb: begin collect rs stats 0 1 1
sequence cache kdnssd 0 13 2
sequence cache kdnnxt: cached seq 0 9 4
sequence cache kdnss 0 6 21
session allocation ksuprc 0 61 61
session allocation ksuxds: KSUSFCLC not set 0 46 20
session allocation ksudlc 0 41 62
session allocation ksucri 0 4 5
session allocation ksursi 0 2 1
session allocation kxfpqidqr 0 2 5
session allocation ksucrp 0 1 0
session allocation ksudlp 0 1 2
shared pool kghalo 0 178 171
shared pool kghfre 0 79 67
shared pool kghupr1 0 30 53
shared pool kghalp 0 2 0
shared pool simulator kglsim_unpin_simhp 0 2 2
simulator hash latch kcbsacc: lookup dba 0 25 21
simulator lru latch kcbs_simulate: simulate set 0 3,772 3,548
simulator lru latch kcbs_simbufseq 0 23 251
simulator lru latch kcbs_shrink_pool 0 3 0
simulator lru latch kcbs_resize_pool : interpolation 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 1 0
undo global data kturimugur: child 0 6,390 4,438
undo global data ktudba: KSLBEGIN 0 1,030 2,957
undo global data ktudnx:child 0 34 43
undo global data ktubnd:child 0 15 2
undo global data ktufrbs: child 0 10 40
undo global data ktusmasp: ktugd_tuux 0 1 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_IDX RA_CUSTOMER_TRX_LINES_C01   INDEX 59,950,928 4.81
AR APPS_TS_TX_IDX RA_INTERFACE_LINES_C01   INDEX 27,522,720 2.21
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_PK WF_ITEM49 INDEX PARTITION 26,891,376 2.16
APPLSYS APPS_TS_SEED WF_ACTIVITIES_PK   INDEX 24,284,656 1.95
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 23,915,824 1.92

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
AR APPS_TS_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 2,423 3.40
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 1,803 2.53
AR APPS_TS_TX_IDX RA_CUSTOMER_TRX_LINES_C01   INDEX 1,242 1.74
AR APPS_TS_INTERFACE RA_INTERFACE_SALESCREDITS_ALL   TABLE 704 0.99
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 458 0.64

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_155893   INDEX 518,552 44.09
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 436,822 37.14
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 194,482 16.54
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 10,852 0.92
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 8,018 0.68

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_N1   INDEX 3 37.50
INV APPS_TS_TX_IDX MTL_MATERIAL_TRANSACTIONS_N3   INDEX 1 12.50
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 1 12.50
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 1 12.50
ASO APPS_TS_QUEUES SYS_IOT_TOP_115213   INDEX 1 12.50

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 62,586 13.72
ASO APPS_TS_QUEUES SYS_IOT_TOP_115215   INDEX 44,864 9.83
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 42,108 9.23
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_155893   INDEX 36,908 8.09
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 36,886 8.08

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 54 0.00 0   3 1
dc_constraints 47 46.81 0   47 9
dc_global_oids 1,206,702 0.00 0   4 95
dc_histogram_data 12,807 3.65 0   4 2,580
dc_histogram_defs 78,912 15.26 0   493 17,502
dc_object_grants 1,090 9.82 0   0 342
dc_object_ids 3,519,098 0.06 0   8 4,835
dc_objects 230,115 1.47 0   67 5,726
dc_profiles 791 0.00 0   0 1
dc_rollback_segments 2,710 0.00 0   0 34
dc_segments 71,328 3.35 0   20,597 5,429
dc_sequences 46,859 0.11 0   46,858 74
dc_table_scns 210,668 0.01 0   14 15
dc_tablespace_quotas 21,766 0.16 0   0 39
dc_tablespaces 1,152,035 0.00 0   0 57
dc_usernames 505,169 0.00 0   0 75
dc_users 5,121,591 0.00 0   0 118
outstanding_alerts 454 0.00 0   0 109


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 32,780 1.22 10,131,504 0.01 0 0
CLUSTER 50 0.00 115 0.00 0 0
INDEX 379 9.23 513 9.75 0 0
JAVA DATA 261 1.15 1,044 1.72 0 0
PIPE 378 0.00 378 0.00 0 0
SQL AREA 9,617 94.56 49,241,699 0.33 2 45
TABLE/PROCEDURE 47,003 8.68 15,313,697 0.03 3 0
TRIGGER 1,430 1.12 787,343 -0.13 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 225.15   2.62 6.00 53 53 86 86
  Freeable 53.56 0.00 0.89 1.63 10   60 60
  SQL 13.89 6.75 0.17 0.23 1 3 81 79
  PL/SQL 6.17 2.37 0.07 0.05 0 0 86 86
E Other 215.19   2.50 5.21 45 52 86 86
  Freeable 57.00 0.00 0.97 1.89 10   59 59
  SQL 17.32 8.80 0.21 0.55 5 5 81 79
  PL/SQL 5.97 2.39 0.07 0.04 0 0 86 86

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 24,612,175,872 24,595,398,656
Fixed Size 2,119,344  
Redo Buffers 14,655,488  
Variable Size 1,140,853,072 1,157,630,288

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 16.00 17.15 7.19
java joxlod exec hp   14.18  
java joxs heap   0.67  
large free memory 15.94 15.94 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor   21.75  
shared Heap0: KGL   13.34  
shared KGLS heap 18.68 34.94 87.02
shared KQR M PO   13.98  
shared PCursor   19.40  
shared PL/SQL DIANA   10.80  
shared PL/SQL MPCODE   43.04  
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 634.67 385.49 -39.26
shared ktcmvcb   25.20  
shared library cache 14.01 33.65 140.10
shared sql area 34.45 151.71 340.32
streams free memory 31.99 31.99 0.00
  buffer_cache 23,472.00 23,456.00 -0.07
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.98 13.98 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 15,633,821 19,826 0
QMON Coordinator 30,720 0 0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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

Back to Streams Statistics
Back to Top

Buffered Subscribers

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

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
APPLSYS.WF_DEFERRED_QUEUE_M_R 104,969 0 104,750 1,087 1,191
APPLSYS.FND_CP_GSM_OPP_AQ_R 1 0 0 0 0
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
aq_tm_processes 1   
background_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/bdump   
compatible 10.2.0   
control_files /oracle/visdata/cntrl01.dbf, /oracle/visdata/cntrl02.dbf, /oracle/visdata/cntrl03.dbf   
core_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_file_multiblock_read_count 8   
db_files 512   
db_name VIS   
dml_locks 10000   
hash_area_size 524288   
ifile /oracle/db/tech_st/10.2.0/dbs/VIS_vega7242_ifile.ora   
job_queue_processes 2   
log_buffer 14211072   
log_checkpoint_interval 100000   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size 20480   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 600   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
parallel_min_servers 0   
pga_aggregate_target 4294967296   
plsql_code_type INTERPRETED   
plsql_native_library_dir /oracle/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 200   
session_cached_cursors 500   
sessions 400   
sga_target 25769803776   
shared_pool_reserved_size 104857600   
shared_pool_size 1073741824   
sort_area_size 262144   
timed_statistics TRUE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_vega7242/udump   
utl_file_dir /usr/tmp, /usr/tmp, /oracle/db/tech_st/10.2.0/appsutil/outbound/VIS_vega7242, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report