WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
VIS	187584551	VIS	1	10.2.0.3.0	NO	hpdb1

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1	15-Feb-08 09:45:20	3582	205.0
End Snap:	2	15-Feb-08 10:45:26	3596	238.0
Elapsed:		60.09 (mins)
DB Time:		496.19 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	18,240M	18,096M	Std Block Size:	8K
Shared Pool Size:	2,144M	2,288M	Log Buffer:	14,320K

Load Profile

	Per Second	Per Transaction
Redo size:	8,346,812.95	32,071.41
Logical reads:	509,917.13	1,959.28
Block changes:	51,490.32	197.84
Physical reads:	124.93	0.48
Physical writes:	814.49	3.13
User calls:	9,386.44	36.07
Parses:	1,887.54	7.25
Hard parses:	1.99	0.01
Sorts:	2,317.99	8.91
Logons:	2.13	0.01
Executes:	22,593.53	86.81
Transactions:	260.26

% Blocks changed per Read:	10.10	Recursive Call %:	79.66
Rollback per transaction %:	18.94	Rows per Sort:	12.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.95	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.79	Soft Parse %:	99.89
Execute to Parse %:	91.65	Latch Hit %:	98.72
Parse CPU to Parse Elapsd %:	84.59	% Non-Parse CPU:	97.83

Shared Pool Statistics

	Begin	End
Memory Usage %:	84.40	84.72
% SQL with executions>1:	89.45	89.34
% Memory for SQL w/exec>1:	67.07	65.96

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		23,675		79.5
db file sequential read	257,143	2,995	12	10.1	User I/O
log file sync	379,744	890	2	3.0	Commit
db file scattered read	15,998	489	31	1.6	User I/O
SQL*Net more data from client	1,779,829	465	0	1.6	Network

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): 29771.5s
• 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	25,736.23	86.45
DB CPU	23,675.37	79.52
PL/SQL execution elapsed time	5,535.00	18.59
inbound PL/SQL rpc elapsed time	5,516.98	18.53
parse time elapsed	676.97	2.27
Java execution elapsed time	645.20	2.17
hard parse elapsed time	308.74	1.04
repeated bind elapsed time	87.61	0.29
sequence load elapsed time	17.87	0.06
connection management call elapsed time	11.92	0.04
PL/SQL compilation elapsed time	10.04	0.03
hard parse (sharing criteria) elapsed time	4.55	0.02
failed parse elapsed time	1.41	0.00
hard parse (bind mismatch) elapsed time	1.18	0.00
DB time	29,771.49
background elapsed time	1,481.70
background cpu time	501.45

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
User I/O	314,399	0.05	3,878	12	0.34
Commit	379,744	0.00	890	2	0.40
Concurrency	2,389,562	0.24	641	0	2.55
Application	52,413	0.33	581	11	0.06
Network	38,819,629	0.00	544	0	41.37
System I/O	677,613	0.00	329	0	0.72
Other	139,050	34.34	107	1	0.15
Configuration	7,713	0.01	13	2	0.01

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
db file sequential read	257,143	0.00	2,995	12	0.27
log file sync	379,744	0.00	890	2	0.40
db file scattered read	15,998	0.00	489	31	0.02
SQL*Net more data from client	1,779,829	0.00	465	0	1.90
buffer busy waits	838,419	0.04	437	1	0.89
enq: RO - fast object reuse	160	78.75	386	2410	0.00
log file parallel write	646,395	0.00	324	1	0.69
local write wait	1,557	9.63	232	149	0.00
read by other session	37,056	0.01	163	4	0.04
enq: UL - contention	1,982	1.87	125	63	0.00
latch: cache buffers chains	1,477,872	0.00	66	0	1.57
cursor: pin S wait on X	5,752	93.53	59	10	0.01
rdbms ipc reply	28	92.86	54	1931	0.00
enq: TX - row lock contention	405	1.73	50	123	0.00
SQL*Net message to client	35,463,929	0.00	47	0	37.79
SQL*Net more data to client	1,575,871	0.00	33	0	1.68
library cache load lock	782	0.00	29	37	0.00
enq: TX - index contention	31,232	0.00	29	1	0.03
PX Deq Credit: send blkd	21,673	0.00	23	1	0.02
SQL*Net break/reset to client	49,858	0.00	12	0	0.05
enq: HW - contention	2,936	0.00	11	4	0.00
latch: library cache	11,432	0.00	10	1	0.01
enq: TM - contention	8	25.00	8	1060	0.00
kksfbc child completion	113	85.84	5	43	0.00
control file parallel write	1,859	0.00	4	2	0.00
latch: undo global data	7,390	0.00	4	0	0.01
latch: In memory undo latch	16,038	0.00	3	0	0.02
os thread startup	76	0.00	3	40	0.00
latch free	4,680	0.00	3	1	0.00
latch: library cache pin	3,464	0.00	2	1	0.00
latch: object queue header operation	16,059	0.00	2	0	0.02
wait list latch free	181	0.00	2	11	0.00
PX Deq: Signal ACK	275	23.27	2	6	0.00
latch: cache buffers lru chain	1,405	0.00	2	1	0.00
buffer deadlock	47,542	98.59	2	0	0.05
enq: DV - contention	171	0.00	1	9	0.00
LGWR wait for redo copy	25,466	0.00	1	0	0.03
enq: TX - contention	2,694	0.00	1	1	0.00
latch: redo allocation	2,497	0.00	1	0	0.00
latch: row cache objects	1,191	0.00	1	1	0.00
latch: session allocation	1,716	0.00	1	1	0.00
enq: SQ - contention	4,113	0.00	1	0	0.00
log file switch completion	47	0.00	1	18	0.00
row cache lock	905	0.00	1	1	0.00
enq: TX - allocate ITL entry	158	0.00	1	3	0.00
SGA: allocation forcing component growth	46	71.74	0	11	0.00
PX qref latch	720	91.25	0	1	0.00
library cache pin	1,428	0.00	0	0	0.00
write complete waits	8	12.50	0	32	0.00
enq: FB - contention	932	0.00	0	0	0.00
control file sequential read	29,347	0.00	0	0	0.03
cursor: pin S	4,654	0.00	0	0	0.00
reliable message	33	0.00	0	7	0.00
latch: object queue header heap	383	0.00	0	1	0.00
latch: shared pool	428	0.00	0	0	0.00
latch: cache buffer handles	223	0.00	0	1	0.00
latch: library cache lock	188	0.00	0	1	0.00
latch: messages	86	0.00	0	1	0.00
log file sequential read	6	0.00	0	7	0.00
latch: redo writing	451	0.00	0	0	0.00
cursor: mutex S	119	0.00	0	0	0.00
latch: enqueue hash chains	23	0.00	0	0	0.00
cursor: mutex X	236	0.00	0	0	0.00
latch: checkpoint queue latch	8	0.00	0	0	0.00
direct path read	1,830	0.00	0	0	0.00
enq: CU - contention	1	0.00	0	3	0.00
enq: PS - contention	49	0.00	0	0	0.00
enq: US - contention	1	0.00	0	2	0.00
direct path write	771	0.00	0	0	0.00
log file single write	6	0.00	0	0	0.00
direct path write temp	38	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
L1 validation	1	0.00	0	0	0.00
SQL*Net message from client	35,463,916	0.00	6,983,862	197	37.79
pipe get	21,908	21.07	21,063	961	0.02
Streams AQ: waiting for messages in the queue	2,389	100.00	11,658	4880	0.00
PX Idle Wait	3,284	76.49	5,180	1577	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,517	27263	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,517	13631	0.00
Streams AQ: waiting for time management or cleanup tasks	2,221	38.63	3,513	1582	0.00
PL/SQL lock timer	260	99.62	2,859	10995	0.00
jobq slave wait	612	99.51	1,792	2927	0.00
PX Deq: Execution Msg	11,497	0.00	64	6	0.01
PX Deq: Msg Fragment	9,341	0.00	3	0	0.01
PX Deq Credit: need buffer	3,718	0.00	3	1	0.00
PX Deq: Execute Reply	4,272	0.00	2	1	0.00
PX Deq: Table Q Normal	8,191	0.00	1	0	0.01
PX Deq: Parse Reply	318	0.00	0	1	0.00
PX Deq: Join ACK	205	0.00	0	0	0.00
class slave wait	1	0.00	0	1	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	646,399	0.00	324	1	0.69
db file scattered read	189	0.00	6	31	0.00
control file parallel write	1,859	0.00	4	2	0.00
events in waitclass Other	35,017	0.00	3	0	0.04
os thread startup	60	0.00	2	41	0.00
db file sequential read	127	0.00	2	14	0.00
latch: cache buffers chains	37	0.00	0	1	0.00
log file sequential read	6	0.00	0	7	0.00
latch: redo writing	451	0.00	0	0	0.00
control file sequential read	1,019	0.00	0	0	0.00
direct path read	1,830	0.00	0	0	0.00
log file sync	1	0.00	0	1	0.00
latch: shared pool	2	0.00	0	0	0.00
log file single write	6	0.00	0	0	0.00
direct path write	666	0.00	0	0	0.00
buffer busy waits	6	0.00	0	0	0.00
latch: library cache pin	1	0.00	0	0	0.00
latch: library cache	1	0.00	0	0	0.00
rdbms ipc message	957,368	1.05	30,235	32	1.02
pmon timer	1,245	98.15	3,518	2826	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,517	27263	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,517	13631	0.00
Streams AQ: waiting for time management or cleanup tasks	2,221	38.63	3,513	1582	0.00
smon timer	110,961	0.00	3,500	32	0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,602,998
IDLE_TIME	3,159,677
IOWAIT_TIME	176,689
NICE_TIME	24,344
SYS_TIME	167,761
USER_TIME	2,320,535
LOAD	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,680
NUM_CPUS	16
NUM_CPU_SOCKETS	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
SYS$USERS	29,764.10	23,670.60	439,838	1,835,664,722
SYS$BACKGROUND	0.00	0.00	10,477	2,750,458
VIS	0.00	0.00	0	0

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
SYS$USERS	311579	387071	2389439	63818	0	0	38808378	54444
SYS$BACKGROUND	2814	769	107	252	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
913	905	300	3.04	3.07	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
606	16	1,608	0.38	2.04	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
576	106	1,608	0.36	1.93	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
516	509	54,779	0.01	1.73	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
492	441	75,489	0.01	1.65	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
477	153	10,000	0.05	1.60	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
469	382	135,421	0.00	1.58	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
462	456	54,753	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
451	445	54,777	0.01	1.52	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
426	3	56	7.60	1.43	9k7t8q4kfcb7y	SQL*Plus	begin GL.apps_ddl.apps_ddl(:dd...
395	393	250,190	0.00	1.33	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
395	392	63,632	0.01	1.33	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
361	260	178,061	0.00	1.21	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
340	153	14,428	0.02	1.14	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
332	327	61,003	0.01	1.11	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
325	304	960	0.34	1.09	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...

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
905	913	300	3.02	3.07	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
509	516	54,779	0.01	1.73	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
456	462	54,753	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
445	451	54,777	0.01	1.52	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
441	492	75,489	0.01	1.65	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
393	395	250,190	0.00	1.33	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
392	395	63,632	0.01	1.33	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
382	469	135,421	0.00	1.58	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
327	332	61,003	0.01	1.11	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
304	325	960	0.32	1.09	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
260	361	178,061	0.00	1.21	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
153	340	14,428	0.01	1.14	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
153	477	10,000	0.02	1.60	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
106	576	1,608	0.07	1.93	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
16	606	1,608	0.01	2.04	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
3	426	56	0.06	1.43	9k7t8q4kfcb7y	SQL*Plus	begin GL.apps_ddl.apps_ddl(:dd...

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,838,606,145
• Captured SQL account for 19.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
154,609,170	63,632	2,429.74	8.41	392.26	394.54	auzgm2ap4faw2	JDBC Thin Client	(SELECT SUB.GUID SUB_GUID, DE...
50,983,873	135,421	376.48	2.77	381.69	469.18	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
49,501,029	178,061	278.00	2.69	259.95	361.11	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
48,884,721	54,779	892.40	2.66	508.71	515.98	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
42,139,016	300	140,463.39	2.29	905.24	913.37	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
34,792,380	54,777	635.16	1.89	444.59	451.10	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
30,757,598	166,006	185.28	1.67	226.40	232.70	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
30,734,080	165,952	185.20	1.67	242.56	248.94	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
29,083,420	4,810	6,046.45	1.58	177.65	266.54	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
28,496,267	1,367,169	20.84	1.55	157.03	158.39	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
26,396,111	10,000	2,639.61	1.44	152.71	476.63	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
25,274,754	11	2,297,704.91	1.37	137.45	137.45	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...
23,569,103	61,003	386.36	1.28	327.00	331.62	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
22,723,860	54,753	415.02	1.24	456.16	461.98	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 450,456
• Captured SQL account for 39.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,235	10,000	4.52	10.04	152.71	476.63	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
43,071	1,608	26.79	9.56	15.51	606.16	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
31,440	1,608	19.55	6.98	106.27	576.00	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
26,190	4,744	5.52	5.81	5.22	200.72	auudu2jzbt9s0	CSCCCCRC	SELECT HD.ID CONTRACT_ID , HD....
21,900	14,428	1.52	4.86	153.03	340.37	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
13,330	178,061	0.07	2.96	259.95	361.11	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
11,601	2,728	4.25	2.58	14.54	177.88	72cqcsuq5wgh0	asn.dashboard.server.DashboardAM	SELECT aslrt.meaning as rank_n...
11,213	481	23.31	2.49	121.19	201.73	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,332	4,810	2.15	2.29	177.65	266.54	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
10,277	135,421	0.08	2.28	381.69	469.18	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,600	9,999	0.46	1.02	193.93	231.76	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
4,511	10,000	0.45	1.00	161.22	195.25	63t8zpm02skgh	PYUSLV	SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 81,465,418
• Captured SQL account for 9.7% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
1,367,169	708,194	0.52	0.00	0.00	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
779,854	779,828	1.00	0.00	0.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
727,444	727,393	1.00	0.00	0.00	gnhmcahkmrnzs	ap.oie.server.WebExpensesAM	INSERT INTO WF_ITEM_ACTIVITY_S...
425,176	182,983	0.43	0.00	0.00	0wrz2kbatczjk	CSCCCCRC	SELECT EXECUTE_FLAG FROM JTF_U...
402,534	402,535	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
251,282	196,270	0.78	0.00	0.00	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
250,190	250,182	1.00	0.00	0.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
197,021	3,349,185	17.00	0.00	0.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
178,061	0	0.00	0.00	0.00	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
166,006	165,994	1.00	0.00	0.00	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 6,805,891
• Captured SQL account for 44.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
402,538	402,534	5.91	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
251,283	251,282	3.69	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
250,194	250,190	3.68	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
197,022	197,021	2.89	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
165,288	165,994	2.43	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
135,422	135,421	1.99	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
116,403	116,817	1.71	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
111,002	111,241	1.63	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
87,408	87,546	1.28	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
83,466	83,492	1.23	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...
83,461	87,538	1.23	dcvv68fju01g4	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.E...
83,439	83,524	1.23	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
80,329	80,328	1.18	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
74,300	74,309	1.09	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
69,996	69,995	1.03	97mt0g20bcfc3	PYUSLV	begin ...

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
0wrz2kbatczjk	SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
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 ;
162ttnv4ubqun	begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); 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
1q78dwnrrkf6c	BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
25wzrzwd46a44	SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk	SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh	SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39	select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
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
6gnth2mfbs2nq	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
72cqcsuq5wgh0	SELECT aslrt.meaning as rank_name , aslrt.rank_id, sum(case when asl.status_open_flag = 'Y' AND round(sysdate-asl.creation_date)<= 2 THEN 1 else 0 END) as day0_2, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 3 and 7 THEN 1 else 0 END) as day3_7, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 8 and 30 THEN 1 else 0 END) as day8_30, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) >= 31 THEN 1 else 0 END) as day_31, sum(case when nvl(asl.status_open_flag, 'N') = 'N' AND asl.status_code <> 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as closed, sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as converted, round((sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END)/count(asl.sales_lead_id)) * 100, 2) as conversion, count(aslrt.rank_id) total_leads FROM as_sales_leads asl, as_sales_lead_ranks_tl aslrt, as_sales_lead_ranks_b aslrb, ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id , aaa.customer_id FROM as_accesses_all aaa WHERE aaa.lead_id is null AND aaa.sales_lead_id IS NOT NULL AND aaa.salesforce_id = :1)secu WHERE asl.lead_rank_id = aslrt.rank_id AND aslrb.rank_id = aslrt.rank_id AND aslrt.language = USERENV('LANG') AND secu.sa les_lead_id = asl.sales_lead_id AND secu.customer_id = asl.customer_id GROUP BY aslrt.rank_id, aslrt.meaning, aslrb.min_score ORDER BY aslrb.min_score DESC
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
827gtfny5uagb	begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2	SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8camsgjsr9zya	begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8jb36w62w5hqf	BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
97mt0g20bcfc3	begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9k7t8q4kfcb7y	begin GL.apps_ddl.apps_ddl(:ddl_text); end;
9wdrypwkpf607	begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4	BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
auudu2jzbt9s0	SELECT HD.ID CONTRACT_ID , HD.CONTRACT_NUMBER , HD.CONTRACT_NUMBER_MODIFIER , HD.STS_CODE , HD.AUTHORING_ORG_ID , HD.INV_ORGANIZATION_ID , HD.END_DATE HDR_END_DATE , SV.ID SERVICE_LINE_ID , SV.START_DATE SV_START_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(SV.END_DATE) SV_END_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(SV.DATE_TERMINATED) SV_DATE_TERMINATED , CL.STS_CODE CL_STS_CODE , CL.ID COVLVL_LINE_ID , CL.START_DATE CL_START_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(CL.END_DATE) CL_END_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(CL.DATE_TERMINATED) CL_DATE_TERMINATED , DECODE(SV.LSE_ID, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') WARRANTY_FLAG FROM OKC_K_HEADERS_B HD , OKC_K_LINES_B SV , OKC_K_LINES_B CL WHERE HD.ID = :B3 AND HD.SCS_CODE IN ('SERVICE', 'WARRANTY') AND HD.ID > -1 AND HD.TEMPLATE_YN <> 'Y' AND SV.DNZ_CHR_ID = HD.ID AND SV.CLE_ID IS NULL AND SV.CHR_ID = HD.ID AND SV.LSE_ID IN (1, 14, 19) AND CL.CLE_ID = SV.ID AND CL.LSE_ID IN (7, 8, 9, 10, 11, 35, 18, 25) AND CL.ID = :B2 AND (:B1 IS NULL OR EXISTS (SELECT '*' FROM OKC_K_ITEMS ITM , OKC_K_LINES_B BPL , OKC_K_LINES_B CV WHERE CV.CLE_ID = SV.ID AND CV.LSE_ID IN (2, 15, 20) AND BPL.CLE_ID = CV.ID AND ITM.CLE_ID = BPL.ID AND ITM.OBJECT1_ID1||'' = TO_CHAR(:B1 ) AND ITM.OBJECT1_ID2 = '#' AND ITM.JTOT_OBJECT1_CODE||'' = 'OKX_BUSIPROC' ))
auzgm2ap4faw2	(SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND SUB.EVENT_FILTER_GUID = EVT.GUID AND EVT.NAME IN (:B1 , 'oracle.apps.wf.event.any') AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') UNION ALL (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENT_GROUPS EGRP, WF_EVENTS GRP, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND GRP.GUID = SUB.EVENT_FILTER_GUID AND GRP.TYPE = 'GROUP' AND GRP.STATUS = 'ENABLED' AND EGRP.GROUP_GUID = GRP.GUID AND EGRP.MEMBER_GUID = EVT.GUID AND EVT.NA ME = :B1 AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') ORDER BY 4
avc1jqzz04wpr	SELECT 'x' FROM DUAL
bf7uwg5pa3pj6	begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bp8crdjba8zgt	update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
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
csvvv0fmhr1yc	BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb	select parameter, value from nls_session_parameters
dcvv68fju01g4	begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvs	BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END;
fb13x9qx0ftks	begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23	SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwz	begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5	DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; 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 )

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	2,362,922	655.33	2.52
CPU used when call started	2,359,151	654.28	2.51
CR blocks created	14,290,600	3,963.34	15.23
Cached Commit SCN referenced	46,162	12.80	0.05
Commit SCN cached	8	0.00	0.00
DB time	6,960,777	1,930.49	7.42
DBWR checkpoint buffers written	2,886,350	800.50	3.08
DBWR checkpoints	37	0.01	0.00
DBWR object drop buffers written	27,304	7.57	0.03
DBWR revisited being-written buffer	13	0.00	0.00
DBWR thread checkpoint buffers written	1,012,168	280.71	1.08
DBWR transaction table writes	1,898	0.53	0.00
DBWR undo block writes	1,497,394	415.29	1.60
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	25,562,927	7,089.60	27.24
IMU Flushes	288,219	79.93	0.31
IMU Redo allocation size	1,917,917,372	531,913.22	2,043.80
IMU commits	490,711	136.09	0.52
IMU contention	32,604	9.04	0.03
IMU ktichg flush	7,992	2.22	0.01
IMU pool not allocated	1,107	0.31	0.00
IMU recursive-transaction flush	1,360	0.38	0.00
IMU undo allocation size	4,387,703,696	1,216,881.21	4,675.69
IMU- failed to get a private strand	1,107	0.31	0.00
PX local messages recv'd	67,293	18.66	0.07
PX local messages sent	67,293	18.66	0.07
Parallel operations downgraded 25 to 50 pct	40	0.01	0.00
Parallel operations not downgraded	8	0.00	0.00
SQL*Net roundtrips to/from client	35,457,546	9,833.76	37.78
active txn count during cleanout	88,041,280	24,417.28	93.82
application wait time	58,091	16.11	0.06
background checkpoints completed	6	0.00	0.00
background checkpoints started	5	0.00	0.00
background timeouts	11,453	3.18	0.01
branch node splits	1,029	0.29	0.00
buffer is not pinned count	692,410,482	192,032.41	737.86
buffer is pinned count	1,452,328,188	402,787.20	1,547.65
bytes received via SQL*Net from client	7,897,837,228	2,190,378.01	8,416.21
bytes sent via SQL*Net to client	7,410,474,664	2,055,213.38	7,896.86
calls to get snapshot scn: kcmgss	91,281,269	25,315.85	97.27
calls to kcmgas	17,894,255	4,962.77	19.07
calls to kcmgcs	14,443,185	4,005.66	15.39
change write time	63,046	17.49	0.07
cleanout - number of ktugct calls	27,376,261	7,592.50	29.17
cleanouts and rollbacks - consistent read gets	12,487,938	3,463.39	13.31
cleanouts only - consistent read gets	133,663	37.07	0.14
cluster key scan block gets	803,825	222.93	0.86
cluster key scans	227,258	63.03	0.24
commit batch/immediate performed	3,764	1.04	0.00
commit batch/immediate requested	3,764	1.04	0.00
commit cleanout failures: block lost	207,727	57.61	0.22
commit cleanout failures: buffer being written	3,808	1.06	0.00
commit cleanout failures: callback failure	103,937	28.83	0.11
commit cleanout failures: cannot pin	30,046	8.33	0.03
commit cleanouts	8,084,965	2,242.28	8.62
commit cleanouts successfully completed	7,739,447	2,146.45	8.25
commit immediate performed	3,764	1.04	0.00
commit immediate requested	3,764	1.04	0.00
commit txn count during cleanout	1,170,694	324.68	1.25
concurrency wait time	64,069	17.77	0.07
consistent changes	609,944,592	169,161.40	649.98
consistent gets	1,625,242,090	450,742.96	1,731.91
consistent gets - examination	1,075,179,586	298,189.19	1,145.75
consistent gets from cache	1,625,242,083	450,742.96	1,731.91
cursor authentications	1,822	0.51	0.00
data blocks consistent reads - undo records applied	606,892,059	168,314.82	646.73
db block changes	185,658,445	51,490.32	197.84
db block gets	213,363,938	59,174.13	227.37
db block gets direct	4,184	1.16	0.00
db block gets from cache	213,359,754	59,172.97	227.36
deferred (CURRENT) block cleanout applications	1,378,361	382.27	1.47
dirty buffers inspected	9,213	2.56	0.01
enqueue conversions	8,806	2.44	0.01
enqueue releases	3,571,263	990.45	3.81
enqueue requests	3,578,281	992.40	3.81
enqueue timeouts	6,897	1.91	0.01
enqueue waits	37,916	10.52	0.04
exchange deadlocks	47,547	13.19	0.05
execute count	81,465,418	22,593.53	86.81
failed probes on index block reclamation	11,814	3.28	0.01
free buffer inspected	2,448,303	679.01	2.61
free buffer requested	18,397,266	5,102.28	19.60
heap block compress	27,466,777	7,617.61	29.27
hot buffers moved to head of LRU	965,498	267.77	1.03
immediate (CR) block cleanout applications	12,621,619	3,500.47	13.45
immediate (CURRENT) block cleanout applications	1,048,894	290.90	1.12
index crx upgrade (found)	47,964	13.30	0.05
index crx upgrade (positioned)	8,016,352	2,223.25	8.54
index fast full scans (rowid ranges)	1,580	0.44	0.00
index fetch by key	193,407,514	53,639.44	206.10
index scans kdiixs1	128,076,714	35,520.66	136.48
java call heap collected bytes	1,224,462,832	339,591.26	1,304.83
java call heap collected count	15,238,947	4,226.35	16.24
java call heap gc count	4,158	1.15	0.00
java call heap live object count	1,452,991	402.97	1.55
java call heap live object count max	1,513,153	419.66	1.61
java call heap live size	357,201,568	99,065.91	380.65
java call heap live size max	368,954,072	102,325.34	393.17
java call heap object count	3,573,133	990.97	3.81
java call heap object count max	3,589,607	995.54	3.83
java call heap total size	462,422,016	128,247.64	492.77
java call heap total size max	477,102,080	132,319.00	508.42
java call heap used size	494,204,216	137,062.09	526.64
java call heap used size max	502,340,600	139,318.62	535.31
leaf node 90-10 splits	18,324	5.08	0.02
leaf node splits	230,141	63.83	0.25
lob reads	15,572	4.32	0.02
lob writes	27,701	7.68	0.03
lob writes unaligned	27,701	7.68	0.03
logons cumulative	7,677	2.13	0.01
messages received	1,089,818	302.25	1.16
messages sent	1,089,818	302.25	1.16
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	508,140,611	140,927.19	541.49
opened cursors cumulative	4,316,648	1,197.17	4.60
parse count (failures)	2,404	0.67	0.00
parse count (hard)	7,190	1.99	0.01
parse count (total)	6,805,891	1,887.54	7.25
parse time cpu	51,366	14.25	0.05
parse time elapsed	60,724	16.84	0.06
physical read IO requests	275,132	76.30	0.29
physical read bytes	3,690,135,552	1,023,418.38	3,932.34
physical read total IO requests	304,595	84.48	0.32
physical read total bytes	4,171,860,992	1,157,019.61	4,445.68
physical read total multi block requests	15,987	4.43	0.02
physical reads	450,456	124.93	0.48
physical reads cache	448,440	124.37	0.48
physical reads cache prefetch	175,144	48.57	0.19
physical reads direct	2,016	0.56	0.00
physical reads direct temporary tablespace	186	0.05	0.00
physical reads prefetch warmup	109,533	30.38	0.12
physical write IO requests	1,353,439	375.36	1.44
physical write bytes	24,058,437,632	6,672,342.21	25,637.50
physical write total IO requests	2,021,758	560.71	2.15
physical write total bytes	55,535,312,896	15,402,106.25	59,180.35
physical write total multi block requests	1,279,972	354.99	1.36
physical writes	2,936,821	814.49	3.13
physical writes direct	5,036	1.40	0.01
physical writes direct (lob)	230	0.06	0.00
physical writes direct temporary tablespace	4,061	1.13	0.00
physical writes from cache	2,931,785	813.10	3.12
physical writes non checkpoint	2,172,855	602.62	2.32
pinned buffers inspected	3,456	0.96	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	242,568	67.27	0.26
prefetched blocks aged out before use	118	0.03	0.00
process last non-idle time	3,605	1.00	0.00
queries parallelized	48	0.01	0.00
recursive calls	132,542,329	36,759.15	141.24
recursive cpu usage	1,365,254	378.64	1.45
redo blocks written	61,299,810	17,000.83	65.32
redo buffer allocation retries	33	0.01	0.00
redo entries	95,816,482	26,573.64	102.11
redo log space requests	49	0.01	0.00
redo log space wait time	84	0.02	0.00
redo ordering marks	1,171,877	325.01	1.25
redo size	30,096,070,076	8,346,812.95	32,071.41
redo subscn max counts	2,272,535	630.26	2.42
redo synch time	91,689	25.43	0.10
redo synch writes	1,640,240	454.90	1.75
redo wastage	262,793,048	72,882.75	280.04
redo write time	40,418	11.21	0.04
redo writer latching time	156	0.04	0.00
redo writes	646,465	179.29	0.69
rollback changes - undo records applied	339,074	94.04	0.36
rollbacks only - consistent read gets	1,953,207	541.70	2.08
rows fetched via callback	110,504,049	30,647.08	117.76
session connect time	0	0.00	0.00
session cursor cache hits	4,408,025	1,222.52	4.70
session logical reads	1,838,606,145	509,917.13	1,959.28
session pga memory	9,080,503,256	2,518,377.38	9,676.50
session pga memory max	11,293,634,232	3,132,164.84	12,034.89
session uga memory	###############	74,592,486.10	286,610.76
session uga memory max	54,313,471,184	15,063,241.93	57,878.31
shared hash latch upgrades - no wait	28,519,926	7,909.69	30.39
shared hash latch upgrades - wait	73,191	20.30	0.08
sorts (memory)	8,357,965	2,317.99	8.91
sorts (rows)	106,688,255	29,588.81	113.69
sql area evicted	1,999	0.55	0.00
sql area purged	2,573	0.71	0.00
summed dirty queue length	59,000	16.36	0.06
switch current to new buffer	1,226,022	340.02	1.31
table fetch by rowid	912,955,512	253,198.14	972.88
table fetch continued row	32,356,217	8,973.64	34.48
table scan blocks gotten	54,112,606	15,007.53	57.66
table scan rows gotten	1,569,769,824	435,358.34	1,672.80
table scans (long tables)	4,134	1.15	0.00
table scans (rowid ranges)	4,132	1.15	0.00
table scans (short tables)	4,302,180	1,193.16	4.58
total number of times SMON posted	110,967	30.78	0.12
transaction rollbacks	3,764	1.04	0.00
transaction tables consistent read rollbacks	84	0.02	0.00
transaction tables consistent reads - undo records applied	6,055	1.68	0.01
undo change vector size	10,480,410,984	2,906,626.34	11,168.29
user I/O wait time	388,036	107.62	0.41
user calls	33,844,642	9,386.44	36.07
user commits	760,720	210.98	0.81
user rollbacks	177,688	49.28	0.19
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	4,728,104	1,311.29	5.04
write clones created in background	1,410	0.39	0.00
write clones created in foreground	35,240	9.77	0.04

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	282,317	789,630
opened cursors current	734,273	855,745
workarea memory allocated	430	86
logons current	3,582	3,596

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)	3	3.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	95	0	4.53	1.00	561,544	156	288,961	0.04
APPS_TS_TX_DATA	172,101	48	13.10	1.36	191,616	53	151,629	0.35
APPS_ASSM_DATA	8,503	2	7.72	6.71	259,458	72	49,336	1.08
APPS_TS_TX_IDX	78,171	22	13.12	1.60	148,054	41	80,111	0.56
APPS_ASSM_IDX	6,218	2	8.08	1.05	135,957	38	265,794	0.16
APPS_TS_TX_INTERFACE	1,082	0	2.82	2.21	28,730	8	17,633	0.06
TEMP	279	0	6.74	15.36	8,872	2	491	821.04
SYSTEM	4,977	1	8.02	3.02	2,358	1	17,700	0.12
APPS_TS_SEED	2,154	1	15.10	2.08	4,808	1	733	6.23
APPS_TS_SUMMARY	144	0	1.11	1.00	4,537	1	2,546	0.03
APPS_TS_QUEUES	374	0	10.53	2.11	4,282	1	346	3.55
SYSAUX	364	0	7.64	1.19	1,397	0	0	0.00
APPS_TS_ARCHIVE	70	0	7.00	1.41	1,579	0	48	5.00
APPS_TS_NOLOGGING	51	0	6.47	1.24	72	0	2	0.00
CTXSYS	64	0	1.72	1.00	12	0	0	0.00
APPS_TS_MEDIA	36	0	2.78	1.00	18	0	0	0.00
ODM	32	0	1.25	1.00	6	0	0	0.00
OLAP	32	0	1.56	1.00	6	0	0	0.00
OWAPUB	32	0	0.94	1.00	6	0	0	0.00
PORTAL	32	0	0.94	1.00	6	0	0	0.00
SYNCSERVER	32	0	1.25	1.00	6	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_ASSM_DATA	/DB/visdata/apps_assm_data.dbf	8,503	2	7.72	6.71	259,458	72	49,336	1.08
APPS_ASSM_IDX	/DB/visdata/apps_assm_idx.dbf	6,218	2	8.08	1.05	135,957	38	265,794	0.16
APPS_TS_ARCHIVE	/DB/visdata/archive1.dbf	30	0	8.33	1.23	1,328	0	44	5.45
APPS_TS_ARCHIVE	/DB/visdata/archive2.dbf	40	0	6.00	1.55	251	0	4	0.00
APPS_TS_MEDIA	/DB/visdata/media1.dbf	12	0	4.17	1.00	6	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media2.dbf	12	0	2.50	1.00	6	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media3.dbf	12	0	1.67	1.00	6	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging1.dbf	12	0	2.50	1.00	6	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging2.dbf	23	0	10.43	1.00	49	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging3.dbf	16	0	3.75	1.75	17	0	2	0.00
APPS_TS_QUEUES	/DB/visdata/queues1.dbf	57	0	6.32	1.63	525	0	144	0.63
APPS_TS_QUEUES	/DB/visdata/queues2.dbf	29	0	7.24	2.38	747	0	159	0.44
APPS_TS_QUEUES	/DB/visdata/queues3.dbf	31	0	10.32	2.48	624	0	6	0.00
APPS_TS_QUEUES	/DB/visdata/queues4.dbf	42	0	7.14	2.29	555	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues5.dbf	31	0	9.35	3.52	566	0	3	0.00
APPS_TS_QUEUES	/DB/visdata/queues6.dbf	38	0	11.32	2.53	506	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues7.dbf	146	0	13.90	1.70	759	0	34	31.47
APPS_TS_SEED	/DB/visdata/reference1.dbf	205	0	15.02	2.58	489	0	45	8.89
APPS_TS_SEED	/DB/visdata/reference10.dbf	195	0	15.44	2.22	529	0	52	6.73
APPS_TS_SEED	/DB/visdata/reference2.dbf	202	0	15.89	1.84	497	0	29	5.52
APPS_TS_SEED	/DB/visdata/reference3.dbf	319	0	12.23	1.89	576	0	425	5.86
APPS_TS_SEED	/DB/visdata/reference4.dbf	213	0	14.74	2.25	442	0	39	5.13
APPS_TS_SEED	/DB/visdata/reference5.dbf	222	0	20.81	1.94	445	0	13	10.77
APPS_TS_SEED	/DB/visdata/reference6.dbf	223	0	12.06	2.40	480	0	31	11.61
APPS_TS_SEED	/DB/visdata/reference7.dbf	194	0	13.20	2.00	433	0	24	8.75
APPS_TS_SEED	/DB/visdata/reference8.dbf	195	0	20.10	2.03	476	0	43	3.95
APPS_TS_SEED	/DB/visdata/reference9.dbf	186	0	12.85	1.75	441	0	32	2.81
APPS_TS_SUMMARY	/DB/visdata/summary1.dbf	16	0	1.25	1.00	529	0	381	0.03
APPS_TS_SUMMARY	/DB/visdata/summary2.dbf	15	0	0.67	1.00	464	0	221	0.00
APPS_TS_SUMMARY	/DB/visdata/summary3.dbf	22	0	1.36	1.00	519	0	209	0.00
APPS_TS_SUMMARY	/DB/visdata/summary4.dbf	19	0	2.11	1.00	438	0	335	0.06
APPS_TS_SUMMARY	/DB/visdata/summary5.dbf	18	0	0.00	1.00	648	0	346	0.03
APPS_TS_SUMMARY	/DB/visdata/summary6.dbf	18	0	1.11	1.00	610	0	572	0.03
APPS_TS_SUMMARY	/DB/visdata/summary7.dbf	18	0	0.56	1.00	708	0	236	0.04
APPS_TS_SUMMARY	/DB/visdata/summary8.dbf	18	0	1.67	1.00	621	0	246	0.04
APPS_TS_TX_DATA	/DB/visdata/tx_data1.dbf	3,234	1	16.07	1.41	260	0	2	10.00
APPS_TS_TX_DATA	/DB/visdata/tx_data10.dbf	3,007	1	16.53	1.33	116	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data11.dbf	2,968	1	16.99	1.36	93	0	1	70.00
APPS_TS_TX_DATA	/DB/visdata/tx_data12.dbf	12,704	4	9.28	1.25	2,196	1	3,534	1.67
APPS_TS_TX_DATA	/DB/visdata/tx_data13.dbf	17,254	5	14.73	1.53	3,624	1	2,093	2.08
APPS_TS_TX_DATA	/DB/visdata/tx_data14.dbf	12,819	4	9.35	1.40	29,724	8	20,414	0.30
APPS_TS_TX_DATA	/DB/visdata/tx_data15.dbf	9,166	3	11.83	1.45	27,170	8	19,975	0.27
APPS_TS_TX_DATA	/DB/visdata/tx_data16.dbf	9,283	3	11.11	1.48	26,037	7	21,064	0.26
APPS_TS_TX_DATA	/DB/visdata/tx_data17.dbf	9,249	3	11.22	1.49	25,145	7	19,839	0.30
APPS_TS_TX_DATA	/DB/visdata/tx_data18.dbf	9,224	3	11.29	1.46	24,427	7	21,188	0.27
APPS_TS_TX_DATA	/DB/visdata/tx_data19.dbf	9,001	2	11.23	1.47	24,312	7	20,201	0.26
APPS_TS_TX_DATA	/DB/visdata/tx_data2.dbf	6,738	2	10.50	1.18	556	0	1,647	1.73
APPS_TS_TX_DATA	/DB/visdata/tx_data20.dbf	9,006	2	12.68	1.51	24,458	7	20,289	0.26
APPS_TS_TX_DATA	/DB/visdata/tx_data21.dbf	23,063	6	16.22	1.22	1,513	0	1,342	0.08
APPS_TS_TX_DATA	/DB/visdata/tx_data3.dbf	3,257	1	15.28	1.45	304	0	5	18.00
APPS_TS_TX_DATA	/DB/visdata/tx_data4.dbf	15,208	4	14.66	1.20	244	0	5	8.00
APPS_TS_TX_DATA	/DB/visdata/tx_data5.dbf	3,059	1	14.30	1.26	263	0	9	8.89
APPS_TS_TX_DATA	/DB/visdata/tx_data6.dbf	2,989	1	16.60	1.29	148	0	11	7.27
APPS_TS_TX_DATA	/DB/visdata/tx_data7.dbf	2,967	1	14.82	1.31	354	0	10	2.00
APPS_TS_TX_DATA	/DB/visdata/tx_data8.dbf	3,081	1	16.34	1.25	417	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data9.dbf	4,824	1	14.71	1.00	255	0	0	0.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx1.dbf	2,283	1	9.38	1.24	1,752	0	1,703	1.05
APPS_TS_TX_IDX	/DB/visdata/tx_idx10.dbf	2,222	1	9.49	1.28	1,147	0	1,539	0.78
APPS_TS_TX_IDX	/DB/visdata/tx_idx11.dbf	2,204	1	8.72	1.30	1,365	0	1,730	1.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx12.dbf	8,630	2	16.31	2.04	18,859	5	1,717	0.52
APPS_TS_TX_IDX	/DB/visdata/tx_idx13.dbf	7,871	2	10.38	1.44	21,477	6	5,093	0.56
APPS_TS_TX_IDX	/DB/visdata/tx_idx14.dbf	4,631	1	21.04	1.80	14,069	4	4,462	0.29
APPS_TS_TX_IDX	/DB/visdata/tx_idx15.dbf	4,463	1	13.83	1.72	11,927	3	5,594	0.80
APPS_TS_TX_IDX	/DB/visdata/tx_idx16.dbf	4,508	1	15.14	1.77	10,765	3	5,430	0.28
APPS_TS_TX_IDX	/DB/visdata/tx_idx17.dbf	4,463	1	12.71	1.71	10,390	3	6,187	0.31
APPS_TS_TX_IDX	/DB/visdata/tx_idx18.dbf	4,441	1	14.54	1.76	10,156	3	8,575	0.25
APPS_TS_TX_IDX	/DB/visdata/tx_idx19.dbf	4,507	1	18.08	1.80	9,613	3	6,423	0.32
APPS_TS_TX_IDX	/DB/visdata/tx_idx2.dbf	2,707	1	12.34	1.58	1,341	0	2,936	0.55
APPS_TS_TX_IDX	/DB/visdata/tx_idx20.dbf	4,344	1	13.94	1.75	8,557	2	4,307	0.26
APPS_TS_TX_IDX	/DB/visdata/tx_idx21.dbf	2,730	1	17.61	1.95	11,498	3	2,080	1.04
APPS_TS_TX_IDX	/DB/visdata/tx_idx3.dbf	3,804	1	8.21	1.21	1,464	0	2,257	1.84
APPS_TS_TX_IDX	/DB/visdata/tx_idx4.dbf	2,454	1	9.95	1.26	2,586	1	2,301	1.40
APPS_TS_TX_IDX	/DB/visdata/tx_idx5.dbf	2,472	1	8.85	1.28	4,118	1	10,412	0.29
APPS_TS_TX_IDX	/DB/visdata/tx_idx6.dbf	2,445	1	8.85	1.27	2,194	1	2,017	1.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx7.dbf	2,369	1	9.60	1.27	2,075	1	1,615	1.07
APPS_TS_TX_IDX	/DB/visdata/tx_idx8.dbf	2,345	1	9.82	1.32	1,391	0	1,910	0.91
APPS_TS_TX_IDX	/DB/visdata/tx_idx9.dbf	2,278	1	10.77	1.35	1,310	0	1,823	0.99
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte.dbf	95	0	5.05	2.58	4,430	1	6,280	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte2.dbf	229	0	3.32	2.40	5,664	2	3,901	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte3.dbf	231	0	2.81	2.07	4,912	1	2,945	0.10
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte4.dbf	131	0	2.98	2.60	4,632	1	1,653	0.07
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte5.dbf	152	0	3.42	2.28	4,495	1	1,568	0.09
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte6.dbf	244	0	1.02	1.77	4,597	1	1,286	0.08
APPS_UNDOTS1	/DB/visdata/undo01.dbf	7	0	1.43	1.00	54,215	15	30,650	0.05
APPS_UNDOTS1	/DB/visdata/undo02.dbf	7	0	1.43	1.00	61,722	17	29,919	0.04
APPS_UNDOTS1	/DB/visdata/undo03.dbf	7	0	2.86	1.00	55,603	15	35,448	0.03
APPS_UNDOTS1	/DB/visdata/undo04.dbf	11	0	4.55	1.00	54,247	15	28,108	0.04
APPS_UNDOTS1	/DB/visdata/undo05.dbf	9	0	13.33	1.00	55,796	15	25,865	0.04
APPS_UNDOTS1	/DB/visdata/undo06.dbf	7	0	1.43	1.00	56,816	16	24,710	0.05
APPS_UNDOTS1	/DB/visdata/undo07.dbf	14	0	2.86	1.00	54,187	15	28,030	0.04
APPS_UNDOTS1	/DB/visdata/undo08.dbf	10	0	10.00	1.00	59,084	16	35,551	0.04
APPS_UNDOTS1	/DB/visdata/undo09.dbf	9	0	3.33	1.00	56,573	16	25,608	0.04
APPS_UNDOTS1	/DB/visdata/undo10.dbf	14	0	2.86	1.00	53,301	15	25,072	0.04
CTXSYS	/DB/visdata/ctx1.dbf	32	0	2.50	1.00	6	0	0	0.00
CTXSYS	/DB/visdata/ctx2.dbf	32	0	0.94	1.00	6	0	0	0.00
ODM	/DB/visdata/odm.dbf	32	0	1.25	1.00	6	0	0	0.00
OLAP	/DB/visdata/olap.dbf	32	0	1.56	1.00	6	0	0	0.00
OWAPUB	/DB/visdata/owa1.dbf	32	0	0.94	1.00	6	0	0	0.00
PORTAL	/DB/visdata/portal.dbf	32	0	0.94	1.00	6	0	0	0.00
SYNCSERVER	/DB/visdata/mobile01.dbf	32	0	1.25	1.00	6	0	0	0.00
SYSAUX	/DB/visdata/sysaux01.dbf	41	0	9.51	1.46	641	0	0	0.00
SYSAUX	/DB/visdata/sysaux02.dbf	323	0	7.40	1.16	756	0	0	0.00
SYSTEM	/DB/visdata/sys1.dbf	503	0	7.44	2.44	107	0	69	0.14
SYSTEM	/DB/visdata/sys2.dbf	569	0	6.89	2.21	176	0	106	0.09
SYSTEM	/DB/visdata/sys3.dbf	658	0	6.31	3.27	217	0	23	2.61
SYSTEM	/DB/visdata/sys4.dbf	563	0	7.16	3.98	225	0	8	8.75
SYSTEM	/DB/visdata/sys5.dbf	814	0	8.46	2.90	657	0	117	0.85
SYSTEM	/DB/visdata/sys6.dbf	501	0	10.40	3.99	74	0	7	2.86
SYSTEM	/DB/visdata/sys7.dbf	388	0	9.56	4.08	144	0	27	0.37
SYSTEM	/DB/visdata/sys8.dbf	373	0	11.82	2.82	397	0	17,307	0.11
SYSTEM	/DB/visdata/sys9.dbf	608	0	6.32	1.94	361	0	36	2.22
TEMP	/DB/visdata/temp1.dbf	55	0	6.91	4.27	2,484	1	179	792.68
TEMP	/DB/visdata/temp2.dbf	74	0	5.14	39.68	2,242	1	128	871.41
TEMP	/DB/visdata/temp3.dbf	62	0	6.94	16.56	1,822	1	89	905.39
TEMP	/DB/visdata/temp4.dbf	88	0	7.84	1.00	2,324	1	95	727.58

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	2,238,249	100	1,819,816,769	448,367	2,931,785	0	0	875,411

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	89	33776	784403	2962467	35156250	2962467
E	180	116	51725	1167566	8685947	35156250	8685947

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - 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	431,644	5

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	20,480	1,280	30,518.91	0.55	0.00	100.00	0.00	1,048,576
E	20,480	1,280	37,741.86	2.44	0.01	100.00	0.00	1,048,576

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	4,287,412	4,287,412	0	0
64K	128K	11,502	11,502	0	0
128K	256K	1,335	1,335	0	0
256K	512K	822	822	0	0
512K	1024K	133,421	133,421	0	0
1M	2M	290,294	290,294	0	0
2M	4M	72	70	2	0
4M	8M	21	21	0	0
8M	16M	18	18	0	0
32M	64M	8	8	0	0
64M	128M	6	6	0	0
128M	256M	2	2	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
2,560	0.13	581,013.85	8,453.28	99.00	1,046
5,120	0.25	581,013.85	8,334.94	99.00	1,004
10,240	0.50	581,013.85	8,147.51	99.00	949
15,360	0.75	581,013.85	7,977.86	99.00	899
20,480	1.00	581,013.85	0.00	100.00	829
24,576	1.20	581,013.85	0.00	100.00	553
28,672	1.40	581,013.85	0.00	100.00	0
32,768	1.60	581,013.85	0.00	100.00	0
36,864	1.80	581,013.85	0.00	100.00	0
40,960	2.00	581,013.85	0.00	100.00	0
61,440	3.00	581,013.85	0.00	100.00	0
81,920	4.00	581,013.85	0.00	100.00	0
122,880	6.00	581,013.85	0.00	100.00	0
163,840	8.00	581,013.85	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
1,568	0.69	288	12,969	3,321,100	1.00	9,103	7.48	140,435,296
1,808	0.79	496	16,055	3,327,203	1.00	3,000	2.47	140,712,100
2,048	0.90	734	19,540	3,328,861	1.00	1,342	1.10	140,789,037
2,288	1.00	971	25,126	3,328,986	1.00	1,217	1.00	140,795,311
2,528	1.10	1,064	29,839	3,328,986	1.00	1,217	1.00	140,795,371
2,768	1.21	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
3,008	1.31	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
3,248	1.42	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
3,488	1.52	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
3,728	1.63	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
3,968	1.73	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
4,208	1.84	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
4,448	1.94	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376
4,688	2.05	1,071	30,623	3,328,986	1.00	1,217	1.00	140,795,376

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,120	0.25	36,376
10,240	0.50	36,376
15,360	0.75	36,381
20,480	1.00	36,375
25,600	1.25	36,390
30,720	1.50	36,390
35,840	1.75	36,390
40,960	2.00	36,391

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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.25	7	185	1,430	1.00	1,217	1.00	17,651
32	0.50	7	185	1,430	1.00	1,217	1.00	17,651
48	0.75	7	185	1,430	1.00	1,217	1.00	17,651
64	1.00	7	185	1,430	1.00	1,217	1.00	17,651
80	1.25	7	185	1,430	1.00	1,217	1.00	17,651
96	1.50	7	185	1,430	1.00	1,217	1.00	17,651
112	1.75	7	185	1,430	1.00	1,217	1.00	17,651
128	2.00	7	185	1,430	1.00	1,217	1.00	17,651

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)
file header block	479	403	842
data block	577,277	200	0
undo block	231,509	9	0
undo header	57,445	3	0
1st level bmb	5,507	1	0
segment header	2,135	1	0
2nd level bmb	933	0	0
bitmap index block	12	0	1
extent map	7	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)
RO-Multiple Object Reuse (fast object reuse)	288	288	0	32	395	12,334.38
UL-User-defined	65,945	64,946	999	1,930	128	66.29
TX-Transaction (row lock contention)	5,624	382	5,242	369	51	138.05
TX-Transaction (index contention)	28,625	28,624	0	27,154	30	1.09
HW-Segment High Water Mark	200,825	200,818	7	2,483	11	4.51
TM-DML	1,613,218	1,613,121	9	6	9	1,450.00
DV-Diana Versioning	21,678	21,678	0	170	2	9.53
TX-Transaction	1,081,302	1,081,262	0	1,867	2	0.83
SQ-Sequence Cache	36,235	36,235	0	3,087	1	0.33
TX-Transaction (allocate ITL entry)	186	186	0	137	1	3.72
FB-Format Block	35,427	35,427	0	646	0	0.36
PS-PX Process Reservation	3,727	3,087	640	33	0	0.00
CU-Cursor	6,945	6,946	0	1	0	0.00
US-Undo Segment	7,457	7,457	0	1	0	0.00

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,509.05	1,081,800	2,685	267		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
15-Feb 10:43	197,031	140,485	645	258	211	0/0	0/0/0/0/0/0
15-Feb 10:33	56,375	97,710	483	255	217	0/0	0/0/0/0/0/0
15-Feb 10:23	385,604	151,452	2,667	267	201	0/0	0/0/0/0/0/0
15-Feb 10:13	347,854	210,496	2,685	264	246	0/0	0/0/0/0/0/0
15-Feb 10:03	197,312	182,898	2,564	265	332	0/0	0/0/0/0/0/0
15-Feb 09:53	324,869	298,759	2,181	265	410	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Back to Top

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,465	0.00		0	0
AWR Alerted Metric Element list	234,961	0.00		0	0
Consistent RBA	646,684	0.02	0.40	0	0
FOB s.o list latch	43,904	0.02	0.00	0	0
In memory undo latch	564,442,966	2.09	0.00	3	962,109	0.00
JOX SGA heap latch	1,855,976	0.00		0	0
JS queue state obj latch	21,630	0.00		0	0
JS slv state obj latch	177	0.00		0	0
KMG MMAN ready and startup request latch	2,760	0.00		0	0
KMG resize request state object freelist	18	0.00		0	0
KTF sga latch	12	0.00		0	1,214	0.00
KWQMN job cache list latch	11,713	0.52	0.95	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1,716	0.00		0	2,751	0.00
OS process	11,400	0.00		0	0
OS process allocation	8,815	0.00		0	0
OS process: request allocation	7,310	0.00		0	0
PL/SQL warning settings	3,454,033	0.00		0	0
SGA IO buffer pool latch	63,569	0.00		0	122,480	0.00
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	5,127,160	0.01	0.01	0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	442,594	0.00	0.00	0	2	0.00
active service list	40,320	0.26	0.00	0	1,236	0.00
begin backup scn array	152	0.00		0	0
buffer pool	18	0.00		0	0
cache buffer handles	21,410,394	1.59	0.00	0	0
cache buffers chains	4,246,659,281	1.25	0.03	66	16,443,534	2.86
cache buffers lru chain	9,195,757	0.46	0.03	2	32,317,618	0.77
cache table scan latch	1,911	0.00		0	1,911	0.05
channel handle pool latch	282,650	0.07	0.03	0	0
channel operations parent latch	1,257,231	0.50	0.00	0	0
checkpoint queue latch	18,780,576	0.01	0.00	0	2,964,470	0.03
client/application info	1,261,661	0.00	0.00	0	0
commit callback allocation	60,214	0.00		0	0
compile environment latch	2,143,609	0.00		0	0
dictionary lookup	78	0.00		0	0
dml lock allocation	3,213,999	0.32	0.01	0	0
dummy allocation	15,372	1.10	0.02	0	0
enqueue hash chains	7,204,279	0.17	0.00	0	960	0.10
enqueues	3,826,794	0.22	0.01	0	0
error message lists	1,584	3.79	0.00	0	0
event group latch	3,662	0.00		0	0
file cache latch	19,915	0.00		0	0
global KZLD latch for mem in SGA	6,787	0.00		0	0
global ctx hash table latch	16,338	0.00		0	0
hash table column usage latch	1,743	0.11	0.00	0	10,848,702	0.00
hash table modification latch	148	0.00		0	0
internal temp table object number allocation latc	3	0.00		0	0
job workq parent latch	0			0	122	0.00
job_queue_processes parameter latch	121	0.00		0	0
kks stats	23,550	0.00	0.00	0	0
ksuosstats global area	242	0.00		0	0
ktm global data	110,967	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	650,028	0.10	0.06	0	0
library cache	260,451,754	0.55	0.01	10	18,287	162.07
library cache load lock	8,772	0.62	0.00	0	15	0.00
library cache lock	41,234,024	0.08	0.01	0	0
library cache lock allocation	1,089,515	0.01	0.01	0	0
library cache pin	162,704,105	0.22	0.01	2	32	0.00
library cache pin allocation	388,236	0.00	0.09	0	0
list of block allocation	418,386	0.03	0.00	0	0
loader state object freelist	219,158	0.00	0.00	0	0
longop free list parent	35	0.00		0	35	0.00
message pool operations parent latch	286,670	0.03	0.03	0	0
messages	3,307,282	0.06	0.04	0	0
mostly latch-free SCN	715,098	6.64	0.07	2	0
multiblock read objects	35,093	0.01	0.00	0	0
ncodef allocation latch	76	0.00		0	0
object queue header heap	3,829,290	0.03	0.39	0	293,080	0.07
object queue header operation	29,915,512	0.14	0.38	2	17,642	0.27
object stats modification	280,886	0.03	0.04	0	0
parallel query alloc buffer	23,520	3.73	0.00	0	0
parallel query stats	912	23.46	0.05	0	0
parameter table allocation management	17,198	1.91	0.55	0	0
post/wait queue	917,829	0.08	0.00	0	379,972	0.02
process allocation	7,358	0.07	1.00	0	3,662	0.00
process group creation	7,310	0.00		0	0
process queue	15,146	1.26	0.00	0	0
process queue reference	1,326,491	0.03	0.00	0	100,226	0.72
qmn task queue latch	516	0.00		0	0
query server freelists	13,488	18.43	0.00	0	0
query server process	16	0.00		0	16	0.00
redo allocation	4,473,387	4.82	0.01	1	95,553,815	2.72
redo copy	0			0	95,816,027	0.04
redo writing	2,792,860	0.03	0.61	0	0
resmgr group change latch	579,590	0.00		0	0
resmgr:actses active list	22,131	0.14	1.00	0	0
resmgr:actses change group	21,137	0.00		0	0
resmgr:free threads list	15,370	1.14	0.01	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	88,978,719	0.27	0.00	1	7,169	0.13
rules engine aggregate statistics	29,487	0.03	0.00	0	0
rules engine rule set statistics	96,069	0.02	0.00	0	0
rules engine rule statistics	37,097	0.00		0	0
sequence cache	15,665,857	0.99	0.00	0	0
session allocation	15,106,859	0.68	0.02	1	0
session idle bit	69,816,840	0.03	0.03	0	0
session state list latch	42,473	0.21	0.04	0	0
session switching	10,200	0.00		0	0
session timer	1,236	0.00		0	0
shared pool	6,067,736	0.20	0.03	0	0
shared pool sim alloc	329	0.00		0	0
shared pool simulator	1,825,744	0.00	0.06	0	0
sim partition latch	1	0.00		0	24,328	0.07
simulator hash latch	2,460	0.00		0	0
simulator lru latch	1,242	0.00		0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	974,249	0.11	0.01	0	0
state object free list	12	0.00		0	0
statistics aggregation	84	0.00		0	0
temp lob duration state obj allocation	216	0.00		0	0
temporary table state object allocation	8,795	0.00		0	0
threshold alerts latch	606	0.00		0	0
trace latch	31	0.00		0	0
transaction allocation	80,899	0.00	0.00	0	0
transaction branch allocation	76	0.00		0	0
undo global data	751,740,391	1.77	0.00	4	12,848	0.10
user lock	27,242	0.00	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	4,246,659,281	52,913,333	1,477,865	51,536,876	0	0	0
undo global data	751,740,391	13,324,442	7,391	13,317,946	0	0	0
In memory undo latch	564,442,966	11,783,338	16,038	11,769,577	0	0	0
library cache	260,451,754	1,419,920	11,435	1,409,494	0	0	0
library cache pin	162,704,105	364,816	3,464	361,610	0	0	0
cache buffer handles	21,410,394	339,454	223	339,252	0	0	0
row cache objects	88,978,719	243,504	1,191	242,350	0	0	0
redo allocation	4,473,387	215,830	2,497	213,717	0	0	0
sequence cache	15,665,857	155,792	157	155,652	0	0	0
session allocation	15,106,859	102,740	1,716	101,241	0	0	0
mostly latch-free SCN	715,098	47,482	3,394	44,419	0	0	0
object queue header operation	29,915,512	42,485	16,060	27,168	0	0	0
cache buffers lru chain	9,195,757	42,058	1,405	40,704	0	0	0
library cache lock	41,234,024	33,487	188	33,304	0	0	0
session idle bit	69,816,840	20,277	538	19,755	0	0	0
enqueue hash chains	7,204,279	12,466	23	12,443	0	0	0
shared pool	6,067,736	12,268	428	11,868	0	0	0
dml lock allocation	3,213,999	10,360	77	10,290	0	0	0
enqueues	3,826,794	8,455	71	8,386	0	0	0
channel operations parent latch	1,257,231	6,263	29	6,237	0	0	0
query server freelists	13,488	2,486	2	2,484	0	0	0
checkpoint queue latch	18,780,576	2,199	8	2,191	0	0	0
messages	3,307,282	2,142	86	2,060	0	0	0
sort extent pool	974,249	1,070	8	1,064	0	0	0
object queue header heap	3,829,290	993	383	623	0	0	0
redo writing	2,792,860	741	451	291	0	0	0
post/wait queue	917,829	716	2	714	0	0	0
lgwr LWN SCN	650,028	654	42	614	0	0	0
process queue reference	1,326,491	436	1	435	0	0	0
SQL memory manager workarea list latch	5,127,160	401	3	398	0	0	0
parameter table allocation management	17,198	328	180	173	0	0	0
parallel query stats	912	214	10	204	0	0	0
channel handle pool latch	282,650	185	5	180	0	0	0
resmgr:free threads list	15,370	175	2	174	0	0	0
dummy allocation	15,372	169	3	166	0	0	0
Consistent RBA	646,684	121	48	82	0	0	0
message pool operations parent latch	286,670	91	3	88	0	0	0
session state list latch	42,473	89	4	85	0	0	0
library cache lock allocation	1,089,515	77	1	76	0	0	0
object stats modification	280,886	74	3	71	0	0	0
KWQMN job cache list latch	11,713	61	58	3	0	0	0
resmgr:actses active list	22,131	32	32	0	0	0	0
shared pool simulator	1,825,744	31	2	29	0	0	0
library cache pin allocation	388,236	11	1	10	0	0	0
process allocation	7,358	5	5	0	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	ktiFlush: child	0	5,961	3,790
In memory undo latch	kturbk	0	5,527	7,735
In memory undo latch	kticmt: child	0	3,293	733
In memory undo latch	ktichg: child	0	990	3,713
In memory undo latch	ktiTxnPoolFree	0	236	0
In memory undo latch	ktiBRacquire	0	21	0
In memory undo latch	ktbgfc	0	6	69
KWQMN job cache list latch	kwqmnuji: update job item	0	60	5
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	2	0
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	1	3
cache buffer handles	kcbzgs	0	145	137
cache buffer handles	kcbzfs	0	78	86
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	1,401,575	1,697,258
cache buffers chains	kcbgtcr: fast path	0	625,477	44,322
cache buffers chains	kcbchg: kslbegin: call CR func	0	474,197	999,374
cache buffers chains	kcbgtcr: kslbegin excl	0	304,833	226,062
cache buffers chains	kcbrls: kslbegin	0	182,840	273,155
cache buffers chains	kcbzgb: scan from tail. nowait	0	165,443	0
cache buffers chains	kcbgcur: kslbegin	0	47,775	23,698
cache buffers chains	kcbget: pin buffer	0	28,607	10,848
cache buffers chains	kcbget: exchange	0	10,088	14,109
cache buffers chains	kcbget: exchange rls	0	9,888	10,703
cache buffers chains	kcbzwb	0	9,574	7,651
cache buffers chains	kcbcge	0	2,879	6,808
cache buffers chains	kcbnlc	0	1,579	1,741
cache buffers chains	kcbso1: set no access	0	343	114
cache buffers chains	kcbgtcr: kslbegin shared	0	123	101
cache buffers chains	kcbesc: escalate	0	111	52
cache buffers chains	kcb_is_private	0	108	1,553
cache buffers chains	kcbnew: new latch again	0	43	4
cache buffers chains	kcbbxsv	0	30	14
cache buffers chains	kcbbic2	0	12	6
cache buffers chains	kcb_pre_apply: kcbhq61	0	10	1,154
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	0	7	0
cache buffers chains	kcb_post_apply: kcbhq62	0	5	256
cache buffers chains	kcbgtcr	0	2	0
cache buffers chains	kcbw_next_free	0	2	0
cache buffers chains	kcb_post_apply: kcbhq63	0	1	184
cache buffers chains	kcbo_ivd_process	0	1	7
cache buffers lru chain	kcbzgws	0	738	0
cache buffers lru chain	kcbo_link_q	0	346	22
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	130	0
cache buffers lru chain	kcbzgb: posted for free bufs	0	91	340
cache buffers lru chain	kcbbxsv: move to being written	0	41	447
cache buffers lru chain	kcbzswcu	0	24	57
cache buffers lru chain	kcbo_ivd_proc	0	12	182
cache buffers lru chain	kcbbic2	0	6	349
cache buffers lru chain	kcbzgm	0	5	0
cache buffers lru chain	kcbzar: KSLNBEGIN	0	4	0
cache buffers lru chain	kcbw_activate_granule	0	2	0
cache buffers lru chain	kcbzib	0	2	3
cache buffers lru chain	kcbrlb	0	1	2
cache buffers lru chain	kcbw_make_free_nowait	0	1	0
cache buffers lru chain	kcbzfw	0	1	0
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	0	1	30
channel handle pool latch	ksrchconnect()	0	25	23
channel handle pool latch	ksrchdelete()	0	1	4
channel operations parent latch	ksrapublish()	0	20	5
channel operations parent latch	ksrchconnect()	0	7	8
channel operations parent latch	ksrchdelete()	0	7	11
channel operations parent latch	ksrmfree()	0	6	6
channel operations parent latch	ksrsconsume()	0	5	2
channel operations parent latch	ksrwait()	0	3	21
checkpoint queue latch	kcbswcu: Switch buffers	0	4	3
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	3	4
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	1	0
dml lock allocation	ktaiam	0	51	51
dml lock allocation	ktaidm	0	26	26
dummy allocation	ktcscnfy	0	3	3
enqueue hash chains	ksqgtl3	0	12	13
enqueue hash chains	ksqrcl	0	11	10
enqueues	ksqgel: create enqueue	0	30	13
enqueues	ksqies	0	23	47
enqueues	ksqdel	0	18	11
lgwr LWN SCN	kcs023	0	804	0
library cache	kglpndl: child: after processing	0	4,488	303
library cache	kglpnp: child	0	4,143	5,547
library cache	kglobpn: child:	0	1,136	1,641
library cache	kglpndl: child: before processing	0	673	3,168
library cache	kglLockCursor	0	257	364
library cache	kglScanDependency	0	146	0
library cache	kgldte: child 0	0	108	154
library cache	kglpin	0	105	44
library cache	kglhdgn: child:	0	82	151
library cache	kgldti: 2child	0	27	6
library cache	kglhdiv0: child	0	24	0
library cache	kglic	0	17	0
library cache	kglhdiv0: parent: invalidate	0	12	9
library cache	kglupd: child	0	5	0
library cache	kglhdgc: child:	0	4	0
library cache	kglrtl	0	3	0
library cache	kgldtld: 2child	0	2	1
library cache	kglget: unpin heap 0	0	2	4
library cache	kglivl: child	0	2	0
library cache	kglobld	0	2	0
library cache	kglhdiv: child	0	1	19
library cache	kglukp: child	0	1	1
library cache lock	kgllkdl: child: cleanup	0	113	124
library cache lock	kgllkal: child: multiinstance	0	74	64
library cache lock	kgllkdl: child: no lock handle	0	71	14
library cache lock	kglhdbrnl: child	0	1	0
library cache lock allocation	kgllkget	0	1	1
library cache pin	kglpndl	0	1,604	1,149
library cache pin	kglpnp: child	0	1,577	1,784
library cache pin	kglpnal: child: alloc space	0	283	531
library cache pin allocation	kglpnget	0	1	1
message pool operations parent latch	ksrmfree()	0	2	0
message pool operations parent latch	ksrmalloc()	0	1	3
messages	ksaamb: after wakeup	0	46	73
messages	ksarcv	0	23	11
messages	ksarcv: after wait	0	17	2
mostly latch-free SCN	kcslcu3	0	2,591	3,435
mostly latch-free SCN	kcs024	0	40	0
mostly latch-free SCN	kcs01	0	29	48
mostly latch-free SCN	kcsnew_scn_rba	0	19	0
object queue header heap	kcbo_link_q:reget	0	377	3
object queue header heap	kcbw_link_q:alloc	0	5	380
object queue header heap	kcbw_unlink_q	0	1	0
object queue header operation	kcbo_ivbo	0	16,727	2,271
object queue header operation	kcbw_link_q	0	3,420	1,427
object queue header operation	kcbw_unlink_q	0	725	4,040
object queue header operation	kcbo_switch_mq_bg	0	207	2,157
object queue header operation	kcbo_switch_q_bg	0	151	1,488
object queue header operation	kcbo_switch_cq	0	130	2,509
object queue header operation	kcbo_link_q:reget	0	67	86
object queue header operation	kcbo_swap_buf	0	12	507
object queue header operation	kcbo_service_ockpt	0	11	0
object queue header operation	kcbo_swap_buf_bg	0	9	7,573
object queue header operation	kcbo_write_q	0	8	0
object queue header operation	kcbw_unlink_q_bg	0	1	15
object stats modification	ksoslinelm	0	3	2
parallel query stats	kxfprst: KSLBEGIN:1	0	10	10
parameter table allocation management	ksp_param_table_free	0	180	180
post/wait queue	ksliwat:remove	0	2	1
process allocation	ksucrp	0	4	0
process allocation	ksudlp	0	1	4
process queue reference	kxfpqrsnd	0	1	0
query server freelists	kxfpobrmf	0	2	2
redo allocation	kcrfw_redo_gen: redo allocation 1	0	1,340	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	533	2,318
redo allocation	kcrfw_redo_write: before write	0	253	99
redo allocation	kcrfw_redo_write: more space	0	230	95
redo allocation	kcrfw_redo_gen: redo allocation 2	0	141	0
redo writing	kcrfw_post: after write	0	346	0
redo writing	kcrfw_post: rba scn pair	0	91	0
redo writing	kcrfw_cal_target_rba	0	14	0
resmgr:actses active list	kgskchclass	0	32	11
resmgr:free threads list	kgskthrsod	0	2	2
row cache objects	kqreqd: reget	0	966	3
row cache objects	kqrpre: find obj	0	162	817
row cache objects	kqreqd	0	59	369
row cache objects	kqrso	0	4	3
sequence cache	kdnssd	0	114	12
sequence cache	kdnnxt: cached seq	0	29	2
sequence cache	kdnss	0	14	143
session allocation	ksuxds: KSUSFCLC not set	0	714	324
session allocation	ksursi	0	186	395
session allocation	ksuprc	0	184	210
session allocation	ksucri	0	143	217
session allocation	ksuxds: not user session	0	130	100
session allocation	ksudlc	0	124	282
session allocation	kxfprdp	0	115	49
session allocation	kxfpqidqr	0	96	135
session allocation	ksudlp	0	14	1
session allocation	kspallmod	0	9	0
session allocation	ksusin	0	1	2
session idle bit	ksupuc: set busy	0	501	200
session idle bit	ksupuc: clear busy	0	211	502
session idle bit	ksuxds	0	27	37
session state list latch	kpseqd	0	4	0
shared pool	kghalo	0	205	111
shared pool	kghupr1	0	166	272
shared pool	kghfrunp: clatch: nowait	0	119	0
shared pool	kghfre	0	26	35
shared pool	kghfrunp: alloc: wait	0	25	1
shared pool	kghalp	0	5	8
shared pool	kghfrunp: clatch: wait	0	5	9
shared pool	kghasp	0	1	1
shared pool simulator	kglsim_unpin_simhp	0	2	2
sort extent pool	ktstdt: dealloc sort extent	0	4	3
sort extent pool	ktstdt: return extent	0	3	0
sort extent pool	ktstsmonmsg	0	1	8
undo global data	kturimugur: child	0	5,920	4,604
undo global data	ktudba: KSLBEGIN	0	1,383	2,763
undo global data	ktucof: at start	0	23	0
undo global data	ktudnx:child	0	21	10
undo global data	ktufrbs: child	0	14	11
undo global data	ktusmasp: ktugd_tuux	0	11	0
undo global data	ktumof: KSLBEGIN	0	10	0
undo global data	ktubnd:child	0	8	3

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,838,606,145
• Captured Segments account for 36.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	64,618,528	3.51
APPLSYS	APPS_TS_SEED	WF_EVENTS_U1		INDEX	54,094,112	2.94
APPLSYS	APPS_TS_SEED	WF_EVENTS		TABLE	53,912,160	2.93
APPLSYS	APPS_TS_SEED	WF_EVENT_SUBSCRIPTIONS		TABLE	45,809,296	2.49
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	24,209,744	1.32

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 450,456
• Captured Segments account for 17.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	35,079	7.79
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	12,976	2.88
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	9,554	2.12
HR	APPS_TS_TX_IDX	PAY_PERSON_LATEST_BALA_N50		INDEX	4,777	1.06
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS		TABLE	4,052	0.90

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	13,646	29.36
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	10,598	22.81
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS		TABLE	10,244	22.04
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	4,001	8.61
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	1,729	3.72

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
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	36	33.96
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	19	17.92
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N3		INDEX	13	12.26
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N1		INDEX	10	9.43
GL	APPS_ASSM_IDX	GL_JE_LINES_U1		INDEX	6	5.66

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
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	185,229	37.63
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	96,837	19.67
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	31,650	6.43
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	17,302	3.51
AR	APPS_ASSM_DATA	RA_CUST_TRX_LINE_GL_DIST_ALL		TABLE	16,757	3.40

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	5	20.00	0		2	1
dc_constraints	648	47.07	0		648	97
dc_files	6,660	0.00	0		0	111
dc_global_oids	5,257,226	0.00	0		0	49
dc_histogram_data	3,849	14.84	0		0	510
dc_histogram_defs	310,855	3.21	0		4,042	3,266
dc_object_grants	48,952	0.07	0		0	119
dc_object_ids	8,835,348	0.02	0		57	1,176
dc_objects	129,262	1.11	0		345	1,054
dc_profiles	6,848	0.00	0		0	1
dc_rollback_segments	18,958	0.02	0		12	269
dc_segments	267,855	0.67	0		14,760	1,494
dc_sequences	45,355	0.12	0		45,355	121
dc_table_scns	16,430	0.05	0		0	5
dc_tablespace_quotas	14,607	0.16	0		216	49
dc_tablespaces	4,377,884	0.00	0		0	21
dc_usernames	353,200	0.00	0		0	23
dc_users	10,333,038	0.00	0		0	68
outstanding_alerts	268	0.75	0		1	43

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	448,700	0.03	31,019,790	-0.03	4	0
CLUSTER	76	0.00	182	1.10	2	0
INDEX	10,617	0.60	11,430	0.81	0	0
JAVA DATA	616	0.00	0		0	0
PIPE	34,548	2.51	50,924	1.65	0	0
SQL AREA	5,370	92.64	88,285,128	0.42	2,479	335
TABLE/PROCEDURE	290,102	0.33	42,952,692	-0.04	829	0
TRIGGER	20,539	0.12	1,241,214	0.00	25	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	24,283.30		11.34	6.54	37	37	2,142	2,142
	SQL	2,279.06	1,166.36	1.07	0.67	4	21	2,136	2,135
	Freeable	2,222.31	0.00	1.20	0.75	9		1,856	1,856
	PL/SQL	1,559.87	132.04	0.73	0.93	3	3	2,142	2,142
	JAVA	178.10	177.39	2.23	0.36	5	8	80	80
E	Other	30,070.31		13.95	8.40	57	57	2,156	2,156
	Freeable	2,920.81	0.00	1.52	0.94	9		1,918	1,918
	SQL	2,725.77	1,427.20	1.27	0.75	5	21	2,150	2,149
	PL/SQL	1,848.06	149.28	0.86	0.97	3	3	2,156	2,156
	JAVA	178.01	177.28	2.23	0.36	5	8	80	80

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	19,126,026,240	18,975,031,296
Fixed Size	2,111,120
Redo Buffers	14,663,680
Variable Size	2,332,035,440	2,483,030,384

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	51.29	51.29	0.00
java	joxlod exec hp	12.09	12.09	0.00
large	PX msg pool	0.49	0.49	0.00
large	free memory	15.51	15.51	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	35.42	36.10	1.92
shared	KGLS heap	33.50		-100.00
shared	KTI-UNDO	44.33	44.33	0.00
shared	PCursor	22.17		-100.00
shared	PL/SQL MPCODE	66.83	70.42	5.36
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	event statistics per sess	52.73	52.73	0.00
shared	free memory	334.51	349.50	4.48
shared	library cache	571.58	697.39	22.01
shared	parameter table block	39.35	39.51	0.39
shared	private strands	83.14	83.14	0.00
shared	sessions	30.35	30.35	0.00
shared	sql area	356.91	377.46	5.76
shared	trace buffer	33.50	33.98	1.45
	buffer_cache	18,240.00	18,096.00	-0.79
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.98	13.98	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

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)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_b_tree_bitmap_plans	FALSE
_fast_full_scan_enabled	FALSE
_like_with_bind_as_equality	TRUE
_sort_elimination_cost_ratio	5
_sqlexec_progression_cost	2147483647
_swrf_mmon_dbfus	FALSE
_swrf_mmon_flush	FALSE
_system_trig_enabled	TRUE
aq_tm_processes	1
background_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/bdump
compatible	10.2.0.3
control_files	/DB/visdata/cntrl01.dbf, /DB/visdata/cntrl02.dbf, /DB/visdata/cntrl03.dbf
core_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/cdump
cursor_sharing	exact
cursor_space_for_time	FALSE
db_block_checking	false
db_block_checksum	TRUE
db_block_size	8192
db_cache_advice	off
db_files	130
db_name	VIS
db_writer_processes	1
dml_locks	10000
fast_start_mttr_target	180
java_pool_size	67108864
job_queue_processes	2
lock_sga	FALSE
log_buffer	14219264
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	1000
optimizer_secure_view_merging	FALSE
parallel_max_servers	16
pga_aggregate_target	21474836480
plsql_code_type	INTERPRETED
plsql_native_library_dir	/DB/oracle/product/10.2.0/db_1/native
plsql_native_library_subdir_count	300
plsql_optimize_level	2
processes	3000
remote_login_passwordfile	EXCLUSIVE
replication_dependency_tracking	FALSE
session_cached_cursors	500
sessions	6000
sga_target	21474836480
shared_pool_reserved_size	209715200
shared_pool_size	2097152000
timed_statistics	TRUE
trace_enabled	FALSE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
user_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/udump
utl_file_dir	/usr/tmp
workarea_size_policy	AUTO

Back to Top

End of Report