WARNING: timed_statistics setting was set to 'FALSE' in the snapshot period: TIMINGS ARE INVALID
WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid.

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

VIS 445481357 VIS 1 01-Oct-15 10:10 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	445481357	VIS	1	01-Oct-15 10:10	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

payrollz Solaris[tm] OE (64-bit) 256 32 1 238.25

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
payrollz	Solaris[tm] OE (64-bit)	256	32	1	238.25

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1 01-Oct-15 11:08:24 409 10.9

End Snap: 9 01-Oct-15 11:28:38 415 13.5

Elapsed: 20.22 (mins)

DB Time: 0.00 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1	01-Oct-15 11:08:24	409	10.9
End Snap:	9	01-Oct-15 11:28:38	415	13.5
Elapsed:		20.22 (mins)
DB Time:		0.00 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 49,152M 49,152M Std Block Size: 8K

Shared Pool Size: 8,192M 8,192M Log Buffer: 273,656K

	Begin	End
Buffer Cache:	49,152M	49,152M	Std Block Size:	8K
Shared Pool Size:	8,192M	8,192M	Log Buffer:	273,656K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.0 0.0 0.00 0.00

DB CPU(s): 0.0 0.0 0.00 0.00

Redo size: 18,451,189.1 336,981.9

Logical reads: 4,430,923.0 80,923.8

Block changes: 110,931.1 2,026.0

Physical reads: 52.4 1.0

Physical writes: 2,376.3 43.4

User calls: 18,225.5 332.9

Parses: 98.5 1.8

Hard parses: 0.8 0.0

W/A MB processed: 0.0 0.0

Logons: 0.4 0.0

Executes: 195,991.2 3,579.5

Rollbacks: 1.0 0.0

Transactions: 54.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.0	0.0	0.00	0.00
DB CPU(s):	0.0	0.0	0.00	0.00
Redo size:	18,451,189.1	336,981.9
Logical reads:	4,430,923.0	80,923.8
Block changes:	110,931.1	2,026.0
Physical reads:	52.4	1.0
Physical writes:	2,376.3	43.4
User calls:	18,225.5	332.9
Parses:	98.5	1.8
Hard parses:	0.8	0.0
W/A MB processed:	0.0	0.0
Logons:	0.4	0.0
Executes:	195,991.2	3,579.5
Rollbacks:	1.0	0.0
Transactions:	54.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 101.17 Soft Parse %: 99.22

Execute to Parse %: 99.95 Latch Hit %: 94.38

Parse CPU to Parse Elapsd %: % Non-Parse CPU: 100.00

Shared Pool Statistics

Begin End

Memory Usage %: 29.54 31.46

% SQL with executions>1: 67.27 96.32

% Memory for SQL w/exec>1: 28.39 95.03

	Begin	End
Memory Usage %:	29.54	31.46
% SQL with executions>1:	67.27	96.32
% Memory for SQL w/exec>1:	28.39	95.03

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		0		100.00

Host CPU (CPUs: 256 Cores: 32 Sockets: 1)

Load Average Begin Load Average End %User %System %WIO %Idle

0.09 12.45 28.0 0.6 0.0 71.4

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.09	12.45	28.0	0.6	0.0	71.4

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

0.0 0.0 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.0	0.0	0.0

Begin End

Host Mem (MB): 243,968.0 243,968.0

SGA use (MB): 58,509.3 58,509.3

PGA use (MB): 1,421.4 1,436.2

% Host Mem used for SGA+PGA: 24.56 24.57

	Begin	End
Host Mem (MB):	243,968.0	243,968.0
SGA use (MB):	58,509.3	58,509.3
PGA use (MB):	1,421.4	1,436.2
% Host Mem used for SGA+PGA:	24.56	24.57

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
AVG_BUSY_TIME	34,618
AVG_IDLE_TIME	86,487
AVG_SYS_TIME	646
AVG_USER_TIME	33,956
BUSY_TIME	8,869,028
IDLE_TIME	22,147,123
SYS_TIME	170,717
USER_TIME	8,698,311
LOAD	0	12
OS_CPU_WAIT_TIME	34,100
PHYSICAL_MEMORY_BYTES	255,818,989,568
NUM_CPUS	256
NUM_CPU_CORES	32
NUM_CPU_SOCKETS	1
TCP_RECEIVE_SIZE_DEFAULT	128,000
TCP_SEND_SIZE_DEFAULT	49,152

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
01-Oct 11:08:24	0.09
01-Oct 11:11:30	34.73	17.90	16.21	1.69	82.10	0.00
01-Oct 11:12:32	32.83	11.87	11.05	0.82	88.13	0.00
01-Oct 11:20:33	58.16	62.41	61.97	0.44	37.59	0.00
01-Oct 11:20:34	57.21	0.65	0.44	0.22	99.35	0.00
01-Oct 11:20:35	57.21	0.57	0.46	0.11	99.43	0.00
01-Oct 11:26:36	0.77	0.44	0.37	0.06	99.56	0.00
01-Oct 11:27:36	0.55	0.21	0.18	0.03	99.79	0.00
01-Oct 11:28:38	12.45	6.80	5.68	1.12	93.20	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for % of Total DB time .00 (s)
Total FG Wait Time: (s) DB CPU time: .00 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			0		100.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Background Wait Events

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	Physical Reads (K)	Logical Reads (K)
SYS$BACKGROUND	0	15
SYS$USERS	0	17
VIS	64	5,376,553

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 0.0% of Total DB Time (s): 0
Captured PL/SQL account for 0.0% of Total DB Time (s): 0

Executions	SQL Id	SQL Module	SQL Text
128	02y1xzs7zv4rq	ICM@payrollz (TNS V1-V3)	SELECT A.VALUE, B.VALUE FROM V...
4	0643vntsbbshw	FNDOAMCOL	select V.PROFILE_OPTION_VALUE ...
2	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
27	0fr8zhn4ymu3v		select intcol#, type, flags, l...
482	0k8522rmdzg4k		select privilege# from sysauth...
2	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
376	0q8w0cndsp865	ICM@payrollz (TNS V1-V3)	SELECT FPOV.PROFILE_OPTION_VAL...
238	0s9jg1j7mykf2	e:FND:cp:OAMCOLMGR	DELETE FROM FND_DEBUG_RULE_OPT...
35,264	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
492,220	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 0.0% of Total CPU Time (s): 0
Captured PL/SQL account for 0.0% of Total CPU Time (s): 0

Executions	SQL Id	SQL Module	SQL Text
128	02y1xzs7zv4rq	ICM@payrollz (TNS V1-V3)	SELECT A.VALUE, B.VALUE FROM V...
4	0643vntsbbshw	FNDOAMCOL	select V.PROFILE_OPTION_VALUE ...
2	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
27	0fr8zhn4ymu3v		select intcol#, type, flags, l...
482	0k8522rmdzg4k		select privilege# from sysauth...
2	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
376	0q8w0cndsp865	ICM@payrollz (TNS V1-V3)	SELECT FPOV.PROFILE_OPTION_VAL...
238	0s9jg1j7mykf2	e:FND:cp:OAMCOLMGR	DELETE FROM FND_DEBUG_RULE_OPT...
35,264	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
492,220	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 0.0% of Total User I/O Wait Time (s): 0
Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 0

Executions	SQL Id	SQL Module	SQL Text
128	02y1xzs7zv4rq	ICM@payrollz (TNS V1-V3)	SELECT A.VALUE, B.VALUE FROM V...
4	0643vntsbbshw	FNDOAMCOL	select V.PROFILE_OPTION_VALUE ...
2	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
27	0fr8zhn4ymu3v		select intcol#, type, flags, l...
482	0k8522rmdzg4k		select privilege# from sysauth...
2	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
376	0q8w0cndsp865	ICM@payrollz (TNS V1-V3)	SELECT FPOV.PROFILE_OPTION_VAL...
238	0s9jg1j7mykf2	e:FND:cp:OAMCOLMGR	DELETE FROM FND_DEBUG_RULE_OPT...
35,264	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
492,220	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 5,376,579,443
Captured SQL account for 24.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	SQL Id	SQL Module	SQL Text
713,542,786	3,945,302	180.86	13.27	g2daxnc5b7rav	PYUSLV	SELECT /+ ORDERED / fnd_numb...
612,508,188	3,694,070	165.81	11.39	7rks7t2gukcwn	PYUSLV	SELECT /+ ORDERED / fnd_numb...
5,924,967	492,220	12.04	0.11	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
647,973	23,520	27.55	0.01	fxz0vtz7p7vy2	e:FND:cp:STANDARD	SELECT R.Conc_Login_Id, R.Requ...
446,797	612	730.06	0.01	73rvua18a9ytx	PYUSLV	declare ret number ; BEGIN hr_...
97,782	35,264	2.77	0.00	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
94,408	16,515	5.72	0.00	2450j0nxcnga5	ICM@payrollz (TNS V1-V3)	declare sql_dummy1 boolean;beg...
89,473	27,517	3.25	0.00	7qs7fx89194u1	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
51,392	440	116.80	0.00	3rwmntrn04p4f	ICM@payrollz (TNS V1-V3)	begin fnd_global.bless_next_in...
48,828	7,200	6.78	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 63,540
Captured SQL account for 1.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	SQL Id	SQL Module	SQL Text
391	381	1.03	0.62	3ktacv9r56b51		select owner#, name, namespace...
215	381	0.56	0.34	8swypbbr0m372		select order#, columns, types ...
109	509	0.21	0.17	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
44	612	0.07	0.07	73rvua18a9ytx	PYUSLV	declare ret number ; BEGIN hr_...
31	87	0.36	0.05	83taa7kaw59c1		select name, intcol#, segcol#,...
23	87	0.26	0.04	2q93zsrvbdw48		select grantee#, privilege#, n...
18	35,264	0.00	0.03	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
11	79	0.14	0.02	6aq34nj2zb2n7		select col#, grantee#, privile...
7	16,515	0.00	0.01	2450j0nxcnga5	ICM@payrollz (TNS V1-V3)	declare sql_dummy1 boolean;beg...
7	62	0.11	0.01	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 17,162
Captured SQL account for 0.0% of Total
Total UnOptimized Read Requests: 17,162
Captured SQL account for 0.0% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

Executions	SQL Id	SQL Module	SQL Text
128	02y1xzs7zv4rq	ICM@payrollz (TNS V1-V3)	SELECT A.VALUE, B.VALUE FROM V...
4	0643vntsbbshw	FNDOAMCOL	select V.PROFILE_OPTION_VALUE ...
2	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
27	0fr8zhn4ymu3v		select intcol#, type, flags, l...
482	0k8522rmdzg4k		select privilege# from sysauth...
2	0pt4jfmq9f1q0		SELECT x.statistic# as stat_id...
376	0q8w0cndsp865	ICM@payrollz (TNS V1-V3)	SELECT FPOV.PROFILE_OPTION_VAL...
238	0s9jg1j7mykf2	e:FND:cp:OAMCOLMGR	DELETE FROM FND_DEBUG_RULE_OPT...
35,264	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
492,220	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 237,819,994
Captured SQL account for 3.5% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
3,945,302	3,953,931	1.00	g2daxnc5b7rav	PYUSLV	SELECT /+ ORDERED / fnd_numb...
3,694,070	3,706,089	1.00	7rks7t2gukcwn	PYUSLV	SELECT /+ ORDERED / fnd_numb...
492,220	493,340	1.00	165d2bgc2b9hr	PYUSLV	SELECT NVL(SUM(prb.balance_val...
35,264	27,297	0.77	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
27,517	6,965	0.25	7qs7fx89194u1	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
23,520	116	0.00	fxz0vtz7p7vy2	e:FND:cp:STANDARD	SELECT R.Conc_Login_Id, R.Requ...
21,001	189,018	9.00	8w57t3xaxs89k	ICM@payrollz (TNS V1-V3)	SELECT NAME, VERSION FROM FND_...
16,515	16,516	1.00	2450j0nxcnga5	ICM@payrollz (TNS V1-V3)	declare sql_dummy1 boolean;beg...
9,529	13,180	1.38	bsa0wjtftg3uw		select file# from file$ where ...
8,595	722	0.08	55dc767ajydh3	e::cp:30	SELECT PROFILE_OPTION_VALUE FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 119,528
Captured SQL account for 12.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
891	16,515	0.75	2450j0nxcnga5	ICM@payrollz (TNS V1-V3)	declare sql_dummy1 boolean;beg...
880	6,388	0.74	bb8xj89g0aq9q	RUNGEN	select parameter_value into :b...
860	860	0.72	9gut0j2v6npp7	PYUSLV	select 'X' into :b0 from Fnd_C...
773	1,156	0.65	aw7fu9a9bdyus	PYUSLV	SELECT * FROM PER_SECURITY_PRO...
623	783	0.52	6u1kf5ctzu70k	e:FND:cp:OAMCOLMGR	select EXECUTABLE_APPLICATION_...
618	618	0.52	fj83qgv5su7sr	e:FND:cp:OAMCOLMGR	select SEQUENCE , WIDTH , LENG...
571	35,264	0.48	0wmwsjy9kd92f	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APPL...
565	27,517	0.47	7qs7fx89194u1	ICM@payrollz (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
563	21,001	0.47	8w57t3xaxs89k	ICM@payrollz (TNS V1-V3)	SELECT NAME, VERSION FROM FND_...
482	482	0.40	0k8522rmdzg4k		select privilege# from sysauth...

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

02y1xzs7zv4rq SELECT A.VALUE, B.VALUE FROM V$NLS_PARAMETERS A, V$NLS_PARAMETERS B WHERE A.PARAMETER = 'NLS_CHARACTERSET' AND B.PARAMETER = 'NLS_SORT'

0643vntsbbshw select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE_APPLICATION_ID = :3 and V.LEVEL_VALUE = :4

0cn2wm9d7zq8d SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

0fr8zhn4ymu3v select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0pt4jfmq9f1q0 SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC

0q8w0cndsp865 SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID

0s9jg1j7mykf2 DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_ID FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) )

0wmwsjy9kd92f SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE

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')

2450j0nxcnga5 declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

3nkd3g3ju5ph1 select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

3rwmntrn04p4f begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end;

55dc767ajydh3 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6u1kf5ctzu70k select EXECUTABLE_APPLICATION_ID into :b0 from FND_CONCURRENT_PROGRAMS where (APPLICATION_ID=:b1 and CONCURRENT_PROGRAM_ID=:b2)

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 ;

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7qs7fx89194u1 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

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 = 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 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)

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

8w57t3xaxs89k SELECT NAME, VERSION FROM FND_CACHE_VERSIONS

9gut0j2v6npp7 select 'X' into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code

aw7fu9a9bdyus SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1

bb8xj89g0aq9q select parameter_value into :b0 from pay_action_parameters where ((parameter_name=:b1 or parameter_name=REPLACE(:b1, ' ', '_')) or parameter_name=REPLACE(:b1, '_', ' '))

bsa0wjtftg3uw select file# from file$ where ts#=:1

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

fj83qgv5su7sr select SEQUENCE , WIDTH , LENGTH , SRW_DRIVER , HEADER_FLAG into :b0, :b1, :b2, :b3, :b4 from FND_PRINTER_STYLES where PRINTER_STYLE_NAME=:b5

fxz0vtz7p7vy2 SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And ((R.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on, 1, FND_CONC_GLOBAL.OPS_INST_NUM, R.OPS_INSTANCE))) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Ho ld_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((510, 40032), (510, 40033), (510, 42156), (510, 42157), (530, 43793), (530, 43794), (535, 42626), (535, 42627), (535, 42628)))) FOR UPDATE OF R.status_code NoWait

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

SQL Id	SQL Text
02y1xzs7zv4rq	SELECT A.VALUE, B.VALUE FROM V$NLS_PARAMETERS A, V$NLS_PARAMETERS B WHERE A.PARAMETER = 'NLS_CHARACTERSET' AND B.PARAMETER = 'NLS_SORT'
0643vntsbbshw	select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE_APPLICATION_ID = :3 and V.LEVEL_VALUE = :4
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0fr8zhn4ymu3v	select intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0pt4jfmq9f1q0	SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC
0q8w0cndsp865	SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID
0s9jg1j7mykf2	DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_ID FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) )
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
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')
2450j0nxcnga5	declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end;
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3rwmntrn04p4f	begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end;
55dc767ajydh3	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6u1kf5ctzu70k	select EXECUTABLE_APPLICATION_ID into :b0 from FND_CONCURRENT_PROGRAMS where (APPLICATION_ID=:b1 and CONCURRENT_PROGRAM_ID=:b2)
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 ;
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7qs7fx89194u1	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
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 = 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 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)
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
8w57t3xaxs89k	SELECT NAME, VERSION FROM FND_CACHE_VERSIONS
9gut0j2v6npp7	select 'X' into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 for update of Status_Code
aw7fu9a9bdyus	SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1
bb8xj89g0aq9q	select parameter_value into :b0 from pay_action_parameters where ((parameter_name=:b1 or parameter_name=REPLACE(:b1, ' ', '_')) or parameter_name=REPLACE(:b1, '_', ' '))
bsa0wjtftg3uw	select file# from file$ where ts#=:1
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
fj83qgv5su7sr	select SEQUENCE , WIDTH , LENGTH , SRW_DRIVER , HEADER_FLAG into :b0, :b1, :b2, :b3, :b4 from FND_PRINTER_STYLES where PRINTER_STYLE_NAME=:b5
fxz0vtz7p7vy2	SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And ((R.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on, 1, FND_CONC_GLOBAL.OPS_INST_NUM, R.OPS_INSTANCE))) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Ho ld_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((510, 40032), (510, 40033), (510, 42156), (510, 42157), (530, 43793), (530, 43794), (535, 42626), (535, 42627), (535, 42628)))) FOR UPDATE OF R.status_code NoWait
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.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 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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	12,442	10.25	0.19
CCursor + sql area evicted	1	0.00	0.00
CR blocks created	5,640,553	4,648.47	84.90
Cached Commit SCN referenced	23,296,733	19,199.20	350.64
Commit SCN cached	1,057,622	871.60	15.92
DBWR checkpoint buffers written	2,875,830	2,370.02	43.28
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	591	0.49	0.01
DBWR undo block writes	1,081,764	891.50	16.28
DFO trees parallelized	0	0.00	0.00
Effective IO time	83,323	68.67	1.25
HSC Heap Segment Block Changes	17,415,878	14,352.70	262.13
Heap Segment Array Inserts	2,044,634	1,685.01	30.77
Heap Segment Array Updates	81,989	67.57	1.23
IMU CR rollbacks	19,909	16.41	0.30
IMU Flushes	49,034	40.41	0.74
IMU Redo allocation size	308,793,236	254,481.32	4,647.70
IMU commits	4,263	3.51	0.06
IMU contention	3,636	3.00	0.05
IMU ktichg flush	446	0.37	0.01
IMU recursive-transaction flush	8	0.01	0.00
IMU undo allocation size	488,136,176	402,280.64	7,347.02
Number of read IOs issued	9	0.01	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	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
RowCR - row contention	70,226	57.87	1.06
RowCR attempts	14,500,950	11,950.46	218.26
RowCR hits	14,427,270	11,889.74	217.15
SMON posted for undo segment shrink	5	0.00	0.00
SQL*Net roundtrips to/from client	20,854,308	17,186.36	313.88
active txn count during cleanout	108,714,219	89,593.08	1,636.28
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	17,410	14.35	0.26
branch node splits	877	0.72	0.01
buffer is not pinned count	2,668,803,729	2,199,402.79	40,168.63
buffer is pinned count	801,656,364	660,657.52	12,065.87
bytes received via SQL*Net from client	5,681,178,377	4,681,947.73	85,508.40
bytes sent via SQL*Net to client	3,171,872,386	2,613,989.52	47,740.40
calls to get snapshot scn: kcmgss	225,978,169	186,232.13	3,401.24
calls to kcmgas	8,382,516	6,908.16	126.17
calls to kcmgcs	12,539,040	10,333.62	188.73
change write time	0	0.00	0.00
cleanout - number of ktugct calls	9,685,288	7,981.80	145.77
cleanouts and rollbacks - consistent read gets	4,283,233	3,529.88	64.47
cleanouts only - consistent read gets	356,113	293.48	5.36
cluster key scan block gets	6,099	5.03	0.09
cluster key scans	3,973	3.27	0.06
commit batch/immediate performed	9,693	7.99	0.15
commit batch/immediate requested	9,693	7.99	0.15
commit cleanout failures: block lost	892	0.74	0.01
commit cleanout failures: callback failure	716,287	590.30	10.78
commit cleanout failures: cannot pin	18,896	15.57	0.28
commit cleanouts	8,290,371	6,832.22	124.78
commit cleanouts successfully completed	7,554,296	6,225.61	113.70
commit immediate performed	9,693	7.99	0.15
commit immediate requested	9,693	7.99	0.15
commit txn count during cleanout	2,472,673	2,037.77	37.22
consistent changes	482,841,381	397,917.11	7,267.33
consistent gets	5,215,980,278	4,298,570.72	78,506.63
consistent gets - examination	2,498,579,197	2,059,118.09	37,606.55
consistent gets direct	79	0.07	0.00
consistent gets from cache	5,215,980,199	4,298,570.65	78,506.63
consistent gets from cache (fastpath)	2,644,235,227	2,179,155.50	39,798.84
cursor authentications	971	0.80	0.01
data blocks consistent reads - undo records applied	482,339,475	397,503.49	7,259.78
db block changes	134,606,270	110,931.13	2,025.98
db block gets	160,599,165	132,352.28	2,417.21
db block gets direct	215	0.18	0.00
db block gets from cache	160,598,950	132,352.10	2,417.20
db block gets from cache (fastpath)	42,176,376	34,758.21	634.80
deferred (CURRENT) block cleanout applications	227,771	187.71	3.43
dirty buffers inspected	1,000	0.82	0.02
doubling up with imu segment	6,925	5.71	0.10
enqueue conversions	1,637	1.35	0.02
enqueue releases	782,414	644.80	11.78
enqueue requests	817,623	673.82	12.31
enqueue timeouts	35,209	29.02	0.53
enqueue waits	189,545	156.21	2.85
exchange deadlocks	92,709	76.40	1.40
execute count	237,819,994	195,991.17	3,579.47
failed probes on index block reclamation	220	0.18	0.00
free buffer inspected	1,012,764	834.63	15.24
free buffer requested	10,306,864	8,494.05	155.13
heap block compress	136,973	112.88	2.06
hot buffers moved to head of LRU	136,817	112.75	2.06
immediate (CR) block cleanout applications	4,639,353	3,823.36	69.83
immediate (CURRENT) block cleanout applications	794,609	654.85	11.96
index crx upgrade (positioned)	4,298	3.54	0.06
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	384,227,028	316,647.49	5,783.07
index scans kdiixs1	1,328,363,970	1,094,725.47	19,993.44
java call heap collected bytes	7,664,576	6,316.50	115.36
java call heap collected count	37,281	30.72	0.56
java call heap gc count	2	0.00	0.00
java call heap live object count	4,451	3.67	0.07
java call heap live object count max	21,139	17.42	0.32
java call heap live size	332,760	274.23	5.01
java call heap live size max	2,041,720	1,682.61	30.73
java call heap object count	12,836	10.58	0.19
java call heap object count max	32,377	26.68	0.49
java call heap total size	4,194,304	3,456.59	63.13
java call heap total size max	4,194,304	3,456.59	63.13
java call heap used size	3,021,512	2,490.08	45.48
java call heap used size max	5,397,512	4,448.17	81.24
java session heap live object count	122	0.10	0.00
java session heap live object count max	122	0.10	0.00
java session heap live size max	0	0.00	0.00
java session heap object count	122	0.10	0.00
java session heap object count max	122	0.10	0.00
java session heap used size max	0	0.00	0.00
leaf node 90-10 splits	42,478	35.01	0.64
leaf node splits	238,576	196.61	3.59
lob reads	9	0.01	0.00
lob writes	289	0.24	0.00
lob writes unaligned	289	0.24	0.00
logical read bytes from cache	44,044,218,589,184	36,297,527,644.29	662,917,197.31
logons cumulative	534	0.44	0.01
max cf enq hold time	3	0.00	0.00
messages received	308,375	254.14	4.64
messages sent	308,375	254.14	4.64
min active SCN optimization applied on CR	264,868,819	218,282.53	3,986.59
no buffer to keep pinned count	4,192	3.45	0.06
no work - consistent read gets	2,655,854,250	2,188,730.92	39,973.72
opened cursors cumulative	225,898,952	186,166.85	3,400.04
parse count (describe)	12	0.01	0.00
parse count (failures)	4	0.00	0.00
parse count (hard)	932	0.77	0.01
parse count (total)	119,528	98.50	1.80
physical read IO requests	17,162	14.14	0.26
physical read bytes	520,519,680	428,968.39	7,834.43
physical reads	63,540	52.36	0.96
physical reads cache	57,111	47.07	0.86
physical reads cache prefetch	40,276	33.19	0.61
physical reads direct	6,429	5.30	0.10
physical reads direct (lob)	19	0.02	0.00
physical reads direct temporary tablespace	6,350	5.23	0.10
physical reads prefetch warmup	40,249	33.17	0.61
physical write IO requests	274,097	225.89	4.13
physical write bytes	23,620,771,840	19,466,246.57	355,520.35
physical writes	2,883,395	2,376.25	43.40
physical writes direct	6,565	5.41	0.10
physical writes direct (lob)	215	0.18	0.00
physical writes direct temporary tablespace	6,350	5.23	0.10
physical writes from cache	2,876,830	2,370.84	43.30
physical writes non checkpoint	2,792,032	2,300.96	42.02
pinned buffers inspected	168	0.14	0.00
pinned cursors current	6	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
queries parallelized	0	0.00	0.00
recursive aborts on index block reclamation	3	0.00	0.00
recursive calls	408,224,799	336,424.43	6,144.26
redo blocks checksummed by FG (exclusive)	594,776	490.16	8.95
redo blocks written	5,672,427	4,674.74	85.38
redo entries	70,634,009	58,210.59	1,063.12
redo ordering marks	630,038	519.22	9.48
redo size	22,389,078,792	18,451,189.11	336,981.92
redo size for direct writes	8,944	7.37	0.13
redo subscn max counts	2,929,972	2,414.64	44.10
redo synch long waits	49	0.04	0.00
redo synch time	530	0.44	0.01
redo synch time (usec)	5,870,711	4,838.14	88.36
redo synch writes	14,314	11.80	0.22
redo wastage	750,571,388	618,557.59	11,296.98
redo write time	1,569	1.29	0.02
redo writes	34,929	28.79	0.53
rollback changes - undo records applied	38,700	31.89	0.58
rollbacks only - consistent read gets	1,324,883	1,091.86	19.94
root node splits	89	0.07	0.00
rows fetched via callback	265,371,693	218,696.95	3,994.16
session cursor cache hits	8,835,343	7,281.34	132.98
session logical reads	5,376,579,443	4,430,923.00	80,923.83
shared hash latch upgrades - no wait	42,670,605	35,165.51	642.24
shared hash latch upgrades - wait	1,879,179	1,548.66	28.28
sorts (disk)	0	0.00	0.00
sorts (memory)	14,945,825	12,317.09	224.95
sorts (rows)	32,710,497	26,957.23	492.33
sql area evicted	1	0.00	0.00
sql area purged	4	0.00	0.00
summed dirty queue length	6,028	4.97	0.09
switch current to new buffer	1,855,161	1,528.87	27.92
table fetch by rowid	913,382,281	752,732.59	13,747.48
table fetch continued row	81,740	67.36	1.23
table scan blocks gotten	18,259,384	15,047.84	274.83
table scan rows gotten	784,068,215	646,162.85	11,801.15
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	8,190,270	6,749.73	123.27
temp space allocated (bytes)	1,048,576	864.15	15.78
total cf enq hold time	93	0.08	0.00
total number of cf enq holders	42	0.03	0.00
total number of times SMON posted	84	0.07	0.00
transaction rollbacks	9,548	7.87	0.14
undo change vector size	8,669,202,272	7,144,424.83	130,481.67
user calls	22,115,202	18,225.48	332.86
user commits	65,196	53.73	0.98
user rollbacks	1,244	1.03	0.02
workarea executions - onepass	16	0.01	0.00
workarea executions - optimal	10,053,187	8,284.99	151.31
write clones created in background	0	0.00	0.00
write clones created in foreground	95	0.08	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	1,943,540,144	2,003,819,280
session cursor cache count	36,255	106,812
session uga memory	318,628,993,064	413,193,873,264
opened cursors current	4,453	5,587
workarea memory allocated	4,416	4,416
logons current	409	415
session uga memory max	22,435,105,032	25,177,846,848
session pga memory	1,718,643,312	1,763,369,744

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

IOStat by Filetype summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

No data exists for this section of the report.

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_TS_TX_DATA	66	0	1.61	159,710	132	216,693	1.88
APPS_UNDOTS1	2	0	1.00	81,481	67	109,124	0.04
APPS_TS_TX_IDX	13,668	11	3.93	31,693	26	805,359	0.13
SYSTEM	2,501	2	1.00	112	0	2,695	0.19
SYSAUX	667	1	1.04	712	1	0	0.00
TEMP1	258	0	24.61	258	0	0	0.00
APPS_TS_SEED	170	0	1.46	37	0	4,335	4.46
APPS_TS_ARCHIVE	26	0	1.88	35	0	3,787	0.01

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
APPS_TS_ARCHIVE	/ebizdata/data/archive_01.dbf	26	0	1.88	35	0	3,787	0.01
APPS_TS_SEED	/ebizdata/data/reference_01.dbf	91	0	1.44	22	0	2,602	3.13
APPS_TS_SEED	/ebizdata/data/reference_02.dbf	79	0	1.49	15	0	1,733	6.45
APPS_TS_TX_DATA	/ebizdata/data/tx_data_01.dbf	8	0	1.00	52,123	43	67,047	0.04
APPS_TS_TX_DATA	/ebizdata/data/tx_data_02.dbf	18	0	1.22	12,908	11	14,138	0.03
APPS_TS_TX_DATA	/ebizdata/data/tx_data_03.dbf	17	0	1.53	46,715	38	74,112	3.93
APPS_TS_TX_DATA	/ebizdata/data/tx_data_04.dbf	23	0	2.17	47,964	40	61,396	1.86
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_01.dbf	4,245	3	3.72	7,551	6	190,654	0.12
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_02.dbf	3,723	3	4.08	7,621	6	191,378	0.14
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_03.dbf	2,771	2	3.82	7,822	6	217,163	0.13
APPS_TS_TX_IDX	/ebizdata/data/tx_idx_04.dbf	2,929	2	4.17	8,699	7	206,164	0.11
APPS_UNDOTS1	/ebizdata/data/undo_01.dbf	2	0	1.00	81,481	67	109,124	0.04
SYSAUX	/ebizdata/data/sysaux_01.dbf	667	1	1.04	712	1	0	0.00
SYSTEM	/ebizdata/data/sys_01.dbf	2,501	2	1.00	112	0	2,695	0.19
TEMP1	/ebizdata/data/temp1_01.dbf	258	0	24.61	258	0	0

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	5,949,814	100	5,342,115,652	57,185	2,876,830	0	0	1,142,627

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,883,395

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	2,874,300	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	15	614	971	154581048	154581048
E	0	171	233210	648881	154581048	154581048

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
98.06	23,155	459

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	16,384	13,716	1,421.39	4.31	0.30	100.00	0.00	1,048,576
E	16,384	13,681	1,436.21	4.31	0.30	100.00	0.00	1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	9,958,104	9,958,104	0
64K	128K	9,812	9,812	0
128K	256K	1,946	1,946	0
256K	512K	2,028	2,028	0
512K	1024K	1,075	1,075	0
1M	2M	59	59	0
2M	4M	6	6	0
4M	8M	21	21	0
8M	16M	23	17	6
16M	32M	2	0	2
32M	64M	8	0	8

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

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)
128	0.14	0	0	0	0
256	0.29	0	0	0	0
384	0.43	0	0	0	0
512	0.57	0	0	0	0
640	0.71	0	0	0	0
768	0.86	0	0	0	0
896	1.00	0	0	0	0
1,024	1.14	0	0	0	0
1,152	1.29	0	0	0	0
1,280	1.43	0	0	0	0
1,408	1.57	0	0	0	0
1,536	1.71	0	0	0	0
1,664	1.86	0	0	0	0
1,792	2.00	0	0	0	0
1,920	2.14	0	0	0	0
2,048	2.29	0	0	0	0
2,176	2.43	0	0	0	0
2,304	2.57	0	0	0	0
2,432	2.71	0	0	0	0
2,560	2.86	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	984,215	520	1
1st level bmb	46,272	5	0
undo header	70,849	4	0
2nd level bmb	667	3	4
3rd level bmb	657	1	2
undo block	38,187	0	0
segment header	427	0	0
system undo header	179	0	0
file header block	97	0	0
system undo block	13	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits
TX-Transaction (index contention)	134,819	134,820	0	107,786
SQ-Sequence Cache	62,913	62,913	0	52,881
TX-Transaction (row lock contention)	47,504	16,008	31,493	15,682
HW-Segment High Water Mark	23,013	22,394	619	7,443
UL-User-defined	6,970	3,978	2,992	3,086
FB-Format Block	96,753	96,746	0	1,355
US-Undo Segment	859	859	0	580
TX-Transaction	297,751	297,600	0	381
TX-Transaction (allocate ITL entry)	1,147	1,042	105	339
CU-Cursor	908	908	0	3

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	1,080.31	261,661	1,628	236	37.2/259	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
01-Oct 11:22	560,398	136,934	1,461	236	37	0/0	0/0/0/0/0/0
01-Oct 11:12	519,913	124,727	1,628	149	259	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	8	0.00		0
AQ dequeue txn counter latch	5,882	0.37	0.00	0
ASM db client latch	1,130	0.00		0
ASM map operation hash table	8	0.00		0
ASM network state latch	730	0.00		0
Change Notification Hash table latch	404	0.00		0
Consistent RBA	35,362	0.10	0.00	0
DML lock allocation	224,180	0.01	0.00	0
Event Group Locks	1,054	0.00		0
FOB s.o list latch	8,519	0.11	0.00	0
File State Object Pool Parent Latch	8	0.00		0
I/O Staticstics latch	8	0.00		0
IPC stats buffer allocation latch	8	0.00		0
In memory undo latch	102,457,376	0.19	0.04	69,139	0.01
JS Sh mem access	10	0.00		0
JS queue access latch	8	0.00		0
JS queue state obj latch	7,290	0.00		0
JS slv state obj latch	88	0.00		0
KFC FX Hash Latch	8	0.00		0
KFC Hash Latch	8	0.00		0
KFCL LE Freelist	8	0.00		0
KGNFS-NFS:SHM structure	8	0.00		0
KGNFS-NFS:SVR LIST	8	0.00		0
KJC message pool free list	8	0.00		0
KJCT flow control latch	8	0.00		0
KMG MMAN ready and startup request latch	404	0.00		0
KTF sga latch	7	0.00		366	0.00
KWQMN job cache list latch	28	0.00		0
KWQP Prop Status	168	0.00		0
KWQS pqsubs latch	308	0.00		0
KWQS pqueue ctx latch	188	0.00		0
Locator state objects pool parent latch	8	0.00		0
Lsod array latch	8	0.00		0
MQL Tracking Latch	0			87	19556.32
Memory Management Latch	8	0.00		404	0.00
Memory Queue	48	0.00		0
Memory Queue Message Subscriber #1	8	0.00		0
Memory Queue Message Subscriber #2	8	0.00		0
Memory Queue Message Subscriber #3	8	0.00		0
Memory Queue Message Subscriber #4	8	0.00		0
Memory Queue Subscriber	8	0.00		0
MinActiveScn Latch	14	0.00		0
Mutex	8	0.00		0
Mutex Stats	8	0.00		0
NLS data objects	1	0.00		0
OS process	2,298	0.00		0
OS process allocation	3,640	0.03	0.00	0
OS process: request allocation	1,018	0.00		0
PL/SQL warning settings	3,708,332	0.50	0.00	0
PX hash array latch	8	0.00		0
QMT	8	0.00		0
SGA blob parent	8	0.00		0
SGA bucket locks	8	0.00		0
SGA heap locks	8	0.00		0
SGA pool locks	8	0.00		0
SQL memory manager latch	0			403	0.00
SQL memory manager workarea list latch	13,209,168	0.03	0.00	0
Shared B-Tree	1,377	0.00		0
Streams Generic	8	0.00		0
Testing	8	0.00		0
Token Manager	8	0.00		0
WCR: sync	8	0.00		0
Write State Object Pool Parent Latch	8	0.00		0
X$KSFQP	8	0.00		0
XDB NFS Security Latch	8	0.00		0
XDB unused session pool	8	0.00		0
XDB used session pool	8	0.00		0
active checkpoint queue latch	284,777	0.61	0.00	0
active service list	4,337	0.09	0.50	3,765	0.00
begin backup scn array	172	0.00		0
bq:time manger info latch	43	0.00		0
buffer pool	8	0.00		0
bufq statistics	40	0.00		0
business card	8	0.00		0
cache buffer handles	168,320,555	16.98	0.00	0
cache buffers lru chain	6,743,802	0.04	0.00	18,107,986	0.31
cache table scan latch	6	0.00		6	0.00
call allocation	515,077	1.69	0.00	0
cas latch	8	0.00		0
change notification client cache latch	8	0.00		0
channel handle pool latch	1,027	0.00		0
channel operations parent latch	11,368	0.00		0
checkpoint queue latch	12,720,575	0.00	0.00	3,110,472	0.01
client/application info	7,917	0.00		0
compile environment latch	534	0.00		0
corrupted undo seg latch	125,648	0.02	0.00	0
cp cmon/server latch	8	0.00		0
cp pool latch	8	0.00		0
cp server hash latch	8	0.00		0
cp sga latch	730	0.00		0
cvmap freelist lock	8	0.00		0
deferred cleanup latch	730	0.00		0
dml lock allocation	1,022	0.00		0
done queue latch	8	0.00		0
dummy allocation	1,070	0.09	0.00	0
enqueue freelist latch	8	0.00		688,507	0.01
enqueue hash chains	1,884,945	4.37	0.00	572	0.70
enqueues	9,300	0.08	0.00	0
fifth spare latch	8	0.00		0
file cache latch	11,484	0.01	0.00	0
flashback copy	8	0.00		0
fourth Audit Vault latch	8	0.00		0
gcs commit scn state	8	0.00		0
gcs partitioned table hash	8	0.00		0
gcs pcm hashed value bucket hash	8	0.00		0
gcs resource freelist	8	0.00		0
gcs resource hash	8	0.00		0
gcs resource scan list	8	0.00		0
gcs shadows freelist	8	0.00		0
ges domain table	8	0.00		0
ges enqueue table freelist	8	0.00		0
ges group table	8	0.00		0
ges process hash list	8	0.00		0
ges process parent latch	8	0.00		0
ges resource hash list	8	0.00		0
ges resource scan list	8	0.00		0
ges resource table freelist	8	0.00		0
ges value block free list	8	0.00		0
global KZLD latch for mem in SGA	460	0.00		0
global ctx hash table latch	1,066	0.00		0
global tx hash mapping	8	0.00		0
granule operation	8	0.00		0
hash table column usage latch	643	0.00		115,675	0.00
hash table modification latch	2	0.00		0
heartbeat check	8	0.00		0
intra txn parallel recovery	8	0.00		0
io pool granule metadata list	8	0.00		0
job workq parent latch	30	0.00		22	0.00
job_queue_processes free list latch	44	0.00		0
job_queue_processes parameter latch	286	0.00		0
k2q lock allocation	8	0.00		0
kdlx hb parent latch	8	0.00		0
kgb parent	8	0.00		0
kgnfs mount latch	8	0.00		0
kokc descriptor allocation latch	5,892	6.52	0.01	0
ksfv messages	8	0.00		0
ksim group membership cache	8	0.00		0
kss move lock	32	0.00		0
ksuosstats global area	64	0.00		0
ksv allocation latch	772	0.00		0
ksv class latch	44	0.00		0
ksv msg queue latch	8	0.00		0
ksz_so allocation latch	1,018	0.10	0.00	0
ktm global data	342	0.00		0
kwqbsn:qsga	777	0.51	0.00	0
kwqbsn:qxl	3	0.00		0
lgwr LWN SCN	36,165	1.86	0.00	0
list of block allocation	807,860	0.33	0.00	0
loader state object freelist	1,222	0.25	0.00	0
lob segment dispenser latch	8	0.00		0
lob segment hash table latch	12	0.00		0
lob segment query latch	8	0.00		0
lock DBA buffer during media recovery	8	0.00		0
logical standby cache	8	0.00		0
logminer context allocation	16	0.00		0
logminer work area	8	0.00		0
longop free list parent	8	0.00		0
mapped buffers lru chain	8	0.00		0
message pool operations parent latch	980	0.00		0
messages	689,304	0.41	0.00	0
mostly latch-free SCN	53,223	24.07	0.00	0
msg queue latch	8	0.00		0
multiblock read objects	17,310	0.24	0.00	0
name-service namespace bucket	8	0.00		0
ncodef allocation latch	730	0.00		0
object queue header heap	2,329,014	0.00	0.00	2,655	0.00
object queue header operation	17,815,645	0.01	0.00	0
object stats modification	8	0.00		0
parallel query alloc buffer	2,568	0.00		0
parallel query stats	8	0.00		0
parameter list	1,600	0.00		0
parameter table management	10,784	0.10	0.73	0
peshm	8	0.00		0
pesom_free_list	50,728	0.00		0
pesom_hash_node	50,728	0.00		0
post/wait queue	58,347	0.08	0.00	16,465	0.22
process allocation	1,070	0.00		512	0.00
process group creation	1,018	0.00		0
process queue	8	0.00		0
process queue reference	8	0.00		0
qmn task queue latch	1,487	4.64	0.00	0
query server freelists	8	0.00		0
queued dump request	4	0.00		0
queuing load statistics	8	0.00		0
recovery domain hash list	8	0.00		0
redo allocation	1,063,598	1.29	0.00	70,623,151	0.75
redo copy	8	0.00		70,634,192	0.05
redo writing	711,638	0.08	0.00	0
resmgr group change latch	1,410	0.00		0
resmgr:active threads	1,070	0.00		0
resmgr:actses change group	502	0.00		0
resmgr:actses change state	8	0.00		0
resmgr:free threads list	1,062	0.09	0.00	0
resmgr:plan CPU method	8	0.00		0
resmgr:resource group CPU method	8	0.00		0
resmgr:schema config	8	0.00		0
resmgr:session queuing	8	0.00		0
rm cas latch	8	0.00		0
row cache objects	39,941,962	11.59	0.00	0
rules engine rule set statistics	800	0.00		0
second Audit Vault latch	8	0.00		0
second spare latch	8	0.00		0
sequence cache	30,151,841	5.37	0.00	0
session allocation	98,979	0.00		97,940	0.01
session idle bit	44,327,661	0.01	0.00	0
session queue latch	8	0.00		0
session state list latch	2,912	0.10	1.00	0
session switching	1,244	0.00		0
session timer	939	0.00		0
shared pool	2,337,362	0.09	0.01	0
shared pool sim alloc	8	0.00		0
shared pool simulator	8	0.00		0
sim partition latch	8	0.00		0
simulator hash latch	8	0.00		0
simulator lru latch	8	0.00		0
sort extent pool	6,274	0.14	0.00	0
space background state object latch	12	0.00		0
space background task latch	4,944	10.11	0.01	1,062	1.13
state object free list	16	0.00		0
statistics aggregation	2,688	0.00		0
tablespace key chain	8	0.00		0
temp lob duration state obj allocation	1	0.00		0
temporary table state object allocation	892	0.00		0
test excl. parent l0	8	0.00		0
test excl. parent2 l0	8	0.00		0
third spare latch	8	0.00		0
threshold alerts latch	5	0.00		0
transaction allocation	22,273	0.00		0
undo global data	215,835,696	1.07	0.00	2,025,785	0.71
virtual circuit buffers	8	0.00		0
virtual circuit holder	8	0.00		0
virtual circuit queues	8	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffer handles	168,320,555	28,572,426	1,988	28,570,462
row cache objects	39,941,962	4,630,301	103	4,630,201
undo global data	215,835,696	2,315,424	137	2,315,294
sequence cache	30,151,841	1,619,559	69	1,619,493
In memory undo latch	102,457,376	195,231	7,450	188,287
enqueue hash chains	1,884,945	82,294	29	82,266
redo allocation	1,063,598	13,733	5	13,729
call allocation	515,077	8,682	2	8,680
session idle bit	44,327,661	4,623	2	4,621
cache buffers lru chain	6,743,802	2,554	2	2,552
shared pool	2,337,362	2,199	17	2,183
object queue header operation	17,815,645	2,028	2	2,026
space background task latch	4,944	500	4	496
checkpoint queue latch	12,720,575	400	1	399
kokc descriptor allocation latch	5,892	384	3	381
parameter table management	10,784	11	8	3
active service list	4,337	4	2	2
session state list latch	2,912	3	3	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	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	4,432	1,958
In memory undo latch	kticmt: child	2,079	78
In memory undo latch	ktichg: child	851	753
In memory undo latch	ktiFlushMe	106	8
In memory undo latch	ktbgfc	17	158
In memory undo latch	ktiTxnPoolFree	3	0
In memory undo latch	kturbk	1	4,540
PC and Classifier lists for WLM	No latch	604,587	0
active service list	kswslogon: session logout	2	2
cache buffer handles	kcbzgs	1,121	1,391
cache buffer handles	kcbzfs	867	597
cache buffers lru chain	kcbzgws	2	0
call allocation	ksuxds	2	1
checkpoint queue latch	kcbklbc_cql	1	0
enqueue hash chains	ksqrcl	11	9
enqueue hash chains	ksqcmi: get hash chain latch after wait	9	13
enqueue hash chains	ksqcmi: kslgpl	7	4
enqueue hash chains	ksqcmi: if deadlock detected	2	0
kokc descriptor allocation latch	kokcdlt: regular free	3	3
object queue header operation	kcbo_switch_mq_bg	2	2
parameter table management	kspcpy	8	0
redo allocation	kcrfw_redo_gen: redo allocation 1	5	0
row cache objects	kqreqd: reget	77	5
row cache objects	kqrpre: find obj	21	86
row cache objects	kqreqd	5	14
sequence cache	kdnssd	46	4
sequence cache	kdnnxt: cached seq	12	3
sequence cache	kdnss	11	62
session idle bit	ksupuc: clear busy	1	1
session idle bit	ksupuc: set busy	1	1
session state list latch	kpseqd	3	0
shared pool	kghalp	9	9
shared pool	kghfre	8	1
space background task latch	ktsj_grab_task	4	4
undo global data	ktudba: KSLBEGIN	133	135
undo global data	ktufrbs_3	2	0
undo global data	kturax	2	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglpnal1 90	1,238,953
Library Cache	kglpin1 4	914,481
Library Cache	kglpndl1 95	851,516
Library Cache	kgllkc1 57	341,420
Library Cache	kgllkdl1 85	192,868
Cursor Pin	kkslce [KKSCHLPIN2]	96,705
Library Cache	kglobpn1 71	13,747
Library Cache	kglllal3 111	12,202
Cursor Pin	kksfbc [KKSCHLFSP2]	4,559
Library Cache	kglhdgn2 106	4,437
Cursor Pin	kksLockDelete [KKSCHLPIN6]	3,115
Library Cache	kgllldl2 112	2,563
Library Cache	kglget2 2	2,366
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	1,336
Cursor Pin	kksfbc [KKSCHLPIN1]	1,204
Library Cache	kglhdgn1 62	764
Library Cache	kglllal1 109	576
Library Cache	kgllkal3 82	276
hash table	kkshGetNextChild [KKSHBKLOC1]	169
hash table	kkscsSearchChildList [KKSHBKLOC2]	143
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	134
Library Cache	kglini1 32	108
Library Cache	kglUpgradeLock 119	71
Library Cache	kglnti1 46	60
Library Cache	kglhbh1 63	57
Library Cache	kglobld1 75	54
Cursor Pin	kksxsccmp [KKSCHLPIN5]	36
Library Cache	kglati1 45	35
Library Cache	kglrdtin1 44	31
Library Cache	kglget1 1	27
Library Cache	kgllkal5 84	17
Library Cache	kglhdgc1 102	16
Library Cache	kglReleaseHandleReference 125	7
Library Cache	kgldtin1 42	7
Library Cache	kglGetHandleReference 124	3
Cursor Pin	kksSetBindType [KKSCHLPIN4]	1
hash table	kkshListChanged [KKSHBKLOC9]	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	32	0.00	16	1
dc_global_oids	4,950	0.22	0	123
dc_histogram_data	2,791	1.65	0	370
dc_histogram_defs	22,187	8.37	0	38,679
dc_object_grants	183	3.28	0	247
dc_objects	131,447	0.47	0	11,101
dc_profiles	482	0.00	0	1
dc_rollback_segments	57,767	0.25	435	229
dc_segments	28,767	1.55	769	7,390
dc_sequences	10,031	0.11	10,031	33
dc_tablespaces	6,527,698	0.00	0	57
dc_users	6,526,305	0.00	0	166
global database name	1,374	0.00	0	1
outstanding_alerts	3	0.00	0	4

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	920	0.00	0		0	0
APP CONTEXT	1,733	0.12	22,419	0.09	0	0
BODY	35,588	0.23	39,139,133	-0.23	0	0
CLUSTER	12	0.00	12	0.00	0	0
DBLINK	921	0.00	0		0	0
DIRECTORY	986	0.00	986	0.00	0	0
EDITION	565	0.00	1,047	0.00	0	0
INDEX	665	2.11	665	3.91	12	0
PIPE	360	0.00	360	0.00	0	0
QUEUE	407	0.00	5,323	0.00	0	0
SCHEMA	1,254	0.16	0		0	0
SQL AREA	58,735	3.36	287,695,678	-1.46	6	6
SQL AREA BUILD	1,899	40.44	0		0	0
SQL AREA STATS	839	99.28	839	99.28	0	0
TABLE/PROCEDURE	67,450	0.86	49,135,374	-0.31	21	0
TRIGGER	2,323	0.26	5,576,793	-0.01	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	48,256.00	48,256.00	48,256.00	49,152.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	16,384.00	16,384.00	16,384.00	16,384.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	0.00	0.00	0.00	0.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	896.00	896.00	896.00	896.00	STA/
large pool	0.00	0.00	0.00	0.00	STA/
shared pool	8,192.00	8,192.00	8,192.00	8,192.00	STA/
streams pool	896.00	896.00	0.00	896.00	GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
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	918.29		2.25	2.14	19	19	409	409
B	PL/SQL	249.89	227.21	0.61	0.29	2	2	409	409
B	Freeable	112.81	0.00	0.40	0.81	9		285	285
B	JAVA	101.95	101.78	3.92	4.37	25	35	26	26
B	SQL	38.56	11.54	0.11	0.21	2	13	366	361
E	Other	940.48		2.27	1.94	19	19	415	415
E	PL/SQL	252.86	238.58	0.61	0.30	2	2	415	415
E	Freeable	113.63	0.00	0.40	1.53	22		281	281
E	JAVA	101.95	101.77	3.92	4.37	25	35	26	26
E	SQL	27.40	9.62	0.07	0.15	2	13	373	368

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	50,600,083,456
Fixed Size	2,174,144
Redo Buffers	280,223,744
Variable Size	10,468,987,712

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	JOXLE	14.37	14.37	0.00
java	free memory	880.83	880.83	0.00
shared	ASH buffers	254.00	254.00	0.00
shared	Checkpoint queue	128.13	128.13	0.00
shared	FileOpenBlock	96.00	96.00	0.00
shared	KGLH0	104.62	122.99	17.56
shared	SQLA	127.06	148.30	16.72
shared	db_block_hash_buckets	356.00	356.00	0.00
shared	dbktb: trace buffer	93.75	93.75	0.00
shared	dbwriter coalesce buffer	128.13	128.13	0.00
shared	dirty object counts array	128.00	128.00	0.00
shared	event statistics per sess	115.03	115.03	0.00
shared	free memory	5,771.73	5,614.89	-2.72
shared	ksunfy : SSO free list	107.72	107.72	0.00
shared	private strands	135.53	135.53	0.00
shared	state objects		88.53
streams	free memory	894.06	894.06	-0.00
	buffer_cache	48,256.00	48,256.00	0.00
	fixed_sga	2.07	2.07	0.00
	log_buffer	267.24	267.24	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	1001 10:22:26	0.00	0.00	0.00
QMON Slaves	1001 10:22:36	0.00	0.00	0.00

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 Capture Rate

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

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec	Spill Msgs	Spill Msgs/sec	%Spill Msgs
APPLSYS.WF_CONTROL(423650)	0	0.00	0	0.00	0	0.00

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enq Msgs	Enq Msgs/sec	Deq Msgs	Deq Msgs/sec	Spill Msgs	Spill Msgs/sec	%Spill Msgs
WFBESCL_21135(17394)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00
WFBESCL_21136(17392)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00
WFBESCL_21137(17393)/APPLSYS.WF_CONTROL	0	0.00	0	0.00	0	0.00

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	%Transf Time	%Eval Time
APPLSYS.FND_CP_GSM_IPC_AQ(425717)	0			0.00
APPLSYS.FND_CP_GSM_OPP_AQ(423855)	20	100.00	0.00	0.08	0.00	0.00
APPLSYS.WF_CONTROL(423650)	0			0.00
APPLSYS.WF_DEFERRED(423674)	0			0.00
APPLSYS.WF_JAVA_DEFERRED(423754)	0			0.00
APPLSYS.WF_NOTIFICATION_OUT(423750)	0			0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Avg Enqueue sec / msg
APPLSYS.FND_CP_GSM_IPC_AQ(425717)	0.00
APPLSYS.FND_CP_GSM_OPP_AQ(423855)	0.02	0.00
APPLSYS.WF_CONTROL(423650)	0.00
APPLSYS.WF_DEFERRED(423674)	0.00
APPLSYS.WF_JAVA_DEFERRED(423754)	0.00
APPLSYS.WF_NOTIFICATION_OUT(423750)	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
FNDCPGSMIPC_CARTRIDGE_1597115(228)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_CARTRIDGE_1597116(230)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_CARTRIDGE_1597117(232)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_CARTRIDGE_1597118(234)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_CARTRIDGE_1597119(236)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_CARTRIDGE_1597120(238)/APPLSYS.FND_CP_GSM_IPC_AQ
FNDCPGSMIPC_SERVICE_1597111(221)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597112(223)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597113(225)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597114(227)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597115(229)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597116(231)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597117(233)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597118(235)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597119(237)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597120(239)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597121(241)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597122(243)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
FNDCPGSMIPC_SERVICE_1597123(245)/APPLSYS.FND_CP_GSM_IPC_AQ	0.00	0.00	0.00
WFBESCL_21135(17394)/APPLSYS.WF_CONTROL	0.00	0.00	0.00
WFBESCL_21136(17392)/APPLSYS.WF_CONTROL	0.00	0.00	0.00
WFBESCL_21137(17393)/APPLSYS.WF_CONTROL	0.00	0.00	0.00
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED	0.00	0.00	0.00
WF_JAVA_DEFERRED(1)/APPLSYS.WF_JAVA_DEFERRED
WF_NOTIFICATION_OUT(1)/APPLSYS.WF_NOTIFICATION_OUT	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_ash_size	536870912
_b_tree_bitmap_plans	FALSE
_disk_sector_size_override	TRUE
_fast_full_scan_enabled	FALSE
_like_with_bind_as_equality	TRUE
_optimizer_autostats_job	FALSE
_sort_elimination_cost_ratio	5
_system_trig_enabled	TRUE
_trace_files_public	FALSE
aq_tm_processes	1
audit_sys_operations	FALSE
compatible	11.2.0
control_files	/ebizdata/data/cntrl01.dbf, /ebizdata/data/cntrl02.dbf, /ebizdata/data/cntrl03.dbf
cursor_sharing	EXACT
db_block_checking	FALSE
db_block_checksum	TRUE
db_block_size	8192
db_cache_size	50600083456
db_files	512
db_name	VIS
diagnostic_dest	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/admin/VIS_payrollz
dml_locks	10000
filesystemio_options	setall
ifile	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/VIS_payrollz_ifile.ora
job_queue_processes	2
local_listener	VIS_LOCAL
log_archive_dest_1	LOCATION=/ebizdata/data/archive
log_archive_format	%t_%s_%r.dbf
log_buffer	268369920
log_checkpoint_interval	0
log_checkpoint_timeout	0
log_checkpoints_to_alert	TRUE
max_dump_file_size	20480
nls_comp	binary
nls_date_format	DD-MON-RR
nls_length_semantics	BYTE
nls_numeric_characters	.,
nls_sort	binary
nls_territory	america
olap_page_pool_size	4194304
open_cursors	6000
optimizer_secure_view_merging	FALSE
os_authent_prefix
parallel_max_servers	256
parallel_min_servers	0
pga_aggregate_target	17179869184
plsql_code_type	INTERPRETED
plsql_optimize_level	2
processes	6000
sec_case_sensitive_logon	FALSE
session_cached_cursors	5000
sessions	9216
shared_pool_reserved_size	2147483648
shared_pool_size	8589934592
sql92_security	FALSE
statistics_level	basic
timed_statistics	FALSE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
utl_file_dir	/usr/tmp, /usr/tmp, /export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_payrollz, /usr/tmp
workarea_size_policy	AUTO

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/ebizdata/data/cntrl01.dbf
control_files	/ebizdata/data/cntrl02.dbf
control_files	/ebizdata/data/cntrl03.dbf
utl_file_dir	/export/home/oracle/app/oracle/product/11.2.0/dbhome_1/appsutil/outbound/VIS_payrollz
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp
utl_file_dir	/usr/tmp

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	101.17	Soft Parse %:	99.22
Execute to Parse %:	99.95	Latch Hit %:	94.38
Parse CPU to Parse Elapsd %:		% Non-Parse CPU:	100.00