WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

VIS 210556022 VIS 1 10.2.0.3.0 NO vega7242.cup.hp.com

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 79 25-Aug-08 13:58:55 86 31.7

End Snap: 80 25-Aug-08 14:41:05 86 29.9

Elapsed: 42.17 (mins)

DB Time: 244.79 (mins)

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

Report Summary

Cache Sizes

Begin End

Buffer Cache: 23,472M 23,456M Std Block Size: 8K

Shared Pool Size: 1,024M 1,024M Log Buffer: 14,312K

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

Load Profile

Per Second Per Transaction

Redo size: 8,048,031.45 32,682.79

Logical reads: 492,191.30 1,998.77

Block changes: 49,192.06 199.77

Physical reads: 28.19 0.11

Physical writes: 886.51 3.60

User calls: 75.23 0.31

Parses: 815.55 3.31

Hard parses: 1.32 0.01

Sorts: 1,639.23 6.66

Logons: 0.34 0.00

Executes: 18,145.60 73.69

Transactions: 246.25

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

% Blocks changed per Read: 9.99 Recursive Call %: 99.77

Rollback per transaction %: 0.13 Rows per Sort: 3.12

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 100.00

Buffer Hit %: 99.99 In-memory Sort %: 100.00

Library Hit %: 99.78 Soft Parse %: 99.84

Execute to Parse %: 95.51 Latch Hit %: 98.04

Parse CPU to Parse Elapsd %: 53.80 % Non-Parse CPU: 99.75

Shared Pool Statistics

Begin End

Memory Usage %: 38.02 62.35

% SQL with executions>1: 85.86 83.03

% Memory for SQL w/exec>1: 83.81 86.61

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

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 13,232 90.1

log file sync 167,967 745 4 5.1 Commit

log file parallel write 215,806 568 3 3.9 System I/O

buffer busy waits 1,057,405 177 0 1.2 Concurrency

db file sequential read 20,815 79 4 .5 User I/O

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

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 14687.7s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

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

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

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

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

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

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

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

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

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

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 1,245,319,302
Captured SQL account for 31.1% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 71,326
Captured SQL account for 13.2% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 45,911,137
Captured SQL account for 23.8% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,063,463
Captured SQL account for 89.3% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

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

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0074pdmwb7fmv BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;

0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;

0r0gvtarcjwzz insert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)

0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;

1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3

1v818hwxjxy58 select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3

1wnq9qthbb54q BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;

2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#

39wym7tugc2sk SELECT PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE, LOT_CONTROL_CODE, SERIAL_NUMBER_CONTROL_CODE, AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER, INVENTORY_ASSET_FLAG, DESCRIPTION, CONCATENATED_SEGMENTS, SHELF_LIFE_CODE, SHELF_LIFE_DAYS, REVISION_QTY_CONTROL_CODE, LOCATION_CONTROL_CODE, DEFAULT_SERIAL_STATUS_ID, DEFAULT_LOT_STATUS_ID, nvl(RECEIVING_ROUTING_ID, -1) RECEIVING_ROUTING_ID, BOM_ITEM_TYPE, BASE_ITEM_ID, EAM_ITEM_TYPE, TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND, CHILD_LOT_FLAG, DEFAULT_GRADE, RETEST_INTERVAL, EXPIRATION_ACTION_INTERVAL, EXPIRATION_ACTION_CODE, MATURITY_DAYS, HOLD_DAYS, SECONDARY_UOM_CODE, GRADE_CONTROL_FLAG, nvl(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS_VL WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2

3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;

4h6x64v79na0t SELECT COUNT(1) FROM RA_CUSTOMER_TRX_LINES_ALL RCTL WHERE RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND RCTL.LINE_TYPE = 'LINE' AND RCTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(:B1 )

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

4y08a52989vfk BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;

4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;

5t39uchjqpyfm BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;

608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;

66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1

6h228dtb8hp1t SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT .ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID

6z9c18cxpxfq0 SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1

72yyswsqkzkrm BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;

76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;

7bdg2fscmus2h SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

7h2mgwhpy4qym INSERT INTO MTL_ONHAND_QUANTITIES_DETAIL (ONHAND_QUANTITIES_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID, OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE, DATE_RECEIVED, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, PRIMARY_TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE, TRANSACTION_QUANTITY, SECONDARY_UOM_CODE, SECONDARY_TRANSACTION_QUANTITY, SUBINVENTORY_CODE, LOT_NUMBER, REVISION, LOCATOR_ID, CREATE_TRANSACTION_ID, UPDATE_TRANSACTION_ID, ORIG_DATE_RECEIVED, COST_GROUP_ID, LPN_ID, CONTAINERIZED_FLAG, IS_CONSIGNED, PROJECT_ID, TASK_ID) VALUES (MTL_ONHAND_QUANTITIES_S.nextval, :1, :2, decode(nvl(:3, 0), 0, 2, :4), decode(nvl(:5, 0), 0, :6, :7), decode(nvl(:8, 0), 0, 2, :9), nvl(:10, :11), nvl(:12, 2), :13, SYSDATE, :14, SYSDATE, :15, :16, round(:17, 5), :18, round(((:19*:20)/:21), 5), :22, round( NVL(:23, :24), :25) + :26, :27, :28, :29, DECODE(:30, 0, '', :31), :32, :33, :34, :35, :36, nvl(:37, 2), :38, :39, :40)

7mrs575bj7a41 begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;

7mz96k4qtxrzr SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC

7ptvbaycjtbg4 BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;

8upd356sbxqat SELECT LOOKUP_CODE FROM ASO_LOOKUPS WHERE LOOKUP_TYPE = 'ASO_ORDER_FEEDBACK_CRM_APPS' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE)

8zfgv4ck11dw9 BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;

9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;

a40f9h91scg23 select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2

assndb4wqnd6r BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;

b73h3md2wvs09 SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)

bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;

bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;

bsa0wjtftg3uw select file# from file$ where ts#=:1

bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE

cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1

cdjud36xbtuu5 SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE'

cqc8bmqp529tz begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures ) ; END ;

cw171rvngr1w9 begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;

d1swc9auhtxwd BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;

dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;

fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;

fvcbstf9s6a5r begin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;

g2qs4xk48vcwy select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)

g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;

gdnwgx9fcxggr begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;

ggak0dvtsppv3 SELECT /*+ leading(wias) index(wias, WF_ITEM_ACTIVITY_STATUSES_PK) */ WPA.INSTANCE_ID FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA WHERE WPA.ACTIVITY_ITEM_TYPE = :B2 AND WPA.ACTIVITY_NAME = :B1 AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B4 AND WIAS.ITEM_KEY = :B3

ghmx8n7wgqvfr begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;

gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )

gnng1rmpjxzsx begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

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

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

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

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

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

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

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

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

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

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

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

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

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

Back to Advisory Statistics
Back to Top

SGA Target Advisory

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

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

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

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

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

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

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

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

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

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

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

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,245,319,302
Captured Segments account for 32.6% of Total

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

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 71,326
Captured Segments account for 12.9% of Total

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

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

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

Back to Segment Statistics
Back to Top

Segments by ITL Waits

% of Capture shows % of ITL waits for each top segment compared
with total ITL waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	ITL Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1	INDEX	3	37.50
INV	APPS_TS_TX_IDX	MTL_MATERIAL_TRANSACTIONS_N3	INDEX	1	12.50
AR	APPS_TS_TX_IDX	RA_CUST_TRX_LINE_GL_DIST_N5	INDEX	1	12.50
AR	APPS_TS_TX_IDX	RA_CUST_TRX_LINE_GL_DIST_N6	INDEX	1	12.50
ASO	APPS_TS_QUEUES	SYS_IOT_TOP_115213	INDEX	1	12.50

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

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

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

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

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	32,780	1.22	10,131,504	0.01	0	0
CLUSTER	50	0.00	115	0.00	0	0
INDEX	379	9.23	513	9.75	0	0
JAVA DATA	261	1.15	1,044	1.72	0	0
PIPE	378	0.00	378	0.00	0	0
SQL AREA	9,617	94.56	49,241,699	0.33	2	45
TABLE/PROCEDURE	47,003	8.68	15,313,697	0.03	3	0
TRIGGER	1,430	1.12	787,343	-0.13	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	225.15		2.62	6.00	53	53	86	86
	Freeable	53.56	0.00	0.89	1.63	10		60	60
	SQL	13.89	6.75	0.17	0.23	1	3	81	79
	PL/SQL	6.17	2.37	0.07	0.05	0	0	86	86
E	Other	215.19		2.50	5.21	45	52	86	86
	Freeable	57.00	0.00	0.97	1.89	10		59	59
	SQL	17.32	8.80	0.21	0.55	5	5	81	79
	PL/SQL	5.97	2.39	0.07	0.04	0	0	86	86

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

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

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	15,633,821	19,826	0
QMON Coordinator	30,720	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

The Spill Rate should be very close to zero
The Diff in Percentage Spilled should be very close to zero or negative

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

Back to Streams Statistics
Back to Top

Buffered Subscribers

All Subscribers should have a zero spill rate

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

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

End of Report

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

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