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	06-May-09 05:37:49	4768	211.4
End Snap:	2	06-May-09 06:37:54	4783	234.1
Elapsed:		60.08 (mins)
DB Time:		415.31 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	17,984M	17,824M	Std Block Size:	8K
Shared Pool Size:	2,400M	2,560M	Log Buffer:	14,320K

Load Profile

	Per Second	Per Transaction
Redo size:	8,752,977.49	27,282.24
Logical reads:	561,879.43	1,751.33
Block changes:	54,468.54	169.77
Physical reads:	121.84	0.38
Physical writes:	852.12	2.66
User calls:	12,467.11	38.86
Parses:	2,360.62	7.36
Hard parses:	2.46	0.01
Sorts:	2,867.43	8.94
Logons:	2.58	0.01
Executes:	27,142.69	84.60
Transactions:	320.83

% Blocks changed per Read:	9.69	Recursive Call %:	77.91
Rollback per transaction %:	20.62	Rows per Sort:	12.39

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.30	Latch Hit %:	99.05
Parse CPU to Parse Elapsd %:	92.53	% Non-Parse CPU:	97.79

Shared Pool Statistics

	Begin	End
Memory Usage %:	86.49	86.54
% SQL with executions>1:	90.40	90.92
% Memory for SQL w/exec>1:	70.62	70.89

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		19,651		78.9
SQL*Net more data from client	2,333,168	5,578	2	22.4	Network
db file sequential read	278,108	932	3	3.7	User I/O
log file sync	494,534	698	1	2.8	Commit
log file parallel write	813,691	337	0	1.4	System I/O

Main Report

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

Back to Top

Wait Events Statistics

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

Back to Top

Time Model Statistics

• Total time in database user-calls (DB Time): 24918.5s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
DB CPU	19,650.53	78.86
sql execute elapsed time	19,005.47	76.27
PL/SQL execution elapsed time	7,062.42	28.34
inbound PL/SQL rpc elapsed time	6,847.17	27.48
parse time elapsed	533.56	2.14
Java execution elapsed time	498.39	2.00
hard parse elapsed time	282.76	1.13
repeated bind elapsed time	74.55	0.30
sequence load elapsed time	13.42	0.05
connection management call elapsed time	9.63	0.04
PL/SQL compilation elapsed time	6.27	0.03
hard parse (sharing criteria) elapsed time	3.62	0.01
failed parse elapsed time	1.43	0.01
hard parse (bind mismatch) elapsed time	1.18	0.00
DB time	24,918.49
background elapsed time	1,002.45
background cpu time	352.99

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
Network	51,318,007	0.00	5,618	0	44.37
User I/O	329,343	0.00	1,050	3	0.28
Commit	494,534	0.00	698	1	0.43
System I/O	1,130,959	0.00	497	0	0.98
Application	63,077	0.06	177	3	0.05
Concurrency	1,926,552	0.19	126	0	1.67
Other	136,814	21.98	37	0	0.12
Configuration	6,932	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
SQL*Net more data from client	2,333,168	0.00	5,578	2	2.02
db file sequential read	278,108	0.00	932	3	0.24
log file sync	494,534	0.00	698	1	0.43
log file parallel write	813,691	0.00	337	0	0.70
db file parallel write	286,365	0.00	154	1	0.25
enq: TX - row lock contention	659	5.92	137	207	0.00
db file scattered read	11,990	0.00	58	5	0.01
read by other session	36,446	0.00	58	2	0.03
cursor: pin S wait on X	4,110	90.61	41	10	0.00
latch: cache buffers chains	1,201,589	0.00	29	0	1.04
SQL*Net message to client	47,083,483	0.00	23	0	40.71
enq: UL - contention	1,450	0.00	19	13	0.00
SQL*Net more data to client	1,901,356	0.00	18	0	1.64
buffer busy waits	651,468	0.00	18	0	0.56
library cache load lock	650	0.00	11	18	0.00
SQL*Net break/reset to client	60,930	0.00	11	0	0.05
enq: TX - index contention	26,204	0.00	11	0	0.02
PX Deq Credit: send blkd	23,600	0.00	9	0	0.02
rdbms ipc reply	6	50.00	7	1148	0.00
latch: In memory undo latch	24,440	0.00	6	0	0.02
enq: RO - fast object reuse	32	0.00	6	184	0.00
control file sequential read	29,164	0.00	5	0	0.03
latch: library cache	9,054	0.00	5	1	0.01
latch: undo global data	8,164	0.00	5	1	0.01
enq: TM - contention	6	0.00	4	634	0.00
PX Deq: Signal ACK	255	36.08	3	12	0.00
kksfbc child completion	60	83.33	2	42	0.00
os thread startup	70	0.00	2	31	0.00
latch: object queue header operation	20,566	0.00	2	0	0.02
latch free	2,786	0.00	2	1	0.00
latch: library cache pin	2,530	0.00	1	1	0.00
LGWR wait for redo copy	32,863	0.01	1	0	0.03
enq: HW - contention	2,528	0.00	1	0	0.00
latch: cache buffers lru chain	1,623	0.00	1	1	0.00
local write wait	1,570	0.00	1	1	0.00
log buffer space	136	0.00	1	8	0.00
buffer exterminate	2	50.00	1	489	0.00
control file parallel write	1,739	0.00	1	1	0.00
enq: TX - contention	2,748	0.00	1	0	0.00
enq: DV - contention	185	0.00	1	4	0.00
row cache lock	2,703	0.00	1	0	0.00
latch: redo allocation	1,047	0.00	1	0	0.00
enq: SQ - contention	3,999	0.00	0	0	0.00
library cache pin	2,064	0.00	0	0	0.00
buffer deadlock	27,301	98.78	0	0	0.02
latch: row cache objects	742	0.00	0	1	0.00
wait list latch free	29	0.00	0	11	0.00
latch: session allocation	563	0.00	0	0	0.00
SGA: allocation forcing component growth	24	41.67	0	10	0.00
latch: shared pool	660	0.00	0	0	0.00
direct path read	732	0.00	0	0	0.00
latch: library cache lock	156	0.00	0	1	0.00
latch: messages	231	0.00	0	0	0.00
latch: cache buffer handles	194	0.00	0	0	0.00
cursor: pin S	10,542	0.00	0	0	0.01
enq: FB - contention	678	0.00	0	0	0.00
enq: TX - allocate ITL entry	154	0.00	0	0	0.00
latch: object queue header heap	192	0.00	0	0	0.00
latch: redo writing	108	0.00	0	0	0.00
latch: checkpoint queue latch	39	0.00	0	1	0.00
library cache lock	3	0.00	0	9	0.00
reliable message	35	0.00	0	1	0.00
latch: enqueue hash chains	26	0.00	0	1	0.00
PX qref latch	3,004	97.90	0	0	0.00
cursor: mutex S	97	0.00	0	0	0.00
L1 validation	1	100.00	0	10	0.00
write complete waits	7	0.00	0	1	0.00
enq: PS - contention	49	0.00	0	0	0.00
direct path write	439	0.00	0	0	0.00
direct path write temp	45	0.00	0	0	0.00
cursor: mutex X	12	0.00	0	0	0.00
kkdlgon	1	0.00	0	0	0.00
direct path read temp	13	0.00	0	0	0.00
SQL*Net message from client	47,083,459	0.00	9,289,464	197	40.71
pipe get	26,893	16.74	21,083	784	0.02
Streams AQ: waiting for time management or cleanup tasks	2,790	39.53	3,492	1252	0.00
Streams AQ: qmn slave idle wait	128	0.00	3,473	27135	0.00
Streams AQ: qmn coordinator idle wait	256	50.00	3,473	13568	0.00
PX Idle Wait	1,618	76.14	2,534	1566	0.00
PL/SQL lock timer	217	99.54	2,442	11253	0.00
jobq slave wait	618	99.35	1,808	2925	0.00
PX Deq: Execution Msg	5,148	0.00	39	8	0.00
PX Deq: Execute Reply	2,651	0.00	3	1	0.00
PX Deq Credit: need buffer	4,383	0.00	1	0	0.00
PX Deq: Msg Fragment	4,359	0.00	0	0	0.00
PX Deq: Table Q Normal	5,877	0.00	0	0	0.01
PX Deq: Parse Reply	242	0.00	0	1	0.00
PX Deq: Join ACK	280	0.00	0	0	0.00
class slave wait	1	0.00	0	1	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	813,685	0.00	337	0	0.70
db file parallel write	286,365	0.00	154	1	0.25
events in waitclass Other	41,699	0.00	3	0	0.04
control file sequential read	827	0.00	2	2	0.00
db file scattered read	492	0.00	2	4	0.00
os thread startup	62	0.00	2	31	0.00
control file parallel write	1,739	0.00	1	1	0.00
db file sequential read	227	0.00	1	3	0.00
direct path read	732	0.00	0	0	0.00
latch: cache buffers chains	57	0.00	0	1	0.00
latch: redo writing	108	0.00	0	0	0.00
direct path write	333	0.00	0	0	0.00
log file sync	1	0.00	0	2	0.00
latch: library cache	1	0.00	0	0	0.00
buffer busy waits	9	0.00	0	0	0.00
rdbms ipc message	1,686,824	0.72	37,581	22	1.46
pmon timer	1,361	89.42	3,511	2579	0.00
smon timer	133,293	0.00	3,503	26	0.12
Streams AQ: waiting for time management or cleanup tasks	2,790	39.53	3,492	1252	0.00
Streams AQ: qmn slave idle wait	128	0.00	3,473	27135	0.00
Streams AQ: qmn coordinator idle wait	256	50.00	3,473	13568	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	2,104,482
IDLE_TIME	3,662,196
IOWAIT_TIME	107,016
NICE_TIME	17,999
SYS_TIME	99,103
USER_TIME	1,916,799
LOAD	3
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	53,184,240
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,918.50	19,649.90	424,014	2,021,912,369
SYS$BACKGROUND	0.00	0.00	15,097	3,633,137
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	327540	104679	1926418	12416	0	0	51304426	561846
SYS$BACKGROUND	1786	282	129	197	0	0	0	0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

Back to Top

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
725	721	305	2.38	2.91	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
411	11	20,008	0.02	1.65	fw8fr3nddyd26	PYUSLV	insert into pay_run_balances(r...
400	373	101,491	0.00	1.60	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
398	8	10,000	0.04	1.60	38kpqs2vdwfh9	PYUSLV	update pay_person_latest_balan...
361	360	56,487	0.01	1.45	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
360	358	63,127	0.01	1.44	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
339	337	56,504	0.01	1.36	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
314	309	1,300	0.24	1.26	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
311	309	56,500	0.01	1.25	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
285	283	337,939	0.00	1.14	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...

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
721	725	305	2.36	2.91	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
373	400	101,491	0.00	1.60	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
360	361	56,487	0.01	1.45	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
358	360	63,127	0.01	1.44	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
337	339	56,504	0.01	1.36	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
309	311	56,500	0.01	1.25	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
309	314	1,300	0.24	1.26	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
283	285	337,939	0.00	1.14	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
228	229	45,424	0.01	0.92	6ubqcscr1gk1b	asnDispContainer.jsp	select name, value from icx_s...
209	211	58,106	0.00	0.85	bfbyqwbr4vwms	OEXOETEL	begin OE_OEOL_SCH.SCHEDULE_LIN...
11	411	20,008	0.00	1.65	fw8fr3nddyd26	PYUSLV	insert into pay_run_balances(r...
8	398	10,000	0.00	1.60	38kpqs2vdwfh9	PYUSLV	update pay_person_latest_balan...

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,025,588,843
• Captured SQL account for 10.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
55,996,328	156,472	357.87	2.76	154.56	155.16	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
44,238,706	56,487	783.17	2.18	359.55	361.41	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
43,268,870	305	141,865.15	2.14	721.13	724.68	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
38,913,527	63,127	616.43	1.92	357.51	360.03	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
37,252,817	56,500	659.34	1.84	309.36	311.30	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
31,000,965	171,664	180.59	1.53	173.28	174.96	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
30,993,222	171,646	180.56	1.53	162.56	164.19	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
30,235,981	1,515,467	19.95	1.49	110.82	111.61	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
28,782,722	56,504	509.39	1.42	337.22	339.46	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
28,583,053	1,300	21,986.96	1.41	309.18	314.33	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,402,611	10,000	2,640.26	1.30	81.27	177.95	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
23,415,782	182,637	128.21	1.16	183.68	201.92	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
20,526,741	45,424	451.89	1.01	227.60	228.81	6ubqcscr1gk1b	asnDispContainer.jsp	select name, value from icx_s...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 439,230
• Captured SQL account for 28.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
45,240	10,000	4.52	10.30	81.27	177.95	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
36,755	2,160	17.02	8.37	13.11	144.27	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
31,688	2,160	14.67	7.21	93.02	200.95	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
23,156	19,462	1.19	5.27	146.87	212.12	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
9,084	6,484	1.40	2.07	104.11	134.61	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
9,037	182,637	0.05	2.06	183.68	201.92	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
4,779	10,000	0.48	1.09	8.29	398.20	38kpqs2vdwfh9	PYUSLV	update pay_person_latest_balan...
4,590	10,000	0.46	1.05	129.84	137.92	csvvv0fmhr1yc	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
4,508	10,000	0.45	1.03	107.73	113.52	63t8zpm02skgh	PYUSLV	SELECT DECODE(COUNT(PRR.RUN_RE...
1,488	90,807	0.02	0.34	104.45	106.63	7dtkxnqpkqszw	jtfavald.jsp	SELECT DISTINCT a.PERMISSION_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 97,850,049
• Captured SQL account for 7.9% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
1,515,467	783,564	0.52	0.00	0.00	66tmsr3446uqn	ap.oie.server.WebExpensesAM	SELECT WIAS.ACTIVITY_STATUS, ...
859,336	859,335	1.00	0.00	0.00	cd9mbmqyf4qhp	ap.oie.server.WebExpensesAM	UPDATE WF_ITEM_ACTIVITY_STATUS...
537,442	537,430	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
452,476	452,385	1.00	0.00	0.00	821fx90awyvj7	OEXOETEL	SELECT ACCOUNTING_RULE_ID , A...
337,939	337,938	1.00	0.00	0.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
315,471	242,454	0.77	0.00	0.00	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
261,810	4,450,680	17.00	0.00	0.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
182,637	182,634	1.00	0.00	0.00	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
171,664	171,664	1.00	0.00	0.00	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
171,663	171,661	1.00	0.00	0.00	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 8,510,087
• Captured SQL account for 43.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
537,447	537,442	6.32	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
337,938	337,939	3.97	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
315,475	315,471	3.71	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
261,812	261,810	3.08	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
182,636	182,637	2.15	827gtfny5uagb	CSCCCCRC	begin :con := FND_GENERIC_POLI...
171,670	171,663	2.02	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
122,725	122,722	1.44	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
115,180	115,176	1.35	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
108,307	108,306	1.27	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
100,197	100,194	1.18	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
97,137	97,131	1.14	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...
91,747	91,744	1.08	608c0n36kaw62	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.C...
91,747	91,741	1.08	bf7uwg5pa3pj6	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.V...
91,747	97,134	1.08	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,361,340	3,901	0.05	gz467g1c3hf9v	qotSCopHdrUpd.jsp	SELECT /*+ ORDERED USE_NL(QPQ ...

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;
38kpqs2vdwfh9	update pay_person_latest_balances set assignment_action_id=:b1, value=:b2, expired_assignment_action_id=:b3, expired_value=:b4, prev_assignment_action_id=:b5, prev_balance_value=:b6 where rowid=:b7
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk	SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6	SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62	begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh	SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39	select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn	SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
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
821fx90awyvj7	SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
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;
bfbyqwbr4vwms	begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp	UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc	BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb	select parameter, value from nls_session_parameters
dcvv68fju01g4	begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
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
fw8fr3nddyd26	insert into pay_run_balances(run_balance_id, assignment_action_id, assignment_id, action_sequence, defined_balance_id, balance_value, payroll_action_id, effective_date, tax_unit_id, jurisdiction_code, jurisdiction_comp1, jurisdiction_comp2, jurisdiction_comp3, source_id, source_text, tax_group, source_number, source_text2) values (:b1, :b2:b3, :b4:b5, :b6:b7, :b8, :b9, :b10:b11, to_date(:b12, :b13), :b14:b15, :b16:b17, :b18:b19, :b20:b21, :b22:b23, :b24:b25, :b26:b27, :b28:b29, :b30:b31, :b32:b33)
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;
gz467g1c3hf9v	SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VAL UE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B14 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFF ECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLAT_Q.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q. PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line _attrs_tmp_N2) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_AT TR_VALUE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B17 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QPA.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPL.LIST_HEAD ER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL( QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q.PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B18 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFE CTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_ TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B19 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QP A.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) ORDER BY 1, 2

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Back to Top

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	1,937,287	537.39	1.67
CPU used when call started	1,932,842	536.15	1.67
CR blocks created	16,011,813	4,441.53	13.84
Cached Commit SCN referenced	47,654	13.22	0.04
Commit SCN cached	8	0.00	0.00
DB time	5,209,210	1,444.99	4.50
DBWR checkpoint buffers written	2,983,521	827.60	2.58
DBWR checkpoints	34	0.01	0.00
DBWR object drop buffers written	57,953	16.08	0.05
DBWR revisited being-written buffer	197	0.05	0.00
DBWR thread checkpoint buffers written	639,346	177.35	0.55
DBWR transaction table writes	2,288	0.63	0.00
DBWR undo block writes	1,585,108	439.69	1.37
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	37,304,078	10,347.80	32.25
IMU Flushes	334,958	92.91	0.29
IMU Redo allocation size	2,288,521,852	634,814.60	1,978.66
IMU commits	601,811	166.94	0.52
IMU contention	36,074	10.01	0.03
IMU ktichg flush	10,508	2.91	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1,657	0.46	0.00
IMU undo allocation size	5,420,477,984	1,503,589.99	4,686.55
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	52,836	14.66	0.05
PX local messages sent	52,836	14.66	0.05
Parallel operations downgraded 25 to 50 pct	40	0.01	0.00
Parallel operations not downgraded	8	0.00	0.00
SQL*Net roundtrips to/from client	47,073,853	13,057.85	40.70
active txn count during cleanout	104,830,494	29,079.00	90.64
application wait time	17,679	4.90	0.02
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,901	3.86	0.01
branch node splits	1,052	0.29	0.00
buffer is not pinned count	568,695,930	157,750.94	491.70
buffer is pinned count	1,473,230,256	408,660.32	1,273.76
bytes received via SQL*Net from client	10,346,478,470	2,870,016.53	8,945.58
bytes sent via SQL*Net to client	9,458,274,336	2,623,637.00	8,177.64
calls to get snapshot scn: kcmgss	109,891,561	30,482.89	95.01
calls to kcmgas	20,036,121	5,557.83	17.32
calls to kcmgcs	11,013,488	3,055.04	9.52
change write time	44,960	12.47	0.04
cleanout - number of ktugct calls	25,265,595	7,008.44	21.84
cleanouts and rollbacks - consistent read gets	13,833,102	3,837.17	11.96
cleanouts only - consistent read gets	148,422	41.17	0.13
cluster key scan block gets	856,168	237.49	0.74
cluster key scans	237,412	65.86	0.21
commit batch/immediate performed	4,134	1.15	0.00
commit batch/immediate requested	4,134	1.15	0.00
commit cleanout failures: block lost	244,930	67.94	0.21
commit cleanout failures: buffer being written	558	0.15	0.00
commit cleanout failures: callback failure	107,015	29.68	0.09
commit cleanout failures: cannot pin	32,967	9.14	0.03
commit cleanouts	9,177,693	2,545.81	7.94
commit cleanouts successfully completed	8,792,223	2,438.88	7.60
commit immediate performed	4,134	1.15	0.00
commit immediate requested	4,134	1.15	0.00
commit txn count during cleanout	1,325,727	367.74	1.15
concurrency wait time	12,614	3.50	0.01
consistent changes	799,285,700	221,714.39	691.06
consistent gets	1,806,365,572	501,068.94	1,561.79
consistent gets - examination	1,278,942,261	354,766.64	1,105.78
consistent gets from cache	1,806,365,558	501,068.94	1,561.79
cursor authentications	2,120	0.59	0.00
data blocks consistent reads - undo records applied	795,360,272	220,625.51	687.67
db block changes	196,360,398	54,468.54	169.77
db block gets	219,222,733	60,810.34	189.54
db block gets direct	4,284	1.19	0.00
db block gets from cache	219,218,448	60,809.15	189.54
deferred (CURRENT) block cleanout applications	1,603,750	444.87	1.39
dirty buffers inspected	8,593	2.38	0.01
enqueue conversions	9,730	2.70	0.01
enqueue releases	4,344,191	1,205.04	3.76
enqueue requests	4,351,487	1,207.06	3.76
enqueue timeouts	7,210	2.00	0.01
enqueue waits	32,382	8.98	0.03
exchange deadlocks	27,303	7.57	0.02
execute count	97,850,049	27,142.69	84.60
failed probes on index block reclamation	12,621	3.50	0.01
frame signature mismatch	304	0.08	0.00
free buffer inspected	3,059,756	848.75	2.65
free buffer requested	20,391,855	5,656.51	17.63
heap block compress	32,980,869	9,148.59	28.52
hot buffers moved to head of LRU	1,309,365	363.21	1.13
immediate (CR) block cleanout applications	13,981,543	3,878.35	12.09
immediate (CURRENT) block cleanout applications	1,134,141	314.60	0.98
index crx upgrade (found)	22,160	6.15	0.02
index crx upgrade (positioned)	9,760,129	2,707.37	8.44
index fast full scans (rowid ranges)	824	0.23	0.00
index fetch by key	180,513,677	50,072.81	156.07
index scans kdiixs1	133,939,271	37,153.50	115.80
java call heap collected bytes	1,414,009,736	392,233.10	1,222.56
java call heap collected count	17,326,790	4,806.29	14.98
java call heap gc count	4,645	1.29	0.00
java call heap live object count	1,544,144	428.33	1.34
java call heap live object count max	1,552,691	430.70	1.34
java call heap live size	375,651,440	104,202.20	324.79
java call heap live size max	377,623,320	104,749.18	326.49
java call heap object count	3,709,293	1,028.92	3.21
java call heap object count max	3,719,594	1,031.78	3.22
java call heap total size	485,097,472	134,561.51	419.42
java call heap total size max	487,201,792	135,145.23	421.24
java call heap used size	514,354,416	142,677.11	444.71
java call heap used size max	516,590,616	143,297.41	446.65
leaf node 90-10 splits	20,737	5.75	0.02
leaf node splits	241,665	67.04	0.21
lob reads	21,413	5.94	0.02
lob writes	37,206	10.32	0.03
lob writes unaligned	37,206	10.32	0.03
logons cumulative	9,312	2.58	0.01
messages received	2,303,677	639.02	1.99
messages sent	2,303,676	639.02	1.99
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	478,808,494	132,817.01	413.98
opened cursors cumulative	5,511,597	1,528.87	4.77
parse count (failures)	3,250	0.90	0.00
parse count (hard)	8,876	2.46	0.01
parse count (total)	8,510,087	2,360.62	7.36
parse time cpu	43,337	12.02	0.04
parse time elapsed	46,836	12.99	0.04
physical read IO requests	290,826	80.67	0.25
physical read bytes	3,598,172,160	998,099.36	3,110.99
physical read total IO requests	320,101	88.79	0.28
physical read total bytes	4,076,904,448	1,130,895.23	3,524.90
physical read total multi block requests	12,003	3.33	0.01
physical reads	439,230	121.84	0.38
physical reads cache	438,095	121.52	0.38
physical reads cache prefetch	148,006	41.06	0.13
physical reads direct	1,135	0.31	0.00
physical reads direct temporary tablespace	403	0.11	0.00
physical reads prefetch warmup	79,001	21.91	0.07
physical write IO requests	1,200,045	332.88	1.04
physical write bytes	25,165,127,680	6,980,571.47	21,757.81
physical write total IO requests	2,417,538	670.60	2.09
physical write total bytes	58,192,146,944	16,141,958.26	50,313.03
physical write total multi block requests	1,406,043	390.02	1.22
physical writes	3,071,915	852.12	2.66
physical writes direct	5,020	1.39	0.00
physical writes direct (lob)	219	0.06	0.00
physical writes direct temporary tablespace	4,400	1.22	0.00
physical writes from cache	3,066,895	850.73	2.65
physical writes non checkpoint	2,321,319	643.91	2.01
pinned buffers inspected	4,042	1.12	0.00
prefetch warmup blocks aged out before use	243,215	67.47	0.21
prefetched blocks aged out before use	116	0.03	0.00
process last non-idle time	3,605	1.00	0.00
queries parallelized	48	0.01	0.00
recursive aborts on index block reclamation	2	0.00	0.00
recursive calls	158,520,480	43,972.10	137.06
recursive cpu usage	1,089,715	302.28	0.94
redo blocks written	64,339,000	17,847.04	55.63
redo buffer allocation retries	211	0.06	0.00
redo entries	101,050,912	28,030.58	87.37
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,277,047	354.24	1.10
redo size	31,554,693,908	8,752,977.49	27,282.24
redo subscn max counts	2,334,595	647.59	2.02
redo synch time	71,719	19.89	0.06
redo synch writes	2,186,220	606.44	1.89
redo wastage	309,193,776	85,767.47	267.33
redo write time	38,355	10.64	0.03
redo writer latching time	156	0.04	0.00
redo writes	813,759	225.73	0.70
rollback changes - undo records applied	220,158	61.07	0.19
rollbacks only - consistent read gets	2,330,479	646.45	2.01
rows fetched via callback	94,350,709	26,172.01	81.58
session connect time	0	0.00	0.00
session cursor cache hits	5,370,078	1,489.61	4.64
session logical reads	2,025,588,843	561,879.43	1,751.33
session pga memory	9,388,017,248	2,604,148.34	8,116.90
session pga memory max	10,344,395,776	2,869,438.81	8,943.78
session uga memory	###############	74,879,256.30	233,391.88
session uga memory max	67,781,103,296	18,801,845.23	58,603.65
shared hash latch upgrades - no wait	31,618,527	8,770.68	27.34
shared hash latch upgrades - wait	36,941	10.25	0.03
sorts (memory)	10,337,154	2,867.43	8.94
sorts (rows)	128,116,585	35,538.34	110.77
sql area evicted	2,782	0.77	0.00
sql area purged	3,420	0.95	0.00
summed dirty queue length	458,784	127.26	0.40
switch current to new buffer	1,358,632	376.87	1.17
table fetch by rowid	872,213,891	241,943.99	754.12
table fetch continued row	30,276,008	8,398.28	26.18
table scan blocks gotten	94,007,611	26,076.83	81.28
table scan rows gotten	7,349,181,714	2,038,594.39	6,354.11
table scans (long tables)	2,058	0.57	0.00
table scans (rowid ranges)	2,056	0.57	0.00
table scans (short tables)	5,686,081	1,577.27	4.92
total number of times SMON posted	133,293	36.97	0.12
transaction rollbacks	4,134	1.15	0.00
transaction tables consistent read rollbacks	60	0.02	0.00
transaction tables consistent reads - undo records applied	5,426	1.51	0.00
undo change vector size	11,032,576,764	3,060,333.79	9,538.78
user I/O wait time	104,993	29.12	0.09
user calls	44,944,237	12,467.11	38.86
user commits	918,140	254.68	0.79
user rollbacks	238,462	66.15	0.21
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	6,070,521	1,683.91	5.25
write clones created in background	1,563	0.43	0.00
write clones created in foreground	4,609	1.28	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	508,690	1,160,615
opened cursors current	1,008,193	1,119,537
workarea memory allocated	2,562	160
logons current	4,768	4,783

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

• Tablespace IO Stats
• File IO Stats

Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_UNDOTS1	32	0	9.06	1.00	529,391	147	250,812	0.02
APPS_TS_TX_DATA	171,477	48	3.50	1.28	170,904	47	119,598	0.19
APPS_TS_TX_IDX	94,094	26	3.51	1.32	194,488	54	50,935	0.32
APPS_ASSM_DATA	8,728	2	1.96	6.56	133,674	37	44,727	0.33
APPS_ASSM_IDX	6,589	2	1.95	1.04	112,190	31	184,854	0.09
APPS_TS_TX_INTERFACE	1,186	0	1.69	2.11	27,086	8	10,328	0.03
TEMP	478	0	3.49	10.07	9,496	3	33	1.82
SYSTEM	5,010	1	3.42	3.68	2,457	1	22,696	0.05
APPS_TS_SEED	2,179	1	4.47	1.61	4,914	1	726	1.98
APPS_TS_SUMMARY	56	0	7.50	1.00	6,954	2	2,667	0.01
APPS_TS_QUEUES	372	0	4.25	2.35	5,053	1	447	0.22
APPS_TS_ARCHIVE	66	0	4.70	1.17	1,991	1	88	4.20
SYSAUX	307	0	2.25	1.07	1,427	0	0	0.00
APPS_TS_NOLOGGING	25	0	4.40	1.56	35	0	3	0.00
CTXSYS	24	0	4.17	1.00	6	0	0	0.00
APPS_TS_MEDIA	12	0	5.83	1.00	9	0	0	0.00
ODM	12	0	5.00	1.00	3	0	0	0.00
OLAP	12	0	3.33	1.00	3	0	0	0.00
OWAPUB	12	0	4.17	1.00	3	0	0	0.00
PORTAL	12	0	4.17	1.00	3	0	0	0.00
SYNCSERVER	12	0	4.17	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,728	2	1.96	6.56	133,674	37	44,727	0.33
APPS_ASSM_IDX	/DB/visdata/apps_assm_idx.dbf	6,589	2	1.95	1.04	112,190	31	184,854	0.09
APPS_TS_ARCHIVE	/DB/visdata/archive1.dbf	35	0	5.14	1.00	1,741	0	86	4.30
APPS_TS_ARCHIVE	/DB/visdata/archive2.dbf	31	0	4.19	1.35	250	0	2	0.00
APPS_TS_MEDIA	/DB/visdata/media1.dbf	4	0	5.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media2.dbf	4	0	5.00	1.00	3	0	0	0.00
APPS_TS_MEDIA	/DB/visdata/media3.dbf	4	0	7.50	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging1.dbf	4	0	5.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging2.dbf	15	0	4.00	1.00	18	0	3	0.00
APPS_TS_NOLOGGING	/DB/visdata/nologging3.dbf	6	0	5.00	3.33	14	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues1.dbf	49	0	4.08	2.18	643	0	216	0.23
APPS_TS_QUEUES	/DB/visdata/queues2.dbf	30	0	3.00	3.10	840	0	183	0.22
APPS_TS_QUEUES	/DB/visdata/queues3.dbf	36	0	4.44	2.58	756	0	1	0.00
APPS_TS_QUEUES	/DB/visdata/queues4.dbf	41	0	3.41	2.83	741	0	2	0.00
APPS_TS_QUEUES	/DB/visdata/queues5.dbf	40	0	3.50	2.05	630	0	4	0.00
APPS_TS_QUEUES	/DB/visdata/queues6.dbf	38	0	4.47	2.76	602	0	0	0.00
APPS_TS_QUEUES	/DB/visdata/queues7.dbf	138	0	4.93	2.02	841	0	41	0.24
APPS_TS_SEED	/DB/visdata/reference1.dbf	185	0	4.76	1.81	455	0	39	3.59
APPS_TS_SEED	/DB/visdata/reference10.dbf	184	0	4.78	1.67	531	0	43	0.93
APPS_TS_SEED	/DB/visdata/reference2.dbf	219	0	4.57	1.52	521	0	44	4.32
APPS_TS_SEED	/DB/visdata/reference3.dbf	337	0	4.36	1.54	547	0	418	1.89
APPS_TS_SEED	/DB/visdata/reference4.dbf	193	0	3.99	1.67	477	0	36	2.50
APPS_TS_SEED	/DB/visdata/reference5.dbf	243	0	4.20	1.50	466	0	10	1.00
APPS_TS_SEED	/DB/visdata/reference6.dbf	223	0	4.53	1.73	514	0	14	0.71
APPS_TS_SEED	/DB/visdata/reference7.dbf	223	0	4.84	1.52	439	0	20	1.00
APPS_TS_SEED	/DB/visdata/reference8.dbf	197	0	3.91	1.69	448	0	30	3.33
APPS_TS_SEED	/DB/visdata/reference9.dbf	175	0	4.86	1.54	516	0	72	0.69
APPS_TS_SUMMARY	/DB/visdata/summary1.dbf	5	0	8.00	1.00	849	0	296	0.03
APPS_TS_SUMMARY	/DB/visdata/summary2.dbf	5	0	6.00	1.00	765	0	292	0.00
APPS_TS_SUMMARY	/DB/visdata/summary3.dbf	7	0	4.29	1.00	786	0	251	0.12
APPS_TS_SUMMARY	/DB/visdata/summary4.dbf	11	0	5.45	1.00	694	0	252	0.00
APPS_TS_SUMMARY	/DB/visdata/summary5.dbf	7	0	8.57	1.00	889	0	370	0.00
APPS_TS_SUMMARY	/DB/visdata/summary6.dbf	7	0	10.00	1.00	935	0	713	0.00
APPS_TS_SUMMARY	/DB/visdata/summary7.dbf	7	0	10.00	1.00	988	0	254	0.00
APPS_TS_SUMMARY	/DB/visdata/summary8.dbf	7	0	8.57	1.00	1,048	0	239	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data1.dbf	3,090	1	3.97	1.18	333	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data10.dbf	3,050	1	3.94	1.17	228	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data11.dbf	3,055	1	3.93	1.22	190	0	0	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data12.dbf	12,961	4	2.59	1.21	2,860	1	2,786	0.92
APPS_TS_TX_DATA	/DB/visdata/tx_data13.dbf	17,292	5	3.75	1.43	4,608	1	1,806	0.91
APPS_TS_TX_DATA	/DB/visdata/tx_data14.dbf	12,923	4	3.46	1.33	25,084	7	14,929	0.16
APPS_TS_TX_DATA	/DB/visdata/tx_data15.dbf	9,170	3	3.21	1.39	23,947	7	16,046	0.21
APPS_TS_TX_DATA	/DB/visdata/tx_data16.dbf	9,204	3	3.25	1.41	23,152	6	16,960	0.15
APPS_TS_TX_DATA	/DB/visdata/tx_data17.dbf	9,108	3	3.22	1.40	22,215	6	16,464	0.13
APPS_TS_TX_DATA	/DB/visdata/tx_data18.dbf	9,148	3	3.21	1.38	21,311	6	15,487	0.16
APPS_TS_TX_DATA	/DB/visdata/tx_data19.dbf	9,041	3	3.27	1.40	21,364	6	16,369	0.14
APPS_TS_TX_DATA	/DB/visdata/tx_data2.dbf	6,525	2	2.90	1.13	757	0	1,422	0.95
APPS_TS_TX_DATA	/DB/visdata/tx_data20.dbf	9,134	3	3.37	1.42	21,325	6	15,733	0.13
APPS_TS_TX_DATA	/DB/visdata/tx_data21.dbf	22,042	6	3.84	1.21	988	0	1,532	0.03
APPS_TS_TX_DATA	/DB/visdata/tx_data3.dbf	3,564	1	4.27	1.30	420	0	9	5.56
APPS_TS_TX_DATA	/DB/visdata/tx_data4.dbf	16,718	5	3.76	1.06	288	0	9	6.67
APPS_TS_TX_DATA	/DB/visdata/tx_data5.dbf	3,072	1	3.99	1.17	390	0	8	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data6.dbf	3,082	1	3.69	1.19	224	0	9	7.78
APPS_TS_TX_DATA	/DB/visdata/tx_data7.dbf	3,035	1	3.78	1.20	482	0	14	0.71
APPS_TS_TX_DATA	/DB/visdata/tx_data8.dbf	3,060	1	3.90	1.21	470	0	14	0.00
APPS_TS_TX_DATA	/DB/visdata/tx_data9.dbf	3,203	1	4.03	1.23	268	0	1	0.00
APPS_TS_TX_IDX	/DB/visdata/tx_idx1.dbf	2,479	1	3.10	1.12	2,141	1	1,066	0.69
APPS_TS_TX_IDX	/DB/visdata/tx_idx10.dbf	2,450	1	3.03	1.13	1,394	0	1,173	0.60
APPS_TS_TX_IDX	/DB/visdata/tx_idx11.dbf	2,456	1	3.14	1.15	1,542	0	1,110	0.54
APPS_TS_TX_IDX	/DB/visdata/tx_idx12.dbf	11,000	3	3.89	1.55	20,558	6	1,293	0.39
APPS_TS_TX_IDX	/DB/visdata/tx_idx13.dbf	9,664	3	3.61	1.28	27,015	7	3,225	0.37
APPS_TS_TX_IDX	/DB/visdata/tx_idx14.dbf	5,812	2	3.75	1.35	19,561	5	3,095	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx15.dbf	5,719	2	3.63	1.39	16,862	5	3,393	0.18
APPS_TS_TX_IDX	/DB/visdata/tx_idx16.dbf	5,686	2	3.74	1.40	15,729	4	3,598	0.12
APPS_TS_TX_IDX	/DB/visdata/tx_idx17.dbf	5,583	2	3.50	1.34	14,284	4	3,599	0.23
APPS_TS_TX_IDX	/DB/visdata/tx_idx18.dbf	5,813	2	3.68	1.36	14,873	4	5,036	0.14
APPS_TS_TX_IDX	/DB/visdata/tx_idx19.dbf	5,775	2	3.79	1.38	13,746	4	3,878	0.31
APPS_TS_TX_IDX	/DB/visdata/tx_idx2.dbf	3,065	1	3.43	1.23	1,893	1	1,150	0.41
APPS_TS_TX_IDX	/DB/visdata/tx_idx20.dbf	5,570	2	3.65	1.38	13,495	4	2,411	0.08
APPS_TS_TX_IDX	/DB/visdata/tx_idx21.dbf	3,364	1	3.92	1.51	13,987	4	2,078	0.50
APPS_TS_TX_IDX	/DB/visdata/tx_idx3.dbf	4,020	1	2.45	1.09	1,844	1	1,572	1.26
APPS_TS_TX_IDX	/DB/visdata/tx_idx4.dbf	2,667	1	3.27	1.09	3,108	1	1,365	0.87
APPS_TS_TX_IDX	/DB/visdata/tx_idx5.dbf	2,656	1	3.23	1.18	4,362	1	7,396	0.10
APPS_TS_TX_IDX	/DB/visdata/tx_idx6.dbf	2,674	1	3.26	1.17	2,411	1	1,175	0.66
APPS_TS_TX_IDX	/DB/visdata/tx_idx7.dbf	2,586	1	3.03	1.18	2,253	1	952	0.68
APPS_TS_TX_IDX	/DB/visdata/tx_idx8.dbf	2,520	1	3.21	1.12	1,752	0	1,225	0.59
APPS_TS_TX_IDX	/DB/visdata/tx_idx9.dbf	2,535	1	2.91	1.17	1,678	0	1,145	0.52
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte.dbf	144	0	1.53	2.06	4,168	1	2,029	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte2.dbf	399	0	1.38	1.81	5,533	2	2,227	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte3.dbf	184	0	2.23	2.35	4,651	1	1,954	0.02
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte4.dbf	155	0	1.81	2.36	4,370	1	1,483	0.04
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte5.dbf	246	0	1.30	1.79	4,246	1	1,757	0.03
APPS_TS_TX_INTERFACE	/DB/visdata/ts_tx_inte6.dbf	58	0	3.97	4.24	4,118	1	878	0.02
APPS_UNDOTS1	/DB/visdata/undo01.dbf	3	0	6.67	1.00	59,015	16	24,062	0.02
APPS_UNDOTS1	/DB/visdata/undo02.dbf	4	0	5.00	1.00	54,787	15	23,159	0.03
APPS_UNDOTS1	/DB/visdata/undo03.dbf	3	0	10.00	1.00	50,216	14	27,953	0.03
APPS_UNDOTS1	/DB/visdata/undo04.dbf	4	0	10.00	1.00	48,907	14	25,905	0.02
APPS_UNDOTS1	/DB/visdata/undo05.dbf	3	0	13.33	1.00	51,633	14	24,276	0.02
APPS_UNDOTS1	/DB/visdata/undo06.dbf	3	0	6.67	1.00	50,170	14	22,161	0.03
APPS_UNDOTS1	/DB/visdata/undo07.dbf	3	0	16.67	1.00	47,936	13	23,620	0.02
APPS_UNDOTS1	/DB/visdata/undo08.dbf	3	0	3.33	1.00	51,459	14	23,462	0.02
APPS_UNDOTS1	/DB/visdata/undo09.dbf	3	0	10.00	1.00	56,248	16	29,180	0.03
APPS_UNDOTS1	/DB/visdata/undo10.dbf	3	0	10.00	1.00	59,020	16	27,034	0.02
CTXSYS	/DB/visdata/ctx1.dbf	12	0	5.00	1.00	3	0	0	0.00
CTXSYS	/DB/visdata/ctx2.dbf	12	0	3.33	1.00	3	0	0	0.00
ODM	/DB/visdata/odm.dbf	12	0	5.00	1.00	3	0	0	0.00
OLAP	/DB/visdata/olap.dbf	12	0	3.33	1.00	3	0	0	0.00
OWAPUB	/DB/visdata/owa1.dbf	12	0	4.17	1.00	3	0	0	0.00
PORTAL	/DB/visdata/portal.dbf	12	0	4.17	1.00	3	0	0	0.00
SYNCSERVER	/DB/visdata/mobile01.dbf	12	0	4.17	1.00	3	0	0	0.00
SYSAUX	/DB/visdata/sysaux01.dbf	6	0	6.67	1.33	552	0	0	0.00
SYSAUX	/DB/visdata/sysaux02.dbf	301	0	2.16	1.06	875	0	0	0.00
SYSTEM	/DB/visdata/sys1.dbf	534	0	3.15	4.14	105	0	53	0.00
SYSTEM	/DB/visdata/sys2.dbf	516	0	3.91	4.43	178	0	67	0.30
SYSTEM	/DB/visdata/sys3.dbf	692	0	2.93	3.46	241	0	0	0.00
SYSTEM	/DB/visdata/sys4.dbf	624	0	2.85	3.73	231	0	0	0.00
SYSTEM	/DB/visdata/sys5.dbf	808	0	3.61	3.10	627	0	1,784	0.06
SYSTEM	/DB/visdata/sys6.dbf	552	0	3.35	4.20	63	0	8	0.00
SYSTEM	/DB/visdata/sys7.dbf	443	0	3.81	4.31	156	0	110	0.82
SYSTEM	/DB/visdata/sys8.dbf	377	0	3.77	3.21	441	0	20,628	0.04
SYSTEM	/DB/visdata/sys9.dbf	464	0	3.71	2.69	415	0	46	1.09
TEMP	/DB/visdata/temp1.dbf	124	0	3.87	16.81	2,568	1	24	1.67
TEMP	/DB/visdata/temp2.dbf	150	0	3.47	16.84	2,508	1	0
TEMP	/DB/visdata/temp3.dbf	116	0	3.02	1.00	1,950	1	0
TEMP	/DB/visdata/temp4.dbf	88	0	3.64	1.00	2,470	1	9	2.22

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,204,606	100	2,025,349,202	438,073	3,066,895	0	0	687,916

Back to Top

 

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Back to Top

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	180	90	43824	1061578	4138619	188743680	4138619
E	180	91	47928	1068193	9681343	188743680	9681343

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	578,911	10

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	20,480	1,280	43,446.69	1.31	0.00	100.00	0.00	1,048,576
E	20,480	1,280	49,931.53	0.60	0.00	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	5,488,787	5,488,787	0	0
64K	128K	11,705	11,705	0	0
128K	256K	1,144	1,144	0	0
256K	512K	1,121	1,121	0	0
512K	1024K	171,831	171,831	0	0
1M	2M	395,699	395,699	0	0
2M	4M	70	70	0	0
4M	8M	19	17	2	0
8M	16M	20	20	0	0
32M	64M	8	8	0	0
64M	128M	6	6	0	0
128M	256M	2	2	0	0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
2,560	0.13	858,717.79	8,256.51	99.00	1,092
5,120	0.25	858,717.79	8,180.31	99.00	1,058
10,240	0.50	858,717.79	8,032.82	99.00	1,008
15,360	0.75	858,717.79	7,880.45	99.00	958
20,480	1.00	858,717.79	5.06	100.00	922
24,576	1.20	858,717.79	5.06	100.00	879
28,672	1.40	858,717.79	5.06	100.00	813
32,768	1.60	858,717.79	5.06	100.00	614
36,864	1.80	858,717.79	0.00	100.00	162
40,960	2.00	858,717.79	0.00	100.00	0
61,440	3.00	858,717.79	0.00	100.00	0
81,920	4.00	858,717.79	0.00	100.00	0
122,880	6.00	858,717.79	0.00	100.00	0
163,840	8.00	858,717.79	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,024	0.40	299	13,520	2,353,193	1.00	6,441	5.88	183,211,262
1,280	0.50	523	16,756	2,355,686	1.00	3,948	3.60	183,395,087
1,536	0.60	778	20,398	2,358,012	1.00	1,622	1.48	183,566,756
1,792	0.70	1,032	24,349	2,358,464	1.00	1,170	1.07	183,602,492
2,048	0.80	1,275	30,769	2,358,533	1.00	1,101	1.00	183,608,390
2,304	0.90	1,442	35,634	2,358,538	1.00	1,096	1.00	183,608,976
2,560	1.00	1,505	36,928	2,358,538	1.00	1,096	1.00	183,609,059
2,816	1.10	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
3,072	1.20	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
3,328	1.30	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
3,584	1.40	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
3,840	1.50	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
4,096	1.60	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
4,352	1.70	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
4,608	1.80	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
4,864	1.90	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083
5,120	2.00	1,536	37,930	2,358,538	1.00	1,096	1.00	183,609,083

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
5,120	0.25	33,070
10,240	0.50	33,070
15,360	0.75	33,071
20,480	1.00	33,070
25,600	1.25	33,071
30,720	1.50	33,071
35,840	1.75	33,071
40,960	2.00	33,075

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
16	0.25	11	285	1,057	1.00	1,096	1.00	17,771
32	0.50	11	285	1,057	1.00	1,096	1.00	17,771
48	0.75	11	285	1,057	1.00	1,096	1.00	17,771
64	1.00	11	285	1,057	1.00	1,096	1.00	17,771
80	1.25	11	285	1,057	1.00	1,096	1.00	17,771
96	1.50	11	285	1,057	1.00	1,096	1.00	17,771
112	1.75	11	285	1,057	1.00	1,096	1.00	17,771
128	2.00	11	285	1,057	1.00	1,096	1.00	17,771

Back to Advisory Statistics
Back to Top

 

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	428,278	73	0
undo block	208,799	5	0
undo header	42,013	1	0
1st level bmb	5,278	0	0
segment header	2,550	0	0
2nd level bmb	900	0	0
file header block	85	0	1
extent map	10	0	0
bitmap index block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	6,455	590	5,865	570	140	245.40
UL-User-defined	68,198	67,177	1,021	1,438	20	13.82
TX-Transaction (index contention)	24,951	24,951	0	22,592	12	0.52
RO-Multiple Object Reuse (fast object reuse)	288	288	0	31	6	193.87
TM-DML	2,003,309	2,003,276	0	6	4	646.67
HW-Segment High Water Mark	255,180	255,177	3	2,170	1	0.62
TX-Transaction	1,262,042	1,262,046	0	1,852	1	0.43
DV-Diana Versioning	29,103	29,103	0	184	1	3.26
SQ-Sequence Cache	41,198	41,198	0	2,899	1	0.18
FB-Format Block	36,116	36,116	0	462	0	0.28
TX-Transaction (allocate ITL entry)	209	209	0	137	0	0.36
PS-PX Process Reservation	1,864	1,544	320	39	0	0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Back to Top

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	1,520.49	1,237,220	2,504	346		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
06-May 06:27	154,255	152,778	440	342	205	0/0	0/0/0/0/0/0
06-May 06:17	72,516	119,584	741	336	204	0/0	0/0/0/0/0/0
06-May 06:07	452,894	197,729	2,504	336	190	0/0	0/0/0/0/0/0
06-May 05:57	362,976	263,729	2,480	343	245	0/0	0/0/0/0/0/0
06-May 05:47	411,938	379,744	2,459	346	337	0/0	0/0/0/0/0/0
06-May 05:37	65,913	123,656	1,856	341	896	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

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

Back to Top

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,468	0.00		0	0
AWR Alerted Metric Element list	305,814	0.00		0	0
Consistent RBA	814,635	0.06	0.23	0	0
FOB s.o list latch	50,291	0.01	0.00	0	0
In memory undo latch	778,699,019	1.60	0.00	6	1,181,112	0.00
JOX SGA heap latch	1,923,593	0.00		0	0
JS queue state obj latch	21,630	0.00		0	0
JS slv state obj latch	183	0.00		0	0
KMG MMAN ready and startup request latch	3,391	0.00		0	0
KMG resize request state object freelist	24	0.00		0	0
KTF sga latch	12	0.00		0	1,214	0.00
KWQMN job cache list latch	13,693	0.21	0.90	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	2,385	0.00		0	3,378	0.00
OS process	14,145	0.00		0	0
OS process allocation	10,649	0.00		0	0
OS process: request allocation	9,168	0.00		0	0
PL/SQL warning settings	4,259,615	0.00		0	0
SGA IO buffer pool latch	31,438	0.06	0.00	0	31,926	0.24
SQL memory manager latch	1	0.00		0	1,199	0.00
SQL memory manager workarea list latch	6,597,867	0.01	0.02	0	0
Shared B-Tree	128	0.00		0	0
active checkpoint queue latch	1,490,741	0.78	0.00	0	2	0.00
active service list	45,304	0.06	0.00	0	1,282	0.00
begin backup scn array	133	0.00		0	0
buffer pool	20	0.00		0	0
cache buffer handles	20,124,012	1.26	0.00	0	0
cache buffers chains	4,826,676,779	1.01	0.02	29	18,030,381	2.42
cache buffers lru chain	9,826,395	0.36	0.05	1	36,022,880	0.48
cache table scan latch	2,113	0.00		0	2,113	0.00
channel handle pool latch	374,006	0.12	0.02	0	0
channel operations parent latch	1,593,242	0.50	0.00	0	0
checkpoint queue latch	21,092,556	0.01	0.01	0	3,074,770	0.03
client/application info	1,632,863	0.00	0.00	0	0
commit callback allocation	80,063	0.00	0.00	0	0
compile environment latch	2,841,382	0.00		0	0
dictionary lookup	80	0.00		0	0
dml lock allocation	3,991,099	0.17	0.01	0	0
dummy allocation	18,628	0.18	0.00	0	0
enqueue hash chains	8,744,442	0.06	0.01	0	537	0.19
enqueues	4,915,185	0.11	0.01	0	0
error message lists	816	0.98	0.00	0	0
event group latch	4,593	0.00		0	0
file cache latch	21,180	0.00		0	0
global KZLD latch for mem in SGA	8,805	0.00		0	0
global ctx hash table latch	22,057	0.00		0	0
hash table column usage latch	1,921	0.00		0	13,928,926	0.00
hash table modification latch	145	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	29,164	0.01	0.00	0	0
ksuosstats global area	242	0.00		0	0
ktm global data	133,298	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	817,273	0.12	0.02	0	0
library cache	326,878,826	0.34	0.01	5	20,320	0.74
library cache load lock	10,849	0.41	0.00	0	29	0.00
library cache lock	54,257,475	0.05	0.01	0	0
library cache lock allocation	1,407,077	0.01	0.04	0	0
library cache pin	203,849,511	0.11	0.01	1	67	0.00
library cache pin allocation	490,675	0.00	0.00	0	0
list of block allocation	444,346	0.01	0.00	0	0
loader state object freelist	290,376	0.00	0.00	0	0
longop free list parent	33	0.00		0	33	0.00
message pool operations parent latch	379,770	0.01	0.07	0	0
messages	6,477,944	0.44	0.01	0	0
mostly latch-free SCN	864,109	4.14	0.05	1	0
multiblock read objects	26,538	0.00	0.00	0	0
ncodef allocation latch	192	0.00		0	0
object queue header heap	4,190,454	0.03	0.17	0	361,914	0.07
object queue header operation	34,751,079	0.15	0.40	2	19,550	1.22
object stats modification	371,802	0.02	0.00	0	0
parallel query alloc buffer	8,156	0.83	0.00	0	0
parallel query stats	528	13.26	0.00	0	0
parameter table allocation management	21,960	1.14	0.45	0	0
post/wait queue	1,216,663	0.05	0.02	0	495,020	0.01
process allocation	9,216	0.15	0.64	0	4,592	0.02
process group creation	9,168	0.00		0	0
process queue	5,030	0.85	0.00	0	0
process queue reference	774,153	0.05	0.00	0	84,313	3.56
qmn task queue latch	512	0.00		0	0
query server freelists	4,256	5.38	0.00	0	0
query server process	8	0.00		0	8	0.00
redo allocation	5,325,622	2.62	0.01	1	100,857,373	2.03
redo copy	0			0	101,053,376	0.05
redo writing	4,353,191	0.36	0.01	0	0
resmgr group change latch	774,555	0.00		0	0
resmgr:actses active list	27,404	0.51	0.98	0	0
resmgr:actses change group	26,805	0.00		0	0
resmgr:free threads list	18,626	0.20	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	115,899,453	0.20	0.00	0	5,878	0.15
rules engine aggregate statistics	37,940	0.00		0	0
rules engine rule set statistics	122,317	0.00	0.00	0	0
rules engine rule statistics	46,437	0.00		0	0
sequence cache	16,199,414	0.42	0.00	0	0
session allocation	18,630,131	0.45	0.01	0	0
session idle bit	92,709,755	0.01	0.02	0	0
session state list latch	53,798	0.12	0.62	0	0
session switching	13,717	0.00		0	0
session timer	1,282	0.00		0	0
shared pool	7,417,384	0.15	0.06	0	0
shared pool sim alloc	375	0.00		0	0
shared pool simulator	1,687,145	0.00	0.00	0	0
sim partition latch	1	0.00		0	22,940	0.10
simulator hash latch	2,460	0.00		0	0
simulator lru latch	1,380	0.00		0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	1,276,012	0.13	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	237	0.00		0	0
temporary table state object allocation	11,459	0.00		0	0
threshold alerts latch	615	0.00		0	0
trace latch	33	0.00		0	0
transaction allocation	106,251	0.00		0	0
transaction branch allocation	192	0.00		0	0
undo global data	981,988,827	0.85	0.00	5	16,110	0.02
user lock	35,314	0.02	0.17	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
cache buffers chains	4,826,676,779	48,613,119	1,201,585	47,569,342	0	0	0
In memory undo latch	778,699,019	12,462,079	24,439	12,441,047	0	0	0
undo global data	981,988,827	8,391,718	8,166	8,384,794	0	0	0
library cache	326,878,826	1,112,813	9,055	1,104,693	0	0	0
cache buffer handles	20,124,012	254,526	194	254,370	0	0	0
row cache objects	115,899,453	236,608	742	235,912	0	0	0
library cache pin	203,849,511	221,764	2,530	219,493	0	0	0
redo allocation	5,325,622	139,420	1,047	138,555	0	0	0
session allocation	18,630,131	83,026	563	82,517	0	0	0
sequence cache	16,199,414	68,691	65	68,640	0	0	0
object queue header operation	34,751,079	51,366	20,565	32,490	0	0	0
mostly latch-free SCN	864,109	35,744	1,836	34,086	0	0	0
cache buffers lru chain	9,826,395	34,978	1,623	33,440	0	0	0
library cache lock	54,257,475	28,649	156	28,501	0	0	0
messages	6,477,944	28,557	231	28,335	0	0	0
redo writing	4,353,191	15,532	108	15,426	0	0	0
active checkpoint queue latch	1,490,741	11,654	14	11,640	0	0	0
session idle bit	92,709,755	11,212	242	10,974	0	0	0
shared pool	7,417,384	10,967	660	10,371	0	0	0
channel operations parent latch	1,593,242	7,902	13	7,890	0	0	0
dml lock allocation	3,991,099	6,727	60	6,672	0	0	0
enqueues	4,915,185	5,285	56	5,236	0	0	0
enqueue hash chains	8,744,442	5,117	26	5,093	0	0	0
checkpoint queue latch	21,092,556	3,051	39	3,015	0	0	0
sort extent pool	1,276,012	1,633	12	1,621	0	0	0
object queue header heap	4,190,454	1,121	192	945	0	0	0
lgwr LWN SCN	817,273	996	21	976	0	0	0
post/wait queue	1,216,663	614	11	603	0	0	0
Consistent RBA	814,635	495	112	403	0	0	0
channel handle pool latch	374,006	460	7	453	0	0	0
SQL memory manager workarea list latch	6,597,867	361	6	356	0	0	0
parameter table allocation management	21,960	251	114	141	0	0	0
resmgr:actses active list	27,404	140	137	5	0	0	0
library cache lock allocation	1,407,077	104	4	101	0	0	0
session state list latch	53,798	63	39	24	0	0	0
KWQMN job cache list latch	13,693	29	26	3	0	0	0
message pool operations parent latch	379,770	28	2	27	0	0	0
process allocation	9,216	14	9	5	0	0	0
user lock	35,314	6	1	5	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	kturbk	0	15,071	17,391
In memory undo latch	ktiFlush: child	0	5,201	3,035
In memory undo latch	kticmt: child	0	3,582	696
In memory undo latch	ktichg: child	0	425	3,241
In memory undo latch	ktiTxnPoolFree	0	147	0
In memory undo latch	ktiBRacquire	0	9	0
In memory undo latch	ktbgfc	0	4	86
KWQMN job cache list latch	kwqmnuji: update job item	0	27	1
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	6	5
active checkpoint queue latch	kcbbacq: scan active checkpoints	0	14	14
active service list	ksws_event: ksws event	0	1	1
cache buffer handles	kcbzgs	0	131	112
cache buffer handles	kcbzfs	0	63	83
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	1,452,918	1,664,729
cache buffers chains	kcbgtcr: fast path	0	629,642	25,543
cache buffers chains	kcbchg: kslbegin: call CR func	0	532,654	1,101,650
cache buffers chains	kcbgtcr: kslbegin excl	0	131,116	55,709
cache buffers chains	kcbzgb: scan from tail. nowait	0	123,465	0
cache buffers chains	kcbrls: kslbegin	0	41,855	80,812
cache buffers chains	kcbgcur: kslbegin	0	27,366	13,702
cache buffers chains	kcbget: pin buffer	0	19,826	8,177
cache buffers chains	kcbzwb	0	6,155	4,466
cache buffers chains	kcbcge	0	3,355	6,179
cache buffers chains	kcbget: exchange rls	0	2,429	2,676
cache buffers chains	kcbget: exchange	0	1,676	4,247
cache buffers chains	kcbnlc	0	307	1,468
cache buffers chains	kcbbxsv	0	194	190
cache buffers chains	kcb_is_private	0	145	1,840
cache buffers chains	kcbgtcr: kslbegin shared	0	102	87
cache buffers chains	kcbesc: escalate	0	68	37
cache buffers chains	kcbnew: new latch again	0	67	9
cache buffers chains	kcbso1: set no access	0	51	48
cache buffers chains	kcb_pre_apply: kcbhq61	0	36	1,649
cache buffers chains	kcb_post_apply: kcbhq63	0	16	251
cache buffers chains	kcbbic2	0	10	5
cache buffers chains	kcbzib: finish free bufs	0	8	3
cache buffers chains	kcb_post_apply: kcbhq62	0	6	344
cache buffers chains	kcbzib: multi-block read: nowait	0	2	0
cache buffers chains	kcbgtcr	0	1	0
cache buffers chains	kcbo_ivd_process	0	1	38
cache buffers chains	kcbw_next_free	0	1	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	0	1	0
cache buffers chains	kcbzib: exchange rls	0	1	0
cache buffers lru chain	kcbzgws	0	887	0
cache buffers lru chain	kcbbxsv: move to being written	0	272	564
cache buffers lru chain	kcbo_link_q	0	188	13
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	129	0
cache buffers lru chain	kcbzgb: posted for free bufs	0	50	369
cache buffers lru chain	kcbo_ivd_proc	0	38	278
cache buffers lru chain	kcbbic2	0	29	291
cache buffers lru chain	kcbzswcu	0	26	64
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	0	3	27
cache buffers lru chain	kcbzfw	0	1	1
channel handle pool latch	ksrchconnect()	0	9	9
channel handle pool latch	ksrchdelete()	0	6	6
channel operations parent latch	ksrapublish()	0	28	6
channel operations parent latch	ksrchdelete()	0	19	14
channel operations parent latch	ksrsconsume()	0	8	9
channel operations parent latch	ksrmfree()	0	7	1
channel operations parent latch	ksrchconnect()	0	3	12
channel operations parent latch	ksrwait()	0	3	26
checkpoint queue latch	kcbkubc	0	21	17
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	11	18
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	5	2
checkpoint queue latch	kcbswcu: Switch buffers	0	2	2
client/application info	kqp327i	0	1	1
cost function	kzulrl	0	1	1
dml lock allocation	ktaiam	0	44	44
dml lock allocation	ktaidm	0	16	16
enqueue hash chains	ksqgtl3	0	15	16
enqueue hash chains	ksqrcl	0	10	9
enqueue hash chains	ksqcmi: get hash chain latch after wait	0	1	1
enqueues	ksqies	0	22	26
enqueues	ksqgel: create enqueue	0	21	23
enqueues	ksqdel	0	13	7
lgwr LWN SCN	kcs023	0	495	0
library cache	kglpndl: child: after processing	0	3,557	73
library cache	kglpnp: child	0	3,174	4,813
library cache	kglobpn: child:	0	806	1,352
library cache	kglpndl: child: before processing	0	537	2,164
library cache	kglLockCursor	0	229	293
library cache	kglScanDependency	0	189	0
library cache	kglhdgn: child:	0	92	135
library cache	kglpin	0	81	33
library cache	kgldte: child 0	0	75	157
library cache	kglic	0	31	0
library cache	kgldti: 2child	0	16	5
library cache	kglhdiv: child	0	7	0
library cache	kglivl: child	0	6	0
library cache	kglupd: child	0	3	0
library cache	kglget: unpin heap 0	0	1	1
library cache	kglhdgh: child:	0	1	1
library cache	kglukp: child	0	1	0
library cache lock	kgllkdl: child: cleanup	0	85	97
library cache lock	kgllkdl: child: no lock handle	0	79	17
library cache lock	kgllkal: child: multiinstance	0	71	57
library cache lock allocation	kgllkget	0	4	4
library cache pin	kglpndl	0	1,183	679
library cache pin	kglpnp: child	0	1,143	1,474
library cache pin	kglpnal: child: alloc space	0	203	376
library cache pin	kglpnck	0	1	1
message pool operations parent latch	ksrmalloc()	0	3	2
messages	ksaamb: after wakeup	0	80	109
messages	ksarcv: after wait	0	78	104
messages	ksarcv	0	73	15
mostly latch-free SCN	kcslcu3	0	1,342	1,857
mostly latch-free SCN	kcs01	0	62	114
mostly latch-free SCN	kcsnew_scn_rba	0	50	0
mostly latch-free SCN	kcs024	0	20	0
object queue header heap	kcbo_link_q:reget	0	184	3
object queue header heap	kcbw_link_q:alloc	0	7	189
object queue header heap	kcbw_unlink_q	0	1	0
object queue header operation	kcbo_ivbo	0	21,422	5,519
object queue header operation	kcbw_link_q	0	3,601	1,939
object queue header operation	kcbw_unlink_q	0	1,056	6,200
object queue header operation	kcbo_switch_mq_bg	0	302	3,079
object queue header operation	kcbo_switch_q_bg	0	284	2,292
object queue header operation	kcbo_switch_cq	0	121	2,913
object queue header operation	kcbo_link_q:reget	0	88	134
object queue header operation	kcbo_write_q	0	24	16
object queue header operation	kcbo_swap_buf_bg	0	20	4,624
object queue header operation	kcbo_service_ockpt	0	19	0
object queue header operation	kcbo_swap_buf	0	7	505
object queue header operation	kcbw_unlink_q_bg	0	2	12
parameter table allocation management	ksp_param_table_free	0	114	114
post/wait queue	ksliwat:remove	0	10	10
post/wait queue	kslpstevent:get	0	1	1
process allocation	ksucrp	0	7	0
process allocation	ksudlp	0	2	6
redo allocation	kcrfw_redo_gen: redo allocation 1	0	655	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	223	881
redo allocation	kcrfw_redo_write: before write	0	79	104
redo allocation	kcrfw_redo_write: more space	0	47	72
redo allocation	kcrfw_redo_gen: redo allocation 2	0	43	0
redo writing	kcrfw_post: after write	0	39	0
redo writing	kcrfw_post: rba scn pair	0	36	0
redo writing	kcrfwcr	0	25	108
redo writing	kcrfw_cal_target_rba	0	8	0
resmgr:actses active list	kgskchclass	0	137	83
row cache objects	kqreqd: reget	0	568	5
row cache objects	kqrpre: find obj	0	128	602
row cache objects	kqreqd	0	42	135
row cache objects	kqrso	0	2	0
sequence cache	kdnssd	0	46	1
sequence cache	kdnnxt: cached seq	0	14	0
sequence cache	kdnss	0	5	66
session allocation	ksuxds: KSUSFCLC not set	0	210	31
session allocation	ksuprc	0	105	118
session allocation	ksuxds: not user session	0	75	71
session allocation	ksucri	0	68	193
session allocation	ksudlc	0	57	104
session allocation	kspallmod	0	17	0
session allocation	kxfpqidqr	0	10	26
session allocation	ksudlp	0	8	0
session allocation	ksursi	0	8	17
session allocation	kxfprdp	0	4	3
session allocation	ksucrp	0	1	0
session idle bit	ksupuc: set busy	0	284	111
session idle bit	ksupuc: clear busy	0	106	272
session idle bit	ksuxds	0	9	16
session state list latch	kpseqd	0	37	0
session state list latch	kpscad	0	1	0
session state list latch	kpscdl	0	1	17
shared pool	kghupr1	0	357	461
shared pool	kghalo	0	242	95
shared pool	kghfrunp: clatch: nowait	0	162	0
shared pool	kghfrunp: alloc: wait	0	29	0
shared pool	kghfre	0	26	86
shared pool	kghfrunp: clatch: wait	0	10	11
shared pool	kghalp	0	6	16
sort extent pool	ktstdt: dealloc sort extent	0	9	0
sort extent pool	ktstaddextent1	0	2	0
sort extent pool	ktstcrtobj	0	1	0
undo global data	kturimugur: child	0	7,263	4,874
undo global data	ktudba: KSLBEGIN	0	862	3,268
undo global data	ktucof: at start	0	14	0
undo global data	ktudnx:child	0	12	11
undo global data	ktufrbs: child	0	9	12
undo global data	ktubnd:child	0	6	1

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 2,025,588,843
• Captured Segments account for 29.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	62,399,696	3.08
INV	APPS_TS_TX_IDX	MTL_ITEM_CATEGORIES_U1		INDEX	50,591,856	2.50
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	23,164,368	1.14
ICX	APPS_TS_TX_DATA	ICX_SESSION_ATTRIBUTES		TABLE	20,817,824	1.03
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	19,690,672	0.97

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 439,230
• Captured Segments account for 16.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	35,017	7.97
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	13,110	2.98
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	9,554	2.18
HR	APPS_TS_TX_IDX	PAY_PERSON_LATEST_BALA_N50		INDEX	4,777	1.09
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS		TABLE	4,048	0.92

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	13,955	31.54
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS		TABLE	11,202	25.32
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	8,934	20.19
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	2,763	6.24
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	1,677	3.79

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	26	21.85
GL	APPS_ASSM_IDX	GL_IMPORT_REFERENCES_N1		INDEX	25	21.01
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	16	13.45
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	14	11.76
SYS	SYSTEM	SEG$		TABLE	13	10.92

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	132,600	36.61
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	72,775	20.09
SYS	SYSTEM	DBMS_LOCK_ALLOCATED		TABLE	20,591	5.69
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	17,881	4.94
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	17,363	4.79

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

• "Pct Misses" should be very low (< 2% in most cases)
• "Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	5	20.00	0		2	1
dc_constraints	648	47.07	0		648	0
dc_files	6,660	0.00	0		0	111
dc_global_oids	7,062,970	0.00	0		0	48
dc_histogram_data	61,984	2.16	0		0	612
dc_histogram_defs	382,682	3.11	0		4,044	2,073
dc_object_grants	65,567	0.09	0		0	76
dc_object_ids	11,402,996	0.02	0		58	1,093
dc_objects	165,924	1.22	0		347	802
dc_profiles	8,866	0.00	0		0	1
dc_rollback_segments	19,342	0.00	0		0	353
dc_segments	335,341	0.76	0		15,598	1,357
dc_sequences	51,259	0.16	0		51,259	110
dc_table_scns	19,384	0.04	0		0	5
dc_tablespace_quotas	15,463	0.14	0		211	40
dc_tablespaces	5,439,479	0.00	0		0	21
dc_usernames	466,245	0.00	0		0	19
dc_users	13,676,873	0.00	0		0	63
outstanding_alerts	279	2.87	0		11	43

Back to Top

 

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	574,403	0.02	39,097,210	0.00	16	0
CLUSTER	124	0.81	290	1.72	4	0
INDEX	14,285	0.45	15,096	0.62	0	0
JAVA DATA	626	0.00	0		0	0
PIPE	45,444	2.54	66,869	1.73	0	0
SQL AREA	6,285	88.23	106,916,002	0.42	3,721	512
TABLE/PROCEDURE	370,176	0.28	53,412,075	0.01	1,285	0
TRIGGER	26,261	0.10	1,357,901	0.01	25	0

Back to Top

 

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Back to Top

Process Memory Summary

• B: Begin snap E: End snap
• All rows below contain absolute values (i.e. not diffed over the interval)
• Max Alloc is Maximum PGA Allocation size at snapshot time
• Hist Max Alloc is the Historical Max Allocation for still-connected processes
• ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	34,351.85		12.16	7.17	38	38	2,824	2,824
	Freeable	3,421.63	0.00	1.37	0.83	9		2,497	2,497
	SQL	3,224.30	1,652.93	1.14	0.72	4	21	2,816	2,815
	PL/SQL	2,196.59	175.41	0.78	0.96	3	3	2,824	2,824
	JAVA	243.73	242.60	2.26	0.33	5	8	108	108
E	Other	39,695.14		13.97	8.63	41	41	2,842	2,842
	Freeable	3,834.00	0.00	1.50	0.93	9		2,551	2,551
	SQL	3,643.29	1,902.13	1.29	0.77	5	21	2,834	2,833
	PL/SQL	2,515.84	196.46	0.89	0.99	3	3	2,842	2,842
	JAVA	244.23	243.09	2.26	0.33	5	8	108	108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	18,857,590,784	18,689,818,624
Fixed Size	2,111,120
Redo Buffers	14,663,680
Variable Size	2,600,470,896	2,768,243,056

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	34.66	35.23	1.66
shared	KTI-UNDO	53.19	53.19	0.00
shared	PL/SQL MPCODE	66.50	68.84	3.53
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	324.24	344.65	6.30
shared	library cache	786.12	916.79	16.62
shared	parameter table block	52.40	52.55	0.29
shared	private strands	99.77	99.77	0.00
shared	sessions	36.42	36.42	0.00
shared	sql area	333.00	337.32	1.30
shared	trace buffer	44.17	44.69	1.17
	buffer_cache	17,984.00	17,824.00	-0.89
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.98	13.98	0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

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

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.

Back to Top

 

init.ora Parameters

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_b_tree_bitmap_plans	FALSE
_fast_full_scan_enabled	FALSE
_like_with_bind_as_equality	TRUE
_sort_elimination_cost_ratio	5
_sqlexec_progression_cost	2147483647
_swrf_mmon_dbfus	FALSE
_swrf_mmon_flush	FALSE
_system_trig_enabled	TRUE
aq_tm_processes	1
background_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/bdump
compatible	10.2.0.3
control_files	/raw_links/cntrl01, /raw_links/cntrl02, /raw_links/cntrl03
core_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/cdump
cursor_sharing	exact
cursor_space_for_time	FALSE
db_block_checking	false
db_block_checksum	TRUE
db_block_size	8192
db_cache_advice	off
db_files	130
db_name	VIS
db_writer_processes	3
dml_locks	10000
fast_start_mttr_target	180
java_pool_size	67108864
job_queue_processes	2
lock_sga	FALSE
log_buffer	14219264
log_checkpoint_timeout	1200
log_checkpoints_to_alert	TRUE
max_dump_file_size	unlimited
nls_comp	binary
nls_date_format	DD-MON-RR
nls_language	american
nls_length_semantics	BYTE
nls_numeric_characters	.,
nls_sort	binary
nls_territory	america
olap_page_pool_size	4194304
open_cursors	1000
optimizer_secure_view_merging	FALSE
parallel_max_servers	8
pga_aggregate_target	21474836480
plsql_code_type	INTERPRETED
plsql_native_library_dir	/DB/oracle/product/10.2.0/db_1/native
plsql_native_library_subdir_count	300
plsql_optimize_level	2
processes	3600
remote_login_passwordfile	EXCLUSIVE
replication_dependency_tracking	FALSE
session_cached_cursors	500
sessions	7200
sga_target	21474836480
shared_pool_reserved_size	209715200
shared_pool_size	2097152000
timed_statistics	TRUE
trace_enabled	FALSE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
user_dump_dest	/DB/oracle/product/10.2.0/db_1/admin/VIS/udump
utl_file_dir	/usr/tmp
workarea_size_policy	AUTO

Back to Top

End of Report