WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS242183836VIS110.2.0.3.0NOapp0

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:12613-Feb-11 14:04:2777 26.0
End Snap:12713-Feb-11 14:22:5475 26.0
Elapsed:  18.45 (mins)  
DB Time:  158.23 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 10,240M 10,240MStd Block Size: 8K
Shared Pool Size: 2,000M 2,000MLog Buffer: 63,468K

Load Profile

Per SecondPer Transaction
Redo size: 17,638,891.29 31,291.61
Logical reads: 812,749.61 1,441.83
Block changes: 105,801.15 187.69
Physical reads: 86.57 0.15
Physical writes: 1,129.88 2.00
User calls: 164.71 0.29
Parses: 1,808.14 3.21
Hard parses: 0.50 0.00
Sorts: 7,241.10 12.85
Logons: 0.49 0.00
Executes: 38,078.49 67.55
Transactions: 563.69 

% Blocks changed per Read: 13.02Recursive Call %: 99.77
Rollback per transaction %: 0.04Rows per Sort: 2.31

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.78Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.98Soft Parse %: 99.97
Execute to Parse %: 95.25Latch Hit %: 97.79
Parse CPU to Parse Elapsd %: 20.39% Non-Parse CPU: 99.81

Shared Pool Statistics

BeginEnd
Memory Usage %: 34.22 35.19
% SQL with executions>1: 93.47 90.72
% Memory for SQL w/exec>1: 93.52 95.19

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  3,843  40.5 
buffer busy waits 1,989,884 620 0 6.5Concurrency
log file sync 149,052 601 4 6.3Commit
log file parallel write 315,321 290 1 3.1System I/O
db file parallel write 95,289 136 1 1.4System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 9,461.39 99.66
DB CPU 3,843.38 40.48
PL/SQL execution elapsed time 2,445.43 25.76
Java execution elapsed time 315.38 3.32
parse time elapsed 38.86 0.41
sequence load elapsed time 9.42 0.10
repeated bind elapsed time 3.30 0.03
hard parse elapsed time 1.91 0.02
connection management call elapsed time 0.74 0.01
PL/SQL compilation elapsed time 0.18 0.00
hard parse (sharing criteria) elapsed time 0.07 0.00
inbound PL/SQL rpc elapsed time 0.02 0.00
failed parse elapsed time 0.01 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 9,493.76  
background elapsed time 504.90  
background cpu time 31.95  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 2,272,340 0.00 982 0 3.64
Commit 149,052 0.01 601 4 0.24
System I/O 413,188 0.00 429 1 0.66
Application 10,810 0.06 137 13 0.02
User I/O 37,300 0.00 135 4 0.06
Configuration 37,178 0.00 69 2 0.06
Other 317,178 82.02 65 0 0.51
Network 171,224 0.00 0 0 0.27

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
buffer busy waits 1,989,884 0.00 620 0 3.19
log file sync 149,052 0.01 601 4 0.24
log file parallel write 315,321 0.00 290 1 0.51
db file parallel write 95,289 0.00 136 1 0.15
enq: TX - row lock contention 9,292 0.06 136 15 0.01
enq: TX - index contention 44,227 0.00 121 3 0.07
latch: library cache 2,292 0.00 95 42 0.00
latch: cache buffers chains 232,563 0.00 85 0 0.37
db file sequential read 26,323 0.00 76 3 0.04
enq: HW - contention 22,357 0.00 67 3 0.04
db file scattered read 5,041 0.00 35 7 0.01
latch: library cache pin 754 0.00 29 39 0.00
read by other session 4,619 0.00 24 5 0.01
buffer deadlock 262,385 99.08 18 0 0.42
latch: In memory undo latch 462 0.00 16 34 0.00
enq: TX - contention 12,880 0.00 14 1 0.02
latch: row cache objects 169 0.00 8 49 0.00
latch: redo allocation 487 0.00 6 12 0.00
latch: library cache lock 118 0.00 5 40 0.00
latch: session allocation 138 0.00 5 33 0.00
latch free 83 0.00 4 54 0.00
latch: undo global data 229 0.00 4 18 0.00
LGWR wait for redo copy 36,441 0.42 4 0 0.06
PX Deq Credit: send blkd 1,139 0.00 4 3 0.00
enq: FB - contention 2,976 0.00 3 1 0.00
latch: cache buffers lru chain 135 0.00 3 19 0.00
enq: SQ - contention 14,688 0.00 2 0 0.02
latch: shared pool 121 0.00 2 15 0.00
control file parallel write 571 0.00 2 3 0.00
control file sequential read 2,007 0.00 1 1 0.00
latch: enqueue hash chains 25 0.00 1 33 0.00
os thread startup 31 0.00 1 25 0.00
SQL*Net break/reset to client 1,488 0.00 1 0 0.00
kksfbc child completion 8 100.00 0 49 0.00
local write wait 55 0.00 0 5 0.00
library cache lock 18 0.00 0 12 0.00
enq: RO - fast object reuse 30 0.00 0 7 0.00
row cache lock 1,637 0.00 0 0 0.00
library cache pin 64 0.00 0 3 0.00
SQL*Net more data to client 9,586 0.00 0 0 0.02
enq: TX - allocate ITL entry 124 0.00 0 1 0.00
direct path read 1,002 0.00 0 0 0.00
latch: redo writing 9 0.00 0 12 0.00
latch: checkpoint queue latch 6 0.00 0 16 0.00
latch: object queue header operation 18 0.00 0 5 0.00
enq: US - contention 5 0.00 0 18 0.00
SQL*Net message to client 153,946 0.00 0 0 0.25
SQL*Net more data from client 7,692 0.00 0 0 0.01
direct path write 259 0.00 0 0 0.00
PX Deq: Signal ACK 10 50.00 0 0 0.00
reliable message 33 0.00 0 0 0.00
PX Deq: Table Q Get Keys 12 0.00 0 0 0.00
db file single write 1 0.00 0 0 0.00
kkdlgon 2 0.00 0 0 0.00
PX qref latch 159 13.84 0 0 0.00
PX Deq: Table Q qref 6 0.00 0 0 0.00
enq: PS - contention 1 0.00 0 0 0.00
SQL*Net message from client 153,948 0.00 31,358 204 0.25
PX Idle Wait 1,799 98.89 3,466 1927 0.00
Streams AQ: qmn slave idle wait 582 0.17 2,763 4748 0.00
Streams AQ: waiting for messages in the queue 413 82.81 2,293 5553 0.00
PL/SQL lock timer 225 98.67 1,204 5351 0.00
Streams AQ: qmn coordinator idle wait 383 43.34 1,082 2824 0.00
pipe get 294 100.00 1,074 3652 0.00
Streams AQ: waiting for time management or cleanup tasks 30 36.67 793 26424 0.00
jobq slave wait 189 100.00 554 2931 0.00
PX Deq: Execution Msg 430 2.33 32 74 0.00
PX Deq: Table Q Normal 1,481 0.00 0 0 0.00
PX Deq: Execute Reply 191 0.00 0 1 0.00
PX Deq: Msg Fragment 76 0.00 0 0 0.00
PX Deq: Parse Reply 14 0.00 0 1 0.00
PX Deq: Table Q Sample 9 0.00 0 1 0.00
PX Deq Credit: need buffer 304 0.00 0 0 0.00
PX Deq: Join ACK 12 0.00 0 0 0.00
class slave wait 1 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 315,321 0.00 290 1 0.51
db file parallel write 95,289 0.00 136 1 0.15
events in waitclass Other 36,591 0.42 5 0 0.06
control file parallel write 571 0.00 2 3 0.00
control file sequential read 313 0.00 1 3 0.00
os thread startup 19 0.00 1 29 0.00
latch: redo writing 9 0.00 0 12 0.00
latch: library cache 3 0.00 0 15 0.00
direct path write 240 0.00 0 0 0.00
buffer busy waits 33 0.00 0 1 0.00
latch: cache buffers chains 6 0.00 0 3 0.00
latch: shared pool 1 0.00 0 9 0.00
direct path read 990 0.00 0 0 0.00
db file single write 1 0.00 0 0 0.00
rdbms ipc message 210,177 1.77 9,854 47 0.34
Streams AQ: qmn slave idle wait 196 0.00 1,216 6206 0.00
smon timer 1,742 0.00 1,129 648 0.00
Streams AQ: qmn coordinator idle wait 383 43.34 1,082 2824 0.00
pmon timer 427 99.77 1,080 2529 0.00
Streams AQ: waiting for time management or cleanup tasks 30 36.67 793 26424 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 62,883
AVG_IDLE_TIME 48,059
AVG_IOWAIT_TIME 819
AVG_SYS_TIME 2,302
AVG_USER_TIME 60,543
BUSY_TIME 754,979
IDLE_TIME 577,129
IOWAIT_TIME 10,130
SYS_TIME 28,006
USER_TIME 726,973
LOAD 0
OS_CPU_WAIT_TIME 919,300
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,017,561,088
NUM_CPUS 12
NUM_CPU_CORES 6

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
VIS 9,482.60 3,840.00 63,264 895,345,434
SYS$USERS 11.10 3.30 349 1,633,585
SYS$BACKGROUND 0.00 0.00 32,250 2,973,894

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
VIS 22466 12404 2271260 98167 0 0 169716 27
SYS$USERS 420 75 4 2 0 0 52 0
SYS$BACKGROUND 14414 1051 62 65 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 IdSQL ModuleSQL Text
3,029 921 10 302.87 31.90 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
2,724 1,364 24 113.50 28.69 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
1,608 485 100 16.08 16.94 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
956 269 49,963 0.02 10.07 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
657 334 14 46.93 6.92 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
420 266 149,600 0.00 4.42 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
419 395 49,588 0.01 4.42 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
402 196 14 28.75 4.24 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
305 301 49,986 0.01 3.21 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
299 250 203,106 0.00 3.15 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
277 275 49,389 0.01 2.92 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
274 164 49,985 0.01 2.89 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
212 152 939,444 0.00 2.23 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
184 68 5,516 0.03 1.94 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
160 57 5,515 0.03 1.69 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
160 160 599,974 0.00 1.69 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
157 71 149,909 0.00 1.65 33838u0xy9fk9 WSHPSGL_SUB INSERT INTO MTL_MATERIAL_TRAN...
147 116 1,309,687 0.00 1.54 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
146 73 24 6.09 1.54 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
133 16 112 1.19 1.40 1p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...
109 65 12 9.12 1.15 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
108 73 3 35.84 1.13 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
106 97 149,969 0.00 1.12 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...

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 IdSQL ModuleSQL Text
1,364 2,724 24 56.81 28.69 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
921 3,029 10 92.09 31.90 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
485 1,608 100 4.85 16.94 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
395 419 49,588 0.01 4.42 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
334 657 14 23.83 6.92 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
301 305 49,986 0.01 3.21 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
275 277 49,389 0.01 2.92 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
269 956 49,963 0.01 10.07 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
266 420 149,600 0.00 4.42 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
250 299 203,106 0.00 3.15 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
196 402 14 13.99 4.24 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
164 274 49,985 0.00 2.89 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
160 160 599,974 0.00 1.69 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
152 212 939,444 0.00 2.23 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
116 147 1,309,687 0.00 1.54 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
97 106 149,969 0.00 1.12 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
73 146 24 3.06 1.54 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
73 108 3 24.23 1.13 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
71 157 149,909 0.00 1.65 33838u0xy9fk9 WSHPSGL_SUB INSERT INTO MTL_MATERIAL_TRAN...
68 184 5,516 0.01 1.94 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
65 109 12 5.38 1.15 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
57 160 5,515 0.01 1.69 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
16 133 112 0.14 1.40 1p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
392,211,751 24 16,342,156.29 43.58 1363.54 2724.07 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
121,440,555 14 8,674,325.36 13.49 333.68 657.07 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
113,532,834 10 11,353,283.40 12.62 920.92 3028.73 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
87,211,101 100 872,111.01 9.69 485.34 1608.36 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
66,542,606 599,974 110.91 7.39 160.14 160.17 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
33,957,979 14 2,425,569.93 3.77 195.83 402.45 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
32,541,859 49,986 651.02 3.62 300.53 304.84 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
31,411,416 1,309,687 23.98 3.49 116.20 146.65 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
28,468,075 939,444 30.30 3.16 151.78 211.57 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
28,243,136 24 1,176,797.33 3.14 73.33 146.08 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
26,076,231 149,600 174.31 2.90 265.86 419.96 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
25,316,242 5,516 4,589.60 2.81 67.75 184.16 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
24,872,364 49,963 497.82 2.76 268.63 955.98 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
22,760,443 98,785 230.40 2.53 73.41 80.14 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
22,221,279 5,515 4,029.24 2.47 56.76 160.46 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
20,293,672 49,588 409.25 2.25 394.55 419.26 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
15,309,653 12 1,275,804.42 1.70 64.57 109.48 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
14,510,242 3 4,836,747.33 1.61 72.69 107.53 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
13,531,787 2 6,765,893.50 1.50 57.87 81.54 6abn0zw8kkvtk RAXTRX begin arp_etax_autoinv_util . ...
12,574,402 54,469 230.85 1.40 60.65 66.26 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
11,211,029 415,841 26.96 1.25 35.47 42.40 f34wj84pszqj0 OEHVIMP SELECT WI.ROOT_ACTIVITY, WI.R...
10,415,317 594,822 17.51 1.16 58.84 71.37 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
9,523,256 49,389 192.82 1.06 274.53 277.00 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
22,213 24 925.54 23.17 1363.54 2724.07 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
9,185 12 765.42 9.58 64.57 109.48 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
5,549 14 396.36 5.79 333.68 657.07 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
3,601 98,785 0.04 3.76 73.41 80.14 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
2,757 49,829 0.06 2.88 11.93 16.39 03frm3304ubbu WSHPSGL_SUB INSERT INTO MTL_RESERVATIONS (...
2,549 14 182.07 2.66 195.83 402.45 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
2,320 149,909 0.02 2.42 71.35 156.60 33838u0xy9fk9 WSHPSGL_SUB INSERT INTO MTL_MATERIAL_TRAN...
1,994 10 199.40 2.08 920.92 3028.73 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,700 3 566.67 1.77 72.69 107.53 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
1,255 49,588 0.03 1.31 394.55 419.26 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
1,230 48,636 0.03 1.28 13.73 27.35 37g4kfmk19h5g FNDWFBG INSERT INTO RA_INTERFACE_LINES...
984 99,852 0.01 1.03 4.07 5.68 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,309,687 775,943 0.59 0.00 0.00 66tmsr3446uqn OEHVIMP SELECT WIAS.ACTIVITY_STATUS, ...
939,444 938,050 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
599,974 49,987 0.08 0.00 0.00 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
594,822 594,643 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
415,841 357,569 0.86 0.00 0.00 f34wj84pszqj0 OEHVIMP SELECT WI.ROOT_ACTIVITY, WI.R...
388,120 390,345 1.01 0.00 0.00 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A...
203,106 201,375 0.99 0.00 0.00 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
199,674 199,082 1.00 0.00 0.00 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,517 197,943 0.99 0.00 0.00 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,969 149,921 1.00 0.00 0.00 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
199,745 199,674 9.98 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,337 199,517 9.96 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,499 149,969 7.47 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
100,067 99,142 5.00 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
99,547 99,852 4.97 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
59,999 59,788 3.00 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
59,996 59,604 3.00 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
59,990 59,881 3.00 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
59,990 59,882 3.00 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
52,814 54,469 2.64 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
50,024 49,721 2.50 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
50,015 49,654 2.50 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
50,000 49,967 2.50 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO...
50,000 49,991 2.50 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN...
50,000 49,950 2.50 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
49,999 49,808 2.50 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
49,999 49,969 2.50 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI...
49,998 49,963 2.50 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
49,993 49,588 2.50 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
49,900 49,972 2.49 bsuw7pmwrufpy INCTCW SELECT reservation_...
48,797 49,693 2.44 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
47,995 49,389 2.40 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
45,318 45,314 2.26 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
44,983 44,896 2.25 2skwhauh2cwky   select o.name, u.name from ob...
44,868 44,807 2.24 7gtztzv329wg0   select c.name, u.name from co...
20,466 20,466 1.02 bsa0wjtftg3uw   select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,151,072 203,106 0.20 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
2,074,676 12 0.10 cdkb9h9mhux7s INCTCM update MTL_TRANSACTIONS_INTERF...
1,407,558 1,271 0.07 fxz0vtz7p7vy2 STANDARD@app0 (TNS V1-V3) SELECT R.Conc_Login_Id, R.Req...
1,358,303 12 0.06 03s61gtq86zy3 INCTCM update MTL_MATERIAL_TRANSACTIO...
1,266,806 99,956 0.06 fuvc2825ycjfm WSHPSGL_SUB SELECT * FROM MTL_MATERIAL_TRA...
1,124,102 1,271 0.05 fxz0vtz7p7vy2 STANDARD@app0 (TNS V1-V3) SELECT R.Conc_Login_Id, R.Req...
1,094,791 49,999 0.05 869nd7cqgy7b7 WSHPSGL_SUB UPDATE MTL_MATERIAL_TRANSACTIO...

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 IdSQL Text
0074pdmwb7fmvBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
03frm3304ubbu INSERT INTO MTL_RESERVATIONS ( RESERVATION_ID , REQUIREMENT_DATE , ORGANIZATION_ID , INVENTORY_ITEM_ID , DEMAND_SOURCE_TYPE_ID , DEMAND_SOURCE_NAME , DEMAND_SOURCE_HEADER_ID , DEMAND_SOURCE_LINE_ID , DEMAND_SOURCE_DELIVERY , PRIMARY_UOM_CODE , PRIMARY_UOM_ID , SECONDARY_UOM_CODE , SECONDARY_UOM_ID , RESERVATION_UOM_CODE , RESERVATION_UOM_ID , RESERVATION_QUANTITY , PRIMARY_RESERVATION_QUANTITY , SECONDARY_RESERVATION_QUANTITY , DETAILED_QUANTITY , SECONDARY_DETAILED_QUANTITY , AUTODETAIL_GROUP_ID , EXTERNAL_SOURCE_CODE , EXTERNAL_SOURCE_LINE_ID , SUPPLY_SOURCE_TYPE_ID , SUPPLY_SOURCE_HEADER_ID , SUPPLY_SOURCE_LINE_ID , SUPPLY_SOURCE_LINE_DETAIL , SUPPLY_SOURCE_NAME , REVISION , SUBINVENTORY_CODE , SUBINVENTORY_ID , LOCATOR_ID , LOT_NUMBER , LOT_NUMBER_ID , SERIAL_NUMBER , SERIAL_NUMBER_ID , PARTIAL_QUANTITIES_ALLOWED , AUTO_DETAILED , PICK_SLIP_NUMBER , LPN_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , SHIP_READY_FLAG , STAGED_FLAG , CROSSDOCK_FLAG , CROSSDOCK_CRITERIA_ID , DEMAND_SOURCE_LINE_DETAIL , SERIAL_RESERVATION_QUANTITY , SUPPLY_RECEIPT_DATE , DEMAND_SHIP_DATE , PROJECT_ID , TASK_ID , ORIG_SUPPLY_SOURCE_TYPE_ID , ORIG_SUPPL Y_SOURCE_HEADER_ID , ORIG_SUPPLY_SOURCE_LINE_ID , ORIG_SUPPLY_SOURCE_LINE_DETAIL , ORIG_DEMAND_SOURCE_TYPE_ID , ORIG_DEMAND_SOURCE_HEADER_ID , ORIG_DEMAND_SOURCE_LINE_ID , ORIG_DEMAND_SOURCE_LINE_DETAIL ) VALUES ( NVL(:B83 , MTL_DEMAND_S.NEXTVAL) , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )RETURNING RESERVATION_ID INTO :O0
03s61gtq86zy3update MTL_MATERIAL_TRANSACTIONS_TEMP MMTT set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG='Y', ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG='Y' and NVL(TRANSACTION_STATUS, 1) in (1, 3)) and NVL(LOCK_FLAG, 'N')='N') and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MMTT.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
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;
0r0gvtarcjwzzinsert 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)
0z318y6g3uagcdeclare 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
1p2p9fdwaujpvupdate MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID in (2, 8, 16)))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
1v818hwxjxy58select 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
1wnq9qthbb54qBEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
2skwhauh2cwkyselect o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
33838u0xy9fk9 INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , COST_U PDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOVEMENT_ID, SOUR CE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, LOGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE, TRANSFER_PRICE, COSTED_FLAG, OPM_COSTED_FLAG ) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, ROUND(:75, 5), :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, Decode(:149, 'D', 'N', NULL), DECODE(:150, 'O', 'N', NULL))
37g4kfmk19h5g INSERT INTO RA_INTERFACE_LINES_ALL (CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , INTERFACE_LINE_ATTRIBUTE1 , INTERFACE_LINE_ATTRIBUTE2 , INTERFACE_LINE_ATTRIBUTE3 , INTERFACE_LINE_ATTRIBUTE4 , INTERFACE_LINE_ATTRIBUTE5 , INTERFACE_LINE_ATTRIBUTE6 , INTERFACE_LINE_ATTRIBUTE7 , INTERFACE_LINE_ATTRIBUTE8 , INTERFACE_LINE_ATTRIBUTE9 , INTERFACE_LINE_ATTRIBUTE10 , INTERFACE_LINE_ATTRIBUTE11 , INTERFACE_LINE_ATTRIBUTE12 , INTERFACE_LINE_ATTRIBUTE13 , INTERFACE_LINE_ATTRIBUTE14 , INTERFACE_LINE_ATTRIBUTE15 , INTERFACE_LINE_ID , INTERFACE_LINE_CONTEXT , WAREHOUSE_ID , BATCH_SOURCE_NAME , SET_OF_BOOKS_ID , LINE_TYPE , DESCRIPTION , CURRENCY_CODE , AMOUNT , CONVERSION_TYPE , CONVERSION_DATE , CONVERSION_RATE , CUST_TRX_TYPE_NAME , CUST_TRX_TYPE_ID , TERM_NAME , TERM_ID , ORIG_SYSTEM_BILL_CUSTOMER_REF , ORIG_SYSTEM_BILL_CUSTOMER_ID , ORIG_SYSTEM_BILL_ADDRESS_REF , ORIG_SYSTEM_BILL_ADDRESS_ID , ORIG_SYSTEM_BILL_CONTACT_REF , ORIG_SYSTEM_BILL_CONTACT_ID , ORIG_SYSTEM_SHIP_CUSTOMER_REF , ORIG_SYSTEM_SHIP_CUSTOMER_ID , ORIG_SYSTEM_SHIP_ADDRESS_REF , ORIG_SYSTEM_SHIP_ADDRESS_ID , ORIG_SYSTEM_SHIP_CONTACT_REF , ORIG_SYSTEM_SHIP_CONTACT_ID , ORIG_SYSTEM_SOLD_CUSTOMER_REF , ORIG_SYSTEM_SOLD_CUSTOMER_ID , LINK_TO_LINE_ID , LINK_TO_LINE_CONTEXT , LINK_TO_LINE_ATTRIBUTE1 , LINK_TO_LINE_ATTRIBUTE2 , LINK_TO_LINE_ATTRIBUTE3 , LINK_TO_LINE_ATTRIBUTE4 , LINK_TO_LINE_ATTRIBUTE5 , LINK_TO_LINE_ATTRIBUTE6 , LINK_TO_LINE_ATTRIBUTE7 , LINK_TO_LINE_ATTRIBUTE8 , LINK_TO_LINE_ATTRIBUTE9 , LINK_TO_LINE_ATTRIBUTE10 , LINK_TO_LINE_ATTRIBUTE11 , LINK_TO_LINE_ATTRIBUTE12 , LINK_TO_LINE_ATTRIBUTE13 , LINK_TO_LINE_ATTRIBUTE14 , LINK_TO_LINE_ATTRIBUTE15 , RECEIPT_METHOD_NAME , RECEIPT_METHOD_ID , CUSTOMER_TRX_ID , TRX_DATE , GL_DATE , DOCUMENT_NUMBER , DOCUMENT_NUMBER_SEQUENCE_ID , TRX_NUMBER , QUANTITY , QUANTITY_ORDERED , UNIT_SELLING_PRICE , UNIT_STANDARD_PRICE , UOM_CODE , UOM_NAME , PRINTING_OPTION , INTERFACE_STATUS , REQUEST_ID , RELATED_BATCH_SOURCE_NAME , RELATED_TRX_NUMBER , RELATED_CUSTOMER_TRX_ID , PREVIOUS_CUSTOMER_TRX_ID , INITIAL_CUSTOMER_TRX_ID , CREDIT_METHOD_FOR_ACCT_RULE , CREDIT_METHOD_FOR_INSTALLMENTS , REASON_CODE_MEANING , REASON_CODE , TAX_RATE , TAX_CODE , TAX_PRECEDENCE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , EXCEPTION_ID , EXEMPTION_ID , SHIP_DATE_ACTUAL , FOB_POINT , SHIP_VIA , WAYBILL_NUMBER , INVOICING_RULE_NAME , INVOICING_RULE_ID , ACCOUNTING_RULE_NAME , ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , RULE_START_DATE , RULE_END_DATE , PRIMARY_SALESREP_NUMBER , PRIMARY_SALESREP_ID , SALES_ORDER , SALES_ORDER_LINE , SALES_ORDER_DATE , SALES_ORDER_SOURCE , SALES_ORDER_REVISION , PURCHASE_ORDER , PURCHASE_ORDER_REVISION , PURCHASE_ORDER_DATE , AGREEMENT_NAME , AGREEMENT_ID , MEMO_LINE_NAME , MEMO_LINE_ID , INVENTORY_ITEM_ID , MTL_SYSTEM_ITEMS_SEG1 , MTL_SYSTEM_ITEMS_SEG2 , MTL_SYSTEM_ITEMS_SEG3 , MTL_SYSTEM_ITEMS_SEG4 , MTL_SYSTEM_ITEMS_SEG5 , MTL_SYSTEM_ITEMS_SEG6 , MTL_SYSTEM_ITEMS_SEG7 , MTL_SYSTEM_ITEMS_SEG8 , MTL_SYSTEM_ITEMS_SEG9 , MTL_SYSTEM_ITEMS_SEG10 , MTL_SYSTEM_ITEMS_SEG11 , MTL_SYSTEM_ITEMS_SEG12 , MTL_SYSTEM_ITEMS_SEG13 , MTL_SYSTEM_ITEMS_SEG14 , MTL_SYSTEM_ITEMS_SEG15 , MTL_SYSTEM_ITEMS_SEG16 , MTL_SYSTEM_ITEMS_SEG17 , MTL_SYSTEM_ITEMS_SEG18 , MTL_SYSTEM_ITEMS_SEG19 , MTL_SYSTEM_ITEMS_SEG20 , REFERENCE_LINE_ID , REFERENCE_LINE_CONTEXT , REFERENCE_LINE_ATTRIBUTE1 , REFERENCE_LINE_ATTRIBUTE2 , REFERENCE_LINE_ATTRIBUTE3 , REFERENCE_LINE_ATTRIBUTE4 , REFERENCE_LINE_ATTRIBUTE5 , REFERENCE_LINE_ATTRIBUTE6 , REFERENCE_LINE_ATTRIBUTE7 , REFERENCE_LINE_ATTRIBUTE8 , REFERENCE_LINE_ATTRIBUTE9 , REFERENCE_LINE_ATTRIBUTE10 , REFERENCE_LINE_ATTRIBUTE11 , REFERENCE_LINE_ATTRIBUTE12 , REFERENCE_LINE_ATTRIBUTE13 , REFERENCE_LINE_ATTRIBUTE14 , REFERENCE_LINE_ATTRIBUTE15 , TERRITORY_ID , TERRITORY_SEGMENT1 , TERRITORY_SEGMENT2 , TERRITORY_SEGMENT3 , TERRITORY_SEGMENT4 , TERRITORY_SEGMENT5 , TERRITORY_SEGMENT6 , TERRITORY_SEGMENT7 , TERRITORY_SEGMENT8 , TERRITORY_SEGMENT9 , TERRITORY_SEGMENT10 , TERRITORY_SEGMENT11 , TERRITORY_SEGMENT12 , TERRITORY_SEGMENT13 , TERRITORY_SEGMENT14 , TERRITORY_SEGMENT15 , TERRITORY_SEGMENT16 , TERRITORY_SEGMENT17 , TERRITORY_SEGMENT18 , TERRITORY_SEGMENT19 , TERRITORY_SEGMENT20 , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , HEADER_ATTRIBUTE_CATEGORY , HEADER_ATTRIBUTE1 , HEADER_ATTRIBU TE2 , HEADER_ATTRIBUTE3 , HEADER_ATTRIBUTE4 , HEADER_ATTRIBUTE5 , HEADER_ATTRIBUTE6 , HEADER_ATTRIBUTE7 , HEADER_ATTRIBUTE8 , HEADER_ATTRIBUTE9 , HEADER_ATTRIBUTE10 , HEADER_ATTRIBUTE11 , HEADER_ATTRIBUTE12 , HEADER_ATTRIBUTE13 , HEADER_ATTRIBUTE14 , HEADER_ATTRIBUTE15 , COMMENTS , INTERNAL_NOTES , MOVEMENT_ID , ORG_ID , HEADER_GDF_ATTR_CATEGORY , HEADER_GDF_ATTRIBUTE1 , HEADER_GDF_ATTRIBUTE2 , HEADER_GDF_ATTRIBUTE3 , HEADER_GDF_ATTRIBUTE4 , HEADER_GDF_ATTRIBUTE5 , HEADER_GDF_ATTRIBUTE6 , HEADER_GDF_ATTRIBUTE7 , HEADER_GDF_ATTRIBUTE8 , HEADER_GDF_ATTRIBUTE9 , HEADER_GDF_ATTRIBUTE10 , HEADER_GDF_ATTRIBUTE11 , HEADER_GDF_ATTRIBUTE12 , HEADER_GDF_ATTRIBUTE13 , HEADER_GDF_ATTRIBUTE14 , HEADER_GDF_ATTRIBUTE15 , HEADER_GDF_ATTRIBUTE16 , HEADER_GDF_ATTRIBUTE17 , HEADER_GDF_ATTRIBUTE18 , HEADER_GDF_ATTRIBUTE19 , HEADER_GDF_ATTRIBUTE20 , HEADER_GDF_ATTRIBUTE21 , HEADER_GDF_ATTRIBUTE22 , HEADER_GDF_ATTRIBUTE23 , HEADER_GDF_ATTRIBUTE24 , HEADER_GDF_ATTRIBUTE25 , HEADER_GDF_ATTRIBUTE26 , HEADER_GDF_ATTRIBUTE27 , HEADER_GDF_ATTRIBUTE28 , HEADER_GDF_ATTRIBUTE29 , HEADER_GDF_ATTRIBUTE30 , LINE_GDF_ATTR_CATEGORY , LINE_GDF_ATTRIBUTE1 , LINE_GDF_ATTRIBUTE2 , LINE_GDF_ATTRIBUTE3 , LINE_GDF_ATTRIBUTE4 , LINE_GDF_ATTRIBUTE5 , LINE_GDF_ATTRIBUTE6 , LINE_GDF_ATTRIBUTE7 , LINE_GDF_ATTRIBUTE8 , LINE_GDF_ATTRIBUTE9 , LINE_GDF_ATTRIBUTE10 , LINE_GDF_ATTRIBUTE11 , LINE_GDF_ATTRIBUTE12 , LINE_GDF_ATTRIBUTE13 , LINE_GDF_ATTRIBUTE14 , LINE_GDF_ATTRIBUTE15 , LINE_GDF_ATTRIBUTE16 , LINE_GDF_ATTRIBUTE17 , LI NE_GDF_ATTRIBUTE18 , LINE_GDF_ATTRIBUTE19 , LINE_GDF_ATTRIBUTE20 , TRANSLATED_DESCRIPTION , PAYMENT_TRXN_EXTENSION_ID , PARENT_LINE_ID , DEFERRAL_EXCLUSION_FLAG ) VALUES ( :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B154 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING ROWID INTO :O0
3b3psftuyks81BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfkBEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52zwqr7xyrc2mSELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT
54tkzbnhn8gapDELETE FROM MTL_SERIAL_NUMBERS_TEMP WHERE TRANSACTION_TEMP_ID IN ( SELECT TRANSACTION_TEMP_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :B2 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:B1, -1) AND PROCESS_FLAG ='Y' AND NVL(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 AND NOT (TRANSACTION_SOURCE_TYPE_ID IN (2, 8) AND TRANSACTION_ACTION_ID = 28 AND ABS(PRIMARY_QUANTITY) <> 1) UNION ALL SELECT MTLT.SERIAL_TRANSACTION_TEMP_ID FROM MTL_TRANSACTION_LOTS_TEMP MTLT WHERE MTLT.TRANSACTION_TEMP_ID IN ( SELECT MMTT.TRANSACTION_TEMP_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.TRANSACTION_HEADER_ID = :B4 AND NVL(MMTT.TRANSACTION_BATCH_ID, -1)=NVL(:B3, -1) AND MMTT.PROCESS_FLAG ='Y' AND NVL(MMTT.ERROR_CODE, '@@') = '@@' AND NVL(MMTT.TRANSACTION_STATUS, 1) <> 2 AND NOT (MMTT.TRANSACTION_SOURCE_TYPE_ID IN (2, 8) AND MMTT.TRANSACTION_ACTION_ID = 28 AND ABS(MTLT.PRIMARY_QUANTITY) <> 1)))
5t39uchjqpyfmBEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
66tmsr3446uqnSELECT 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
6abn0zw8kkvtkbegin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ;
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
72yyswsqkzkrmBEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89jbegin 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
7gtztzv329wg0select 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#
7mrs575bj7a41begin 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
7ptvbaycjtbg4BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
869nd7cqgy7b7 UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP SET TRANSACTION_HEADER_ID = :B176 , SOURCE_CODE = :B175 , SOURCE_LINE_ID = :B174 , TRANSACTION_MODE = :B173 , LOCK_FLAG = :B172 , LAST_UPDATE_DATE = :B171 , LAST_UPDATED_BY = :B170 , CREATION_DATE = :B169 , CREATED_BY = :B168 , LAST_UPDATE_LOGIN = :B167 , REQUEST_ID = :B166 , PROGRAM_APPLICATION_ID = :B165 , PROGRAM_ID = :B164 , PROGRAM_UPDATE_DATE = :B163 , INVENTORY_ITEM_ID = :B162 , REVISION = :B161 , ORGANIZATION_ID = :B160 , SUBINVENTORY_CODE = :B159 , LOCATOR_ID = :B158 , TRANSACTION_QUANTITY = :B157 , PRIMARY_QUANTITY = :B156 , TRANSACTION_UOM = :B155 , TRANSACTION_COST = :B154 , TRANSACTION_TYPE_ID = :B153 , TRANSACTION_ACTION_ID = :B152 , TRANSACTION_SOURCE_TYPE_ID = :B151 , TRANSACTION_SOURCE_ID = :B150 , TRANSACTION_SOURCE_NAME = :B149 , TRANSACTION_DATE = :B148 , ACCT_PERIOD_ID = :B147 , DISTRIBUTION_ACCOUNT_ID = :B146 , TRANSACTION_REFERENCE = :B145 , REQUISITION_LINE_ID = :B144 , REQUISITION_DISTRIBUTION_ID = :B143 , REASON_ID = :B142 , LOT_NUMBER = :B141 , LOT_EXPIRATION_DATE = :B140 , SERIAL_NUMBER = :B139 , RECEIVING_DOCUMENT = :B138 , DEMAND_ID = :B137 , RCV_TRANSACTION_ID = :B136 , MOVE_TRANSACTION_ID = :B135 , COMPLETION_TRANSACTION_ID = :B134 , WIP_ENTITY_TYPE = :B133 , SCHEDULE_ID = :B132 , REPETITIVE_LINE_ID = :B131 , EMPLOYEE_CODE = :B130 , PRIMARY_SWITCH = :B129 , SCHEDULE_UPDATE_CODE = :B128 , SETUP_TEARDOWN_CODE = :B127 , ITEM_ORDERING = :B126 , NEGATIVE_REQ_FLA G = :B125 , OPERATION_SEQ_NUM = :B124 , PICKING_LINE_ID = :B123 , TRX_SOURCE_LINE_ID = :B122 , TRX_SOURCE_DELIVERY_ID = :B121 , PHYSICAL_ADJUSTMENT_ID = :B120 , CYCLE_COUNT_ID = :B119 , RMA_LINE_ID = :B118 , CUSTOMER_SHIP_ID = :B117 , CURRENCY_CODE = :B116 , CURRENCY_CONVERSION_RATE = :B115 , CURRENCY_CONVERSION_TYPE = :B114 , CURRENCY_CONVERSION_DATE = :B113 , USSGL_TRANSACTION_CODE = :B112 , VENDOR_LOT_NUMBER = :B111 , ENCUMBRANCE_ACCOUNT = :B110 , ENCUMBRANCE_AMOUNT = :B109 , SHIP_TO_LOCATION = :B108 , SHIPMENT_NUMBER = :B107 , TRANSFER_COST = :B106 , TRANSPORTATION_COST = :B105 , TRANSPORTATION_ACCOUNT = :B104 , FREIGHT_CODE = :B103 , CONTAINERS = :B102 , WAYBILL_AIRBILL = :B101 , EXPECTED_ARRIVAL_DATE = :B100 , TRANSFER_SUBINVENTORY = :B99 , TRANSFER_ORGANIZATION = :B98 , TRANSFER_TO_LOCATION = :B97 , NEW_AVERAGE_COST = :B96 , VALUE_CHANGE = :B95 , PERCENTAGE_CHANGE = :B94 , MATERIAL_ALLOCATION_TEMP_ID = :B93 , DEMAND_SOURCE_HEADER_ID = :B92 , DEMAND_SOURCE_LINE = :B91 , DEMAND_SOURCE_DELIVERY = :B90 , ITEM_SEGMENTS = :B89 , ITEM_DESCRIPTION = :B88 , ITEM_TRX_ENABLED_FLAG = :B87 , ITEM_LOCATION_CONTROL_CODE = :B86 , ITEM_RESTRICT_SUBINV_CODE = :B85 , ITEM_RESTRICT_LOCATORS_CODE = :B84 , ITEM_REVISION_QTY_CONTROL_CODE = :B83 , ITEM_PRIMARY_UOM_CODE = :B82 , ITEM_UOM_CLASS = :B81 , ITEM_SHELF_LIFE_CODE = :B80 , ITEM_SHELF_LIFE_DAYS = :B79 , ITEM_LOT_CONTROL_CODE = :B78 , ITEM_SERIAL_CONTROL_CODE = :B77 , ITEM_INVENTORY_ASSET _FLAG = :B76 , ALLOWED_UNITS_LOOKUP_CODE = :B75 , DEPARTMENT_ID = :B74 , DEPARTMENT_CODE = :B73 , WIP_SUPPLY_TYPE = :B72 , SUPPLY_SUBINVENTORY = :B71 , SUPPLY_LOCATOR_ID = :B70 , VALID_SUBINVENTORY_FLAG = :B69 , VALID_LOCATOR_FLAG = :B68 , LOCATOR_SEGMENTS = :B67 , CURRENT_LOCATOR_CONTROL_CODE = :B66 , NUMBER_OF_LOTS_ENTERED = :B65 , WIP_COMMIT_FLAG = :B64 , NEXT_LOT_NUMBER = :B63 , LOT_ALPHA_PREFIX = :B62 , NEXT_SERIAL_NUMBER = :B61 , SERIAL_ALPHA_PREFIX = :B60 , SHIPPABLE_FLAG = :B59 , POSTING_FLAG = :B58 , REQUIRED_FLAG = :B57 , PROCESS_FLAG = :B56 , ERROR_CODE = :B55 , ERROR_EXPLANATION = :B54 , MOVEMENT_ID = :B53 , RESERVATION_QUANTITY = :B52 , SHIPPED_QUANTITY = :B51 , TRANSACTION_LINE_NUMBER = :B50 , TASK_ID = :B49 , TO_TASK_ID = :B48 , SOURCE_TASK_ID = :B47 , PROJECT_ID = :B46 , SOURCE_PROJECT_ID = :B45 , PA_EXPENDITURE_ORG_ID = :B44 , TO_PROJECT_ID = :B43 , EXPENDITURE_TYPE = :B42 , FINAL_COMPLETION_FLAG = :B41 , TRANSFER_PERCENTAGE = :B40 , TRANSACTION_SEQUENCE_ID = :B39 , MATERIAL_ACCOUNT = :B38 , MATERIAL_OVERHEAD_ACCOUNT = :B37 , RESOURCE_ACCOUNT = :B36 , OUTSIDE_PROCESSING_ACCOUNT = :B35 , OVERHEAD_ACCOUNT = :B34 , FLOW_SCHEDULE = :B33 , COST_GROUP_ID = :B32 , DEMAND_CLASS = :B31 , QA_COLLECTION_ID = :B30 , KANBAN_CARD_ID = :B29 , OVERCOMPLETION_TRANSACTION_ID = :B28 , OVERCOMPLETION_PRIMARY_QTY = :B27 , OVERCOMPLETION_TRANSACTION_QTY = :B26 , END_ITEM_UNIT_NUMBER = :B25 , SCHEDULED_PAYBACK_DATE = :B24 , LINE_ TYPE_CODE = :B23 , PARENT_TRANSACTION_TEMP_ID = :B22 , PUT_AWAY_STRATEGY_ID = :B21 , PUT_AWAY_RULE_ID = :B20 , PICK_STRATEGY_ID = :B19 , PICK_RULE_ID = :B18 , COMMON_BOM_SEQ_ID = :B17 , COMMON_ROUTING_SEQ_ID = :B16 , COST_TYPE_ID = :B15 , ORG_COST_GROUP_ID = :B14 , MOVE_ORDER_LINE_ID = :B2 , TASK_GROUP_ID = :B13 , PICK_SLIP_NUMBER = :B12 , RESERVATION_ID = :B11 , TRANSACTION_STATUS = :B10 , TRANSFER_COST_GROUP_ID = :B9 , LPN_ID = :B8 , TRANSFER_LPN_ID = :B7 , PICK_SLIP_DATE = :B6 , CONTENT_LPN_ID = :B5 , SECONDARY_TRANSACTION_QUANTITY = :B4 , SECONDARY_UOM_CODE = :B3 WHERE MOVE_ORDER_LINE_ID = :B2 AND TRANSACTION_TEMP_ID = :B1
8yucb2j07mns1 DECLARE l_count number; BEGIN delete from mtl_serial_numbers_temp where transaction_temp_id in ( select transaction_temp_id from mtl_material_transactions_temp where transaction_header_id = :1 AND nvl(TRANSACTION_BATCH_ID, -1)=NVL(:2, -1) and process_flag ='Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 and not (transaction_source_type_id in (2, 8) and transaction_action_id = 28 and abs(primary_quantity) <> 1) UNION ALL select mtlt.serial_transaction_temp_id from mtl_transaction_lots_temp mtlt where mtlt.transaction_temp_id in ( select mmtt.transaction_temp_id from mtl_material_transactions_temp mmtt where mmtt.transaction_header_id = :3 AND NVL(mmtt.TRANSACTION_BATCH_ID, -1)=NVL(:4, -1) and mmtt.process_flag ='Y' AND nvl(mmtt.ERROR_CODE, '@@') = '@@' AND NVL(mmtt.TRANSACTION_STATUS, 1) <> 2 and not (mmtt.transaction_source_type_id in (2, 8) and mmtt.transaction_action_id = 28 and abs(mtlt.primary_quantity) <> 1))); l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MSNT', 'INV_TRX_MGR'); DELETE from mtl_transaction_lots_temp where transaction_temp_id in ( select transaction_temp_id from MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :5 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:6, -1) AND PROCESS_FLAG = 'Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <& gt; 2 ); l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MTLT', 'INV_TRX_MGR'); DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :7 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:8, -1) AND PROCESS_FLAG = 'Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 ; l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MMTT', 'INV_TRX_MGR'); END;
8zfgv4ck11dw9BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23select 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
assndb4wqnd6rBEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwmsbegin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uwselect 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
cd9mbmqyf4qhpUPDATE 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
cdkb9h9mhux7supdate MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where ((((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and VALIDATION_REQUIRED=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID not in (2, 5, 8, 16)))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
cw171rvngr1w9begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
f34wj84pszqj0SELECT WI.ROOT_ACTIVITY, WI.ROOT_ACTIVITY_VERSION, WI.BEGIN_DATE, WI.USER_KEY FROM WF_ITEMS WI WHERE WI.ITEM_TYPE = :B2 AND WI.ITEM_KEY = :B1
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fuvc2825ycjfmSELECT * FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_TEMP_ID = :B1
fvcbstf9s6a5rbegin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
fxz0vtz7p7vy2 SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Arg ument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security _Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And ((R.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on, 1, FND_CONC_GLOBAL.OPS_INST_NUM, R.OPS_INSTANCE))) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONC URRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((510, 40032), (510, 40033), (510, 42156), (510, 42157), (530, 43793), (530, 43794), (535, 42626), (535, 42627), (535, 42628)))) FOR UPDATE OF R.status_code NoWait
g2qs4xk48vcwyselect 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)
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggrbegin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ghmx8n7wgqvfrbegin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzsINSERT 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 )
gnng1rmpjxzsxbegin 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

StatisticTotalper Secondper Trans
CPU used by this session 382,808 345.71 0.61
CPU used when call started 382,037 345.02 0.61
CR blocks created 12,160,113 10,981.83 19.48
DB time 1,504,357 1,358.59 2.41
DBWR checkpoint buffers written 1,248,792 1,127.79 2.00
DBWR checkpoints 30 0.03 0.00
DBWR object drop buffers written 1,939 1.75 0.00
DBWR revisited being-written buffer 50 0.05 0.00
DBWR transaction table writes 87 0.08 0.00
DBWR undo block writes 869,295 785.06 1.39
DFO trees parallelized 2 0.00 0.00
IMU CR rollbacks 5,275,423 4,764.25 8.45
IMU Flushes 376,301 339.84 0.60
IMU Redo allocation size 1,130,976,796 1,021,387.99 1,811.95
IMU commits 298,908 269.94 0.48
IMU contention 123,887 111.88 0.20
IMU ktichg flush 396 0.36 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 333 0.30 0.00
IMU undo allocation size 1,694,973,760 1,530,735.07 2,715.54
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 3,835 3.46 0.01
PX local messages sent 3,835 3.46 0.01
Parallel operations downgraded 25 to 50 pct 1 0.00 0.00
Parallel operations downgraded 50 to 75 pct 1 0.00 0.00
SQL*Net roundtrips to/from client 152,492 137.72 0.24
active txn count during cleanout 46,046,848 41,585.02 73.77
application wait time 13,657 12.33 0.02
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 3,908 3.53 0.01
branch node splits 500 0.45 0.00
buffer is not pinned count 203,210,066 183,519.52 325.57
buffer is pinned count 139,038,640 125,566.15 222.76
bytes received via SQL*Net from client 51,593,103 46,593.86 82.66
bytes sent via SQL*Net to client 50,401,835 45,518.02 80.75
calls to get snapshot scn: kcmgss 50,983,935 46,043.72 81.68
calls to kcmgas 14,976,860 13,525.64 23.99
calls to kcmgcs 1,424,987 1,286.91 2.28
change write time 24,686 22.29 0.04
cleanout - number of ktugct calls 14,236,836 12,857.32 22.81
cleanouts and rollbacks - consistent read gets 11,342,041 10,243.03 18.17
cleanouts only - consistent read gets 70,154 63.36 0.11
cluster key scan block gets 87,077 78.64 0.14
cluster key scans 65,822 59.44 0.11
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 49,531 44.73 0.08
commit batch/immediate requested 49,531 44.73 0.08
commit cleanout failures: block lost 183,226 165.47 0.29
commit cleanout failures: buffer being written 16 0.01 0.00
commit cleanout failures: callback failure 83,910 75.78 0.13
commit cleanout failures: cannot pin 66,286 59.86 0.11
commit cleanouts 7,384,262 6,668.75 11.83
commit cleanouts successfully completed 7,050,824 6,367.62 11.30
commit immediate performed 49,531 44.73 0.08
commit immediate requested 49,531 44.73 0.08
commit txn count during cleanout 781,070 705.39 1.25
concurrency wait time 98,235 88.72 0.16
consistent changes 439,441,568 396,860.79 704.04
consistent gets 774,122,982 699,112.41 1,240.23
consistent gets - examination 594,312,120 536,724.77 952.16
consistent gets direct 51 0.05 0.00
consistent gets from cache 774,122,931 699,112.37 1,240.23
cursor authentications 1,292 1.17 0.00
data blocks consistent reads - undo records applied 433,601,330 391,586.45 694.68
db block changes 117,152,979 105,801.15 187.69
db block gets 125,829,780 113,637.19 201.59
db block gets direct 44 0.04 0.00
db block gets from cache 125,829,736 113,637.15 201.59
deferred (CURRENT) block cleanout applications 1,332,434 1,203.32 2.13
dirty buffers inspected 4 0.00 0.00
doubling up with imu segment 3 0.00 0.00
enqueue conversions 1,195 1.08 0.00
enqueue releases 3,801,061 3,432.75 6.09
enqueue requests 4,165,889 3,762.22 6.67
enqueue timeouts 364,829 329.48 0.58
enqueue waits 89,963 81.25 0.14
exchange deadlocks 262,651 237.20 0.42
execute count 42,164,084 38,078.49 67.55
failed probes on index block reclamation 13,794 12.46 0.02
free buffer inspected 1,658,453 1,497.75 2.66
free buffer requested 14,943,117 13,495.17 23.94
heap block compress 26,450,136 23,887.18 42.38
hot buffers moved to head of LRU 175,620 158.60 0.28
immediate (CR) block cleanout applications 11,412,203 10,306.39 18.28
immediate (CURRENT) block cleanout applications 675,416 609.97 1.08
index crx upgrade (found) 173,395 156.59 0.28
index crx upgrade (positioned) 4,475,206 4,041.57 7.17
index fetch by key 40,148,239 36,257.98 64.32
index scans kdiixs1 49,365,255 44,581.89 79.09
java call heap collected bytes 806,944,728 728,753.82 1,292.82
java call heap collected count 11,149,235 10,068.90 17.86
java call heap gc count 2,466 2.23 0.00
java call heap live object count 543,008 490.39 0.87
java call heap live object count max 549,188 495.97 0.88
java call heap live size 192,682,944 174,012.45 308.70
java call heap live size max 193,612,096 174,851.57 310.19
java call heap object count 1,241,247 1,120.97 1.99
java call heap object count max 1,286,115 1,161.49 2.06
java call heap total size 264,527,872 238,895.79 423.80
java call heap total size max 264,527,872 238,895.79 423.80
java call heap used size 239,337,976 216,146.73 383.45
java call heap used size max 243,366,184 219,784.61 389.90
leaf node 90-10 splits 10,368 9.36 0.02
leaf node splits 126,864 114.57 0.20
lob reads 3,075,041 2,777.08 4.93
lob writes 1,310,059 1,183.12 2.10
lob writes unaligned 1,310,059 1,183.12 2.10
logons cumulative 548 0.49 0.00
messages received 411,490 371.62 0.66
messages sent 411,490 371.62 0.66
no buffer to keep pinned count 10 0.01 0.00
no work - consistent read gets 152,405,209 137,637.53 244.17
opened cursors cumulative 818,024 738.76 1.31
parse count (failures) 31 0.03 0.00
parse count (hard) 558 0.50 0.00
parse count (total) 2,002,145 1,808.14 3.21
parse time cpu 741 0.67 0.00
parse time elapsed 3,634 3.28 0.01
physical read IO requests 32,111 29.00 0.05
physical read bytes 785,309,696 709,215.16 1,258.16
physical read total IO requests 34,380 31.05 0.06
physical read total bytes 820,338,688 740,849.94 1,314.28
physical read total multi block requests 5,049 4.56 0.01
physical reads 95,863 86.57 0.15
physical reads cache 94,815 85.63 0.15
physical reads cache prefetch 63,716 57.54 0.10
physical reads direct 1,048 0.95 0.00
physical reads direct (lob) 48 0.04 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 25,363 22.91 0.04
physical write IO requests 95,977 86.68 0.15
physical write bytes 10,249,101,312 9,255,989.21 16,420.24
physical write total IO requests 708,872 640.18 1.14
physical write total bytes 30,625,974,784 27,658,394.96 49,066.33
physical write total multi block requests 688,503 621.79 1.10
physical writes 1,251,111 1,129.88 2.00
physical writes direct 284 0.26 0.00
physical writes direct (lob) 17 0.02 0.00
physical writes from cache 1,250,827 1,129.63 2.00
physical writes non checkpoint 1,195,576 1,079.73 1.92
pinned buffers inspected 4,806 4.34 0.01
prefetch warmup blocks aged out before use 17,956 16.22 0.03
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 51 0.05 0.00
process last non-idle time 1,151 1.04 0.00
queries parallelized 2 0.00 0.00
recursive aborts on index block reclamation 9 0.01 0.00
recursive calls 78,362,810 70,769.65 125.55
recursive cpu usage 320,259 289.23 0.51
redo blocks written 39,743,749 35,892.68 63.67
redo buffer allocation retries 0 0.00 0.00
redo entries 63,024,726 56,917.79 100.97
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 731,589 660.70 1.17
redo size 19,531,438,492 17,638,891.29 31,291.61
redo subscn max counts 1,393,086 1,258.10 2.23
redo synch time 59,654 53.87 0.10
redo synch writes 130,006 117.41 0.21
redo wastage 149,953,812 135,423.67 240.24
redo write time 30,994 27.99 0.05
redo writer latching time 456 0.41 0.00
redo writes 315,321 284.77 0.51
rollback changes - undo records applied 65,807 59.43 0.11
rollbacks only - consistent read gets 924,200 834.65 1.48
rows fetched via callback 23,665,127 21,372.04 37.91
session connect time 0 0.00 0.00
session cursor cache hits 1,849,489 1,670.28 2.96
session logical reads 899,952,762 812,749.61 1,441.83
session pga memory 20,062,368 18,118.38 32.14
session pga memory max 36,041,472 32,549.14 57.74
session uga memory 77,327,110,960 69,834,308.65 123,886.91
session uga memory max 7,851,208,016 7,090,445.73 12,578.54
shared hash latch upgrades - no wait 15,723,211 14,199.67 25.19
shared hash latch upgrades - wait 237,408 214.40 0.38
sorts (memory) 8,018,027 7,241.10 12.85
sorts (rows) 18,528,293 16,732.95 29.68
sql area purged 106 0.10 0.00
summed dirty queue length 2 0.00 0.00
switch current to new buffer 1,264,779 1,142.23 2.03
table fetch by rowid 113,412,762 102,423.35 181.70
table fetch continued row 19,639,713 17,736.67 31.47
table scan blocks gotten 11,110,852 10,034.24 17.80
table scan rows gotten 276,529,189 249,734.21 443.03
table scans (cache partitions) 248 0.22 0.00
table scans (rowid ranges) 248 0.22 0.00
table scans (short tables) 881,615 796.19 1.41
total number of times SMON posted 1,742 1.57 0.00
transaction rollbacks 49,531 44.73 0.08
transaction tables consistent read rollbacks 267 0.24 0.00
transaction tables consistent reads - undo records applied 135,998 122.82 0.22
undo change vector size 7,176,211,244 6,480,854.45 11,497.11
user I/O wait time 13,534 12.22 0.02
user calls 182,379 164.71 0.29
user commits 623,911 563.46 1.00
user rollbacks 264 0.24 0.00
workarea executions - optimal 4,014,004 3,625.06 6.43
write clones created in background 55 0.05 0.00
write clones created in foreground 23 0.02 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 18,891 42,643
opened cursors current 2,003 1,948
logons current 77 75

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 23 0 10.43 1.00 60,176 54 574,673 0.35
APPS_TS_TX_IDX 9,650 9 5.79 2.63 11,987 11 175,774 0.50
APPS_TS_TX_DATA 5,087 5 5.07 6.15 9,562 9 486,053 0.28
SYSAUX 12,595 11 0.70 1.07 257 0 6 6.67
APPS_TS_QUEUES 1,411 1 6.84 3.01 7,465 7 633,259 0.21
APPS_TS_SUMMARY 45 0 2.00 1.00 4,274 4 73,300 0.45
APPS_TS_INTERFACE 1,780 2 3.75 1.36 1,838 2 19,831 2.07
SYSTEM 1,068 1 4.06 17.24 280 0 30,146 0.13
APPS_TS_SEED 152 0 5.33 1.18 5 0 272 3.13
APPS_TS_ARCHIVE 18 0 7.78 3.06 50 0 21 0.00
CTXSYS 14 0 2.86 1.00 2 0 0 0.00
CWMLITE 13 0 3.08 1.00 2 0 0 0.00
DCM 12 0 3.33 1.00 2 0 0 0.00
GEOR_TBS 12 0 3.33 1.00 2 0 0 0.00
APPS_CALCLIP 4 0 10.00 1.00 4 0 0 0.00
APPS_TS_MEDIA 4 0 0.00 1.00 4 0 0 0.00
B2B_LOB 7 0 2.86 1.00 1 0 0 0.00
B2B_RT 7 0 2.86 1.00 1 0 0 0.00
BAM 7 0 2.86 1.00 1 0 0 0.00
ODM_DATA 7 0 2.86 1.00 1 0 0 0.00
OLTS_ATTRSTORE 7 0 2.86 1.00 1 0 0 0.00
OLTS_BATTRSTORE 7 0 1.43 1.00 1 0 0 0.00
OLTS_CT_STORE 7 0 1.43 1.00 1 0 0 0.00
OLTS_DEFAULT 7 0 1.43 1.00 1 0 0 0.00
OLTS_SVRMGSTORE 7 0 1.43 1.00 1 0 0 0.00
B2B_DT 6 0 3.33 1.00 1 0 0 0.00
B2B_IDX 6 0 3.33 1.00 1 0 0 0.00
DISCO_PTM5_CACHE 6 0 3.33 1.00 1 0 0 0.00
DISCO_PTM5_META 6 0 3.33 1.00 1 0 0 0.00
DSGATEWAY_TAB 6 0 3.33 1.00 1 0 0 0.00
HTMLDB 6 0 3.33 1.00 1 0 0 0.00
IAS_META 6 0 3.33 1.00 1 0 0 0.00
MTR 6 0 3.33 1.00 1 0 0 0.00
NOETIX 6 0 3.33 1.00 1 0 0 0.00
NON_APPS_TS_DATA 6 0 3.33 1.00 1 0 0 0.00
OCATS 6 0 3.33 1.00 1 0 0 0.00
OPMOR 6 0 1.67 1.00 1 0 0 0.00
ORABPEL 6 0 1.67 1.00 1 0 0 0.00
OWAPUB 6 0 1.67 1.00 1 0 0 0.00
PORTAL 6 0 1.67 1.00 1 0 0 0.00
PORTAL_DOC 6 0 1.67 1.00 1 0 0 0.00
PORTAL_IDX 6 0 1.67 1.00 1 0 0 0.00
PORTAL_LOG 6 0 1.67 1.00 1 0 0 0.00
RE 6 0 1.67 1.00 1 0 0 0.00
SYNCSERVER 6 0 1.67 1.00 1 0 0 0.00
UDDISYS_TS 6 0 1.67 1.00 1 0 0 0.00
WCRSYS_TS 6 0 1.67 1.00 1 0 0 0.00
XDB 6 0 1.67 1.00 1 0 0 0.00
APPS_TS_NOLOGGING 2 0 0.00 1.00 4 0 400 0.00
TEMP 3 0 0.00 1.00 2 0 0 0.00
APPS_TS_TOOLS 2 0 0.00 1.00 1 0 0 0.00
APPS_OMO 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_DISCO 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP 1 0 10.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_CALCLIP /slot/ems2703/oracle/VIS/db/apps_st/data/apps_calcli 1 0 10.00 1.00 1 0 0 0.00
APPS_CALCLIP /slot/ems2703/oracle/VIS/db/apps_st/data/apps_calcli 1 0 10.00 1.00 1 0 0 0.00
APPS_CALCLIP /slot/ems2703/oracle/VIS/db/apps_st/data/apps_calcli 1 0 10.00 1.00 1 0 0 0.00
APPS_CALCLIP /slot/ems2703/oracle/VIS/db/apps_st/data/apps_calcli 1 0 10.00 1.00 1 0 0 0.00
APPS_OMO /slot/ems2703/oracle/VIS/db/apps_st/data/omo1.dbf 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_ARCHIVE /slot/ems2703/oracle/VIS/db/apps_st/data/archive1.db 18 0 7.78 3.06 50 0 21 0.00
APPS_TS_DISCO /slot/ems2703/oracle/VIS/db/apps_st/data/disco1.dbf 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_DISCO_OLAP /slot/ems2703/oracle/VIS/db/apps_st/data/disco_drake 1 0 10.00 1.00 1 0 0 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 76 0 3.42 1.36 84 0 460 4.74
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     3 0 4 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 86 0 3.60 1.44 75 0 402 3.23
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 78 0 2.95 1.36 82 0 487 3.26
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 3 0 6.67 1.00 3 0 2 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 74 0 5.14 1.15 75 0 349 0.60
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 2 0 5.00 1.00 4 0 2 20.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 70 0 2.00 1.01 66 0 303 1.95
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 79 0 4.68 1.32 73 0 576 2.05
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 75 0 3.07 1.17 73 0 653 4.82
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 75 0 4.67 1.17 71 0 666 3.53
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 2 0 5.00 1.00 4 0 164 6.34
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 2 0 5.00 1.00 4 0 167 6.59
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 2 0 5.00 1.00 4 0 213 6.62
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 82 0 4.51 1.30 77 0 569 3.92
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 61 0 2.95 1.21 61 0 422 3.01
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 2 0 5.00 1.00 4 0 6 8.33
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 4 0 2.50 1.00 10 0 352 0.03
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 5 0 8.00 3.80 14 0 858 1.86
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 5 0 10.00 3.60 14 0 475 0.08
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 67 0 3.73 1.40 73 0 1,413 2.14
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 101 0 3.47 1.95 117 0 880 2.56
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 75 0 4.40 1.73 93 0 1,970 0.50
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     1 0 16 1.88
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 85 0 3.65 1.32 88 0 2,891 0.28
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 102 0 3.73 1.39 95 0 2,368 0.81
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 107 0 2.80 1.25 83 0 681 1.73
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 99 0 3.43 1.28 96 0 516 3.16
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 96 0 2.60 1.20 96 0 541 4.01
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 86 0 4.77 1.44 95 0 477 3.98
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 94 0 4.26 1.30 90 0 481 4.43
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 82 0 4.15 1.50 96 0 396 4.27
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     3 0 21 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     3 0 24 0.42
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     2 0 20 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 0 0     1 0 0 0.00
APPS_TS_INTERFACE /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_int 3 0 6.67 1.00 5 0 6 0.00
APPS_TS_MEDIA /slot/ems2703/oracle/VIS/db/apps_st/data/media4.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /slot/ems2703/oracle/VIS/db/apps_st/data/media5.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /slot/ems2703/oracle/VIS/db/apps_st/data/media6.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_MEDIA /slot/ems2703/oracle/VIS/db/apps_st/data/media7.dbf 1 0 0.00 1.00 1 0 0 0.00
APPS_TS_NOLOGGING /slot/ems2703/oracle/VIS/db/apps_st/data/nologging1. 2 0 0.00 1.00 4 0 400 0.00
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues1.dbf 121 0 6.94 4.94 1,067 1 88,232 0.24
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues2.dbf 113 0 8.76 5.45 1,067 1 99,688 0.23
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues3.dbf 111 0 9.10 5.18 1,046 1 91,760 0.24
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues4.dbf 161 0 6.27 3.94 1,062 1 92,363 0.19
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues5.dbf 143 0 7.34 4.22 1,059 1 83,155 0.18
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues6.dbf 596 1 6.16 1.00 1,071 1 88,693 0.19
APPS_TS_QUEUES /slot/ems2703/oracle/VIS/db/apps_st/data/queues7.dbf 166 0 6.51 3.75 1,093 1 89,368 0.20
APPS_TS_SEED /slot/ems2703/oracle/VIS/db/apps_st/data/reference1. 13 0 3.08 1.00 1 0 22 5.45
APPS_TS_SEED /slot/ems2703/oracle/VIS/db/apps_st/data/reference2. 24 0 7.08 1.00 1 0 28 5.36
APPS_TS_SEED /slot/ems2703/oracle/VIS/db/apps_st/data/reference3. 58 0 5.34 1.48 1 0 152 2.63
APPS_TS_SEED /slot/ems2703/oracle/VIS/db/apps_st/data/reference4. 39 0 5.38 1.00 1 0 49 2.45
APPS_TS_SEED /slot/ems2703/oracle/VIS/db/apps_st/data/reference5. 18 0 4.44 1.00 1 0 21 2.86
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary1.db 1 0 0.00 1.00 353 0 5,066 0.36
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary10.d 3 0 6.67 1.00 355 0 5,699 0.41
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary11.d 1 0 0.00 1.00 351 0 6,133 0.39
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary12.d 2 0 0.00 1.00 345 0 4,492 0.44
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary13.d 10 0 2.00 1.00 46 0 3,799 0.09
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary2.db 5 0 6.00 1.00 352 0 8,488 0.49
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary3.db 3 0 0.00 1.00 356 0 7,796 0.43
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary4.db 2 0 0.00 1.00 354 0 5,604 0.41
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary5.db 4 0 0.00 1.00 358 0 4,850 0.46
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary6.db 3 0 0.00 1.00 351 0 5,501 0.55
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary7.db 4 0 5.00 1.00 352 0 5,557 0.54
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary8.db 2 0 0.00 1.00 353 0 4,946 0.39
APPS_TS_SUMMARY /slot/ems2703/oracle/VIS/db/apps_st/data/summary9.db 5 0 0.00 1.00 348 0 5,369 0.80
APPS_TS_TOOLS /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_too 2 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data1.db 22 0 5.00 10.05 5 0 34 4.71
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data10.d 23 0 5.65 9.78 5 0 50 4.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data11.d 97 0 4.12 5.41 256 0 10,796 0.27
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data12.d 101 0 3.86 4.91 245 0 34,500 0.14
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data13.d 106 0 4.06 4.91 246 0 10,999 0.23
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data14.d 31 0 7.42 7.48 11 0 43 6.05
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data15.d 28 0 7.14 8.25 11 0 36 6.67
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data16.d 27 0 9.26 8.48 13 0 34 5.88
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data17.d 53 0 4.72 7.49 5 0 32 5.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data18.d 26 0 5.00 8.46 3 0 35 3.43
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data19.d 54 0 4.63 7.67 5 0 34 6.18
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data2.db 102 0 4.51 5.40 259 0 10,087 0.33
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data20.d 34 0 8.53 7.35 7 0 40 3.50
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data21.d 90 0 4.89 5.87 243 0 10,201 0.31
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data22.d 48 0 7.08 8.00 14 0 37 3.24
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data23.d 30 0 7.00 8.57 14 0 34 5.88
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data24.d 33 0 7.88 8.09 5 0 42 2.86
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data25.d 4 0 0.00 1.00 1 0 0 0.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data26.d 9 0 5.56 2.44 9 0 397 0.10
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data27.d 19 0 7.37 5.11 70 0 33 0.61
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data28.d 53 0 5.09 6.38 18 0 200 4.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data29.d 76 0 6.05 5.08 13 0 182 3.74
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data3.db 40 0 5.75 7.93 11 0 91 2.31
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data30.d 39 0 6.67 7.79 12 0 64 4.38
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data31.d 44 0 6.59 7.39 38 0 2,241 0.12
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data32.d 152 0 5.20 2.82 19 0 118 2.12
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data33.d 65 0 5.38 6.31 23 0 63 3.97
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data34.d 51 0 4.71 7.59 16 0 135 2.67
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data35.d 44 0 7.05 7.11 17 0 70 6.14
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data36.d 34 0 2.94 8.71 20 0 154 1.69
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data37.d 56 0 5.00 5.96 8 0 168 4.11
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data38.d 35 0 6.00 8.57 7 0 56 2.86
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data39.d 39 0 4.87 7.69 5 0 69 4.06
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data4.db 37 0 6.76 8.43 12 0 83 1.93
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data40.d 39 0 5.90 7.46 12 0 63 4.92
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data41.d 35 0 4.29 8.37 23 0 43 3.72
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data42.d 36 0 6.94 8.11 23 0 44 4.55
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data43.d 94 0 4.79 3.14 17 0 51 2.35
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data44.d 35 0 5.43 8.71 23 0 41 5.85
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data45.d 64 0 5.78 5.80 18 0 379 0.34
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data46.d 76 0 6.32 6.45 17 0 985 0.25
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data47.d 71 0 5.21 6.85 15 0 42 3.81
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data48.d 91 0 5.27 5.21 29 0 1,307 0.37
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data49.d 58 0 4.66 7.59 8 0 61 3.11
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data5.db 32 0 5.31 8.84 5 0 49 2.45
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data50.d 81 0 5.06 6.51 6 0 60 3.67
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data51.d 184 0 3.04 3.77 390 0 14,187 0.32
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data52.d 47 0 4.89 9.11 13 0 44 5.68
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data53.d 92 0 5.22 6.36 327 0 12,441 0.39
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data54.d 97 0 5.26 6.21 325 0 11,032 0.41
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data55.d 88 0 4.77 6.52 333 0 11,857 0.33
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data56.d 85 0 5.29 6.56 306 0 13,274 0.32
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data57.d 80 0 5.00 6.55 322 0 13,950 0.21
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data58.d 68 0 4.71 7.56 286 0 11,617 0.33
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data59.d 91 0 4.62 5.98 288 0 59,273 0.09
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data6.db 26 0 7.69 9.65 9 0 40 5.75
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data60.d 89 0 5.06 6.12 250 0 22,339 0.21
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data61.d 76 0 5.79 6.99 270 0 31,390 0.34
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data62.d 76 0 4.34 7.47 282 0 11,738 0.25
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data63.d 89 0 4.61 6.47 269 0 11,359 0.39
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data64.d 92 0 5.43 5.91 271 0 12,216 0.29
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data65.d 77 0 5.32 6.55 273 0 11,676 0.31
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data66.d 76 0 5.13 7.01 270 0 11,429 0.26
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data67.d 83 0 5.06 6.71 269 0 11,506 0.21
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data68.d 88 0 4.66 5.75 287 0 10,639 0.31
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data69.d 85 0 5.18 6.54 255 0 11,351 0.46
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data7.db 30 0 4.67 8.37 17 0 35 3.43
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data70.d 76 0 5.39 6.66 264 0 10,744 0.31
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data71.d 73 0 6.03 7.07 277 0 11,662 0.38
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data72.d 166 0 4.64 3.02 277 0 12,067 0.23
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data73.d 90 0 5.11 6.18 277 0 12,366 0.29
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data74.d 98 0 4.39 5.33 263 0 11,445 0.26
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data75.d 104 0 5.77 5.49 279 0 12,580 0.21
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data76.d 105 0 4.10 5.20 257 0 13,945 0.23
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data77.d 82 0 4.02 5.79 248 0 11,792 0.28
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data78.d 118 0 3.22 4.33 256 0 11,740 0.42
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data8.db 15 0 7.33 4.60 5 0 1 10.00
APPS_TS_TX_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/tx_data9.db 27 0 3.33 8.22 5 0 35 4.57
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx1.dbf 111 0 6.94 3.45 169 0 3,051 0.68
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx10.db 130 0 6.31 3.55 179 0 3,032 0.48
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx11.db 126 0 5.48 3.28 164 0 2,929 0.68
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx12.db 144 0 7.01 2.57 174 0 3,259 0.55
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx13.db 110 0 7.09 3.38 171 0 3,477 0.49
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx14.db 97 0 5.46 3.29 169 0 2,473 0.10
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx15.db 125 0 6.32 2.82 162 0 2,096 0.34
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx16.db 117 0 5.13 2.81 156 0 2,185 0.42
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx17.db 107 0 6.07 2.82 160 0 2,896 0.37
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx18.db 118 0 5.17 2.43 146 0 2,864 0.38
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx19.db 116 0 6.12 2.22 149 0 2,872 0.32
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx2.dbf 157 0 5.03 2.18 139 0 3,226 0.44
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx20.db 110 0 5.18 2.29 132 0 2,750 0.28
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx21.db 117 0 4.36 1.93 122 0 3,128 0.69
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx22.db 125 0 5.84 1.88 111 0 3,299 0.38
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx23.db 168 0 5.83 1.63 109 0 3,296 0.39
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx24.db 160 0 5.00 1.80 103 0 3,500 0.37
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx25.db 381 0 5.46 1.87 1,532 1 15,623 0.27
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx26.db 221 0 6.56 2.07 194 0 8,833 0.31
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx27.db 527 0 3.78 3.77 315 0 1,788 0.11
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx28.db 216 0 4.72 1.70 348 0 1,639 0.68
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx29.db 625 1 4.69 1.49 515 0 2,213 0.39
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx3.dbf 1,184 1 4.13 1.80 670 1 3,006 0.64
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx30.db 291 0 6.56 2.38 520 0 3,273 0.92
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx31.db 169 0 8.88 3.31 266 0 3,226 0.77
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx32.db 177 0 5.76 3.37 216 0 3,306 0.98
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx33.db 167 0 5.27 3.01 200 0 3,575 0.70
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx34.db 174 0 6.90 2.91 206 0 3,455 0.85
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx35.db 218 0 5.46 2.56 243 0 4,131 0.92
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx36.db 228 0 5.39 2.55 237 0 3,236 1.03
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx37.db 247 0 6.32 2.54 276 0 3,461 0.43
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx38.db 222 0 5.90 2.83 261 0 4,013 0.65
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx39.db 221 0 6.65 3.20 275 0 3,797 1.14
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx4.dbf 275 0 5.02 2.69 251 0 4,823 0.35
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx40.db 196 0 5.46 3.12 257 0 4,243 0.59
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx41.db 173 0 7.34 3.40 257 0 4,537 0.52
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx42.db 151 0 9.27 3.43 235 0 3,936 0.41
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx43.db 132 0 8.71 4.09 228 0 3,842 0.36
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx44.db 159 0 6.86 2.91 203 0 3,799 0.26
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx45.db 137 0 8.32 3.45 213 0 3,096 0.81
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx46.db 128 0 8.05 3.52 199 0 3,244 0.35
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx47.db 153 0 5.95 2.80 195 0 2,914 0.29
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx48.db 132 0 5.91 3.02 169 0 3,443 0.25
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx49.db 103 0 6.50 3.20 160 0 3,236 0.33
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx5.dbf 69 0 6.81 4.41 160 0 2,828 0.65
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx6.dbf 96 0 8.44 4.11 180 0 2,987 0.77
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx7.dbf 108 0 7.87 3.53 154 0 3,344 0.14
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx8.dbf 110 0 8.09 3.18 162 0 3,263 0.76
APPS_TS_TX_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/tx_idx9.dbf 122 0 7.95 3.28 175 0 3,331 0.33
APPS_UNDOTS1 /slot/ems2703/oracle/VIS/db/apps_st/data/undo.dbf 11 0 20.00 1.00 22,016 20 251,866 0.42
APPS_UNDOTS1 /slot/ems2703/oracle/VIS/db/apps_st/data/undo2.dbf 6 0 1.67 1.00 19,660 18 154,752 0.30
APPS_UNDOTS1 /slot/ems2703/oracle/VIS/db/apps_st/data/undo3.dbf 6 0 1.67 1.00 18,500 17 168,055 0.30
B2B_DT /slot/ems2703/oracle/VIS/db/apps_st/data/b2b_dt.dbf 6 0 3.33 1.00 1 0 0 0.00
B2B_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/b2b_idx.dbf 6 0 3.33 1.00 1 0 0 0.00
B2B_LOB /slot/ems2703/oracle/VIS/db/apps_st/data/b2b_lob.dbf 7 0 2.86 1.00 1 0 0 0.00
B2B_RT /slot/ems2703/oracle/VIS/db/apps_st/data/b2b_rt.dbf 7 0 2.86 1.00 1 0 0 0.00
BAM /slot/ems2703/oracle/VIS/db/apps_st/data/bam.dbf 7 0 2.86 1.00 1 0 0 0.00
CTXSYS /slot/ems2703/oracle/VIS/db/apps_st/data/ctx1.dbf 7 0 2.86 1.00 1 0 0 0.00
CTXSYS /slot/ems2703/oracle/VIS/db/apps_st/data/ctx2.dbf 7 0 2.86 1.00 1 0 0 0.00
CWMLITE /slot/ems2703/oracle/VIS/db/apps_st/data/cwmlite01.d 7 0 2.86 1.00 1 0 0 0.00
CWMLITE /slot/ems2703/oracle/VIS/db/apps_st/data/cwmlite02.d 6 0 3.33 1.00 1 0 0 0.00
DCM /slot/ems2703/oracle/VIS/db/apps_st/data/dcm.dbf 6 0 3.33 1.00 1 0 0 0.00
DCM /slot/ems2703/oracle/VIS/db/apps_st/data/dcm1.dbf 6 0 3.33 1.00 1 0 0 0.00
DISCO_PTM5_CACHE /slot/ems2703/oracle/VIS/db/apps_st/data/discopltc1. 6 0 3.33 1.00 1 0 0 0.00
DISCO_PTM5_META /slot/ems2703/oracle/VIS/db/apps_st/data/discopltm1. 6 0 3.33 1.00 1 0 0 0.00
DSGATEWAY_TAB /slot/ems2703/oracle/VIS/db/apps_st/data/oss_sys01.d 6 0 3.33 1.00 1 0 0 0.00
GEOR_TBS /slot/ems2703/oracle/VIS/db/apps_st/data/apps_ts_spa 6 0 3.33 1.00 1 0 0 0.00
GEOR_TBS /slot/ems2703/oracle/VIS/db/apps_st/data/geor_tbs02. 6 0 3.33 1.00 1 0 0 0.00
HTMLDB /slot/ems2703/oracle/VIS/db/apps_st/data/htmldb.dbf 6 0 3.33 1.00 1 0 0 0.00
IAS_META /slot/ems2703/oracle/VIS/db/apps_st/data/ias_meta01. 6 0 3.33 1.00 1 0 0 0.00
MTR /slot/ems2703/oracle/VIS/db/apps_st/data/opmtr01.dbf 6 0 3.33 1.00 1 0 0 0.00
NOETIX /slot/ems2703/oracle/VIS/db/apps_st/data/noetix.dbf 6 0 3.33 1.00 1 0 0 0.00
NON_APPS_TS_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/non_apps_da 6 0 3.33 1.00 1 0 0 0.00
OCATS /slot/ems2703/oracle/VIS/db/apps_st/data/oca.dbf 6 0 3.33 1.00 1 0 0 0.00
ODM_DATA /slot/ems2703/oracle/VIS/db/apps_st/data/odm.dbf 7 0 2.86 1.00 1 0 0 0.00
OLTS_ATTRSTORE /slot/ems2703/oracle/VIS/db/apps_st/data/attrs1_oid. 7 0 2.86 1.00 1 0 0 0.00
OLTS_BATTRSTORE /slot/ems2703/oracle/VIS/db/apps_st/data/battrs1_oid 7 0 1.43 1.00 1 0 0 0.00
OLTS_CT_STORE /slot/ems2703/oracle/VIS/db/apps_st/data/gcats1_oid. 7 0 1.43 1.00 1 0 0 0.00
OLTS_DEFAULT /slot/ems2703/oracle/VIS/db/apps_st/data/gdefault1_o 7 0 1.43 1.00 1 0 0 0.00
OLTS_SVRMGSTORE /slot/ems2703/oracle/VIS/db/apps_st/data/svrmg1_oid. 7 0 1.43 1.00 1 0 0 0.00
OPMOR /slot/ems2703/oracle/VIS/db/apps_st/data/opmor01.dbf 6 0 1.67 1.00 1 0 0 0.00
ORABPEL /slot/ems2703/oracle/VIS/db/apps_st/data/orabpel.dbf 6 0 1.67 1.00 1 0 0 0.00
OWAPUB /slot/ems2703/oracle/VIS/db/apps_st/data/owa1.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL /slot/ems2703/oracle/VIS/db/apps_st/data/portal.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL_DOC /slot/ems2703/oracle/VIS/db/apps_st/data/ptldoc.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL_IDX /slot/ems2703/oracle/VIS/db/apps_st/data/ptlidx.dbf 6 0 1.67 1.00 1 0 0 0.00
PORTAL_LOG /slot/ems2703/oracle/VIS/db/apps_st/data/ptllog.dbf 6 0 1.67 1.00 1 0 0 0.00
RE /slot/ems2703/oracle/VIS/db/apps_st/data/opre01.dbf 6 0 1.67 1.00 1 0 0 0.00
SYNCSERVER /slot/ems2703/oracle/VIS/db/apps_st/data/mobile01.db 6 0 1.67 1.00 1 0 0 0.00
SYSAUX /slot/ems2703/oracle/VIS/db/apps_st/data/sysaux01.db 7,998 7 0.77 1.11 194 0 6 6.67
SYSAUX /slot/ems2703/oracle/VIS/db/apps_st/data/sysaux02.db 4,597 4 0.58 1.00 63 0 0 0.00
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys1.dbf 173 0 5.38 14.02 63 0 7,091 0.14
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys10.dbf 80 0 2.25 20.46 36 0 5,063 0.10
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys2.dbf 94 0 4.79 17.83 25 0 5,315 0.10
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys3.dbf 69 0 2.90 24.30 11 0 109 0.00
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys4.dbf 116 0 3.79 15.34 34 0 712 0.44
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys5.dbf 102 0 3.73 16.62 16 0 322 0.00
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys6.dbf 103 0 2.91 17.64 6 0 982 0.03
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys7.dbf 97 0 4.33 18.84 12 0 934 0.27
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys8.dbf 126 0 3.65 14.79 26 0 2,877 0.18
SYSTEM /slot/ems2703/oracle/VIS/db/apps_st/data/sys9.dbf 108 0 5.37 18.65 51 0 6,741 0.10
TEMP /slot/ems2703/oracle/VIS/db/apps_st/data/tempx01.dbf 3 0 0.00 1.00 2 0 0  
UDDISYS_TS /slot/ems2703/oracle/VIS/db/apps_st/data/uddisys01.d 6 0 1.67 1.00 1 0 0 0.00
WCRSYS_TS /slot/ems2703/oracle/VIS/db/apps_st/data/wcrsys01.db 6 0 1.67 1.00 1 0 0 0.00
XDB /slot/ems2703/oracle/VIS/db/apps_st/data/xdb01.dbf 6 0 1.67 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 1,266,560 100 804,455,660 94,234 1,172,697 0 0 1,683,282
K 1,211,148 100 92,140,735 587 78,130 0 0 311,103


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 24 7158 202201 95846400 95846400    
E 0 388 232439 6101291 95846400 95846400    

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 60,423 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 8,192 7,266 243.58 0.00 0.00 0.00 0.00 838,860
E 8,192 7,264 221.93 0.00 0.00 0.00 0.00 838,860

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,942,267 3,942,267 0 0
64K 128K 482 482 0 0
128K 256K 130 130 0 0
256K 512K 353 353 0 0
512K 1024K 706 706 0 0
1M 2M 45,490 45,490 0 0
2M 4M 68 68 0 0
4M 8M 14 14 0 0
8M 16M 14 14 0 0
16M 32M 4 4 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
1,024 0.13 61,218.71 214.37 100.00 13
2,048 0.25 61,218.71 164.74 100.00 3
4,096 0.50 61,218.71 0.00 100.00 0
6,144 0.75 61,218.71 0.00 100.00 0
8,192 1.00 61,218.71 0.00 100.00 0
9,830 1.20 61,218.71 0.00 100.00 0
11,469 1.40 61,218.71 0.00 100.00 0
13,107 1.60 61,218.71 0.00 100.00 0
14,746 1.80 61,218.71 0.00 100.00 0
16,384 2.00 61,218.71 0.00 100.00 0
24,576 3.00 61,218.71 0.00 100.00 0
32,768 4.00 61,218.71 0.00 100.00 0
49,152 6.00 61,218.71 0.00 100.00 0
65,536 8.00 61,218.71 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
560 0.28 239 10,464 506,029 1.00 294 1.20 35,612,403
768 0.38 351 16,523 506,079 1.00 244 1.00 35,615,781
976 0.48 351 16,523 506,079 1.00 244 1.00 35,615,781
1,184 0.59 351 16,523 506,079 1.00 244 1.00 35,615,781
1,392 0.69 351 16,523 506,079 1.00 244 1.00 35,615,781
1,600 0.79 351 16,523 506,079 1.00 244 1.00 35,615,781
1,808 0.90 351 16,523 506,079 1.00 244 1.00 35,615,781
2,016 1.00 351 16,523 506,079 1.00 244 1.00 35,615,781
2,224 1.10 351 16,523 506,079 1.00 244 1.00 35,615,781
2,432 1.21 351 16,523 506,079 1.00 244 1.00 35,615,781
2,640 1.31 351 16,523 506,079 1.00 244 1.00 35,615,781
2,848 1.41 351 16,523 506,079 1.00 244 1.00 35,615,781
3,056 1.52 351 16,523 506,079 1.00 244 1.00 35,615,781
3,264 1.62 351 16,523 506,079 1.00 244 1.00 35,615,781
3,472 1.72 351 16,523 506,079 1.00 244 1.00 35,615,781
3,680 1.83 351 16,523 506,079 1.00 244 1.00 35,615,781
3,888 1.93 351 16,523 506,079 1.00 244 1.00 35,615,781
4,096 2.03 351 16,523 506,079 1.00 244 1.00 35,615,781

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
128 0.13 0 0 0 0
240 0.23 0 0 0 0
352 0.34 0 0 0 0
464 0.45 0 0 0 0
576 0.56 0 0 0 0
688 0.67 0 0 0 0
800 0.78 0 0 0 0
912 0.89 0 0 0 0
1,024 1.00 0 0 0 0
1,136 1.11 0 0 0 0
1,248 1.22 0 0 0 0
1,360 1.33 0 0 0 0
1,472 1.44 0 0 0 0
1,584 1.55 0 0 0 0
1,696 1.66 0 0 0 0
1,808 1.77 0 0 0 0
1,920 1.88 0 0 0 0
2,032 1.98 0 0 0 0
2,144 2.09 0 0 0 0
2,256 2.20 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.20 4 178 7 1.00 244 1.00 116
48 0.30 4 178 7 1.00 244 1.00 116
64 0.40 4 178 7 1.00 244 1.00 116
80 0.50 4 178 7 1.00 244 1.00 116
96 0.60 4 178 7 1.00 244 1.00 116
112 0.70 4 178 7 1.00 244 1.00 116
128 0.80 4 178 7 1.00 244 1.00 116
144 0.90 4 178 7 1.00 244 1.00 116
160 1.00 4 178 7 1.00 244 1.00 116
176 1.10 4 178 7 1.00 244 1.00 116
192 1.20 4 178 7 1.00 244 1.00 116
208 1.30 4 178 7 1.00 244 1.00 116
224 1.40 4 178 7 1.00 244 1.00 116
240 1.50 4 178 7 1.00 244 1.00 116
256 1.60 4 178 7 1.00 244 1.00 116
272 1.70 4 178 7 1.00 244 1.00 116
288 1.80 4 178 7 1.00 244 1.00 116
304 1.90 4 178 7 1.00 244 1.00 116
320 2.00 4 178 7 1.00 244 1.00 116
336 2.10 4 178 7 1.00 244 1.00 116

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,328,044 423 0
undo block 530,570 165 0
undo header 44,042 37 1
1st level bmb 75,501 10 0
segment header 14,732 2 0
2nd level bmb 540 0 0
extent map 86 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 372,025 7,524 364,503 7,521 139 18.49
TX-Transaction (index contention) 41,343 41,342 0 40,520 124 3.06
HW-Segment High Water Mark 85,187 85,183 4 20,010 68 3.42
TX-Transaction 896,362 896,932 0 9,192 14 1.55
FB-Format Block 22,078 22,077 0 2,147 3 1.44
SQ-Sequence Cache 40,747 40,746 0 10,423 2 0.20
RO-Multiple Object Reuse (fast object reuse) 270 270 0 30 0 7.47
TX-Transaction (allocate ITL entry) 144 144 0 111 0 1.23
US-Undo Segment 356 356 0 5 0 18.20
PS-PX Process Reservation 120 108 12 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 TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 875.31 843,755 311 33   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
13-Feb 14:18 470,538 427,756 0 33 42 0/0 0/0/0/0/0/0
13-Feb 14:08 404,776 415,999 311 23 60 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 788 0.00   0 0  
AWR Alerted Metric Element list 9,719 0.00   0 0  
Consistent RBA 316,282 0.01 0.00 0 0  
FOB s.o list latch 19,249 1.19 0.00 0 0  
In memory undo latch 424,826,676 0.68 0.00 16 682,824 0.10
JOX SGA heap latch 1,725,169 0.00   0 0  
JS queue state obj latch 6,630 0.00   0 0  
JS slv state obj latch 56 0.00   0 0  
KMG MMAN ready and startup request latch 369 0.00   0 0  
KTF sga latch 3 0.00   0 361 0.00
KWQMN job cache list latch 205,683 0.72 0.00 0 0  
KWQP Prop Status 140 0.00   0 0  
MQL Tracking Latch 0     0 21 0.00
Memory Management Latch 0     0 369 0.00
OS process 1,746 0.00   0 0  
OS process allocation 1,530 0.39 0.00 0 0  
OS process: request allocation 1,038 0.19 0.00 0 0  
PL/SQL warning settings 1,301,755 0.00   0 0  
SGA IO buffer pool latch 1,824 0.00   0 1,824 0.05
SQL memory manager latch 1 0.00   0 368 0.00
SQL memory manager workarea list latch 306,018 0.04 0.00 0 0  
Shared B-Tree 730 0.00   0 0  
active checkpoint queue latch 96,982 0.03 0.00 0 0  
active service list 4,347 1.06 0.02 0 427 0.00
begin backup scn array 20 0.00   0 0  
bq:time manger info latch 39 0.00   0 0  
bufq statistics 9 0.00   0 0  
cache buffer handles 3,898,572 1.70 0.00 0 0  
cache buffers chains 2,345,883,819 2.16 0.00 85 11,949,132 4.33
cache buffers lru chain 5,126,521 0.70 0.00 3 26,899,771 0.78
cache table scan latch 2,203 0.00   0 2,203 0.00
channel handle pool latch 10,510 0.08 0.00 0 0  
channel operations parent latch 43,669 0.21 0.01 0 0  
checkpoint queue latch 4,223,001 0.02 0.01 0 1,475,556 0.03
client/application info 5,370 0.00   0 0  
commit callback allocation 222,326 0.21 0.00 0 0  
compile environment latch 41,834 0.00   0 0  
dictionary lookup 49 6.12 1.00 0 0  
dml lock allocation 5,002,141 11.68 0.00 4 0  
dummy allocation 1,122 2.85 0.00 0 0  
enqueue hash chains 8,082,224 2.04 0.00 1 472 0.21
enqueues 1,513,509 0.87 0.00 0 0  
error message lists 50 10.00 0.00 0 0  
event group latch 518 0.39 0.00 0 0  
file cache latch 20,929 0.02 0.00 0 0  
global KZLD latch for mem in SGA 486 0.00   0 0  
global ctx hash table latch 275,864 0.00   0 0  
hash table column usage latch 895 0.34 0.00 0 30,473 0.00
hash table modification latch 49 0.00   0 0  
job workq parent latch 0     0 36 0.00
job_queue_processes parameter latch 36 0.00   0 0  
kks stats 2,071 0.77 0.00 0 0  
ksuosstats global area 76 0.00   0 0  
ktm global data 1,742 0.00   0 0  
kwqbsn:qsga 681 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 319,407 0.22 0.00 0 0  
library cache 231,781,321 4.14 0.00 95 170 201.18
library cache load lock 326 1.53 0.00 0 0  
library cache lock 14,516,652 1.31 0.00 5 0  
library cache lock allocation 49,344 0.02 0.00 0 0  
library cache pin 150,881,603 2.22 0.00 29 0  
library cache pin allocation 115,754 0.21 0.00 0 0  
list of block allocation 306,399 0.24 0.00 0 0  
loader state object freelist 6,144 0.36 0.00 0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 10,118 0.05 0.00 0 0  
messages 1,120,164 0.48 0.00 0 0  
mostly latch-free SCN 345,039 3.75 0.00 0 0  
multiblock read objects 10,778 0.00   0 0  
ncodef allocation latch 22 0.00   0 0  
object queue header heap 596,396 0.00 0.00 0 14,690 0.01
object queue header operation 10,647,877 0.10 0.00 0 0  
object stats modification 10,276 0.07 0.00 0 0  
parallel query alloc buffer 600 6.33 0.00 0 0  
parallel query stats 30 63.33 0.00 0 0  
parameter list 1,572 0.19 0.00 0 0  
parameter table allocation management 581 5.16 0.00 0 0  
post/wait queue 324,489 2.31 0.00 0 144,584 3.08
process allocation 1,040 1.54 0.00 0 502 3.19
process group creation 1,038 0.10 0.00 0 0  
process queue 316 3.16 0.00 0 0  
process queue reference 95,881 0.42 0.00 0 5,563 2.86
qmn state object latch 1 0.00   0 0  
qmn task queue latch 1,461 4.45 0.00 0 0  
query server freelists 270 29.26 0.00 0 0  
query server process 12 0.00   0 12 0.00
redo allocation 2,758,567 5.46 0.00 6 62,864,760 2.85
redo copy 0     0 63,025,393 0.07
redo writing 1,337,018 0.01 0.11 0 0  
resmgr group change latch 3,231 0.00   0 0  
resmgr:actses active list 1,612 0.43 0.00 0 0  
resmgr:actses change group 1,513 0.00   0 0  
resmgr:free threads list 1,119 2.14 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 29,598,151 3.93 0.00 8 1 0.00
rules engine aggregate statistics 105,001 3.12 0.00 0 0  
rules engine rule set statistics 419,889 1.28 0.00 0 0  
rules engine rule statistics 209,833 0.00   0 0  
sequence cache 6,077,425 1.85 0.00 0 0  
session allocation 6,317,176 3.29 0.00 5 0  
session idle bit 406,037 0.18 0.00 0 0  
session state list latch 3,073 2.02 0.00 0 0  
session switching 22 0.00   0 0  
session timer 427 0.00   0 0  
shared pool 12,403,962 3.13 0.00 2 0  
shared pool sim alloc 26 0.00   0 0  
shared pool simulator 2,157,352 0.02 0.00 0 0  
slave class 2 0.00   0 0  
slave class create 7 0.00   0 0  
sort extent pool 31,960 0.37 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temporary table state object allocation 516 1.74 0.00 0 0  
threshold alerts latch 506 0.00   0 0  
trace latch 4 0.00   0 0  
transaction allocation 22,074 0.02 0.00 0 0  
transaction branch allocation 22 0.00   0 0  
undo global data 515,259,600 2.77 0.00 4 5,740 0.05
user lock 1,980 0.25 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,345,883,819 50,633,123 232,560 50,438,951 0 0 0
undo global data 515,259,600 14,292,547 229 14,292,335 0 0 0
library cache 231,781,321 9,586,644 2,292 9,584,497 0 0 0
library cache pin 150,881,603 3,345,766 754 3,345,059 0 0 0
In memory undo latch 424,826,676 2,904,711 462 2,904,277 0 0 0
row cache objects 29,598,151 1,164,090 169 1,163,942 0 0 0
dml lock allocation 5,002,141 584,361 53 584,313 0 0 0
shared pool 12,403,962 388,350 121 388,236 0 0 0
session allocation 6,317,176 207,682 138 207,561 0 0 0
library cache lock 14,516,652 190,003 118 189,896 0 0 0
enqueue hash chains 8,082,224 164,877 25 164,856 0 0 0
redo allocation 2,758,567 150,616 487 150,159 0 0 0
sequence cache 6,077,425 112,441 6 112,436 0 0 0
cache buffers lru chain 5,126,521 35,853 135 35,733 0 0 0
enqueues 1,513,509 13,119 11 13,109 0 0 0
object queue header operation 10,647,877 10,608 18 10,591 0 0 0
post/wait queue 324,489 7,486 1 7,485 0 0 0
rules engine rule set statistics 419,889 5,354 2 5,353 0 0 0
KWQMN job cache list latch 205,683 1,491 5 1,486 0 0 0
checkpoint queue latch 4,223,001 781 6 776 0 0 0
channel operations parent latch 43,669 92 1 91 0 0 0
redo writing 1,337,018 85 9 76 0 0 0
active service list 4,347 46 1 45 0 0 0
dictionary lookup 49 3 3 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch kturbk 0 331 228
In memory undo latch ktiFlush: child 0 52 211
In memory undo latch ktiTxnPoolFree 0 52 0
In memory undo latch ktichg: child 0 16 18
In memory undo latch ktiBRacquire 0 7 0
In memory undo latch ktbgfc 0 2 5
In memory undo latch kticmt: child 0 2 0
KWQMN job cache list latch kwqmnuji: update job item 0 137 137
active service list ksws_event: ksws event 0 6 5
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 762,178 695,498
cache buffers chains kcbgtcr: kslbegin excl 0 196,211 90,875
cache buffers chains kcbchg: kslbegin: call CR func 0 139,479 437,941
cache buffers chains kcbgtcr: fast path 0 97,550 11,289
cache buffers chains kcbgcur: kslbegin 0 59,661 22,283
cache buffers chains kcbzgb: scan from tail. nowait 0 36,217 0
cache buffers chains kcbget: pin buffer 0 31,601 9,896
cache buffers chains kcbzwb 0 16,963 7,787
cache buffers chains kcbrls: kslbegin 0 11,021 59,626
cache buffers chains kcbget: exchange 0 738 1,363
cache buffers chains kcbcge 0 645 9,953
cache buffers chains kcbget: exchange rls 0 533 952
cache buffers chains kcbnlc 0 283 1,767
cache buffers chains kcb_is_private 0 216 6,664
cache buffers chains kcbgtcr: kslbegin shared 0 33 21
cache buffers chains kcbesc: escalate 0 29 8
cache buffers chains kcb_post_apply: kcbhq62 0 20 164
cache buffers chains kcbso1: set no access 0 15 75
cache buffers chains kcb_pre_apply: kcbhq61 0 11 1,515
cache buffers chains kcbnew: new latch again 0 10 0
cache buffers lru chain kcbzgws 0 66 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 50 0
cache buffers lru chain kcbzswcu 0 14 3
cache buffers lru chain kcbbic2 0 2 12
cache buffers lru chain kcbbxsv: move to being written 0 2 5
cache buffers lru chain kcbzgb: posted for free bufs 0 1 115
channel operations parent latch ksrchconnect() 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 3 0
checkpoint queue latch kcbswcu: Switch buffers 0 3 5
dictionary lookup kkdleqd 0 2 0
dictionary lookup kkdlgon: check 0 1 2
dml lock allocation ktaiam 0 36 48
dml lock allocation ktaidm 0 17 5
enqueue hash chains ksqrcl 0 14 4
enqueue hash chains ksqgtl3 0 11 21
enqueues ksqgel: create enqueue 0 7 10
enqueues ksqdel 0 4 1
library cache kglpndl: child: after processing 0 1,250 7
library cache kglpnp: child 0 463 720
library cache kglpnc: child 0 313 739
library cache kglpndl: child: before processing 0 109 473
library cache kglpin: child: heap processing 0 65 119
library cache kglobpn: child: 0 56 167
library cache kglhdgc: child: 0 11 13
library cache kglget: unpin heap 0 0 6 14
library cache kglhdgn: child: 0 5 31
library cache kglpin 0 5 0
library cache kglLockCursor 0 1 8
library cache kglupd: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 94 81
library cache lock kgllkal: child: multiinstance 0 24 37
library cache lock kgllkdl: child: no lock handle 0 7 0
library cache pin kglpndl 0 422 175
library cache pin kglpnp: child 0 169 223
library cache pin kglpnc: child 0 111 255
library cache pin kglpnal: child: alloc space 0 52 101
object queue header operation kcbw_link_q 0 79 10
object queue header operation kcbo_swap_buf 0 9 61
object queue header operation kcbo_switch_mq_bg 0 9 9
object queue header operation kcbo_switch_cq 0 8 21
object queue header operation kcbo_ivbo 0 5 8
object queue header operation kcbw_unlink_q 0 2 2
object queue header operation kcbo_write_q 0 1 0
post/wait queue ksliwat:remove 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 404 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 53 363
redo allocation kcrfw_redo_write: before write 0 17 18
redo allocation kcrfw_redo_write: more space 0 7 106
redo allocation kcrfw_redo_gen: redo allocation 2 0 6 0
redo writing kcrfw_post: rba scn pair 0 4 0
redo writing kcrfw_cal_target_rba 0 3 0
redo writing kcrfwcr 0 2 9
row cache objects kqreqd: reget 0 147 0
row cache objects kqrpre: find obj 0 13 167
row cache objects kqreqd 0 9 2
rules engine rule set statistics kwrsose: end collect rs stats 0 3 1
sequence cache kdnssd 0 5 0
sequence cache kdnnxt: cached seq 0 1 0
session allocation ksudlc 0 94 21
session allocation ksuprc 0 43 116
session allocation ksuxds: not user session 0 1 0
shared pool kghalo 0 62 90
shared pool kghfre 0 40 13
shared pool kghupr1 0 19 18
undo global data kturimugur: child 0 136 14
undo global data ktudba: KSLBEGIN 0 83 201
undo global data ktudnx:child 0 8 1
undo global data ktubnd:child 0 2 1

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 32,387,472 3.60
AR APPS_TS_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 16,657,952 1.85
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES_PK   INDEX 16,132,288 1.79
INV APPS_TS_TX_IDX MTL_SYSTEM_ITEMS_B_U1   INDEX 12,137,808 1.35
WSH APPS_TS_TX_IDX WSH_DELIVERY_DETAILS_U1   INDEX 11,363,168 1.26

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_79232   INDEX 923 0.96
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_79230   INDEX 699 0.73
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 527 0.55
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N4   INDEX 457 0.48
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 321 0.33

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 727,300 50.74
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_79232   INDEX 644,408 44.96
ASO APPS_TS_QUEUES SYS_IOT_TOP_130692   INDEX 15,634 1.09
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 13,058 0.91
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 12,207 0.85

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 5 17.24
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 5 17.24
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 4 13.79
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 3 10.34
AR APPS_TS_TX_DATA RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2 6.90

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_79232   INDEX 359,944 27.45
ASO APPS_TS_QUEUES SYS_IOT_TOP_130692   INDEX 154,641 11.79
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 122,044 9.31
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 98,852 7.54
ASO APPS_TS_QUEUES ASO_ORDER_FEEDBACK_T   TABLE 84,502 6.44

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 30 0.00 0   3 1
dc_constraints 160 50.00 0   160 49
dc_global_oids 1,201,109 0.00 0   4 81
dc_histogram_data 3,317 1.72 0   0 3,890
dc_histogram_defs 11,436 7.49 0   0 17,262
dc_object_grants 822 0.00 0   0 398
dc_object_ids 3,260,469 0.00 0   22 4,225
dc_objects 216,822 0.06 0   192 5,455
dc_profiles 504 0.00 0   0 1
dc_rollback_segments 1,293 0.23 0   27 37
dc_segments 26,679 0.23 0   18,630 5,507
dc_sequences 45,318 0.00 0   45,318 71
dc_table_scns 213,682 0.00 0   0 15
dc_tablespace_quotas 19,820 0.11 0   0 37
dc_tablespaces 278,448 0.00 0   0 56
dc_usernames 527,243 0.00 0   0 74
dc_users 4,272,482 0.00 0   0 249
outstanding_alerts 243 0.00 0   0 109


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 17,436 0.01 10,125,243 0.01 0 0
CLUSTER 1 0.00 2 0.00 0 0
INDEX 93 21.51 164 18.29 0 0
JAVA DATA 112 0.00 0   0 0
PIPE 108 0.00 108 0.00 0 0
SQL AREA 397 88.41 46,656,463 0.03 213 120
TABLE/PROCEDURE 16,192 0.30 15,130,427 0.02 10 0
TRIGGER 489 0.00 778,358 0.00 0 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 180.32   2.37 3.96 28 35 76 76
  Freeable 46.31 0.00 1.72 3.48 14   27 27
  SQL 12.45 5.93 0.18 0.31 1 5 70 64
  PL/SQL 4.54 1.83 0.06 0.04 0 0 76 76
E Other 143.96   1.95 2.58 22 35 74 74
  Freeable 58.69 0.00 2.35 4.31 14   25 25
  SQL 14.98 7.62 0.22 0.48 3 5 68 64
  PL/SQL 4.36 1.76 0.06 0.04 0 0 74 74

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 21,005,074,432  
Fixed Size 2,116,752  
Redo Buffers 64,991,232  
Variable Size 3,338,666,864  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 147.47 147.47 0.00
java joxlod exec hp 11.87 11.87 0.00
shared ASH buffers 22.50 22.50 0.00
shared CCursor 27.15 29.03 6.95
shared KGLS heap 31.52 31.96 1.37
shared PL/SQL MPCODE 42.64 42.99 0.81
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 1,315.63 1,296.21 -1.48
shared ktcmvcb   25.12  
shared library cache 33.71 35.56 5.47
shared sql area 190.95 202.08 5.83
streams free memory 1,023.99 1,023.99 0.00
  buffer_cache 20,032.00 20,032.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 61.98 61.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 6,310,249 -398,834 0
QMON Coordinator 8,896 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 NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber NameIncoming per secondOutgoing per secondSpilled per second
WFBESCL_20610 0 0 0
WFBESCL_20636 0 0 0
WFBESCL_20641 0 0 0
WFBESCL_20649 0 0 0
WFBESCL_20651 0 0 0
WFBESCL_20674 0 0 0
WFBESCL_20677 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
APPLSYS.WF_DEFERRED_QUEUE_M_R 104,676 0 104,870 224 648
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 NameBegin valueEnd value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_gby_hash_aggregation_enabled FALSE   
_index_join_enabled FALSE   
_kks_use_mutex_pin 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 /slot/ems2703/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db0/bdump   
compatible 10.2.0.3.0   
control_files /slot/ems2703/oracle/VIS/db/apps_st/data/cntrl01.dbf, /slot/ems2703/oracle/VIS/db/apps_st/data/cntrl02.dbf, /slot/ems2703/oracle/VIS/db/apps_st/data/cntrl03.dbf   
core_dump_dest /slot/ems2703/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db0/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_cache_advice off   
db_cache_size 10737418240   
db_files 512   
db_keep_cache_size 10267656192   
db_name VIS   
dml_locks 10000   
java_pool_size 167772160   
job_queue_processes 2   
large_pool_size 0   
lock_sga TRUE   
log_buffer 63021056   
log_checkpoint_interval 0   
log_checkpoint_timeout 0   
log_checkpoints_to_alert FALSE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 600   
optimizer_index_caching 0   
optimizer_index_cost_adj 50   
optimizer_secure_view_merging FALSE   
parallel_max_servers 12   
parallel_min_servers 0   
pga_aggregate_target 8589934592   
plsql_code_type INTERPRETED   
plsql_native_library_dir /slot/ems2703/oracle/VIS/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 200   
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 500   
session_max_open_files 20   
sessions 400   
shared_pool_reserved_size 1048576000   
shared_pool_size 2097152000   
streams_pool_size 1073741824   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /slot/ems2703/oracle/VIS/db/tech_st/10.2.0/admin/VIS_db0/udump   
utl_file_dir /usr/tmp, /slot/ems2703/oracle/VIS/db/tech_st/10.2.0/appsutil/outbound/VIS_db0   
workarea_size_policy AUTO   


Back to Top

End of Report