WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
VIS	220594996	VIS	1	10.2.0.3.0	NO	r12db.sanmateo.ibm.com

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	995	26-Mar-09 21:37:43	169	35.5
End Snap:	996	26-Mar-09 23:00:35	169	34.0
Elapsed:		82.86 (mins)
DB Time:		555.32 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	8,128M	8,128M	Std Block Size:	8K
Shared Pool Size:	2,000M	2,000M	Log Buffer:	30,724K

Load Profile

	Per Second	Per Transaction
Redo size:	3,572,179.06	49,710.54
Logical reads:	656,497.44	9,135.84
Block changes:	24,544.35	341.56
Physical reads:	142.01	1.98
Physical writes:	342.73	4.77
User calls:	4,675.01	65.06
Parses:	3,703.04	51.53
Hard parses:	0.10	0.00
Sorts:	3,530.97	49.14
Logons:	0.05	0.00
Executes:	42,713.87	594.41
Transactions:	71.86

% Blocks changed per Read:	3.74	Recursive Call %:	95.08
Rollback per transaction %:	1.43	Rows per Sort:	1.89

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.94	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	100.01	Soft Parse %:	100.00
Execute to Parse %:	91.33	Latch Hit %:	96.42
Parse CPU to Parse Elapsd %:	87.49	% Non-Parse CPU:	99.14

Shared Pool Statistics

	Begin	End
Memory Usage %:	21.88	23.01
% SQL with executions>1:	87.33	94.42
% Memory for SQL w/exec>1:	89.11	90.77

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		28,533		85.6
enq: UL - contention	56,040	2,896	52	8.7	Application
log file sync	151,429	788	5	2.4	Commit
latch: cache buffers chains	13,355,671	764	0	2.3	Concurrency
wait list latch free	12,617	136	11	.4	Other

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): 33319.3s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	32,165.32	96.54
DB CPU	28,532.91	85.63
PL/SQL execution elapsed time	10,635.94	31.92
parse time elapsed	342.26	1.03
repeated bind elapsed time	17.03	0.05
inbound PL/SQL rpc elapsed time	10.93	0.03
sequence load elapsed time	3.99	0.01
hard parse elapsed time	2.17	0.01
connection management call elapsed time	0.47	0.00
PL/SQL compilation elapsed time	0.27	0.00
hard parse (sharing criteria) elapsed time	0.06	0.00
Java execution elapsed time	0.05	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
DB time	33,319.31
background elapsed time	1,405.05
background cpu time	190.48

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
Application	62,846	0.12	2,898	46	0.18
Concurrency	15,456,865	0.02	987	0	43.26
Commit	151,429	0.00	788	5	0.42
Other	267,957	63.17	156	1	0.75
User I/O	710,167	0.00	51	0	1.99
Network	22,536,879	0.00	21	0	63.08
System I/O	287,277	0.00	20	0	0.80
Configuration	8,985	0.00	2	0	0.03

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
enq: UL - contention	56,040	0.13	2,896	52	0.16
log file sync	151,429	0.00	788	5	0.42
latch: cache buffers chains	13,355,671	0.00	764	0	37.38
wait list latch free	12,617	0.00	136	11	0.04
buffer busy waits	1,838,962	0.00	120	0	5.15
enq: TX - index contention	118,143	0.00	47	0	0.33
db file sequential read	703,385	0.00	46	0	1.97
cursor: pin S wait on X	4,708	65.31	33	7	0.01
control file parallel write	2,233	0.00	18	8	0.01
SQL*Net message to client	21,811,957	0.00	18	0	61.05
latch: In memory undo latch	121,687	0.00	17	0	0.34
read by other session	5,320	0.00	5	1	0.01
Streams AQ: qmn coordinator waiting for slave to start	1	100.00	5	4884	0.00
latch free	21,358	0.00	5	0	0.06
SQL*Net more data from client	722,670	0.00	4	0	2.02
buffer deadlock	174,048	97.22	3	0	0.49
kksfbc child completion	70	75.71	3	38	0.00
enq: TX - row lock contention	5,160	0.00	2	0	0.01
latch: library cache	10,457	0.00	2	0	0.03
os thread startup	55	0.00	2	35	0.00
latch: cache buffer handles	7,507	0.00	2	0	0.02
log file parallel write	216,671	0.00	1	0	0.61
enq: SQ - contention	8,852	0.00	1	0	0.02
latch: undo global data	5,952	0.00	1	0	0.02
latch: library cache pin	5,048	0.00	1	0	0.01
db file parallel write	67,679	0.00	1	0	0.19
log file switch completion	29	0.00	0	16	0.00
SQL*Net break/reset to client	1,646	0.00	0	0	0.00
latch: session allocation	1,501	0.00	0	0	0.00
LGWR wait for redo copy	6,012	0.00	0	0	0.02
rdbms ipc reply	521	0.00	0	1	0.00
latch: library cache lock	1,638	0.00	0	0	0.00
latch: redo allocation	677	0.00	0	0	0.00
enq: CU - contention	6	0.00	0	24	0.00
cursor: pin S	37,257	0.00	0	0	0.10
latch: row cache objects	470	0.00	0	0	0.00
latch: cache buffers lru chain	262	0.00	0	0	0.00
SQL*Net more data to client	2,252	0.00	0	0	0.01
latch: object queue header operation	46	0.00	0	1	0.00
enq: HW - contention	76	0.00	0	0	0.00
latch: enqueue hash chains	86	0.00	0	0	0.00
control file sequential read	690	0.00	0	0	0.00
db file scattered read	35	0.00	0	0	0.00
cursor: pin X	2	50.00	0	5	0.00
latch: checkpoint queue latch	26	0.00	0	0	0.00
latch: shared pool	12	0.00	0	0	0.00
enq: TX - allocate ITL entry	25	0.00	0	0	0.00
direct path read	996	0.00	0	0	0.00
latch: messages	8	0.00	0	0	0.00
log file single write	2	0.00	0	0	0.00
direct path write temp	109	0.00	0	0	0.00
cursor: mutex X	14	0.00	0	0	0.00
direct path read temp	109	0.00	0	0	0.00
direct path write	213	0.00	0	0	0.00
latch: redo writing	2	0.00	0	0	0.00
log file sequential read	2	0.00	0	0	0.00
undo segment extension	1	0.00	0	0	0.00
SQL*Net message from client	21,811,947	0.00	282,357	13	61.05
Streams AQ: waiting for messages in the queue	11,511	98.19	98,068	8519	0.03
pipe get	5,951	99.33	24,264	4077	0.02
PL/SQL lock timer	2,925	99.76	23,069	7887	0.01
Streams AQ: qmn slave idle wait	1,369	0.00	5,347	3906	0.00
Streams AQ: qmn coordinator idle wait	2,268	34.08	4,848	2138	0.01
Streams AQ: waiting for time management or cleanup tasks	3	100.00	2,189	729684	0.00
jobq slave wait	595	97.14	1,732	2911	0.00
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	2,233	0.00	18	8	0.01
events in waitclass Other	6,700	0.01	6	1	0.02
os thread startup	55	0.00	2	35	0.00
log file parallel write	216,671	0.00	1	0	0.61
db file parallel write	67,679	0.00	1	0	0.19
db file sequential read	71	0.00	0	2	0.00
latch: cache buffers chains	29	0.00	0	1	0.00
control file sequential read	656	0.00	0	0	0.00
buffer busy waits	4	0.00	0	1	0.00
direct path read	996	0.00	0	0	0.00
log file single write	2	0.00	0	0	0.00
direct path write	213	0.00	0	0	0.00
latch: redo writing	2	0.00	0	0	0.00
log file sequential read	2	0.00	0	0	0.00
rdbms ipc message	445,045	3.71	46,325	104	1.25
Streams AQ: qmn slave idle wait	1,369	0.00	5,347	3906	0.00
pmon timer	2,024	83.55	4,851	2397	0.01
Streams AQ: qmn coordinator idle wait	2,268	34.08	4,848	2138	0.01
smon timer	243	2.88	4,591	18892	0.00
Streams AQ: waiting for time management or cleanup tasks	3	100.00	2,189	729684	0.00
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	3,162,388
IDLE_TIME	2,803,087
IOWAIT_TIME	61,010
NICE_TIME	49
SYS_TIME	189,145
USER_TIME	2,944,247
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	339,052
NUM_CPUS	12
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
VIS	33,317.50	28,531.60	704,829	3,263,847,163
SYS$USERS	1.80	1.30	119	11,483
SYS$BACKGROUND	0.00	0.00	1,051	83,319

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
VIS	708569	5090	15456777	98549	0	0	22536387	2115
SYS$USERS	327	16	0	0	0	0	1	0
SYS$BACKGROUND	1269	12	88	194	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
19,968	19,870	249,233	0.08	59.93	4f5mjr4hnaz3u	PYUSLV	declare begin pay_archive...
19,872	19,774	249,671	0.08	59.64	5sfm6rppc4y8x	PYUSLV	BEGIN pay_us_action_arch.actio...
3,724	1,191	60	62.06	11.18	dab1prc9qyv3v	PYUSLV	begin hr_nonrun_asact...
1,398	1,307	249,987	0.01	4.19	4ds53shhfcynn	PYUSLV	declare begin hr_pre_pay....
1,241	1,238	3,748,793	0.00	3.72	g2daxnc5b7rav	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
1,026	1,024	3,747,687	0.00	3.08	7rks7t2gukcwn	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
1,012	887	249,792	0.00	3.04	9jv68n0ctas75	PYUSLV	begin pay_core_utils . get_pro...
932	931	4,247,316	0.00	2.80	6500rnmy4f88w	PYUSLV	SELECT PAP.ACCRUAL_PLAN_ID, P...
905	903	1,499,267	0.00	2.72	01pkua627ktjk	PYUSLV	SELECT fnd_number.number_to_ca...
893	891	2,748,986	0.00	2.68	dz7tyjxnar7gt	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
816	412	12,499	0.07	2.45	7y9t68kb4mc6q	PYUSLV	BEGIN pay_us_action_arch.actio...
650	643	28,392,138	0.00	1.95	4gz4b2bh1fs14	PYUSLV	SELECT CONTEXT_ID, SEQUENCE_N...
633	579	249,995	0.00	1.90	699jt64x8hadf	PYUSLV	UPDATE PAY_ASSIGNMENT_ACTIONS ...
585	60	12,512	0.05	1.76	73rvua18a9ytx	PYUSLV	declare ret number ; BEGIN hr_...
503	502	1,124,666	0.00	1.51	8v2cvg5zhw9ua	PYUSLV	SELECT fnd_number.number_to_ca...
468	467	2,749,822	0.00	1.41	6v07302134wyf	PYUSLV	INSERT INTO PAY_ACTION_INFORMA...
440	438	10,720,406	0.00	1.32	02k10jzw8c495	PYUSLV	SELECT INTLK.LOCKING_ACTION_ID...
419	419	13,593,609	0.00	1.26	grg3zu94xp62h	PYUSLV	SELECT PDB.BALANCE_TYPE_ID, P...
403	397	249,840	0.00	1.21	7mmdd7sypzu9x	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
401	397	249,991	0.00	1.20	7d66dw0vz7yaa	PYUSLV	begin pay_cc_process_utils . r...
393	343	249,984	0.00	1.18	36z3h9rgkd8aa	PYUSLV	begin ...
366	365	249,901	0.00	1.10	2z261p0p82p32	PYUSLV	BEGIN FFP51704_01010001.FORMUL...

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
19,870	19,968	249,233	0.08	59.93	4f5mjr4hnaz3u	PYUSLV	declare begin pay_archive...
19,774	19,872	249,671	0.08	59.64	5sfm6rppc4y8x	PYUSLV	BEGIN pay_us_action_arch.actio...
1,307	1,398	249,987	0.01	4.19	4ds53shhfcynn	PYUSLV	declare begin hr_pre_pay....
1,238	1,241	3,748,793	0.00	3.72	g2daxnc5b7rav	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
1,191	3,724	60	19.86	11.18	dab1prc9qyv3v	PYUSLV	begin hr_nonrun_asact...
1,024	1,026	3,747,687	0.00	3.08	7rks7t2gukcwn	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
931	932	4,247,316	0.00	2.80	6500rnmy4f88w	PYUSLV	SELECT PAP.ACCRUAL_PLAN_ID, P...
903	905	1,499,267	0.00	2.72	01pkua627ktjk	PYUSLV	SELECT fnd_number.number_to_ca...
891	893	2,748,986	0.00	2.68	dz7tyjxnar7gt	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
887	1,012	249,792	0.00	3.04	9jv68n0ctas75	PYUSLV	begin pay_core_utils . get_pro...
643	650	28,392,138	0.00	1.95	4gz4b2bh1fs14	PYUSLV	SELECT CONTEXT_ID, SEQUENCE_N...
579	633	249,995	0.00	1.90	699jt64x8hadf	PYUSLV	UPDATE PAY_ASSIGNMENT_ACTIONS ...
502	503	1,124,666	0.00	1.51	8v2cvg5zhw9ua	PYUSLV	SELECT fnd_number.number_to_ca...
467	468	2,749,822	0.00	1.41	6v07302134wyf	PYUSLV	INSERT INTO PAY_ACTION_INFORMA...
438	440	10,720,406	0.00	1.32	02k10jzw8c495	PYUSLV	SELECT INTLK.LOCKING_ACTION_ID...
419	419	13,593,609	0.00	1.26	grg3zu94xp62h	PYUSLV	SELECT PDB.BALANCE_TYPE_ID, P...
412	816	12,499	0.03	2.45	7y9t68kb4mc6q	PYUSLV	BEGIN pay_us_action_arch.actio...
397	403	249,840	0.00	1.21	7mmdd7sypzu9x	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
397	401	249,991	0.00	1.20	7d66dw0vz7yaa	PYUSLV	begin pay_cc_process_utils . r...
365	366	249,901	0.00	1.10	2z261p0p82p32	PYUSLV	BEGIN FFP51704_01010001.FORMUL...
343	393	249,984	0.00	1.18	36z3h9rgkd8aa	PYUSLV	begin ...
60	585	12,512	0.00	1.76	73rvua18a9ytx	PYUSLV	declare ret number ; BEGIN hr_...

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: 3,263,941,824
• Captured SQL account for 61.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,235,379,554	249,671	8,953.30	68.49	19774.11	19871.80	5sfm6rppc4y8x	PYUSLV	BEGIN pay_us_action_arch.actio...
2,213,043,065	249,233	8,879.41	67.80	19870.03	19967.86	4f5mjr4hnaz3u	PYUSLV	declare begin pay_archive...
251,949,867	3,748,793	67.21	7.72	1238.33	1240.86	g2daxnc5b7rav	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
248,589,156	1,499,267	165.81	7.62	903.49	904.70	01pkua627ktjk	PYUSLV	SELECT fnd_number.number_to_ca...
210,990,547	60	3,516,509.12	6.46	1191.43	3723.69	dab1prc9qyv3v	PYUSLV	begin hr_nonrun_asact...
198,425,050	3,747,687	52.95	6.08	1024.38	1026.14	7rks7t2gukcwn	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
184,034,366	2,748,986	66.95	5.64	891.05	892.82	dz7tyjxnar7gt	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
139,288,914	1,124,666	123.85	4.27	501.71	502.62	8v2cvg5zhw9ua	PYUSLV	SELECT fnd_number.number_to_ca...
122,248,530	13,593,609	8.99	3.75	418.53	419.37	grg3zu94xp62h	PYUSLV	SELECT PDB.BALANCE_TYPE_ID, P...
118,565,998	249,987	474.29	3.63	1307.06	1397.52	4ds53shhfcynn	PYUSLV	declare begin hr_pre_pay....
118,009,125	10,720,406	11.01	3.62	437.88	439.99	02k10jzw8c495	PYUSLV	SELECT INTLK.LOCKING_ACTION_ID...
85,142,247	28,392,138	3.00	2.61	643.18	650.27	4gz4b2bh1fs14	PYUSLV	SELECT CONTEXT_ID, SEQUENCE_N...
77,293,256	249,991	309.18	2.37	397.21	401.47	7d66dw0vz7yaa	PYUSLV	begin pay_cc_process_utils . r...
67,470,207	249,792	270.11	2.07	887.04	1011.71	9jv68n0ctas75	PYUSLV	begin pay_core_utils . get_pro...
59,342,224	249,840	237.52	1.82	397.37	403.09	7mmdd7sypzu9x	PYUSLV	BEGIN FFP1893_01010001.FORMULA...
55,818,693	2,749,822	20.30	1.71	467.02	468.42	6v07302134wyf	PYUSLV	INSERT INTO PAY_ACTION_INFORMA...
55,148,110	248,875	221.59	1.69	244.81	245.66	gxa19cf01sb0c	PYUSLV	SELECT PTS.TIME_IN_STATE, PTS...
54,360,244	13,594,588	4.00	1.67	267.06	267.94	9wupzu1crbdbb	PYUSLV	SELECT RO.TEXT, RO.OPTIMIZER_...
50,810,066	75,038	677.12	1.56	281.65	282.08	6gb9bfzbwqugc	PYUSLV	SELECT RGE.STARTING_PERSON_ID,...
47,533,326	4,247,316	11.19	1.46	930.82	932.12	6500rnmy4f88w	PYUSLV	SELECT PAP.ACCRUAL_PLAN_ID, P...
43,536,041	249,901	174.21	1.33	364.59	366.28	2z261p0p82p32	PYUSLV	BEGIN FFP51704_01010001.FORMUL...
41,039,933	499,802	82.11	1.26	116.14	116.38	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
37,487,798	3,119,615	12.02	1.15	212.63	212.82	fnnymj5r1f0n8	RUNGEN	SELECT PBG.LEGISLATION_CODE FR...
34,841,297	249,612	139.58	1.07	294.13	294.30	gq04p7vgjcmkg	PYUSLV	SELECT PPT.CATEGORY CATEGORY, ...
34,072,791	12,499	2,726.04	1.04	412.34	815.64	7y9t68kb4mc6q	PYUSLV	BEGIN pay_us_action_arch.actio...
32,910,599	499,729	65.86	1.01	146.89	147.88	b0j6srzdfp5jf	PYUSLV	select /*+ ORDERED USE_NL(AA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 706,028
• Captured SQL account for 37.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
429,965	249,671	1.72	60.90	19774.11	19871.80	5sfm6rppc4y8x	PYUSLV	BEGIN pay_us_action_arch.actio...
426,276	249,233	1.71	60.38	19870.03	19967.86	4f5mjr4hnaz3u	PYUSLV	declare begin pay_archive...
63,789	2,749,822	0.02	9.03	467.02	468.42	6v07302134wyf	PYUSLV	INSERT INTO PAY_ACTION_INFORMA...
59,813	249,986	0.24	8.47	284.77	294.27	g4jp561h1bs98	PYUSLV	select /*+ ORDERED USE_NL(AC...
50,164	499,802	0.10	7.11	116.14	116.38	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
40,675	249,991	0.16	5.76	397.21	401.47	7d66dw0vz7yaa	PYUSLV	begin pay_cc_process_utils . r...
25,109	248,875	0.10	3.56	244.81	245.66	gxa19cf01sb0c	PYUSLV	SELECT PTS.TIME_IN_STATE, PTS...
20,753	499,729	0.04	2.94	146.89	147.88	b0j6srzdfp5jf	PYUSLV	select /*+ ORDERED USE_NL(AA...
17,592	4,247,316	0.00	2.49	930.82	932.12	6500rnmy4f88w	PYUSLV	SELECT PAP.ACCRUAL_PLAN_ID, P...
15,699	1,499,267	0.01	2.22	903.49	904.70	01pkua627ktjk	PYUSLV	SELECT fnd_number.number_to_ca...
13,792	60	229.87	1.95	1191.43	3723.69	dab1prc9qyv3v	PYUSLV	begin hr_nonrun_asact...
10,451	249,901	0.04	1.48	364.59	366.28	2z261p0p82p32	PYUSLV	BEGIN FFP51704_01010001.FORMUL...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 212,362,745
• Captured SQL account for 48.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
28,392,138	43,826,491	1.54	0.00	0.00	4gz4b2bh1fs14	PYUSLV	SELECT CONTEXT_ID, SEQUENCE_N...
13,594,588	13,606,464	1.00	0.00	0.00	9wupzu1crbdbb	PYUSLV	SELECT RO.TEXT, RO.OPTIMIZER_...
13,593,609	13,597,089	1.00	0.00	0.00	grg3zu94xp62h	PYUSLV	SELECT PDB.BALANCE_TYPE_ID, P...
10,720,406	10,729,869	1.00	0.00	0.00	02k10jzw8c495	PYUSLV	SELECT INTLK.LOCKING_ACTION_ID...
4,247,316	0	0.00	0.00	0.00	6500rnmy4f88w	PYUSLV	SELECT PAP.ACCRUAL_PLAN_ID, P...
3,748,793	3,747,651	1.00	0.00	0.00	g2daxnc5b7rav	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
3,747,687	3,741,576	1.00	0.00	0.00	7rks7t2gukcwn	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
3,119,615	3,124,317	1.00	0.00	0.00	fnnymj5r1f0n8	RUNGEN	SELECT PBG.LEGISLATION_CODE FR...
2,749,822	2,749,810	1.00	0.00	0.00	6v07302134wyf	PYUSLV	INSERT INTO PAY_ACTION_INFORMA...
2,749,451	2,749,839	1.00	0.00	0.00	cw5jzzppcw0kj	PYUSLV	SELECT PAY_ACTION_INFORMATION_...
2,748,986	2,745,211	1.00	0.00	0.00	dz7tyjxnar7gt	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 18,410,591
• Captured SQL account for 92.5% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
3,725,953	3,747,687	20.24	7rks7t2gukcwn	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
3,725,385	3,748,793	20.24	g2daxnc5b7rav	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
2,735,188	2,748,986	14.86	dz7tyjxnar7gt	PYUSLV	SELECT /*+ ORDERED */ fnd_numb...
1,484,406	1,499,267	8.06	01pkua627ktjk	PYUSLV	SELECT fnd_number.number_to_ca...
1,110,985	1,124,666	6.03	8v2cvg5zhw9ua	PYUSLV	SELECT fnd_number.number_to_ca...
745,089	749,395	4.05	fqgs7vbu8htby	PYUSLV	SELECT fnd_number.number_to_ca...
499,641	499,690	2.71	83kbt99vg4svq	PYUSLV	begin ...
497,662	499,780	2.70	3n5uwzsh3y8gr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
495,900	499,802	2.69	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
249,953	249,999	1.36	97mt0g20bcfc3	PYUSLV	begin ...
249,933	249,984	1.36	36z3h9rgkd8aa	PYUSLV	begin ...
249,813	249,987	1.36	4ds53shhfcynn	PYUSLV	declare begin hr_pre_pay....
249,440	249,233	1.35	4f5mjr4hnaz3u	PYUSLV	declare begin pay_archive...
249,119	249,671	1.35	5sfm6rppc4y8x	PYUSLV	BEGIN pay_us_action_arch.actio...
248,535	249,935	1.35	3rg5fyfgd5uwc	PYUSLV	begin pay_US_rules.get_tim...
245,393	249,884	1.33	d7shgtk3p7s4u	PYUSLV	SELECT /*+ ordered index(BAL...
222,270	222,270	1.21	cr74qtm56vcq6	NACHA	BEGIN PAY_US_NACHA_TAPE.RUN_FO...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id	SQL Text
01pkua627ktjk	SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02k10jzw8c495	SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
165d2bgc2b9hr	SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
2z261p0p82p32	BEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I12, :T3, :I3, :T8, :I14, :N6, :I10, :T7, :I13, :N4, :I8, :D1, :N12, :I18, :N10, :I16, :N7, :I11, :N11, :I17, :T6, :I6, :N1, :T2, :I2, :N5, :I9, :N9, :I15, :FFERLN, :FFERCD, :FFERMT); END;
36z3h9rgkd8aa	begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr	SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
3rg5fyfgd5uwc	begin pay_US_rules.get_time_def_for_entry( :element_entry_id, :assignment_id, :assignment_action_id, :business_group_id, :time_def_id); end;
4ds53shhfcynn	declare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3u	declare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14	SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5sfm6rppc4y8x	BEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
6500rnmy4f88w	SELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
699jt64x8hadf	UPDATE PAY_ASSIGNMENT_ACTIONS SET SERIAL_NUMBER = :B2 WHERE ASSIGNMENT_ACTION_ID = :B1
6gb9bfzbwqugc	SELECT RGE.STARTING_PERSON_ID, RGE.ENDING_PERSON_ID, RGE.CHUNK_NUMBER, NVL(RGE.RAND_CHUNK_NUMBER, RGE.CHUNK_NUMBER) FROM PAY_POPULATION_RANGES RGE WHERE RGE.PAYROLL_ACTION_ID = :B1 AND RGE.RANGE_STATUS = 'U' AND ROWNUM < 2
6v07302134wyf	INSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
73rvua18a9ytx	declare ret number ; BEGIN hr_nonrun_asact . get_next_pop_chunk ( :pactid , :atype , :l_lckhandle , :lub , :lul , :chunk_method , :threads , :slave_no , :curr_chunk , :max_chunks , :stperson:stperson_ind , :endperson:endperson_ind , :chunk:chunk_ind , :rand_chunk:rand_chunk_ind ) ; END ;
7d66dw0vz7yaa	begin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7mmdd7sypzu9x	BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N5, :T4, :I4, :N4, :N3, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
7rks7t2gukcwn	SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decod e(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assignment_action_id = ASSACT.assignment_action_id and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') /* Within Jurisdiction */ and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
7y9t68kb4mc6q	BEGIN pay_us_action_arch.action_action_creation(:pactid, :stperson, :endperson, :chunk); END;
83kbt99vg4svq	begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8v2cvg5zhw9ua	SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
97mt0g20bcfc3	begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9jv68n0ctas75	begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
9wupzu1crbdbb	SELECT RO.TEXT, RO.OPTIMIZER_HINT FROM FF_ROUTES RO WHERE RO.ROUTE_ID = :B1
b0j6srzdfp5jf	select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , decode(RR.source_type, 'E', nvl(EE.creator_type, 'X'), 'I', decode(EE.creator_type, null , 'X', 'N')) , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result_i d, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost.get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where ((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_date and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_id=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) order by 17, 8, 14
cr74qtm56vcq6	BEGIN PAY_US_NACHA_TAPE.RUN_FORMULA; END;
cw5jzzppcw0kj	SELECT PAY_ACTION_INFORMATION_S.NEXTVAL FROM SYS.DUAL
d7shgtk3p7s4u	SELECT /*+ ordered index(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(BACT PAY_PAYROLL_ACTIONS_PK) index(ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PACT PAY_PAYROLL_ACTIONS_PK) index(INTLCK2 PAY_ACTION_INTERLOCKS_FK1) index(PPASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PPACT PAY_PAYROLL_ACTIONS_PK) index(RR PAY_RUN_RESULTS_N50) index(TARGET PAY_RUN_RESULT_VALUES_N50) index(FEED PAY_BALANCE_FEEDS_F_N50) */ fnd_number.number_to_canonical(/*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0) ) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action _id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and nvl(PACT.future_process_mode, 'Y') = 'Y' and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and pay_core_utils.include_action_in_payment(BACT.action_type, BAL_ASSACT.assignment_action_id, ASSACT.assignment_action_id) = 'Y' and NOT EXISTS (SELECT /*+ NO_PUSH_SUBQ */ NULL FROM pay_payroll_actions RPACT , pay_assignment_actions RASSACT , pay_action_interlocks RINTLK where ASSACT.assignment_action_id = RINTLK.locked_action_id and RINTLK.locking_action_id = RASSACT.assignment_action_id and RPACT.payroll_action_id = RASSACT.payroll_action_id and RPACT.action_type = 'V')
dab1prc9qyv3v	begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dz7tyjxnar7gt	SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT. action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and R R.assignment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and exists (select null from pay_taxability_rules TR , pay_element_types_f ET , pay_balance_types BT where ET.element_type_id = RR.element_type_id and PACT.date_earned between ET.effective_start_date and ET.effective_end_date and BT.balance_type_id = :U1 and TR.classification_id = ET.classification_id + 0 and TR.tax_category = ET.element_information1 and TR.tax_type = BT.tax_type and TR.jurisdiction_code = '00-000-0000' and nvl(TR.status, 'VALID') <> 'D' )
fnnymj5r1f0n8	SELECT PBG.LEGISLATION_CODE FROM PER_BUSINESS_GROUPS PBG WHERE PBG.BUSINESS_GROUP_ID = :B1
fqgs7vbu8htby	SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment For Run */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_payroll_actions PACT where ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA')
g2daxnc5b7rav	SELECT /*+ ORDERED */ fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_run_types_f BAL_PRT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_run_types_f PRT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id( BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.ac tion_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type not in ('V') and RR.assig nment_action_id = ASSACT.assignment_action_id and RR.status in ('P', 'PA') and TARGET.run_result_id = RR.run_result_id and nvl(TARGET.result_value, '0') != '0' and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date
g4jp561h1bs98	select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.act ion_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.elem ent_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
gq04p7vgjcmkg	SELECT PPT.CATEGORY CATEGORY, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_METHOD, PEA.PRENOTE_DATE PRENOTE_DATE, PPT.VALIDATION_DAYS VALID_DAYS, PPM.PERCENTAGE PERCENTAGE, PPM.AMOUNT AMOUNT, OPM.ORG_PAYMENT_METHOD_ID ORG_METHOD, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1) CASH_RULE, OPM.CURRENCY_CODE PAYMENT_CURRENCY, PPT.PRE_VALIDATION_REQUIRED VALIDATION_REQUIRED, PPT.VALIDATION_VALUE VALIDATION_VALUE, OPM.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID FROM PAY_EXTERNAL_ACCOUNTS PEA, PAY_PAYMENT_TYPES PPT, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_ASSIGNMENT_ACTIONS ACT WHERE ACT.ASSIGNMENT_ACTION_ID=:B4 AND PPM.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PPM.RUN_TYPE_ID = :B3 AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = :B2 AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN PPM.EFFECTIVE_START_DATE AND PPM.EFFECTIVE_END_DATE AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE ORDER BY PPM.PERSON_ID, PPM.PRIORITY
grg3zu94xp62h	SELECT PDB.BALANCE_TYPE_ID, PDR.ROUTE_ID, PDR.BALANCE_TYPE_COLUMN, PDR.RETRIEVAL_COLUMN, NVL(PDR.DECODE_REQUIRED, 'N'), NVL(JURISDICTION_LEVEL, 0) FROM PAY_DEFINED_BALANCES PDB, PAY_DIMENSION_ROUTES PDR, PAY_BALANCE_TYPES PBT WHERE PDB.DEFINED_BALANCE_ID = :B2 AND PDB.BALANCE_DIMENSION_ID = PDR.BALANCE_DIMENSION_ID AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID AND PDR.PRIORITY = :B1
gxa19cf01sb0c	SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, PTS.MEANING, PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

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

Back to Top

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	2,904,679	584.24	8.13
CPU used when call started	2,904,485	584.20	8.13
CR blocks created	11,978,260	2,409.26	33.53
Cached Commit SCN referenced	1,166	0.23	0.00
Commit SCN cached	2	0.00	0.00
DB time	14,505,437	2,917.57	40.60
DBWR checkpoint buffers written	1,687,255	339.37	4.72
DBWR checkpoints	1	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	9	0.00	0.00
DBWR thread checkpoint buffers written	1,595,113	320.84	4.46
DBWR transaction table writes	585	0.12	0.00
DBWR undo block writes	883,944	177.79	2.47
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	226,118,447	45,480.65	632.91
IMU Flushes	201,300	40.49	0.56
IMU Redo allocation size	3,372,765,424	678,385.83	9,440.44
IMU commits	157,148	31.61	0.44
IMU contention	80,111	16.11	0.22
IMU ktichg flush	114	0.02	0.00
IMU pool not allocated	780	0.16	0.00
IMU recursive-transaction flush	7,665	1.54	0.02
IMU undo allocation size	5,362,087,224	1,078,510.82	15,008.59
IMU- failed to get a private strand	780	0.16	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations downgraded 25 to 50 pct	0	0.00	0.00
Parallel operations downgraded 50 to 75 pct	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment shrink	6	0.00	0.00
SQL*Net roundtrips to/from client	21,811,512	4,387.09	61.05
active txn count during cleanout	53,010,853	10,662.41	148.38
application wait time	289,830	58.30	0.81
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	17,464	3.51	0.05
branch node splits	346	0.07	0.00
buffer is not pinned count	1,497,417,307	301,185.10	4,191.30
buffer is pinned count	704,430,865	141,686.67	1,971.72
bytes received via SQL*Net from client	5,741,961,638	1,154,917.38	16,071.86
bytes sent via SQL*Net to client	3,211,127,962	645,874.66	8,988.01
calls to get snapshot scn: kcmgss	228,826,930	46,025.42	640.49
calls to kcmgas	13,424,982	2,700.25	37.58
calls to kcmgcs	557,246	112.08	1.56
change write time	34,025	6.84	0.10
cleanout - number of ktugct calls	12,101,498	2,434.05	33.87
cleanouts and rollbacks - consistent read gets	11,360,967	2,285.10	31.80
cleanouts only - consistent read gets	96,870	19.48	0.27
cluster key scan block gets	16,510	3.32	0.05
cluster key scans	885	0.18	0.00
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	16,959	3.41	0.05
commit batch/immediate requested	16,959	3.41	0.05
commit cleanout failures: block lost	243	0.05	0.00
commit cleanout failures: buffer being written	378	0.08	0.00
commit cleanout failures: callback failure	172,037	34.60	0.48
commit cleanout failures: cannot pin	56,129	11.29	0.16
commit cleanouts	5,328,184	1,071.69	14.91
commit cleanouts successfully completed	5,099,397	1,025.67	14.27
commit immediate performed	16,959	3.41	0.05
commit immediate requested	16,959	3.41	0.05
commit txn count during cleanout	937,585	188.58	2.62
concurrency wait time	98,742	19.86	0.28
consistent changes	723,096,820	145,441.08	2,023.96
consistent gets	3,109,177,236	625,368.66	8,702.65
consistent gets - examination	1,859,078,297	373,928.28	5,203.60
consistent gets direct	0	0.00	0.00
consistent gets from cache	3,109,177,236	625,368.66	8,702.65
cursor authentications	542	0.11	0.00
data blocks consistent reads - undo records applied	722,313,134	145,283.45	2,021.77
db block changes	122,028,410	24,544.35	341.56
db block gets	154,764,588	31,128.79	433.19
db block gets direct	100	0.02	0.00
db block gets from cache	154,764,488	31,128.77	433.19
deferred (CURRENT) block cleanout applications	543,945	109.41	1.52
dirty buffers inspected	2,156	0.43	0.01
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	76,226	15.33	0.21
enqueue releases	2,293,166	461.24	6.42
enqueue requests	2,294,396	461.49	6.42
enqueue timeouts	1,230	0.25	0.00
enqueue waits	161,488	32.48	0.45
exchange deadlocks	174,071	35.01	0.49
execute count	212,362,745	42,713.87	594.41
failed probes on index block reclamation	42	0.01	0.00
free buffer inspected	4,569,759	919.14	12.79
free buffer requested	13,861,613	2,788.07	38.80
global undo segment hints helped	0	0.00	0.00
heap block compress	291,684	58.67	0.82
hot buffers moved to head of LRU	477,896	96.12	1.34
immediate (CR) block cleanout applications	11,457,866	2,304.59	32.07
immediate (CURRENT) block cleanout applications	919,078	184.86	2.57
index crx upgrade (found)	911,170	183.27	2.55
index crx upgrade (positioned)	28,369,595	5,706.16	79.41
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	386,362,845	77,711.62	1,081.44
index scans kdiixs1	353,708,542	71,143.66	990.04
java call heap collected bytes	0	0.00	0.00
java call heap collected count	0	0.00	0.00
java call heap gc count	0	0.00	0.00
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	0	0.00	0.00
java call heap object count max	0	0.00	0.00
java call heap total size	0	0.00	0.00
java call heap total size max	0	0.00	0.00
java call heap used size	0	0.00	0.00
java call heap used size max	0	0.00	0.00
leaf node 90-10 splits	40,129	8.07	0.11
leaf node splits	102,025	20.52	0.29
lob reads	0	0.00	0.00
lob writes	45	0.01	0.00
lob writes unaligned	45	0.01	0.00
local undo segment hints helped	0	0.00	0.00
logons cumulative	268	0.05	0.00
messages received	535,768	107.76	1.50
messages sent	535,768	107.76	1.50
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,181,854,217	237,713.88	3,308.03
opened cursors cumulative	16,910,192	3,401.25	47.33
parse count (failures)	0	0.00	0.00
parse count (hard)	496	0.10	0.00
parse count (total)	18,410,591	3,703.04	51.53
parse time cpu	24,481	4.92	0.07
parse time elapsed	27,981	5.63	0.08
physical read IO requests	704,339	141.67	1.97
physical read bytes	5,783,781,376	1,163,328.85	16,188.92
physical read total IO requests	705,242	141.85	1.97
physical read total bytes	5,796,815,872	1,165,950.56	16,225.40
physical read total multi block requests	144	0.03	0.00
physical reads	706,028	142.01	1.98
physical reads cache	703,397	141.48	1.97
physical reads cache prefetch	163	0.03	0.00
physical reads direct	2,631	0.53	0.01
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	1,635	0.33	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	383,461	77.13	1.07
physical write bytes	13,958,815,744	2,807,625.67	39,070.99
physical write total IO requests	689,735	138.73	1.93
physical write total bytes	32,441,867,776	6,525,239.86	90,805.41
physical write total multi block requests	474,949	95.53	1.33
physical writes	1,703,957	342.73	4.77
physical writes direct	1,946	0.39	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1,635	0.33	0.00
physical writes from cache	1,702,011	342.34	4.76
physical writes non checkpoint	1,115,329	224.33	3.12
pinned buffers inspected	2,461	0.49	0.01
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	66,844	13.44	0.19
process last non-idle time	4,786	0.96	0.01
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	113	0.02	0.00
recursive calls	449,599,065	90,430.73	1,258.44
recursive cpu usage	2,552,471	513.39	7.14
redo blocks written	36,028,253	7,246.59	100.84
redo buffer allocation retries	11	0.00	0.00
redo entries	60,918,237	12,252.87	170.51
redo log space requests	29	0.01	0.00
redo log space wait time	52	0.01	0.00
redo ordering marks	694,619	139.71	1.94
redo size	17,759,984,808	3,572,179.06	49,710.54
redo subscn max counts	1,152,329	231.78	3.23
redo synch time	81,006	16.29	0.23
redo synch writes	118,381	23.81	0.33
redo wastage	79,832,940	16,057.31	223.45
redo write time	74,241	14.93	0.21
redo writer latching time	36	0.01	0.00
redo writes	216,671	43.58	0.61
rollback changes - undo records applied	71,752	14.43	0.20
rollbacks only - consistent read gets	717,728	144.36	2.01
rows fetched via callback	228,920,521	46,044.24	640.75
session connect time	0	0.00	0.00
session cursor cache hits	18,388,083	3,698.51	51.47
session logical reads	3,263,941,824	656,497.44	9,135.84
session pga memory max	7,982,288	1,605.53	22.34
session uga memory	77,309,920,960	15,549,837.66	216,391.95
session uga memory max	634,900,744	127,701.64	1,777.10
shared hash latch upgrades - no wait	30,859,376	6,206.94	86.38
shared hash latch upgrades - wait	1,008,610	202.87	2.82
sorts (disk)	0	0.00	0.00
sorts (memory)	17,555,105	3,530.97	49.14
sorts (rows)	33,181,263	6,673.96	92.87
space was found by tune down	0	0.00	0.00
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	9,420	1.89	0.03
switch current to new buffer	287,921	57.91	0.81
table fetch by rowid	953,554,463	191,794.49	2,669.02
table fetch continued row	6,989	1.41	0.02
table scan blocks gotten	98,309,629	19,773.64	275.17
table scan rows gotten	992,848,007	199,697.85	2,779.00
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	1	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	12,770,966	2,568.71	35.75
total number of times SMON posted	236	0.05	0.00
transaction rollbacks	16,959	3.41	0.05
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	6,239,102,904	1,254,910.57	17,463.37
user I/O wait time	5,125	1.03	0.01
user calls	23,242,984	4,675.01	65.06
user commits	352,149	70.83	0.99
user rollbacks	5,119	1.03	0.01
workarea executions - onepass	6	0.00	0.00
workarea executions - optimal	11,173,008	2,247.30	31.27
write clones created in background	5	0.00	0.00
write clones created in foreground	6,641	1.34	0.02

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	28,981	34,765
opened cursors current	6,000	5,738
logons current	169	169

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)	1	0.72

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_TS_TX_DATA	436,396	88	0.05	1.00	63,517	13	187,114	0.05
APPS_TS_TX_IDX	266,800	54	0.08	1.00	199,533	40	905,893	0.11
APPS_UNDOTS1	40	0	0.25	1.00	119,437	24	749,779	0.03
SYSTEM	83	0	3.13	1.00	380	0	310	2.16
SYSAUX	166	0	1.33	1.00	199	0	0	0.00
TEMP1	109	0	0.55	15.00	140	0	0	0.00
APPS_TS_INTERFACE	157	0	0.19	1.00	28	0	0	0.00
APPS_TS_SEED	138	0	1.81	1.39	5	0	1,035	2.09
APPS_TS_ARCHIVE	16	0	3.13	1.00	120	0	29	0.34
APPS_TS_SUMMARY	53	0	0.19	1.00	13	0	0	0.00
APPS_TS_MEDIA	36	0	0.56	1.00	7	0	0	0.00
APPS_CALCLIP	20	0	0.00	1.00	4	0	0	0.00
APPS_TS_QUEUES	19	0	0.00	1.00	4	0	0	0.00
TEMP2	0	0	0.00		18	0	0	0.00
DCM	13	0	0.00	1.00	2	0	0	0.00
GEOR_TBS	13	0	0.77	1.00	2	0	0	0.00
APPS_TS_DISCO	8	0	0.00	1.00	3	0	0	0.00
CWMLITE	8	0	0.00	1.00	2	0	0	0.00
IAS_META	8	0	2.50	1.00	1	0	0	0.00
B2B_DT	7	0	2.86	1.00	1	0	0	0.00
B2B_RT	7	0	0.00	1.00	1	0	0	0.00
DISCO_PTM5_CACHE	7	0	0.00	1.00	1	0	0	0.00
DSGATEWAY_TAB	7	0	0.00	1.00	1	0	0	0.00
WCRSYS_TS	7	0	0.00	1.00	1	0	0	0.00
APPS_OMO	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO_OLAP	6	0	0.00	1.00	1	0	0	0.00
B2B_IDX	6	0	0.00	1.00	1	0	0	0.00
B2B_LOB	6	0	0.00	1.00	1	0	0	0.00
BAM	6	0	0.00	1.00	1	0	0	0.00
DISCO_PTM5_META	6	0	0.00	1.00	1	0	0	0.00
MTR	6	0	0.00	1.00	1	0	0	0.00
NOETIX	6	0	0.00	1.00	1	0	0	0.00
OCATS	6	0	0.00	1.00	1	0	0	0.00
OLTS_ATTRSTORE	6	0	0.00	1.00	1	0	0	0.00
OLTS_BATTRSTORE	6	0	0.00	1.00	1	0	0	0.00
OLTS_CT_STORE	6	0	0.00	1.00	1	0	0	0.00
OLTS_DEFAULT	6	0	0.00	1.00	1	0	0	0.00
OLTS_SVRMGSTORE	6	0	0.00	1.00	1	0	0	0.00
OPMOR	6	0	0.00	1.00	1	0	0	0.00
ORABPEL	6	0	0.00	1.00	1	0	0	0.00
PORTAL	6	0	0.00	1.00	1	0	0	0.00
PORTAL_DOC	6	0	0.00	1.00	1	0	0	0.00
PORTAL_IDX	6	0	0.00	1.00	1	0	0	0.00
PORTAL_LOG	6	0	0.00	1.00	1	0	0	0.00
RE	6	0	0.00	1.00	1	0	0	0.00
UDDISYS_TS	6	0	0.00	1.00	1	0	0	0.00
XDB	6	0	0.00	1.00	1	0	0	0.00
HTMLDB	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_NOLOGGING	3	0	0.00	1.00	1	0	0	0.00
ODM_DATA	2	0	0.00	1.00	1	0	0	0.00
SYNCSERVER	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_TOOLS	1	0	10.00	1.00	1	0	0	0.00
CTXSYS	1	0	10.00	1.00	1	0	0	0.00
NON_APPS_TS_DATA	1	0	10.00	1.00	1	0	0	0.00
OWAPUB	1	0	0.00	1.00	1	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_CALCLIP	/ds2/oracle/VIS/db/apps_st/data/apps_calclip.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds2/oracle/VIS/db/apps_st/data/apps_calclip1.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds2/oracle/VIS/db/apps_st/data/apps_calclip2.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_CALCLIP	/ds2/oracle/VIS/db/apps_st/data/apps_calclip3.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_OMO	/ds2/oracle/VIS/db/apps_st/data/omo1.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_ARCHIVE	/ds2/oracle/VIS/db/apps_st/data/archive1.dbf	16	0	3.13	1.00	120	0	29	0.34
APPS_TS_DISCO	/ds2/oracle/VIS/db/apps_st/data/disco1.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO	/ds2/oracle/VIS/db/apps_st/data/disco2.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO	/ds2/oracle/VIS/db/apps_st/data/disco3.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_DISCO_OLAP	/ds2/oracle/VIS/db/apps_st/data/disco_drake1.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interfac27.d	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface.db	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface1.d	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface10.	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface11.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface12.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface13.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface14.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface15.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface16.	7	0	4.29	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface17.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface18.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface19.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface2.d	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface20.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface21.	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface22.	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface23.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface24.	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface25.	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface26.	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface3.d	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface4.d	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface5.d	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface6.d	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface7.d	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface8.d	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_INTERFACE	/ds2/oracle/VIS/db/apps_st/data/apps_ts_interface9.d	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media1.dbf	3	0	0.00	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media2.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media3.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media4.dbf	7	0	1.43	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media5.dbf	6	0	1.67	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media6.dbf	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_MEDIA	/ds2/oracle/VIS/db/apps_st/data/media7.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_NOLOGGING	/ds2/oracle/VIS/db/apps_st/data/nologging1.dbf	3	0	0.00	1.00	1	0	0	0.00
APPS_TS_QUEUES	/ds2/oracle/VIS/db/apps_st/data/queues1.dbf	3	0	0.00	1.00	1	0	0	0.00
APPS_TS_QUEUES	/ds2/oracle/VIS/db/apps_st/data/queues2.dbf	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_QUEUES	/ds2/oracle/VIS/db/apps_st/data/queues3.dbf	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_QUEUES	/ds2/oracle/VIS/db/apps_st/data/queues4.dbf	7	0	0.00	1.00	1	0	0	0.00
APPS_TS_SEED	/ds2/oracle/VIS/db/apps_st/data/reference1.dbf	101	0	1.98	1.16	1	0	889	2.07
APPS_TS_SEED	/ds2/oracle/VIS/db/apps_st/data/reference2.dbf	27	0	0.74	2.41	1	0	74	1.35
APPS_TS_SEED	/ds2/oracle/VIS/db/apps_st/data/reference3.dbf	8	0	3.75	1.00	1	0	72	3.06
APPS_TS_SEED	/ds2/oracle/VIS/db/apps_st/data/reference4.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_SEED	/ds2/oracle/VIS/db/apps_st/data/reference5.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary1.dbf	3	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary10.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary11.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary12.dbf	7	0	1.43	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary13.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary2.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary3.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary4.dbf	1	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary5.dbf	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary6.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary7.dbf	2	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary8.dbf	4	0	0.00	1.00	1	0	0	0.00
APPS_TS_SUMMARY	/ds2/oracle/VIS/db/apps_st/data/summary9.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_TOOLS	/ds2/oracle/VIS/db/apps_st/data/apps_ts_tools01.dbf	1	0	10.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data1.dbf	34	0	0.29	1.00	8	0	2	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data10.dbf	118	0	0.00	1.00	99	0	21	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data11.dbf	18,000	4	0.08	1.00	2,125	0	5,790	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data12.dbf	11,257	2	0.13	1.00	2,099	0	5,728	0.05
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data13.dbf	645	0	0.05	1.00	580	0	438	0.02
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data14.dbf	2	0	0.00	1.00	12	0	5	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data15.dbf	2	0	0.00	1.00	4	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data16.dbf	215	0	0.14	1.00	84	0	38	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data17.dbf	10	0	0.00	1.00	4	0	40	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data18.dbf	35	0	0.00	1.00	5	0	5	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data19.dbf	148	0	0.00	1.07	70	0	83	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data2.dbf	573	0	0.05	1.00	431	0	276	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data20.dbf	4	0	0.00	1.00	4	0	2	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data21.dbf	3,264	1	0.02	1.00	1,786	0	1,298	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data22.dbf	175	0	0.11	1.16	76	0	35	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data23.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data24.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data25.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data26.dbf	5	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data27.dbf	7	0	0.00	1.00	34	0	31,235	0.11
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data28.dbf	24	0	0.00	1.00	2	0	21	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data29.dbf	6	0	0.00	1.00	10	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data3.dbf	35	0	0.00	1.00	3	0	2	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data30.dbf	70	0	0.00	1.00	27	0	30	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data31.dbf	8	0	0.00	1.00	26	0	11	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data32.dbf	6	0	0.00	1.00	35	0	5	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data33.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data34.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data35.dbf	7	0	1.43	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data36.dbf	7	0	1.43	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data37.dbf	12	0	0.83	1.00	8	0	23	0.43
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data38.dbf	7	0	0.00	1.00	1	0	16	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data39.dbf	4,534	1	0.04	1.00	1,759	0	1,347	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data4.dbf	81	0	0.00	1.00	26	0	14	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data40.dbf	6	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data41.dbf	11	0	0.00	1.00	1	0	11	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data42.dbf	13	0	0.77	1.00	1	0	21	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data43.dbf	6,297	1	0.03	1.01	1,815	0	1,234	0.08
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data44.dbf	36,411	7	0.04	1.00	5,015	1	13,501	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data45.dbf	36,404	7	0.05	1.00	4,981	1	14,113	0.03
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data46.dbf	170	0	0.29	1.00	234	0	114	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data47.dbf	27,152	5	0.07	1.00	2,857	1	6,148	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data48.dbf	36,770	7	0.05	1.00	5,004	1	13,659	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data49.dbf	36,441	7	0.05	1.00	4,968	1	12,920	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data5.dbf	35	0	0.00	1.00	5	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data50.dbf	34,949	7	0.06	1.00	4,538	1	10,585	0.03
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data51.dbf	36,536	7	0.06	1.00	4,961	1	13,613	0.05
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data52.dbf	12	0	0.00	1.00	1	0	10	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data53.dbf	36,505	7	0.05	1.00	4,946	1	13,849	0.05
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data54.dbf	36,478	7	0.05	1.00	4,899	1	12,968	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data55.dbf	36,187	7	0.05	1.00	4,897	1	13,571	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data56.dbf	36,368	7	0.05	1.00	4,873	1	13,703	0.04
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data6.dbf	33	0	0.00	1.00	5	0	1	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data7.dbf	211	0	0.14	1.00	162	0	45	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data8.dbf	3	0	0.00	1.00	1	0	0	0.00
APPS_TS_TX_DATA	/ds2/oracle/VIS/db/apps_st/data/tx_data9.dbf	86	0	0.00	1.00	26	0	583	0.05
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx1.dbf	4,979	1	0.04	1.00	7,604	2	39,044	0.10
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx10.dbf	5,287	1	0.04	1.00	7,617	2	38,891	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx11.dbf	4,929	1	0.03	1.00	7,833	2	40,646	0.09
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx12.dbf	4,882	1	0.02	1.00	7,796	2	39,264	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx13.dbf	4,918	1	0.04	1.00	7,583	2	40,856	0.64
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx14.dbf	4,921	1	0.02	1.00	7,622	2	39,509	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx15.dbf	5,305	1	0.04	1.00	7,609	2	41,924	0.08
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx16.dbf	5,340	1	0.02	1.00	7,589	2	38,180	0.06
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx17.dbf	5,263	1	0.04	1.00	7,734	2	38,616	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx18.dbf	4,916	1	0.04	1.00	7,739	2	40,399	0.06
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx19.dbf	4,868	1	0.04	1.00	7,618	2	41,462	0.09
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx2.dbf	5,341	1	0.04	1.00	7,736	2	41,163	0.12
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx20.dbf	4,803	1	0.03	1.00	7,601	2	41,646	0.06
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx21.dbf	5,137	1	0.03	1.00	7,696	2	41,859	0.09
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx22.dbf	86	0	0.12	1.00	272	0	102	0.20
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx23.dbf	474	0	0.13	1.00	210	0	113	0.09
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx24.dbf	6,611	1	0.04	1.00	7,609	2	40,245	0.12
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx25.dbf	43,524	9	0.11	1.00	8,853	2	2,389	0.09
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx26.dbf	43,551	9	0.11	1.00	9,047	2	2,276	0.14
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx27.dbf	13,853	3	0.05	1.00	7,508	2	39,639	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx28.dbf	42,834	9	0.11	1.00	20,271	4	59,027	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx3.dbf	14,534	3	0.15	1.00	1	0	150	0.53
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx4.dbf	4,884	1	0.02	1.00	7,713	2	40,505	0.12
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx5.dbf	5,047	1	0.03	1.00	7,704	2	39,808	0.06
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx6.dbf	5,291	1	0.09	1.00	21	0	170	0.29
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx7.dbf	4,974	1	0.04	1.00	7,643	2	41,090	0.07
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx8.dbf	5,001	1	0.02	1.00	7,698	2	39,385	0.12
APPS_TS_TX_IDX	/ds2/oracle/VIS/db/apps_st/data/tx_idx9.dbf	5,247	1	0.05	1.00	7,606	2	37,535	0.09
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo.dbf	1	0	10.00	1.00	12,941	3	114,822	0.06
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo2.dbf	6	0	0.00	1.00	11,248	2	58,012	0.03
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo3.dbf	7	0	0.00	1.00	10,064	2	64,743	0.03
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo4.dbf	7	0	0.00	1.00	12,002	2	62,921	0.03
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo5.dbf	6	0	0.00	1.00	11,251	2	50,565	0.02
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo6.dbf	6	0	0.00	1.00	27,763	6	214,446	0.03
APPS_UNDOTS1	/ds2/oracle/VIS/db/apps_st/data/undo7.dbf	7	0	0.00	1.00	34,168	7	184,270	0.02
B2B_DT	/ds2/oracle/VIS/db/apps_st/data/b2b_dt.dbf	7	0	2.86	1.00	1	0	0	0.00
B2B_IDX	/ds2/oracle/VIS/db/apps_st/data/b2b_idx.dbf	6	0	0.00	1.00	1	0	0	0.00
B2B_LOB	/ds2/oracle/VIS/db/apps_st/data/b2b_lob.dbf	6	0	0.00	1.00	1	0	0	0.00
B2B_RT	/ds2/oracle/VIS/db/apps_st/data/b2b_rt.dbf	7	0	0.00	1.00	1	0	0	0.00
BAM	/ds2/oracle/VIS/db/apps_st/data/bam.dbf	6	0	0.00	1.00	1	0	0	0.00
CTXSYS	/ds2/oracle/VIS/db/apps_st/data/ctx1.dbf	1	0	10.00	1.00	1	0	0	0.00
CWMLITE	/ds2/oracle/VIS/db/apps_st/data/cwmlite01.dbf	2	0	0.00	1.00	1	0	0	0.00
CWMLITE	/ds2/oracle/VIS/db/apps_st/data/cwmlite02.dbf	6	0	0.00	1.00	1	0	0	0.00
DCM	/ds2/oracle/VIS/db/apps_st/data/dcm.dbf	7	0	0.00	1.00	1	0	0	0.00
DCM	/ds2/oracle/VIS/db/apps_st/data/dcm1.dbf	6	0	0.00	1.00	1	0	0	0.00
DISCO_PTM5_CACHE	/ds2/oracle/VIS/db/apps_st/data/discopltc1.dbf	7	0	0.00	1.00	1	0	0	0.00
DISCO_PTM5_META	/ds2/oracle/VIS/db/apps_st/data/discopltm1.dbf	6	0	0.00	1.00	1	0	0	0.00
DSGATEWAY_TAB	/ds2/oracle/VIS/db/apps_st/data/oss_sys01.dbf	7	0	0.00	1.00	1	0	0	0.00
GEOR_TBS	/ds2/oracle/VIS/db/apps_st/data/apps_ts_spatial.dbf	7	0	1.43	1.00	1	0	0	0.00
GEOR_TBS	/ds2/oracle/VIS/db/apps_st/data/geor_tbs02.dbf	6	0	0.00	1.00	1	0	0	0.00
HTMLDB	/ds2/oracle/VIS/db/apps_st/data/htmldb.dbf	5	0	0.00	1.00	1	0	0	0.00
IAS_META	/ds2/oracle/VIS/db/apps_st/data/ias_meta01.dbf	8	0	2.50	1.00	1	0	0	0.00
MTR	/ds2/oracle/VIS/db/apps_st/data/opmtr01.dbf	6	0	0.00	1.00	1	0	0	0.00
NOETIX	/ds2/oracle/VIS/db/apps_st/data/noetix.dbf	6	0	0.00	1.00	1	0	0	0.00
NON_APPS_TS_DATA	/ds2/oracle/VIS/db/apps_st/data/non_apps_data1.dbf	1	0	10.00	1.00	1	0	0	0.00
OCATS	/ds2/oracle/VIS/db/apps_st/data/oca.dbf	6	0	0.00	1.00	1	0	0	0.00
ODM_DATA	/ds2/oracle/VIS/db/apps_st/data/odm.dbf	2	0	0.00	1.00	1	0	0	0.00
OLTS_ATTRSTORE	/ds2/oracle/VIS/db/apps_st/data/attrs1_oid.dbf	6	0	0.00	1.00	1	0	0	0.00
OLTS_BATTRSTORE	/ds2/oracle/VIS/db/apps_st/data/battrs1_oid.dbf	6	0	0.00	1.00	1	0	0	0.00
OLTS_CT_STORE	/ds2/oracle/VIS/db/apps_st/data/gcats1_oid.dbf	6	0	0.00	1.00	1	0	0	0.00
OLTS_DEFAULT	/ds2/oracle/VIS/db/apps_st/data/gdefault1_oid.dbf	6	0	0.00	1.00	1	0	0	0.00
OLTS_SVRMGSTORE	/ds2/oracle/VIS/db/apps_st/data/svrmg1_oid.dbf	6	0	0.00	1.00	1	0	0	0.00
OPMOR	/ds2/oracle/VIS/db/apps_st/data/opmor01.dbf	6	0	0.00	1.00	1	0	0	0.00
ORABPEL	/ds2/oracle/VIS/db/apps_st/data/orabpel.dbf	6	0	0.00	1.00	1	0	0	0.00
OWAPUB	/ds2/oracle/VIS/db/apps_st/data/owa1.dbf	1	0	0.00	1.00	1	0	0	0.00
PORTAL	/ds2/oracle/VIS/db/apps_st/data/portal.dbf	6	0	0.00	1.00	1	0	0	0.00
PORTAL_DOC	/ds2/oracle/VIS/db/apps_st/data/ptldoc.dbf	6	0	0.00	1.00	1	0	0	0.00
PORTAL_IDX	/ds2/oracle/VIS/db/apps_st/data/ptlidx.dbf	6	0	0.00	1.00	1	0	0	0.00
PORTAL_LOG	/ds2/oracle/VIS/db/apps_st/data/ptllog.dbf	6	0	0.00	1.00	1	0	0	0.00
RE	/ds2/oracle/VIS/db/apps_st/data/opre01.dbf	6	0	0.00	1.00	1	0	0	0.00
SYNCSERVER	/ds2/oracle/VIS/db/apps_st/data/mobile01.dbf	2	0	0.00	1.00	1	0	0	0.00
SYSAUX	/ds2/oracle/VIS/db/apps_st/data/sysaux01.dbf	159	0	1.38	1.00	197	0	0	0.00
SYSAUX	/ds2/oracle/VIS/db/apps_st/data/sysaux02.dbf	7	0	0.00	1.00	2	0	0	0.00
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys1.dbf	19	0	5.26	1.00	125	0	43	5.12
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys10.dbf	7	0	0.00	1.00	30	0	151	0.20
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys2.dbf	11	0	1.82	1.00	46	0	29	0.69
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys3.dbf	4	0	2.50	1.00	30	0	7	4.29
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys4.dbf	3	0	3.33	1.00	34	0	10	7.00
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys5.dbf	7	0	1.43	1.00	16	0	11	6.36
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys6.dbf	9	0	3.33	1.00	34	0	35	3.14
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys7.dbf	9	0	5.56	1.00	30	0	12	3.33
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys8.dbf	8	0	3.75	1.00	34	0	12	6.67
SYSTEM	/ds2/oracle/VIS/db/apps_st/data/sys9.dbf	6	0	0.00	1.00	1	0	0	0.00
TEMP1	/ds2/oracle/VIS/db/apps_st/data/temp1_01.dbf	109	0	0.55	15.00	140	0	0
TEMP2	/ds2/oracle/VIS/db/apps_st/data/temp2_02.dbf	0	0			18	0	0
UDDISYS_TS	/ds2/oracle/VIS/db/apps_st/data/uddisys01.dbf	6	0	0.00	1.00	1	0	0	0.00
WCRSYS_TS	/ds2/oracle/VIS/db/apps_st/data/wcrsys01.dbf	7	0	0.00	1.00	1	0	0	0.00
XDB	/ds2/oracle/VIS/db/apps_st/data/xdb01.dbf	6	0	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,005,329	100	3,240,799,379	703,387	1,702,011	0	0	1,844,158

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	0	33	325	1466	147995	37748700	147995	1000000
E	0	33	347	2532	1000000	37748700	17478519	1000000

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	800	0.10	98,950	1.53	4,855,163
D	1,600	0.20	197,900	1.37	4,342,458
D	2,400	0.30	296,850	1.31	4,146,505
D	3,200	0.39	395,800	1.25	3,979,723
D	4,000	0.49	494,750	1.19	3,789,683
D	4,800	0.59	593,700	1.14	3,633,921
D	5,600	0.69	692,650	1.10	3,499,201
D	6,400	0.79	791,600	1.07	3,385,206
D	7,200	0.89	890,550	1.03	3,284,270
D	8,000	0.98	989,500	1.00	3,187,613
D	8,128	1.00	1,005,332	1.00	3,174,173
D	8,800	1.08	1,088,450	0.97	3,072,611
D	9,600	1.18	1,187,400	0.93	2,948,790
D	10,400	1.28	1,286,350	0.91	2,904,108
D	11,200	1.38	1,385,300	0.90	2,844,605
D	12,000	1.48	1,484,250	0.88	2,799,582
D	12,800	1.57	1,583,200	0.88	2,781,724
D	13,600	1.67	1,682,150	0.87	2,756,638
D	14,400	1.77	1,781,100	0.86	2,729,059
D	15,200	1.87	1,880,050	0.85	2,708,366
D	16,000	1.97	1,979,000	0.85	2,684,718

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
99.98	293,122	71

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	6,144	5,239	500.69	0.20	0.04	100.00	0.00	629,140
E	6,144	5,242	484.92	0.00	0.00	0.00	0.00	629,140

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	10,854,892	10,854,892	0	0
64K	128K	5	5	0	0
128K	256K	47	47	0	0
256K	512K	5	5	0	0
512K	1024K	399	399	0	0
1M	2M	249,073	249,073	0	0
2M	4M	4	4	0	0
4M	8M	13	13	0	0
8M	16M	27	21	6	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
768	0.13	717,592.19	2,783.00	100.00	0
1,536	0.25	717,592.19	172.95	100.00	0
3,072	0.50	717,592.19	172.95	100.00	0
4,608	0.75	717,592.19	172.95	100.00	0
6,144	1.00	717,592.19	172.95	100.00	0
7,373	1.20	717,592.19	0.00	100.00	0
8,602	1.40	717,592.19	0.00	100.00	0
9,830	1.60	717,592.19	0.00	100.00	0
11,059	1.80	717,592.19	0.00	100.00	0
12,288	2.00	717,592.19	0.00	100.00	0
18,432	3.00	717,592.19	0.00	100.00	0
24,576	4.00	717,592.19	0.00	100.00	0
36,864	6.00	717,592.19	0.00	100.00	0
49,152	8.00	717,592.19	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
352	0.17	223	10,695	5,731,674	1.00	2,493	3.08	324,334,367
560	0.28	347	19,121	5,733,358	1.00	809	1.00	324,336,123
768	0.38	347	19,121	5,733,358	1.00	809	1.00	324,336,123
976	0.48	347	19,121	5,733,358	1.00	809	1.00	324,336,123
1,184	0.59	347	19,121	5,733,358	1.00	809	1.00	324,336,123
1,392	0.69	347	19,121	5,733,358	1.00	809	1.00	324,336,123
1,600	0.79	347	19,121	5,733,358	1.00	809	1.00	324,336,123
1,808	0.90	347	19,121	5,733,358	1.00	809	1.00	324,336,123
2,016	1.00	347	19,121	5,733,358	1.00	809	1.00	324,336,123
2,224	1.10	347	19,121	5,733,358	1.00	809	1.00	324,336,123
2,432	1.21	347	19,121	5,733,358	1.00	809	1.00	324,336,123
2,640	1.31	347	19,121	5,733,358	1.00	809	1.00	324,336,123
2,848	1.41	347	19,121	5,733,358	1.00	809	1.00	324,336,123
3,056	1.52	347	19,121	5,733,358	1.00	809	1.00	324,336,123
3,264	1.62	347	19,121	5,733,358	1.00	809	1.00	324,336,123
3,472	1.72	347	19,121	5,733,358	1.00	809	1.00	324,336,123
3,680	1.83	347	19,121	5,733,358	1.00	809	1.00	324,336,123
3,888	1.93	347	19,121	5,733,358	1.00	809	1.00	324,336,123
4,096	2.03	347	19,121	5,733,358	1.00	809	1.00	324,336,123

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,560	0.25	85,180	4,674,499
5,120	0.50	84,768	4,079,355
7,680	0.75	84,397	3,535,314
10,240	1.00	84,145	3,174,101
12,800	1.25	84,036	3,013,491
15,360	1.50	83,968	2,915,412
17,920	1.75	83,951	2,890,019
20,480	2.00	83,951	2,890,019

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
32	0.67	8	179	19	1.00	809	1.00	522
48	1.00	8	179	19	1.00	809	1.00	522
64	1.33	8	179	19	1.00	809	1.00	522
80	1.67	8	179	19	1.00	809	1.00	522
96	2.00	8	179	19	1.00	809	1.00	522
112	2.33	8	179	19	1.00	809	1.00	522

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	1,094,200	110	0
undo block	689,537	19	0
undo header	60,223	6	0
1st level bmb	133	0	0
file header block	10	0	2

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
UL-User-defined	76,388	75,196	1,192	51,077	2,966	58.07
TX-Transaction (index contention)	100,517	100,516	0	100,441	49	0.49
TX-Transaction (row lock contention)	4,246	4,208	38	4,188	2	0.56
SQ-Sequence Cache	15,467	15,467	0	5,704	1	0.18
CU-Cursor	501	501	0	5	0	30.00
HW-Segment High Water Mark	1,995	1,995	0	57	0	0.35
TX-Transaction (allocate ITL entry)	15	15	0	15	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
18	883.92	584,925	1,921	17	420.416666666666666666666666666666666667/482.45	0/0	0/0/0/43/196152/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
26-Mar 23:05	145	246	0	3	475	0/0	0/0/0/0/0/0
26-Mar 22:55	44	211	0	2	466	0/0	0/0/0/0/0/0
26-Mar 22:45	107,400	98,647	33	16	456	0/0	0/0/0/2/17408/0
26-Mar 22:35	71,358	118,613	292	13	462	0/0	0/0/0/3/15568/0
26-Mar 22:25	87,797	24,699	1,921	16	461	0/0	0/0/0/2/9728/0
26-Mar 22:15	96,903	27,264	1,319	15	436	0/0	0/0/0/1/5120/0
26-Mar 22:05	94,892	27,249	1,476	16	447	0/0	0/0/0/1/9344/0
26-Mar 21:55	241,341	183,246	813	17	420	0/0	0/0/0/23/94360/0
26-Mar 21:45	184,042	104,750	265	17	482	0/0	0/0/0/11/44624/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	3,844	0.00		0	0
AWR Alerted Metric Element list	30,923	0.00		0	0
Consistent RBA	216,730	0.02	0.16	0	0
FOB s.o list latch	9,114	0.05	0.00	0	0
In memory undo latch	725,516,359	1.54	0.01	17	361,013	0.00
JOX SGA heap latch	30	0.00		0	0
JS queue state obj latch	29,820	0.00		0	0
JS slv state obj latch	157	0.00		0	0
KMG MMAN ready and startup request latch	1,657	0.00		0	0
KTF sga latch	11	0.00		0	1,593	0.00
KWQMN job cache list latch	46	0.00		0	0
KWQP Prop Status	604	0.00		0	0
MQL Tracking Latch	0			0	99	0.00
Memory Management Latch	0			0	1,657	0.00
OS process	936	0.00		0	0
OS process allocation	2,282	0.00		0	0
OS process: request allocation	405	0.00		0	0
PL/SQL warning settings	6,337,966	0.00		0	0
SGA IO buffer pool latch	6,251	0.00		0	10,739	0.07
SQL memory manager latch	1	0.00		0	1,650	0.00
SQL memory manager workarea list latch	15,089,162	0.03	0.00	0	0
Shared B-Tree	3,167	0.00		0	0
active checkpoint queue latch	320,976	0.49	0.00	0	0
active service list	10,087	0.03	0.00	0	1,889	0.00
begin backup scn array	15	0.00		0	0
bq:time manger info latch	180	0.00		0	0
bufq statistics	5	0.00		0	0
cache buffer handles	235,198,750	4.34	0.00	2	0
cache buffers chains	6,437,685,594	4.67	0.04	763	10,486,890	20.96
cache buffers lru chain	3,988,369	0.72	0.01	0	25,282,752	0.98
cache table scan latch	0			0	35	0.00
channel handle pool latch	639	0.00		0	0
channel operations parent latch	27,923	0.08	0.00	0	0
checkpoint queue latch	5,964,547	0.01	0.03	0	1,687,827	0.02
client/application info	1,960	0.05	0.00	0	0
commit callback allocation	86	0.00		0	0
compile environment latch	376,389	0.00		0	0
dml lock allocation	2,932,934	0.29	0.00	0	0
dummy allocation	536	0.19	0.00	0	0
enqueue hash chains	4,853,780	0.23	0.01	0	3,406	0.23
enqueue sob latch	1	0.00		0	0
enqueues	832,055	0.21	0.02	0	0
event group latch	203	0.00		0	0
file cache latch	1,915	0.00		0	0
global KZLD latch for mem in SGA	148	0.00		0	0
global ctx hash table latch	923	0.00		0	0
hash table column usage latch	555	0.00		0	56,229	0.00
hash table modification latch	89	0.00		0	0
job workq parent latch	0			0	130	0.00
job_queue_processes parameter latch	146	0.00		0	0
kks stats	1,055	0.00		0	0
ksuosstats global area	333	0.00		0	0
ktm global data	255	0.00		0	0
kwqbsn:qsga	2,982	0.00		0	0
lgwr LWN SCN	218,242	0.35	0.00	0	0
library cache	438,627,563	1.24	0.00	2	0
library cache lock	215,736,861	1.75	0.00	0	0
library cache lock allocation	12,948	0.07	0.00	0	0
library cache pin	191,046,229	1.34	0.00	1	0
library cache pin allocation	4,663	0.00		0	0
list of block allocation	321,362	0.01	0.00	0	0
loader state object freelist	362	0.00		0	0
logminer context allocation	1	0.00		0	0
message pool operations parent latch	462	0.00		0	0
messages	1,599,927	0.20	0.00	0	0
mostly latch-free SCN	232,295	5.85	0.02	0	0
multiblock read objects	82	0.00		0	0
ncodef allocation latch	372	0.00		0	0
object queue header heap	965,345	0.00		0	8,041	0.00
object queue header operation	10,215,559	0.04	0.01	0	0
object stats modification	397	0.25	0.00	0	0
parallel query alloc buffer	660	0.00		0	0
parameter list	690	0.00		0	0
parameter table allocation management	280	1.07	0.00	0	0
post/wait queue	306,384	0.19	0.01	0	151,433	0.02
process allocation	405	0.49	1.00	0	203	0.00
process group creation	405	0.00		0	0
qmn state object latch	1	0.00		0	0
qmn task queue latch	5,239	2.42	0.10	0	0
redo allocation	1,522,678	2.05	0.02	0	60,868,885	1.41
redo copy	0			0	60,918,531	0.01
redo writing	1,073,882	0.21	0.00	0	0
resmgr group change latch	807	0.00		0	0
resmgr:actses active list	659	0.15	1.00	0	0
resmgr:actses change group	414	0.00		0	0
resmgr:free threads list	534	0.19	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	45,760,081	1.78	0.00	0	0
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	104	0.00		0	0
sequence cache	29,276,966	1.95	0.00	0	0
session allocation	22,368,675	3.23	0.00	0	0
session idle bit	46,860,503	0.05	0.00	0	0
session state list latch	1,139	0.61	0.43	0	0
session switching	371	0.00		0	0
session timer	1,890	0.00		0	0
shared pool	859,043	0.07	0.02	0	0
shared pool sim alloc	12	0.00		0	0
shared pool simulator	222,146	0.00		0	0
simulator hash latch	217,507,767	0.02	0.00	0	0
simulator lru latch	217,226,934	4.15	0.00	4	101,205	0.42
slave class create	2	0.00		0	0
sort extent pool	2,072	0.10	0.00	0	0
state object free list	2	0.00		0	0
statistics aggregation	84	0.00		0	0
temporary table state object allocation	228	0.00		0	0
threshold alerts latch	1,155	0.00		0	0
transaction allocation	118,681	0.00	0.00	0	0
transaction branch allocation	372	0.00		0	0
undo global data	819,459,561	0.35	0.00	1	423	0.71
user lock	632	1.42	0.00	0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
cache buffers chains	6,437,685,594	300,352,784	13,355,634	288,387,728	0	0	0
In memory undo latch	725,516,359	11,159,968	121,687	11,058,870	0	0	0
cache buffer handles	235,198,750	10,197,580	7,508	10,191,348	0	0	0
simulator lru latch	217,226,934	9,012,024	20,318	8,995,615	0	0	0
library cache	438,627,563	5,418,308	10,457	5,409,957	0	0	0
library cache lock	215,736,861	3,779,823	1,638	3,778,449	0	0	0
undo global data	819,459,561	2,845,932	5,952	2,841,356	0	0	0
library cache pin	191,046,229	2,555,840	5,048	2,551,755	0	0	0
row cache objects	45,760,081	813,704	470	813,335	0	0	0
session allocation	22,368,675	721,890	1,501	720,681	0	0	0
sequence cache	29,276,966	569,983	588	569,521	0	0	0
simulator hash latch	217,507,767	39,471	91	39,401	0	0	0
redo allocation	1,522,678	31,253	677	30,687	0	0	0
cache buffers lru chain	3,988,369	28,659	262	28,402	0	0	0
session idle bit	46,860,503	21,115	44	21,079	0	0	0
mostly latch-free SCN	232,295	13,584	226	13,386	0	0	0
enqueue hash chains	4,853,780	11,180	86	11,100	0	0	0
dml lock allocation	2,932,934	8,454	26	8,432	0	0	0
SQL memory manager workarea list latch	15,089,162	4,001	8	3,994	0	0	0
object queue header operation	10,215,559	3,729	46	3,687	0	0	0
messages	1,599,927	3,237	8	3,229	0	0	0
redo writing	1,073,882	2,289	2	2,287	0	0	0
enqueues	832,055	1,774	31	1,743	0	0	0
checkpoint queue latch	5,964,547	878	26	854	0	0	0
lgwr LWN SCN	218,242	756	1	755	0	0	0
shared pool	859,043	624	12	614	0	0	0
post/wait queue	306,384	594	4	590	0	0	0
qmn task queue latch	5,239	127	13	114	0	0	0
Consistent RBA	216,730	38	6	32	0	0	0
session state list latch	1,139	7	3	4	0	0	0
process allocation	405	2	2	0	0	0	0
resmgr:actses active list	659	1	1	0	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	0	58,317	25,889
In memory undo latch	kturbk	0	35,801	61,163
In memory undo latch	kticmt: child	0	13,156	89
In memory undo latch	ktichg: child	0	9,852	32,809
In memory undo latch	ktiTxnPoolFree	0	4,280	61
In memory undo latch	ktbgfc	0	257	1,675
In memory undo latch	ktiBRacquire	0	20	0
In memory undo latch	ktuswr	0	1	0
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	5	7
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	2	1
SQL memory manager workarea list latch	qesmmIRefreshBound	0	1	0
active service list	ksws_event: ksws event	0	2	2
cache buffer handles	kcbzgs	0	5,172	4,932
cache buffer handles	kcbzfs	0	2,336	2,575
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	17,572,549	17,444,899
cache buffers chains	kcbchg: kslbegin: call CR func	0	11,027,200	15,564,913
cache buffers chains	kcbgtcr: fast path	0	2,827,900	212,266
cache buffers chains	kcbgtcr: kslbegin excl	0	1,122,238	395,097
cache buffers chains	kcbrls: kslbegin	0	314,123	469,038
cache buffers chains	kcbget: pin buffer	0	305,345	156,573
cache buffers chains	kcbgcur: kslbegin	0	106,484	53,956
cache buffers chains	kcbzgb: scan from tail. nowait	0	99,157	0
cache buffers chains	kcbzwb	0	96,632	59,318
cache buffers chains	kcbcge	0	72,523	126,011
cache buffers chains	kcbnlc	0	8,310	10,789
cache buffers chains	kcb_is_private	0	2,522	13,099
cache buffers chains	kcb_pre_apply: kcbhq61	0	2,303	16,093
cache buffers chains	kcbget: exchange rls	0	2,250	3,519
cache buffers chains	kcbget: exchange	0	2,248	4,301
cache buffers chains	kcb_post_apply: kcbhq62	0	1,850	3,138
cache buffers chains	kcb_post_apply: kcbhq63	0	1,264	3,489
cache buffers chains	kcbesc: escalate	0	228	119
cache buffers chains	kcbbxsv	0	189	176
cache buffers chains	kcbso1: set no access	0	138	126
cache buffers chains	kcbnew: new latch again	0	98	1
cache buffers chains	kcbgtcr: kslbegin shared	0	56	38
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	0	17	0
cache buffers chains	kcbbic1	0	15	4
cache buffers chains	kcbzib: finish free bufs	0	12	12
cache buffers chains	kcbgtcr	0	7	22
cache buffers chains	kcbbic2	0	2	1
cache buffers chains	kcbzib: exchange rls	0	1	0
cache buffers lru chain	kcbzgws	0	126	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	65	0
cache buffers lru chain	kcbbxsv: move to being written	0	64	195
cache buffers lru chain	kcbzgb: posted for free bufs	0	3	29
cache buffers lru chain	kcbbic2	0	2	37
cache buffers lru chain	kcbzswcu	0	2	1
channel operations parent latch	ksrchdelete()	0	1	0
checkpoint queue latch	kcbkubc	0	12	8
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	11	0
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	3	25
dml lock allocation	ktaiam	0	21	22
dml lock allocation	ktaidm	0	5	4
enqueue hash chains	ksqrcl	0	41	21
enqueue hash chains	ksqgtl3	0	34	28
enqueue hash chains	ksqcmi: get hash chain latch after wait	0	10	37
enqueue hash chains	ksqcnl	0	1	0
enqueues	ksqdel	0	25	28
enqueues	ksqgel: create enqueue	0	3	0
enqueues	ksqies	0	3	3
event range base latch	No latch	0	13	13
lgwr LWN SCN	kcs023	0	69	0
library cache	kglpnp: child	0	4,334	5,249
library cache	kglpndl: child: after processing	0	2,982	240
library cache	kglpndl: child: before processing	0	1,371	2,974
library cache	kglobpn: child:	0	708	917
library cache	kglLockCursor	0	634	1,025
library cache	kglScanDependency	0	76	0
library cache	kgldte: child 0	0	10	24
library cache	kglhdgn: child:	0	3	10
library cache	kgldti: 2child	0	2	0
library cache	kglati	0	1	0
library cache	kglpin	0	1	0
library cache lock	kgllkdl: child: cleanup	0	905	940
library cache lock	kgllkal: child: multiinstance	0	733	698
library cache lock	kgllkdl: child: no lock handle	0	335	18
library cache pin	kglpnp: child	0	2,713	2,840
library cache pin	kglpndl	0	2,207	1,973
library cache pin	kglpnal: child: alloc space	0	128	235
messages	ksarcv	0	3	1
messages	ksarcv: after wait	0	3	4
messages	ksaamb: after wakeup	0	2	5
mostly latch-free SCN	kcslcu3	0	157	227
mostly latch-free SCN	kcs01	0	3	6
mostly latch-free SCN	kcsnew_scn_rba	0	3	0
mostly latch-free SCN	kcs024	0	1	0
object queue header operation	kcbo_switch_mq_bg	0	21	7
object queue header operation	kcbw_link_q	0	16	9
object queue header operation	kcbw_unlink_q	0	10	12
object queue header operation	kcbo_switch_cq	0	5	6
object queue header operation	kcbo_swap_buf	0	3	0
object queue header operation	kcbo_switch_q_bg	0	2	1
object queue header operation	kcbo_swap_buf_bg	0	1	23
post/wait queue	ksliwat:remove	0	3	4
post/wait queue	ksliwat:add:nowait	0	1	0
process allocation	ksucrp	0	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	0	547	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	84	546
redo allocation	kcrfw_redo_write: before write	0	24	90
redo allocation	kcrfw_redo_gen: redo allocation 2	0	18	0
redo allocation	kcrfw_redo_write: more space	0	4	41
redo writing	kcrfw_post: rba scn pair	0	1	0
redo writing	kcrfwcr	0	1	2
resmgr:actses active list	kgskchclass	0	1	1
row cache objects	kqreqd: reget	0	279	1
row cache objects	kqrpre: find obj	0	163	433
row cache objects	kqreqd	0	28	36
sequence cache	kdnssd	0	339	18
sequence cache	kdnnxt: cached seq	0	187	22
sequence cache	kdnss	0	62	548
session allocation	ksuprc	0	975	1,019
session allocation	ksudlc	0	485	455
session allocation	ksuxds: not user session	0	25	16
session allocation	ksuxds: KSUSFCLC not set	0	9	3
session allocation	ksucri	0	7	7
session idle bit	ksupuc: set busy	0	32	12
session idle bit	ksupuc: clear busy	0	21	40
session idle bit	ksuxds	0	1	2
session state list latch	kpseqd	0	3	0
shared pool	kghalo	0	5	5
shared pool	kghfre	0	4	1
shared pool	kghupr1	0	3	4
simulator hash latch	kcbsacc: lookup dba	0	85	90
simulator hash latch	kcbs_get_or_extract_simbufseq	0	6	1
simulator lru latch	kcbs_simulate: simulate set	0	19,983	20,172
simulator lru latch	kcbs_simbufseq	0	329	145
simulator lru latch	kcbs_lookup_setid	0	5	0
undo global data	kturimugur: child	0	4,797	2,460
undo global data	ktudba: KSLBEGIN	0	1,141	3,471
undo global data	ktudnx:child	0	10	21
undo global data	ktucof: at start	0	2	0
undo global data	ktufrbs: child	0	1	2
undo global data	ktusmupst: KSLBEGIN	0	1	0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 3,263,941,824
• Captured Segments account for 69.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
HR	APPS_TS_TX_IDX	PAY_ASSIGNMENT_ACTIONS_PK		INDEX	303,508,064	9.30
HR	APPS_TS_TX_IDX	PAY_PAYROLL_ACTIONS_PK		INDEX	294,207,552	9.01
HR	APPS_TS_TX_IDX	PAY_RUN_RESULTS_N50		INDEX	188,607,584	5.78
HR	APPS_TS_TX_DATA	PAY_ASSIGNMENT_ACTIONS		TABLE	175,561,712	5.38
HR	APPS_TS_TX_DATA	PAY_PAYROLL_ACTIONS		TABLE	146,625,120	4.49

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 706,028
• Captured Segments account for 62.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
HR	APPS_TS_TX_DATA	PAY_ACTION_INFORMATION		TABLE	208,468	29.53
HR	APPS_TS_TX_DATA	PAY_LATEST_BALANCES		TABLE	45,944	6.51
HR	APPS_TS_TX_DATA	PAY_RUN_BALANCES		TABLE	38,138	5.40
HR	APPS_TS_TX_IDX	PAY_ACTION_INFORMATION_N5		INDEX	37,992	5.38
HR	APPS_TS_TX_IDX	PAY_ACTION_INFORMATION_N2		INDEX	26,307	3.73

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
HR	APPS_TS_TX_IDX	PAY_ACTION_INTERLOCKS_PK		INDEX	19,927	17.95
HR	APPS_TS_TX_IDX	PAY_ASSIGNMENT_ACTIONS_N50		INDEX	12,921	11.64
HR	APPS_TS_TX_DATA	PAY_PAYROLL_ACTIONS		TABLE	7,814	7.04
HR	APPS_TS_TX_IDX	PAY_ASSIGNMENT_ACTIONS_PK		INDEX	7,709	6.94
HR	APPS_TS_TX_IDX	PAY_COSTS_FK2		INDEX	7,564	6.81

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
HR	APPS_TS_TX_IDX	PAY_ACTION_INFORMATION_N2		INDEX	15	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

• % of Capture shows % of Buffer Busy Waits for each top segment compared
• with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
HR	APPS_TS_TX_IDX	PAY_ASSIGNMENT_ACTIONS_PK		INDEX	218,594	20.22
HR	APPS_TS_TX_IDX	PAY_ACTION_INTERLOCKS_PK		INDEX	90,115	8.34
HR	APPS_TS_TX_IDX	PAY_ACTION_INFORMATION_PK		INDEX	88,679	8.20
HR	APPS_TS_TX_IDX	PAY_ASSIGNMENT_ACTIONS_N50		INDEX	65,014	6.01
HR	APPS_TS_TX_DATA	PAY_ASSIGNMENT_ACTIONS		TABLE	63,455	5.87

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	91	0.00	0		2	10
dc_global_oids	15,156	0.00	0		0	77
dc_histogram_data	1,187	0.00	0		0	396
dc_histogram_defs	8,074	0.19	0		0	37,184
dc_object_grants	38	0.00	0		0	158
dc_object_ids	91,382	0.00	0		0	6,585
dc_objects	2,092	0.05	0		0	7,672
dc_profiles	166	0.00	0		0	1
dc_rollback_segments	5,503	0.00	0		2	81
dc_segments	16,012	0.01	0		80	7,105
dc_sequences	9,756	0.00	0		9,756	33
dc_tablespace_quotas	61	0.00	0		0	5
dc_tablespaces	7,571,333	0.00	0		0	83
dc_usernames	1,769	0.00	0		0	46
dc_users	7,521,324	0.00	0		0	77
kqlsubheap_object	32	0.00	0		0	4
outstanding_alerts	510	0.00	0		2	54

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	3,624	0.00	41,353,913	-0.00	0	0
INDEX	8	0.00	43	0.00	0	0
JAVA DATA	2	0.00	0		0	0
PIPE	1,479	0.00	1,480	0.00	0	0
SQL AREA	11	45.45	337,290,715	-0.01	447	0
TABLE/PROCEDURE	4,602	0.00	51,175,074	-0.01	0	0
TRIGGER	276	0.00	5,407,833	-0.00	0	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	372.28		2.22	2.98	26	31	168	168
	Freeable	83.94	0.00	1.08	1.79	10		78	78
	SQL	26.39	14.01	0.16	0.24	2	17	162	160
	PL/SQL	14.46	5.76	0.09	0.07	1	1	168	168
	JAVA	3.71	3.70	1.24	0.36	2	3	3	3
E	Other	359.06		2.12	2.96	24	31	169	169
	Freeable	82.44	0.00	1.03	1.60	10		80	80
	SQL	25.42	13.46	0.16	0.25	2	17	163	159
	PL/SQL	14.37	5.34	0.09	0.08	1	1	169	169
	JAVA	3.71	3.70	0.93	0.69	2	3	4	3

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,522,825,728
Fixed Size	2,090,528
Redo Buffers	31,461,376
Variable Size	2,181,040,608

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	38.45	38.45	0.00
java	joxlod exec hp	9.25	9.25	0.00
large	PX msg pool	0.49	0.49	0.00
large	free memory	15.51	15.51	0.00
shared	ASH buffers	22.50	22.50	0.00
shared	CCursor		21.38
shared	KGLS heap	41.16	41.16	0.00
shared	KQR M PO	25.06	25.07	0.03
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	1,562.40	1,539.85	-1.44
shared	library cache	35.34	35.74	1.15
shared	private strands	22.17	22.17	0.00
shared	sql area	48.13	67.77	40.82
streams	KGH: NO ACCESS	15.98	15.98	0.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	8,128.00	8,128.00	0.00
	fixed_sga	1.99	1.99	0.00
	log_buffer	30.00	30.00	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

• Streams processes ordered by CPU usage
• CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	274,742	0	0
QMON Coordinator	129,134	0	0

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

• The Spill Rate should be very close to zero
• The Diff in Percentage Spilled should be very close to zero or negative

Queue Schema and Name	Incoming per second	Outgoing per second	Spilled per second	Diff Pct Spilled
APPLSYS.WF_CONTROL	0	0	0	0

Back to Streams Statistics
Back to Top

Buffered Subscribers

• All Subscribers should have a zero spill rate

Subscriber Name	Incoming per second	Outgoing per second	Spilled per second
WFBESCL_20532	0	0	0
WFBESCL_20533	0	0	0
WFBESCL_20534	0	0	0

Back to Streams Statistics
Back to Top

Rule Set

• Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	2	0	0	0	0
APPLSYS.WF_DEFERRED_R	0	0	0	0	0
APPLSYS.WF_NOTIFICATION_OUT_R	0	0	0	0	0

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)
_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
_system_trig_enabled	TRUE
_trace_files_public	TRUE
aq_tm_processes	1
background_dump_dest	/ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/bdump
compatible	10.2.0.3
core_dump_dest	/ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/cdump
cursor_sharing	EXACT
db_block_checking	FALSE
db_block_checksum	TRUE
db_block_size	8192
db_file_multiblock_read_count	8
db_files	512
db_name	VIS
dml_locks	10000
filesystemio_options	asynch
ifile	/ds2/oracle/VIS/db/tech_st/10.2.0/dbs/VIS_r12db_ifile.ora
job_queue_processes	2
log_buffer	30507008
log_checkpoint_interval	1000000
log_checkpoint_timeout	3600
log_checkpoints_to_alert	TRUE
max_dump_file_size	20480
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	600
optimizer_secure_view_merging	FALSE
parallel_max_servers	16
parallel_min_servers	0
pga_aggregate_target	6442450944
plsql_code_type	INTERPRETED
plsql_native_library_dir	/ds2/oracle/VIS/db/tech_st/10.2.0/plsql/nativelib
plsql_native_library_subdir_count	149
plsql_optimize_level	2
processes	800
session_cached_cursors	500
sessions	1600
sga_target	10737418240
shared_pool_size	2097152000
timed_statistics	TRUE
undo_management	AUTO
undo_retention	36000
undo_tablespace	APPS_UNDOTS1
user_dump_dest	/ds2/oracle/VIS/db/tech_st/10.2.0/admin/VIS_r12db/udump
utl_file_dir	/usr/tmp, /ds2/oracle/VIS/db/tech_st/10.2.0/appsutil/outbound/VIS_r12db, /usr/tmp
workarea_size_policy	AUTO

Back to Top

End of Report