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.zko.hp

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1	16-Aug-08 08:20:22	5268	209.0
End Snap:	2	16-Aug-08 09:20:27	5301	233.4
Elapsed:		60.09 (mins)
DB Time:		471.50 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	17,728M	17,568M	Std Block Size:	8K
Shared Pool Size:	2,624M	2,784M	Log Buffer:	14,320K

Load Profile

	Per Second	Per Transaction
Redo size:	8,972,969.68	25,877.02
Logical reads:	570,734.26	1,645.93
Block changes:	55,917.93	161.26
Physical reads:	126.75	0.37
Physical writes:	905.73	2.61
User calls:	13,795.52	39.78
Parses:	2,563.57	7.39
Hard parses:	2.61	0.01
Sorts:	3,060.08	8.82
Logons:	2.83	0.01
Executes:	29,119.77	83.98
Transactions:	346.75

% Blocks changed per Read:	9.80	Recursive Call %:	77.33
Rollback per transaction %:	21.22	Rows per Sort:	12.30

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.97	Soft Parse %:	99.90
Execute to Parse %:	91.20	Latch Hit %:	98.45
Parse CPU to Parse Elapsd %:	90.96	% Non-Parse CPU:	97.53

Shared Pool Statistics

	Begin	End
Memory Usage %:	85.64	86.19
% SQL with executions>1:	88.29	89.57
% Memory for SQL w/exec>1:	63.98	66.52

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		26,070		92.2
db file sequential read	286,977	1,215	4	4.3	User I/O
log file sync	539,230	810	2	2.9	Commit
log file parallel write	895,680	461	1	1.6	System I/O
db file parallel write	207,377	162	1	.6	System I/O

Main Report

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

Back to Top

Wait Events Statistics

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

Back to Top

Time Model Statistics

• Total time in database user-calls (DB Time): 28290.3s
• 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
DB CPU	26,069.99	92.15
sql execute elapsed time	24,071.53	85.09
inbound PL/SQL rpc elapsed time	5,832.09	20.62
PL/SQL execution elapsed time	5,657.19	20.00
parse time elapsed	788.08	2.79
Java execution elapsed time	501.42	1.77
hard parse elapsed time	394.57	1.39
repeated bind elapsed time	102.16	0.36
sequence load elapsed time	18.90	0.07
connection management call elapsed time	15.06	0.05
PL/SQL compilation elapsed time	8.19	0.03
hard parse (sharing criteria) elapsed time	3.79	0.01
failed parse elapsed time	2.16	0.01
hard parse (bind mismatch) elapsed time	1.22	0.00
DB time	28,290.28
background elapsed time	1,272.19
background cpu time	530.76

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	340,355	0.00	1,371	4	0.27
Commit	539,230	0.00	810	2	0.43
System I/O	1,133,960	0.00	635	1	0.91
Application	70,314	0.08	215	3	0.06
Network	56,728,488	0.00	200	0	45.37
Concurrency	3,698,630	0.12	189	0	2.96
Other	169,938	35.13	38	0	0.14
Configuration	8,424	0.00	5	1	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	286,977	0.00	1,215	4	0.23
log file sync	539,230	0.00	810	2	0.43
log file parallel write	895,680	0.00	461	1	0.72
db file parallel write	207,377	0.00	162	1	0.17
enq: TX - row lock contention	449	10.69	158	351	0.00
SQL*Net more data from client	2,570,939	0.00	109	0	2.06
db file scattered read	13,054	0.00	83	6	0.01
read by other session	37,258	0.00	70	2	0.03
SQL*Net message to client	52,112,545	0.00	61	0	41.68
cursor: pin S wait on X	4,792	93.20	49	10	0.00
latch: cache buffers chains	2,522,388	0.00	47	0	2.02
buffer busy waits	1,066,984	0.00	40	0	0.85
enq: UL - contention	2,324	0.30	35	15	0.00
SQL*Net more data to client	2,045,004	0.00	30	0	1.64
latch: In memory undo latch	48,188	0.00	17	0	0.04
library cache load lock	858	0.00	14	16	0.00
enq: TX - index contention	33,579	0.00	14	0	0.03
enq: RO - fast object reuse	34	0.00	12	344	0.00
SQL*Net break/reset to client	67,506	0.00	11	0	0.05
PX Deq Credit: send blkd	21,721	0.00	10	0	0.02
control file sequential read	29,164	0.00	9	0	0.02
rdbms ipc reply	5	60.00	7	1462	0.00
kksfbc child completion	154	77.27	6	39	0.00
latch: library cache	8,848	0.00	3	0	0.01
os thread startup	70	0.00	3	42	0.00
local write wait	1,854	0.00	3	1	0.00
log buffer space	475	0.00	3	6	0.00
wait list latch free	235	0.00	3	11	0.00
PX Deq: Signal ACK	197	38.07	2	11	0.00
latch: object queue header operation	32,885	0.00	2	0	0.03
enq: HW - contention	3,295	0.00	2	1	0.00
LGWR wait for redo copy	37,378	0.00	1	0	0.03
control file parallel write	1,739	0.00	1	1	0.00
row cache lock	4,156	0.00	1	0	0.00
enq: TX - contention	3,197	0.00	1	0	0.00
latch free	1,733	0.00	1	1	0.00
latch: library cache pin	2,554	0.00	1	0	0.00
buffer exterminate	1	100.00	1	977	0.00
enq: DV - contention	220	0.00	1	4	0.00
enq: SQ - contention	4,422	0.00	1	0	0.00
latch: undo global data	2,413	0.00	1	0	0.00
latch: row cache objects	2,045	0.00	0	0	0.00
library cache pin	2,600	0.00	0	0	0.00
buffer deadlock	60,017	98.71	0	0	0.05
latch: session allocation	1,694	0.00	0	0	0.00
direct path read	732	0.00	0	0	0.00
SGA: allocation forcing component growth	29	51.72	0	10	0.00
latch: redo allocation	1,198	0.00	0	0	0.00
latch: cache buffers lru chain	1,484	0.00	0	0	0.00
enq: FB - contention	906	0.00	0	0	0.00
enq: TM - contention	1	0.00	0	146	0.00
latch: shared pool	740	0.00	0	0	0.00
enq: TX - allocate ITL entry	198	0.00	0	1	0.00
latch: library cache lock	242	0.00	0	0	0.00
cursor: pin S	3,568	0.00	0	0	0.00
latch: object queue header heap	244	0.00	0	0	0.00
L1 validation	5	60.00	0	7	0.00
PX qref latch	300	79.67	0	0	0.00
library cache lock	4	0.00	0	7	0.00
latch: enqueue hash chains	21	0.00	0	1	0.00
latch: cache buffer handles	125	0.00	0	0	0.00
latch: messages	103	0.00	0	0	0.00
reliable message	38	0.00	0	0	0.00
latch: redo writing	28	0.00	0	0	0.00
cursor: pin X	2	50.00	0	6	0.00
enq: CU - contention	3	0.00	0	3	0.00
cursor: mutex S	188	0.00	0	0	0.00
direct path write	436	0.00	0	0	0.00
latch: checkpoint queue latch	30	0.00	0	0	0.00
write complete waits	6	0.00	0	0	0.00
cursor: mutex X	394	0.00	0	0	0.00
enq: PS - contention	32	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
SQL*Net message from client	52,112,500	0.00	10,158,985	195	41.68
pipe get	29,576	14.77	21,090	713	0.02
Streams AQ: qmn slave idle wait	129	0.00	3,525	27326	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,525	13663	0.00
Streams AQ: waiting for time management or cleanup tasks	2,943	40.16	3,504	1191	0.00
PX Idle Wait	1,644	76.40	2,570	1563	0.00
PL/SQL lock timer	224	100.00	2,518	11243	0.00
jobq slave wait	612	99.84	1,792	2929	0.00
PX Deq: Execution Msg	5,282	0.00	35	7	0.00
PX Deq: Execute Reply	2,708	0.00	4	1	0.00
PX Deq Credit: need buffer	5,314	0.00	1	0	0.00
PX Deq: Msg Fragment	4,459	0.00	1	0	0.00
PX Deq: Table Q Normal	6,007	0.00	0	0	0.00
PX Deq: Parse Reply	279	0.00	0	1	0.00
PX Deq: Join ACK	229	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	895,670	0.00	461	1	0.72
db file parallel write	207,377	0.00	162	1	0.17
control file sequential read	827	0.00	3	4	0.00
os thread startup	62	0.00	3	41	0.00
events in waitclass Other	48,636	0.00	2	0	0.04
db file scattered read	471	0.00	2	4	0.00
control file parallel write	1,739	0.00	1	1	0.00
db file sequential read	271	0.00	1	3	0.00
direct path read	732	0.00	0	0	0.00
latch: cache buffers chains	133	0.00	0	0	0.00
latch: redo writing	28	0.00	0	0	0.00
direct path write	333	0.00	0	0	0.00
log file sync	1	0.00	0	1	0.00
latch: shared pool	4	0.00	0	0	0.00
latch: library cache	2	0.00	0	0	0.00
buffer busy waits	8	0.00	0	0	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
rdbms ipc message	1,559,099	0.79	37,136	24	1.25
Streams AQ: qmn slave idle wait	129	0.00	3,525	27326	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,525	13663	0.00
pmon timer	1,274	95.60	3,512	2756	0.00
Streams AQ: waiting for time management or cleanup tasks	2,943	40.16	3,504	1191	0.00
smon timer	176,702	0.00	3,495	20	0.14

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,870,339
IDLE_TIME	5,697,891
IOWAIT_TIME	97,646
NICE_TIME	0
SYS_TIME	177,265
USER_TIME	2,590,652
LOAD	7
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	47,076,192
NUM_CPUS	24
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	28,292.40	26,072.50	441,850	2,054,233,943
SYS$BACKGROUND	0.00	0.00	15,292	3,728,005
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	338540	136771	3698443	18678	0	0	56713388	19993
SYS$BACKGROUND	1809	290	210	258	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
802	801	304	2.64	2.84	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
612	596	16	38.28	2.17	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
612	578	112,814	0.01	2.16	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
528	494	202,493	0.00	1.87	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
494	491	1,443	0.34	1.75	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
472	471	376,000	0.00	1.67	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
445	441	57,147	0.01	1.57	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
429	425	56,820	0.01	1.52	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
424	422	64,006	0.01	1.50	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
388	386	57,101	0.01	1.37	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
373	344	266,225	0.00	1.32	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
326	319	81,013	0.00	1.15	3prk3vg9u0abb	FNDOAMCOL	BEGIN FND_GLOBAL.APPS_INITIA...
285	142	2,409	0.12	1.01	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
285	192	21,633	0.01	1.01	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...

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
801	802	304	2.64	2.84	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
596	612	16	37.25	2.17	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
578	612	112,814	0.01	2.16	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
494	528	202,493	0.00	1.87	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
491	494	1,443	0.34	1.75	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
471	472	376,000	0.00	1.67	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
441	445	57,147	0.01	1.57	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
425	429	56,820	0.01	1.52	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
422	424	64,006	0.01	1.50	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
386	388	57,101	0.01	1.37	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
344	373	266,225	0.00	1.32	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
319	326	81,013	0.00	1.15	3prk3vg9u0abb	FNDOAMCOL	BEGIN FND_GLOBAL.APPS_INITIA...
192	285	21,633	0.01	1.01	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
142	285	2,409	0.06	1.01	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....

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: 2,057,823,471
• Captured SQL account for 12.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
99,906,049	16	6,244,128.06	4.85	596.01	612.50	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
76,155,269	202,493	376.09	3.70	493.68	528.04	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
73,966,832	266,225	277.84	3.59	344.38	372.94	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
46,831,486	57,147	819.49	2.28	440.58	445.49	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
44,353,490	304	145,899.64	2.16	801.16	802.30	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
42,841,193	157,186	272.55	2.08	156.12	156.56	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
41,776,566	1,443	28,951.19	2.03	491.16	494.48	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,852,978	57,101	715.45	1.99	385.53	388.02	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
38,830,535	64,006	606.67	1.89	422.29	424.35	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
31,585,987	1,581,000	19.98	1.53	163.33	163.85	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
30,226,386	56,820	531.97	1.47	425.36	428.89	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
27,984,807	173,973	160.86	1.36	203.90	206.46	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
27,623,576	173,295	159.40	1.34	191.44	193.92	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
26,390,231	9,998	2,639.55	1.28	121.16	224.19	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 457,024
• Captured SQL account for 30.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,227	9,998	4.52	9.90	121.16	224.19	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
39,769	2,409	16.51	8.70	141.80	285.22	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
36,098	2,409	14.98	7.90	19.45	187.02	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
24,194	21,633	1.12	5.29	192.45	284.83	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
13,284	266,225	0.05	2.91	344.38	372.94	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
10,690	721	14.83	2.34	107.30	150.12	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,361	7,213	1.30	2.05	149.22	190.43	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
9,329	202,493	0.05	2.04	493.68	528.04	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,598	9,974	0.46	1.01	168.31	181.26	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
4,514	9,994	0.45	0.99	138.84	149.44	63t8zpm02skgh	PYUSLV	SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 104,993,440
• Captured SQL account for 7.6% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
1,581,000	817,875	0.52	0.00	0.00	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
895,346	895,318	1.00	0.00	0.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
597,125	597,105	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
376,000	375,990	1.00	0.00	0.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
344,216	262,733	0.76	0.00	0.00	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
291,153	4,949,139	17.00	0.00	0.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
266,225	0	0.00	0.00	0.00	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
202,493	202,486	1.00	0.00	0.00	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
173,973	173,935	1.00	0.00	0.00	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
173,805	173,764	1.00	0.00	0.00	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 9,243,122
• Captured SQL account for 42.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
597,096	597,125	6.46	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
376,000	376,000	4.07	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
344,221	344,216	3.72	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
291,126	291,153	3.15	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
202,482	202,493	2.19	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
169,880	173,805	1.84	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
124,256	125,202	1.34	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
120,403	120,423	1.30	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
115,409	116,422	1.25	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
111,327	111,405	1.20	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
101,211	101,323	1.09	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
95,279	101,325	1.03	dcvv68fju01g4	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.E...
95,266	95,320	1.03	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
95,201	95,318	1.03	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,213,974	2,885	0.04	9hypmc3t618sc	OEXOETEL	SELECT ORDERED_ITEM, ORDERED_Q...

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
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 ) )
3prk3vg9u0abb	BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6	SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
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;
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74	BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); 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;
9hypmc3t618sc	SELECT ORDERED_ITEM, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2, PREFERRED_GRADE, LINE_NUMBER, COMPONENT_NUMBER, REQUEST_DATE, SCHEDULE_SHIP_DATE, LINE_TYPE, CANCELLED_QUANTITY, SHIPPED_QUANTITY, PROMISE_DATE, PRICING_QUANTITY, PRICING_QUANTITY_UOM, SHIP_FROM, SOLD_TO, CUSTOMER_NUMBER, CUST_PO_NUMBER, CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER, DEMAND_BUCKET_TYPE_CODE, RLA_SCHEDULE_TYPE_CODE, CUSTOMER_DOCK_CODE, CUST_MODEL_SERIAL_NUMBER, CUSTOMER_PRODUCTION_LINE, CUST_PRODUCTION_SEQ_NUM, CUSTOMER_JOB, END_ITEM_UNIT_NUMBER, TAX_CODE, BLANKET_NUMBER, BLANKET_LINE_NUMBER, BLANKET_VERSION_NUMBER, PRICE_LIST, PRICING_DATE, SHIPMENT_NUMBER, TERMS, UNIT_LIST_PRICE, ORIGINAL_LIST_PRICE, ITEM_TYPE_CODE, OPTION_NUMBER, VISIBLE_DEMAND_FLAG, SCHEDULE_ARRIVAL_DATE, PLANNING_PRIORITY, ORIGINAL_ORDERED_ITEM, ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID, item_relationship_type, LATE_DEMAND_PENALTY_FACTOR, ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE, OVERRIDE_ATP_DATE_CODE, FIRM_DEMAND_FLAG, ITEM_IDENTIFIER_TYPE, UNIT_SELLING_PRICE, UNIT_COST, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, CALCULATE_PRICE_FLAG, TAX_EXEMPT_NUMBER, TAX_DATE, TAX_VALUE, TAX_POINT_CODE, ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, INVOICING_RULE, SUBINVENTORY, FULFILLED_QUANTITY, INVOICED_QUANTITY, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, USER_ITEM_DESCRIPTION, SHIP_FROM_LOCATION, SHIP_TO, SHIP_TO_LOCATION, SHIP_TO_CONTACT, SHIP_TO_ADDRESS1, SHI P_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_ADDRESS5, SHIPPING_QUANTITY_UOM, SHIPPING_QUANTITY, DELIVERY_LEAD_TIME, INVOICE_TO, INVOICE_TO_LOCATION, INVOICE_TO_CONTACT, INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4, INVOICE_TO_ADDRESS5, ITEM_REVISION, ROUNDING_FACTOR, SPLIT_BY, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, ORDER_NUMBER, VERSION_NUMBER, ORDER_TYPE, ORDERED_DATE, OVER_SHIP_REASON, first_ack_code, FIRST_ACK_DATE, last_ack_code, LAST_ACK_DATE, SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS, SERVICE_COTERMINATE_FLAG, SERVICE_DURATION, SERVICE_PERIOD, SERVICE_START_DATE, SERVICE_END_DATE, UNIT_SELLING_PERCENT, SERVICE_NUMBER, SERVICE_REFERENCE_TYPE_CODE, UNIT_LIST_PERCENT, UNIT_PERCENT_BASE_PRICE, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_CONTACT_ID, END_CUSTOMER_ID, IB_OWNER, IB_INSTALLED_AT_LOCATION, IB_CURRENT_LOCATION, EARLIEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE, ACTUAL_SHIPMENT_DATE, OVER_SHIP_RESOLVED_FLAG, ACTUAL_ARRIVAL_DATE, DEP_PLAN_REQUIRED_FLAG, AUTHORIZED_TO_SHIP_FLAG, COMMITMENT_ID, LOCK_CONTROL, ORDER_SOURCE_ID, TAX_EXEMPT_REASON_CODE, FULFILLED_FLAG, FULFILLMENT_METHOD_CODE, TAX_EXEMPT_FLAG, TAX_RATE, FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE, FOB_POINT_CODE, INVOICE_INTERFACE_STATUS_CODE, SHIP_MODEL_COMPLETE_FLAG, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID, ROW_ID, HEADER_ROW_ID, REFERENCE_HEADER_ID, REFERENCE_LINE_ID, REFERENCE_CUSTOMER_TRX_LINE_ID, CREDIT_INVOICE_LINE_ID, LINE_ID, ORG_ID, HEADER_ID, LINE_TYPE_ID, LINE_SET_ID, CONFIG_HEADER_ID, CONFIG_REV_NBR, SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, SOLD_FROM_ORG_ID, SHIP_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID, INTMED_SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID, INVENTORY_ITEM_ID, SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID, PRICE_LIST_ID, AGREEMENT_ID, PAYMENT_TERM_ID, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, SPLIT_FROM_LINE_ID, VEH_CUS_ITEM_CUM_KEY_ID, SALESREP_ID, RETURN_REASON_CODE, ARRIVAL_SET_ID, SHIP_SET_ID, ORDERED_ITEM_ID, OVER_SHIP_REASON_CODE, CONTEXT, SCHEDULE_STATUS_CODE, FLOW_STATUS_CODE, SOURCE_TYPE_CODE, DEMAND_CLASS_CODE, TRANSACTION_PHASE_CODE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, INDUSTRY_CONTEXT, INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTR IBUTE4, INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15, INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE30, RETURN_CONTEXT, RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15, TP_CONTEXT, TP_ATTRIBUTE1, TP_ATTRIBUTE2, TP_ATTRIBUTE3, TP_ATTRIBUTE4, TP_ATTRIBUTE5, TP_ATTRIBUTE6, TP_ATTRIBUTE7, TP_ATTRIBUTE8, TP_ATTRIBUTE9, TP_ATTRIBUTE10, TP_ATTRIBUTE11, TP_ATTRIBUTE12, TP_ATTRIBUTE13, TP_ATTRIBUTE14, TP_ATTRIBUTE15, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, COMPONENT_SEQUENCE_ID, CONFIGURATION_ID, TOP_MODEL_LINE_ID, LINK_TO_LINE_ID, CONFIG_DISPLAY_SEQUENCE, COMPONENT_CODE, SORT_ORDER, SOLD_TO_ORG_ID, FREIGHT_CARRIER_CODE, PROJECT_ID, TASK_ID, LINE_CATEGORY_CODE, MODEL_REMNANT_FL AG, CUSTOMER_TRX_LINE_ID, OPTION_FLAG, BOOKED_FLAG, OPEN_FLAG, CANCELLED_FLAG, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, SHIPPING_INTERFACED_FLAG, ATO_LINE_ID, AUTO_SELECTED_QUANTITY, EXPLOSION_DATE, MODEL_GROUP_NUMBER FROM OE_ORDER_LINES_V WHERE (HEADER_ID=:1) order by line_number, shipment_number, nvl(option_number, -1), nvl(component_number, -1), nvl(service_number, -1)
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;
avc1jqzz04wpr	SELECT 'x' FROM DUAL
bf7uwg5pa3pj6	begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
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;

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,596,908	720.25	2.08
CPU used when call started	2,590,774	718.55	2.07
CR blocks created	16,828,138	4,667.26	13.46
Cached Commit SCN referenced	48,138	13.35	0.04
Commit SCN cached	8	0.00	0.00
DB time	5,577,812	1,547.00	4.46
DBWR checkpoint buffers written	3,177,636	881.31	2.54
DBWR checkpoints	34	0.01	0.00
DBWR object drop buffers written	54,745	15.18	0.04
DBWR revisited being-written buffer	278	0.08	0.00
DBWR thread checkpoint buffers written	439,856	121.99	0.35
DBWR transaction table writes	2,741	0.76	0.00
DBWR undo block writes	1,628,683	451.71	1.30
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	42,934,818	11,907.91	34.34
IMU Flushes	367,146	101.83	0.29
IMU Redo allocation size	2,413,995,392	669,518.01	1,930.81
IMU commits	639,451	177.35	0.51
IMU contention	47,048	13.05	0.04
IMU ktichg flush	11,455	3.18	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1,756	0.49	0.00
IMU undo allocation size	5,766,829,344	1,599,421.49	4,612.55
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	53,258	14.77	0.04
PX local messages sent	53,258	14.77	0.04
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	52,094,933	14,448.45	41.67
active txn count during cleanout	129,763,784	35,989.79	103.79
application wait time	21,537	5.97	0.02
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,886	3.85	0.01
branch node splits	1,069	0.30	0.00
buffer is not pinned count	623,480,812	172,921.47	498.69
buffer is pinned count	1,611,223,966	446,870.56	1,288.72
bytes received via SQL*Net from client	11,407,648,542	3,163,894.26	9,124.31
bytes sent via SQL*Net to client	10,341,738,403	2,868,265.67	8,271.75
calls to get snapshot scn: kcmgss	117,577,198	32,609.86	94.04
calls to kcmgas	20,953,537	5,811.43	16.76
calls to kcmgcs	15,999,347	4,437.39	12.80
change write time	67,117	18.61	0.05
cleanout - number of ktugct calls	31,190,633	8,650.68	24.95
cleanouts and rollbacks - consistent read gets	14,667,284	4,067.95	11.73
cleanouts only - consistent read gets	165,004	45.76	0.13
cluster key scan block gets	873,491	242.26	0.70
cluster key scans	238,986	66.28	0.19
commit batch/immediate performed	4,862	1.35	0.00
commit batch/immediate requested	4,862	1.35	0.00
commit cleanout failures: block lost	260,459	72.24	0.21
commit cleanout failures: buffer being written	3,766	1.04	0.00
commit cleanout failures: callback failure	112,582	31.22	0.09
commit cleanout failures: cannot pin	36,673	10.17	0.03
commit cleanouts	9,683,651	2,685.75	7.75
commit cleanouts successfully completed	9,270,171	2,571.07	7.41
commit immediate performed	4,862	1.35	0.00
commit immediate requested	4,862	1.35	0.00
commit txn count during cleanout	1,424,695	395.14	1.14
concurrency wait time	18,934	5.25	0.02
consistent changes	729,501,579	202,326.17	583.49
consistent gets	1,827,270,805	506,790.82	1,461.53
consistent gets - examination	1,253,422,486	347,634.85	1,002.54
consistent gets from cache	1,827,270,332	506,790.69	1,461.53
cursor authentications	2,119	0.59	0.00
data blocks consistent reads - undo records applied	725,060,081	201,094.33	579.93
db block changes	201,616,106	55,917.93	161.26
db block gets	230,548,442	63,942.27	184.40
db block gets direct	4,341	1.20	0.00
db block gets from cache	230,544,104	63,941.06	184.40
deferred (CURRENT) block cleanout applications	1,662,681	461.14	1.33
dirty buffers inspected	10,515	2.92	0.01
doubling up with imu segment	0	0.00	0.00
enqueue conversions	10,429	2.89	0.01
enqueue releases	4,697,621	1,302.88	3.76
enqueue requests	4,704,879	1,304.89	3.76
enqueue timeouts	7,145	1.98	0.01
enqueue waits	41,901	11.62	0.03
exchange deadlocks	60,025	16.65	0.05
execute count	104,993,440	29,119.77	83.98
failed probes on index block reclamation	8,037	2.23	0.01
frame signature mismatch	2	0.00	0.00
free buffer inspected	3,294,412	913.70	2.64
free buffer requested	21,399,537	5,935.13	17.12
heap block compress	28,635,614	7,942.04	22.90
hot buffers moved to head of LRU	1,372,306	380.61	1.10
immediate (CR) block cleanout applications	14,832,306	4,113.72	11.86
immediate (CURRENT) block cleanout applications	1,155,120	320.37	0.92
index crx upgrade (found)	149,329	41.42	0.12
index crx upgrade (positioned)	10,540,373	2,923.36	8.43
index fast full scans (rowid ranges)	824	0.23	0.00
index fetch by key	191,268,110	53,047.92	152.98
index scans kdiixs1	163,078,949	45,229.70	130.44
java call heap collected bytes	1,548,662,120	429,519.12	1,238.68
java call heap collected count	19,044,297	5,281.91	15.23
java call heap gc count	4,838	1.34	0.00
java call heap live object count	1,590,320	441.07	1.27
java call heap live object count max	1,595,344	442.47	1.28
java call heap live size	462,248,992	128,204.07	369.73
java call heap live size max	463,290,936	128,493.05	370.56
java call heap object count	3,929,752	1,089.91	3.14
java call heap object count max	3,936,446	1,091.77	3.15
java call heap total size	619,053,056	171,693.44	495.14
java call heap total size max	620,104,704	171,985.11	495.99
java call heap used size	613,070,952	170,034.31	490.36
java call heap used size max	614,302,680	170,375.93	491.34
leaf node 90-10 splits	20,606	5.72	0.02
leaf node splits	249,207	69.12	0.20
lob reads	23,724	6.58	0.02
lob writes	41,270	11.45	0.03
lob writes unaligned	41,270	11.45	0.03
logons cumulative	10,192	2.83	0.01
messages received	1,863,237	516.77	1.49
messages sent	1,863,237	516.77	1.49
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	522,574,659	144,935.30	417.98
opened cursors cumulative	6,015,614	1,668.42	4.81
parse count (failures)	3,604	1.00	0.00
parse count (hard)	9,396	2.61	0.01
parse count (total)	9,243,122	2,563.57	7.39
parse time cpu	64,439	17.87	0.05
parse time elapsed	70,840	19.65	0.06
physical read IO requests	300,746	83.41	0.24
physical read bytes	3,743,948,800	1,038,378.60	2,994.56
physical read total IO requests	330,020	91.53	0.26
physical read total bytes	4,222,672,896	1,171,152.01	3,377.47
physical read total multi block requests	13,034	3.61	0.01
physical reads	457,024	126.75	0.37
physical reads cache	456,106	126.50	0.36
physical reads cache prefetch	156,099	43.29	0.12
physical reads direct	918	0.25	0.00
physical reads direct temporary tablespace	186	0.05	0.00
physical reads prefetch warmup	86,863	24.09	0.07
physical write IO requests	2,083,904	577.97	1.67
physical write bytes	26,752,385,024	7,419,733.96	21,397.66
physical write total IO requests	3,492,936	968.76	2.79
physical write total bytes	60,660,584,960	16,824,122.49	48,518.84
physical write total multi block requests	1,586,282	439.95	1.27
physical writes	3,265,672	905.73	2.61
physical writes direct	4,860	1.35	0.00
physical writes direct (lob)	226	0.06	0.00
physical writes direct temporary tablespace	4,225	1.17	0.00
physical writes from cache	3,260,812	904.38	2.61
physical writes non checkpoint	2,386,743	661.96	1.91
pinned buffers inspected	3,212	0.89	0.00
prefetch warmup blocks aged out before use	250,654	69.52	0.20
prefetched blocks aged out before use	121	0.03	0.00
process last non-idle time	3,607	1.00	0.00
queries parallelized	48	0.01	0.00
recursive aborts on index block reclamation	1	0.00	0.00
recursive calls	169,703,452	47,067.00	135.74
recursive cpu usage	1,462,282	405.56	1.17
redo blocks written	66,059,858	18,321.60	52.84
redo buffer allocation retries	482	0.13	0.00
redo entries	103,670,387	28,752.83	82.92
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,220,560	338.52	0.98
redo size	32,352,688,232	8,972,969.68	25,877.02
redo subscn max counts	2,427,931	673.38	1.94
redo synch time	83,685	23.21	0.07
redo synch writes	2,430,027	673.96	1.94
redo wastage	364,176,136	101,003.71	291.28
redo write time	51,906	14.40	0.04
redo writer latching time	153	0.04	0.00
redo writes	895,471	248.36	0.72
rollback changes - undo records applied	252,092	69.92	0.20
rollbacks only - consistent read gets	2,406,721	667.50	1.92
rows fetched via callback	101,674,318	28,199.22	81.32
session connect time	0	0.00	0.00
session cursor cache hits	5,775,393	1,601.80	4.62
session logical reads	2,057,823,471	570,734.26	1,645.93
session pga memory	10,737,139,224	2,977,929.50	8,588.01
session pga memory max	12,053,395,672	3,342,991.26	9,640.80
session uga memory	###############	75,197,719.09	216,861.61
session uga memory max	74,834,750,408	20,755,306.07	59,855.92
shared hash latch upgrades - no wait	33,104,259	9,181.42	26.48
shared hash latch upgrades - wait	245,539	68.10	0.20
sorts (memory)	11,033,348	3,060.08	8.82
sorts (rows)	135,688,498	37,633.00	108.53
sql area evicted	2,896	0.80	0.00
sql area purged	3,774	1.05	0.00
summed dirty queue length	96,034	26.63	0.08
switch current to new buffer	1,415,351	392.55	1.13
table fetch by rowid	950,236,162	263,546.58	760.04
table fetch continued row	32,931,182	9,133.41	26.34
table scan blocks gotten	74,689,717	20,715.08	59.74
table scan rows gotten	2,310,542,629	640,825.54	1,848.07
table scans (long tables)	2,050	0.57	0.00
table scans (rowid ranges)	2,048	0.57	0.00
table scans (short tables)	6,176,183	1,712.96	4.94
total number of times SMON posted	176,663	49.00	0.14
transaction rollbacks	4,862	1.35	0.00
transaction tables consistent read rollbacks	90	0.02	0.00
transaction tables consistent reads - undo records applied	3,130	0.87	0.00
undo change vector size	11,319,410,292	3,139,421.51	9,053.73
user I/O wait time	137,082	38.02	0.11
user calls	49,740,735	13,795.52	39.78
user commits	984,965	273.18	0.79
user rollbacks	265,283	73.58	0.21
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	6,521,242	1,808.66	5.22
write clones created in background	1,846	0.51	0.00
write clones created in foreground	16,080	4.46	0.01

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	540,169	1,257,636
opened cursors current	1,100,832	1,237,063
workarea memory allocated	2,891	845
logons current	5,268	5,301

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

• Tablespace IO Stats
• File IO Stats

Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_UNDOTS1	37	0	8.65	1.00	981,601	272	356,076	0.02
APPS_TS_TX_DATA	179,572	50	4.46	1.33	252,518	70	172,430	0.18
APPS_TS_TX_IDX	95,490	26	4.45	1.30	251,170	70	113,623	0.22
APPS_ASSM_DATA	8,867	2	2.27	6.47	308,408	86	50,059	0.29
APPS_ASSM_IDX	6,796	2	2.40	1.03	205,924	57	340,890	0.09
APPS_TS_TX_INTERFACE	1,172	0	2.61	2.12	44,084	12	22,635	0.03
TEMP	508	0	4.29	9.21	10,633	3	54	16.67
APPS_TS_SUMMARY	57	0	7.72	1.00	9,158	3	3,648	0.01
SYSTEM	5,245	1	3.67	3.58	3,114	1	42,288	0.08
APPS_TS_SEED	2,055	1	6.27	1.36	6,021	2	940	2.65
APPS_TS_QUEUES	344	0	5.96	2.51	5,929	2	1,022	0.15
APPS_TS_ARCHIVE	61	0	6.89	1.44	2,800	1	170	7.35
SYSAUX	291	0	2.20	1.14	1,695	0	9	0.00
APPS_TS_NOLOGGING	25	0	9.20	1.56	49	0	0	0.00
CTXSYS	24	0	7.08	1.00	6	0	0	0.00
APPS_TS_MEDIA	12	0	10.83	1.00	9	0	0	0.00
ODM	12	0	5.00	1.00	3	0	0	0.00
OLAP	12	0	6.67	1.00	3	0	0	0.00
OWAPUB	12	0	5.83	1.00	3	0	0	0.00
PORTAL	12	0	10.00	1.00	3	0	0	0.00
SYNCSERVER	12	0	12.50	1.00	3	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,867	2	2.27	6.47	308,408	86	50,059	0.29
APPS_ASSM_IDX	/DB/visdata/apps_assm_idx.dbf	6,796	2	2.40	1.03	205,924	57	340,890	0.09
APPS_TS_ARCHIVE	/DB/visdata/archive1.dbf	32	0	9.06	1.50	2,514	1	166	2.53
APPS_TS_ARCHIVE	/DB/visdata/archive2.dbf	29	0	4.48	1.38	286	0	4	207.50
APPS_TS_MEDIA	/DB/visdata/media1.dbf	4	0	7.50	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media2.dbf	4	0	15.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media3.dbf	4	0	10.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging1.dbf	4	0	12.50	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging2.dbf	15	0	6.00	1.00	35	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging3.dbf	6	0	15.00	3.33	11	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues1.dbf	34	0	5.29	2.71	824	0	433	0.14
APPS_TS_QUEUES	/DB/visdata/queues2.dbf	27	0	4.81	3.56	1,009	0	355	0.14
APPS_TS_QUEUES	/DB/visdata/queues3.dbf	33	0	9.70	4.06	872	0	8	0.00
APPS_TS_QUEUES	/DB/visdata/queues4.dbf	40	0	5.00	2.58	863	0	8	0.00
APPS_TS_QUEUES	/DB/visdata/queues5.dbf	40	0	7.25	3.03	647	0	7	0.00
APPS_TS_QUEUES	/DB/visdata/queues6.dbf	33	0	7.58	2.52	701	0	9	0.00
APPS_TS_QUEUES	/DB/visdata/queues7.dbf	137	0	4.96	1.70	1,013	0	202	0.20
APPS_TS_SEED	/DB/visdata/reference1.dbf	176	0	6.53	1.36	535	0	44	1.59
APPS_TS_SEED	/DB/visdata/reference10.dbf	169	0	7.46	1.26	584	0	61	5.57
APPS_TS_SEED	/DB/visdata/reference2.dbf	189	0	7.04	1.33	619	0	43	5.81
APPS_TS_SEED	/DB/visdata/reference3.dbf	317	0	5.33	1.38	674	0	459	1.96
APPS_TS_SEED	/DB/visdata/reference4.dbf	205	0	6.73	1.37	658	0	35	1.43
APPS_TS_SEED	/DB/visdata/reference5.dbf	238	0	5.97	1.28	604	0	81	3.58
APPS_TS_SEED	/DB/visdata/reference6.dbf	226	0	6.37	1.48	668	0	43	3.26
APPS_TS_SEED	/DB/visdata/reference7.dbf	206	0	7.18	1.30	525	0	31	2.26
APPS_TS_SEED	/DB/visdata/reference8.dbf	171	0	5.15	1.46	546	0	50	5.00
APPS_TS_SEED	/DB/visdata/reference9.dbf	158	0	5.44	1.32	608	0	93	1.40
APPS_TS_SUMMARY	/DB/visdata/summary1.dbf	5	0	8.00	1.00	1,096	0	458	0.00
APPS_TS_SUMMARY	/DB/visdata/summary2.dbf	5	0	8.00	1.00	953	0	299	0.00
APPS_TS_SUMMARY	/DB/visdata/summary3.dbf	7	0	11.43	1.00	898	0	240	0.00
APPS_TS_SUMMARY	/DB/visdata/summary4.dbf	12	0	5.83	1.00	1,052	0	308	0.00
APPS_TS_SUMMARY	/DB/visdata/summary5.dbf	7	0	7.14	1.00	1,147	0	468	0.02
APPS_TS_SUMMARY	/DB/visdata/summary6.dbf	7	0	8.57	1.00	1,418	0	750	0.00
APPS_TS_SUMMARY	/DB/visdata/summary7.dbf	7	0	7.14	1.00	1,090	0	396	0.00
APPS_TS_SUMMARY	/DB/visdata/summary8.dbf	7	0	7.14	1.00	1,504	0	729	0.04
APPS_TS_TX_DATA	/DB/visdata/tx_data1.dbf	3,278	1	5.51	1.26	407	0	2	5.00
APPS_TS_TX_DATA	/DB/visdata/tx_data10.dbf	3,257	1	5.07	1.26	284	0	1	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data11.dbf	3,263	1	4.68	1.30	257	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data12.dbf	13,326	4	3.26	1.23	4,659	1	3,900	1.75
APPS_TS_TX_DATA	/DB/visdata/tx_data13.dbf	18,066	5	4.78	1.47	5,963	2	2,657	1.08
APPS_TS_TX_DATA	/DB/visdata/tx_data14.dbf	13,347	4	4.11	1.35	36,180	10	22,885	0.14
APPS_TS_TX_DATA	/DB/visdata/tx_data15.dbf	9,518	3	4.01	1.44	35,960	10	23,737	0.13
APPS_TS_TX_DATA	/DB/visdata/tx_data16.dbf	9,548	3	4.06	1.42	34,440	10	21,913	0.13
APPS_TS_TX_DATA	/DB/visdata/tx_data17.dbf	9,366	3	3.92	1.42	33,127	9	23,236	0.12
APPS_TS_TX_DATA	/DB/visdata/tx_data18.dbf	9,497	3	4.12	1.39	31,728	9	24,409	0.13
APPS_TS_TX_DATA	/DB/visdata/tx_data19.dbf	9,318	3	4.12	1.42	31,963	9	22,774	0.12
APPS_TS_TX_DATA	/DB/visdata/tx_data2.dbf	6,822	2	3.69	1.17	1,383	0	2,306	0.63
APPS_TS_TX_DATA	/DB/visdata/tx_data20.dbf	9,313	3	4.12	1.48	31,918	9	22,813	0.10
APPS_TS_TX_DATA	/DB/visdata/tx_data21.dbf	24,026	7	5.00	1.28	1,182	0	1,765	0.03
APPS_TS_TX_DATA	/DB/visdata/tx_data3.dbf	4,001	1	5.36	1.42	500	0	3	3.33
APPS_TS_TX_DATA	/DB/visdata/tx_data4.dbf	17,099	5	5.01	1.09	354	0	2	5.00
APPS_TS_TX_DATA	/DB/visdata/tx_data5.dbf	3,348	1	5.23	1.25	448	0	2	10.00
APPS_TS_TX_DATA	/DB/visdata/tx_data6.dbf	3,324	1	5.17	1.26	265	0	2	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data7.dbf	3,280	1	5.15	1.29	593	0	7	1.43
APPS_TS_TX_DATA	/DB/visdata/tx_data8.dbf	3,169	1	5.18	1.24	550	0	14	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data9.dbf	3,406	1	4.82	1.29	357	0	2	0.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx1.dbf	2,492	1	3.49	1.12	3,015	1	1,866	0.61
APPS_TS_TX_IDX	/DB/visdata/tx_idx10.dbf	2,486	1	3.69	1.14	2,011	1	2,079	0.35
APPS_TS_TX_IDX	/DB/visdata/tx_idx11.dbf	2,438	1	3.68	1.13	2,225	1	1,759	0.53
APPS_TS_TX_IDX	/DB/visdata/tx_idx12.dbf	11,573	3	5.27	1.52	25,637	7	2,185	0.25
APPS_TS_TX_IDX	/DB/visdata/tx_idx13.dbf	9,719	3	4.56	1.24	35,142	10	6,959	0.17
APPS_TS_TX_IDX	/DB/visdata/tx_idx14.dbf	5,982	2	4.88	1.34	25,968	7	7,029	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx15.dbf	5,766	2	4.79	1.36	22,031	6	10,945	0.08
APPS_TS_TX_IDX	/DB/visdata/tx_idx16.dbf	5,781	2	4.96	1.39	20,200	6	7,363	0.10
APPS_TS_TX_IDX	/DB/visdata/tx_idx17.dbf	5,825	2	4.92	1.35	19,172	5	7,882	0.10
APPS_TS_TX_IDX	/DB/visdata/tx_idx18.dbf	5,817	2	4.85	1.34	18,794	5	13,586	0.11
APPS_TS_TX_IDX	/DB/visdata/tx_idx19.dbf	5,833	2	4.83	1.36	17,842	5	9,485	0.13
APPS_TS_TX_IDX	/DB/visdata/tx_idx2.dbf	3,060	1	3.87	1.29	2,487	1	2,185	0.40
APPS_TS_TX_IDX	/DB/visdata/tx_idx20.dbf	5,665	2	4.79	1.36	17,187	5	8,712	0.08
APPS_TS_TX_IDX	/DB/visdata/tx_idx21.dbf	3,499	1	5.05	1.46	16,271	5	2,894	0.74
APPS_TS_TX_IDX	/DB/visdata/tx_idx3.dbf	3,968	1	2.73	1.08	2,433	1	2,060	0.78
APPS_TS_TX_IDX	/DB/visdata/tx_idx4.dbf	2,674	1	3.44	1.11	4,028	1	2,706	0.64
APPS_TS_TX_IDX	/DB/visdata/tx_idx5.dbf	2,682	1	3.33	1.16	5,580	2	16,209	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx6.dbf	2,644	1	3.53	1.17	3,305	1	2,270	0.66
APPS_TS_TX_IDX	/DB/visdata/tx_idx7.dbf	2,542	1	3.55	1.14	3,168	1	1,655	0.44
APPS_TS_TX_IDX	/DB/visdata/tx_idx8.dbf	2,529	1	3.96	1.13	2,460	1	1,875	1.02
APPS_TS_TX_IDX	/DB/visdata/tx_idx9.dbf	2,515	1	3.41	1.17	2,214	1	1,919	0.43
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte.dbf	66	0	6.21	3.32	6,859	2	3,560	0.03
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte2.dbf	310	0	2.61	2.04	8,813	2	3,840	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte3.dbf	266	0	2.18	1.94	7,561	2	4,588	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte4.dbf	148	0	1.96	2.43	7,275	2	3,865	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte5.dbf	161	0	3.23	2.20	6,848	2	3,779	0.03
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte6.dbf	221	0	2.04	1.85	6,728	2	3,003	0.02
APPS_UNDOTS1	/DB/visdata/undo01.dbf	6	0	10.00	1.00	97,496	27	37,257	0.02
APPS_UNDOTS1	/DB/visdata/undo02.dbf	3	0	10.00	1.00	97,353	27	38,896	0.03
APPS_UNDOTS1	/DB/visdata/undo03.dbf	4	0	10.00	1.00	101,729	28	42,712	0.03
APPS_UNDOTS1	/DB/visdata/undo04.dbf	4	0	10.00	1.00	101,290	28	32,321	0.02
APPS_UNDOTS1	/DB/visdata/undo05.dbf	3	0	3.33	1.00	102,604	28	35,114	0.02
APPS_UNDOTS1	/DB/visdata/undo06.dbf	3	0	6.67	1.00	100,693	28	41,574	0.03
APPS_UNDOTS1	/DB/visdata/undo07.dbf	3	0	13.33	1.00	94,026	26	33,928	0.02
APPS_UNDOTS1	/DB/visdata/undo08.dbf	3	0	6.67	1.00	94,348	26	31,793	0.02
APPS_UNDOTS1	/DB/visdata/undo09.dbf	3	0	13.33	1.00	93,632	26	31,816	0.02
APPS_UNDOTS1	/DB/visdata/undo10.dbf	5	0	4.00	1.00	98,430	27	30,665	0.02
CTXSYS	/DB/visdata/ctx1.dbf	12	0	7.50	1.00	3	0	0	0.00
CTXSYS	/DB/visdata/ctx2.dbf	12	0	6.67	1.00	3	0	0	0.00
ODM	/DB/visdata/odm.dbf	12	0	5.00	1.00	3	0	0	0.00
OLAP	/DB/visdata/olap.dbf	12	0	6.67	1.00	3	0	0	0.00
OWAPUB	/DB/visdata/owa1.dbf	12	0	5.83	1.00	3	0	0	0.00
PORTAL	/DB/visdata/portal.dbf	12	0	10.00	1.00	3	0	0	0.00
SYNCSERVER	/DB/visdata/mobile01.dbf	12	0	12.50	1.00	3	0	0	0.00
SYSAUX	/DB/visdata/sysaux01.dbf	16	0	5.63	2.31	770	0	7	0.00
SYSAUX	/DB/visdata/sysaux02.dbf	275	0	2.00	1.07	925	0	2	0.00
SYSTEM	/DB/visdata/sys1.dbf	567	0	3.53	3.94	110	0	138	1.38
SYSTEM	/DB/visdata/sys2.dbf	579	0	3.42	4.07	211	0	200	0.20
SYSTEM	/DB/visdata/sys3.dbf	689	0	2.89	3.52	295	0	57	0.00
SYSTEM	/DB/visdata/sys4.dbf	646	0	2.86	3.62	290	0	38	2.11
SYSTEM	/DB/visdata/sys5.dbf	860	0	4.13	2.99	751	0	3,831	0.13
SYSTEM	/DB/visdata/sys6.dbf	565	0	4.62	4.19	94	0	14	0.00
SYSTEM	/DB/visdata/sys7.dbf	451	0	4.63	4.31	225	0	193	0.16
SYSTEM	/DB/visdata/sys8.dbf	391	0	3.68	3.19	620	0	37,603	0.07
SYSTEM	/DB/visdata/sys9.dbf	497	0	3.54	2.58	518	0	214	0.14
TEMP	/DB/visdata/temp1.dbf	103	0	4.08	1.00	2,407	1	15	3.33
TEMP	/DB/visdata/temp2.dbf	88	0	5.57	1.00	2,692	1	7	7.14
TEMP	/DB/visdata/temp3.dbf	152	0	3.82	5.38	2,516	1	8	26.25
TEMP	/DB/visdata/temp4.dbf	165	0	4.18	22.23	3,018	1	24	24.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,172,942	100	2,049,259,240	456,117	3,260,812	0	0	1,104,060

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	103	48896	1186958	4592129	188743680	4592129
E	180	107	53728	1200683	10234452	188743680	10234452

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	639,025	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	47,282.39	0.86	0.00	100.00	0.00	1,048,576
E	20,480	1,280	55,048.71	0.20	0.00	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	5,868,709	5,868,709	0	0
64K	128K	11,754	11,754	0	0
128K	256K	1,160	1,160	0	0
256K	512K	1,110	1,110	0	0
512K	1024K	188,207	188,207	0	0
1M	2M	438,530	438,530	0	0
2M	4M	70	68	2	0
4M	8M	17	17	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	940,243.01	9,455.79	99.00	1,253
5,120	0.25	940,243.01	9,403.83	99.00	1,220
10,240	0.50	940,243.01	9,267.71	99.00	1,164
15,360	0.75	940,243.01	9,135.12	99.00	1,110
20,480	1.00	940,243.01	0.00	100.00	1,059
24,576	1.20	940,243.01	0.00	100.00	1,025
28,672	1.40	940,243.01	0.00	100.00	961
32,768	1.60	940,243.01	0.00	100.00	859
36,864	1.80	940,243.01	0.00	100.00	613
40,960	2.00	940,243.01	0.00	100.00	180
61,440	3.00	940,243.01	0.00	100.00	0
81,920	4.00	940,243.01	0.00	100.00	0
122,880	6.00	940,243.01	0.00	100.00	0
163,840	8.00	940,243.01	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,920	0.69	331	13,835	2,566,922	1.00	3,273	2.13	200,159,558
2,208	0.79	594	17,405	2,568,109	1.00	2,086	1.36	200,244,338
2,496	0.90	879	21,004	2,568,564	1.00	1,631	1.06	200,277,876
2,784	1.00	1,163	25,260	2,568,659	1.00	1,536	1.00	200,285,251
3,072	1.10	1,389	33,016	2,568,670	1.00	1,525	0.99	200,286,211
3,360	1.21	1,439	34,194	2,568,670	1.00	1,525	0.99	200,286,316
3,648	1.31	1,486	34,850	2,568,670	1.00	1,525	0.99	200,286,351
3,936	1.41	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
4,224	1.52	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
4,512	1.62	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
4,800	1.72	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
5,088	1.83	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
5,376	1.93	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353
5,664	2.03	1,502	35,709	2,568,670	1.00	1,525	0.99	200,286,353

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	37,559
10,240	0.50	37,560
15,360	0.75	37,560
20,480	1.00	37,559
25,600	1.25	37,565
30,720	1.50	37,565
35,840	1.75	37,565
40,960	2.00	37,566

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
32	0.33	14	325	576	1.00	1,537	1.00	25,116
48	0.50	15	331	576	1.00	1,537	1.00	25,116
64	0.67	15	331	576	1.00	1,537	1.00	25,116
80	0.83	15	331	576	1.00	1,537	1.00	25,116
96	1.00	15	331	576	1.00	1,537	1.00	25,116
112	1.17	15	331	576	1.00	1,537	1.00	25,116
128	1.33	15	331	576	1.00	1,537	1.00	25,116
144	1.50	15	331	576	1.00	1,537	1.00	25,116
160	1.67	15	331	576	1.00	1,537	1.00	25,116
176	1.83	15	331	576	1.00	1,537	1.00	25,116
192	2.00	15	331	576	1.00	1,537	1.00	25,116
208	2.17	15	331	576	1.00	1,537	1.00	25,116

Back to Advisory Statistics
Back to Top

 

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	735,405	107	0
undo block	289,066	6	0
undo header	67,020	3	0
file header block	88	1	10
segment header	3,516	0	0
1st level bmb	8,230	0	0
2nd level bmb	599	0	0
extent map	13	0	0
bitmap index block	2	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	6,137	386	5,751	361	162	447.37
UL-User-defined	69,496	68,445	1,051	2,307	36	15.50
TX-Transaction (index contention)	32,447	32,447	0	29,851	14	0.46
RO-Multiple Object Reuse (fast object reuse)	288	288	0	32	12	373.13
HW-Segment High Water Mark	280,534	280,526	9	2,809	2	0.72
TX-Transaction	1,340,496	1,341,054	0	2,200	1	0.66
SQ-Sequence Cache	43,669	43,669	0	3,292	1	0.29
DV-Diana Versioning	32,321	32,322	0	212	1	3.68
TX-Transaction (allocate ITL entry)	263	263	0	173	0	1.21
FB-Format Block	37,213	37,214	0	643	0	0.23
TM-DML	2,174,892	2,174,813	14	1	0	150.00
CU-Cursor	9,220	9,219	0	3	0	3.33
PS-PX Process Reservation	1,864	1,542	320	22	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,630.46	1,344,342	2,638	384		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
16-Aug 09:19	135,326	160,344	468	383	204	0/0	0/0/0/0/0/0
16-Aug 09:09	153,560	164,215	760	379	201	0/0	0/0/0/0/0/0
16-Aug 08:59	231,517	167,181	619	375	199	0/0	0/0/0/0/0/0
16-Aug 08:49	461,601	240,284	450	377	208	0/0	0/0/0/0/0/0
16-Aug 08:39	269,247	234,873	2,638	380	283	0/0	0/0/0/0/0/0
16-Aug 08:29	379,209	377,445	2,033	384	358	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	336,053	0.00		0	0
Consistent RBA	895,910	0.02	0.07	0	0
FOB s.o list latch	54,400	0.03	0.00	0	0
In memory undo latch	707,960,200	3.47	0.00	17	1,278,615	0.00
JOX SGA heap latch	1,947,738	0.00		0	0
JS queue state obj latch	21,600	0.00		0	0
JS slv state obj latch	183	0.00		0	0
KMG MMAN ready and startup request latch	2,517	0.00		0	0
KMG resize request state object freelist	20	0.00		0	0
KTF sga latch	11	0.00		0	1,213	0.00
KWQMN job cache list latch	14,382	0.45	0.66	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1,506	0.00		0	2,506	0.00
OS process	15,276	0.00		0	0
OS process allocation	11,423	0.01	0.00	0	0
OS process: request allocation	9,942	0.00		0	0
PL/SQL warning settings	4,601,344	0.00		0	0
SGA IO buffer pool latch	57,669	0.90	0.00	0	62,110	0.94
SQL memory manager latch	1	0.00		0	1,198	0.00
SQL memory manager workarea list latch	7,241,410	0.02	0.01	0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	969,738	0.89	0.00	0	2	0.00
active service list	48,793	0.27	0.00	0	1,258	0.00
begin backup scn array	132	0.00		0	0
buffer pool	20	0.00		0	0
cache buffer handles	24,429,288	1.78	0.00	0	0
cache buffers chains	4,788,779,215	1.55	0.03	47	19,474,224	2.58
cache buffers lru chain	10,482,980	0.40	0.04	0	37,876,116	0.77
cache table scan latch	2,090	0.00		0	2,090	0.05
channel handle pool latch	415,177	0.21	0.03	0	0
channel operations parent latch	1,860,836	0.41	0.00	0	0
checkpoint queue latch	20,668,169	0.02	0.01	0	3,290,204	0.03
client/application info	1,797,038	0.01	0.00	0	0
commit callback allocation	88,581	0.01	0.00	0	0
compile environment latch	3,154,453	0.00		0	0
dictionary lookup	78	0.00		0	0
dml lock allocation	4,332,238	0.79	0.00	0	0
dummy allocation	20,367	1.12	0.00	0	0
enqueue hash chains	9,465,143	0.31	0.00	0	366	0.27
enqueues	5,429,541	0.21	0.01	0	0
error message lists	816	7.60	0.00	0	0
event group latch	4,990	0.00		0	0
file cache latch	21,943	0.00		0	0
global KZLD latch for mem in SGA	9,684	0.00		0	0
global ctx hash table latch	24,513	0.00		0	0
hash table column usage latch	1,785	0.28	0.00	0	15,614,586	0.00
hash table modification latch	143	0.00		0	0
internal temp table object number allocation latc	6	0.00		0	0
job workq parent latch	0			0	122	0.00
job_queue_processes parameter latch	120	0.00		0	0
kks stats	30,975	0.02	0.00	0	0
ksuosstats global area	242	0.00		0	0
ktm global data	176,681	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	901,490	0.45	0.00	0	0
library cache	356,106,109	0.59	0.00	3	17,898	0.80
library cache load lock	10,245	0.99	0.03	0	40	0.00
library cache lock	59,842,238	0.13	0.00	0	0
library cache lock allocation	1,553,362	0.01	0.02	0	0
library cache pin	222,005,440	0.39	0.00	1	37	0.00
library cache pin allocation	541,231	0.00	0.00	0	0
list of block allocation	459,001	0.02	0.00	0	0
loader state object freelist	322,714	0.02	0.00	0	0
longop free list parent	34	0.00		0	34	0.00
message pool operations parent latch	421,806	0.08	0.02	0	0
messages	5,506,136	0.52	0.00	0	0
mostly latch-free SCN	1,043,655	12.59	0.00	0	0
multiblock read objects	28,796	0.01	0.00	0	0
ncodef allocation latch	106	0.00		0	0
object queue header heap	4,295,435	0.03	0.17	0	426,363	0.05
object queue header operation	43,954,385	0.18	0.42	2	19,552	0.33
object stats modification	412,901	0.05	0.01	0	0
parallel query alloc buffer	8,160	3.05	0.00	0	0
parallel query stats	528	35.61	0.02	0	0
parameter table allocation management	24,258	1.03	0.88	0	0
post/wait queue	1,331,672	0.06	0.02	0	539,918	0.04
process allocation	9,990	0.49	0.96	1	4,988	0.04
process group creation	9,942	0.00		0	0
process queue	5,030	3.02	0.00	0	0
process queue reference	771,215	0.07	0.00	0	83,747	0.36
qmn task queue latch	516	0.00		0	0
query server freelists	4,256	16.28	0.00	0	0
query server process	8	0.00		0	8	0.00
redo allocation	6,148,514	5.49	0.00	0	103,232,569	3.58
redo copy	0			0	103,678,359	0.05
redo writing	4,219,384	0.29	0.00	0	0
resmgr group change latch	860,117	0.00		0	0
resmgr:actses active list	30,020	0.85	1.04	0	0
resmgr:actses change group	29,438	0.00		0	0
resmgr:free threads list	20,365	1.15	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	129,625,777	0.57	0.00	0	5,319	0.15
rules engine aggregate statistics	41,573	0.13	0.00	0	0
rules engine rule set statistics	133,611	0.08	0.00	0	0
rules engine rule statistics	50,482	0.00		0	0
sequence cache	16,639,719	1.13	0.00	0	0
session allocation	19,765,025	1.10	0.01	0	0
session idle bit	102,624,959	0.02	0.02	0	0
session state list latch	59,047	0.31	0.27	0	0
session switching	15,186	0.01	0.00	0	0
session timer	1,258	0.00		0	0
shared pool	7,679,251	0.31	0.03	0	0
shared pool sim alloc	387	0.00		0	0
shared pool simulator	2,024,943	0.01	0.01	0	0
sim partition latch	1	0.00		0	22,938	0.16
simulator hash latch	2,460	0.00		0	0
simulator lru latch	2,060	0.00		0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	1,446,135	0.21	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	262	0.00		0	0
temporary table state object allocation	12,638	0.11	0.00	0	0
threshold alerts latch	606	0.00		0	0
trace latch	47	0.00		0	0
transaction allocation	117,397	0.00	0.00	0	0
transaction branch allocation	106	0.00		0	0
undo global data	950,752,636	1.37	0.00	1	30,992	0.11
user lock	38,792	0.05	0.05	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,788,779,215	74,007,369	2,522,325	71,640,796	0	0	0
In memory undo latch	707,960,200	24,554,786	48,189	24,510,286	0	0	0
undo global data	950,752,636	13,054,831	2,419	13,052,669	0	0	0
library cache	356,106,109	2,111,094	8,847	2,102,940	0	0	0
library cache pin	222,005,440	862,907	2,555	860,526	0	0	0
row cache objects	129,625,777	732,983	2,045	730,982	0	0	0
cache buffer handles	24,429,288	434,535	125	434,423	0	0	0
redo allocation	6,148,514	337,251	1,199	336,196	0	0	0
session allocation	19,765,025	217,913	1,694	216,311	0	0	0
sequence cache	16,639,719	187,973	75	187,908	0	0	0
mostly latch-free SCN	1,043,655	131,375	333	131,056	0	0	0
object queue header operation	43,954,385	79,103	32,885	48,443	0	0	0
library cache lock	59,842,238	77,793	242	77,554	0	0	0
cache buffers lru chain	10,482,980	42,258	1,484	40,833	0	0	0
dml lock allocation	4,332,238	34,250	91	34,169	0	0	0
enqueue hash chains	9,465,143	29,072	21	29,053	0	0	0
messages	5,506,136	28,410	103	28,308	0	0	0
session idle bit	102,624,959	24,172	381	23,797	0	0	0
shared pool	7,679,251	23,668	737	22,997	0	0	0
redo writing	4,219,384	12,405	28	12,377	0	0	0
enqueues	5,429,541	11,138	78	11,063	0	0	0
active checkpoint queue latch	969,738	8,624	9	8,615	0	0	0
channel operations parent latch	1,860,836	7,576	37	7,540	0	0	0
lgwr LWN SCN	901,490	4,021	1	4,020	0	0	0
checkpoint queue latch	20,668,169	3,459	30	3,431	0	0	0
sort extent pool	1,446,135	3,095	28	3,068	0	0	0
object queue header heap	4,295,435	1,436	244	1,213	0	0	0
SQL memory manager workarea list latch	7,241,410	1,163	8	1,156	0	0	0
channel handle pool latch	415,177	889	26	866	0	0	0
post/wait queue	1,331,672	830	14	816	0	0	0
SGA IO buffer pool latch	57,669	517	2	515	0	0	0
message pool operations parent latch	421,806	318	5	314	0	0	0
resmgr:actses active list	30,020	254	263	7	0	0	0
parameter table allocation management	24,258	250	219	58	0	0	0
object stats modification	412,901	196	1	195	0	0	0
parallel query stats	528	188	4	184	0	0	0
session state list latch	59,047	182	49	135	0	0	0
Consistent RBA	895,910	150	11	143	0	0	0
library cache lock allocation	1,553,362	136	3	133	0	0	0
shared pool simulator	2,024,943	111	1	110	0	0	0
library cache load lock	10,245	101	3	98	0	0	0
KWQMN job cache list latch	14,382	65	43	22	0	0	0
process allocation	9,990	49	47	2	0	0	0
user lock	38,792	21	1	20	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	0	36,465	39,182
In memory undo latch	ktiFlush: child	0	6,832	4,000
In memory undo latch	kticmt: child	0	3,251	531
In memory undo latch	ktichg: child	0	1,311	4,313
In memory undo latch	ktiTxnPoolFree	0	249	2
In memory undo latch	ktbgfc	0	8	79
In memory undo latch	ktiBRacquire	0	7	0
KWQMN job cache list latch	kwqmnuji: update job item	0	50	16
KWQMN job cache list latch	kwqmndej: dequeue	0	1	49
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	0	1	0
SGA IO buffer pool latch	ksfd_free_sgabuffer	0	1	3
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	7	6
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	1	2
active checkpoint queue latch	kcbbacq: scan active checkpoints	0	9	9
active service list	ksws_event: ksws event	0	1	1
cache buffer handles	kcbzgs	0	78	58
cache buffer handles	kcbzfs	0	47	67
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	2,595,338	2,788,272
cache buffers chains	kcbchg: kslbegin: call CR func	0	1,106,452	1,925,287
cache buffers chains	kcbgtcr: fast path	0	790,332	73,699
cache buffers chains	kcbgtcr: kslbegin excl	0	567,841	446,941
cache buffers chains	kcbrls: kslbegin	0	286,315	422,042
cache buffers chains	kcbzgb: scan from tail. nowait	0	176,417	0
cache buffers chains	kcbgcur: kslbegin	0	54,809	30,265
cache buffers chains	kcbget: pin buffer	0	26,947	12,314
cache buffers chains	kcbget: exchange rls	0	15,778	17,075
cache buffers chains	kcbzwb	0	14,278	11,863
cache buffers chains	kcbget: exchange	0	12,691	17,293
cache buffers chains	kcbcge	0	7,065	15,999
cache buffers chains	kcbnlc	0	1,907	2,697
cache buffers chains	kcbbxsv	0	409	402
cache buffers chains	kcbso1: set no access	0	395	143
cache buffers chains	kcb_is_private	0	290	3,299
cache buffers chains	kcbgtcr: kslbegin shared	0	206	163
cache buffers chains	kcbesc: escalate	0	117	59
cache buffers chains	kcbnew: new latch again	0	98	11
cache buffers chains	kcbbic2	0	44	9
cache buffers chains	kcb_pre_apply: kcbhq61	0	24	1,378
cache buffers chains	kcb_post_apply: kcbhq62	0	12	200
cache buffers chains	kcb_post_apply: kcbhq63	0	7	243
cache buffers chains	kcbo_ivd_process	0	2	49
cache buffers chains	kcbzib: finish free bufs	0	2	2
cache buffers chains	kcbbic1	0	1	5
cache buffers chains	kcbgtcr	0	1	1
cache buffers chains	kcbrlb1	0	1	17
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	0	1	0
cache buffers chains	kcbzib: exchange rls	0	1	1
cache buffers chains	kcbzib: multi-block read: nowait	0	1	0
cache buffers lru chain	kcbzgws	0	790	0
cache buffers lru chain	kcbo_link_q	0	316	26
cache buffers lru chain	kcbbxsv: move to being written	0	203	564
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	70	0
cache buffers lru chain	kcbzgb: posted for free bufs	0	58	343
cache buffers lru chain	kcbzswcu	0	18	104
cache buffers lru chain	kcbbic2	0	12	302
cache buffers lru chain	kcbo_ivd_proc	0	11	100
cache buffers lru chain	kcbz_decr_wspwbcnt	0	2	20
cache buffers lru chain	kcbo_write_process:free_unlink	0	1	0
cache buffers lru chain	kcbzfw	0	1	1
cache buffers lru chain	kcbzgm	0	1	0
cache buffers lru chain	kcbzib	0	1	0
channel handle pool latch	ksrchconnect()	0	106	92
channel handle pool latch	ksrchdelete()	0	6	20
channel operations parent latch	ksrapublish()	0	51	25
channel operations parent latch	ksrchdelete()	0	27	22
channel operations parent latch	ksrwait()	0	8	25
channel operations parent latch	ksrchconnect()	0	7	9
channel operations parent latch	ksrsconsume()	0	6	13
channel operations parent latch	ksrmfree()	0	4	9
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	16	10
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	5	3
checkpoint queue latch	kcbkubc	0	5	7
checkpoint queue latch	kcbswcu: Switch buffers	0	3	10
checkpoint queue latch	kcbnlc: Link buffers into FQ	0	1	0
client/application info	kskirefrattrmap	0	1	0
cost function	kzulrl	0	1	1
dml lock allocation	ktaiam	0	70	63
dml lock allocation	ktaidm	0	21	28
enqueue hash chains	ksqgtl3	0	12	12
enqueue hash chains	ksqrcl	0	5	6
enqueue hash chains	ksqcmi: kslgpl	0	2	1
enqueue hash chains	ksqcmi: get hash chain latch after wait	0	1	2
enqueue hash chains	ksqcmi: if deadlock detected	0	1	0
enqueues	ksqgel: create enqueue	0	33	14
enqueues	ksqies	0	28	57
enqueues	ksqdel	0	17	7
lgwr LWN SCN	kcs023	0	70	0
library cache	kglpndl: child: after processing	0	3,315	288
library cache	kglpnp: child	0	3,006	3,892
library cache	kglobpn: child:	0	1,054	1,490
library cache	kglpndl: child: before processing	0	420	2,508
library cache	kglLockCursor	0	163	274
library cache	kgldti: 2child	0	142	16
library cache	kglScanDependency	0	140	0
library cache	kglhdgn: child:	0	86	151
library cache	kglpin	0	85	56
library cache	kgldte: child 0	0	84	126
library cache	kglhdgc: child:	0	28	4
library cache	kglukp: child	0	6	0
library cache	kglic	0	5	0
library cache	kglivl: child	0	5	0
library cache	kglupd: child	0	3	0
library cache	kgldtld: 2child	0	2	0
library cache	kglhdiv: child	0	2	0
library cache	kglobld	0	2	4
library cache	kglget: unpin heap 0	0	1	0
library cache load lock	kglllal: llatch: in loop	0	2	3
library cache load lock	kglllal: llatch	0	1	0
library cache lock	kgllkdl: child: cleanup	0	167	140
library cache lock	kgllkal: child: multiinstance	0	75	102
library cache lock	kgllkdl: child: no lock handle	0	48	19
library cache lock allocation	kgllkget	0	3	2
library cache pin	kglpnp: child	0	1,193	1,257
library cache pin	kglpndl	0	1,137	876
library cache pin	kglpnal: child: alloc space	0	226	423
message pool operations parent latch	ksrmalloc()	0	10	8
messages	ksarcv: after wait	0	53	77
messages	ksarcv	0	39	7
messages	ksaamb: after wakeup	0	11	19
mostly latch-free SCN	kcslcu3	0	263	334
mostly latch-free SCN	kcsnew_scn_rba	0	6	0
mostly latch-free SCN	kcs01	0	5	11
mostly latch-free SCN	kcs024	0	1	0
object queue header heap	kcbo_link_q:reget	0	239	3
object queue header heap	kcbw_link_q:alloc	0	5	252
object queue header operation	kcbo_ivbo	0	33,614	13,866
object queue header operation	kcbw_link_q	0	4,853	3,289
object queue header operation	kcbw_unlink_q	0	1,693	6,786
object queue header operation	kcbo_switch_mq_bg	0	559	4,034
object queue header operation	kcbo_switch_q_bg	0	503	2,230
object queue header operation	kcbo_switch_cq	0	139	4,059
object queue header operation	kcbo_link_q:reget	0	64	207
object queue header operation	kcbo_service_ockpt	0	32	13
object queue header operation	kcbo_write_q	0	19	72
object queue header operation	kcbo_swap_buf	0	12	627
object queue header operation	kcbo_swap_buf_bg	0	12	6,317
object queue header operation	kcbw_unlink_q_bg	0	4	20
object stats modification	ksoslinelm	0	1	1
parallel query stats	kxfprst: KSLBEGIN:1	0	4	4
parameter table allocation management	ksp_param_table_free	0	218	219
parameter table allocation management	kspptval	0	1	1
post/wait queue	ksliwat:remove	0	13	12
post/wait queue	ksliwat:add:nowait	0	1	0
process allocation	ksucrp	0	39	0
process allocation	ksudlp	0	7	8
process allocation	ksufap: active procs	0	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	0	763	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	293	1,008
redo allocation	kcrfw_redo_gen: redo allocation 2	0	90	0
redo allocation	kcrfw_redo_write: before write	0	29	86
redo allocation	kcrfw_redo_write: more space	0	22	125
redo writing	kcrfwcr	0	17	26
redo writing	kcrfw_post: rba scn pair	0	7	0
redo writing	kcrfw_cal_target_rba	0	2	0
redo writing	kcrfw_post: after write	0	2	2
resmgr:actses active list	kgskchclass	0	263	131
row cache objects	kqreqd: reget	0	1,530	19
row cache objects	kqrpre: find obj	0	374	911
row cache objects	kqreqd	0	127	1,109
row cache objects	kqrso	0	6	6
row cache objects	kqrpup	0	1	0
sequence cache	kdnssd	0	57	4
sequence cache	kdnnxt: cached seq	0	12	2
sequence cache	kdnss	0	6	70
session allocation	ksuxds: KSUSFCLC not set	0	894	110
session allocation	ksucri	0	213	409
session allocation	ksuprc	0	197	340
session allocation	ksudlc	0	153	467
session allocation	ksuxds: not user session	0	150	296
session allocation	kspallmod	0	26	0
session allocation	kxfpqidqr	0	24	37
session allocation	ksudlp	0	17	2
session allocation	ksursi	0	15	25
session allocation	kxfprdp	0	5	7
session idle bit	ksupuc: set busy	0	357	155
session idle bit	ksupuc: clear busy	0	166	358
session idle bit	ksuxds	0	27	37
session state list latch	kpseqd	0	47	1
session state list latch	kpscad	0	2	10
shared pool	kghupr1	0	396	488
shared pool	kghalo	0	222	127
shared pool	kghfrunp: clatch: nowait	0	222	0
shared pool	kghalp	0	50	35
shared pool	kghfrunp: clatch: wait	0	32	14
shared pool	kghfrunp: alloc: cursor dur	0	30	1
shared pool	kghfrunp: alloc: wait	0	19	1
shared pool	kghfre	0	18	83
shared pool	kghasp	0	1	2
shared pool	kghfrh	0	1	0
shared pool simulator	kglsim_unpin_simhp	0	1	1
sort extent pool	ktstdt: dealloc sort extent	0	20	3
sort extent pool	ktstdt: return extent	0	5	5
sort extent pool	ktstsmonmsg	0	2	26
sort extent pool	ktstallobj1	0	1	1
undo global data	kturimugur: child	0	1,897	1,452
undo global data	ktudba: KSLBEGIN	0	453	949
undo global data	ktucof: at start	0	27	0
undo global data	ktudnx:child	0	14	6
undo global data	ktusmasp: ktugd_tuux	0	13	4
undo global data	ktufrbs: child	0	8	5
undo global data	ktubnd:child	0	4	0
undo global data	ktumof: KSLBEGIN	0	1	0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 2,057,823,471
• Captured Segments account for 30.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	69,216,048	3.36
INV	APPS_TS_TX_IDX	MTL_ITEM_CATEGORIES_U1		INDEX	50,914,512	2.47
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	23,755,280	1.15
APPLSYS	APPS_TS_TX_DATA	WF_LOCAL_USER_ROLES	FND_RESP	TABLE PARTITION	22,433,264	1.09
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	21,668,992	1.05

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 457,024
• Captured Segments account for 16.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	35,007	7.66
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	13,143	2.88
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	9,554	2.09
HR	APPS_TS_TX_IDX	PAY_PERSON_LATEST_BALA_N50		INDEX	4,777	1.05
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS		TABLE	4,048	0.89

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
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS		TABLE	11,110	24.28
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	10,393	22.71
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	10,064	21.99
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	3,406	7.44
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	1,953	4.27

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	37	25.34
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	23	15.75
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	21	14.38
SYS	SYSTEM	SEG$		TABLE	19	13.01
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N1		INDEX	14	9.59

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	202,605	33.72
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	97,413	16.21
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	37,563	6.25
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	28,878	4.81
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	21,047	3.50

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	0
dc_files	6,660	0.00	0		0	111
dc_global_oids	7,854,808	0.00	0		0	48
dc_histogram_data	5,248	14.54	0		0	705
dc_histogram_defs	423,300	2.56	0		4,044	3,867
dc_object_grants	72,626	0.05	0		0	68
dc_object_ids	13,062,197	0.02	0		58	1,056
dc_objects	181,619	0.99	0		347	810
dc_profiles	9,745	0.00	0		0	1
dc_rollback_segments	21,212	0.00	0		0	387
dc_segments	369,501	0.51	0		16,159	1,401
dc_sequences	53,663	0.16	0		53,663	119
dc_table_scns	20,653	0.04	0		0	5
dc_tablespace_quotas	16,019	0.14	0		218	45
dc_tablespaces	6,008,849	0.00	0		0	22
dc_usernames	515,326	0.00	0		0	19
dc_users	15,154,424	0.00	0		0	65
outstanding_alerts	268	0.75	0		1	42

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	643,216	0.02	42,590,301	-0.00	11	0
CLUSTER	105	0.00	234	0.85	2	0
INDEX	15,818	0.40	16,630	0.56	0	0
JAVA DATA	624	0.00	0		0	0
PIPE	50,600	2.53	74,832	1.72	1	0
SQL AREA	6,358	90.23	114,118,177	0.06	3,836	404
TABLE/PROCEDURE	410,104	0.25	57,980,293	-0.01	1,043	0
TRIGGER	28,849	0.09	1,408,747	0.00	27	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	37,500.51		12.07	7.10	38	38	3,107	3,107
	Freeable	3,653.63	0.00	1.33	0.80	9		2,753	2,753
	SQL	3,469.61	1,778.85	1.12	0.70	5	21	3,099	3,098
	PL/SQL	2,407.00	192.33	0.77	0.96	3	3	3,107	3,107
	JAVA	266.68	265.32	2.22	0.29	5	8	120	120
E	Other	43,763.61		13.92	8.63	42	42	3,145	3,145
	Freeable	4,239.81	0.00	1.50	0.93	9		2,822	2,822
	SQL	3,981.55	2,082.43	1.27	0.75	5	21	3,137	3,136
	PL/SQL	2,802.85	217.44	0.89	0.99	3	3	3,145	3,145
	JAVA	266.70	265.35	2.22	0.29	5	8	120	120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	18,589,155,328	18,421,383,168
Fixed Size	2,111,120
Redo Buffers	14,663,680
Variable Size	2,868,906,352	3,036,678,512

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	83.29	83.29	0.00
java	joxlod exec hp	12.09	12.09	0.00
large	free memory	15.94	15.94	0.00
shared	ASH buffers	40.50	40.50	0.00
shared	CCursor	34.09	34.52	1.26
shared	KTI-UNDO	53.19	53.19	0.00
shared	PL/SQL MPCODE	66.66	68.97	3.46
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	event statistics per sess	63.28	63.28	0.00
shared	free memory	376.82	384.57	2.06
shared	library cache	860.79	1,016.02	18.03
shared	parameter table block	57.89	58.25	0.63
shared	private strands	99.77	99.77	0.00
shared	sessions	36.42	36.42	0.00
shared	sql area	391.37	385.48	-1.50
shared	trace buffer	48.61	49.34	1.51
	buffer_cache	17,728.00	17,568.00	-0.90
	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

• only rows with Current or Maximum Utilization > 80% of Limit are shown
• ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	3,146	3,159	3600	3600

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	/raw_links/cntrl01, /raw_links/cntrl02, /raw_links/cntrl03
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	3
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	8
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	3600
remote_login_passwordfile	EXCLUSIVE
replication_dependency_tracking	FALSE
session_cached_cursors	500
sessions	7200
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