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-Oct-08 16:10:16	3820	204.7
End Snap:	2	16-Oct-08 17:10:21	3836	238.0
Elapsed:		60.08 (mins)
DB Time:		308.34 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	18,208M	18,048M	Std Block Size:	8K
Shared Pool Size:	2,176M	2,336M	Log Buffer:	14,320K

Load Profile

	Per Second	Per Transaction
Redo size:	8,399,093.43	31,258.29
Logical reads:	505,590.93	1,881.62
Block changes:	51,797.99	192.77
Physical reads:	118.79	0.44
Physical writes:	805.22	3.00
User calls:	9,844.09	36.64
Parses:	1,954.72	7.27
Hard parses:	2.07	0.01
Sorts:	2,382.06	8.87
Logons:	2.10	0.01
Executes:	23,197.98	86.33
Transactions:	268.70

% Blocks changed per Read:	10.25	Recursive Call %:	79.31
Rollback per transaction %:	19.22	Rows per Sort:	12.85

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.96	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.90	Soft Parse %:	99.89
Execute to Parse %:	91.57	Latch Hit %:	99.03
Parse CPU to Parse Elapsd %:	87.88	% Non-Parse CPU:	97.78

Shared Pool Statistics

	Begin	End
Memory Usage %:	85.30	85.18
% SQL with executions>1:	90.63	90.95
% Memory for SQL w/exec>1:	68.27	69.53

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		16,836		91.0
db file sequential read	254,039	985	4	5.3	User I/O
log file sync	400,441	635	2	3.4	Commit
log file parallel write	701,714	429	1	2.3	System I/O
db file parallel write	282,037	260	1	1.4	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): 18500.5s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
DB CPU	16,835.94	91.00
sql execute elapsed time	16,002.73	86.50
PL/SQL execution elapsed time	3,649.90	19.73
inbound PL/SQL rpc elapsed time	3,167.41	17.12
parse time elapsed	480.54	2.60
Java execution elapsed time	466.57	2.52
hard parse elapsed time	240.00	1.30
repeated bind elapsed time	60.17	0.33
sequence load elapsed time	11.40	0.06
connection management call elapsed time	7.75	0.04
PL/SQL compilation elapsed time	6.62	0.04
hard parse (sharing criteria) elapsed time	3.90	0.02
hard parse (bind mismatch) elapsed time	1.19	0.01
failed parse elapsed time	1.02	0.01
DB time	18,500.49
background elapsed time	1,074.86
background cpu time	320.53

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	309,713	0.00	1,142	4	0.32
System I/O	1,014,644	0.00	699	1	1.05
Commit	400,441	0.00	635	2	0.41
Network	40,644,780	0.00	146	0	41.96
Application	50,491	0.05	112	2	0.05
Concurrency	1,484,598	0.26	110	0	1.53
Other	112,898	22.42	32	0	0.12
Configuration	6,587	0.00	4	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	254,039	0.00	985	4	0.26
log file sync	400,441	0.00	635	2	0.41
log file parallel write	701,714	0.00	429	1	0.72
db file parallel write	282,037	0.00	260	1	0.29
SQL*Net more data from client	1,852,194	0.00	98	0	1.91
db file scattered read	13,579	0.00	89	7	0.01
read by other session	39,046	0.00	66	2	0.04
enq: UL - contention	2,318	0.56	50	22	0.00
enq: TX - row lock contention	535	2.43	49	92	0.00
cursor: pin S wait on X	4,245	92.20	43	10	0.00
SQL*Net message to client	37,169,523	0.00	36	0	38.38
enq: TX - index contention	25,899	0.00	15	1	0.03
buffer busy waits	628,735	0.00	15	0	0.65
latch: cache buffers chains	791,630	0.00	13	0	0.82
library cache load lock	627	0.00	13	21	0.00
SQL*Net more data to client	1,623,063	0.00	13	0	1.68
PX Deq Credit: send blkd	23,697	0.00	11	0	0.02
control file sequential read	29,155	0.00	9	0	0.03
SQL*Net break/reset to client	47,604	0.00	8	0	0.05
rdbms ipc reply	5	60.00	7	1319	0.00
enq: RO - fast object reuse	31	0.00	6	182	0.00
latch: In memory undo latch	21,070	0.00	4	0	0.02
PX Deq: Signal ACK	291	34.36	3	11	0.00
kksfbc child completion	82	79.27	3	40	0.00
latch: library cache	6,289	0.00	3	0	0.01
os thread startup	69	0.00	2	29	0.00
log buffer space	205	0.00	2	9	0.00
latch: undo global data	9,011	0.00	2	0	0.01
enq: HW - contention	2,419	0.00	2	1	0.00
LGWR wait for redo copy	28,306	0.00	1	0	0.03
control file parallel write	1,738	0.00	1	1	0.00
local write wait	1,819	0.00	1	1	0.00
latch: object queue header operation	12,091	0.00	1	0	0.01
enq: TX - contention	2,740	0.00	1	0	0.00
latch: library cache pin	1,562	0.00	1	0	0.00
enq: DV - contention	176	0.00	1	3	0.00
latch: cache buffers lru chain	855	0.00	1	1	0.00
enq: SQ - contention	3,834	0.00	0	0	0.00
direct path read	732	0.00	0	1	0.00
wait list latch free	35	0.00	0	11	0.00
latch free	661	0.00	0	1	0.00
latch: row cache objects	493	0.00	0	1	0.00
buffer deadlock	25,187	98.90	0	0	0.03
latch: session allocation	530	0.00	0	0	0.00
SGA: allocation forcing component growth	23	56.52	0	11	0.00
library cache pin	1,402	0.00	0	0	0.00
latch: redo allocation	669	0.00	0	0	0.00
row cache lock	1,841	0.00	0	0	0.00
latch: shared pool	504	0.00	0	0	0.00
cursor: pin S	7,019	0.00	0	0	0.01
latch: library cache lock	97	0.00	0	1	0.00
enq: TM - contention	3	0.00	0	30	0.00
enq: FB - contention	654	0.00	0	0	0.00
latch: object queue header heap	128	0.00	0	0	0.00
PX qref latch	272	82.35	0	0	0.00
enq: TX - allocate ITL entry	86	0.00	0	1	0.00
latch: cache buffer handles	141	0.00	0	0	0.00
library cache lock	3	0.00	0	10	0.00
reliable message	36	0.00	0	1	0.00
latch: messages	172	0.00	0	0	0.00
latch: redo writing	37	0.00	0	0	0.00
latch: checkpoint queue latch	32	0.00	0	0	0.00
cursor: mutex S	117	0.00	0	0	0.00
latch: enqueue hash chains	17	0.00	0	0	0.00
direct path write	440	0.00	0	0	0.00
enq: PS - contention	63	0.00	0	0	0.00
enq: US - contention	5	0.00	0	1	0.00
write complete waits	6	0.00	0	0	0.00
direct path write temp	45	0.00	0	0	0.00
cursor: mutex X	15	0.00	0	0	0.00
direct path read temp	13	0.00	0	0	0.00
SQL*Net message from client	37,169,495	0.00	7,414,695	199	38.38
pipe get	22,132	20.89	21,077	952	0.02
Streams AQ: waiting for time management or cleanup tasks	2,341	38.74	3,504	1497	0.00
Streams AQ: qmn slave idle wait	128	0.00	3,489	27255	0.00
Streams AQ: qmn coordinator idle wait	256	50.00	3,489	13627	0.00
PX Idle Wait	1,618	76.14	2,535	1567	0.00
PL/SQL lock timer	209	99.04	2,354	11262	0.00
jobq slave wait	605	99.67	1,769	2924	0.00
PX Deq: Execution Msg	5,074	0.00	42	8	0.01
PX Deq: Execute Reply	2,655	0.00	3	1	0.00
PX Deq Credit: need buffer	3,922	0.00	1	0	0.00
PX Deq: Msg Fragment	4,300	0.00	1	0	0.00
PX Deq: Table Q Normal	5,308	0.00	0	0	0.01
PX Deq: Parse Reply	264	0.00	0	0	0.00
PX Deq: Join ACK	271	0.00	0	0	0.00
class slave wait	1	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	701,725	0.00	429	1	0.72
db file parallel write	282,037	0.00	260	1	0.29
control file sequential read	827	0.00	3	4	0.00
events in waitclass Other	33,899	0.00	2	0	0.04
db file sequential read	993	0.00	2	2	0.00
os thread startup	61	0.00	2	29	0.00
db file scattered read	277	0.00	2	5	0.00
control file parallel write	1,738	0.00	1	1	0.00
direct path read	732	0.00	0	1	0.00
latch: cache buffers chains	76	0.00	0	1	0.00
latch: redo writing	37	0.00	0	0	0.00
direct path write	333	0.00	0	0	0.00
buffer busy waits	12	0.00	0	0	0.00
log file sync	1	0.00	0	1	0.00
latch: shared pool	3	0.00	0	0	0.00
latch: library cache	1	0.00	0	0	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
rdbms ipc message	1,613,115	0.75	36,936	23	1.67
pmon timer	1,305	92.57	3,511	2690	0.00
smon timer	117,236	0.00	3,508	30	0.12
Streams AQ: waiting for time management or cleanup tasks	2,341	38.74	3,504	1497	0.00
Streams AQ: qmn slave idle wait	128	0.00	3,489	27255	0.00
Streams AQ: qmn coordinator idle wait	256	50.00	3,489	13627	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	1,806,351
IDLE_TIME	3,961,222
IOWAIT_TIME	76,261
NICE_TIME	0
SYS_TIME	76,451
USER_TIME	1,683,922
LOAD	3
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	64,691,772
NUM_CPUS	16
NUM_CPU_SOCKETS	4

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	18,499.80	16,835.40	414,898	1,819,497,826
SYS$BACKGROUND	0.00	0.00	13,422	2,974,512
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	307363	113785	1484436	10788	0	0	40633285	14594
SYS$BACKGROUND	2340	374	154	181	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
694	689	304	2.28	3.75	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
363	361	55,047	0.01	1.96	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
324	297	78,524	0.00	1.75	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
318	317	55,043	0.01	1.72	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
288	288	55,045	0.01	1.56	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
281	257	141,882	0.00	1.52	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
244	241	61,309	0.00	1.32	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
231	230	259,826	0.00	1.25	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
222	219	1,009	0.22	1.20	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
194	172	186,474	0.00	1.05	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
193	85	1,683	0.11	1.04	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....

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
689	694	304	2.27	3.75	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
361	363	55,047	0.01	1.96	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
317	318	55,043	0.01	1.72	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
297	324	78,524	0.00	1.75	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
288	288	55,045	0.01	1.56	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
257	281	141,882	0.00	1.52	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
241	244	61,309	0.00	1.32	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
230	231	259,826	0.00	1.25	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
219	222	1,009	0.22	1.20	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
172	194	186,474	0.00	1.05	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
85	193	1,683	0.05	1.04	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: 1,822,426,758
• Captured SQL account for 12.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
53,359,867	141,882	376.09	2.93	257.18	280.88	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
51,818,331	186,474	277.89	2.84	171.69	193.91	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
51,140,929	155,039	329.86	2.81	138.24	138.57	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
46,793,742	55,047	850.07	2.57	361.13	362.53	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
41,836,630	304	137,620.49	2.30	689.14	693.65	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
30,997,073	55,045	563.12	1.70	287.83	288.39	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
28,280,579	1,383,944	20.43	1.55	104.99	105.26	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
27,602,516	166,869	165.41	1.51	138.89	139.02	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
27,599,838	166,865	165.40	1.51	128.42	128.52	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
26,399,748	10,000	2,639.97	1.45	82.22	169.06	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
23,437,890	61,309	382.29	1.29	241.35	244.03	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
23,072,718	55,043	419.18	1.27	316.99	317.88	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 428,196
• Captured SQL account for 30.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,238	10,000	4.52	10.56	82.22	169.06	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
39,461	1,683	23.45	9.22	11.18	175.16	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
26,928	1,683	16.00	6.29	85.44	192.56	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
19,912	15,135	1.32	4.65	113.06	179.59	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
11,228	186,474	0.06	2.62	171.69	193.91	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
9,704	504	19.25	2.27	59.33	93.38	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
8,315	5,048	1.65	1.94	82.14	114.32	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
8,270	141,882	0.06	1.93	257.18	280.88	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,592	10,000	0.46	1.07	125.67	136.66	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
4,504	10,000	0.45	1.05	104.03	112.84	63t8zpm02skgh	PYUSLV	SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 83,618,233
• Captured SQL account for 8.2% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
1,383,944	716,434	0.52	0.00	0.00	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
788,541	788,542	1.00	0.00	0.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
419,285	419,281	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
259,826	259,821	1.00	0.00	0.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
259,067	202,173	0.78	0.00	0.00	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
203,869	3,465,682	17.00	0.00	0.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
186,474	0	0.00	0.00	0.00	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
166,869	166,869	1.00	0.00	0.00	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
166,868	166,868	1.00	0.00	0.00	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
166,865	166,865	1.00	0.00	0.00	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 7,045,881
• Captured SQL account for 44.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
419,285	419,285	5.95	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
259,823	259,826	3.69	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
259,066	259,067	3.68	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
203,871	203,869	2.89	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
166,870	166,868	2.37	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
141,882	141,882	2.01	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
117,685	117,685	1.67	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
111,820	111,820	1.59	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
88,961	88,959	1.26	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
84,746	84,742	1.20	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
84,746	84,746	1.20	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...
84,746	88,961	1.20	dcvv68fju01g4	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.E...
84,308	84,308	1.20	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
77,988	77,988	1.11	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id	SQL Text
0z318y6g3uagc	declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun	begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z	SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1q78dwnrrkf6c	BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
25wzrzwd46a44	SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk	SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
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;
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;
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	1,667,821	462.70	1.72
CPU used when call started	1,664,412	461.75	1.72
CR blocks created	14,410,084	3,997.75	14.88
Cached Commit SCN referenced	46,446	12.89	0.05
Commit SCN cached	8	0.00	0.00
DB time	4,532,837	1,257.53	4.68
DBWR checkpoint buffers written	2,820,332	782.44	2.91
DBWR checkpoints	34	0.01	0.00
DBWR object drop buffers written	57,713	16.01	0.06
DBWR revisited being-written buffer	134	0.04	0.00
DBWR thread checkpoint buffers written	973,137	269.97	1.00
DBWR transaction table writes	1,836	0.51	0.00
DBWR undo block writes	1,520,066	421.71	1.57
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	31,579,928	8,761.13	32.61
IMU Flushes	291,645	80.91	0.30
IMU Redo allocation size	2,015,213,732	559,075.29	2,080.67
IMU commits	507,084	140.68	0.52
IMU contention	31,861	8.84	0.03
IMU ktichg flush	8,472	2.35	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1,500	0.42	0.00
IMU undo allocation size	4,616,342,328	1,280,699.36	4,766.28
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	51,678	14.34	0.05
PX local messages sent	51,678	14.34	0.05
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	37,162,791	10,309.97	38.37
active txn count during cleanout	92,278,235	25,600.50	95.28
application wait time	11,232	3.12	0.01
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,907	3.86	0.01
branch node splits	1,011	0.28	0.00
buffer is not pinned count	550,898,041	152,834.15	568.79
buffer is pinned count	1,388,844,373	385,303.34	1,433.96
bytes received via SQL*Net from client	8,234,064,881	2,284,354.34	8,501.51
bytes sent via SQL*Net to client	7,712,180,053	2,139,569.25	7,962.68
calls to get snapshot scn: kcmgss	93,563,029	25,956.94	96.60
calls to kcmgas	18,155,619	5,036.86	18.75
calls to kcmgcs	12,978,204	3,600.51	13.40
change write time	41,496	11.51	0.04
cleanout - number of ktugct calls	25,751,841	7,144.26	26.59
cleanouts and rollbacks - consistent read gets	12,363,341	3,429.93	12.76
cleanouts only - consistent read gets	132,940	36.88	0.14
cluster key scan block gets	813,120	225.58	0.84
cluster key scans	229,975	63.80	0.24
commit batch/immediate performed	3,668	1.02	0.00
commit batch/immediate requested	3,668	1.02	0.00
commit cleanout failures: block lost	212,664	59.00	0.22
commit cleanout failures: buffer being written	666	0.18	0.00
commit cleanout failures: callback failure	102,637	28.47	0.11
commit cleanout failures: cannot pin	31,111	8.63	0.03
commit cleanouts	8,181,309	2,269.72	8.45
commit cleanouts successfully completed	7,834,231	2,173.43	8.09
commit immediate performed	3,668	1.02	0.00
commit immediate requested	3,668	1.02	0.00
commit txn count during cleanout	1,221,080	338.76	1.26
concurrency wait time	10,968	3.04	0.01
consistent changes	681,910,304	189,180.53	704.06
consistent gets	1,609,691,516	446,572.36	1,661.98
consistent gets - examination	1,122,530,192	311,420.51	1,158.99
consistent gets from cache	1,609,691,561	446,572.37	1,661.98
cursor authentications	1,901	0.53	0.00
data blocks consistent reads - undo records applied	678,760,909	188,306.80	700.81
db block changes	186,708,347	51,797.99	192.77
db block gets	212,738,098	59,019.35	219.65
db block gets direct	4,180	1.16	0.00
db block gets from cache	212,733,918	59,018.20	219.64
deferred (CURRENT) block cleanout applications	1,413,836	392.24	1.46
dirty buffers inspected	8,769	2.43	0.01
enqueue conversions	8,304	2.30	0.01
enqueue releases	3,664,497	1,016.63	3.78
enqueue requests	3,669,895	1,018.13	3.79
enqueue timeouts	5,250	1.46	0.01
enqueue waits	32,558	9.03	0.03
exchange deadlocks	25,187	6.99	0.03
execute count	83,618,233	23,197.98	86.33
failed probes on index block reclamation	9,814	2.72	0.01
free buffer inspected	2,487,241	690.03	2.57
free buffer requested	18,544,521	5,144.76	19.15
heap block compress	29,515,420	8,188.38	30.47
hot buffers moved to head of LRU	1,063,401	295.02	1.10
immediate (CR) block cleanout applications	12,496,291	3,466.81	12.90
immediate (CURRENT) block cleanout applications	1,076,220	298.57	1.11
index crx upgrade (found)	13,055	3.62	0.01
index crx upgrade (positioned)	8,289,709	2,299.79	8.56
index fast full scans (rowid ranges)	792	0.22	0.00
index fetch by key	166,546,375	46,204.51	171.96
index scans kdiixs1	134,910,024	37,427.72	139.29
java call heap collected bytes	1,247,602,296	346,118.93	1,288.13
java call heap collected count	15,456,932	4,288.17	15.96
java call heap gc count	4,237	1.18	0.00
java call heap live object count	1,491,563	413.80	1.54
java call heap live object count max	1,535,163	425.90	1.59
java call heap live size	360,563,968	100,030.29	372.28
java call heap live size max	369,045,592	102,383.32	381.03
java call heap object count	3,582,265	993.82	3.70
java call heap object count max	3,595,274	997.43	3.71
java call heap total size	463,601,664	128,615.76	478.66
java call heap total size max	474,087,424	131,524.79	489.49
java call heap used size	495,372,920	137,429.97	511.46
java call heap used size max	501,298,752	139,073.96	517.58
leaf node 90-10 splits	19,172	5.32	0.02
leaf node splits	231,931	64.34	0.24
lob reads	16,701	4.63	0.02
lob writes	28,989	8.04	0.03
lob writes unaligned	28,989	8.04	0.03
logons cumulative	7,586	2.10	0.01
messages received	1,948,822	540.66	2.01
messages sent	1,948,822	540.66	2.01
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	444,596,714	123,343.26	459.04
opened cursors cumulative	4,491,852	1,246.16	4.64
parse count (failures)	2,520	0.70	0.00
parse count (hard)	7,448	2.07	0.01
parse count (total)	7,045,881	1,954.72	7.27
parse time cpu	37,367	10.37	0.04
parse time elapsed	42,521	11.80	0.04
physical read IO requests	268,299	74.43	0.28
physical read bytes	3,507,781,632	973,154.37	3,621.72
physical read total IO requests	297,564	82.55	0.31
physical read total bytes	3,986,358,272	1,105,924.59	4,115.84
physical read total multi block requests	13,572	3.77	0.01
physical reads	428,196	118.79	0.44
physical reads cache	427,061	118.48	0.44
physical reads cache prefetch	159,507	44.25	0.16
physical reads direct	1,135	0.31	0.00
physical reads direct temporary tablespace	403	0.11	0.00
physical reads prefetch warmup	92,872	25.77	0.10
physical write IO requests	1,079,647	299.52	1.11
physical write bytes	23,776,927,744	6,596,368.74	24,549.22
physical write total IO requests	2,127,683	590.28	2.20
physical write total bytes	55,436,521,984	15,379,604.32	57,237.15
physical write total multi block requests	1,226,409	340.24	1.27
physical writes	2,902,457	805.22	3.00
physical writes direct	4,916	1.36	0.01
physical writes direct (lob)	235	0.07	0.00
physical writes direct temporary tablespace	4,300	1.19	0.00
physical writes from cache	2,897,541	803.86	2.99
physical writes non checkpoint	2,232,511	619.36	2.31
pinned buffers inspected	2,587	0.72	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	217,041	60.21	0.22
prefetched blocks aged out before use	121	0.03	0.00
process last non-idle time	3,605	1.00	0.00
queries parallelized	48	0.01	0.00
recursive aborts on index block reclamation	1	0.00	0.00
recursive calls	136,017,154	37,734.87	140.44
recursive cpu usage	953,814	264.61	0.98
redo blocks written	61,668,246	17,108.45	63.67
redo buffer allocation retries	206	0.06	0.00
redo entries	96,227,941	26,696.26	99.35
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,255,063	348.19	1.30
redo size	30,274,935,420	8,399,093.43	31,258.29
redo subscn max counts	2,232,762	619.43	2.31
redo synch time	65,502	18.17	0.07
redo synch writes	1,709,346	474.22	1.76
redo wastage	266,471,236	73,926.39	275.13
redo write time	46,577	12.92	0.05
redo writer latching time	167	0.05	0.00
redo writes	701,741	194.68	0.72
rollback changes - undo records applied	337,233	93.56	0.35
rollbacks only - consistent read gets	2,221,578	616.33	2.29
rows fetched via callback	87,380,160	24,241.64	90.22
session connect time	0	0.00	0.00
session cursor cache hits	4,537,145	1,258.73	4.68
session logical reads	1,822,426,758	505,590.93	1,881.62
session pga memory	8,887,556,744	2,465,650.82	9,176.23
session pga memory max	10,267,101,224	2,848,374.12	10,600.59
session uga memory	###############	74,747,862.32	278,183.64
session uga memory max	55,906,783,792	15,510,067.78	57,722.68
shared hash latch upgrades - no wait	28,828,259	7,997.75	29.76
shared hash latch upgrades - wait	27,260	7.56	0.03
sorts (memory)	8,586,245	2,382.06	8.87
sorts (rows)	110,330,350	30,608.65	113.91
sql area evicted	2,387	0.66	0.00
sql area purged	2,690	0.75	0.00
summed dirty queue length	188,238	52.22	0.19
switch current to new buffer	1,288,034	357.34	1.33
table fetch by rowid	821,500,242	227,906.59	848.18
table fetch continued row	32,585,566	9,040.13	33.64
table scan blocks gotten	54,906,488	15,232.56	56.69
table scan rows gotten	1,636,783,528	454,088.43	1,689.95
table scans (long tables)	2,056	0.57	0.00
table scans (rowid ranges)	2,054	0.57	0.00
table scans (short tables)	4,484,327	1,244.07	4.63
total number of times SMON posted	117,211	32.52	0.12
transaction rollbacks	3,668	1.02	0.00
transaction tables consistent read rollbacks	68	0.02	0.00
transaction tables consistent reads - undo records applied	8,256	2.29	0.01
undo change vector size	10,552,112,200	2,927,443.94	10,894.85
user I/O wait time	114,184	31.68	0.12
user calls	35,483,497	9,844.09	36.64
user commits	782,350	217.05	0.81
user rollbacks	186,191	51.65	0.19
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	4,892,993	1,357.45	5.05
write clones created in background	1,818	0.50	0.00
write clones created in foreground	4,308	1.20	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	300,114	827,523
opened cursors current	781,921	913,020
workarea memory allocated	144	1,908
logons current	3,820	3,836

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	9.19	1.00	465,749	129	246,420	0.02
APPS_TS_TX_DATA	162,347	45	4.11	1.32	164,207	46	106,624	0.24
APPS_TS_TX_IDX	80,304	22	4.19	1.50	158,787	44	47,723	0.33
APPS_ASSM_DATA	8,590	2	2.02	6.66	133,470	37	35,340	0.48
APPS_ASSM_IDX	6,327	2	2.07	1.05	104,589	29	189,803	0.10
APPS_TS_TX_INTERFACE	1,106	0	1.94	2.19	25,147	7	18,574	0.02
TEMP	320	0	4.44	14.25	8,840	2	41	1.71
SYSTEM	5,243	1	4.04	3.12	2,237	1	19,925	0.04
APPS_TS_SEED	2,308	1	6.15	1.82	3,731	1	719	2.81
APPS_TS_SUMMARY	70	0	5.43	1.00	5,756	2	1,955	0.02
APPS_TS_QUEUES	1,109	0	2.98	1.53	4,085	1	585	0.14
SYSAUX	302	0	2.62	1.10	1,389	0	0	0.00
APPS_TS_ARCHIVE	49	0	5.10	1.43	1,604	0	70	3.14
APPS_TS_NOLOGGING	28	0	5.36	1.50	36	0	0	0.00
CTXSYS	24	0	8.75	1.00	6	0	0	0.00
APPS_TS_MEDIA	15	0	9.33	1.00	9	0	0	0.00
ODM	13	0	5.38	1.00	3	0	0	0.00
OLAP	13	0	6.92	1.00	3	0	0	0.00
OWAPUB	12	0	6.67	1.00	3	0	0	0.00
PORTAL	12	0	7.50	1.00	3	0	0	0.00
SYNCSERVER	12	0	5.83	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,590	2	2.02	6.66	133,470	37	35,340	0.48
APPS_ASSM_IDX	/DB/visdata/apps_assm_idx.dbf	6,327	2	2.07	1.05	104,589	29	189,803	0.10
APPS_TS_ARCHIVE	/DB/visdata/archive1.dbf	20	0	7.50	1.50	1,368	0	67	2.99
APPS_TS_ARCHIVE	/DB/visdata/archive2.dbf	29	0	3.45	1.38	236	0	3	6.67
APPS_TS_MEDIA	/DB/visdata/media1.dbf	5	0	8.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media2.dbf	5	0	6.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media3.dbf	5	0	14.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging1.dbf	5	0	6.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging2.dbf	16	0	3.75	1.00	19	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging3.dbf	7	0	8.57	3.00	14	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues1.dbf	177	0	2.60	1.29	514	0	143	0.14
APPS_TS_QUEUES	/DB/visdata/queues2.dbf	143	0	2.24	1.52	715	0	383	0.16
APPS_TS_QUEUES	/DB/visdata/queues3.dbf	137	0	2.92	1.55	553	0	5	0.00
APPS_TS_QUEUES	/DB/visdata/queues4.dbf	134	0	2.46	1.52	548	0	2	0.00
APPS_TS_QUEUES	/DB/visdata/queues5.dbf	132	0	3.18	1.58	562	0	1	0.00
APPS_TS_QUEUES	/DB/visdata/queues6.dbf	131	0	2.37	1.69	467	0	1	0.00
APPS_TS_QUEUES	/DB/visdata/queues7.dbf	255	0	4.20	1.58	726	0	50	0.00
APPS_TS_SEED	/DB/visdata/reference1.dbf	197	0	5.94	1.89	357	0	43	2.79
APPS_TS_SEED	/DB/visdata/reference10.dbf	217	0	5.99	1.88	378	0	50	3.00
APPS_TS_SEED	/DB/visdata/reference2.dbf	209	0	6.94	2.07	373	0	34	4.41
APPS_TS_SEED	/DB/visdata/reference3.dbf	355	0	5.89	1.69	458	0	344	2.76
APPS_TS_SEED	/DB/visdata/reference4.dbf	217	0	6.87	1.87	382	0	31	3.23
APPS_TS_SEED	/DB/visdata/reference5.dbf	245	0	6.41	1.67	363	0	66	4.55
APPS_TS_SEED	/DB/visdata/reference6.dbf	233	0	6.14	1.83	363	0	34	1.18
APPS_TS_SEED	/DB/visdata/reference7.dbf	220	0	5.36	1.87	326	0	30	2.00
APPS_TS_SEED	/DB/visdata/reference8.dbf	214	0	6.50	1.86	332	0	34	2.35
APPS_TS_SEED	/DB/visdata/reference9.dbf	201	0	5.62	1.65	399	0	53	1.32
APPS_TS_SUMMARY	/DB/visdata/summary1.dbf	6	0	8.33	1.00	675	0	279	0.04
APPS_TS_SUMMARY	/DB/visdata/summary2.dbf	6	0	5.00	1.00	584	0	153	0.07
APPS_TS_SUMMARY	/DB/visdata/summary3.dbf	12	0	6.67	1.00	611	0	154	0.00
APPS_TS_SUMMARY	/DB/visdata/summary4.dbf	14	0	3.57	1.00	693	0	229	0.00
APPS_TS_SUMMARY	/DB/visdata/summary5.dbf	8	0	5.00	1.00	703	0	311	0.00
APPS_TS_SUMMARY	/DB/visdata/summary6.dbf	8	0	7.50	1.00	792	0	511	0.02
APPS_TS_SUMMARY	/DB/visdata/summary7.dbf	8	0	3.75	1.00	907	0	153	0.00
APPS_TS_SUMMARY	/DB/visdata/summary8.dbf	8	0	5.00	1.00	791	0	165	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data1.dbf	2,900	1	5.12	1.31	275	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data10.dbf	2,840	1	4.47	1.25	167	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data11.dbf	2,821	1	4.46	1.30	115	0	4	17.50
APPS_TS_TX_DATA	/DB/visdata/tx_data12.dbf	12,361	3	2.73	1.23	2,108	1	2,925	1.02
APPS_TS_TX_DATA	/DB/visdata/tx_data13.dbf	16,298	5	4.60	1.51	3,616	1	2,153	1.01
APPS_TS_TX_DATA	/DB/visdata/tx_data14.dbf	12,313	3	3.89	1.38	25,407	7	14,823	0.18
APPS_TS_TX_DATA	/DB/visdata/tx_data15.dbf	8,754	2	3.73	1.44	22,794	6	14,435	0.22
APPS_TS_TX_DATA	/DB/visdata/tx_data16.dbf	8,825	2	3.60	1.42	22,108	6	14,090	0.22
APPS_TS_TX_DATA	/DB/visdata/tx_data17.dbf	8,708	2	3.80	1.44	21,116	6	13,914	0.20
APPS_TS_TX_DATA	/DB/visdata/tx_data18.dbf	8,751	2	3.63	1.41	20,796	6	13,193	0.15
APPS_TS_TX_DATA	/DB/visdata/tx_data19.dbf	8,577	2	3.93	1.43	20,905	6	14,245	0.16
APPS_TS_TX_DATA	/DB/visdata/tx_data2.dbf	6,335	2	3.15	1.15	556	0	1,343	1.71
APPS_TS_TX_DATA	/DB/visdata/tx_data20.dbf	8,652	2	3.94	1.47	21,069	6	14,115	0.12
APPS_TS_TX_DATA	/DB/visdata/tx_data21.dbf	20,490	6	4.71	1.18	946	0	1,324	0.10
APPS_TS_TX_DATA	/DB/visdata/tx_data3.dbf	3,136	1	5.21	1.49	388	0	14	2.86
APPS_TS_TX_DATA	/DB/visdata/tx_data4.dbf	16,339	5	4.52	1.11	302	0	13	2.31
APPS_TS_TX_DATA	/DB/visdata/tx_data5.dbf	2,805	1	4.73	1.24	334	0	6	5.00
APPS_TS_TX_DATA	/DB/visdata/tx_data6.dbf	2,859	1	4.60	1.23	155	0	11	2.73
APPS_TS_TX_DATA	/DB/visdata/tx_data7.dbf	2,803	1	4.81	1.27	397	0	16	4.38
APPS_TS_TX_DATA	/DB/visdata/tx_data8.dbf	2,824	1	4.59	1.16	395	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data9.dbf	2,956	1	4.84	1.30	258	0	0	0.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx1.dbf	2,409	1	3.24	1.24	1,935	1	1,289	0.49
APPS_TS_TX_IDX	/DB/visdata/tx_idx10.dbf	2,334	1	3.30	1.26	1,324	0	1,233	0.58
APPS_TS_TX_IDX	/DB/visdata/tx_idx11.dbf	2,294	1	3.48	1.29	1,587	0	1,280	0.78
APPS_TS_TX_IDX	/DB/visdata/tx_idx12.dbf	9,528	3	5.18	1.93	17,473	5	1,268	0.39
APPS_TS_TX_IDX	/DB/visdata/tx_idx13.dbf	8,019	2	4.34	1.36	22,093	6	2,878	0.31
APPS_TS_TX_IDX	/DB/visdata/tx_idx14.dbf	4,401	1	4.51	1.55	14,801	4	2,521	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx15.dbf	4,373	1	4.46	1.53	12,714	4	3,083	0.24
APPS_TS_TX_IDX	/DB/visdata/tx_idx16.dbf	4,543	1	4.63	1.52	11,592	3	2,897	0.11
APPS_TS_TX_IDX	/DB/visdata/tx_idx17.dbf	4,326	1	4.49	1.54	11,343	3	3,034	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx18.dbf	4,560	1	4.76	1.55	11,268	3	4,045	0.05
APPS_TS_TX_IDX	/DB/visdata/tx_idx19.dbf	4,588	1	4.61	1.54	10,657	3	3,149	0.21
APPS_TS_TX_IDX	/DB/visdata/tx_idx2.dbf	2,691	1	3.76	1.50	1,575	0	1,037	0.59
APPS_TS_TX_IDX	/DB/visdata/tx_idx20.dbf	4,393	1	4.78	1.57	10,295	3	2,106	0.07
APPS_TS_TX_IDX	/DB/visdata/tx_idx21.dbf	3,142	1	5.01	1.85	13,852	4	1,680	0.52
APPS_TS_TX_IDX	/DB/visdata/tx_idx3.dbf	3,842	1	2.50	1.21	1,609	0	1,818	0.73
APPS_TS_TX_IDX	/DB/visdata/tx_idx4.dbf	2,537	1	3.26	1.32	2,879	1	2,098	0.72
APPS_TS_TX_IDX	/DB/visdata/tx_idx5.dbf	2,498	1	3.28	1.27	4,186	1	7,655	0.07
APPS_TS_TX_IDX	/DB/visdata/tx_idx6.dbf	2,591	1	3.69	1.27	2,402	1	1,249	1.22
APPS_TS_TX_IDX	/DB/visdata/tx_idx7.dbf	2,434	1	3.53	1.29	2,171	1	1,091	0.86
APPS_TS_TX_IDX	/DB/visdata/tx_idx8.dbf	2,368	1	3.16	1.30	1,563	0	1,044	0.98
APPS_TS_TX_IDX	/DB/visdata/tx_idx9.dbf	2,433	1	3.29	1.33	1,468	0	1,268	0.56
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte.dbf	222	0	0.95	1.69	3,829	1	6,399	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte2.dbf	391	0	1.69	1.83	4,963	1	4,265	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte3.dbf	172	0	2.33	2.44	4,455	1	3,517	0.01
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte4.dbf	214	0	1.07	1.99	3,888	1	1,511	0.07
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte5.dbf	64	0	5.78	4.03	4,019	1	1,968	0.01
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte6.dbf	43	0	6.51	5.35	3,993	1	914	0.02
APPS_UNDOTS1	/DB/visdata/undo01.dbf	3	0	16.67	1.00	48,400	13	22,280	0.01
APPS_UNDOTS1	/DB/visdata/undo02.dbf	6	0	5.00	1.00	48,966	14	28,287	0.02
APPS_UNDOTS1	/DB/visdata/undo03.dbf	3	0	3.33	1.00	45,618	13	21,642	0.02
APPS_UNDOTS1	/DB/visdata/undo04.dbf	3	0	16.67	1.00	44,984	12	25,923	0.02
APPS_UNDOTS1	/DB/visdata/undo05.dbf	3	0	16.67	1.00	48,248	13	23,387	0.02
APPS_UNDOTS1	/DB/visdata/undo06.dbf	3	0	3.33	1.00	44,607	12	21,338	0.02
APPS_UNDOTS1	/DB/visdata/undo07.dbf	4	0	7.50	1.00	46,183	13	22,628	0.01
APPS_UNDOTS1	/DB/visdata/undo08.dbf	4	0	7.50	1.00	50,013	14	30,608	0.02
APPS_UNDOTS1	/DB/visdata/undo09.dbf	4	0	7.50	1.00	43,431	12	23,497	0.02
APPS_UNDOTS1	/DB/visdata/undo10.dbf	4	0	12.50	1.00	45,299	13	26,830	0.02
CTXSYS	/DB/visdata/ctx1.dbf	12	0	10.00	1.00	3	0	0	0.00
CTXSYS	/DB/visdata/ctx2.dbf	12	0	7.50	1.00	3	0	0	0.00
ODM	/DB/visdata/odm.dbf	13	0	5.38	1.00	3	0	0	0.00
OLAP	/DB/visdata/olap.dbf	13	0	6.92	1.00	3	0	0	0.00
OWAPUB	/DB/visdata/owa1.dbf	12	0	6.67	1.00	3	0	0	0.00
PORTAL	/DB/visdata/portal.dbf	12	0	7.50	1.00	3	0	0	0.00
SYNCSERVER	/DB/visdata/mobile01.dbf	12	0	5.83	1.00	3	0	0	0.00
SYSAUX	/DB/visdata/sysaux01.dbf	25	0	8.40	1.44	637	0	0	0.00
SYSAUX	/DB/visdata/sysaux02.dbf	277	0	2.09	1.07	752	0	0	0.00
SYSTEM	/DB/visdata/sys1.dbf	545	0	4.46	3.47	88	0	10	0.00
SYSTEM	/DB/visdata/sys2.dbf	569	0	4.04	3.77	173	0	19	0.00
SYSTEM	/DB/visdata/sys3.dbf	686	0	3.64	3.24	197	0	1	0.00
SYSTEM	/DB/visdata/sys4.dbf	553	0	3.71	3.68	203	0	7	0.00
SYSTEM	/DB/visdata/sys5.dbf	929	0	4.18	2.61	593	0	1,184	0.08
SYSTEM	/DB/visdata/sys6.dbf	555	0	4.13	3.68	84	0	1	0.00
SYSTEM	/DB/visdata/sys7.dbf	436	0	4.56	3.67	158	0	14	0.00
SYSTEM	/DB/visdata/sys8.dbf	401	0	4.54	2.35	393	0	18,659	0.04
SYSTEM	/DB/visdata/sys9.dbf	569	0	3.37	1.85	348	0	30	0.33
TEMP	/DB/visdata/temp1.dbf	129	0	4.11	27.05	2,602	1	27	1.48
TEMP	/DB/visdata/temp2.dbf	44	0	5.68	1.00	1,942	1	0
TEMP	/DB/visdata/temp3.dbf	78	0	4.23	10.73	2,259	1	14	2.14
TEMP	/DB/visdata/temp4.dbf	69	0	4.49	2.74	2,037	1	0

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,232,312	100	1,822,167,375	427,047	2,897,731	0	0	667,735

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	78	35000	815750	3115314	188743680	3115314
E	180	81	38423	823487	8765559	188743680	8765559

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	456,208	10

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	32,633.82	0.14	0.00	100.00	0.00	1,048,576
E	20,480	1,280	40,237.68	2.09	0.01	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	4,431,576	4,431,576	0	0
64K	128K	11,499	11,499	0	0
128K	256K	1,065	1,065	0	0
256K	512K	1,033	1,033	0	0
512K	1024K	138,711	138,711	0	0
1M	2M	308,652	308,652	0	0
2M	4M	76	76	0	0
4M	8M	23	21	2	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	619,303.95	7,830.00	99.00	957
5,120	0.25	619,303.95	7,769.50	99.00	923
10,240	0.50	619,303.95	7,665.12	99.00	870
15,360	0.75	619,303.95	7,573.60	99.00	821
20,480	1.00	619,303.95	5.00	100.00	770
24,576	1.20	619,303.95	5.00	100.00	614
28,672	1.40	619,303.95	0.00	100.00	185
32,768	1.60	619,303.95	0.00	100.00	0
36,864	1.80	619,303.95	0.00	100.00	0
40,960	2.00	619,303.95	0.00	100.00	0
61,440	3.00	619,303.95	0.00	100.00	0
81,920	4.00	619,303.95	0.00	100.00	0
122,880	6.00	619,303.95	0.00	100.00	0
163,840	8.00	619,303.95	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,136	0.49	281	12,748	1,902,929	1.00	3,178	3.66	148,214,845
1,376	0.59	490	15,652	1,904,735	1.00	1,372	1.58	148,353,142
1,616	0.69	730	19,266	1,905,200	1.00	907	1.04	148,389,328
1,856	0.79	968	24,437	1,905,238	1.00	869	1.00	148,392,732
2,096	0.90	1,078	30,205	1,905,238	1.00	869	1.00	148,392,804
2,336	1.00	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
2,576	1.10	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
2,816	1.21	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
3,056	1.31	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
3,296	1.41	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
3,536	1.51	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
3,776	1.62	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
4,016	1.72	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
4,256	1.82	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
4,496	1.92	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805
4,736	2.03	1,085	30,944	1,905,238	1.00	869	1.00	148,392,805

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

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	0.25	11	207	449	1.00	869	1.00	13,692
32	0.50	11	207	449	1.00	869	1.00	13,692
48	0.75	11	207	449	1.00	869	1.00	13,692
64	1.00	11	207	449	1.00	869	1.00	13,692
80	1.25	11	207	449	1.00	869	1.00	13,692
96	1.50	11	207	449	1.00	869	1.00	13,692
112	1.75	11	207	449	1.00	869	1.00	13,692
128	2.00	11	207	449	1.00	869	1.00	13,692

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	412,580	80	0
undo block	197,210	3	0
undo header	49,210	2	0
2nd level bmb	1,158	0	0
1st level bmb	5,339	0	0
segment header	2,187	0	0
file header block	75	0	1
extent map	21	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)
UL-User-defined	66,004	64,953	1,051	2,298	51	22.38
TX-Transaction (row lock contention)	4,382	495	3,887	481	50	104.49
TX-Transaction (index contention)	24,183	24,183	0	22,367	15	0.69
RO-Multiple Object Reuse (fast object reuse)	288	288	0	31	6	186.45
HW-Segment High Water Mark	206,605	206,604	1	2,064	2	0.78
TX-Transaction	1,106,965	1,106,968	0	1,798	1	0.50
DV-Diana Versioning	22,889	22,889	0	175	1	3.60
SQ-Sequence Cache	36,817	36,817	0	2,755	0	0.17
TM-DML	1,661,656	1,661,626	0	3	0	30.00
FB-Format Block	35,284	35,284	0	458	0	0.09
TX-Transaction (allocate ITL entry)	122	122	0	78	0	0.38
PS-PX Process Reservation	1,864	1,544	320	49	0	0.20
US-Undo Segment	8,267	8,267	0	4	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,505.74	1,097,292	2,676	275	179.3/999.066666666666666666666666666666666667	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-Oct 17:00	195,645	142,260	603	269	193	0/0	0/0/0/0/0/0
16-Oct 16:50	60,144	92,464	450	262	196	0/0	0/0/0/0/0/0
16-Oct 16:40	438,538	164,402	2,114	265	179	0/0	0/0/0/0/0/0
16-Oct 16:30	350,255	243,450	2,676	271	231	0/0	0/0/0/0/0/0
16-Oct 16:20	389,060	350,760	1,805	275	321	0/0	0/0/0/0/0/0
16-Oct 16:10	72,099	103,956	1,705	269	999	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,464	0.00		0	0
AWR Alerted Metric Element list	249,322	0.00		0	0
Consistent RBA	702,580	0.06	0.01	0	0
FOB s.o list latch	46,358	0.01	0.00	0	0
In memory undo latch	665,498,408	2.15	0.00	4	989,741	0.00
JOX SGA heap latch	1,868,257	0.00		0	0
JS queue state obj latch	21,630	0.00		0	0
JS slv state obj latch	180	0.00		0	0
KMG MMAN ready and startup request latch	2,521	0.00		0	0
KMG resize request state object freelist	20	0.00		0	0
KTF sga latch	12	0.00		0	1,214	0.00
KWQMN job cache list latch	12,048	0.12	1.00	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1,513	0.00		0	2,511	0.00
OS process	11,820	0.00		0	0
OS process allocation	9,103	0.01	0.00	0	0
OS process: request allocation	7,626	0.00		0	0
PL/SQL warning settings	3,560,728	0.00		0	0
SGA IO buffer pool latch	29,708	0.38	0.02	0	31,137	0.25
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	5,412,558	0.00	0.02	0	0
Shared B-Tree	128	0.00		0	0
active checkpoint queue latch	1,248,873	0.51	0.00	0	2	0.00
active service list	38,424	0.11	0.00	0	1,261	0.00
begin backup scn array	150	0.00		0	0
buffer pool	20	0.00		0	0
cache buffer handles	21,859,456	0.91	0.00	0	0
cache buffers chains	4,319,710,780	0.90	0.02	13	16,434,426	2.36
cache buffers lru chain	9,213,963	0.33	0.03	1	32,578,482	0.41
cache table scan latch	1,875	0.00		0	1,875	0.00
channel handle pool latch	292,732	0.07	0.02	0	0
channel operations parent latch	1,300,795	0.45	0.00	0	0
checkpoint queue latch	17,752,411	0.01	0.01	0	2,908,458	0.02
client/application info	1,305,221	0.00	0.00	0	0
commit callback allocation	62,854	0.00		0	0
compile environment latch	2,228,635	0.00		0	0
dictionary lookup	78	0.00		0	0
dml lock allocation	3,310,017	0.16	0.01	0	0
dummy allocation	15,170	0.25	0.03	0	0
enqueue hash chains	7,382,860	0.06	0.00	0	228	0.00
enqueues	3,946,402	0.10	0.01	0	0
error message lists	816	0.74	0.00	0	0
event group latch	3,824	0.00		0	0
file cache latch	20,007	0.01	0.00	0	0
global KZLD latch for mem in SGA	7,078	0.00		0	0
global ctx hash table latch	17,132	0.00		0	0
hash table column usage latch	1,706	0.00		0	11,002,643	0.00
hash table modification latch	146	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	121	0.00		0	0
kks stats	24,664	0.00		0	0
ksuosstats global area	242	0.00		0	0
ktm global data	117,201	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	704,733	0.10	0.00	0	0
library cache	269,105,458	0.32	0.01	3	19,327	0.67
library cache load lock	9,885	0.22	0.00	0	14	0.00
library cache lock	42,912,069	0.04	0.01	0	0
library cache lock allocation	1,131,584	0.01	0.09	0	0
library cache pin	168,034,278	0.10	0.01	1	37	0.00
library cache pin allocation	396,520	0.00	0.00	0	0
list of block allocation	416,838	0.02	0.00	0	0
loader state object freelist	226,582	0.00	0.00	0	0
longop free list parent	33	0.00		0	33	0.00
message pool operations parent latch	296,736	0.00	0.09	0	0
messages	5,693,502	0.58	0.01	0	0
mostly latch-free SCN	740,881	3.61	0.00	0	0
multiblock read objects	29,820	0.00	0.00	0	0
ncodef allocation latch	148	0.00		0	0
object queue header heap	3,590,034	0.02	0.18	0	291,753	0.06
object queue header operation	30,038,570	0.12	0.35	1	19,548	0.03
object stats modification	290,818	0.02	0.04	0	0
parallel query alloc buffer	8,160	0.91	0.00	0	0
parallel query stats	528	13.64	0.00	0	0
parameter table allocation management	17,458	1.50	0.50	0	0
post/wait queue	992,771	0.02	0.01	0	400,858	0.01
process allocation	7,676	0.14	0.64	0	3,820	0.10
process group creation	7,628	0.00		0	0
process queue	5,030	0.87	0.00	0	0
process queue reference	756,752	0.05	0.00	0	82,836	0.33
qmn task queue latch	512	0.00		0	0
query server freelists	4,256	5.31	0.00	0	0
query server process	8	0.00		0	8	0.00
redo allocation	4,495,574	1.89	0.01	0	96,103,940	1.64
redo copy	0			0	96,230,155	0.04
redo writing	3,715,113	0.28	0.00	0	0
resmgr group change latch	603,662	0.00		0	0
resmgr:actses active list	22,211	0.37	0.96	0	0
resmgr:actses change group	21,608	0.00		0	0
resmgr:free threads list	15,168	0.31	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	92,538,298	0.18	0.00	0	6,949	0.20
rules engine aggregate statistics	30,613	0.00	0.00	0	0
rules engine rule set statistics	99,568	0.00	0.00	0	0
rules engine rule statistics	38,342	0.00		0	0
sequence cache	15,771,002	0.48	0.00	0	0
session allocation	15,644,913	0.46	0.01	0	0
session idle bit	73,178,655	0.01	0.02	0	0
session state list latch	43,402	0.13	0.53	0	0
session switching	10,704	0.00		0	0
session timer	1,262	0.00		0	0
shared pool	6,138,963	0.14	0.06	0	0
shared pool sim alloc	339	0.00		0	0
shared pool simulator	1,777,095	0.00	0.05	0	0
sim partition latch	1	0.00		0	22,790	0.08
simulator hash latch	2,460	0.00		0	0
simulator lru latch	1,380	0.00		0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	1,010,956	0.09	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	238	0.00		0	0
temporary table state object allocation	9,181	0.00		0	0
threshold alerts latch	605	0.00		0	0
trace latch	30	0.00		0	0
transaction allocation	84,646	0.00	1.00	0	0
transaction branch allocation	148	0.00		0	0
undo global data	828,988,162	1.17	0.00	2	14,249	0.05
user lock	28,402	0.01	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
cache buffers chains	4,319,710,780	38,800,706	791,588	38,085,105	0	0	0
In memory undo latch	665,498,408	14,303,344	21,070	14,285,708	0	0	0
undo global data	828,988,162	9,729,424	9,014	9,721,389	0	0	0
library cache	269,105,458	852,547	6,285	846,920	0	0	0
cache buffer handles	21,859,456	199,007	141	198,885	0	0	0
library cache pin	168,034,278	169,044	1,562	167,652	0	0	0
row cache objects	92,538,298	163,771	488	163,305	0	0	0
redo allocation	4,495,574	84,940	669	84,339	0	0	0
sequence cache	15,771,002	75,043	73	74,981	0	0	0
session allocation	15,644,913	71,635	530	71,146	0	0	0
object queue header operation	30,038,570	34,685	12,076	23,522	0	0	0
messages	5,693,502	33,210	172	33,041	0	0	0
cache buffers lru chain	9,213,963	30,863	855	30,041	0	0	0
mostly latch-free SCN	740,881	26,717	61	26,663	0	0	0
library cache lock	42,912,069	17,846	97	17,753	0	0	0
redo writing	3,715,113	10,360	37	10,323	0	0	0
shared pool	6,138,963	8,412	505	7,954	0	0	0
session idle bit	73,178,655	6,566	113	6,456	0	0	0
active checkpoint queue latch	1,248,873	6,392	23	6,370	0	0	0
channel operations parent latch	1,300,795	5,850	7	5,845	0	0	0
dml lock allocation	3,310,017	5,238	40	5,199	0	0	0
enqueue hash chains	7,382,860	4,395	17	4,379	0	0	0
enqueues	3,946,402	4,084	45	4,040	0	0	0
checkpoint queue latch	17,752,411	2,215	32	2,184	0	0	0
sort extent pool	1,010,956	947	9	938	0	0	0
object queue header heap	3,590,034	707	128	596	0	0	0
Consistent RBA	702,580	408	3	406	0	0	0
parameter table allocation management	17,458	262	130	143	0	0	0
post/wait queue	992,771	239	3	236	0	0	0
channel handle pool latch	292,732	218	4	214	0	0	0
SQL memory manager workarea list latch	5,412,558	207	5	203	0	0	0
SGA IO buffer pool latch	29,708	113	2	111	0	0	0
resmgr:actses active list	22,211	82	79	5	0	0	0
library cache lock allocation	1,131,584	69	6	64	0	0	0
session state list latch	43,402	57	30	29	0	0	0
object stats modification	290,818	56	2	54	0	0	0
dummy allocation	15,170	38	1	37	0	0	0
shared pool simulator	1,777,095	20	1	19	0	0	0
KWQMN job cache list latch	12,048	15	15	0	0	0	0
message pool operations parent latch	296,736	11	1	10	0	0	0
process allocation	7,676	11	7	4	0	0	0
transaction allocation	84,646	1	1	0	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	0	13,960	15,917
In memory undo latch	ktiFlush: child	0	3,863	2,316
In memory undo latch	kticmt: child	0	2,755	590
In memory undo latch	ktichg: child	0	362	2,195
In memory undo latch	ktiTxnPoolFree	0	119	0
In memory undo latch	ktiBRacquire	0	7	0
In memory undo latch	ktbgfc	0	3	56
In memory undo latch	ktuswr	0	1	0
KWQMN job cache list latch	kwqmnuji: update job item	0	15	1
SGA IO buffer pool latch	ksfd_free_sgabuffer	0	2	4
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	4	5
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	1	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	0	23	23
cache buffer handles	kcbzgs	0	89	94
cache buffer handles	kcbzfs	0	52	49
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	1,014,019	1,215,750
cache buffers chains	kcbgtcr: fast path	0	513,498	19,494
cache buffers chains	kcbchg: kslbegin: call CR func	0	249,515	670,873
cache buffers chains	kcbzgb: scan from tail. nowait	0	87,762	0
cache buffers chains	kcbgtcr: kslbegin excl	0	85,160	28,733
cache buffers chains	kcbgcur: kslbegin	0	22,502	10,728
cache buffers chains	kcbrls: kslbegin	0	15,312	41,421
cache buffers chains	kcbget: pin buffer	0	13,190	5,542
cache buffers chains	kcbzwb	0	4,283	4,959
cache buffers chains	kcbcge	0	1,771	4,599
cache buffers chains	kcbget: exchange rls	0	851	585
cache buffers chains	kcbget: exchange	0	354	1,165
cache buffers chains	kcbbxsv	0	329	323
cache buffers chains	kcbnlc	0	176	1,077
cache buffers chains	kcb_is_private	0	116	2,101
cache buffers chains	kcbgtcr: kslbegin shared	0	55	47
cache buffers chains	kcb_pre_apply: kcbhq61	0	50	1,277
cache buffers chains	kcbesc: escalate	0	50	21
cache buffers chains	kcbnew: new latch again	0	41	3
cache buffers chains	kcb_post_apply: kcbhq63	0	27	209
cache buffers chains	kcbso1: set no access	0	10	24
cache buffers chains	kcbbic2	0	4	6
cache buffers chains	kcbw_next_free	0	3	0
cache buffers chains	kcb_post_apply: kcbhq62	0	2	238
cache buffers lru chain	kcbzgws	0	463	0
cache buffers lru chain	kcbbxsv: move to being written	0	164	327
cache buffers lru chain	kcbo_link_q	0	83	16
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	74	0
cache buffers lru chain	kcbzgb: posted for free bufs	0	34	182
cache buffers lru chain	kcbbic2	0	16	168
cache buffers lru chain	kcbo_ivd_proc	0	11	112
cache buffers lru chain	kcbzswcu	0	8	26
cache buffers lru chain	kcbbwlru	0	1	19
cache buffers lru chain	kcbrlb	0	1	2
channel handle pool latch	ksrchconnect()	0	5	4
channel handle pool latch	ksrchdelete()	0	1	2
channel operations parent latch	ksrapublish()	0	7	0
channel operations parent latch	ksrchdelete()	0	3	0
channel operations parent latch	ksrwait()	0	2	10
checkpoint queue latch	kcbkubc	0	12	17
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	10	12
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	8	0
checkpoint queue latch	kcbswcu: Switch buffers	0	2	4
dml lock allocation	ktaiam	0	26	31
dml lock allocation	ktaidm	0	14	9
dummy allocation	ktcdod	0	1	1
enqueue hash chains	ksqrcl	0	10	7
enqueue hash chains	ksqgtl3	0	7	6
enqueues	ksqgel: create enqueue	0	19	9
enqueues	ksqies	0	18	33
enqueues	ksqdel	0	8	3
lgwr LWN SCN	kcs023	0	16	0
library cache	kglpndl: child: after processing	0	2,470	73
library cache	kglpnp: child	0	2,261	3,316
library cache	kglobpn: child:	0	525	948
library cache	kglpndl: child: before processing	0	341	1,524
library cache	kglLockCursor	0	165	194
library cache	kglScanDependency	0	138	0
library cache	kglpin	0	59	22
library cache	kglhdgn: child:	0	54	71
library cache	kgldte: child 0	0	51	103
library cache	kgldti: 2child	0	15	2
library cache	kglic	0	14	0
library cache	kglrtl	0	5	0
library cache	kglhdgc: child:	0	2	0
library cache	kglhdiv: child	0	2	0
library cache	kglivl: child	0	2	0
library cache	kglget: unpin heap 0	0	1	1
library cache	kglupd: child	0	1	0
library cache lock	kgllkdl: child: cleanup	0	56	52
library cache lock	kgllkal: child: multiinstance	0	41	44
library cache lock	kgllkdl: child: no lock handle	0	39	12
library cache lock allocation	kgllkget	0	6	5
library cache pin	kglpndl	0	757	455
library cache pin	kglpnp: child	0	703	880
library cache pin	kglpnal: child: alloc space	0	102	227
message pool operations parent latch	ksrmfree()	0	1	0
messages	ksarcv	0	74	15
messages	ksarcv: after wait	0	74	109
messages	ksaamb: after wakeup	0	24	48
mostly latch-free SCN	kcslcu3	0	45	61
mostly latch-free SCN	kcsnew_scn_rba	0	2	0
mostly latch-free SCN	kcs01	0	1	4
object queue header heap	kcbo_link_q:reget	0	122	5
object queue header heap	kcbw_link_q:alloc	0	3	125
object queue header heap	kcbw_unlink_q	0	3	0
object queue header operation	kcbo_ivbo	0	12,673	2,669
object queue header operation	kcbw_link_q	0	2,320	1,217
object queue header operation	kcbw_unlink_q	0	480	3,938
object queue header operation	kcbo_switch_q_bg	0	256	1,310
object queue header operation	kcbo_switch_mq_bg	0	255	1,891
object queue header operation	kcbo_switch_cq	0	97	1,896
object queue header operation	kcbo_service_ockpt	0	40	2
object queue header operation	kcbo_link_q:reget	0	28	70
object queue header operation	kcbo_write_q	0	24	11
object queue header operation	kcbo_swap_buf_bg	0	7	3,055
object queue header operation	kcbo_swap_buf	0	4	338
object queue header operation	kcbw_unlink_q_bg	0	3	16
object stats modification	ksoslinelm	0	2	1
parameter table allocation management	ksp_param_table_free	0	129	130
parameter table allocation management	kspallmod	0	1	0
post/wait queue	ksliwat:remove	0	3	2
process allocation	ksucrp	0	7	0
redo allocation	kcrfw_redo_gen: redo allocation 1	0	507	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	112	431
redo allocation	kcrfw_redo_gen: redo allocation 2	0	29	0
redo allocation	kcrfw_redo_write: more space	0	11	161
redo allocation	kcrfw_redo_write: before write	0	10	97
redo writing	kcrfwcr	0	27	34
redo writing	kcrfw_post: rba scn pair	0	8	0
redo writing	kcrfw_cal_target_rba	0	1	1
redo writing	kcrfw_post: after write	0	1	2
resmgr:actses active list	kgskchclass	0	79	45
row cache objects	kqreqd: reget	0	369	4
row cache objects	kqrpre: find obj	0	86	427
row cache objects	kqreqd	0	31	56
row cache objects	kqrso	0	1	0
sequence cache	kdnssd	0	47	5
sequence cache	kdnnxt: cached seq	0	23	1
sequence cache	kdnss	0	3	68
session allocation	ksuprc	0	148	98
session allocation	ksuxds: KSUSFCLC not set	0	142	17
session allocation	ksudlc	0	110	118
session allocation	ksucri	0	55	199
session allocation	ksuxds: not user session	0	40	69
session allocation	kspallmod	0	17	0
session allocation	kxfpqidqr	0	8	6
session allocation	ksursi	0	5	19
session allocation	ksudlp	0	3	2
session allocation	kxfprdp	0	1	1
session idle bit	ksupuc: set busy	0	75	64
session idle bit	ksupuc: clear busy	0	65	66
session idle bit	ksuxds	0	1	11
session state list latch	kpseqd	0	27	0
session state list latch	kpscad	0	3	1
shared pool	kghupr1	0	269	380
shared pool	kghalo	0	186	71
shared pool	kghfrunp: clatch: nowait	0	130	0
shared pool	kghfrunp: alloc: wait	0	29	2
shared pool	kghfre	0	16	46
shared pool	kghfrunp: clatch: wait	0	11	18
shared pool	kghalp	0	4	5
shared pool	kghfrunp: alloc: session dur	0	1	0
shared pool simulator	kglsim_unpin_simhp	0	1	1
sort extent pool	ktstdt: dealloc sort extent	0	6	2
sort extent pool	ktstdt: return extent	0	2	0
sort extent pool	ktstsmonmsg	0	1	8
transaction allocation	ktcdso	0	1	0
undo global data	kturimugur: child	0	8,325	6,888
undo global data	ktudba: KSLBEGIN	0	648	2,101
undo global data	ktucof: at start	0	12	0
undo global data	ktudnx:child	0	11	11
undo global data	ktufrbs: child	0	9	11
undo global data	ktubnd:child	0	5	2
undo global data	ktusmasp: ktugd_tuux	0	4	2

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 1,822,426,758
• Captured Segments account for 31.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	66,664,416	3.66
INV	APPS_TS_TX_IDX	MTL_ITEM_CATEGORIES_U1		INDEX	50,123,648	2.75
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	21,682,960	1.19
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	19,949,712	1.09
GL	APPS_TS_TX_DATA	GL_CODE_COMBINATIONS		TABLE	18,971,056	1.04

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 428,196
• Captured Segments account for 17.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	35,070	8.19
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	13,037	3.04
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	9,555	2.23
HR	APPS_TS_TX_IDX	PAY_PERSON_LATEST_BALA_N50		INDEX	4,777	1.12
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS		TABLE	4,050	0.95

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	11,186	29.61
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	9,421	24.94
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS		TABLE	7,200	19.06
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	2,591	6.86
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	1,690	4.47

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	26	43.33
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N1		INDEX	7	11.67
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	7	11.67
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N1		INDEX	4	6.67
GL	APPS_ASSM_IDX	GL_INTERFACE_N2		INDEX	3	5.00

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	136,648	39.25
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	62,165	17.85
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	18,646	5.36
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	16,718	4.80
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ACTIVITY_STATUSES	WF_ITEM49	TABLE PARTITION	15,601	4.48

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.22	0		648	0
dc_files	6,660	0.00	0		0	111
dc_global_oids	5,470,223	0.00	0		0	43
dc_histogram_data	5,933	9.94	0		0	586
dc_histogram_defs	315,378	3.08	0		4,044	3,420
dc_object_grants	51,192	0.07	0		0	78
dc_object_ids	9,172,402	0.02	0		58	1,275
dc_objects	134,353	1.34	0		347	783
dc_profiles	7,139	0.00	0		0	1
dc_rollback_segments	22,350	0.03	0		21	278
dc_segments	273,220	0.89	0		14,869	1,307
dc_sequences	46,367	0.14	0		46,367	106
dc_table_scns	16,848	0.05	0		0	5
dc_tablespace_quotas	14,713	0.16	0		211	40
dc_tablespaces	4,551,389	0.00	0		0	22
dc_usernames	368,834	0.01	0		0	19
dc_users	10,775,892	0.00	0		0	63
outstanding_alerts	268	0.75	0		1	43

Back to Top

 

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	469,281	0.03	32,111,698	0.00	9	0
CLUSTER	97	1.03	245	1.22	2	0
INDEX	11,177	0.57	11,989	0.78	0	0
JAVA DATA	624	0.00	0		0	0
PIPE	35,634	2.55	52,246	1.74	0	0
SQL AREA	5,527	90.74	91,054,297	0.19	2,744	378
TABLE/PROCEDURE	297,025	0.34	44,389,425	0.01	1,161	0
TRIGGER	21,190	0.13	1,256,875	0.00	32	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	25,922.54		11.23	6.66	37	37	2,309	2,309
	Freeable	2,435.19	0.00	1.23	0.78	9		1,980	1,980
	SQL	2,424.65	1,243.18	1.05	0.69	4	21	2,301	2,299
	PL/SQL	1,657.80	139.40	0.72	0.93	3	3	2,309	2,309
	JAVA	185.97	185.14	2.21	0.35	5	8	84	84
E	Other	32,046.01		13.77	8.36	41	41	2,328	2,328
	Freeable	3,128.94	0.00	1.51	0.93	9		2,071	2,071
	SQL	2,904.33	1,522.47	1.25	0.76	5	21	2,320	2,318
	PL/SQL	1,975.19	162.05	0.85	0.97	3	3	2,328	2,328
	JAVA	185.93	185.09	2.21	0.35	5	8	84	84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	19,092,471,808	18,924,699,648
Fixed Size	2,111,120
Redo Buffers	14,663,680
Variable Size	2,365,589,872	2,533,362,032

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	51.29	51.29	0.00
java	joxlod exec hp	12.09	12.09	0.00
large	free memory	15.94	15.94	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	32.47	32.96	1.53
shared	KTI-UNDO	53.19	53.19	0.00
shared	PCursor	21.79		-100.00
shared	PL/SQL MPCODE	66.75	69.42	4.00
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	319.84	346.24	8.25
shared	library cache	603.66	735.85	21.90
shared	parameter table block	41.98	42.13	0.37
shared	private strands	99.77	99.77	0.00
shared	sessions	36.42	36.42	0.00
shared	sql area	334.19	337.34	0.94
shared	trace buffer	36.14	36.61	1.30
	buffer_cache	18,208.00	18,048.00	-0.88
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.98	13.98	0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

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

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.

Back to Top

 

init.ora Parameters

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_b_tree_bitmap_plans	FALSE
_fast_full_scan_enabled	FALSE
_like_with_bind_as_equality	TRUE
_sort_elimination_cost_ratio	5
_sqlexec_progression_cost	2147483647
_swrf_mmon_dbfus	FALSE
_swrf_mmon_flush	FALSE
_system_trig_enabled	TRUE
aq_tm_processes	1
background_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/bdump
compatible	10.2.0.3
control_files	/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