WORKLOAD REPOSITORY report for

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

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2593	10-Sep-08 18:56:00	91	29.5
End Snap:	2594	10-Sep-08 19:44:41	92	29.6
Elapsed:		48.69 (mins)
DB Time:		305.61 (mins)

 

Report Summary

Cache Sizes

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

Load Profile

	Per Second	Per Transaction
Redo size:	7,112,301.32	34,003.35
Logical reads:	461,064.18	2,204.31
Block changes:	43,185.47	206.47
Physical reads:	20.17	0.10
Physical writes:	536.93	2.57
User calls:	58.26	0.28
Parses:	673.93	3.22
Hard parses:	0.22	0.00
Sorts:	1,614.12	7.72
Logons:	0.15	0.00
Executes:	15,595.63	74.56
Transactions:	209.16

% Blocks changed per Read:	9.37	Recursive Call %:	99.79
Rollback per transaction %:	0.15	Rows per Sort:	3.17

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.92	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.99	Soft Parse %:	99.97
Execute to Parse %:	95.68	Latch Hit %:	98.00
Parse CPU to Parse Elapsd %:	25.44	% Non-Parse CPU:	99.85

Shared Pool Statistics

	Begin	End
Memory Usage %:	33.24	33.80
% SQL with executions>1:	94.64	91.51
% Memory for SQL w/exec>1:	95.50	95.21

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		8,481		46.3
log file parallel write	451,803	374	1	2.0	System I/O
log file sync	101,895	357	4	1.9	Commit
buffer busy waits	1,051,355	357	0	1.9	Concurrency
db file sequential read	43,580	168	4	.9	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

Back to Top

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Back to Top

Time Model Statistics

• Total time in database user-calls (DB Time): 18336.8s
• 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	18,326.16	99.94
DB CPU	8,481.13	46.25
PL/SQL execution elapsed time	4,200.96	22.91
Java execution elapsed time	543.84	2.97
parse time elapsed	64.99	0.35
sequence load elapsed time	11.18	0.06
hard parse elapsed time	7.56	0.04
repeated bind elapsed time	5.76	0.03
connection management call elapsed time	0.93	0.01
PL/SQL compilation elapsed time	0.57	0.00
hard parse (sharing criteria) elapsed time	0.49	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
inbound PL/SQL rpc elapsed time	0.01	0.00
DB time	18,336.84
background elapsed time	771.86
background cpu time	126.80

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
Concurrency	1,115,431	0.03	554	0	1.83
System I/O	568,869	0.00	509	1	0.93
Commit	101,895	0.00	357	4	0.17
User I/O	53,160	0.00	184	3	0.09
Application	15,137	0.00	135	9	0.02
Other	156,592	37.00	65	0	0.26
Configuration	20,019	43.13	10	0	0.03
Network	304,801	0.00	2	0	0.50

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 parallel write	451,803	0.00	374	1	0.74
log file sync	101,895	0.00	357	4	0.17
buffer busy waits	1,051,355	0.00	357	0	1.72
db file sequential read	43,580	0.00	168	4	0.07
enq: TX - row lock contention	14,319	0.00	134	9	0.02
db file parallel write	113,275	0.00	133	1	0.19
latch: cache buffers chains	34,293	0.00	73	2	0.06
enq: TX - index contention	20,634	0.00	42	2	0.03
latch: library cache	2,850	0.00	40	14	0.00
latch free	2,184	0.00	19	9	0.00
read by other session	6,251	0.00	14	2	0.01
enq: TX - contention	8,417	0.00	14	2	0.01
latch: library cache pin	1,020	0.00	13	13	0.00
latch: In memory undo latch	2,631	0.00	9	3	0.00
enq: HW - contention	6,204	0.00	9	1	0.01
latch: shared pool	674	0.00	6	9	0.00
LGWR wait for redo copy	22,028	0.27	6	0	0.04
latch: row cache objects	564	0.00	6	10	0.00
cursor: pin S wait on X	366	88.80	5	15	0.00
latch: undo global data	2,006	0.00	5	2	0.00
latch: redo allocation	934	0.00	4	5	0.00
buffer deadlock	32,123	99.57	4	0	0.05
latch: session allocation	251	0.00	3	12	0.00
latch: library cache lock	130	0.00	3	21	0.00
latch: enqueue hash chains	189	0.00	3	14	0.00
db file scattered read	1,898	0.00	3	1	0.00
enq: FB - contention	2,005	0.00	2	1	0.00
control file parallel write	1,420	0.00	2	1	0.00
rdbms ipc reply	1,001	0.00	2	2	0.00
latch: cache buffers lru chain	270	0.00	2	6	0.00
SQL*Net more data to client	152,186	0.00	1	0	0.25
enq: SQ - contention	5,121	0.00	1	0	0.01
cursor: pin S	57,089	0.00	1	0	0.09
kksfbc child completion	14	92.86	1	45	0.00
control file sequential read	2,371	0.00	0	0	0.00
PX Deq Credit: send blkd	2,028	0.00	0	0	0.00
os thread startup	17	0.00	0	20	0.00
PX Deq: Signal ACK	22	50.00	0	13	0.00
SQL*Net break/reset to client	790	0.00	0	0	0.00
row cache lock	890	0.00	0	0	0.00
latch: object queue header operation	55	0.00	0	2	0.00
latch: checkpoint queue latch	7	0.00	0	18	0.00
direct path read	1,118	0.00	0	0	0.00
SQL*Net more data from client	7,278	0.00	0	0	0.01
enq: RO - fast object reuse	28	0.00	0	3	0.00
SQL*Net message to client	145,337	0.00	0	0	0.24
local write wait	44	0.00	0	2	0.00
undo segment extension	8,648	99.84	0	0	0.01
library cache lock	3	0.00	0	11	0.00
PX qref latch	25,923	99.81	0	0	0.04
direct path write	265	0.00	0	0	0.00
latch: redo writing	8	0.00	0	3	0.00
reliable message	20	0.00	0	1	0.00
wait list latch free	1	0.00	0	10	0.00
L1 validation	4	25.00	0	2	0.00
latch: cache buffer handles	7	0.00	0	1	0.00
latch: messages	6	0.00	0	1	0.00
enq: TX - allocate ITL entry	38	0.00	0	0	0.00
direct path write temp	4	0.00	0	0	0.00
enq: PS - contention	8	0.00	0	0	0.00
cursor: mutex X	4	0.00	0	0	0.00
SQL*Net message from client	145,336	0.00	96,438	664	0.24
Streams AQ: waiting for messages in the queue	1,552	98.97	11,426	7362	0.00
pipe get	1,849	100.00	5,703	3084	0.00
Streams AQ: waiting for time management or cleanup tasks	88	39.77	3,520	40002	0.00
PL/SQL lock timer	531	99.44	3,212	6048	0.00
Streams AQ: qmn slave idle wait	444	0.00	2,842	6401	0.00
Streams AQ: qmn coordinator idle wait	1,135	39.12	2,842	2504	0.00
PX Idle Wait	1,241	96.70	2,358	1900	0.00
jobq slave wait	206	98.06	600	2911	0.00
PX Deq: Execution Msg	506	0.00	5	10	0.00
PX Deq: Execute Reply	228	0.00	0	2	0.00
PX Deq: Msg Fragment	343	0.00	0	0	0.00
PX Deq: Table Q Normal	1,248	0.00	0	0	0.00
PX Deq Credit: need buffer	617	0.00	0	0	0.00
PX Deq: Parse Reply	23	0.00	0	1	0.00
PX Deq: Join ACK	21	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	451,803	0.00	374	1	0.74
db file parallel write	113,275	0.00	133	1	0.19
events in waitclass Other	23,646	0.25	9	0	0.04
control file parallel write	1,420	0.00	2	1	0.00
db file scattered read	400	0.00	1	1	0.00
db file sequential read	276	0.00	1	2	0.00
control file sequential read	686	0.00	0	0	0.00
os thread startup	9	0.00	0	22	0.00
buffer busy waits	117	0.00	0	0	0.00
latch: cache buffers chains	6	0.00	0	7	0.00
direct path write	258	0.00	0	0	0.00
latch: redo writing	8	0.00	0	3	0.00
latch: shared pool	1	0.00	0	2	0.00
direct path read	1,106	0.00	0	0	0.00
latch: library cache	1	0.00	0	1	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
rdbms ipc message	401,516	2.21	24,448	61	0.66
Streams AQ: waiting for time management or cleanup tasks	88	39.77	3,520	40002	0.00
smon timer	2,213	0.00	2,945	1331	0.00
pmon timer	1,007	100.00	2,848	2828	0.00
Streams AQ: qmn slave idle wait	444	0.00	2,842	6401	0.00
Streams AQ: qmn coordinator idle wait	1,135	39.12	2,842	2504	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	197,917
AVG_IDLE_TIME	94,436
AVG_IOWAIT_TIME	1,398
AVG_SYS_TIME	6,568
AVG_USER_TIME	191,262
BUSY_TIME	1,583,977
IDLE_TIME	756,184
IOWAIT_TIME	11,755
SYS_TIME	53,198
USER_TIME	1,530,779
LOAD	0
OS_CPU_WAIT_TIME	1,720,800
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,420,214,272
NUM_CPUS	8
NUM_CPU_CORES	4

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	18,290.80	8,456.80	54,145	1,331,975,456
SYS$USERS	46.10	24.30	467	12,048,640
SYS$BACKGROUND	0.00	0.00	4,276	2,830,037

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
VIS	50383	18160	1115291	55353	0	0	303660	155
SYS$USERS	733	156	5	1	0	0	45	0
SYS$BACKGROUND	2040	110	135	30	0	0	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

Back to Top

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
6,713	2,554	8	839.19	36.61	8zfgv4ck11dw9	FNDWFBG	BEGIN WF_ENGINE.BACKGROUNDCONC...
5,175	2,589	16	323.43	28.22	4y08a52989vfk	WSHPSGL_SUB	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,454	1,166	49,788	0.05	13.38	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
2,318	724	100	23.18	12.64	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,967	1,018	10	196.73	10.73	72yyswsqkzkrm	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,571	461	49,993	0.03	8.57	9wdrypwkpf607	FNDWFBG	begin OE_FULFILL_WF.START_FULF...
772	613	149,967	0.01	4.21	3b3psftuyks81	WSHPSGL_SUB	BEGIN INV_TXNSTUB_PUB.postTran...
711	396	49,998	0.01	3.88	4yak7x2zqz0dh	WSHPSGL_SUB	BEGIN inv_transfer_order_pvt.f...
710	361	10	71.01	3.87	0074pdmwb7fmv	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
523	450	204,624	0.00	2.85	0r0gvtarcjwzz	WSHINTERFACES	insert into "ASO"."ASO_ORDER_F...
458	406	49,774	0.01	2.50	gnng1rmpjxzsx	FNDWFBG	begin OE_CLOSE_WF.CLOSE_LINE (...
432	423	354,854	0.00	2.36	cdjud36xbtuu5	OEHVIMP	SELECT WIAS.PROCESS_ACTIVITY, ...
373	228	49,999	0.01	2.03	assndb4wqnd6r	INCTCW	BEGIN INV_TXN_MANAGER_PUB.rel_...
361	338	2,817,790	0.00	1.97	66tmsr3446uqn	OEHVIMP	SELECT WIAS.ACTIVITY_STATUS, ...
332	286	1,689,788	0.00	1.81	cd9mbmqyf4qhp	OEHVIMP	UPDATE WF_ITEM_ACTIVITY_STATUS...
322	321	399,498	0.00	1.75	52zwqr7xyrc2m	WSHPSGL_SUB	SELECT 'Y' FROM WSH_PR_WORKERS...
221	202	1,344,406	0.00	1.21	gnhmcahkmrnzs	OEHVIMP	INSERT INTO WF_ITEM_ACTIVITY_S...
195	151	54,983	0.00	1.07	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...

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
2,589	5,175	16	161.84	28.22	4y08a52989vfk	WSHPSGL_SUB	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,554	6,713	8	319.21	36.61	8zfgv4ck11dw9	FNDWFBG	BEGIN WF_ENGINE.BACKGROUNDCONC...
1,166	2,454	49,788	0.02	13.38	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
1,018	1,967	10	101.82	10.73	72yyswsqkzkrm	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
724	2,318	100	7.24	12.64	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
613	772	149,967	0.00	4.21	3b3psftuyks81	WSHPSGL_SUB	BEGIN INV_TXNSTUB_PUB.postTran...
461	1,571	49,993	0.01	8.57	9wdrypwkpf607	FNDWFBG	begin OE_FULFILL_WF.START_FULF...
450	523	204,624	0.00	2.85	0r0gvtarcjwzz	WSHINTERFACES	insert into "ASO"."ASO_ORDER_F...
423	432	354,854	0.00	2.36	cdjud36xbtuu5	OEHVIMP	SELECT WIAS.PROCESS_ACTIVITY, ...
406	458	49,774	0.01	2.50	gnng1rmpjxzsx	FNDWFBG	begin OE_CLOSE_WF.CLOSE_LINE (...
396	711	49,998	0.01	3.88	4yak7x2zqz0dh	WSHPSGL_SUB	BEGIN inv_transfer_order_pvt.f...
361	710	10	36.14	3.87	0074pdmwb7fmv	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
338	361	2,817,790	0.00	1.97	66tmsr3446uqn	OEHVIMP	SELECT WIAS.ACTIVITY_STATUS, ...
321	322	399,498	0.00	1.75	52zwqr7xyrc2m	WSHPSGL_SUB	SELECT 'Y' FROM WSH_PR_WORKERS...
286	332	1,689,788	0.00	1.81	cd9mbmqyf4qhp	OEHVIMP	UPDATE WF_ITEM_ACTIVITY_STATUS...
228	373	49,999	0.00	2.03	assndb4wqnd6r	INCTCW	BEGIN INV_TXN_MANAGER_PUB.rel_...
202	221	1,344,406	0.00	1.21	gnhmcahkmrnzs	OEHVIMP	INSERT INTO WF_ITEM_ACTIVITY_S...
151	195	54,983	0.00	1.07	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...

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,346,854,232
• Captured SQL account for 37.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
577,609,853	16	36,100,615.81	42.89	2589.45	5174.86	4y08a52989vfk	WSHPSGL_SUB	BEGIN WSH_PICK_LIST.RELEASE_BA...
233,130,880	8	29,141,360.00	17.31	2553.69	6713.48	8zfgv4ck11dw9	FNDWFBG	BEGIN WF_ENGINE.BACKGROUNDCONC...
231,447,575	10	23,144,757.50	17.18	1018.17	1967.30	72yyswsqkzkrm	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
103,824,973	354,854	292.59	7.71	422.72	431.83	cdjud36xbtuu5	OEHVIMP	SELECT WIAS.PROCESS_ACTIVITY, ...
88,093,572	399,498	220.51	6.54	321.44	321.56	52zwqr7xyrc2m	WSHPSGL_SUB	SELECT 'Y' FROM WSH_PR_WORKERS...
80,018,767	100	800,187.67	5.94	723.56	2318.43	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
70,331,043	149,967	468.98	5.22	613.29	771.91	3b3psftuyks81	WSHPSGL_SUB	BEGIN INV_TXNSTUB_PUB.postTran...
68,126,450	49,998	1,362.58	5.06	396.33	711.00	4yak7x2zqz0dh	WSHPSGL_SUB	BEGIN inv_transfer_order_pvt.f...
63,915,901	49,788	1,283.76	4.75	1165.61	2454.03	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
59,017,401	2,817,790	20.94	4.38	337.94	360.70	66tmsr3446uqn	OEHVIMP	SELECT WIAS.ACTIVITY_STATUS, ...
53,748,695	10	5,374,869.50	3.99	361.42	710.13	0074pdmwb7fmv	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
46,427,419	1,689,788	27.48	3.45	286.25	332.41	cd9mbmqyf4qhp	OEHVIMP	UPDATE WF_ITEM_ACTIVITY_STATUS...
25,838,066	49,993	516.83	1.92	461.42	1571.19	9wdrypwkpf607	FNDWFBG	begin OE_FULFILL_WF.START_FULF...
25,328,793	309,854	81.74	1.88	148.61	155.58	b73h3md2wvs09	OEHVIMP	SELECT C.INSTANCE_ID FROM WF_P...
24,809,841	1,344,406	18.45	1.84	201.88	221.15	gnhmcahkmrnzs	OEHVIMP	INSERT INTO WF_ITEM_ACTIVITY_S...
22,322,815	4	5,580,703.75	1.66	149.01	156.88	7ptvbaycjtbg4	ARTERRPW	BEGIN arp_run.revenue_recognit...
21,799,556	54,983	396.48	1.62	151.18	195.36	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...
19,328,037	29,908	646.25	1.44	95.47	96.13	6uwctg1cdb25v	WSHPSGL_SUB	SELECT DG.DELIVERY_LEG_ID LEG_...
17,469,736	149,552	116.81	1.30	94.77	99.40	6z9c18cxpxfq0	WSHPSGL_SUB	SELECT NVL(COMMS_NL_TRACKABLE_...
15,897,514	99,636	159.56	1.18	94.03	96.08	6h228dtb8hp1t	WSHPSGL_SUB	SELECT X.ORGANIZATION_ID ORGAN...
15,211,473	49,992	304.28	1.13	78.90	78.90	fvcbstf9s6a5r	OEHVIMP	begin WF_STANDARD.WAITFORFLOW ...
14,478,960	3	4,826,320.00	1.08	177.10	177.57	1wnq9qthbb54q	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
14,252,509	2	7,126,254.50	1.06	136.98	136.98	cqc8bmqp529tz	RAXTRX	begin arp_etax_autoinv_util . ...
14,226,352	56	254,042.00	1.06	61.66	109.45	by0sg8ccaazuk	OEHVIMP	UPDATE MRP_ATP_SCHEDULE_TEMP S...
14,030,847	4	3,507,711.75	1.04	132.61	138.90	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 58,915
• Captured SQL account for 1.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
32,522	8	4,065.25	55.20	2553.69	6713.48	8zfgv4ck11dw9	FNDWFBG	BEGIN WF_ENGINE.BACKGROUNDCONC...
31,741	49,788	0.64	53.88	1165.61	2454.03	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
8,951	4	2,237.75	15.19	132.61	138.90	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...
3,048	16	190.50	5.17	2589.45	5174.86	4y08a52989vfk	WSHPSGL_SUB	BEGIN WSH_PICK_LIST.RELEASE_BA...
1,772	10	177.20	3.01	361.42	710.13	0074pdmwb7fmv	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,258	10	125.80	2.14	1018.17	1967.30	72yyswsqkzkrm	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
719	3	239.67	1.22	177.10	177.57	1wnq9qthbb54q	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
579	54,983	0.01	0.98	151.18	195.36	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...
360	1,689,788	0.00	0.61	286.25	332.41	cd9mbmqyf4qhp	OEHVIMP	UPDATE WF_ITEM_ACTIVITY_STATUS...
265	100	2.65	0.45	723.56	2318.43	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 45,557,722
• Captured SQL account for 24.3% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
2,817,790	1,527,481	0.54	0.00	0.00	66tmsr3446uqn	OEHVIMP	SELECT WIAS.ACTIVITY_STATUS, ...
1,689,788	1,689,606	1.00	0.00	0.00	cd9mbmqyf4qhp	OEHVIMP	UPDATE WF_ITEM_ACTIVITY_STATUS...
1,344,406	1,344,184	1.00	0.00	0.00	gnhmcahkmrnzs	OEHVIMP	INSERT INTO WF_ITEM_ACTIVITY_S...
399,498	49,998	0.13	0.00	0.00	52zwqr7xyrc2m	WSHPSGL_SUB	SELECT 'Y' FROM WSH_PR_WORKERS...
398,209	396,187	0.99	0.00	0.00	7bdg2fscmus2h	WSHINTERFACES	SELECT ACCOUNTING_RULE_ID , A...
354,854	0	0.00	0.00	0.00	cdjud36xbtuu5	OEHVIMP	SELECT WIAS.PROCESS_ACTIVITY, ...
309,854	308,490	1.00	0.00	0.00	b73h3md2wvs09	OEHVIMP	SELECT C.INSTANCE_ID FROM WF_P...
204,624	204,010	1.00	0.00	0.00	0r0gvtarcjwzz	WSHINTERFACES	insert into "ASO"."ASO_ORDER_F...
199,847	199,446	1.00	0.00	0.00	fb13x9qx0ftks	OEHVIMP	begin OE_STANDARD_WF.OEOL_SELE...
199,831	199,445	1.00	0.00	0.00	ghmx8n7wgqvfr	WSHINTERFACES	begin WF_STANDARD.DEFER (:v1, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 1,968,668
• Captured SQL account for 93.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
199,727	199,831	10.15	ghmx8n7wgqvfr	WSHINTERFACES	begin WF_STANDARD.DEFER (:v1, ...
199,631	199,847	10.14	fb13x9qx0ftks	OEHVIMP	begin OE_STANDARD_WF.OEOL_SELE...
149,581	149,987	7.60	0mdnts20d60yr	WSHPSGL_SUB	declare v_ret number := 0...
99,573	99,839	5.06	1c0b7sas42w2z	WSHPSGL_SUB	SELECT NVL(ITEM_COST, 0), ...
99,332	99,628	5.05	1v818hwxjxy58	WSHINTERFACES	select FND_FLEX_VALUES_VL.FLEX...
59,978	59,984	3.05	bf7uwg5pa3pj6	WSHINTERFACES	begin FND_FLEX_WORKFLOW_APIS.V...
59,964	59,967	3.05	76sw2a4vnc89j	WSHINTERFACES	begin FND_FLEX_WORKFLOW_APIS.S...
59,958	59,971	3.05	608c0n36kaw62	WSHINTERFACES	begin FND_FLEX_WORKFLOW_APIS.C...
59,958	59,976	3.05	dcvv68fju01g4	WSHINTERFACES	begin FND_FLEX_WORKFLOW_APIS.E...
53,964	54,983	2.74	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...
49,994	49,993	2.54	9wdrypwkpf607	FNDWFBG	begin OE_FULFILL_WF.START_FULF...
49,983	49,788	2.54	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
49,949	49,979	2.54	bfbyqwbr4vwms	OEHVIMP	begin OE_OEOL_SCH.SCHEDULE_LIN...
49,902	49,980	2.53	cw171rvngr1w9	WSHINTERFACES	begin OE_FLEX_COGS_PUB.GET_COS...
49,880	49,920	2.53	gdnwgx9fcxggr	OEHVIMP	begin OE_SHIPPING_WF.START_SHI...
49,861	49,908	2.53	7mrs575bj7a41	OEHVIMP	begin OE_OEOL_SCH.BRANCH_ON_SO...
49,825	49,992	2.53	fvcbstf9s6a5r	OEHVIMP	begin WF_STANDARD.WAITFORFLOW ...
49,779	49,955	2.53	g2qs4xk48vcwy	WSHINTERFACES	select to_char(CODE_COMBINATIO...
49,730	49,774	2.53	gnng1rmpjxzsx	FNDWFBG	begin OE_CLOSE_WF.CLOSE_LINE (...
49,614	49,742	2.52	7mz96k4qtxrzr	WSHPSGL_SUB	SELECT BASE.REVISION , BASE.LO...
49,577	49,942	2.52	bsuw7pmwrufpy	INCTCW	SELECT reservation_...
49,440	49,796	2.51	a40f9h91scg23	WSHINTERFACES	select to_char(CODE_COMBINATIO...
44,970	44,981	2.28	7gtztzv329wg0		select c.name, u.name from co...
44,962	44,981	2.28	2skwhauh2cwky		select o.name, u.name from ob...
41,751	41,752	2.12	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
22,348	22,348	1.14	bsa0wjtftg3uw		select file# from file$ where ...
21,531	21,531	1.09	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...

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,473,584	398,209	0.07	7bdg2fscmus2h	WSHINTERFACES	SELECT ACCOUNTING_RULE_ID , A...
1,118,534	512	0.05	g345hj2ua4pf9	WSHPSGL_SUB	INSERT INTO MTL_TRANSACTION_LO...

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#
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfk	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52zwqr7xyrc2m	SELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT
5t39uchjqpyfm	BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
66tmsr3446uqn	SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6h228dtb8hp1t	SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT .ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
6uwctg1cdb25v	SELECT DG.DELIVERY_LEG_ID LEG_ID, ST1.STOP_LOCATION_ID PICKUP, ST2.STOP_LOCATION_ID DROPOFF FROM WSH_DELIVERY_LEGS DG, WSH_TRIP_STOPS ST1, WSH_TRIP_STOPS ST2 WHERE DG.DELIVERY_ID = :B2 AND ST1.STOP_ID = DG.PICK_UP_STOP_ID AND ST2.STOP_ID = DG.DROP_OFF_STOP_ID AND ST1.STOP_LOCATION_ID = :B1
6z9c18cxpxfq0	SELECT NVL(COMMS_NL_TRACKABLE_FLAG, 'N') FROM MTL_SYSTEM_ITEMS A, MTL_MATERIAL_TRANSACTIONS B WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND NVL(B.INVENTORY_ITEM_ID, -1) <> -1 AND ENABLED_FLAG = 'Y' AND NVL(START_DATE_ACTIVE, SYSDATE) <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE AND B.TRANSACTION_ID = :B1
72yyswsqkzkrm	BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h	SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7mrs575bj7a41	begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr	SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , X.LOCATOR_ID , X.COST_GROUP_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.ORGANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4	BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8zfgv4ck11dw9	BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9wdrypwkpf607	begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23	select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
assndb4wqnd6r	BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09	SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
bf7uwg5pa3pj6	begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms	begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bsuw7pmwrufpy	SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
by0sg8ccaazuk	UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B4 , NULL), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1)
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;
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)
g345hj2ua4pf9	INSERT INTO MTL_TRANSACTION_LOTS_TEMP ( TRANSACTION_TEMP_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, TRANSACTION_QUANTITY, PRIMARY_QUANTITY, LOT_NUMBER, LOT_EXPIRATION_DATE, GROUP_HEADER_ID, SERIAL_TRANSACTION_TEMP_ID, STATUS_ID , LOT_ATTRIBUTE_CATEGORY , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , C_ATTRIBUTE1 , C_ATTRIBUTE2 , C_ATTRIBUTE3 , C_ATTRIBUTE4 , C_ATTRIBUTE5 , C_ATTRIBUTE6 , C_ATTRIBUTE7 , C_ATTRIBUTE8 , C_ATTRIBUTE9 , C_ATTRIBUTE10 , C_ATTRIBUTE11 , C_ATTRIBUTE12 , C_ATTRIBUTE13 , C_ATTRIBUTE14 , C_ATTRIBUTE15 , C_ATTRIBUTE16 , C_ATTRIBUTE17 , C_ATTRIBUTE18 , C_ATTRIBUTE19 , C_ATTRIBUTE20 , N_ATTRIBUTE1 , N_ATTRIBUTE2 , N_ATTRIBUTE3 , N_ATTRIBUTE4 , N_ATTRIBUTE5 , N_ATTRIBUTE6 , N_ATTRIBUTE7 , N_ATTRIBUTE8 , N_ATTRIBUTE9 , N_ATTRIBUTE10 , D_ATTRIBUTE1 , D_ATTRIBUTE2 , D_ATTRIBUTE3 , D_ATTRIBUTE4 , D_ATTRIBUTE5 , D_ATTRIBUTE6 , D_ATTRIBUTE7 , D_ATTRIBUTE8 , D_ATTRIBUTE9 , D_ATTRIBUTE10 , GRADE_CODE , ORIGINATION_DATE , DATE_CODE , CHANGE_DATE , AGE , RETEST_DATE , MATURITY_DATE , ITEM_SIZE , COLOR , VOLUME , VOLUME_UOM , PLACE_OF_ORIGIN , BEST_BY_DATE , LENGTH , LENGTH_UOM , RECYCLED_CONTENT , THICKNESS , THICKNESS_UOM , WIDTH , WIDTH_UOM , TERRITORY_CODE , SUPPLIER_LOT_NUMBER , VENDOR_NAME , SECONDARY_QUANTITY , PARENT_LOT_NUMBER , ORIGINATION_TYPE , EXPIRATION_ACTION_CODE , EXPIRATION_ACTION_DATE , HOLD_DATE , REASON_ID ) (SELECT MMTT.TRANSACTION_TEMP_ID, MMTT.LAST_UPDATE_DATE, MMTT.LAST_UPDATED_BY, MMTT.CREATION_DATE, MMTT.CREATED_BY, MMTT.LAST_UPDATE_LOGIN, MMTT.REQUEST_ID, MMTT.PROGRAM_APPLICATION_ID, MMTT.PROGRAM_ID, MMTT.PROGRAM_UPDATE_DATE, MMTT.TRANSACTION_QUANTITY, MMTT.PRIMARY_QUANTITY, MMTT.LOT_NUMBER, NVL(MMTT.LOT_EXPIRATION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 2, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + SHELF_LIFE_DAYS, NULL)), MMTT.TRANSACTION_HEADER_ID, MMTT.TRANSACTION_TEMP_ID, NVL(MLN.STATUS_ID, MSI.DEFAULT_LOT_STATUS_ID) , MLN.LOT_ATTRIBUTE_CATEGORY , MLN.ATTRIBUTE_CATEGORY , MLN.ATTRIBUTE1 , MLN.ATTRIBUTE2 , MLN.ATTRIBUTE3 , MLN.ATTRIBUTE4 , MLN.ATTRIBUTE5 , MLN.ATTRIBUTE6 , MLN.ATTRIBUTE7 , MLN.ATTRIBUTE8 , MLN.ATTRIBUTE9 , MLN.ATTRIBUTE10 , MLN.ATTRIBUTE11 , MLN.ATTRIBUTE12 , MLN.ATTRIBUTE13 , MLN.ATTRIBUTE14 , MLN.ATTRIBUTE15 , MLN.C_ATTRIBUTE1 , MLN.C_ATTRIBUTE2 , MLN.C_ATTRIBUTE3 , MLN.C_ATTRIBUTE4 , MLN.C_ATTRIBUTE5 , MLN.C_ATTRIBUTE6 , MLN.C_ATTRIBUTE7 , MLN.C_ATTRIBUTE8 , MLN.C_ATTRIBUTE9 , MLN.C_ATTRIBUTE10 , MLN.C_ATTRIBUTE11 , MLN.C_ATTRIBUTE12 , MLN.C_ATTRIBUTE13 , MLN.C_ATTRIBUTE14 , MLN.C_ATTRIBUTE15 , MLN.C_ATTRIBUTE16 , MLN.C_ATTRIBUTE17 , MLN.C_ATTRIBUTE18 , MLN.C_ATTRIBUTE19 , MLN.C_ATTRIB UTE20 , MLN.N_ATTRIBUTE1 , MLN.N_ATTRIBUTE2 , MLN.N_ATTRIBUTE3 , MLN.N_ATTRIBUTE4 , MLN.N_ATTRIBUTE5 , MLN.N_ATTRIBUTE6 , MLN.N_ATTRIBUTE7 , MLN.N_ATTRIBUTE8 , MLN.N_ATTRIBUTE9 , MLN.N_ATTRIBUTE10 , MLN.D_ATTRIBUTE1 , MLN.D_ATTRIBUTE2 , MLN.D_ATTRIBUTE3 , MLN.D_ATTRIBUTE4 , MLN.D_ATTRIBUTE5 , MLN.D_ATTRIBUTE6 , MLN.D_ATTRIBUTE7 , MLN.D_ATTRIBUTE8 , MLN.D_ATTRIBUTE9 , MLN.D_ATTRIBUTE10 , NVL(MLN.GRADE_CODE, DECODE(MSI.GRADE_CONTROL_FLAG, 'Y', MSI.DEFAULT_GRADE, NULL)) , NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) , MLN.DATE_CODE , MLN.CHANGE_DATE , MLN.AGE , NVL(MLN.RETEST_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + MSI.RETEST_INTERVAL) , NVL(MLN.MATURITY_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + MSI.MATURITY_DAYS) , MLN.ITEM_SIZE , MLN.COLOR , MLN.VOLUME , MLN.VOLUME_UOM , MLN.PLACE_OF_ORIGIN , MLN.BEST_BY_DATE , MLN.LENGTH , MLN.LENGTH_UOM , MLN.RECYCLED_CONTENT , MLN.THICKNESS , MLN.THICKNESS_UOM , MLN.WIDTH , MLN.WIDTH_UOM , MLN.TERRITORY_CODE , MLN.SUPPLIER_LOT_NUMBER , MLN.VENDOR_NAME , MMTT.SECONDARY_TRANSACTION_QUANTITY , MLN.PARENT_LOT_NUMBER , NVL(MLN.ORIGINATION_TYPE, DECODE(MMTT.TRANSACTION_SOURCE_TYPE_ID, 1, 3, 7, 3, 13, 4, 6, 4, 12, 4, 31, 1, 6)) , NVL(MLN.EXPIRATION_ACTION_CODE, DECODE(MSI.SHELF_LIFE_CODE, 1, NULL, MSI.EXPIRATION_ACTION_CODE)) , NVL(MLN.EXPIRATION_ACTION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 1, NULL, NVL(MMTT.LOT_EXPIRATION_DATE, DECODE(MSI.SHELF_LIFE_CODE, 2, NVL(MLN.ORIGINATION _DATE, MMTT.TRANSACTION_DATE) + SHELF_LIFE_DAYS, NULL)) + MSI.EXPIRATION_ACTION_INTERVAL)) , NVL(MLN.HOLD_DATE, NVL(MLN.ORIGINATION_DATE, MMTT.TRANSACTION_DATE) + HOLD_DAYS) , MMTT.REASON_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_SYSTEM_ITEMS MSI, MTL_LOT_NUMBERS MLN WHERE MMTT.TRANSACTION_HEADER_ID = :B1 AND MMTT.LOT_NUMBER IS NOT NULL AND MMTT.TRANSACTION_HEADER_ID IS NOT NULL AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID(+) = MMTT.INVENTORY_ITEM_ID AND MLN.ORGANIZATION_ID(+) = MMTT.ORGANIZATION_ID AND MLN.LOT_NUMBER(+) =MMTT.LOT_NUMBER)
g8102j8yynbwz	begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggr	begin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ghmx8n7wgqvfr	begin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0	begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzs	INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
gnng1rmpjxzsx	begin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

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

Back to Top

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	846,094	289.64	1.38
CPU used when call started	844,568	289.12	1.38
CR blocks created	14,575,661	4,989.64	23.86
Cached Commit SCN referenced	153,154	52.43	0.25
Commit SCN cached	66	0.02	0.00
DB time	4,033,773	1,380.87	6.60
DBWR checkpoint buffers written	1,563,510	535.23	2.56
DBWR checkpoints	24	0.01	0.00
DBWR object drop buffers written	1,867	0.64	0.00
DBWR revisited being-written buffer	25	0.01	0.00
DBWR transaction table writes	225	0.08	0.00
DBWR undo block writes	1,039,257	355.77	1.70
DFO trees parallelized	5	0.00	0.00
IMU CR rollbacks	5,709,494	1,954.51	9.34
IMU Flushes	354,833	121.47	0.58
IMU Redo allocation size	1,339,173,480	458,434.85	2,191.74
IMU commits	307,646	105.32	0.50
IMU contention	90,388	30.94	0.15
IMU ktichg flush	323	0.11	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	123	0.04	0.00
IMU undo allocation size	2,122,620,776	726,629.79	3,473.96
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	6,276	2.15	0.01
PX local messages sent	6,276	2.15	0.01
Parallel operations downgraded 25 to 50 pct	4	0.00	0.00
Parallel operations not downgraded	1	0.00	0.00
SMON posted for undo segment shrink	200	0.07	0.00
SQL*Net roundtrips to/from client	144,241	49.38	0.24
active txn count during cleanout	57,644,327	19,733.19	94.34
application wait time	13,473	4.61	0.02
background checkpoints completed	2	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	9,340	3.20	0.02
branch node splits	610	0.21	0.00
buffer is not pinned count	315,582,781	108,032.42	516.49
buffer is pinned count	471,043,636	161,250.82	770.93
bytes received via SQL*Net from client	47,001,269	16,089.79	76.92
bytes sent via SQL*Net to client	338,926,028	116,023.43	554.70
calls to get snapshot scn: kcmgss	55,342,486	18,945.21	90.58
calls to kcmgas	17,416,080	5,961.99	28.50
calls to kcmgcs	2,879,781	985.83	4.71
change write time	39,097	13.38	0.06
cleanout - number of ktugct calls	18,344,492	6,279.81	30.02
cleanouts and rollbacks - consistent read gets	13,561,607	4,642.50	22.20
cleanouts only - consistent read gets	61,433	21.03	0.10
cluster key scan block gets	150,238	51.43	0.25
cluster key scans	80,577	27.58	0.13
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	49,886	17.08	0.08
commit batch/immediate requested	49,886	17.08	0.08
commit cleanout failures: block lost	178,508	61.11	0.29
commit cleanout failures: buffer being written	15	0.01	0.00
commit cleanout failures: callback failure	93,108	31.87	0.15
commit cleanout failures: cannot pin	44,116	15.10	0.07
commit cleanouts	7,260,230	2,485.37	11.88
commit cleanouts successfully completed	6,944,483	2,377.28	11.37
commit immediate performed	49,886	17.08	0.08
commit immediate requested	49,886	17.08	0.08
commit txn count during cleanout	981,797	336.10	1.61
concurrency wait time	55,383	18.96	0.09
consistent changes	685,396,347	234,629.48	1,121.75
consistent gets	1,205,233,330	412,583.56	1,972.53
consistent gets - examination	917,667,094	314,141.96	1,501.89
consistent gets direct	46	0.02	0.00
consistent gets from cache	1,205,233,284	412,583.55	1,972.53
cursor authentications	702	0.24	0.00
data blocks consistent reads - undo records applied	679,784,303	232,708.33	1,112.56
db block changes	126,152,797	43,185.47	206.47
db block gets	141,620,902	48,480.62	231.78
db block gets direct	344	0.12	0.00
db block gets from cache	141,620,558	48,480.50	231.78
deferred (CURRENT) block cleanout applications	1,092,104	373.86	1.79
dirty buffers inspected	1,529	0.52	0.00
enqueue conversions	1,674	0.57	0.00
enqueue releases	3,767,964	1,289.87	6.17
enqueue requests	3,990,432	1,366.03	6.53
enqueue timeouts	222,466	76.16	0.36
enqueue waits	46,662	15.97	0.08
exchange deadlocks	32,163	11.01	0.05
execute count	45,557,722	15,595.63	74.56
failed probes on index block reclamation	963,089	329.69	1.58
free buffer inspected	1,755,232	600.86	2.87
free buffer requested	16,610,455	5,686.20	27.19
heap block compress	23,558,609	8,064.74	38.56
hot buffers moved to head of LRU	694,044	237.59	1.14
immediate (CR) block cleanout applications	13,623,054	4,663.54	22.30
immediate (CURRENT) block cleanout applications	806,336	276.03	1.32
index crx upgrade (found)	96,990	33.20	0.16
index crx upgrade (positioned)	2,904,495	994.29	4.75
index fast full scans (rowid ranges)	96	0.03	0.00
index fetch by key	96,889,026	33,167.70	158.57
index scans kdiixs1	28,765,572	9,847.22	47.08
java call heap collected bytes	808,146,840	276,650.25	1,322.64
java call heap collected count	11,160,798	3,820.64	18.27
java call heap gc count	2,546	0.87	0.00
java call heap live object count	510,474	174.75	0.84
java call heap live object count max	528,281	180.84	0.86
java call heap live size	185,142,160	63,379.11	303.01
java call heap live size max	186,546,560	63,859.87	305.31
java call heap object count	1,192,140	408.10	1.95
java call heap object count max	1,242,726	425.42	2.03
java call heap total size	255,080,448	87,320.85	417.47
java call heap total size max	255,080,448	87,320.85	417.47
java call heap used size	230,390,328	78,868.76	377.07
java call heap used size max	235,592,328	80,649.55	385.58
leaf node 90-10 splits	9,870	3.38	0.02
leaf node splits	142,613	48.82	0.23
lob reads	3,075,037	1,052.67	5.03
lob writes	1,310,023	448.46	2.14
lob writes unaligned	1,310,023	448.46	2.14
logons cumulative	427	0.15	0.00
messages received	566,303	193.86	0.93
messages sent	566,303	193.86	0.93
no buffer to keep pinned count	8	0.00	0.00
no work - consistent read gets	256,531,205	87,817.48	419.85
opened cursors cumulative	788,222	269.83	1.29
parse count (failures)	0	0.00	0.00
parse count (hard)	648	0.22	0.00
parse count (total)	1,968,668	673.93	3.22
parse time cpu	1,283	0.44	0.00
parse time elapsed	5,043	1.73	0.01
physical read IO requests	46,360	15.87	0.08
physical read bytes	482,631,680	165,217.72	789.89
physical read total IO requests	48,989	16.77	0.08
physical read total bytes	523,591,680	179,239.42	856.93
physical read total multi block requests	1,910	0.65	0.00
physical reads	58,915	20.17	0.10
physical reads cache	57,756	19.77	0.09
physical reads cache prefetch	12,519	4.29	0.02
physical reads direct	1,159	0.40	0.00
physical reads direct (lob)	48	0.02	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	131,807	45.12	0.22
physical write bytes	12,848,939,008	4,398,535.05	21,029.05
physical write total IO requests	979,771	335.40	1.60
physical write total bytes	34,615,090,688	11,849,670.20	56,652.34
physical write total multi block requests	923,241	316.05	1.51
physical writes	1,568,474	536.93	2.57
physical writes direct	602	0.21	0.00
physical writes direct (lob)	5	0.00	0.00
physical writes direct temporary tablespace	286	0.10	0.00
physical writes from cache	1,567,872	536.72	2.57
physical writes non checkpoint	824,488	282.24	1.35
pinned buffers inspected	5,166	1.77	0.01
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	13	0.00	0.00
process last non-idle time	3,048	1.04	0.00
queries parallelized	5	0.00	0.00
recursive aborts on index block reclamation	19	0.01	0.00
recursive calls	82,459,675	28,228.15	134.96
recursive cpu usage	709,369	242.84	1.16
redo blocks written	42,375,791	14,506.37	69.35
redo buffer allocation retries	0	0.00	0.00
redo entries	68,622,296	23,491.24	112.31
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	900,664	308.32	1.47
redo size	20,776,355,056	7,112,301.32	34,003.35
redo subscn max counts	1,491,409	510.55	2.44
redo synch time	34,151	11.69	0.06
redo synch writes	122,794	42.04	0.20
redo wastage	207,575,084	71,058.50	339.73
redo write time	42,012	14.38	0.07
redo writer latching time	704	0.24	0.00
redo writes	451,803	154.66	0.74
rollback changes - undo records applied	69,768	23.88	0.11
rollbacks only - consistent read gets	1,078,971	369.36	1.77
rows fetched via callback	33,457,506	11,453.40	54.76
session connect time	0	0.00	0.00
session cursor cache hits	1,834,111	627.87	3.00
session logical reads	1,346,854,232	461,064.18	2,204.31
session pga memory	77,346,104	26,477.64	126.59
session pga memory max	203,633,976	69,709.35	333.27
session uga memory	51,553,711,016	17,648,212.41	84,374.72
session uga memory max	7,294,750,320	2,497,187.90	11,938.86
shared hash latch upgrades - no wait	22,998,755	7,873.09	37.64
shared hash latch upgrades - wait	202,180	69.21	0.33
sorts (memory)	4,715,158	1,614.12	7.72
sorts (rows)	14,930,837	5,111.22	24.44
sql area evicted	315	0.11	0.00
sql area purged	62	0.02	0.00
summed dirty queue length	8,657	2.96	0.01
switch current to new buffer	1,100,882	376.86	1.80
table fetch by rowid	328,911,453	112,595.18	538.31
table fetch continued row	18,977,315	6,496.44	31.06
table scan blocks gotten	5,945,121	2,035.17	9.73
table scan rows gotten	268,891,902	92,048.88	440.08
table scans (long tables)	195	0.07	0.00
table scans (rowid ranges)	195	0.07	0.00
table scans (short tables)	1,379,934	472.39	2.26
total number of times SMON posted	2,213	0.76	0.00
transaction rollbacks	49,886	17.08	0.08
transaction tables consistent read rollbacks	189	0.06	0.00
transaction tables consistent reads - undo records applied	295,211	101.06	0.48
undo change vector size	7,554,105,168	2,585,971.99	12,363.33
user I/O wait time	18,432	6.31	0.03
user calls	170,198	58.26	0.28
user commits	610,069	208.84	1.00
user rollbacks	940	0.32	0.00
workarea executions - optimal	1,884,799	645.22	3.08
write clones created in background	45	0.02	0.00
write clones created in foreground	61	0.02	0.00

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
logons current	91	92
session cursor cache count	27,427	45,434
opened cursors current	2,680	2,727

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

Back to Top

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_UNDOTS1	1	0	0.00	1.00	70,185	24	513,805	0.29
APPS_TS_TX_IDX	20,321	7	4.07	1.00	28,467	10	178,360	0.31
APPS_TS_TX_DATA	14,973	5	3.71	1.64	14,912	5	198,905	0.31
APPS_TS_INTERFACE	8,675	3	3.34	1.01	3,354	1	23,794	0.30
APPS_TS_QUEUES	190	0	3.37	1.00	9,444	3	86,138	0.73
APPS_TS_SUMMARY	144	0	2.36	1.00	4,421	2	44,429	0.45
SYSTEM	987	0	2.40	3.55	475	0	11,822	0.13
SYSAUX	308	0	2.24	1.00	274	0	0	0.00
APPS_TS_SEED	337	0	3.83	1.26	5	0	118	2.88
APPS_TS_ARCHIVE	38	0	5.26	1.00	64	0	29	0.00
TEMP	41	0	0.73	7.05	32	0	0	0.00
APPS_TS_MEDIA	21	0	3.33	1.00	7	0	0	0.00
GEOR_TBS	14	0	4.29	1.00	2	0	0	0.00
IAS_META	15	0	4.00	1.00	1	0	0	0.00
OLTS_ATTRSTORE	15	0	3.33	1.00	1	0	0	0.00
CWMLITE	12	0	3.33	1.00	2	0	0	0.00
DCM	12	0	3.33	1.00	2	0	0	0.00
APPS_TS_NOLOGGING	7	0	2.86	1.00	4	0	84	0.00
OLTS_CT_STORE	10	0	4.00	1.00	1	0	0	0.00
CTXSYS	8	0	2.50	1.00	2	0	0	0.00
OLTS_DEFAULT	9	0	5.56	1.00	1	0	0	0.00
APPS_CALCLIP	4	0	0.00	1.00	4	0	0	0.00
DISCO_PTM5_CACHE	7	0	4.29	1.00	1	0	0	0.00
DISCO_PTM5_META	7	0	4.29	1.00	1	0	0	0.00
DSGATEWAY_TAB	7	0	4.29	1.00	1	0	0	0.00
HTMLDB	7	0	4.29	1.00	1	0	0	0.00
PORTAL	7	0	4.29	1.00	1	0	0	0.00
PORTAL_DOC	7	0	4.29	1.00	1	0	0	0.00
PORTAL_IDX	7	0	4.29	1.00	1	0	0	0.00
PORTAL_LOG	7	0	4.29	1.00	1	0	0	0.00
RE	7	0	4.29	1.00	1	0	0	0.00
SYNCSERVER	7	0	2.86	1.00	1	0	0	0.00
B2B_DT	6	0	3.33	1.00	1	0	0	0.00
B2B_IDX	6	0	3.33	1.00	1	0	0	0.00
B2B_LOB	6	0	3.33	1.00	1	0	0	0.00
B2B_RT	6	0	3.33	1.00	1	0	0	0.00
BAM	6	0	3.33	1.00	1	0	0	0.00
MTR	6	0	5.00	1.00	1	0	0	0.00
NOETIX	6	0	5.00	1.00	1	0	0	0.00
NON_APPS_TS_DATA	6	0	5.00	1.00	1	0	0	0.00
OCATS	6	0	5.00	1.00	1	0	0	0.00
ODM_DATA	6	0	5.00	1.00	1	0	0	0.00
OLTS_BATTRSTORE	6	0	5.00	1.00	1	0	0	0.00
OLTS_SVRMGSTORE	6	0	5.00	1.00	1	0	0	0.00
OPMOR	6	0	5.00	1.00	1	0	0	0.00
ORABPEL	6	0	5.00	1.00	1	0	0	0.00
OWAPUB	6	0	5.00	1.00	1	0	0	0.00
UDDISYS_TS	6	0	3.33	1.00	1	0	0	0.00
WCRSYS_TS	6	0	3.33	1.00	1	0	0	0.00
XDB	6	0	3.33	1.00	1	0	0	0.00
APPS_TS_TOOLS	4	0	2.50	1.00	1	0	0	0.00
APPS_OMO	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO_OLAP	1	0	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

• 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/apps_st/data/apps_calclip.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds1/oracle/VIS/db/apps_st/data/apps_calclip1.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds1/oracle/VIS/db/apps_st/data/apps_calclip2.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds1/oracle/VIS/db/apps_st/data/apps_calclip3.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_OMO	/ds1/oracle/VIS/db/apps_st/data/omo1.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_ARCHIVE	/ds1/oracle/VIS/db/apps_st/data/archive1.dbf	38	0	5.26	1.00	64	0	29	0.00
APPS_TS_DISCO	/ds1/oracle/VIS/db/apps_st/data/disco1.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO_OLAP	/ds1/oracle/VIS/db/apps_st/data/disco_drake1.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface.db	113	0	1.33	1.31	96	0	846	0.08
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface1.d	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface10.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface11.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface12.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface13.	2	0	0.00	1.00	2	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface14.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface15.	64	0	0.63	1.00	7	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface16.	63	0	0.32	1.00	3	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface17.	39	0	3.85	1.00	22	0	104	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface18.	2	0	0.00	1.00	3	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface19.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface2.d	2	0	0.00	1.00	2	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface20.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface21.	3	0	3.33	1.00	9	0	37	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface22.	2	0	0.00	1.00	4	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface23.	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface24.	2	0	0.00	1.00	2	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface25.	17	0	0.00	1.00	4	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface26.	2	0	0.00	1.00	20	0	40	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface27.	891	0	3.11	1.01	366	0	1,934	0.47
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface28.	905	0	3.03	1.01	360	0	2,656	0.23
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface29.	845	0	3.51	1.02	322	0	2,786	0.31
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface3.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface30.	834	0	3.99	1.01	319	0	1,579	0.41
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface31.	806	0	3.15	1.01	309	0	1,507	0.48
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface32.	842	0	3.92	1.02	316	0	1,437	0.53
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface33.	785	0	3.31	1.01	304	0	2,594	0.19
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface34.	809	0	3.45	1.00	302	0	1,805	0.45
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface35.	798	0	3.63	1.00	280	0	3,256	0.25
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface36.	812	0	3.23	1.00	287	0	3,213	0.13
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface4.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface5.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface6.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface7.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface8.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds1/oracle/VIS/db/apps_st/data/apps_ts_interface9.d	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media1.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media2.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media3.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media4.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media5.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media6.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds1/oracle/VIS/db/apps_st/data/media7.dbf	3	0	3.33	1.00	1	0	0	0.00
APPS_TS_NOLOGGING	/ds1/oracle/VIS/db/apps_st/data/nologging1.dbf	7	0	2.86	1.00	4	0	84	0.00
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues1.dbf	6	0	5.00	1.00	52	0	1,056	1.23
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues2.dbf	18	0	2.78	1.00	71	0	2,425	0.44
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues3.dbf	41	0	2.93	1.00	1,851	1	16,717	0.71
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues4.dbf	55	0	3.09	1.00	1,895	1	16,501	0.77
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues5.dbf	27	0	4.81	1.00	1,805	1	16,800	0.78
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues6.dbf	18	0	3.89	1.00	1,902	1	16,440	0.74
APPS_TS_QUEUES	/ds1/oracle/VIS/db/apps_st/data/queues7.dbf	25	0	2.80	1.00	1,868	1	16,199	0.68
APPS_TS_SEED	/ds1/oracle/VIS/db/apps_st/data/reference1.dbf	105	0	4.29	1.12	1	0	35	4.00
APPS_TS_SEED	/ds1/oracle/VIS/db/apps_st/data/reference2.dbf	137	0	3.72	1.25	1	0	59	2.03
APPS_TS_SEED	/ds1/oracle/VIS/db/apps_st/data/reference3.dbf	84	0	3.81	1.31	1	0	16	2.50
APPS_TS_SEED	/ds1/oracle/VIS/db/apps_st/data/reference4.dbf	7	0	0.00	2.86	1	0	8	5.00
APPS_TS_SEED	/ds1/oracle/VIS/db/apps_st/data/reference5.dbf	4	0	2.50	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary1.dbf	4	0	2.50	1.00	392	0	3,160	0.50
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary10.dbf	6	0	3.33	1.00	390	0	3,358	0.55
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary11.dbf	4	0	2.50	1.00	403	0	3,460	0.44
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary12.dbf	12	0	4.17	1.00	404	0	5,084	0.34
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary13.dbf	34	0	2.35	1.00	398	0	5,151	0.38
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary2.dbf	4	0	2.50	1.00	402	0	4,787	0.38
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary3.dbf	6	0	3.33	1.00	33	0	1,771	0.08
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary4.dbf	6	0	3.33	1.00	406	0	4,024	0.44
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary5.dbf	35	0	1.71	1.00	398	0	3,377	0.46
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary6.dbf	4	0	2.50	1.00	396	0	3,260	0.81
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary7.dbf	19	0	1.05	1.00	401	0	3,621	0.51
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary8.dbf	5	0	4.00	1.00	5	0	1	10.00
APPS_TS_SUMMARY	/ds1/oracle/VIS/db/apps_st/data/summary9.dbf	5	0	2.00	1.00	393	0	3,375	0.42
APPS_TS_TOOLS	/ds1/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf	4	0	2.50	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data1.dbf	4	0	2.50	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data10.dbf	4	0	2.50	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data11.dbf	75	0	1.07	6.33	1	0	167	0.36
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data12.dbf	67	0	1.19	6.96	1	0	170	0.71
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data13.dbf	70	0	1.14	6.70	4	0	173	0.46
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data14.dbf	4	0	2.50	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data15.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data16.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data17.dbf	6	0	3.33	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data18.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data19.dbf	58	0	0.52	7.21	1	0	168	0.60
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data2.dbf	62	0	0.48	7.21	1	0	179	0.50
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data20.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data21.dbf	67	0	1.04	6.76	2	0	168	0.06
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data22.dbf	62	0	1.13	7.10	1	0	172	0.47
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data23.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data24.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data25.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data26.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data27.dbf	70	0	4.57	1.81	74	0	2,838	0.05
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data28.dbf	14	0	4.29	1.29	19	0	243	0.08
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data29.dbf	12	0	3.33	1.00	1	0	1	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data3.dbf	5	0	2.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data30.dbf	6	0	3.33	1.00	6	0	29	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data31.dbf	20	0	2.00	1.00	10	0	1,042	0.06
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data32.dbf	98	0	2.35	5.11	8	0	170	0.35
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data33.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data34.dbf	7	0	5.71	1.43	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data35.dbf	9	0	5.56	2.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data36.dbf	12	0	3.33	2.25	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data37.dbf	8	0	3.75	1.75	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data38.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data39.dbf	77	0	2.08	6.14	7	0	173	0.98
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data4.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data40.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data41.dbf	58	0	0.52	7.16	1	0	170	0.88
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data42.dbf	58	0	0.86	7.16	1	0	167	0.96
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data43.dbf	78	0	1.79	6.44	3	0	172	0.70
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data44.dbf	79	0	1.27	6.37	8	0	175	0.69
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data45.dbf	73	0	2.19	6.62	2	0	168	1.07
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data46.dbf	69	0	0.72	6.96	2	0	166	0.66
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data47.dbf	79	0	1.65	6.22	8	0	167	0.48
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data48.dbf	68	0	1.62	7.07	1	0	171	0.70
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data49.dbf	84	0	2.38	5.90	5	0	179	0.89
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data5.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data50.dbf	73	0	1.37	6.47	1	0	185	0.16
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data51.dbf	158	0	3.48	3.70	88	0	197	0.91
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data52.dbf	59	0	1.02	7.07	1	0	181	0.66
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data53.dbf	572	0	4.42	1.11	677	0	7,119	0.33
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data54.dbf	532	0	3.14	1.09	635	0	7,764	0.21
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data55.dbf	508	0	3.41	1.08	596	0	6,951	0.27
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data56.dbf	515	0	5.15	1.08	616	0	7,410	0.27
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data57.dbf	516	0	4.30	1.08	629	0	7,222	0.34
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data58.dbf	524	0	3.87	1.08	622	0	8,689	0.19
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data59.dbf	505	0	2.93	1.08	587	0	7,484	0.25
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data6.dbf	7	0	2.86	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data60.dbf	514	0	3.79	1.10	571	0	8,065	0.26
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data61.dbf	501	0	3.71	1.11	583	0	7,505	0.23
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data62.dbf	513	0	4.00	1.11	566	0	6,843	0.26
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data63.dbf	504	0	3.71	1.10	591	0	7,127	0.31
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data64.dbf	502	0	4.36	1.10	542	0	6,931	0.37
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data65.dbf	497	0	3.86	1.08	532	0	7,328	0.32
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data66.dbf	520	0	4.15	1.08	539	0	7,768	0.22
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data67.dbf	498	0	4.20	1.08	534	0	7,416	0.42
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data68.dbf	505	0	4.42	1.08	525	0	7,586	0.21
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data69.dbf	507	0	3.81	1.08	506	0	6,824	0.43
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data7.dbf	7	0	2.86	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data70.dbf	500	0	4.36	1.08	521	0	7,659	0.37
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data71.dbf	480	0	4.48	1.09	538	0	8,045	0.27
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data72.dbf	493	0	3.53	1.08	527	0	6,636	0.62
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data73.dbf	489	0	4.05	1.09	547	0	6,996	0.32
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data74.dbf	499	0	3.45	1.08	530	0	7,877	0.28
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data75.dbf	477	0	4.44	1.09	519	0	6,991	0.33
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data76.dbf	474	0	4.32	1.09	529	0	6,900	0.48
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data77.dbf	492	0	3.41	1.09	532	0	6,471	0.34
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data78.dbf	484	0	3.93	1.08	535	0	7,507	0.35
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data8.dbf	7	0	2.86	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds1/oracle/VIS/db/apps_st/data/tx_data9.dbf	7	0	2.86	1.00	1	0	0	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx1.dbf	93	0	3.87	1.00	340	0	3,335	0.20
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx10.dbf	135	0	3.26	1.00	220	0	307	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx11.dbf	31	0	4.52	1.00	31	0	0	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx12.dbf	13	0	3.85	1.00	15	0	4	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx13.dbf	20	0	2.00	1.00	18	0	4	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx14.dbf	34	0	5.00	1.00	17	0	0	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx15.dbf	21	0	2.86	1.00	31	0	39	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx16.dbf	64	0	5.47	1.00	79	0	33	1.21
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx17.dbf	37	0	5.14	1.00	34	0	25	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx18.dbf	28	0	4.29	1.00	33	0	24	0.42
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx19.dbf	23	0	1.74	1.00	27	0	2	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx2.dbf	29	0	3.10	1.00	65	0	33	0.30
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx20.dbf	22	0	1.82	1.00	9	0	84	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx21.dbf	22	0	2.27	1.00	9	0	0	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx22.dbf	90	0	5.56	1.00	69	0	86	0.47
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx23.dbf	25	0	3.20	1.00	33	0	3	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx24.dbf	30	0	2.33	1.00	19	0	0	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx25.dbf	934	0	3.98	1.00	1,340	0	8,370	0.31
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx26.dbf	827	0	4.53	1.00	1,278	0	6,119	0.26
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx27.dbf	883	0	4.00	1.00	1,299	0	5,549	0.32
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx28.dbf	951	0	4.16	1.00	1,239	0	5,258	0.25
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx29.dbf	928	0	3.45	1.00	1,234	0	5,414	0.28
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx3.dbf	20	0	3.00	1.00	61	0	15	0.67
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx30.dbf	897	0	4.35	1.00	1,151	0	6,006	0.24
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx31.dbf	889	0	3.46	1.00	1,075	0	5,754	0.18
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx32.dbf	782	0	3.73	1.00	1,089	0	35,473	0.26
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx33.dbf	813	0	3.41	1.00	1,120	0	5,021	0.31
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx34.dbf	748	0	4.09	1.02	1,055	0	5,138	0.21
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx35.dbf	771	0	4.28	1.02	1,034	0	4,875	0.63
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx36.dbf	734	0	3.86	1.01	1,057	0	4,859	0.33
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx37.dbf	748	0	3.38	1.00	1,015	0	6,002	0.32
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx38.dbf	732	0	3.95	1.00	988	0	5,574	0.35
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx39.dbf	744	0	4.23	1.00	1,057	0	5,666	0.34
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx4.dbf	13	0	4.62	1.00	15	0	1	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx40.dbf	728	0	4.57	1.00	1,032	0	8,160	0.26
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx41.dbf	701	0	3.89	1.00	1,006	0	5,322	0.36
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx42.dbf	742	0	3.53	1.00	1,013	0	5,640	0.39
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx43.dbf	713	0	4.77	1.00	1,014	0	6,471	0.39
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx44.dbf	743	0	4.99	1.00	965	0	5,038	0.44
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx45.dbf	695	0	4.59	1.00	1,028	0	4,939	0.41
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx46.dbf	682	0	4.13	1.00	1,008	0	4,714	0.27
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx47.dbf	661	0	3.90	1.00	1,045	0	7,294	0.39
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx48.dbf	687	0	4.54	1.00	916	0	4,705	0.28
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx49.dbf	697	0	4.13	1.00	958	0	4,910	0.33
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx5.dbf	16	0	5.63	1.00	29	0	2,042	0.04
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx6.dbf	10	0	7.00	1.00	11	0	1	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx7.dbf	58	0	5.00	1.00	225	0	25	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx8.dbf	28	0	5.00	1.00	45	0	9	0.00
APPS_TS_TX_IDX	/ds1/oracle/VIS/db/apps_st/data/tx_idx9.dbf	29	0	5.52	1.00	16	0	17	0.00
APPS_UNDOTS1	/ds1/oracle/VIS/db/apps_st/data/undo.dbf	1	0	0.00	1.00	70,185	24	513,805	0.29
B2B_DT	/ds1/oracle/VIS/db/apps_st/data/b2b_dt.dbf	6	0	3.33	1.00	1	0	0	0.00
B2B_IDX	/ds1/oracle/VIS/db/apps_st/data/b2b_idx.dbf	6	0	3.33	1.00	1	0	0	0.00
B2B_LOB	/ds1/oracle/VIS/db/apps_st/data/b2b_lob.dbf	6	0	3.33	1.00	1	0	0	0.00
B2B_RT	/ds1/oracle/VIS/db/apps_st/data/b2b_rt.dbf	6	0	3.33	1.00	1	0	0	0.00
BAM	/ds1/oracle/VIS/db/apps_st/data/bam.dbf	6	0	3.33	1.00	1	0	0	0.00
CTXSYS	/ds1/oracle/VIS/db/apps_st/data/ctx1.dbf	6	0	3.33	1.00	1	0	0	0.00
CTXSYS	/ds1/oracle/VIS/db/apps_st/data/ctx2.dbf	2	0	0.00	1.00	1	0	0	0.00
CWMLITE	/ds1/oracle/VIS/db/apps_st/data/cwmlite01.dbf	6	0	3.33	1.00	1	0	0	0.00
CWMLITE	/ds1/oracle/VIS/db/apps_st/data/cwmlite02.dbf	6	0	3.33	1.00	1	0	0	0.00
DCM	/ds1/oracle/VIS/db/apps_st/data/dcm.dbf	6	0	3.33	1.00	1	0	0	0.00
DCM	/ds1/oracle/VIS/db/apps_st/data/dcm1.dbf	6	0	3.33	1.00	1	0	0	0.00
DISCO_PTM5_CACHE	/ds1/oracle/VIS/db/apps_st/data/discopltc1.dbf	7	0	4.29	1.00	1	0	0	0.00
DISCO_PTM5_META	/ds1/oracle/VIS/db/apps_st/data/discopltm1.dbf	7	0	4.29	1.00	1	0	0	0.00
DSGATEWAY_TAB	/ds1/oracle/VIS/db/apps_st/data/oss_sys01.dbf	7	0	4.29	1.00	1	0	0	0.00
GEOR_TBS	/ds1/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf	7	0	4.29	1.00	1	0	0	0.00
GEOR_TBS	/ds1/oracle/VIS/db/apps_st/data/geor_tbs02.dbf	7	0	4.29	1.00	1	0	0	0.00
HTMLDB	/ds1/oracle/VIS/db/apps_st/data/htmldb.dbf	7	0	4.29	1.00	1	0	0	0.00
IAS_META	/ds1/oracle/VIS/db/apps_st/data/ias_meta01.dbf	15	0	4.00	1.00	1	0	0	0.00
MTR	/ds1/oracle/VIS/db/apps_st/data/opmtr01.dbf	6	0	5.00	1.00	1	0	0	0.00
NOETIX	/ds1/oracle/VIS/db/apps_st/data/noetix.dbf	6	0	5.00	1.00	1	0	0	0.00
NON_APPS_TS_DATA	/ds1/oracle/VIS/db/apps_st/data/non_apps_data1.dbf	6	0	5.00	1.00	1	0	0	0.00
OCATS	/ds1/oracle/VIS/db/apps_st/data/oca.dbf	6	0	5.00	1.00	1	0	0	0.00
ODM_DATA	/ds1/oracle/VIS/db/apps_st/data/odm.dbf	6	0	5.00	1.00	1	0	0	0.00
OLTS_ATTRSTORE	/ds1/oracle/VIS/db/apps_st/data/attrs1_oid.dbf	15	0	3.33	1.00	1	0	0	0.00
OLTS_BATTRSTORE	/ds1/oracle/VIS/db/apps_st/data/battrs1_oid.dbf	6	0	5.00	1.00	1	0	0	0.00
OLTS_CT_STORE	/ds1/oracle/VIS/db/apps_st/data/gcats1_oid.dbf	10	0	4.00	1.00	1	0	0	0.00
OLTS_DEFAULT	/ds1/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf	9	0	5.56	1.00	1	0	0	0.00
OLTS_SVRMGSTORE	/ds1/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf	6	0	5.00	1.00	1	0	0	0.00
OPMOR	/ds1/oracle/VIS/db/apps_st/data/opmor01.dbf	6	0	5.00	1.00	1	0	0	0.00
ORABPEL	/ds1/oracle/VIS/db/apps_st/data/orabpel.dbf	6	0	5.00	1.00	1	0	0	0.00
OWAPUB	/ds1/oracle/VIS/db/apps_st/data/owa1.dbf	6	0	5.00	1.00	1	0	0	0.00
PORTAL	/ds1/oracle/VIS/db/apps_st/data/portal.dbf	7	0	4.29	1.00	1	0	0	0.00
PORTAL_DOC	/ds1/oracle/VIS/db/apps_st/data/ptldoc.dbf	7	0	4.29	1.00	1	0	0	0.00
PORTAL_IDX	/ds1/oracle/VIS/db/apps_st/data/ptlidx.dbf	7	0	4.29	1.00	1	0	0	0.00
PORTAL_LOG	/ds1/oracle/VIS/db/apps_st/data/ptllog.dbf	7	0	4.29	1.00	1	0	0	0.00
RE	/ds1/oracle/VIS/db/apps_st/data/opre01.dbf	7	0	4.29	1.00	1	0	0	0.00
SYNCSERVER	/ds1/oracle/VIS/db/apps_st/data/mobile01.dbf	7	0	2.86	1.00	1	0	0	0.00
SYSAUX	/ds1/oracle/VIS/db/apps_st/data/sysaux01.dbf	308	0	2.24	1.00	274	0	0	0.00
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys1.dbf	66	0	1.97	4.32	46	0	2,357	0.09
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys10.dbf	65	0	2.62	4.31	49	0	3,103	0.11
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys2.dbf	65	0	2.31	4.22	39	0	2,389	0.08
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys3.dbf	121	0	3.31	3.27	90	0	1,472	0.12
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys4.dbf	113	0	2.57	3.03	64	0	7	1.43
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys5.dbf	111	0	2.79	3.12	50	0	67	2.24
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys6.dbf	120	0	2.08	3.49	41	0	311	0.19
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys7.dbf	117	0	2.22	3.56	21	0	190	0.32
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys8.dbf	128	0	2.50	3.38	48	0	805	0.14
SYSTEM	/ds1/oracle/VIS/db/apps_st/data/sys9.dbf	81	0	1.11	3.83	27	0	1,121	0.19
TEMP	/ds1/oracle/VIS/db/apps_st/data/tempx01.dbf	38	0	0.53	7.53	24	0	0
TEMP	/ds1/oracle/VIS/db/apps_st/data/tempx02.dbf	3	0	3.33	1.00	8	0	0
UDDISYS_TS	/ds1/oracle/VIS/db/apps_st/data/uddisys01.dbf	6	0	3.33	1.00	1	0	0	0.00
WCRSYS_TS	/ds1/oracle/VIS/db/apps_st/data/wcrsys01.dbf	6	0	3.33	1.00	1	0	0	0.00
XDB	/ds1/oracle/VIS/db/apps_st/data/xdb01.dbf	6	0	3.33	1.00	1	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	1,013,248	100	1,343,716,845	57,742	1,566,336	0	0	1,057,602

Back to Top

 

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

Back to Top

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	37	7037	199734	2039162	92152620	2039162
E	0	82	92785	2345046	10117796	92152620	10117796

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	816	0.10	100,929	1.33	1,114,924
D	1,632	0.20	201,858	1.16	970,308
D	2,448	0.30	302,787	1.09	915,180
D	3,264	0.40	403,716	1.06	890,050
D	4,080	0.50	504,645	1.05	878,245
D	4,896	0.60	605,574	1.04	865,957
D	5,712	0.70	706,503	1.03	857,195
D	6,528	0.80	807,432	1.01	847,495
D	7,344	0.90	908,361	1.00	839,754
D	8,160	1.00	1,009,290	1.00	836,016
D	8,192	1.00	1,013,248	1.00	835,943
D	8,976	1.10	1,110,219	1.00	831,929
D	9,792	1.20	1,211,148	0.98	819,794
D	10,608	1.29	1,312,077	0.97	814,641
D	11,424	1.39	1,413,006	0.96	801,146
D	12,240	1.49	1,513,935	0.96	801,107
D	13,056	1.59	1,614,864	0.96	801,101
D	13,872	1.69	1,715,793	0.96	801,073
D	14,688	1.79	1,816,722	0.96	801,045
D	15,504	1.89	1,917,651	0.96	800,074
D	16,320	1.99	2,018,580	0.95	792,457

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
100.00	64,271	0

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	2,048	1,702	275.78	0.00	0.00	0.00	0.00	209,710
E	2,048	1,697	272.68	0.00	0.00	0.00	0.00	209,710

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	M-Pass Execs
2K	4K	1,825,140	1,825,140	0	0
64K	128K	1,488	1,488	0	0
128K	256K	98	98	0	0
256K	512K	778	778	0	0
512K	1024K	10,500	10,500	0	0
1M	2M	45,335	45,335	0	0
2M	4M	382	382	0	0
4M	8M	65	65	0	0
8M	16M	10	10	0	0
16M	32M	4	4	0	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
256	0.13	129,393.02	1,633.17	99.00	292
512	0.25	129,393.02	523.22	100.00	75
1,024	0.50	129,393.02	451.26	100.00	53
1,536	0.75	129,393.02	333.95	100.00	28
2,048	1.00	129,393.02	0.00	100.00	8
2,458	1.20	129,393.02	0.00	100.00	0
2,867	1.40	129,393.02	0.00	100.00	0
3,277	1.60	129,393.02	0.00	100.00	0
3,686	1.80	129,393.02	0.00	100.00	0
4,096	2.00	129,393.02	0.00	100.00	0
6,144	3.00	129,393.02	0.00	100.00	0
8,192	4.00	129,393.02	0.00	100.00	0
12,288	6.00	129,393.02	0.00	100.00	0
16,384	8.00	129,393.02	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
592	0.29	237	10,391	1,296,806	1.00	294	1.14	93,697,758
800	0.39	331	16,650	1,296,842	1.00	258	1.00	93,700,254
1,008	0.49	331	16,650	1,296,842	1.00	258	1.00	93,700,254
1,216	0.59	331	16,650	1,296,842	1.00	258	1.00	93,700,254
1,424	0.70	331	16,650	1,296,842	1.00	258	1.00	93,700,254
1,632	0.80	331	16,650	1,296,842	1.00	258	1.00	93,700,254
1,840	0.90	331	16,650	1,296,842	1.00	258	1.00	93,700,254
2,048	1.00	331	16,650	1,296,842	1.00	258	1.00	93,700,254
2,256	1.10	331	16,650	1,296,842	1.00	258	1.00	93,700,254
2,464	1.20	331	16,650	1,296,842	1.00	258	1.00	93,700,254
2,672	1.30	331	16,650	1,296,842	1.00	258	1.00	93,700,254
2,880	1.41	331	16,650	1,296,842	1.00	258	1.00	93,700,254
3,088	1.51	331	16,650	1,296,842	1.00	258	1.00	93,700,254
3,296	1.61	331	16,650	1,296,842	1.00	258	1.00	93,700,254
3,504	1.71	331	16,650	1,296,842	1.00	258	1.00	93,700,254
3,712	1.81	331	16,650	1,296,842	1.00	258	1.00	93,700,254
3,920	1.91	331	16,650	1,296,842	1.00	258	1.00	93,700,254
4,128	2.02	331	16,650	1,296,842	1.00	258	1.00	93,700,254

Back to Advisory Statistics
Back to Top

 

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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

Back to Advisory Statistics
Back to Top

 

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	513,623	204	0
undo block	478,229	128	0
undo header	35,588	23	1
1st level bmb	21,434	4	0
segment header	8,290	1	0
2nd level bmb	301	0	0
extent map	29	0	0
3rd level bmb	15	0	1
file header block	1	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)	233,870	11,907	221,967	11,901	138	11.59
TX-Transaction (index contention)	18,858	18,858	0	18,289	43	2.34
TX-Transaction	901,730	901,977	0	6,080	14	2.29
HW-Segment High Water Mark	83,231	83,220	11	5,245	9	1.70
FB-Format Block	22,129	22,129	0	1,357	2	1.56
SQ-Sequence Cache	30,482	30,482	0	3,728	1	0.23
RO-Multiple Object Reuse (fast object reuse)	216	216	0	23	0	4.00
TX-Transaction (allocate ITL entry)	49	49	0	31	0	0.13
PS-PX Process Reservation	200	168	32	5	0	0.20

Back to Wait Statistics
Back to Top

 

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Back to Top

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,051.28	886,914	1,702	20		0/0	0/0/0/0/0/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
10-Sep 19:41	109,463	34,646	318	6	14	0/0	0/0/0/0/0/0
10-Sep 19:31	204,246	143,686	300	19	10	0/0	0/0/0/0/0/0
10-Sep 19:21	226,425	192,696	0	20	10	0/0	0/0/0/0/0/0
10-Sep 19:11	255,845	410,879	1,702	14	9	0/0	0/0/0/0/0/0
10-Sep 19:01	255,301	105,007	1,100	17	9	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

Back to Top

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	2,993	0.00		0	0
AWR Alerted Metric Element list	21,217	0.00		0	0
Consistent RBA	452,957	0.04	0.00	0	0
FOB s.o list latch	12,078	0.12	0.00	0	0
In memory undo latch	675,223,022	0.71	0.00	9	666,187	0.03
JOX SGA heap latch	1,722,873	0.00		0	0
JS queue state obj latch	17,520	0.00		0	0
JS slv state obj latch	27	0.00		0	0
KMG MMAN ready and startup request latch	974	0.00		0	0
KTF sga latch	9	0.00		0	950	0.00
KWQMN job cache list latch	206,709	0.16	0.22	0	0
KWQP Prop Status	364	0.00		0	0
MQL Tracking Latch	0			0	59	0.00
Memory Management Latch	0			0	974	0.00
OS process	1,248	0.00		0	0
OS process allocation	1,807	0.06	0.00	0	0
OS process: request allocation	765	0.13	0.00	0	0
PL/SQL warning settings	1,283,618	0.00		0	0
SGA IO buffer pool latch	172	0.00		0	172	0.00
SQL memory manager latch	1	0.00		0	973	0.00
SQL memory manager workarea list latch	476,646	0.01	0.00	0	0
Shared B-Tree	1,894	0.00		0	0
active checkpoint queue latch	114,437	0.00		0	0
active service list	7,169	0.66	0.00	0	1,007	0.00
begin backup scn array	8	0.00		0	0
bq:time manger info latch	105	0.00		0	0
bufq statistics	3	0.00		0	0
cache buffer handles	4,685,870	0.73	0.00	0	0
cache buffers chains	3,436,299,369	2.01	0.00	73	12,037,570	4.22
cache buffers lru chain	5,410,942	0.48	0.01	2	31,327,929	0.70
cache table scan latch	0			0	1,898	0.00
channel handle pool latch	10,003	0.07	0.00	0	0
channel operations parent latch	54,339	0.58	0.00	0	0
checkpoint queue latch	3,943,708	0.01	0.02	0	1,650,546	0.03
client/application info	3,478	0.00		0	0
commit callback allocation	222,264	0.28	0.00	0	0
compile environment latch	42,075	0.00		0	0
dictionary lookup	37	0.00		0	0
dml lock allocation	4,953,567	3.55	0.00	2	0
dummy allocation	869	1.27	0.00	0	0
enqueue hash chains	7,819,634	1.18	0.00	3	316	0.00
enqueues	1,216,426	0.34	0.00	0	0
error message lists	85	18.82	0.00	0	0
event group latch	383	0.00		0	0
file cache latch	23,973	0.01	0.00	0	0
global KZLD latch for mem in SGA	365	0.00		0	0
global ctx hash table latch	271,064	0.00		0	0
hash table column usage latch	524	0.00		0	136,351	0.00
hash table modification latch	125	0.00		0	0
job workq parent latch	0			0	24	0.00
job_queue_processes parameter latch	58	0.00		0	0
kks stats	2,588	0.00		0	0
ksuosstats global area	197	0.00		0	0
ktm global data	2,613	0.00		0	0
kwqbsn:qsga	1,785	0.00		0	0
kwqi:kchunk latch	2	0.00		0	0
lgwr LWN SCN	454,874	0.23	0.00	0	0
library cache	89,173,978	1.66	0.00	40	158	0.00
library cache load lock	184	0.54	0.00	0	0
library cache lock	12,675,606	0.71	0.00	3	0
library cache lock allocation	41,098	0.01	0.00	0	0
library cache pin	57,191,593	1.06	0.00	13	0
library cache pin allocation	20,048	0.00		0	0
list of block allocation	287,758	0.10	0.03	0	0
loader state object freelist	5,922	0.00		0	0
logminer context allocation	1	0.00		0	0
longop free list parent	3	0.00		0	3	0.00
message pool operations parent latch	9,730	0.12	0.00	0	0
messages	1,674,519	0.38	0.00	0	0
mostly latch-free SCN	486,314	4.21	0.00	0	0
multiblock read objects	3,938	0.00		0	0
ncodef allocation latch	48	0.00		0	0
object queue header heap	466,365	0.00	0.00	0	9,037	0.00
object queue header operation	10,524,837	0.06	0.01	0	0
object stats modification	9,632	0.00		0	0
parallel query alloc buffer	1,172	1.71	0.00	0	0
parallel query stats	55	40.00	0.00	0	0
parameter list	1,248	0.00		0	0
parameter table allocation management	441	5.44	0.08	0	0
post/wait queue	248,656	0.30	0.00	0	100,513	1.56
process allocation	770	0.26	0.50	0	383	0.00
process group creation	765	0.13	0.00	0	0
process queue	522	2.87	0.00	0	0
process queue reference	94,803	0.07	0.00	0	9,484	273.33
qmn task queue latch	2,764	7.16	0.14	0	0
query server freelists	447	9.84	0.00	0	0
query server process	8	0.00		0	8	0.00
redo allocation	3,150,528	1.89	0.02	4	68,545,848	1.37
redo copy	0			0	68,622,366	0.03
redo writing	1,859,918	0.01	0.04	0	0
resmgr group change latch	2,402	0.00		0	0
resmgr:actses active list	1,235	0.40	0.00	0	0
resmgr:actses change group	1,148	0.00		0	0
resmgr:free threads list	869	2.76	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	29,986,060	1.90	0.00	6	0
rules engine aggregate statistics	105,002	1.60	0.00	0	0
rules engine rule set statistics	419,998	0.80	0.00	0	0
rules engine rule statistics	209,885	0.00		0	0
sequence cache	5,807,331	0.69	0.00	0	0
session allocation	6,623,818	1.05	0.00	3	0
session idle bit	382,056	0.01	0.00	0	0
session state list latch	2,342	0.81	0.00	0	0
session switching	48	0.00		0	0
session timer	1,007	0.00		0	0
shared pool	12,526,615	1.32	0.00	6	0
shared pool sim alloc	25	0.00		0	0
shared pool simulator	3,255,185	0.00	0.00	0	0
simulator hash latch	76,488,199	0.01	0.00	0	0
simulator lru latch	76,333,699	1.91	0.00	16	58,992	0.13
sort extent pool	31,387	0.09	0.04	0	0
state object free list	2	0.00		0	0
statistics aggregation	112	0.00		0	0
temporary table state object allocation	381	0.26	0.00	0	0
threshold alerts latch	604	0.00		0	0
transaction allocation	27,676	0.01	0.00	0	0
transaction branch allocation	48	0.00		0	0
undo global data	774,557,784	3.56	0.00	5	72	0.00
user lock	1,482	0.20	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	Sleep1	Sleep2	Sleep3
cache buffers chains	3,436,299,369	69,080,526	34,293	69,050,891	0	0	0
undo global data	774,557,784	27,570,694	2,010	27,569,069	0	0	0
In memory undo latch	675,223,022	4,791,948	2,631	4,789,574	0	0	0
library cache	89,173,978	1,477,656	2,850	1,475,116	0	0	0
simulator lru latch	76,333,699	1,456,839	1,868	1,455,217	0	0	0
library cache pin	57,191,593	607,121	1,020	606,194	0	0	0
row cache objects	29,986,060	569,171	564	568,682	0	0	0
dml lock allocation	4,953,567	176,096	167	175,945	0	0	0
shared pool	12,526,615	165,827	674	165,218	0	0	0
enqueue hash chains	7,819,634	92,116	189	91,948	0	0	0
library cache lock	12,675,606	90,570	130	90,451	0	0	0
session allocation	6,623,818	69,675	251	69,451	0	0	0
redo allocation	3,150,528	59,602	934	58,729	0	0	0
sequence cache	5,807,331	39,829	10	39,820	0	0	0
cache buffer handles	4,685,870	34,021	7	34,014	0	0	0
cache buffers lru chain	5,410,942	25,821	270	25,575	0	0	0
simulator hash latch	76,488,199	7,786	11	7,775	0	0	0
messages	1,674,519	6,344	6	6,339	0	0	0
object queue header operation	10,524,837	6,000	55	5,951	0	0	0
enqueues	1,216,426	4,170	8	4,163	0	0	0
rules engine rule set statistics	419,998	3,371	5	3,366	0	0	0
checkpoint queue latch	3,943,708	458	7	452	0	0	0
KWQMN job cache list latch	206,709	338	74	269	0	0	0
channel operations parent latch	54,339	315	1	314	0	0	0
list of block allocation	287,758	302	9	293	0	0	0
redo writing	1,859,918	208	8	200	0	0	0
qmn task queue latch	2,764	198	27	171	0	0	0
sort extent pool	31,387	27	1	26	0	0	0
parameter table allocation management	441	24	2	22	0	0	0
process allocation	770	2	1	1	0	0	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	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	0	1,301	1,444
In memory undo latch	ktiFlush: child	0	884	568
In memory undo latch	ktiTxnPoolFree	0	185	0
In memory undo latch	ktichg: child	0	120	569
In memory undo latch	kticmt: child	0	117	0
In memory undo latch	ktiBRacquire	0	14	0
In memory undo latch	ktbgfc	0	8	48
KWQMN job cache list latch	kwqmnuji: update job item	0	77	73
active service list	ksws_event: ksws event	0	2	1
cache buffer handles	kcbzgs	0	4	3
cache buffer handles	kcbzfs	0	3	4
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	235,646	221,411
cache buffers chains	kcbgtcr: fast path	0	66,996	19,690
cache buffers chains	kcbgtcr: kslbegin excl	0	34,465	16,173
cache buffers chains	kcbgcur: kslbegin	0	30,042	5,781
cache buffers chains	kcbchg: kslbegin: call CR func	0	15,312	113,531
cache buffers chains	kcbget: pin buffer	0	8,189	1,732
cache buffers chains	kcbzwb	0	4,346	1,358
cache buffers chains	kcbrls: kslbegin	0	1,831	11,303
cache buffers chains	kcbzgb: scan from tail. nowait	0	801	0
cache buffers chains	kcbget: exchange rls	0	242	47
cache buffers chains	kcbget: exchange	0	233	74
cache buffers chains	kcbnlc	0	162	537
cache buffers chains	kcbcge	0	133	2,549
cache buffers chains	kcbgtcr: kslbegin shared	0	64	46
cache buffers chains	kcb_is_private	0	60	4,989
cache buffers chains	kcbnew: new latch again	0	21	1
cache buffers chains	kcb_pre_apply: kcbhq61	0	6	522
cache buffers chains	kcbbic1	0	4	2
cache buffers chains	kcbbic2	0	3	1
cache buffers chains	kcbesc: escalate	0	3	1
cache buffers chains	kcb_post_apply: kcbhq62	0	2	22
cache buffers chains	kcbso1: set no access	0	2	7
cache buffers chains	kcb_post_apply: kcbhq63	0	1	11
cache buffers lru chain	kcbzgws	0	143	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	81	0
cache buffers lru chain	kcbzswcu	0	32	4
cache buffers lru chain	kcbzgb: posted for free bufs	0	9	194
cache buffers lru chain	kcbbxsv: move to being written	0	4	14
cache buffers lru chain	kcbbic2	0	1	102
channel operations parent latch	ksrssonsume()	0	1	0
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	4	0
checkpoint queue latch	kcbswcu: Switch buffers	0	3	5
dml lock allocation	ktaiam	0	119	126
dml lock allocation	ktaidm	0	48	41
enqueue hash chains	ksqgtl3	0	131	122
enqueue hash chains	ksqrcl	0	58	67
enqueues	ksqgel: create enqueue	0	7	7
enqueues	ksqdel	0	1	1
event range base latch	No latch	0	27	27
library cache	kglpnp: child	0	1,262	1,733
library cache	kglpndl: child: after processing	0	1,139	10
library cache	kglobpn: child:	0	181	465
library cache	kglpndl: child: before processing	0	154	556
library cache	kglScanDependency	0	50	0
library cache	kglLockCursor	0	24	34
library cache	kglget: unpin heap 0	0	8	11
library cache	kglhdgn: child:	0	5	39
library cache	kglpin	0	2	2
library cache lock	kgllkdl: child: cleanup	0	92	66
library cache lock	kgllkal: child: multiinstance	0	38	64
library cache lock	kgllkdl: child: no lock handle	0	25	0
library cache pin	kglpndl	0	504	237
library cache pin	kglpnp: child	0	459	612
library cache pin	kglpnal: child: alloc space	0	57	171
list of block allocation	ktlabl	0	8	8
list of block allocation	ktlbbl	0	1	1
messages	ksaamb: after wakeup	0	5	3
messages	ksarcv	0	1	2
object queue header operation	kcbo_switch_cq	0	27	25
object queue header operation	kcbw_link_q	0	11	12
object queue header operation	kcbw_unlink_q	0	11	14
object queue header operation	kcbo_swap_buf	0	8	0
object queue header operation	kcbo_ivbo	0	6	0
object queue header operation	kcbo_switch_mq_bg	0	1	9
parameter table allocation management	ksp_param_table_free	0	2	2
process allocation	ksucrp	0	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	0	777	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	90	535
redo allocation	kcrfw_redo_write: before write	0	30	129
redo allocation	kcrfw_redo_write: more space	0	23	268
redo allocation	kcrfw_redo_gen: redo allocation 2	0	12	0
redo allocation	kcrf_pvt_strand_unbind	0	2	0
redo writing	kcrfw_post: rba scn pair	0	8	0
row cache objects	kqreqd: reget	0	470	0
row cache objects	kqrpre: find obj	0	77	560
row cache objects	kqreqd	0	17	4
rules engine rule set statistics	kwrsoef: find ectx stats	0	5	1
sequence cache	kdnssd	0	7	0
sequence cache	kdnnxt: cached seq	0	2	0
sequence cache	kdnss	0	1	24
session allocation	ksudlc	0	143	51
session allocation	ksuprc	0	102	193
session allocation	ksuxds: KSUSFCLC not set	0	5	5
session allocation	ksuxds: not user session	0	1	3
shared pool	kghalo	0	380	516
shared pool	kghfre	0	208	79
shared pool	kghupr1	0	86	79
simulator hash latch	kcbsacc: lookup dba	0	10	11
simulator hash latch	kcbs_lookup_setid: lookup dba	0	1	0
simulator lru latch	kcbs_simulate: simulate set	0	1,848	1,779
simulator lru latch	kcbs_simbufseq	0	20	89
sort extent pool	ktstdt: dealloc sort extent	0	1	0
undo global data	kturimugur: child	0	1,592	692
undo global data	ktudba: KSLBEGIN	0	385	1,283
undo global data	ktudnx:child	0	20	11
undo global data	ktubnd:child	0	5	0
undo global data	ktucof: at start	0	4	0
undo global data	ktufrbs: child	0	3	23
undo global data	kturar: KSLBEGIN	0	1	0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 1,346,854,232
• Captured Segments account for 32.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_IDX	RA_INTERFACE_LINES_C01		INDEX	44,706,336	3.32
APPLSYS	APPS_TS_SEED	WF_ACTIVITIES_PK		INDEX	43,702,592	3.24
APPLSYS	APPS_TS_SEED	WF_ACTIVITIES		TABLE	42,894,592	3.18
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_PK	WF_ITEM49	INDEX PARTITION	29,625,648	2.20
INV	APPS_TS_INTERFACE	MTL_TRANSACTIONS_INTERFACE		TABLE	29,582,720	2.20

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 58,915
• Captured Segments account for 58.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	15,420	26.17
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	10,798	18.33
AR	APPS_TS_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	4,546	7.72
INV	APPS_TS_INTERFACE	MTL_TRANSACTIONS_INTERFACE		TABLE	1,617	2.74
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	384	0.65

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	965,936	49.00
APPLSYS	APPS_TS_QUEUES	SYS_IOT_TOP_153630		INDEX	525,545	26.66
WSH	APPS_TS_INTERFACE	WSH_PR_WORKERS		TABLE	443,401	22.49
APPLSYS	APPS_TS_TX_DATA	WF_ITEMS		TABLE	22,931	1.16
AR	APPS_TS_TX_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	3,650	0.19

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	Subobject Name	Obj. Type	ITL Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_PK	WF_ITEM49	INDEX PARTITION	3	50.00
ASO	APPS_TS_QUEUES	SYS_IOT_TOP_114472		INDEX	2	33.33
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	1	16.67

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,777	13.30
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ACTIVITY_STATUSES	WF_ITEM49	TABLE PARTITION	47,891	10.15
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	42,915	9.09
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	42,477	9.00
APPLSYS	APPS_TS_QUEUES	SYS_IOT_TOP_153630		INDEX	31,680	6.71

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	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	53	0.00	0		2	1
dc_constraints	128	50.00	0		128	65
dc_global_oids	1,203,851	0.00	0		4	94
dc_histogram_data	826	1.94	0		0	1,988
dc_histogram_defs	23,923	3.06	0		491	17,500
dc_object_grants	241	0.00	0		0	606
dc_object_ids	3,285,898	0.00	0		19	4,296
dc_objects	206,332	0.04	0		159	5,415
dc_profiles	377	0.00	0		0	1
dc_rollback_segments	23,461	0.00	0		0	509
dc_segments	36,698	0.09	0		21,545	5,015
dc_sequences	41,752	0.00	0		41,752	75
dc_table_scns	201,625	0.00	0		0	15
dc_tablespace_quotas	22,716	0.00	0		0	34
dc_tablespaces	360,931	0.00	0		0	57
dc_usernames	485,263	0.00	0		0	73
dc_users	4,307,422	0.00	0		0	246
outstanding_alerts	277	0.00	0		1	54

Back to Top

 

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	16,805	0.02	10,092,784	-0.00	0	0
CLUSTER	1	0.00	1	0.00	0	0
INDEX	132	12.12	270	8.89	0	0
JAVA DATA	108	0.00	0		0	0
PIPE	1,023	0.00	1,023	0.00	0	0
SQL AREA	277	90.61	48,940,731	0.02	339	337
TABLE/PROCEDURE	16,993	0.37	15,012,742	-0.00	8	0
TRIGGER	831	0.00	787,917	-0.00	0	0

Back to Top

 

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Back to Top

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	179.43		1.99	2.34	22	35	90	90
	Freeable	70.31	0.00	1.60	3.30	14		44	44
	SQL	19.79	10.01	0.23	0.57	5	5	85	81
	PL/SQL	6.30	2.45	0.07	0.05	0	0	90	90
E	Other	175.53		1.93	2.33	22	35	91	91
	Freeable	70.75	0.00	1.61	3.29	14		44	44
	SQL	20.01	10.15	0.23	0.58	5	5	86	83
	PL/SQL	6.45	2.45	0.07	0.05	0	0	91	91

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

• 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	147.44	147.44	0.00
java	joxlod exec hp	11.89	11.89	0.00
shared	CCursor	23.02	24.29	5.49
shared	KGLS heap	32.19	32.27	0.24
shared	KTI-UNDO	32.56	32.56	0.00
shared	PL/SQL MPCODE	41.95	42.06	0.25
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	event statistics per sess	35.16	35.16	0.00
shared	free memory	1,367.33	1,355.82	-0.84
shared	ktcmvcb	23.55	46.92	99.28
shared	library cache	32.85	33.36	1.53
shared	private strands	55.43	55.43	0.00
shared	sql area	177.71	185.40	4.32
streams	free memory	47.99	47.99	0.00
	buffer_cache	8,192.00	8,192.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

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

Back to Top

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	13,002,821	23,519	0
QMON Coordinator	189,080	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_20628	0	0	0

Back to Streams Statistics
Back to Top

Rule Set

• Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
APPLSYS.WF_DEFERRED_QUEUE_M_R	104,821	0	104,980	477	1,502
SYS.ALERT_QUE_R	1	0	0	0	0
APPLSYS.FND_CP_GSM_OPP_AQ_R	1	0	0	0	0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.

Back to Top

 

init.ora Parameters

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

Back to Top

End of Report