WORKLOAD REPOSITORY report for

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

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

 

Report Summary

Cache Sizes

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

Load Profile

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

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

Instance Efficiency Percentages (Target 100%)

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

Shared Pool Statistics

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

Top 5 Timed Events

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

Main Report

• 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): 17490s
• 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	17,476.53	99.92
DB CPU	8,053.11	46.04
PL/SQL execution elapsed time	3,492.10	19.97
Java execution elapsed time	404.59	2.31
parse time elapsed	53.72	0.31
sequence load elapsed time	8.63	0.05
hard parse elapsed time	6.63	0.04
repeated bind elapsed time	4.05	0.02
connection management call elapsed time	0.67	0.00
hard parse (sharing criteria) elapsed time	0.19	0.00
PL/SQL compilation elapsed time	0.16	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
inbound PL/SQL rpc elapsed time	0.01	0.00
DB time	17,490.02
background elapsed time	960.63
background cpu time	53.70

Back to Wait Events Statistics
Back to Top

Wait Class

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

Back to Wait Events Statistics
Back to Top

Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

• 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	405,082	0.00	661	2	0.66
db file parallel write	103,382	0.00	193	2	0.17
events in waitclass Other	23,715	0.55	11	0	0.04
control file parallel write	1,313	0.00	2	2	0.00
control file sequential read	638	0.00	1	1	0.00
db file sequential read	47	0.00	0	5	0.00
os thread startup	7	0.00	0	26	0.00
latch: redo writing	19	0.00	0	4	0.00
buffer busy waits	145	0.00	0	0	0.00
direct path write	258	0.00	0	0	0.00
latch: library cache	2	0.00	0	11	0.00
log buffer space	1	0.00	0	10	0.00
latch: row cache objects	1	0.00	0	6	0.00
latch: In memory undo latch	3	0.00	0	1	0.00
direct path read	1,038	0.00	0	0	0.00
undo segment extension	776	99.48	0	0	0.00
latch: cache buffers chains	2	0.00	0	0	0.00
rdbms ipc message	395,212	2.03	20,758	53	0.64
smon timer	2,569	0.00	2,676	1042	0.00
pmon timer	946	100.00	2,619	2769	0.00
Streams AQ: qmn coordinator idle wait	969	42.41	2,616	2699	0.00
Streams AQ: qmn slave idle wait	470	0.00	2,616	5565	0.00
Streams AQ: waiting for time management or cleanup tasks	75	41.33	2,076	27674	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

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

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• 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	52199	16128	1065992	51449	0	0	303919	336
SYS$USERS	416	52	5	1	0	0	48	0
SYS$BACKGROUND	1343	24	160	24	0	0	0	0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

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

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• Total Buffer Gets: 1,378,081,470
• Captured SQL account for 43.4% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 57,953
• Captured SQL account for 1.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
32,368	8	4,046.00	55.85	2143.53	5630.16	8zfgv4ck11dw9	FNDWFBG	BEGIN WF_ENGINE.BACKGROUNDCONC...
31,007	49,865	0.62	53.50	986.21	2040.35	gksvm8wmzk8w0	FNDWFBG	begin OE_INVOICE_WF.INVOICE_IN...
11,467	16	716.69	19.79	111.67	149.20	5t39uchjqpyfm	XLAACCUP	BEGIN xla_accounting_pkg.unit_...
2,901	16	181.31	5.01	3026.81	5948.29	4y08a52989vfk	WSHPSGL_SUB	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,118	10	211.80	3.65	299.62	589.54	0074pdmwb7fmv	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
758	10	75.80	1.31	884.11	1719.51	72yyswsqkzkrm	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
741	54,984	0.01	1.28	131.45	147.46	g8102j8yynbwz	OEHVIMP	begin WF_STANDARD.CONTINUEFLOW...
480	3	160.00	0.83	153.52	154.13	1wnq9qthbb54q	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
357	100	3.57	0.62	608.54	2245.63	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
307	49,926	0.01	0.53	346.70	355.69	gnng1rmpjxzsx	FNDWFBG	begin OE_CLOSE_WF.CLOSE_LINE (...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 45,718,295
• Captured SQL account for 24.2% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 1,970,434
• Captured SQL account for 93.7% of Total

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

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

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

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to IO Stats
Back to Top

File IO Stats

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

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

• 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,375,008,811	56,847	1,476,951	0	0	973,878

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

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - 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,936	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,745	215.58	0.00	0.00	0.00	0.00	209,710
E	2,048	1,729	223.13	0.00	0.00	0.00	0.00	209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

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

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• 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	131,583.83	895.05	99.00	227
512	0.25	131,583.83	458.56	100.00	62
1,024	0.50	131,583.83	392.89	100.00	43
1,536	0.75	131,583.83	334.23	100.00	28
2,048	1.00	131,583.83	0.00	100.00	10
2,458	1.20	131,583.83	0.00	100.00	0
2,867	1.40	131,583.83	0.00	100.00	0
3,277	1.60	131,583.83	0.00	100.00	0
3,686	1.80	131,583.83	0.00	100.00	0
4,096	2.00	131,583.83	0.00	100.00	0
6,144	3.00	131,583.83	0.00	100.00	0
8,192	4.00	131,583.83	0.00	100.00	0
12,288	6.00	131,583.83	0.00	100.00	0
16,384	8.00	131,583.83	0.00	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• 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
384	0.19	234	10,826	1,048,475	1.00	1,172	4.88	79,742,168
592	0.29	333	17,783	1,049,407	1.00	240	1.00	79,744,386
800	0.39	333	17,783	1,049,407	1.00	240	1.00	79,744,386
1,008	0.49	333	17,783	1,049,407	1.00	240	1.00	79,744,386
1,216	0.59	333	17,783	1,049,407	1.00	240	1.00	79,744,386
1,424	0.70	333	17,783	1,049,407	1.00	240	1.00	79,744,386
1,632	0.80	333	17,783	1,049,407	1.00	240	1.00	79,744,386
1,840	0.90	333	17,783	1,049,407	1.00	240	1.00	79,744,386
2,048	1.00	333	17,783	1,049,407	1.00	240	1.00	79,744,386
2,256	1.10	333	17,783	1,049,407	1.00	240	1.00	79,744,386
2,464	1.20	333	17,783	1,049,407	1.00	240	1.00	79,744,386
2,672	1.30	333	17,783	1,049,407	1.00	240	1.00	79,744,386
2,880	1.41	333	17,783	1,049,407	1.00	240	1.00	79,744,386
3,088	1.51	333	17,783	1,049,407	1.00	240	1.00	79,744,386
3,296	1.61	333	17,783	1,049,407	1.00	240	1.00	79,744,386
3,504	1.71	333	17,783	1,049,407	1.00	240	1.00	79,744,386
3,712	1.81	333	17,783	1,049,407	1.00	240	1.00	79,744,386
3,920	1.91	333	17,783	1,049,407	1.00	240	1.00	79,744,386
4,128	2.02	333	17,783	1,049,407	1.00	240	1.00	79,744,386

Back to Advisory Statistics
Back to Top

 

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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

Back to Advisory Statistics
Back to Top

 

Wait Statistics

• 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	403,876	166	0
undo block	513,617	144	0
undo header	32,783	19	1
1st level bmb	14,581	4	0
segment header	8,538	1	0
2nd level bmb	346	0	0
extent map	22	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

• 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)	352,657	13,615	339,042	13,506	150	11.08
TX-Transaction (index contention)	15,602	15,602	0	14,716	37	2.51
TX-Transaction	888,345	888,536	0	6,053	15	2.41
HW-Segment High Water Mark	81,393	81,391	2	4,959	12	2.35
FB-Format Block	21,420	21,420	0	1,164	2	1.84
SQ-Sequence Cache	29,051	29,051	0	2,300	1	0.27
RO-Multiple Object Reuse (fast object reuse)	324	324	0	36	0	3.86
TX-Transaction (allocate ITL entry)	108	108	0	88	0	0.17
PS-PX Process Reservation	204	172	32	5	0	0.20

Back to Wait Statistics
Back to Top

 

Undo Statistics

• 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,078.31	880,704	282	22	6.28333333333333333333333333333333333333/13.7	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

• 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
19-Mar 10:36	152,121	62,720	0	12	9	0/0	0/0/0/0/0/0
19-Mar 10:26	345,322	268,610	274	22	6	0/0	0/0/0/0/0/0
19-Mar 10:16	156,966	248,377	0	14	9	0/0	0/0/0/0/0/0
19-Mar 10:06	350,046	275,808	0	16	6	0/0	0/0/0/0/0/0
19-Mar 09:56	73,850	25,189	282	17	14	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
cache buffers chains	3,456,345,171	110,580,036	75,464	110,516,084	0	0	0
undo global data	749,025,503	24,571,744	1,655	24,570,294	0	0	0
In memory undo latch	640,638,847	5,141,210	2,222	5,139,212	0	0	0
simulator lru latch	79,571,036	2,923,407	1,461	2,922,102	0	0	0
library cache	90,020,399	800,726	2,764	798,310	0	0	0
library cache pin	57,180,566	313,716	1,021	312,817	0	0	0
row cache objects	29,820,994	188,058	621	187,516	0	0	0
shared pool	12,441,234	87,500	546	87,013	0	0	0
redo allocation	3,003,280	84,374	1,314	83,187	0	0	0
dml lock allocation	4,971,241	75,034	144	74,910	0	0	0
session allocation	6,569,385	59,855	224	59,662	0	0	0
enqueue hash chains	7,907,391	42,572	155	42,429	0	0	0
library cache lock	13,493,972	35,443	215	35,247	0	0	0
cache buffer handles	4,550,016	26,533	4	26,530	0	0	0
cache buffers lru chain	5,247,674	21,896	261	21,671	0	0	0
sequence cache	5,804,293	13,487	12	13,476	0	0	0
simulator hash latch	79,700,020	7,047	14	7,034	0	0	0
object queue header operation	10,193,793	5,047	50	5,004	0	0	0
enqueues	1,436,120	4,434	21	4,416	0	0	0
messages	1,674,937	1,993	2	1,991	0	0	0
rules engine rule set statistics	420,098	840	3	837	0	0	0
checkpoint queue latch	4,780,480	466	6	460	0	0	0
rules engine aggregate statistics	105,003	381	3	378	0	0	0
channel operations parent latch	58,456	270	1	269	0	0	0
redo writing	1,742,951	228	19	209	0	0	0
KWQMN job cache list latch	206,667	158	20	140	0	0	0
commit callback allocation	222,302	136	2	134	0	0	0
parameter table allocation management	466	22	1	21	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

• 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,378,081,470
• Captured Segments account for 36.6% of Total

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

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 57,953
• Captured Segments account for 61.6% 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	14,761	25.47
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	10,539	18.19
AR	APPS_TS_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	6,214	10.72
INV	APPS_TS_INTERFACE	MTL_TRANSACTIONS_INTERFACE		TABLE	1,872	3.23
ASO	APPS_TS_QUEUES	SYS_IOT_TOP_114472		INDEX	441	0.76

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

• % 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	923,220	42.82
WSH	APPS_TS_INTERFACE	WSH_PR_WORKERS		TABLE	677,824	31.44
APPLSYS	APPS_TS_QUEUES	SYS_IOT_TOP_153630		INDEX	515,263	23.90
APPLSYS	APPS_TS_TX_DATA	WF_ITEMS		TABLE	25,670	1.19
AR	APPS_TS_TX_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	6,861	0.32

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

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

Back to Top

 

Library Cache Activity

• "Pct Misses" should be very low

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

Back to Top

 

Memory Statistics

• 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	143.16		1.99	2.72	22	35	72	72
	Freeable	54.00	0.00	1.54	3.34	14		35	35
	SQL	14.39	7.63	0.21	0.63	5	5	67	61
	PL/SQL	4.08	1.69	0.06	0.04	0	0	72	68
E	Other	155.85		2.26	4.09	28	35	69	69
	Freeable	48.50	0.00	1.35	3.03	14		36	36
	SQL	14.62	7.78	0.23	0.65	5	5	64	63
	PL/SQL	4.20	1.70	0.06	0.04	0	0	69	69

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

• 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.47	147.47	0.00
java	joxlod exec hp	11.87	11.87	0.00
shared	CCursor	24.59	26.56	7.98
shared	KGLS heap	33.72	33.72	0.00
shared	PL/SQL MPCODE	42.04	42.04	0.00
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	1,531.06	1,517.48	-0.89
shared	ktcmvcb	23.45	46.55	98.51
shared	library cache	32.02	32.67	2.03
shared	sql area	171.36	180.95	5.60
streams	free memory	47.99	47.99	0.00
	buffer_cache	8,192.00	8,192.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

• 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	11,170,738	12,830	0
QMON Coordinator	30,206	0	0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

• 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

No data exists for this section of the report.

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

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.

Back to Top

 

init.ora Parameters

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

Back to Top

End of Report