oracle AWR报告原文件

最新推荐文章于 2021-04-09 01:03:07 发布

常语

最新推荐文章于 2021-04-09 01:03:07 发布

阅读量4.8k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/u011631923/article/details/17163669

这是一份Oracle数据库的工作负载存储库报告，详细分析了数据库的性能指标。报告涵盖了等待事件统计、SQL统计、实例活动统计、IO统计、缓冲池统计、建议统计、等待统计、回滚统计、锁统计、段统计、字典缓存统计、库缓存统计、内存统计、流统计、资源限制统计和共享服务器统计等多个方面，全面揭示了数据库的运行状况和性能瓶颈。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MYPL	569030708	mypl	1	03-Dec-13 20:12	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
orale	Linux IA (32-bit)	1			1.39

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	64	03-Dec-13 20:24:57	23	1.4
End Snap:	66	03-Dec-13 22:00:49	27	1.7
Elapsed:		95.87 (mins)
DB Time:		2.92 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	196M	196M	Std Block Size:	8K
Shared Pool Size:	68M	68M	Log Buffer:	5,504K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.0	0.3	0.00	0.18
DB CPU(s):	0.0	0.1	0.00	0.07
Redo size:	1,746.6	15,697.9
Logical reads:	112.2	1,008.5
Block changes:	10.1	90.7
Physical reads:	0.7	6.2
Physical writes:	0.3	2.7
User calls:	0.2	1.5
Parses:	5.6	50.5
Hard parses:	0.8	7.4
W/A MB processed:	0.0	0.2
Logons:	0.1	0.5
Executes:	21.5	192.9
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.38	In-memory Sort %:	100.00
Library Hit %:	90.15	Soft Parse %:	85.35
Execute to Parse %:	73.83	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	62.69	% Non-Parse CPU:	83.68

Shared Pool Statistics

	Begin	End
Memory Usage %:	92.36	93.29
% SQL with executions>1:	78.84	82.63
% Memory for SQL w/exec>1:	78.04	87.68

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		67		38.47
db file sequential read	1,997	37	19	21.36	User I/O
resmgr:cpu quantum	80	7	88	4.04	Scheduler
db file scattered read	194	5	24	2.66	User I/O
library cache: mutex X	2	2	934	1.07	Concurrency

Host CPU (CPUs: 1 Cores: Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.17	1.27	0.7	1.1	1.3	96.7

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	1,419.6	1,419.6
SGA use (MB):	598.7	598.7
PGA use (MB):	45.7	61.1
% Host Mem used for SGA+PGA:	45.39	46.47

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

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	176.32	100.74
parse time elapsed	78.54	44.87
hard parse elapsed time	74.94	42.82
DB CPU	67.32	38.47
PL/SQL execution elapsed time	17.87	10.21
hard parse (sharing criteria) elapsed time	5.32	3.04
PL/SQL compilation elapsed time	2.22	1.27
hard parse (bind mismatch) elapsed time	2.14	1.22
repeated bind elapsed time	0.49	0.28
sequence load elapsed time	0.18	0.10
connection management call elapsed time	0.15	0.08
failed parse elapsed time	0.08	0.05
DB time	175.02
background elapsed time	75.94
background cpu time	16.58

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
BUSY_TIME	18,374
IDLE_TIME	532,106
IOWAIT_TIME	7,208
NICE_TIME	120
SYS_TIME	5,992
USER_TIME	3,640
LOAD	0	1
RSRC_MGR_CPU_WAIT_TIME	702
PHYSICAL_MEMORY_BYTES	1,488,609,280
NUM_CPUS	1
GLOBAL_RECEIVE_SIZE_MAX	131,071
GLOBAL_SEND_SIZE_MAX	131,071
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
03-Dec 20:24:57	0.17
03-Dec 21:00:16	0.00	2.82	0.29	0.96	97.18	0.28
03-Dec 22:00:49	1.27	3.64	0.88	1.17	96.36	1.91

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 69.5% of Total DB time 175.02 (s)
Total FG Wait Time: 54.29 (s) DB CPU time: 67.32 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			67		38.47
User I/O	2,369	0	43	18	24.46
Scheduler	80	0	7	88	4.04
Concurrency	12	0	2	184	1.26
Commit	77	0	1	19	0.82
System I/O	1,812	0	0	0	0.20
Other	184	97	0	1	0.12
Administrative	1	100	0	180	0.10
Application	2	0	0	0	0.00
Network	31	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	1,997	0	37	19	3.12	21.36
resmgr:cpu quantum	80	0	7	88	0.13	4.04
db file scattered read	194	0	5	24	0.30	2.66
library cache: mutex X	2	0	2	934	0.00	1.07
log file sync	77	0	1	19	0.12	0.82
read by other session	2	0	0	206	0.00	0.24
control file sequential read	1,812	0	0	0	2.83	0.20
ADR block file read	4	0	0	54	0.01	0.12
library cache load lock	1	0	0	186	0.00	0.11
JS kgl get object wait	1	100	0	180	0.00	0.10
direct path write temp	15	0	0	10	0.02	0.09
direct path sync	2	0	0	72	0.00	0.08
latch: cache buffers chains	1	0	0	64	0.00	0.04
cursor: pin S wait on X	2	0	0	27	0.00	0.03
latch: shared pool	5	0	0	6	0.01	0.02
utl_file I/O	5	0	0	5	0.01	0.01
Disk file operations I/O	154	0	0	0	0.24	0.01
asynch descriptor resize	178	100	0	0	0.28	0.00
jobq slave wait	11,272	100	5,893	523	17.61
SQL*Net message from client	30	0	5,520	183990	0.05
PL/SQL lock timer	1	100	2	1684	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
os thread startup	209	0	19	89	0.33	24.43
log file parallel write	2,954	0	14	5	4.62	18.00
db file sequential read	906	0	9	10	1.42	12.12
control file parallel write	1,899	0	5	3	2.97	6.85
db file async I/O submit	1,083	0	3	3	1.69	3.79
control file sequential read	5,412	0	0	0	8.46	0.34
db file scattered read	7	0	0	28	0.01	0.25
ADR block file read	12	0	0	15	0.02	0.23
library cache load lock	2	0	0	70	0.00	0.18
rdbms ipc reply	1	0	0	117	0.00	0.15
latch: shared pool	4	0	0	11	0.01	0.06
ADR block file write	5	0	0	6	0.01	0.04
direct path sync	1	0	0	25	0.00	0.03
asynch descriptor resize	230	100	0	0	0.36	0.02
latch free	188	0	0	0	0.29	0.01
Disk file operations I/O	53	0	0	0	0.08	0.01
enq: JS - queue lock	1	0	0	3	0.00	0.00
LGWR wait for redo copy	8	0	0	0	0.01	0.00
rdbms ipc message	24,737	94	68,829	2782	38.65
DIAG idle wait	11,024	100	11,499	1043	17.23
pmon timer	1,980	93	5,747	2903	3.09
Space Manager: slave idle wait	1,107	99	5,746	5191	1.73
Streams AQ: qmn slave idle wait	209	0	5,745	27488	0.33
Streams AQ: qmn coordinator idle wait	236	86	5,745	24343	0.37
smon timer	19	100	5,704	300186	0.03
Streams AQ: waiting for time management or cleanup tasks	5	60	2,735	547083	0.01
class slave wait	20	0	0	2	0.03
SQL*Net message from client	5	0	0	3	0.01

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	16	31.3				18.8	18.8	31.3
ADR block file write	5	60.0				20.0	20.0
ADR file lock	6	100.0
Disk file operations I/O	207	99.5	.5
JS kgl get object wait	1							100.0
LGWR wait for redo copy	8	100.0
SQL*Net break/reset to client	2	100.0
SQL*Net message to client	34	100.0
SQL*Net more data to client	1	100.0
asynch descriptor resize	408	99.3	.7
control file parallel write	1899	83.0	6.6	1.9	2.2	2.1	2.4	1.8
control file sequential read	7224	99.7	.1		.0	.1	.0	.0
cursor: pin S wait on X	2					50.0		50.0
db file async I/O submit	1083	77.3	10.1	2.6	2.7	3.4	2.4	1.6
db file scattered read	204	22.1	3.9	2.0	2.5	15.2	26.0	28.4
db file sequential read	2741	41.9	7.8	2.0	5.0	16.6	14.6	12.0	.0
direct path sync	3				33.3		33.3	33.3
direct path write temp	16	37.5	25.0	12.5			12.5	12.5
enq: JS - queue lock	1			100.0
latch free	188	100.0
latch: cache buffers chains	1							100.0
latch: cache buffers lru chain	2	100.0
latch: redo allocation	10	100.0
latch: shared pool	10	30.0	20.0	10.0	10.0	20.0		10.0
library cache load lock	3							100.0
library cache: mutex X	2							100.0
log file parallel write	2996	80.9	5.0	1.5	1.6	2.5	4.0	4.5
log file sync	79	31.6	5.1	3.8	8.9	13.9	12.7	24.1
os thread startup	209	2.4				.5	2.4	94.3	.5
rdbms ipc reply	1							100.0
read by other session	2							100.0
reliable message	1	100.0
resmgr:cpu quantum	93	11.8	3.2	2.2	3.2	11.8	11.8	55.9
row cache lock	1	100.0
utl_file I/O	5	80.0					20.0
DIAG idle wait	11K							82.2	17.8
PL/SQL lock timer	1								100.0
SQL*Net message from client	35	31.4	11.4			2.9			54.3
Space Manager: slave idle wait	1108	.1							99.9
Streams AQ: qmn coordinator idle wait	236	13.1						.4	86.4
Streams AQ: qmn slave idle wait	209	2.4							97.6
Streams AQ: waiting for time management or cleanup tasks	5	40.0						20.0	40.0
class slave wait	20	90.0		5.0			5.0
jobq slave wait	11.3K							99.9	.1
pmon timer	1982	6.9	.2					.1	92.9
rdbms ipc message	24.8K	2.3	.2	.3	.3	.3	.4	20.6	75.7
smon timer	19								100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	5	68.8	25.0	6.3
JS kgl get object wait	1				100.0
control file parallel write	34	98.2	1.3	.4		.1
control file sequential read	3	100.0	.0	.0
cursor: pin S wait on X	1	50.0	50.0
db file async I/O submit	17	98.4	1.3	.2	.1
db file scattered read	58	71.6	22.1	5.4	1.0
db file sequential read	330	88.0	6.9	3.2	1.4	.5	.0	.0
direct path sync	1	66.7			33.3
direct path write temp	2	87.5	12.5
latch: cache buffers chains	1		100.0
latch: shared pool	1	90.0	10.0
library cache load lock	3		33.3	33.3	33.3
library cache: mutex X	2						100.0
log file parallel write	136	95.5	2.9	1.1	.5	.1
log file sync	19	75.9	21.5	2.5
os thread startup	197	5.3	46.4	43.1	3.8	.5	.5		.5
rdbms ipc reply	1			100.0
read by other session	2				100.0
resmgr:cpu quantum	52	44.1	19.4	16.1	15.1	5.4

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
os thread startup	1	99.5	.5

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	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	172	66	3	517
SYS$BACKGROUND	0	0	1	102
mypl	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	2368	43	12	2	0	0	31	0
SYS$BACKGROUND	992	9	213	19	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by 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 29.1% of Total DB Time (s): 175
Captured PL/SQL account for 32.0% of Total DB Time (s): 175

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
47.58	0		27.18	43.60	40.56	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
8.40	35	0.24	4.80	81.92	1.54	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
7.34	850	0.01	4.19	8.21	93.78	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
5.49	330	0.02	3.14	82.09	0.00	62yyzw3309d6a	DBMS_SCHEDULER	SELECT VALUE FROM V$SESSION_FI...
4.94	1,958	0.00	2.82	38.29	0.23	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
4.32	8,580	0.00	2.47	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
4.13	1,212	0.00	2.36	8.91	82.13	3ktacv9r56b51		select owner#, name, namespace...
3.63	49	0.07	2.07	78.76	3.77	c0j6cx9kzjf7g	DBMS_SCHEDULER	SELECT EXTRACTVALUE(VALUE(T), ...
3.47	847	0.00	1.98	4.55	91.94	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
2.69	850	0.00	1.54	7.59	85.46	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
2.68	146	0.02	1.53	6.18	93.50	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
1.76	847	0.00	1.01	6.76	91.90	c6awqs517jpj0		select /*+ index(idl_char$ i_i...

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 26.4% of Total CPU Time (s): 67
Captured PL/SQL account for 41.0% of Total CPU Time (s): 67

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
20.74	0		30.81	47.58	43.60	40.56	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
6.88	35	0.20	10.22	8.40	81.92	1.54	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
4.51	330	0.01	6.69	5.49	82.09	0.00	62yyzw3309d6a	DBMS_SCHEDULER	SELECT VALUE FROM V$SESSION_FI...
2.86	49	0.06	4.25	3.63	78.76	3.77	c0j6cx9kzjf7g	DBMS_SCHEDULER	SELECT EXTRACTVALUE(VALUE(T), ...
1.89	1,958	0.00	2.81	4.94	38.29	0.23	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1.03	8,580	0.00	1.53	4.32	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
0.80	1,101	0.00	1.19	1.13	70.97	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
0.60	850	0.00	0.90	7.34	8.21	93.78	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
0.57	16,293	0.00	0.85	1.23	46.62	33.34	96g93hntrzjtr		select /+ rule / bucket_cnt,...
0.42	2,099	0.00	0.63	0.69	61.00	0.08	83taa7kaw59c1		select name, intcol#, segcol#,...

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 47.0% of Total User I/O Wait Time (s): 52
Captured PL/SQL account for 37.2% of Total User I/O Wait Time (s): 52

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
19.30	0		36.99	47.58	43.60	40.56	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
6.88	850	0.01	13.20	7.34	8.21	93.78	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
3.39	1,212	0.00	6.50	4.13	8.91	82.13	3ktacv9r56b51		select owner#, name, namespace...
3.19	847	0.00	6.11	3.47	4.55	91.94	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
2.95	8,580	0.00	5.65	4.32	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
2.51	146	0.02	4.81	2.68	6.18	93.50	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
2.30	850	0.00	4.40	2.69	7.59	85.46	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
1.62	847	0.00	3.10	1.76	6.76	91.90	c6awqs517jpj0		select /*+ index(idl_char$ i_i...
0.59	1,212	0.00	1.14	0.97	23.89	61.26	8swypbbr0m372		select order#, columns, types ...
0.41	16,293	0.00	0.79	1.23	46.62	33.34	96g93hntrzjtr		select /+ rule / bucket_cnt,...

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: 645,458
Captured SQL account for 54.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
236,843	0		36.69	47.58	43.60	40.56	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
102,781	35	2,936.60	15.92	8.40	81.92	1.54	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
46,925	16,293	2.88	7.27	1.23	46.62	33.34	96g93hntrzjtr		select /+ rule / bucket_cnt,...
26,857	8,580	3.13	4.16	4.32	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
26,429	1,212	21.81	4.09	0.97	23.89	61.26	8swypbbr0m372		select order#, columns, types ...
25,512	1,212	21.05	3.95	4.13	8.91	82.13	3ktacv9r56b51		select owner#, name, namespace...
25,164	5,726	4.39	3.90	0.27	77.92	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
19,298	3,309	5.83	2.99	0.69	21.63	0.00	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
19,029	1,439	13.22	2.95	0.32	36.12	61.72	6qg99cfg26kwb	DBMS_SCHEDULER	SELECT COUNT(UNQ) UNQ, COUNT(P...
15,575	5,159	3.02	2.41	0.52	57.91	0.00	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
14,238	1,958	7.27	2.21	4.94	38.29	0.23	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
14,027	1,267	11.07	2.17	0.25	52.04	37.06	gx4mv66pvj3xz		select con#, type#, condlength...
14,024	1,101	12.74	2.17	1.13	70.97	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
10,753	2,099	5.12	1.67	0.69	61.00	0.08	83taa7kaw59c1		select name, intcol#, segcol#,...
10,051	850	11.82	1.56	7.34	8.21	93.78	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
7,202	1,660	4.34	1.12	0.23	88.97	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
6,568	2,164	3.04	1.02	0.53	31.31	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
6,545	2,186	2.99	1.01	0.10	85.82	0.00	87gaftwrm2h68		select o.owner#, o.name, o.nam...

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: 3,990
Captured SQL account for 33.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,737	0		43.53	47.58	43.60	40.56	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
692	850	0.81	17.34	7.34	8.21	93.78	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
267	35	7.63	6.69	8.40	81.92	1.54	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
174	8,580	0.02	4.36	4.32	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
100	847	0.12	2.51	3.47	4.55	91.94	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
100	146	0.68	2.51	2.68	6.18	93.50	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
58	850	0.07	1.45	2.69	7.59	85.46	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
57	1,212	0.05	1.43	4.13	8.91	82.13	3ktacv9r56b51		select owner#, name, namespace...
46	1,212	0.04	1.15	0.97	23.89	61.26	8swypbbr0m372		select order#, columns, types ...
32	847	0.04	0.80	1.76	6.76	91.90	c6awqs517jpj0		select /*+ index(idl_char$ i_i...

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: 3,005
Captured SQL account for 44.7% of Total
Total UnOptimized Read Requests: 3,005
Captured SQL account for 44.7% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
1,127	1,127	0		37.50	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
692	692	850	0.81	23.03	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
197	197	35	5.63	6.56	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
174	174	8,580	0.02	5.79	db78fxqxwxt7r		select /+ rule / bucket, end...
100	100	847	0.12	3.33	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
100	100	146	0.68	3.33	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
58	58	850	0.07	1.93	ga9j9xk5cy9s0		select /*+ index(idl_sb4$ i_id...
57	57	1,212	0.05	1.90	3ktacv9r56b51		select owner#, name, namespace...
46	46	1,212	0.04	1.53	8swypbbr0m372		select order#, columns, types ...
31	31	847	0.04	1.03	c6awqs517jpj0		select /*+ index(idl_char$ i_i...

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: 123,458
Captured SQL account for 54.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
16,293	13,747	0.84	1.23	46.62	33.34	96g93hntrzjtr		select /+ rule / bucket_cnt,...
8,580	131,920	15.38	4.32	23.75	68.17	db78fxqxwxt7r		select /+ rule / bucket, end...
5,726	6,845	1.20	0.27	77.92	0.00	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
5,159	5,056	0.98	0.52	57.91	0.00	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
3,309	6,322	1.91	0.69	21.63	0.00	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
2,186	2,173	0.99	0.10	85.82	0.00	87gaftwrm2h68		select o.owner#, o.name, o.nam...
2,164	2,162	1.00	0.53	31.31	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
2,099	29,592	14.10	0.69	61.00	0.08	83taa7kaw59c1		select name, intcol#, segcol#,...
1,958	3,309	1.69	4.94	38.29	0.23	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
1,660	1,660	1.00	0.23	88.97	0.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
1,439	1,439	1.00	0.32	36.12	61.72	6qg99cfg26kwb	DBMS_SCHEDULER	SELECT COUNT(UNQ) UNQ, COUNT(P...
1,267	115	0.09	0.07	70.37	0.00	3w4qs0tbpmxr6		select con#, obj#, rcon#, enab...
1,267	5,730	4.52	0.25	52.04	37.06	gx4mv66pvj3xz		select con#, type#, condlength...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 32,304
Captured SQL account for 42.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
2,164	2,164	6.70	9tgj4g8y4rwy8	select type#, blocks, extents,...
1,212	1,212	3.75	3ktacv9r56b51	select owner#, name, namespace...
1,212	1,212	3.75	8swypbbr0m372	select order#, columns, types ...
850	850	2.63	cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_id...
850	850	2.63	ga9j9xk5cy9s0	select /*+ index(idl_sb4$ i_id...
847	847	2.62	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
847	847	2.62	c6awqs517jpj0	select /*+ index(idl_char$ i_i...
539	539	1.67	asvzxj61dc5vs	select timestamp, flags from f...
270	270	0.84	6qz82dptj0qr7	select l.col#, l.intcol#, l.lo...
198	198	0.61	fsbqktj5vw6n9	select next_run_date, obj#, ru...

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
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
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
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
62yyzw3309d6a	SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID')
63kf3an2j0pkc	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6qg99cfg26kwb	SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /+ first_rows(1) leading(cc) / CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2, 3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /+ first_rows(1) leading(i) / CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY, 1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS, 1025) = 0 AND ROWNUM < 2 )
6qz82dptj0qr7	select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
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#
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#
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
c0j6cx9kzjf7g	SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
c6awqs517jpj0	select /+ index(idl_char$ i_idl_char1) +/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fsbqktj5vw6n9	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
ga9j9xk5cy9s0	select /+ index(idl_sb4$ i_idl_sb41) +/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gx4mv66pvj3xz	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

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	10	0.00	0.02
CCursor + sql area evicted	165	0.03	0.26
CPU used by this session	5,589	0.97	8.73
CPU used when call started	929	0.16	1.45
CR blocks created	121	0.02	0.19
Cached Commit SCN referenced	108	0.02	0.17
Commit SCN cached	9	0.00	0.01
DB time	566,912	98.56	885.80
DBWR checkpoint buffers written	1,587	0.28	2.48
DBWR transaction table writes	145	0.03	0.23
DBWR undo block writes	351	0.06	0.55
HSC Heap Segment Block Changes	12,558	2.18	19.62
Heap Segment Array Inserts	323	0.06	0.50
Heap Segment Array Updates	128	0.02	0.20
IMU CR rollbacks	181	0.03	0.28
IMU Flushes	153	0.03	0.24
IMU Redo allocation size	192,636	33.49	300.99
IMU commits	583	0.10	0.91
IMU ktichg flush	2	0.00	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	1,909,488	331.97	2,983.58
RowCR - row contention	0	0.00	0.00
RowCR attempts	68	0.01	0.11
RowCR hits	70	0.01	0.11
SQL*Net roundtrips to/from client	30	0.01	0.05
active txn count during cleanout	124	0.02	0.19
background timeouts	23,191	4.03	36.24
buffer is not pinned count	468,751	81.49	732.42
buffer is pinned count	93,529	16.26	146.14
bytes received via SQL*Net from client	7,210	1.25	11.27
bytes sent via SQL*Net to client	23,815	4.14	37.21
calls to get snapshot scn: kcmgss	149,572	26.00	233.71
calls to kcmgas	3,432	0.60	5.36
calls to kcmgcs	44,169	7.68	69.01
cell physical IO interconnect bytes	207,586,304	36,089.36	324,353.60
change write time	225	0.04	0.35
cleanout - number of ktugct calls	152	0.03	0.24
cleanouts and rollbacks - consistent read gets	8	0.00	0.01
cleanouts only - consistent read gets	21	0.00	0.03
cluster key scan block gets	49,031	8.52	76.61
cluster key scans	43,702	7.60	68.28
commit cleanout failures: block lost	8	0.00	0.01
commit cleanout failures: callback failure	14	0.00	0.02
commit cleanouts	6,215	1.08	9.71
commit cleanouts successfully completed	6,193	1.08	9.68
commit txn count during cleanout	103	0.02	0.16
concurrency wait time	2,090	0.36	3.27
consistent changes	1,860	0.32	2.91
consistent gets	595,004	103.44	929.69
consistent gets - examination	227,980	39.63	356.22
consistent gets from cache	595,004	103.44	929.69
consistent gets from cache (fastpath)	347,297	60.38	542.65
cursor authentications	971	0.17	1.52
data blocks consistent reads - undo records applied	238	0.04	0.37
db block changes	58,075	10.10	90.74
db block gets	50,454	8.77	78.83
db block gets direct	139	0.02	0.22
db block gets from cache	50,315	8.75	78.62
db block gets from cache (fastpath)	13,007	2.26	20.32
deferred (CURRENT) block cleanout applications	3,499	0.61	5.47
enqueue conversions	1,122	0.20	1.75
enqueue releases	50,252	8.74	78.52
enqueue requests	50,258	8.74	78.53
enqueue timeouts	0	0.00	0.00
enqueue waits	1	0.00	0.00
execute count	123,458	21.46	192.90
file io service time	39,260	6.83	61.34
file io wait time	55,145,645	9,587.20	86,165.07
frame signature mismatch	0	0.00	0.00
free buffer requested	5,778	1.00	9.03
heap block compress	89	0.02	0.14
immediate (CR) block cleanout applications	29	0.01	0.05
immediate (CURRENT) block cleanout applications	1,015	0.18	1.59
index crx upgrade (positioned)	10	0.00	0.02
index fast full scans (full)	123	0.02	0.19
index fetch by key	107,179	18.63	167.47
index scans kdiixs1	81,559	14.18	127.44
leaf node 90-10 splits	33	0.01	0.05
leaf node splits	64	0.01	0.10
lob reads	1,286	0.22	2.01
lob writes	470	0.08	0.73
lob writes unaligned	470	0.08	0.73
logons cumulative	308	0.05	0.48
max cf enq hold time	120	0.02	0.19
messages received	2,697	0.47	4.21
messages sent	2,697	0.47	4.21
min active SCN optimization applied on CR	12	0.00	0.02
no work - consistent read gets	314,967	54.76	492.14
non-idle wait count	17,719	3.08	27.69
non-idle wait time	10,627	1.85	16.60
opened cursors cumulative	115,155	20.02	179.93
parse count (describe)	20	0.00	0.03
parse count (failures)	41	0.01	0.06
parse count (hard)	4,731	0.82	7.39
parse count (total)	32,304	5.62	50.48
parse time cpu	1,099	0.19	1.72
parse time elapsed	1,753	0.30	2.74
physical read IO requests	3,005	0.52	4.70
physical read bytes	32,686,080	5,682.55	51,072.00
physical read total IO requests	10,237	1.78	16.00
physical read total bytes	151,355,392	26,313.49	236,492.80
physical read total multi block requests	3	0.00	0.00
physical reads	3,990	0.69	6.23
physical reads cache	3,990	0.69	6.23
physical reads cache prefetch	985	0.17	1.54
physical write IO requests	1,099	0.19	1.72
physical write bytes	14,139,392	2,458.17	22,092.80
physical write total IO requests	4,497	0.78	7.03
physical write total bytes	56,230,912	9,775.88	87,860.80
physical write total multi block requests	26	0.00	0.04
physical writes	1,726	0.30	2.70
physical writes direct	139	0.02	0.22
physical writes direct temporary tablespace	139	0.02	0.22
physical writes from cache	1,587	0.28	2.48
physical writes non checkpoint	781	0.14	1.22
pinned cursors current	2	0.00	0.00
process last non-idle time	1,386,079,208	240,973.10	2,165,748.76
recursive calls	1,245,483	216.53	1,946.07
recursive cpu usage	2,905	0.51	4.54
redo blocks checksummed by FG (exclusive)	6,441	1.12	10.06
redo blocks written	21,442	3.73	33.50
redo entries	26,067	4.53	40.73
redo size	10,046,628	1,746.63	15,697.86
redo synch time	124	0.02	0.19
redo synch writes	103	0.02	0.16
redo wastage	408,508	71.02	638.29
redo write time	1,421	0.25	2.22
redo writes	1,497	0.26	2.34
rollbacks only - consistent read gets	113	0.02	0.18
rows fetched via callback	34,068	5.92	53.23
scheduler wait time	720	0.13	1.13
session connect time	1,386,079,208	240,973.10	2,165,748.76
session cursor cache hits	132,834	23.09	207.55
session logical reads	645,458	112.21	1,008.53
shared hash latch upgrades - no wait	7,853	1.37	12.27
sorts (memory)	29,032	5.05	45.36
sorts (rows)	505,142	87.82	789.28
sql area evicted	3,430	0.60	5.36
sql area purged	54	0.01	0.08
switch current to new buffer	536	0.09	0.84
table fetch by rowid	160,090	27.83	250.14
table fetch continued row	2,576	0.45	4.03
table scan blocks gotten	39,570	6.88	61.83
table scan rows gotten	1,072,628	186.48	1,675.98
table scans (long tables)	0	0.00	0.00
table scans (short tables)	19,821	3.45	30.97
temp space allocated (bytes)	5,242,880	911.49	8,192.00
total cf enq hold time	230	0.04	0.36
total number of cf enq holders	15	0.00	0.02
total number of times SMON posted	0	0.00	0.00
undo change vector size	3,644,728	633.64	5,694.89
user I/O wait time	5,311	0.92	8.30
user calls	965	0.17	1.51
user commits	640	0.11	1.00
workarea executions - optimal	16,205	2.82	25.32

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 uga memory	42,958,138,736	463,881,404,020
opened cursors current	33	46
logons current	23	27
session uga memory max	39,520,460	4,533,407,028
session pga memory	54,237,012	264,740,492
session pga memory max	79,861,588	362,585,740
session cursor cache count	992	7,522

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

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	113M	1.26	.019645	30M	0.33	.005215	11K	0.74
Buffer Cache Reads	30M	0.51	.005215	0M	0.00	0M	2914	18.06
DBWR	0M	0.00	0M	13M	0.19	.002260	1083	2.05
LGWR	0M	0.00	0M	11M	0.26	.001912	1498	8.92
Direct Writes	0M	0.00	0M	1M	0.00	.000173	16	9.25
Streams AQ	0M	0.00	0M	0M	0.00	0M	1	27.00
TOTAL:	143M	1.76	.024860	55M	0.78	.009561	16.5K	4.63

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Control File	113M	1.26	.019645	30M	0.33	.005215	0.05
Data File	30M	0.50	.005215	12M	0.19	.002086	18.11
Log File	0M	0.00	0M	11M	0.26	.001912
Temp File	1M	0.00	.000173	1M	0.00	.000173	0.00	0.33
TOTAL:	144M	1.76	.025034	54M	0.78	.009388	5.23	0.33

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	113M	1.26	.019645	30M	0.33	.005215	7232	0.05
Others (Control File)	113M	1.26	.019645	30M	0.33	.005215	7224	0.05
Others (Data File)	0M	0.00	0M	0M	0.00	0M	8	0.13
Buffer Cache Reads	30M	0.50	.005215	0M	0.00	0M	2880	18.28
Buffer Cache Reads (Data File)	30M	0.50	.005215	0M	0.00	0M	2880	18.28
DBWR	0M	0.00	0M	13M	0.19	.002260	0
DBWR (Data File)	0M	0.00	0M	13M	0.19	.002260	0
LGWR	0M	0.00	0M	11M	0.26	.001912	0
LGWR (Log File)	0M	0.00	0M	11M	0.26	.001912	0
Direct Writes	0M	0.00	0M	1M	0.00	.000173	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.00	.000173	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	1	27.00
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	1	27.00
TOTAL:	143M	1.76	.024860	55M	0.78	.009561	10.1K	5.25

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	1,402	15.16	1.54	700	0	0.00
SYSTEM	1,735	17.48	1.05	82	2	95.00
UNDOTBS1	0	0.00	0.00	302	0	0.00
TEMP	10	0.00	13.90	16	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/u01/app/oracle/oradata/mypl/sysaux01.dbf	1,402	15.16	1.54	700	0	0.00
SYSTEM	/u01/app/oracle/oradata/mypl/system01.dbf	1,735	17.48	1.05	82	2	95.00
TEMP	/u01/app/oracle/oradata/mypl/temp01.dbf	10	0.00	13.90	16	0
UNDOTBS1	/u01/app/oracle/oradata/mypl/undotbs01.dbf	0			302	0	0.00

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	24,304	99	628,584	4,048	1,587	0	0	2

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 1,726

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	1,587	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	22	184	390	165888	165888
E	0	22	1277	13033	14361	165888	14361

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

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	20	0.10	2	1.81	20	1	270.00
D	40	0.20	5	1.22	13	1	172.00
D	60	0.30	7	1.09	12	1	150.00
D	80	0.40	10	1.00	11	1	136.00
D	100	0.50	12	1.00	11	1	135.00
D	120	0.60	15	1.00	11	1	135.00
D	140	0.70	17	1.00	11	1	135.00
D	160	0.80	20	1.00	11	1	135.00
D	180	0.90	22	1.00	11	1	135.00
D	200	1.00	25	1.00	11	1	135.00
D	220	1.10	27	1.00	11	1	135.00
D	240	1.20	30	1.00	11	1	135.00
D	260	1.30	32	1.00	11	1	135.00
D	280	1.40	35	1.00	11	1	135.00
D	300	1.50	37	1.00	11	1	135.00
D	320	1.60	40	1.00	11	1	135.00
D	340	1.70	42	1.00	11	1	135.00
D	360	1.80	45	1.00	11	1	135.00
D	380	1.90	47	1.00	11	1	135.00
D	400	2.00	50	1.00	11	1	135.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	152	0

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	58	23	45.68	0.00	0.00	0.00	0.00	11,878
E	58	14	61.08	0.00	0.00	0.00	0.00	11,878

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
2K	4K	15,516	15,516
64K	128K	10	10
128K	256K	14	14
256K	512K	26	26
512K	1024K	122	122
1M	2M	4	4
2M	4M	4	4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
15	0.25	186.17	24.31	88.00	5	919,568
29	0.50	186.17	24.31	88.00	5	919,568
44	0.75	186.17	6.16	97.00	2	840,279
58	1.00	186.17	0.00	100.00	0	813,348
70	1.20	186.17	0.00	100.00	0	813,348
81	1.40	186.17	0.00	100.00	0	813,348
93	1.60	186.17	0.00	100.00	0	813,348
104	1.80	186.17	0.00	100.00	0	813,348
116	2.00	186.17	0.00	100.00	0	813,348
174	3.00	186.17	0.00	100.00	0	813,348
232	4.00	186.17	0.00	100.00	0	813,348
348	6.00	186.17	0.00	100.00	0	813,348
464	8.00	186.17	0.00	100.00	0	813,348

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
68	1.00	2	200	1,614	1.00	132	1.00	45
76	1.12	10	898	1,623	1.01	123	0.93	162
84	1.24	18	1,521	1,650	1.02	96	0.73	164
92	1.35	26	2,028	1,664	1.03	82	0.62	165
100	1.47	33	2,521	1,677	1.04	69	0.52	166
108	1.59	41	2,965	1,683	1.04	63	0.48	166
116	1.71	49	3,415	1,689	1.05	57	0.43	166
124	1.82	57	3,911	1,691	1.05	55	0.42	167
132	1.94	65	4,417	1,694	1.05	52	0.39	167
140	2.06	73	4,829	1,695	1.05	51	0.39	167

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

No data exists for this section of the report.

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	2	0	95

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
JS-Job Scheduler (queue lock)	16,675	16,675	0	1	0	0.00

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	0.20	1,666	1,086	3	4755.7/8253.6	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
03-Dec 21:53	11	143	1,086	1	8,254	0/0	0/0/0/0/0/0
03-Dec 21:43	9	152	461	2	7,794	0/0	0/0/0/0/0/0
03-Dec 21:33	10	49	1,052	1	7,212	0/0	0/0/0/0/0/0
03-Dec 21:23	11	180	427	1	6,707	0/0	0/0/0/0/0/0
03-Dec 21:13	6	50	1,006	1	6,057	0/0	0/0/0/0/0/0
03-Dec 21:03	78	446	385	3	5,296	0/0	0/0/0/0/0/0
03-Dec 20:53	11	142	974	2	7,718	0/0	0/0/0/0/0/0
03-Dec 20:43	5	48	348	1	6,502	0/0	0/0/0/0/0/0
03-Dec 20:33	60	456	933	3	4,756	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	22	0.00		0
AQ dequeue txn counter latch	4	0.00		0
AQ disk delete txn counter latch	4	0.00		0
ASM db client latch	3,678	0.00		0
ASM map operation hash table	2	0.00		0
ASM network state latch	94	0.00		0
AWR Alerted Metric Element list	38,155	0.00		0
Change Notification Hash table latch	1,854	0.00		0
Consistent RBA	1,482	0.00		0
DML lock allocation	8,060	0.00		0
Event Group Locks	212	0.00		0
FOB s.o list latch	403	0.00		0
File State Object Pool Parent Latch	2	0.00		0
IPC stats buffer allocation latch	2	0.00		0
In memory undo latch	8,846	0.00		1,882	0.00
JS Sh mem access	16	31.25	1.00	0
JS broadcast autostart latch	4	0.00		0
JS mem alloc latch	18	0.00		0
JS queue access latch	20	0.00		0
JS queue state obj latch	33,350	0.00		0
JS slv state obj latch	1,609	0.00		0
KFC FX Hash Latch	2	0.00		0
KFC Hash Latch	2	0.00		0
KFCL LE Freelist	2	0.00		0
KGNFS-NFS:SHM structure	2	0.00		0
KGNFS-NFS:SVR LIST	2	0.00		0
KJC message pool free list	2	0.00		0
KJCT flow control latch	2	0.00		0
KMG MMAN ready and startup request latch	1,840	0.00		0
KTF sga latch	30	0.00		1,745	0.00
KWQMN job cache list latch	14	0.00		0
KWQS pqsubs latch	2	0.00		0
KWQS pqueue ctx latch	95	0.00		0
Locator state objects pool parent latch	2	0.00		0
Lsod array latch	2	0.00		0
MQL Tracking Latch	0			109	0.00
Memory Management Latch	2	0.00		1,840	0.00
Memory Queue	2	0.00		0
Memory Queue Message Subscriber #1	2	0.00		0
Memory Queue Message Subscriber #2	2	0.00		0
Memory Queue Message Subscriber #3	2	0.00		0
Memory Queue Message Subscriber #4	2	0.00		0
Memory Queue Subscriber	2	0.00		0
MinActiveScn Latch	31	0.00		0
Mutex	2	0.00		0
Mutex Stats	2	0.00		0
NLS data objects	4	0.00		0
OS process	1,884	0.00		0
OS process allocation	3,089	0.00		0
OS process: request allocation	416	0.00		0
PL/SQL warning settings	418	0.00		0
PX hash array latch	2	0.00		0
QMT	2	0.00		0
Real-time plan statistics latch	94	0.00		0
SGA blob parent	2	0.00		0
SGA bucket locks	2	0.00		0
SGA heap locks	2	0.00		0
SGA pool locks	2	0.00		0
SQL memory manager latch	617	0.00		1,839	0.00
SQL memory manager workarea list latch	169,490	0.00		0
Shared B-Tree	491	0.00		0
Streams Generic	2	0.00		0
Testing	2	0.00		0
Token Manager	2	0.00		0
WCR: sync	2	0.00		0
Write State Object Pool Parent Latch	2	0.00		0
X$KSFQP	2	0.00		0
XDB NFS Security Latch	2	0.00		0
XDB unused session pool	2	0.00		0
XDB used session pool	2	0.00		0
active checkpoint queue latch	2,923	0.00		0
active service list	11,185	0.00		2,792	0.00
buffer pool	2	0.00		0
business card	2	0.00		0
cache buffer handles	4,328	0.00		0
cache buffers chains	1,154,087	0.00	1.00	16,149	0.00
cache buffers lru chain	8,448	0.02	1.00	11,768	0.00
cache table scan latch	202	0.00		202	0.00
call allocation	8,505	0.00		0
cas latch	2	0.00		0
change notification client cache latch	2	0.00		0
channel handle pool latch	449	0.00		0
channel operations parent latch	30,607	0.00		0
checkpoint queue latch	40,810	0.00		2,276	0.00
client/application info	2,441	0.00		0
compile environment latch	307	0.00		0
cp cmon/server latch	2	0.00		0
cp pool latch	2	0.00		0
cp server hash latch	2	0.00		0
cp sga latch	94	0.00		0
cvmap freelist lock	2	0.00		0
database property service latch	8	0.00		0
deferred cleanup latch	94	0.00		0
dml lock allocation	94	0.00		0
done queue latch	2	0.00		0
dummy allocation	612	0.00		0
enqueue hash chains	100,906	0.00		0
enqueues	86,474	0.00		0
fifth spare latch	2	0.00		0
file cache latch	171	0.00		0
flashback copy	2	0.00		0
gc element	2	0.00		0
gcs commit scn state	2	0.00		0
gcs partitioned table hash	2	0.00		0
gcs pcm hashed value bucket hash	2	0.00		0
gcs resource freelist	2	0.00		0
gcs resource hash	2	0.00		0
gcs resource scan list	2	0.00		0
gcs shadows freelist	2	0.00		0
ges domain table	2	0.00		0
ges enqueue table freelist	2	0.00		0
ges group table	2	0.00		0
ges process hash list	2	0.00		0
ges process parent latch	2	0.00		0
ges resource hash list	2	0.00		0
ges resource scan list	2	0.00		0
ges resource table freelist	2	0.00		0
ges value block free list	2	0.00		0
global ctx hash table latch	2	0.00		0
global tx hash mapping	2	0.00		0
granule operation	2	0.00		0
hash table column usage latch	1,492	0.00		369,989	0.00
hash table modification latch	163	0.00		0
heartbeat check	2	0.00		0
internal temp table object number allocation latch	16	0.00		0
intra txn parallel recovery	2	0.00		0
io pool granule metadata list	2	0.00		0
job workq parent latch	100	0.00		98	0.00
job_queue_processes free list latch	209	0.00		0
job_queue_processes parameter latch	1,295	0.00		0
k2q lock allocation	2	0.00		0
kdlx hb parent latch	2	0.00		0
kgb parent	2	0.00		0
kks stats	17,741	0.00		0
kokc descriptor allocation latch	1,695	0.00		0
ksfv messages	2	0.00		0
kss move lock	42	0.00		0
ksuosstats global area	374	0.00		0
ksv allocation latch	174	0.00		0
ksv class latch	82	0.00		0
ksv msg queue latch	2	0.00		0
ksz_so allocation latch	416	0.00		0
ktm global data	31	0.00		0
kwqbsn:qsga	204	0.00		0
lgwr LWN SCN	3,064	0.00		0
list of block allocation	278	0.00		0
loader state object freelist	28	0.00		0
lob segment dispenser latch	2	0.00		0
lob segment hash table latch	22	0.00		0
lob segment query latch	2	0.00		0
lock DBA buffer during media recovery	2	0.00		0
logical standby cache	2	0.00		0
logminer context allocation	2	0.00		0
logminer work area	2	0.00		0
longop free list parent	45	0.00		44	0.00
mapped buffers lru chain	2	0.00		0
message pool operations parent latch	23	0.00		0
messages	53,622	0.00		0
mostly latch-free SCN	3,064	0.00		0
msg queue latch	2	0.00		0
multiblock read objects	482	0.00		0
name-service namespace bucket	2	0.00		0
ncodef allocation latch	94	0.00		0
object queue header heap	3,249	0.00		15	0.00
object queue header operation	15,382	0.00		0
object stats modification	1,344	0.00		0
parallel query alloc buffer	730	0.00		0
parallel query stats	2	0.00		0
parameter list	141	0.00		0
parameter table management	614	0.00		0
peshm	2	0.00		0
pesom_free_list	2	0.00		0
pesom_hash_node	2	0.00		0
post/wait queue	173	0.00		87	0.00
process allocation	625	0.00		210	0.00
process group creation	416	0.00		0
process queue	2	0.00		0
process queue reference	2	0.00		0
qmn task queue latch	836	21.17	1.00	0
query server freelists	2	0.00		0
queued dump request	18	0.00		0
queuing load statistics	2	0.00		0
recovery domain hash list	2	0.00		0
redo allocation	8,265	0.12	1.00	25,860	0.00
redo copy	3	0.00		25,859	0.07
redo writing	11,233	0.00		0
resmgr group change latch	597	0.00		0
resmgr:active threads	632	0.00		1	0.00
resmgr:actses change group	131	0.00		0
resmgr:actses change state	6	0.00		0
resmgr:free threads list	612	0.00		0
resmgr:method mem alloc latch	16	0.00		0
resmgr:plan CPU method	52	0.00		0
resmgr:resource group CPU method	1,548	0.00		0
resmgr:schema config	14	0.00		0
resmgr:session queuing	22	0.00		0
rm cas latch	2	0.00		0
row cache objects	804,547	0.00		10,984	0.01
second spare latch	2	0.00		0
sequence cache	454	0.00		0
session allocation	2,294	0.00		0
session idle bit	2,189	0.00		0
session queue latch	2	0.00		0
session state list latch	645	0.00		0
session switching	1,126	0.00		0
session timer	1,982	0.00		0
shared pool	391,790	0.00	1.00	0
shared pool sim alloc	75	0.00		0
shared pool simulator	57,296	0.00		0
sim partition latch	2	0.00		0
simulator hash latch	41,825	0.00		0
simulator lru latch	716	0.00		40,509	0.02
sort extent pool	234	0.00		0
space background state object latch	4	0.00		0
space background task latch	4,086	0.15	1.00	3,680	0.00
state object free list	4	0.00		0
statistics aggregation	672	0.00		0
tablespace key chain	2	0.00		0
temp lob duration state obj allocation	7	0.00		0
temporary table state object allocation	7	0.00		0
test excl. parent l0	2	0.00		0
test excl. parent2 l0	2	0.00		0
third spare latch	2	0.00		0
threshold alerts latch	182	0.00		0
trace latch	5	0.00		0
transaction allocation	1,154	0.00		0
undo global data	9,520	0.00		0
virtual circuit buffers	2	0.00		0
virtual circuit holder	2	0.00		0
virtual circuit queues	2	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps
qmn task queue latch	836	177	177
redo allocation	8,265	10	10
shared pool	391,790	10	10
space background task latch	4,086	6	6
JS Sh mem access	16	5	5
cache buffers lru chain	8,448	2	2
cache buffers chains	1,154,087	1	1

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
JS Sh mem access	jsksGetShMemLatch	5	5
PC and Classifier lists for WLM	No latch	6	0
cache buffers chains	kcbgcur_2	1	0
cache buffers lru chain	kcbzgws_1	2	2
qmn task queue latch	kwqmnmvtsks: delay to ready list	172	0
qmn task queue latch	kwqmnaddtsk: add task	5	0
redo allocation	kcrfw_redo_gen: redo allocation 1	10	0
shared pool	kghalo	6	5
shared pool	kgh_heap_sizes	1	0
shared pool	kghalp	1	4
shared pool	kghasp	1	0
shared pool	kghupr1	1	2

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn1 62	2	916
Cursor Pin	kkslce [KKSCHLPIN2]	2	44

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

Total Logical Reads: 645,458
Captured Segments account for 74.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	OPTSTAT_HIST_CONTROL$	TABLE	44,736	6.93
SYS	SYSTEM	TAB$	TABLE	43,888	6.80
SYS	SYSTEM	I_HH_OBJ#_INTCOL#	INDEX	33,200	5.14
SYS	SYSTEM	I_OBJ#	INDEX	21,760	3.37
SYS	SYSTEM	I_OBJ#_INTCOL#	INDEX	20,720	3.21

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,990
Captured Segments account for 31.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	HISTGRM$		TABLE	263	6.59
SYS	SYSTEM	IDL_UB1$		TABLE	110	2.76
SYS	SYSAUX	WRH$_SQLSTAT	WRH$_SQLSTA_569030708_28	TABLE PARTITION	81	2.03
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	67	1.68
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST		INDEX	59	1.48

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 3,005
Captured Segments account for 36.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	HISTGRM$	TABLE	263	8.75
SYS	SYSTEM	IDL_UB1$	TABLE	110	3.66
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	67	2.23
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST	INDEX	59	1.96
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	51	1.70

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 3,005
Captured Segments account for 36.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	HISTGRM$	TABLE	263	8.75
SYS	SYSTEM	IDL_UB1$	TABLE	110	3.66
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	67	2.23
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST	INDEX	59	1.96
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	51	1.70

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

Total Physical Writes: 1,726
Captured Segments account for 26.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	72	4.17
SYS	SYSAUX	SMON_SCN_TIME		TABLE	43	2.49
SYS	SYSTEM	COL_USAGE$		TABLE	31	1.80
SYS	SYSAUX	WRH$_LATCH	WRH$_LATCH_569030708_59	TABLE PARTITION	21	1.22
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_569030708_59	INDEX PARTITION	19	1.10

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 1,099
Captured Segments account for 22.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	48	4.37
SYS	SYSAUX	SMON_SCN_TIME	TABLE	32	2.91
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01	INDEX	12	1.09
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	11	1.00
SYSMAN	SYSAUX	MGMT_SYSTEM_PERFORMANCE_LOG	TABLE	10	0.91

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 139
Captured Segments account for 11.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	16	11.51

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 123
Captured Segments account for 13.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	14	11.38
SYS	SYSTEM	I_HH_OBJ#_INTCOL#		INDEX	1	0.81
SYS	SYSTEM	I_OBJ1		INDEX	1	0.81
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_569030708_59	INDEX PARTITION	1	0.81

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	HISTGRM$		TABLE	5,376	29.12
SYS	SYSTEM	I_H_OBJ#_COL#		INDEX	5,104	27.64
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	1,408	7.63
SYS	SYSTEM	COL_USAGE$		TABLE	1,008	5.46
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_ST		INDEX	832	4.51

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	163	6.13	4	1
dc_constraints	12	41.67	12	0
dc_files	4	100.00	0	0
dc_global_oids	1,813	15.11	0	1
dc_histogram_data	32,818	23.40	451	330
dc_histogram_defs	39,795	38.05	687	479
dc_object_grants	52	23.08	0	0
dc_objects	54,656	9.25	55	308
dc_profiles	103	9.71	0	0
dc_rollback_segments	700	0.00	0	12
dc_segments	11,472	18.24	10	82
dc_sequences	32	96.88	32	0
dc_table_scns	1	100.00	0	0
dc_tablespaces	57,416	0.07	0	2
dc_users	77,744	0.37	0	2
global database name	3,810	0.24	0	1
outstanding_alerts	30	100.00	0	0
sch_lj_objs	16	37.50	0	0
sch_lj_oids	12	66.67	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	7	14.29	7	14.29	0	0
BODY	1,568	14.73	3,301	9.09	63	0
CLUSTER	1,490	2.21	799	4.13	0	0
DBLINK	4	100.00	0		0	0
EDITION	117	13.68	211	15.64	1	0
INDEX	685	18.10	604	30.30	1	0
OBJECT ID	12	100.00	0		0	0
QUEUE	112	1.79	338	2.07	3	0
SCHEMA	6,204	0.11	0		0	0
SQL AREA	25,768	44.72	147,013	6.65	1,871	60
SUBSCRIPTION	10	90.00	10	100.00	1	0
TABLE/PROCEDURE	28,720	9.08	28,221	25.77	2,413	0
TRIGGER	73	9.59	108	14.81	8	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	196.00	196.00	196.00	200.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	60.00	60.00	60.00	60.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	24.00	24.00	24.00	24.00	STA/
large pool	0.00	0.00	0.00	0.00	STA/
shared pool	68.00	68.00	64.00	68.00	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	STA/

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	38.04		1.65	2.35	11	11	23	23
	Freeable	6.75	0.00	0.96	0.73	2		7	7
	SQL	0.82	0.35	0.07	0.06	0	2	12	10
	PL/SQL	0.32	0.27	0.01	0.03	0	0	23	23
E	Other	48.37		1.79	2.52	11	22	27	27
	Freeable	9.88	0.00	1.10	1.65	5		9	9
	PL/SQL	1.20	1.13	0.04	0.17	1	2	27	27
	SQL	0.64	0.26	0.04	0.04	0	11	15	11

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	205,520,896
Fixed Size	1,338,336
Redo Buffers	5,636,096
Variable Size	415,237,152

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	24.00	24.00	0.00
shared	ASH buffers	2.00	2.00	0.00
shared	CCUR	1.35	1.22	-9.74
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	1.23		-100.00
shared	KGLHD	0.92		-100.00
shared	KGLS	1.10	0.97	-11.62
shared	KGLSG	3.52	3.52	0.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KTI-UNDO	1.18	1.18	0.00
shared	PCUR	1.14	0.77	-32.88
shared	PLMCD	1.21	1.94	60.49
shared	SGA - SWRF Metric CHBs	0.81	0.81	0.00
shared	SQLA	1.96	1.74	-11.66
shared	db_block_hash_buckets	0.74	0.74	0.00
shared	dbktb: trace buffer	1.56	1.56	0.00
shared	dbwriter coalesce buffer	2.00	2.00	0.00
shared	event statistics per sess	1.84	1.84	0.00
shared	free memory	5.19	4.56	-12.17
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	1.00	1.00	0.00
shared	ksunfy : SSO free list	1.78	1.78	0.00
shared	message pool freequeue	1.09	1.09	0.00
shared	obj stats allocation chun	2.21	2.21	0.00
shared	private strands	1.21	1.21	0.00
shared	prmtzdini tz region	0.76	0.76	0.00
shared	row cache	3.62	3.62	0.00
	buffer_cache	196.00	196.00	0.00
	fixed_sga	1.28	1.28	0.00
	log_buffer	5.38	5.38	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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

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

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
control_files	/u01/app/oracle/oradata/contro01.ctl
db_cache_size	205520896
db_name	mypl
job_queue_processes	1000
resource_manager_plan		SCHEDULER[0x2FFC]:DEFAULT_MAINTENANCE_PLAN
sga_max_size	629145600