	Worldwide
	Secure Search
Home Products and Services Industries Support Store Partners Communities About

ORACLE CORPORATION

Legal | Privacy

AWR Report

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 12-Oct-08 06:54:16 5248 209.7

End Snap: 2 12-Oct-08 07:54:20 5279 233.7

Elapsed: 60.07 (mins)

DB Time: 402.20 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 17,840M 17,664M Std Block Size: 8K

Shared Pool Size: 2,544M 2,720M Log Buffer: 14,320K

Load Profile

Per Second Per Transaction

Redo size: 8,965,674.41 25,811.01

Logical reads: 603,590.49 1,737.66

Block changes: 55,951.78 161.08

Physical reads: 126.25 0.36

Physical writes: 876.75 2.52

User calls: 13,804.32 39.74

Parses: 2,559.98 7.37

Hard parses: 2.60 0.01

Sorts: 3,061.58 8.81

Logons: 2.83 0.01

Executes: 29,127.33 83.85

Transactions: 347.36

% Blocks changed per Read: 9.27 Recursive Call %: 77.32

Rollback per transaction %: 21.17 Rows per Sort: 12.33

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00

Buffer Hit %: 99.98 In-memory Sort %: 100.00

Library Hit %: 99.77 Soft Parse %: 99.90

Execute to Parse %: 91.21 Latch Hit %: 99.07

Parse CPU to Parse Elapsd %: 89.50 % Non-Parse CPU: 97.75

Shared Pool Statistics

Begin End

Memory Usage %: 86.77 86.99

% SQL with executions>1: 88.86 89.86

% Memory for SQL w/exec>1: 65.62 66.52

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 21,827 90.4

db file sequential read 288,326 1,193 4 4.9 User I/O

log file sync 564,710 1,039 2 4.3 Commit

log file parallel write 845,228 518 1 2.1 System I/O

db file parallel write 263,319 237 1 1.0 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

Time Model Statistics

Total time in database user-calls (DB Time): 24132.2s
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	21,826.70	90.45
sql execute elapsed time	20,354.04	84.34
PL/SQL execution elapsed time	4,871.72	20.19
inbound PL/SQL rpc elapsed time	4,655.40	19.29
parse time elapsed	620.36	2.57
Java execution elapsed time	516.68	2.14
hard parse elapsed time	333.01	1.38
repeated bind elapsed time	91.46	0.38
sequence load elapsed time	14.50	0.06
connection management call elapsed time	10.73	0.04
PL/SQL compilation elapsed time	7.34	0.03
hard parse (sharing criteria) elapsed time	4.37	0.02
failed parse elapsed time	1.59	0.01
hard parse (bind mismatch) elapsed time	1.10	0.00
DB time	24,132.24
background elapsed time	1,228.46
background cpu time	392.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	340,388	0.00	1,342	4	0.27
Commit	564,710	0.00	1,039	2	0.45
System I/O	1,139,449	0.00	767	1	0.91
Network	56,742,775	0.00	224	0	45.32
Concurrency	1,825,463	0.24	181	0	1.46
Application	70,759	0.06	166	2	0.06
Other	135,593	18.81	48	0	0.11
Configuration	6,576	0.00	3	0	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	288,326	0.00	1,193	4	0.23
log file sync	564,710	0.00	1,039	2	0.45
log file parallel write	845,228	0.00	518	1	0.68
db file parallel write	263,319	0.00	237	1	0.21
SQL*Net more data from client	2,573,124	0.00	155	0	2.06
enq: TX - row lock contention	696	3.59	96	138	0.00
db file scattered read	12,612	0.00	82	7	0.01
read by other session	36,504	0.00	64	2	0.03
SQL*Net message to client	52,124,870	0.00	53	0	41.63
enq: UL - contention	2,425	0.58	52	21	0.00
latch: cache buffers chains	1,064,936	0.00	50	0	0.85
cursor: pin S wait on X	4,719	92.27	48	10	0.00
buffer busy waits	670,862	0.00	30	0	0.54
SQL*Net more data to client	2,044,781	0.00	17	0	1.63
SQL*Net break/reset to client	67,604	0.00	14	0	0.05
library cache load lock	573	0.00	12	22	0.00
latch: In memory undo latch	34,220	0.00	12	0	0.03
enq: TX - index contention	27,898	0.00	11	0	0.02
control file sequential read	29,164	0.00	11	0	0.02
PX Deq Credit: send blkd	24,269	0.00	11	0	0.02
latch: library cache	12,067	0.00	10	1	0.01
rdbms ipc reply	5	60.00	8	1589	0.00
latch: undo global data	13,765	0.00	8	1	0.01
enq: RO - fast object reuse	31	0.00	5	153	0.00
LGWR wait for redo copy	33,643	0.01	4	0	0.03
latch: object queue header operation	20,956	0.00	3	0	0.02
PX Deq: Signal ACK	267	35.21	3	11	0.00
kksfbc child completion	65	86.15	3	43	0.00
latch: library cache pin	3,293	0.00	2	1	0.00
os thread startup	70	0.00	2	33	0.00
local write wait	1,702	0.00	2	1	0.00
latch: cache buffers lru chain	1,816	0.00	2	1	0.00
enq: HW - contention	2,380	0.00	2	1	0.00
control file parallel write	1,738	0.00	1	1	0.00
enq: DV - contention	184	0.00	1	6	0.00
buffer deadlock	25,349	98.80	1	0	0.02
latch: row cache objects	1,026	0.00	1	1	0.00
enq: TX - contention	2,726	0.00	1	0	0.00
latch: redo allocation	1,262	0.00	1	1	0.00
latch free	1,130	0.00	1	1	0.00
enq: SQ - contention	3,985	0.00	1	0	0.00
library cache pin	2,020	0.00	1	0	0.00
latch: session allocation	891	0.00	0	1	0.00
wait list latch free	42	0.00	0	12	0.00
log buffer space	74	0.00	0	7	0.00
row cache lock	2,585	0.00	0	0	0.00
direct path read	732	0.00	0	0	0.00
SGA: allocation forcing component growth	31	51.61	0	10	0.00
latch: shared pool	784	0.00	0	0	0.00
cursor: pin S	7,252	0.00	0	0	0.01
latch: library cache lock	200	0.00	0	1	0.00
latch: object queue header heap	268	0.00	0	1	0.00
latch: cache buffer handles	281	0.00	0	1	0.00
enq: FB - contention	781	0.00	0	0	0.00
enq: TX - allocate ITL entry	84	0.00	0	1	0.00
enq: TM - contention	3	0.00	0	23	0.00
latch: messages	117	0.00	0	0	0.00
latch: enqueue hash chains	39	0.00	0	1	0.00
latch: redo writing	46	0.00	0	1	0.00
PX qref latch	349	84.53	0	0	0.00
write complete waits	7	0.00	0	4	0.00
reliable message	32	0.00	0	1	0.00
latch: checkpoint queue latch	39	0.00	0	1	0.00
enq: CU - contention	3	0.00	0	6	0.00
cursor: mutex S	119	0.00	0	0	0.00
enq: PS - contention	29	0.00	0	0	0.00
direct path write	440	0.00	0	0	0.00
direct path write temp	52	0.00	0	0	0.00
cursor: mutex X	91	0.00	0	0	0.00
direct path read temp	20	0.00	0	0	0.00
L1 validation	2	0.00	0	0	0.00
SQL*Net message from client	52,124,829	0.00	10,080,153	193	41.63
pipe get	29,425	14.84	21,059	716	0.02
Streams AQ: waiting for time management or cleanup tasks	2,947	40.11	3,508	1190	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,505	27170	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,505	13585	0.00
PX Idle Wait	1,620	76.05	2,544	1570	0.00
PL/SQL lock timer	214	100.00	2,422	11318	0.00
jobq slave wait	614	99.67	1,798	2928	0.00
PX Deq: Execution Msg	5,130	0.00	39	8	0.00
PX Deq: Execute Reply	2,634	0.04	3	1	0.00
PX Deq: Table Q Normal	6,559	0.00	1	0	0.01
PX Deq Credit: need buffer	4,120	0.00	1	0	0.00
PX Deq: Msg Fragment	4,370	0.00	1	0	0.00
PX Deq: Parse Reply	220	0.00	0	1	0.00
PX Deq: Join ACK	288	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	845,239	0.00	518	1	0.68
db file parallel write	263,319	0.00	237	1	0.21
events in waitclass Other	41,573	0.01	6	0	0.03
control file sequential read	827	0.00	3	4	0.00
db file scattered read	524	0.00	2	4	0.00
os thread startup	62	0.00	2	34	0.00
control file parallel write	1,738	0.00	1	1	0.00
db file sequential read	189	0.00	0	3	0.00
direct path read	732	0.00	0	0	0.00
latch: cache buffers chains	101	0.00	0	1	0.00
latch: redo writing	46	0.00	0	1	0.00
direct path write	333	0.00	0	0	0.00
log file sync	1	0.00	0	1	0.00
buffer busy waits	6	0.00	0	0	0.00
latch: library cache	3	0.00	0	0	0.00
latch: shared pool	1	0.00	0	0	0.00
enq: TX - index contention	1	0.00	0	0	0.00
rdbms ipc message	1,471,029	0.83	37,517	26	1.17
pmon timer	1,355	89.67	3,510	2590	0.00
Streams AQ: waiting for time management or cleanup tasks	2,947	40.11	3,508	1190	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,505	27170	0.00
Streams AQ: qmn coordinator idle wait	258	50.00	3,505	13585	0.00
smon timer	155,770	0.00	3,502	22	0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,340,446
IDLE_TIME	3,427,142
IOWAIT_TIME	86,124
NICE_TIME	0
SYS_TIME	105,856
USER_TIME	2,167,330
LOAD	5
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	47,441,896
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	24,132.80	21,827.50	440,237	2,171,880,803
SYS$BACKGROUND	0.00	0.00	14,836	3,810,354
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	338599	133866	1825283	17856	0	0	56726516	22442
SYS$BACKGROUND	1783	293	174	218	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

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
778	756	305	2.55	3.23	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
489	442	112,954	0.00	2.03	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
393	381	1,442	0.27	1.63	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
393	387	57,209	0.01	1.63	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
374	368	57,209	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
363	357	64,014	0.01	1.50	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
351	349	376,368	0.00	1.46	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
336	330	57,208	0.01	1.39	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
266	264	50,491	0.01	1.10	6ubqcscr1gk1b	asnDispContainer.jsp	select name, value from icx_s...
260	168	21,632	0.01	1.08	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
245	236	81,143	0.00	1.02	3prk3vg9u0abb	FNDOAMCOL	BEGIN FND_GLOBAL.APPS_INITIA...

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
756	778	305	2.48	3.23	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
442	489	112,954	0.00	2.03	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
387	393	57,209	0.01	1.63	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
381	393	1,442	0.26	1.63	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
368	374	57,209	0.01	1.55	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
357	363	64,014	0.01	1.50	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
349	351	376,368	0.00	1.46	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
330	336	57,208	0.01	1.39	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
264	266	50,491	0.01	1.10	6ubqcscr1gk1b	asnDispContainer.jsp	select name, value from icx_s...
236	245	81,143	0.00	1.02	3prk3vg9u0abb	FNDOAMCOL	BEGIN FND_GLOBAL.APPS_INITIA...
168	260	21,632	0.01	1.08	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...

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,175,631,664
Captured SQL account for 11.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
67,521,820	157,212	429.50	3.10	189.39	195.53	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
47,778,840	57,209	835.16	2.20	387.35	393.10	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
44,057,728	305	144,451.57	2.03	756.00	778.30	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
40,732,914	1,442	28,247.51	1.87	381.18	393.17	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,531,517	12,882	3,146.37	1.86	108.95	110.68	by2f4fw8tac6r	ARXTWMAI	UPDATE RA_CUST_TRX_LINE_GL_DIS...
38,378,724	64,014	599.54	1.76	356.52	362.53	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
36,334,911	57,208	635.14	1.67	330.36	335.53	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
32,907,280	1,583,361	20.78	1.51	131.75	134.87	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
30,158,201	57,209	527.16	1.39	368.43	374.48	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
29,494,405	174,074	169.44	1.36	159.24	161.53	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
29,490,902	174,072	169.42	1.36	147.48	149.74	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
26,397,986	10,000	2,639.80	1.21	81.94	179.45	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
25,939,062	202,546	128.07	1.19	208.05	240.27	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
24,842,131	50,491	492.01	1.14	263.93	265.58	6ubqcscr1gk1b	asnDispContainer.jsp	select name, value from icx_s...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 455,068
Captured SQL account for 25.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,241	10,000	4.52	9.94	81.94	179.45	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
36,956	2,403	15.38	8.12	13.87	173.86	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
31,252	2,403	13.01	6.87	107.79	234.70	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
24,629	21,632	1.14	5.41	167.77	260.25	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
10,762	722	14.91	2.36	88.29	129.98	dk0sqcvc2xjvs	qotSCopHdrUpd.jsp	BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,982	7,214	1.38	2.19	117.59	165.10	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
9,946	202,546	0.05	2.19	208.05	240.27	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,595	10,000	0.46	1.01	129.63	143.40	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
1,445	100,962	0.01	0.32	120.40	124.65	7dtkxnqpkqszw	jtfavald.jsp	SELECT DISTINCT a.PERMISSION_...
1,180	361	3.27	0.26	148.55	154.02	fumydqvpk1g21	qotSCopOverview.jsp	BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 104,988,965
Captured SQL account for 7.3% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
1,583,361	818,323	0.52	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
895,297	895,297	1.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
597,434	597,430	1.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
376,368	376,366	1.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
343,833	262,488	0.76	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
291,434	4,954,301	17.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
202,546	202,545	1.00	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
174,074	174,074	1.00	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
174,072	174,072	1.00	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
174,071	174,071	1.00	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 9,227,403
Captured SQL account for 42.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
597,439	597,434	6.47	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
376,365	376,368	4.08	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
343,822	343,833	3.73	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
291,436	291,434	3.16	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
202,546	202,546	2.20	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
174,075	174,071	1.89	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
125,250	125,248	1.36	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
120,438	120,439	1.31	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
116,865	116,865	1.27	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
111,419	111,419	1.21	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
101,282	101,281	1.10	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
95,287	95,287	1.03	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
95,287	95,285	1.03	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...
95,287	101,280	1.03	dcvv68fju01g4	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.E...

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,752,544	1,203	0.06	2nfc4vng01c8t	POXPOVPO	SELECT END_DATE, START_DATE, R...

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;

2nfc4vng01c8t SELECT END_DATE, START_DATE, ROW_ID, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PO_NUM, RELEASE_NUM, RELEASE_TYPE, REVISED_DATE, APPROVED_DATE, BILL_TO_LOCATION_ID, BILL_TO_LOCATION, AGENT_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_CONTACT, AUTHORIZATION_STATUS, NEED_BY_DATE, REVISION_NUM, DOC_TYPE_NAME, GLOBAL_AGREEMENT_FLAG, OWNING_ORG_ID, TYPE_LOOKUP_CODE, ORDER_DATE, CURRENCY_CODE, TERMS_NAME, SHIP_VIA_LOOKUP_CODE, HEADER_FOB_LOOKUP_CODE, HEADER_FREIGHT_TERMS_LC, RATE_TYPE, RATE_DATE, RATE, PLL_NOTE_TO_RECEIVER, CONFIRMING_ORDER_FLAG, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, ITEM_ID, ITEM_REVISION, JOB_ID, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, UN_NUMBER, HAZARD_CLASS, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, NOTE_TO_VENDOR, UNORDERED_FLAG, VENDOR_PRODUCT_NUM, CONTRACT_ID, MIN_RELEASE_AMOUNT, PO_HEADER_ID, PO_RELEASE_ID, CLOSED_BY, CANCELLED_BY, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, CREATION_DATE, QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT, AMOUNT_RECEIVED, AMOUNT_BILLED, AMOUNT_CANCELLED, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION, PROMISED_DATE, LAST_ACCEPT_DATE, PRICE_OVERRIDE, ENCUMBERED_FLAG, TAXABLE_FLAG, TAX_NAME, CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, MATCHING_TYPE, MATCH_OPTION, COUNTRY_OF_ORIGIN, QTY_RCV_TOLERANC E, QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION, SOURCE_SHIPMENT_ID, SHIPMENT_TYPE, CLOSED_CODE, RECEIVING_ROUTING_ID, ROUTING_NAME, ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON, CLOSED_DATE, SOURCE_SHIPMENT_NUM, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY, USSGL_TRANSACTION_CODE, ACCEPTANCE_DUE_DATE, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_CANCELLED, VMI_FLAG, CONSIGNED_FLAG, CONSIGNED_CONSUMPTION_FLAG, AUTO_PRICED_FLAG FROM PO_LINE_LOCATIONS_INQ_V WHERE (:1 = agent_id OR EXISTS ( SELECT 'This employee is in approval path of this doc' FROM PO_ACTION_HISTORY POAH2 WHERE POAH2.employee_id + 0 = :2 AND POAH2.object_type_code in ('PO', 'PA') AND POAH2.object_id = po_header_id) OR( ((type_lookup_code = 'STANDARD') AND (release_num is null)) AND ( ( :3 = 'PUBLIC') OR ( :4 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id =:5 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :6 = 'HIERARCHY' AND :7 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :8 , -1) )) ) ) OR( ((type_lookup_code = 'PLANNED') AND (release_num is null)) AND ( ( :9 = 'PUBLIC') OR ( :10 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :11 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :12 = 'HIERARCHY' AND :13 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :14 , -1) )) ) ) OR( ((type_lookup_code = 'BLANKET') AND (release_num is null)) AND ( ( :15 = 'PUBLIC') OR ( :16 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :17 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :18 = 'HIERARCHY' AND :19 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :20 , -1) )) ) )OR( release_type = 'BLANKET' AND ( ( :21 = 'PUBLIC') OR ( :22 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :23 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :24 = 'HIERARCHY' AND :25 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIE S POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :26 , -1) )) ) )OR( release_type = 'SCHEDULED' AND ( ( :27 = 'PUBLIC') OR ( :28 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :29 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :30 = 'HIERARCHY' AND :31 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :32 , -1) )) ) )OR (:33 = 'Y')) AND -1=-1 and (po_line_locations_inq_v.owning_org_id = decode(po_line_locations_inq_v.global_agreement_flag, 'Y', po_line_locations_inq_v.owning_org_id, 204) ) and (RELEASE_TYPE IS NULL) and (PO_HEADER_ID=:34) and (PO_LINE_ID=:35) order by po_header_id desc, release_num desc, line_num, shipment_num

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;

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;

6ubqcscr1gk1b select name, value from icx_session_attributes where session_id = :1

76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;

7dtkxnqpkqszw SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = 1 AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = 0 AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=1 AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME

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;

by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )

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

fumydqvpk1g21 BEGIN ASO_QUOTE_PUB_W.SUBMIT_Quote(x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_q_quote_header_id => :4, p_q_last_update_date => :5, p_q_quote_expiration_date => :6, p_sc_book_flag => :7, p_sc_reserve_flag => :8, p_sc_calculate_price => :9, p_sc_server_id => :10, x_order_number => :11, x_order_header_id => :12, x_order_request_id => :13, x_contract_id => :14, x_status => :15 ); END;

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	2,149,370	596.30	1.72
CPU used when call started	2,144,665	595.00	1.71
CR blocks created	16,969,997	4,708.03	13.55
Cached Commit SCN referenced	48,318	13.40	0.04
Commit SCN cached	8	0.00	0.00
DB time	5,155,069	1,430.18	4.12
DBWR checkpoint buffers written	3,069,971	851.71	2.45
DBWR checkpoints	34	0.01	0.00
DBWR object drop buffers written	57,150	15.86	0.05
DBWR revisited being-written buffer	154	0.04	0.00
DBWR thread checkpoint buffers written	676,455	187.67	0.54
DBWR transaction table writes	2,553	0.71	0.00
DBWR undo block writes	1,624,676	450.74	1.30
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	45,125,573	12,519.29	36.04
IMU Flushes	359,900	99.85	0.29
IMU Redo allocation size	2,391,286,496	663,420.11	1,909.90
IMU commits	647,895	179.75	0.52
IMU contention	39,821	11.05	0.03
IMU ktichg flush	11,323	3.14	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1,777	0.49	0.00
IMU undo allocation size	5,745,000,064	1,593,848.57	4,588.48
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	53,212	14.76	0.04
PX local messages sent	53,212	14.76	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,111,573	14,457.43	41.62
active txn count during cleanout	133,212,031	36,957.32	106.40
application wait time	16,632	4.61	0.01
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,899	3.86	0.01
branch node splits	1,085	0.30	0.00
buffer is not pinned count	599,501,052	166,320.95	478.82
buffer is pinned count	1,548,896,796	429,714.00	1,237.09
bytes received via SQL*Net from client	11,411,101,651	3,165,808.15	9,113.95
bytes sent via SQL*Net to client	10,345,017,534	2,870,041.98	8,262.48
calls to get snapshot scn: kcmgss	117,848,380	32,694.95	94.12
calls to kcmgas	21,181,916	5,876.55	16.92
calls to kcmgcs	13,394,422	3,716.05	10.70
change write time	46,169	12.81	0.04
cleanout - number of ktugct calls	28,706,596	7,964.14	22.93
cleanouts and rollbacks - consistent read gets	14,838,241	4,116.61	11.85
cleanouts only - consistent read gets	157,091	43.58	0.13
cluster key scan block gets	874,059	242.49	0.70
cluster key scans	239,613	66.48	0.19
commit batch/immediate performed	4,379	1.21	0.00
commit batch/immediate requested	4,379	1.21	0.00
commit cleanout failures: block lost	260,501	72.27	0.21
commit cleanout failures: buffer being written	1,090	0.30	0.00
commit cleanout failures: callback failure	109,958	30.51	0.09
commit cleanout failures: cannot pin	33,336	9.25	0.03
commit cleanouts	9,699,965	2,691.08	7.75
commit cleanouts successfully completed	9,295,080	2,578.76	7.42
commit immediate performed	4,379	1.21	0.00
commit immediate requested	4,379	1.21	0.00
commit txn count during cleanout	1,393,024	386.47	1.11
concurrency wait time	18,074	5.01	0.01
consistent changes	871,572,434	241,802.34	696.12
consistent gets	1,948,547,771	540,590.08	1,556.29
consistent gets - examination	1,392,187,538	386,237.79	1,111.93
consistent gets from cache	1,948,547,735	540,590.07	1,556.29
cursor authentications	2,101	0.58	0.00
data blocks consistent reads - undo records applied	867,256,758	240,605.03	692.67
db block changes	201,677,243	55,951.78	161.08
db block gets	227,082,909	63,000.13	181.37
db block gets direct	4,340	1.20	0.00
db block gets from cache	227,078,569	62,998.93	181.37
deferred (CURRENT) block cleanout applications	1,679,123	465.84	1.34
dirty buffers inspected	10,214	2.83	0.01
doubling up with imu segment	0	0.00	0.00
enqueue conversions	10,426	2.89	0.01
enqueue releases	4,693,210	1,302.05	3.75
enqueue requests	4,699,430	1,303.77	3.75
enqueue timeouts	6,120	1.70	0.00
enqueue waits	34,568	9.59	0.03
exchange deadlocks	25,349	7.03	0.02
execute count	104,988,965	29,127.33	83.85
failed probes on index block reclamation	13,553	3.76	0.01
frame signature mismatch	308	0.09	0.00
free buffer inspected	3,180,710	882.43	2.54
free buffer requested	21,533,959	5,974.22	17.20
heap block compress	34,348,320	9,529.33	27.43
hot buffers moved to head of LRU	1,347,251	373.77	1.08
immediate (CR) block cleanout applications	14,995,338	4,160.19	11.98
immediate (CURRENT) block cleanout applications	1,164,091	322.96	0.93
index crx upgrade (found)	17,172	4.76	0.01
index crx upgrade (positioned)	10,507,595	2,915.15	8.39
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	784	0.22	0.00
index fetch by key	189,752,382	52,643.44	151.55
index scans kdiixs1	141,918,759	39,372.85	113.35
java call heap collected bytes	1,509,438,192	418,766.91	1,205.58
java call heap collected count	18,447,733	5,118.00	14.73
java call heap gc count	4,895	1.36	0.00
java call heap live object count	1,555,617	431.58	1.24
java call heap live object count max	1,559,673	432.70	1.25
java call heap live size	394,887,216	109,554.47	315.39
java call heap live size max	395,530,624	109,732.97	315.91
java call heap object count	3,821,286	1,060.15	3.05
java call heap object count max	3,829,630	1,062.46	3.06
java call heap total size	513,146,880	142,363.52	409.85
java call heap total size max	513,675,264	142,510.11	410.27
java call heap used size	539,841,400	149,769.44	431.17
java call heap used size max	540,856,144	150,050.96	431.98
leaf node 90-10 splits	21,126	5.86	0.02
leaf node splits	248,796	69.02	0.20
lob reads	23,585	6.54	0.02
lob writes	41,328	11.47	0.03
lob writes unaligned	41,328	11.47	0.03
logons cumulative	10,190	2.83	0.01
messages received	1,816,303	503.90	1.45
messages sent	1,816,303	503.90	1.45
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	504,792,461	140,045.73	403.17
opened cursors cumulative	6,000,675	1,664.78	4.79
parse count (failures)	3,604	1.00	0.00
parse count (hard)	9,357	2.60	0.01
parse count (total)	9,227,403	2,559.98	7.37
parse time cpu	49,102	13.62	0.04
parse time elapsed	54,860	15.22	0.04
physical read IO requests	301,638	83.68	0.24
physical read bytes	3,727,917,056	1,034,244.59	2,977.46
physical read total IO requests	330,914	91.81	0.26
physical read total bytes	4,206,657,536	1,167,062.67	3,359.82
physical read total multi block requests	12,622	3.50	0.01
physical reads	455,068	126.25	0.36
physical reads cache	453,716	125.88	0.36
physical reads cache prefetch	152,830	42.40	0.12
physical reads direct	1,352	0.38	0.00
physical reads direct temporary tablespace	620	0.17	0.00
physical reads prefetch warmup	84,001	23.30	0.07
physical write IO requests	1,524,329	422.90	1.22
physical write bytes	25,888,628,736	7,182,341.75	20,677.03
physical write total IO requests	2,783,136	772.13	2.22
physical write total bytes	59,717,275,648	16,567,500.98	47,695.68
physical write total multi block requests	1,451,791	402.77	1.16
physical writes	3,160,233	876.75	2.52
physical writes direct	5,293	1.47	0.00
physical writes direct (lob)	223	0.06	0.00
physical writes direct temporary tablespace	4,674	1.30	0.00
physical writes from cache	3,154,940	875.28	2.52
physical writes non checkpoint	2,383,804	661.34	1.90
pinned buffers inspected	3,879	1.08	0.00
prefetch warmup blocks aged out before use	250,316	69.45	0.20
prefetched blocks aged out before use	120	0.03	0.00
process last non-idle time	3,603	1.00	0.00
queries parallelized	48	0.01	0.00
recursive calls	169,672,852	47,072.73	135.52
recursive cpu usage	1,195,064	331.55	0.95
redo blocks written	65,904,619	18,284.07	52.64
redo buffer allocation retries	75	0.02	0.00
redo entries	103,890,480	28,822.57	82.98
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,300,957	360.93	1.04
redo size	32,316,620,996	8,965,674.41	25,811.01
redo subscn max counts	2,411,018	668.89	1.93
redo synch time	106,368	29.51	0.08
redo synch writes	2,431,769	674.65	1.94
redo wastage	322,824,600	89,561.97	257.84
redo write time	56,636	15.71	0.05
redo writer latching time	353	0.10	0.00
redo writes	845,278	234.51	0.68
rollback changes - undo records applied	219,821	60.99	0.18
rollbacks only - consistent read gets	2,281,421	632.94	1.82
rows fetched via callback	100,286,545	27,822.73	80.10
session connect time	0	0.00	0.00
session cursor cache hits	5,778,135	1,603.04	4.61
session logical reads	2,175,631,664	603,590.49	1,737.66
session pga memory	10,448,054,784	2,898,627.84	8,344.77
session pga memory max	11,652,062,432	3,232,658.45	9,306.40
session uga memory	###############	75,152,022.18	216,352.88
session uga memory max	74,490,488,024	20,666,067.23	59,494.91
shared hash latch upgrades - no wait	32,899,686	9,127.44	26.28
shared hash latch upgrades - wait	32,994	9.15	0.03
sorts (memory)	11,035,416	3,061.58	8.81
sorts (rows)	136,025,515	37,737.87	108.64
sql area evicted	2,671	0.74	0.00
sql area purged	3,774	1.05	0.00
summed dirty queue length	503,581	139.71	0.40
switch current to new buffer	1,426,178	395.67	1.14
table fetch by rowid	918,034,884	254,692.53	733.23
table fetch continued row	33,657,601	9,337.71	26.88
table scan blocks gotten	99,038,642	27,476.52	79.10
table scan rows gotten	8,250,799,368	2,289,038.22	6,589.84
table scans (long tables)	2,046	0.57	0.00
table scans (rowid ranges)	2,044	0.57	0.00
table scans (short tables)	6,225,139	1,727.05	4.97
total number of times SMON posted	155,750	43.21	0.12
transaction rollbacks	4,379	1.21	0.00
transaction tables consistent read rollbacks	81	0.02	0.00
transaction tables consistent reads - undo records applied	4,843	1.34	0.00
undo change vector size	11,304,214,864	3,136,154.30	9,028.58
user I/O wait time	134,178	37.23	0.11
user calls	49,757,427	13,804.32	39.74
user commits	987,013	273.83	0.79
user rollbacks	265,035	73.53	0.21
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	6,629,910	1,839.35	5.30
write clones created in background	1,698	0.47	0.00
write clones created in foreground	7,437	2.06	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	554,121	1,271,490
opened cursors current	1,100,695	1,233,499
workarea memory allocated	176	1,358
logons current	5,248	5,279

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

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	32	0	12.19	1.00	715,894	199	259,551	0.04
APPS_TS_TX_DATA	177,552	49	4.30	1.30	215,501	60	127,081	0.21
APPS_TS_TX_IDX	97,990	27	4.46	1.32	228,272	63	60,992	0.33
APPS_ASSM_DATA	8,833	2	2.27	6.49	155,050	43	42,386	0.39
APPS_ASSM_IDX	6,827	2	2.36	1.04	139,136	39	175,621	0.10
APPS_TS_TX_INTERFACE	1,193	0	2.90	2.10	33,840	9	16,519	0.03
TEMP	513	0	4.33	9.98	10,307	3	91	4.07
APPS_TS_SUMMARY	59	0	8.98	1.00	8,390	2	1,975	0.04
SYSTEM	5,395	1	3.93	3.45	2,755	1	21,755	0.07
APPS_TS_SEED	2,317	1	6.08	1.65	5,678	2	850	2.18
APPS_TS_QUEUES	386	0	5.39	2.12	5,699	2	428	0.28
APPS_TS_ARCHIVE	62	0	5.48	1.39	2,269	1	111	21.35
SYSAUX	292	0	2.16	1.08	1,496	0	0	0.00
APPS_TS_NOLOGGING	25	0	10.40	1.56	38	0	0	0.00
CTXSYS	24	0	7.50	1.00	6	0	0	0.00
APPS_TS_MEDIA	12	0	13.33	1.00	9	0	0	0.00
ODM	12	0	5.83	1.00	3	0	0	0.00
OLAP	12	0	6.67	1.00	3	0	0	0.00
OWAPUB	12	0	5.00	1.00	3	0	0	0.00
PORTAL	12	0	8.33	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,833	2	2.27	6.49	155,050	43	42,386	0.39
APPS_ASSM_IDX	/DB/visdata/apps_assm_idx.dbf	6,827	2	2.36	1.04	139,136	39	175,621	0.10
APPS_TS_ARCHIVE	/DB/visdata/archive1.dbf	34	0	6.76	1.38	2,002	1	107	22.15
APPS_TS_ARCHIVE	/DB/visdata/archive2.dbf	28	0	3.93	1.39	267	0	4	0.00
APPS_TS_MEDIA	/DB/visdata/media1.dbf	4	0	10.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media2.dbf	4	0	17.50	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media3.dbf	4	0	12.50	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging1.dbf	4	0	15.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging2.dbf	15	0	7.33	1.00	23	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging3.dbf	6	0	15.00	3.33	12	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues1.dbf	50	0	6.00	1.82	773	0	93	0.54
APPS_TS_QUEUES	/DB/visdata/queues2.dbf	26	0	3.85	3.54	1,005	0	224	0.18
APPS_TS_QUEUES	/DB/visdata/queues3.dbf	39	0	5.38	3.41	812	0	5	0.00
APPS_TS_QUEUES	/DB/visdata/queues4.dbf	55	0	4.73	1.98	832	0	4	0.00
APPS_TS_QUEUES	/DB/visdata/queues5.dbf	54	0	5.56	2.35	688	0	1	0.00
APPS_TS_QUEUES	/DB/visdata/queues6.dbf	34	0	6.18	1.79	727	0	10	0.00
APPS_TS_QUEUES	/DB/visdata/queues7.dbf	128	0	5.47	1.61	862	0	91	0.33
APPS_TS_SEED	/DB/visdata/reference1.dbf	196	0	6.48	1.67	499	0	43	1.86
APPS_TS_SEED	/DB/visdata/reference10.dbf	192	0	5.89	1.63	550	0	59	1.69
APPS_TS_SEED	/DB/visdata/reference2.dbf	221	0	7.06	1.58	577	0	37	2.97
APPS_TS_SEED	/DB/visdata/reference3.dbf	362	0	5.28	1.62	625	0	404	1.83
APPS_TS_SEED	/DB/visdata/reference4.dbf	218	0	6.74	1.84	648	0	32	2.19
APPS_TS_SEED	/DB/visdata/reference5.dbf	263	0	6.27	1.60	565	0	81	1.85
APPS_TS_SEED	/DB/visdata/reference6.dbf	249	0	5.66	1.71	622	0	48	3.13
APPS_TS_SEED	/DB/visdata/reference7.dbf	240	0	5.83	1.50	497	0	38	6.84
APPS_TS_SEED	/DB/visdata/reference8.dbf	197	0	5.63	1.77	520	0	39	3.33
APPS_TS_SEED	/DB/visdata/reference9.dbf	179	0	6.59	1.60	575	0	69	0.87
APPS_TS_SUMMARY	/DB/visdata/summary1.dbf	7	0	12.86	1.00	1,033	0	262	0.00
APPS_TS_SUMMARY	/DB/visdata/summary2.dbf	5	0	8.00	1.00	858	0	130	0.08
APPS_TS_SUMMARY	/DB/visdata/summary3.dbf	7	0	8.57	1.00	915	0	171	0.12
APPS_TS_SUMMARY	/DB/visdata/summary4.dbf	12	0	7.50	1.00	904	0	184	0.00
APPS_TS_SUMMARY	/DB/visdata/summary5.dbf	7	0	7.14	1.00	1,031	0	285	0.00
APPS_TS_SUMMARY	/DB/visdata/summary6.dbf	7	0	14.29	1.00	1,222	0	524	0.04
APPS_TS_SUMMARY	/DB/visdata/summary7.dbf	7	0	7.14	1.00	1,083	0	216	0.05
APPS_TS_SUMMARY	/DB/visdata/summary8.dbf	7	0	7.14	1.00	1,344	0	203	0.05
APPS_TS_TX_DATA	/DB/visdata/tx_data1.dbf	3,201	1	5.15	1.20	411	0	3	6.67
APPS_TS_TX_DATA	/DB/visdata/tx_data10.dbf	3,167	1	5.04	1.19	277	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data11.dbf	3,144	1	4.89	1.24	233	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data12.dbf	13,295	4	3.18	1.22	3,994	1	3,516	0.87
APPS_TS_TX_DATA	/DB/visdata/tx_data13.dbf	18,069	5	4.73	1.46	5,626	2	2,314	0.94
APPS_TS_TX_DATA	/DB/visdata/tx_data14.dbf	13,196	4	4.19	1.35	31,405	9	16,283	0.15
APPS_TS_TX_DATA	/DB/visdata/tx_data15.dbf	9,425	3	3.94	1.41	30,380	8	15,908	0.18
APPS_TS_TX_DATA	/DB/visdata/tx_data16.dbf	9,456	3	3.85	1.43	29,015	8	17,371	0.16
APPS_TS_TX_DATA	/DB/visdata/tx_data17.dbf	9,378	3	3.85	1.41	28,091	8	17,264	0.17
APPS_TS_TX_DATA	/DB/visdata/tx_data18.dbf	9,430	3	3.85	1.40	26,883	7	17,408	0.15
APPS_TS_TX_DATA	/DB/visdata/tx_data19.dbf	9,386	3	4.00	1.42	27,034	8	16,805	0.21
APPS_TS_TX_DATA	/DB/visdata/tx_data2.dbf	6,760	2	3.48	1.15	1,293	0	2,217	0.81
APPS_TS_TX_DATA	/DB/visdata/tx_data20.dbf	9,350	3	4.07	1.45	26,930	7	16,577	0.15
APPS_TS_TX_DATA	/DB/visdata/tx_data21.dbf	22,879	6	4.74	1.17	1,087	0	1,361	0.04
APPS_TS_TX_DATA	/DB/visdata/tx_data3.dbf	3,964	1	5.38	1.36	489	0	11	6.36
APPS_TS_TX_DATA	/DB/visdata/tx_data4.dbf	17,338	5	4.56	1.07	349	0	12	7.50
APPS_TS_TX_DATA	/DB/visdata/tx_data5.dbf	3,277	1	5.03	1.18	408	0	6	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data6.dbf	3,241	1	4.96	1.21	256	0	4	10.00
APPS_TS_TX_DATA	/DB/visdata/tx_data7.dbf	3,165	1	4.83	1.23	537	0	16	6.88
APPS_TS_TX_DATA	/DB/visdata/tx_data8.dbf	3,131	1	4.63	1.19	484	0	5	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data9.dbf	3,300	1	4.95	1.23	319	0	0	0.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx1.dbf	2,587	1	3.41	1.12	2,678	1	1,113	0.61
APPS_TS_TX_IDX	/DB/visdata/tx_idx10.dbf	2,531	1	3.56	1.14	1,945	1	1,127	0.51
APPS_TS_TX_IDX	/DB/visdata/tx_idx11.dbf	2,558	1	3.37	1.16	1,996	1	1,100	0.53
APPS_TS_TX_IDX	/DB/visdata/tx_idx12.dbf	11,691	3	5.17	1.57	23,408	6	1,241	0.27
APPS_TS_TX_IDX	/DB/visdata/tx_idx13.dbf	9,959	3	4.69	1.28	30,887	9	3,420	0.28
APPS_TS_TX_IDX	/DB/visdata/tx_idx14.dbf	6,170	2	4.98	1.32	23,236	6	3,726	0.44
APPS_TS_TX_IDX	/DB/visdata/tx_idx15.dbf	5,988	2	4.74	1.36	19,627	5	4,299	0.16
APPS_TS_TX_IDX	/DB/visdata/tx_idx16.dbf	5,915	2	5.06	1.36	18,474	5	3,923	0.20
APPS_TS_TX_IDX	/DB/visdata/tx_idx17.dbf	5,923	2	4.72	1.35	17,286	5	3,856	0.19
APPS_TS_TX_IDX	/DB/visdata/tx_idx18.dbf	6,039	2	4.89	1.35	17,035	5	5,421	0.18
APPS_TS_TX_IDX	/DB/visdata/tx_idx19.dbf	6,010	2	4.95	1.40	16,690	5	3,537	0.23
APPS_TS_TX_IDX	/DB/visdata/tx_idx2.dbf	3,138	1	4.22	1.28	2,287	1	1,378	0.60
APPS_TS_TX_IDX	/DB/visdata/tx_idx20.dbf	5,790	2	4.78	1.36	15,830	4	3,525	0.17
APPS_TS_TX_IDX	/DB/visdata/tx_idx21.dbf	3,544	1	4.99	1.48	15,675	4	3,036	0.45
APPS_TS_TX_IDX	/DB/visdata/tx_idx3.dbf	4,060	1	2.82	1.09	2,094	1	2,970	0.67
APPS_TS_TX_IDX	/DB/visdata/tx_idx4.dbf	2,742	1	3.48	1.12	3,599	1	3,187	0.56
APPS_TS_TX_IDX	/DB/visdata/tx_idx5.dbf	2,776	1	3.53	1.17	5,186	1	8,378	0.19
APPS_TS_TX_IDX	/DB/visdata/tx_idx6.dbf	2,730	1	3.47	1.18	3,025	1	2,006	0.52
APPS_TS_TX_IDX	/DB/visdata/tx_idx7.dbf	2,622	1	3.51	1.14	2,943	1	1,442	0.51
APPS_TS_TX_IDX	/DB/visdata/tx_idx8.dbf	2,614	1	3.46	1.17	2,217	1	1,217	0.53
APPS_TS_TX_IDX	/DB/visdata/tx_idx9.dbf	2,603	1	3.71	1.21	2,154	1	1,090	0.87
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte.dbf	293	0	2.01	1.52	5,351	1	5,644	0.03
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte2.dbf	157	0	5.29	3.07	6,655	2	3,803	0.03
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte3.dbf	118	0	4.83	3.09	5,819	2	2,925	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte4.dbf	313	0	1.66	1.68	5,492	2	1,685	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte5.dbf	165	0	2.67	2.18	5,238	1	1,541	0.05
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte6.dbf	147	0	3.47	2.27	5,285	1	921	0.07
APPS_UNDOTS1	/DB/visdata/undo01.dbf	3	0	6.67	1.00	74,525	21	25,325	0.06
APPS_UNDOTS1	/DB/visdata/undo02.dbf	3	0	13.33	1.00	70,751	20	24,551	0.04
APPS_UNDOTS1	/DB/visdata/undo03.dbf	3	0	10.00	1.00	70,564	20	27,540	0.03
APPS_UNDOTS1	/DB/visdata/undo04.dbf	5	0	6.00	1.00	72,090	20	30,638	0.04
APPS_UNDOTS1	/DB/visdata/undo05.dbf	3	0	10.00	1.00	69,101	19	30,151	0.03
APPS_UNDOTS1	/DB/visdata/undo06.dbf	3	0	23.33	1.00	68,133	19	23,014	0.03
APPS_UNDOTS1	/DB/visdata/undo07.dbf	3	0	10.00	1.00	72,121	20	29,388	0.04
APPS_UNDOTS1	/DB/visdata/undo08.dbf	3	0	23.33	1.00	73,217	20	20,560	0.03
APPS_UNDOTS1	/DB/visdata/undo09.dbf	3	0	10.00	1.00	72,413	20	26,094	0.04
APPS_UNDOTS1	/DB/visdata/undo10.dbf	3	0	13.33	1.00	72,979	20	22,290	0.03
CTXSYS	/DB/visdata/ctx1.dbf	12	0	9.17	1.00	3	0	0	0.00
CTXSYS	/DB/visdata/ctx2.dbf	12	0	5.83	1.00	3	0	0	0.00
ODM	/DB/visdata/odm.dbf	12	0	5.83	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.00	1.00	3	0	0	0.00
PORTAL	/DB/visdata/portal.dbf	12	0	8.33	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	18	0	7.22	1.44	639	0	0	0.00
SYSAUX	/DB/visdata/sysaux02.dbf	274	0	1.82	1.06	857	0	0	0.00
SYSTEM	/DB/visdata/sys1.dbf	566	0	3.67	3.86	103	0	39	0.00
SYSTEM	/DB/visdata/sys2.dbf	578	0	3.84	4.02	210	0	95	0.11
SYSTEM	/DB/visdata/sys3.dbf	706	0	3.57	3.42	259	0	11	0.00
SYSTEM	/DB/visdata/sys4.dbf	620	0	2.90	3.76	256	0	0	0.00
SYSTEM	/DB/visdata/sys5.dbf	856	0	4.05	2.94	686	0	875	0.06
SYSTEM	/DB/visdata/sys6.dbf	643	0	4.15	3.72	64	0	5	0.00
SYSTEM	/DB/visdata/sys7.dbf	494	0	4.57	3.89	181	0	65	0.00
SYSTEM	/DB/visdata/sys8.dbf	448	0	4.51	2.86	517	0	20,602	0.06
SYSTEM	/DB/visdata/sys9.dbf	484	0	4.46	2.63	479	0	63	0.48
TEMP	/DB/visdata/temp1.dbf	135	0	4.30	8.44	3,486	1	52	3.65
TEMP	/DB/visdata/temp2.dbf	84	0	4.05	1.00	2,045	1	4	2.50
TEMP	/DB/visdata/temp3.dbf	169	0	4.44	18.28	2,518	1	33	5.15
TEMP	/DB/visdata/temp4.dbf	125	0	4.40	6.45	2,258	1	2	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	2,184,816	100	2,175,382,448	453,694	3,154,940	0	0	707,340

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

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	101	48592	1190370	4585294	188743680	4585294
E	180	104	54068	1188160	10212264	188743680	10212264

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,681	16

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,234.26	0.17	0.00	100.00	0.00	1,048,576
E	20,480	1,280	54,727.39	1.13	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
2K	4K	5,989,372	5,989,372	0
64K	128K	11,774	11,774	0
128K	256K	1,170	1,170	0
256K	512K	1,121	1,121	0
512K	1024K	188,288	188,288	0
1M	2M	438,967	438,967	0
2M	4M	72	70	2
4M	8M	21	19	2
8M	16M	2	2	0
32M	64M	8	8	0
64M	128M	6	6	0
128M	256M	2	2	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	941,140.16	9,092.35	99.00	1,211
5,120	0.25	941,140.16	9,047.53	99.00	1,182
10,240	0.50	941,140.16	8,926.17	99.00	1,131
15,360	0.75	941,140.16	8,780.90	99.00	1,078
20,480	1.00	941,140.16	5.28	100.00	1,033
24,576	1.20	941,140.16	5.28	100.00	1,000
28,672	1.40	941,140.16	5.28	100.00	939
32,768	1.60	941,140.16	5.28	100.00	830
36,864	1.80	941,140.16	5.28	100.00	562
40,960	2.00	941,140.16	0.00	100.00	119
61,440	3.00	941,140.16	0.00	100.00	0
81,920	4.00	941,140.16	0.00	100.00	0
122,880	6.00	941,140.16	0.00	100.00	0
163,840	8.00	941,140.16	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,360	0.50	305	13,711	2,327,915	1.00	4,464	3.63	208,722,605
1,632	0.60	552	17,034	2,329,474	1.00	2,905	2.36	208,844,802
1,904	0.70	823	20,869	2,330,787	1.00	1,592	1.29	208,948,391
2,176	0.80	1,093	25,258	2,331,104	1.00	1,275	1.04	208,975,716
2,448	0.90	1,350	32,084	2,331,145	1.00	1,234	1.00	208,979,713
2,720	1.00	1,537	37,621	2,331,148	1.00	1,231	1.00	208,980,191
2,992	1.10	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,246
3,264	1.20	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
3,536	1.30	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
3,808	1.40	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
4,080	1.50	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
4,352	1.60	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
4,624	1.70	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
4,896	1.80	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
5,168	1.90	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256
5,440	2.00	1,604	39,955	2,331,148	1.00	1,231	1.00	208,980,256

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)
5,120	0.25	31,531
10,240	0.50	31,531
15,360	0.75	31,531
20,480	1.00	31,530
25,600	1.25	31,531
30,720	1.50	31,535
35,840	1.75	31,535
40,960	2.00	31,536

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	13	247	1,191	1.00	1,231	1.00	18,403
32	0.50	13	247	1,191	1.00	1,231	1.00	18,403
48	0.75	13	247	1,191	1.00	1,231	1.00	18,403
64	1.00	13	247	1,191	1.00	1,231	1.00	18,403
80	1.25	13	247	1,191	1.00	1,231	1.00	18,403
96	1.50	13	247	1,191	1.00	1,231	1.00	18,403
112	1.75	13	247	1,191	1.00	1,231	1.00	18,403
128	2.00	13	247	1,191	1.00	1,231	1.00	18,403

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	440,514	88	0
undo block	209,788	7	0
undo header	49,768	3	0
1st level bmb	4,180	0	0
file header block	95	0	4
segment header	2,240	0	0
2nd level bmb	771	0	0
extent map	9	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)	5,387	663	4,724	613	99	160.90
UL-User-defined	69,451	68,394	1,057	2,383	53	22.14
TX-Transaction (index contention)	27,278	27,278	0	23,965	11	0.48
RO-Multiple Object Reuse (fast object reuse)	288	288	0	29	5	166.55
HW-Segment High Water Mark	280,074	280,067	7	2,032	2	0.97
DV-Diana Versioning	32,387	32,387	0	183	1	6.23
TX-Transaction	1,342,575	1,342,576	0	1,802	1	0.58
SQ-Sequence Cache	43,263	43,263	0	2,909	1	0.26
FB-Format Block	36,971	36,971	0	549	0	0.26
TX-Transaction (allocate ITL entry)	169	169	0	73	0	0.82
TM-DML	2,175,044	2,174,964	13	3	0	20.00
CU-Cursor	9,234	9,234	0	2	0	10.00
PS-PX Process Reservation	1,864	1,544	320	26	0	0.38

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

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,613.00	1,334,540	2,680	383	184.9/553.75	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
12-Oct 07:45	215,882	183,248	523	380	192	0/0	0/0/0/0/0/0
12-Oct 07:35	77,949	132,023	370	375	197	0/0	0/0/0/0/0/0
12-Oct 07:25	458,074	209,492	677	371	185	0/0	0/0/0/0/0/0
12-Oct 07:15	356,062	272,816	2,445	383	236	0/0	0/0/0/0/0/0
12-Oct 07:05	337,749	376,047	2,680	380	315	0/0	0/0/0/0/0/0
12-Oct 06:55	167,286	160,914	1,729	379	554	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

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,467	0.00		0	0
AWR Alerted Metric Element list	335,057	0.00		0	0
Consistent RBA	846,592	0.07	0.03	0	0
FOB s.o list latch	55,356	0.02	0.00	0	0
In memory undo latch	849,821,584	1.65	0.00	12	1,279,750	0.00
JOX SGA heap latch	1,951,344	0.00		0	0
JS mem alloc latch	8	0.00		0	0
JS queue access latch	8	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,928	0.00		0	0
KMG resize request state object freelist	22	0.00		0	0
KTF sga latch	12	0.00		0	1,213	0.00
KWQMN job cache list latch	14,387	0.19	0.93	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1,925	0.00		0	2,916	0.00
OS process	15,291	0.00		0	0
OS process allocation	11,433	0.01	0.00	0	0
OS process: request allocation	9,952	0.00		0	0
PL/SQL warning settings	4,611,180	0.00		0	0
SGA IO buffer pool latch	41,920	0.22	0.00	0	43,021	0.22
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	7,216,151	0.01	0.02	0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	972,420	0.52	0.00	0	2	0.00
active service list	48,836	0.07	0.00	0	1,284	0.00
begin backup scn array	135	0.00		0	0
buffer pool	22	0.00		0	0
cache buffer handles	20,704,835	1.15	0.00	0	0
cache buffers chains	5,167,822,821	0.93	0.02	50	19,078,965	2.42
cache buffers lru chain	10,240,249	0.36	0.05	2	38,110,686	0.48
cache table scan latch	2,145	0.00		0	2,145	0.00
channel handle pool latch	414,917	0.08	0.01	0	0
channel operations parent latch	1,791,464	0.42	0.00	0	0
checkpoint queue latch	15,253,878	0.02	0.02	0	3,167,730	0.02
client/application info	1,796,413	0.00	0.00	0	0
commit callback allocation	88,556	0.00		0	0
compile environment latch	3,154,587	0.00		0	0
dictionary lookup	76	0.00		0	0
dml lock allocation	4,333,041	0.19	0.02	0	0
dummy allocation	20,373	0.16	0.00	0	0
enqueue hash chains	9,445,574	0.06	0.01	0	307	0.00
enqueues	5,414,747	0.11	0.01	0	0
error message lists	816	1.10	0.00	0	0
event group latch	4,995	0.00		0	0
file cache latch	22,043	0.00	0.00	0	0
global KZLD latch for mem in SGA	9,687	0.00		0	0
global ctx hash table latch	24,496	0.00		0	0
hash table column usage latch	1,937	0.10	0.00	0	15,511,294	0.00
hash table modification latch	144	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	31,231	0.00		0	0
ksuosstats global area	242	0.00		0	0
ktm global data	155,770	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	849,000	0.11	0.00	0	0
library cache	356,107,880	0.38	0.01	10	21,757	4.49
library cache load lock	10,158	0.32	0.00	0	11	0.00
library cache lock	59,801,841	0.05	0.01	0	0
library cache lock allocation	1,551,221	0.01	0.02	0	0
library cache pin	222,013,833	0.13	0.01	2	52	0.00
library cache pin allocation	540,601	0.00	0.08	0	0
list of block allocation	459,767	0.01	0.00	0	0
loader state object freelist	322,382	0.00	0.00	0	0
longop free list parent	33	0.00		0	33	0.00
message pool operations parent latch	421,550	0.01	0.08	0	0
messages	5,307,626	0.38	0.01	0	0
mostly latch-free SCN	898,358	3.95	0.00	0	0
multiblock read objects	27,836	0.00	0.00	0	0
ncodef allocation latch	189	0.00		0	0
object queue header heap	2,957,835	0.03	0.28	0	404,783	0.07
object queue header operation	35,327,666	0.14	0.42	3	21,275	0.03
object stats modification	412,359	0.03	0.02	0	0
parallel query alloc buffer	8,160	1.04	0.00	0	0
parallel query stats	528	10.42	0.00	0	0
parameter table allocation management	24,267	0.97	0.44	0	0
post/wait queue	1,380,574	0.03	0.01	0	565,121	0.01
process allocation	10,000	0.17	0.88	0	4,994	0.02
process group creation	9,952	0.00		0	0
process queue	5,030	0.76	0.00	0	0
process queue reference	789,511	0.05	0.01	0	85,071	0.41
qmn task queue latch	516	0.00		0	0
query server freelists	4,256	5.26	0.00	0	0
query server process	8	0.00		0	8	0.00
redo allocation	5,567,288	1.58	0.01	1	103,759,795	1.66
redo copy	0			0	103,894,916	0.05
redo writing	3,951,382	0.20	0.01	0	0
resmgr group change latch	859,823	0.00		0	0
resmgr:actses active list	30,023	0.48	0.99	0	0
resmgr:actses change group	29,435	0.00		0	0
resmgr:free threads list	20,371	0.16	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	128,247,477	0.22	0.00	1	7,083	0.13
rules engine aggregate statistics	41,610	0.00		0	0
rules engine rule set statistics	133,740	0.00	0.00	0	0
rules engine rule statistics	50,520	0.00		0	0
sequence cache	16,638,272	0.46	0.00	0	0
session allocation	19,764,863	0.46	0.01	0	0
session idle bit	102,651,842	0.01	0.02	0	0
session state list latch	59,041	0.10	0.69	0	0
session switching	15,267	0.00		0	0
session timer	1,284	0.00		0	0
shared pool	7,813,496	0.16	0.06	0	0
shared pool sim alloc	373	0.00		0	0
shared pool simulator	1,914,463	0.00	0.06	0	0
sim partition latch	1	0.00		0	24,164	0.08
simulator hash latch	2,460	0.00		0	0
simulator lru latch	1,518	0.00		0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	1,424,122	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	262	0.00		0	0
temporary table state object allocation	12,640	0.00		0	0
threshold alerts latch	605	0.00		0	0
trace latch	48	0.00		0	0
transaction allocation	117,402	0.00		0	0
transaction branch allocation	189	0.00		0	0
undo global data	1,096,027,346	1.06	0.00	8	24,230	0.17
user lock	38,804	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
cache buffers chains	5,167,822,821	48,207,068	1,064,930	47,262,037
In memory undo latch	849,821,584	13,991,139	34,218	13,963,449
undo global data	1,096,027,346	11,584,549	13,767	11,572,763
library cache	356,107,880	1,363,201	12,069	1,352,363
row cache objects	128,247,477	281,547	1,026	280,576
library cache pin	222,013,833	279,515	3,294	276,538
cache buffer handles	20,704,835	238,807	281	238,563
session allocation	19,764,863	91,739	891	90,925
redo allocation	5,567,288	88,022	1,262	86,862
sequence cache	16,638,272	76,415	143	76,298
object queue header operation	35,327,666	50,051	20,956	31,025
cache buffers lru chain	10,240,249	36,929	1,816	35,229
mostly latch-free SCN	898,358	35,447	95	35,362
library cache lock	59,801,841	31,140	200	30,948
messages	5,307,626	20,015	117	19,900
session idle bit	102,651,842	15,162	252	14,916
shared pool	7,813,496	12,433	784	11,728
dml lock allocation	4,333,041	8,188	125	8,074
redo writing	3,951,382	7,897	46	7,851
channel operations parent latch	1,791,464	7,557	18	7,541
enqueues	5,414,747	5,926	88	5,839
enqueue hash chains	9,445,574	5,257	39	5,220
active checkpoint queue latch	972,420	5,086	17	5,071
checkpoint queue latch	15,253,878	2,422	39	2,386
sort extent pool	1,424,122	1,346	18	1,328
object queue header heap	2,957,835	959	268	724
lgwr LWN SCN	849,000	896	1	895
Consistent RBA	846,592	573	17	561
post/wait queue	1,380,574	440	4	436
SQL memory manager workarea list latch	7,216,151	375	8	367
process queue reference	789,511	364	2	363
channel handle pool latch	414,917	341	3	338
parameter table allocation management	24,267	235	103	137
resmgr:actses active list	30,023	145	143	4
library cache lock allocation	1,551,221	128	3	125
object stats modification	412,359	119	2	117
session state list latch	59,041	59	41	19
shared pool simulator	1,914,463	36	2	34
KWQMN job cache list latch	14,387	28	26	2
message pool operations parent latch	421,550	24	2	23
process allocation	10,000	17	15	2
library cache pin allocation	540,601	13	1	12

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	25,748	27,988
In memory undo latch	ktiFlush: child	4,582	2,808
In memory undo latch	kticmt: child	3,081	566
In memory undo latch	ktichg: child	495	2,761
In memory undo latch	ktiTxnPoolFree	282	1
In memory undo latch	ktiBRacquire	19	0
In memory undo latch	ktbgfc	10	111
In memory undo latch	ktuswr	1	0
KWQMN job cache list latch	kwqmnuji: update job item	27	3
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	6	5
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	2	7
active checkpoint queue latch	kcbbacq: scan active checkpoints	17	17
cache buffer handles	kcbzgs	178	170
cache buffer handles	kcbzfs	103	111
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1,283,854	1,506,019
cache buffers chains	kcbgtcr: fast path	587,209	26,068
cache buffers chains	kcbchg: kslbegin: call CR func	379,355	897,402
cache buffers chains	kcbzgb: scan from tail. nowait	129,421	0
cache buffers chains	kcbgtcr: kslbegin excl	118,293	45,933
cache buffers chains	kcbrls: kslbegin	29,487	64,133
cache buffers chains	kcbgcur: kslbegin	25,637	13,019
cache buffers chains	kcbget: pin buffer	15,248	6,628
cache buffers chains	kcbzwb	5,534	5,840
cache buffers chains	kcbcge	2,301	5,478
cache buffers chains	kcbget: exchange rls	621	509
cache buffers chains	kcbget: exchange	298	1,173
cache buffers chains	kcbbxsv	283	260
cache buffers chains	kcbnlc	192	1,319
cache buffers chains	kcb_is_private	189	2,200
cache buffers chains	kcbgtcr: kslbegin shared	84	69
cache buffers chains	kcbnew: new latch again	65	8
cache buffers chains	kcb_pre_apply: kcbhq61	59	1,601
cache buffers chains	kcbesc: escalate	53	21
cache buffers chains	kcb_post_apply: kcbhq63	26	260
cache buffers chains	kcbbic2	14	5
cache buffers chains	kcbso1: set no access	12	35
cache buffers chains	kcb_post_apply: kcbhq62	3	319
cache buffers chains	kcbzib: finish free bufs	2	4
cache buffers chains	kcbo_ivd_process	1	43
cache buffers chains	kcbw_next_free	1	0
cache buffers lru chain	kcbzgws	1,062	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	217	0
cache buffers lru chain	kcbbxsv: move to being written	193	528
cache buffers lru chain	kcbo_link_q	148	30
cache buffers lru chain	kcbzgb: posted for free bufs	92	459
cache buffers lru chain	kcbo_ivd_proc	44	416
cache buffers lru chain	kcbzswcu	28	78
cache buffers lru chain	kcbbic2	21	275
cache buffers lru chain	kcbzfw	4	0
cache buffers lru chain	kcbzib	4	1
cache buffers lru chain	kcbbwlru	1	67
cache buffers lru chain	kcbzgm	1	0
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	1	52
channel handle pool latch	ksrchconnect()	9	3
channel operations parent latch	ksrapublish()	15	3
channel operations parent latch	ksrwait()	6	21
channel operations parent latch	ksrchdelete()	4	4
channel operations parent latch	ksrchconnect()	3	9
channel operations parent latch	ksrmfree()	2	1
channel operations parent latch	ksrsconsume()	1	1
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	18	12
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	9	0
checkpoint queue latch	kcbkubc	8	15
checkpoint queue latch	kcbswcu: Switch buffers	3	13
checkpoint queue latch	kcbnlc: Link buffers into FQ	1	0
dml lock allocation	ktaiam	83	91
dml lock allocation	ktaidm	42	34
enqueue hash chains	ksqgtl3	25	16
enqueue hash chains	ksqrcl	10	20
enqueue hash chains	ksqcmi: get hash chain latch after wait	3	2
enqueues	ksqies	37	60
enqueues	ksqgel: create enqueue	27	21
enqueues	ksqdel	24	7
lgwr LWN SCN	kcs023	28	0
library cache	kglpndl: child: after processing	4,733	130
library cache	kglpnp: child	4,462	6,204
library cache	kglobpn: child:	1,021	1,756
library cache	kglpndl: child: before processing	639	3,097
library cache	kglLockCursor	292	397
library cache	kglScanDependency	183	0
library cache	kglpin	139	58
library cache	kgldte: child 0	125	213
library cache	kglhdgn: child:	110	162
library cache	kgldti: 2child	31	13
library cache	kglic	16	0
library cache	kglhdiv: child	7	1
library cache	kglivl: child	3	0
library cache	kglupd: child	3	0
library cache	kglget: unpin heap 0	2	0
library cache	kglhdgc: child:	2	0
library cache	kgldrp: child	1	0
library cache	kglhdiv0: child	1	0
library cache	kglukp: child	1	0
library cache lock	kgllkdl: child: cleanup	122	112
library cache lock	kgllkdl: child: no lock handle	86	23
library cache lock	kgllkal: child: multiinstance	78	88
library cache lock allocation	kgllkget	3	3
library cache pin	kglpndl	1,570	986
library cache pin	kglpnp: child	1,480	1,828
library cache pin	kglpnal: child: alloc space	244	480
library cache pin allocation	kglpnget	1	1
message pool operations parent latch	ksrmalloc()	2	2
messages	ksarcv	49	19
messages	ksarcv: after wait	43	67
messages	ksaamb: after wakeup	25	31
mostly latch-free SCN	kcslcu3	67	96
mostly latch-free SCN	kcs01	9	17
mostly latch-free SCN	kcsnew_scn_rba	8	0
mostly latch-free SCN	kcs024	1	0
object queue header heap	kcbo_link_q:reget	257	7
object queue header heap	kcbw_link_q:alloc	9	261
object queue header heap	kcbw_unlink_q	2	0
object queue header operation	kcbo_ivbo	21,489	4,973
object queue header operation	kcbw_link_q	3,685	2,518
object queue header operation	kcbw_unlink_q	1,112	7,580
object queue header operation	kcbo_switch_mq_bg	449	2,818
object queue header operation	kcbo_switch_q_bg	324	1,900
object queue header operation	kcbo_switch_cq	124	3,186
object queue header operation	kcbo_link_q:reget	98	155
object queue header operation	kcbo_write_q	34	4
object queue header operation	kcbo_service_ockpt	29	1
object queue header operation	kcbo_swap_buf_bg	10	3,938
object queue header operation	kcbo_swap_buf	9	561
object queue header operation	kcbw_unlink_q_bg	1	21
object stats modification	ksoslinelm	2	1
parameter table allocation management	ksp_param_table_free	103	103
post/wait queue	ksliwat:remove	4	3
process allocation	ksucrp	14	0
process allocation	ksudlp	1	7
process queue reference	kxfpqrsnd	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	984	0
redo allocation	kcrfw_redo_gen: redo allocation 3	188	769
redo allocation	kcrfw_redo_gen: redo allocation 2	49	0
redo allocation	kcrfw_redo_write: more space	26	318
redo allocation	kcrfw_redo_write: before write	15	191
redo writing	kcrfwcr	33	42
redo writing	kcrfw_post: rba scn pair	9	0
redo writing	kcrfw_post: after write	4	4
resmgr:actses active list	kgskchclass	143	69
row cache objects	kqreqd: reget	792	5
row cache objects	kqrpre: find obj	158	890
row cache objects	kqreqd	71	131
row cache objects	kqrso	4	0
sequence cache	kdnssd	91	4
sequence cache	kdnnxt: cached seq	41	2
sequence cache	kdnss	11	142
session allocation	ksuprc	271	163
session allocation	ksuxds: KSUSFCLC not set	216	20
session allocation	ksudlc	152	233
session allocation	ksucri	110	307
session allocation	ksuxds: not user session	92	116
session allocation	kspallmod	22	0
session allocation	ksudlp	10	1
session allocation	kxfpqidqr	8	28
session allocation	ksursi	6	20
session allocation	kxfprdp	3	3
session allocation	ksucrp	1	0
session idle bit	ksupuc: set busy	164	163
session idle bit	ksupuc: clear busy	128	135
session idle bit	ksuxds	16	10
session state list latch	kpseqd	38	0
session state list latch	kpscad	1	1
session state list latch	kpscdl	1	25
session state list latch	kpseqa	1	71
shared pool	kghupr1	392	567
shared pool	kghalo	296	132
shared pool	kghfrunp: clatch: nowait	202	0
shared pool	kghfrunp: alloc: wait	47	0
shared pool	kghfre	36	70
shared pool	kghfrunp: clatch: wait	11	14
shared pool	kghalp	9	15
shared pool	kgh: sim resz update	2	0
shared pool	kghasp	1	0
shared pool	kghfrunp: alloc: session dur	1	0
shared pool simulator	kglsim_unpin_simhp	2	2
sort extent pool	ktstdt: dealloc sort extent	14	2
sort extent pool	ktstsmonmsg	3	12
sort extent pool	ktstallocext: new extent in-doubt	1	0
undo global data	kturimugur: child	12,002	8,085
undo global data	ktudba: KSLBEGIN	1,666	5,639
undo global data	ktudnx:child	33	23
undo global data	ktucof: at start	24	0
undo global data	ktufrbs: child	23	17
undo global data	ktusmasp: ktugd_tuux	11	4
undo global data	ktubnd:child	8	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

Segments by Logical Reads

Total Logical Reads: 2,175,631,664
Captured Segments account for 28.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL	TABLE	68,348,928	3.14
INV	APPS_TS_TX_IDX	MTL_ITEM_CATEGORIES_U1	INDEX	51,059,968	2.35
ICX	APPS_TS_TX_DATA	ICX_SESSION_ATTRIBUTES	TABLE	25,153,984	1.16
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL	TABLE	22,897,968	1.05
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS	TABLE	20,822,656	0.96

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 455,068
Captured Segments account for 14.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES	TABLE	35,010	7.69
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL	TABLE	13,066	2.87
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS	TABLE	9,554	2.10
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS	TABLE	4,048	0.89
GL	APPS_TS_TX_DATA	GL_CODE_COMBINATIONS	TABLE	1,132	0.25

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	Obj. Type	Row Lock Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1	INDEX	14,980	33.26
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1	INDEX	9,395	20.86
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS	TABLE	8,966	19.91
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6	INDEX	2,174	4.83
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK	INDEX	1,740	3.86

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	Obj. Type	ITL Waits	% of Capture
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6	INDEX	17	27.87
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK	INDEX	11	18.03
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N5	INDEX	10	16.39
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N3	INDEX	4	6.56
GL	APPS_ASSM_IDX	GL_JE_LINES_N1	INDEX	4	6.56

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	127,744	34.71
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	76,297	20.73
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	20,581	5.59
AR	APPS_ASSM_DATA	RA_CUST_TRX_LINE_GL_DIST_ALL		TABLE	17,489	4.75
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ACTIVITY_STATUSES	WF_ITEM49	TABLE PARTITION	16,050	4.36

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	Mod Reqs	Final Usage
dc_awr_control	5	20.00	2	1
dc_constraints	648	47.22	648	0
dc_files	6,660	0.00	0	111
dc_global_oids	7,853,638	0.00	0	43
dc_histogram_data	67,252	0.93	0	641
dc_histogram_defs	418,134	2.51	4,044	3,704
dc_object_grants	72,674	0.06	0	74
dc_object_ids	12,655,581	0.01	58	1,372
dc_objects	182,187	1.02	346	788
dc_profiles	9,746	0.00	0	1
dc_rollback_segments	20,547	0.00	0	389
dc_segments	367,678	0.71	16,157	1,351
dc_sequences	53,645	0.14	53,645	115
dc_table_scns	20,653	0.04	0	5
dc_tablespace_quotas	16,019	0.13	213	43
dc_tablespaces	5,963,923	0.00	0	22
dc_usernames	514,911	0.01	0	18
dc_users	15,140,589	0.00	0	63
outstanding_alerts	268	16.42	1	42

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	636,094	0.02	42,611,552	0.00	15	0
CLUSTER	105	0.95	253	0.40	0	0
INDEX	15,818	0.40	16,630	0.56	0	0
JAVA DATA	626	0.00	0		0	0
PIPE	50,580	2.55	74,655	1.73	0	0
SQL AREA	6,441	89.83	114,750,932	0.44	3,942	447
TABLE/PROCEDURE	408,981	0.25	58,036,377	0.01	1,197	0
TRIGGER	28,740	0.09	1,408,996	0.00	25	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

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,381.17		12.11	7.03	40	40	3,088	3,088
	Freeable	3,692.94	0.00	1.35	0.82	9		2,743	2,743
	SQL	3,502.63	1,794.57	1.14	0.71	4	22	3,080	3,079
	PL/SQL	2,385.34	190.43	0.77	0.96	3	3	3,088	3,088
	JAVA	268.30	267.02	2.24	0.30	5	8	120	120
E	Other	43,431.59		13.90	8.46	41	41	3,124	3,124
	Freeable	4,249.44	0.00	1.51	0.94	9		2,821	2,821
	SQL	4,004.55	2,092.97	1.29	0.76	5	22	3,116	3,115
	PL/SQL	2,765.02	215.40	0.89	0.99	3	3	3,124	3,124
	JAVA	268.27	266.97	2.24	0.30	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,706,595,840	18,522,046,464
Fixed Size	2,111,120
Redo Buffers	14,663,680
Variable Size	2,751,465,840	2,936,015,216

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	37.43	37.58	0.40
shared	KTI-UNDO	53.19	53.19	0.00
shared	PL/SQL MPCODE	66.57	69.50	4.41
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	336.63	353.86	5.12
shared	library cache	852.81	1,002.35	17.53
shared	parameter table block	57.65	58.01	0.63
shared	private strands	99.77	99.77	0.00
shared	sessions	36.42	36.42	0.00
shared	sql area	366.81	377.41	2.89
shared	trace buffer	48.27	49.00	1.52
	buffer_cache	17,840.00	17,664.00	-0.99
	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

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,125	3,137	3600	3600

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