oracle的AWR报告样式供参考学习

oracle的AWR报告样式供参考学习

WORKLOAD REPOSITORY report for(example for learning)

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	14498*****	orcl	1	13-Sep-16 15:09	11.2.0.4.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rhel6712971	Linux x86 64-bit	4	4	2	31.68

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	3874	22-Feb-17 01:00:49	109	5.2
End Snap:	3882	22-Feb-17 09:00:06	108	5.3
Elapsed:		479.29 (mins)
DB Time:		0.32 (mins)

Report Summary

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.01
Redo size (bytes):	2,477.5	23,996.5
Logical read (blocks):	32.4	314.3
Block changes:	16.4	158.9
Physical read (blocks):	0.2	2.4
Physical write (blocks):	0.5	5.2
Read IO requests:	0.2	2.4
Write IO requests:	0.3	2.7
Read IO (MB):	0.0	0.0
Write IO (MB):	0.0	0.0
User calls:	0.2	2.0
Parses (SQL):	2.1	19.8
Hard parses (SQL):	0.0	0.1
SQL Work Area (MB):	0.0	0.1
Logons:	0.1	0.6
Executes (SQL):	3.3	31.8
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.25	In-memory Sort %:	100.00
Library Hit %:	99.36	Soft Parse %:	99.35
Execute to Parse %:	37.59	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	84.70	% Non-Parse CPU:	94.85

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		30.1		159.0
log file sync	738	.5	1	2.7	Commit
db file sequential read	6,818	.1	0	.3	User I/O
direct path sync	1	0	13	.1	User I/O
Disk file operations I/O	208	0	0	.1	User I/O
SQL*Net message to client	384	0	0	.0	Network
control file sequential read	120	0	0	.0	System I/O
latch free	1	0	0	.0	Other
latch: shared pool	11	0	0	.0	Concurrency
direct path write temp	1	0	0	.0	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		30		159.0	0.0
System I/O	79,886	22	0	116.1	0.0
Concurrency	1,144	14	12	74.1	0.0
Commit	756	1	1	2.8	0.0
Other	1,773	0	0	1.2	0.0
User I/O	7,839	0	0	.5	0.0
Configuration	2	0	7	.1	0.0
Application	41	0	0	.0	0.0
Network	1,152	0	0	.0	0.0

Host CPU

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
4	4	2	0.00	0.00	0.2	0.1	0.0	99.7

Instance CPU

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

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	3.4	2.2	1.2
Database Requests:	0.5	0.2	0.3
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	0.2	0.0	0.2
Total (MB):	0.1	0.0	0.0
Database (MB):	0.0	0.0	0.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.0	0.0	0.0
Database (blocks):	0.8	0.2	0.5
Via Buffer Cache (blocks):	0.8	0.2	0.5
Direct (blocks):	0.0	0.0	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	32,440.9	32,440.9
SGA use (MB):	2,048.0	2,048.0
PGA use (MB):	263.7	262.4
% Host Mem used for SGA+PGA:	7.13	7.12

Cache Sizes

	Begin	End
Buffer Cache:	752M	752M	Std Block Size:	8K
Shared Pool Size:	985M	984M	Log Buffer:	16,140K

Shared Pool Statistics

	Begin	End
Memory Usage %:	85.52	85.56
% SQL with executions>1:	94.56	88.22
% Memory for SQL w/exec>1:	93.33	78.58

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

Back to Top

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

Back to Top

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
DB CPU	30.11	158.95
sql execute elapsed time	11.41	60.24
PL/SQL execution elapsed time	3.07	16.20
parse time elapsed	1.31	6.90
connection management call elapsed time	0.86	4.54
hard parse (sharing criteria) elapsed time	0.19	0.98
hard parse elapsed time	0.18	0.97
repeated bind elapsed time	0.00	0.01
sequence load elapsed time	0.00	0.00
DB time	18.95
background elapsed time	340.34
background cpu time	218.14

---

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	32,572
IDLE_TIME	11,431,930
IOWAIT_TIME	2,483
NICE_TIME	229
SYS_TIME	6,473
USER_TIME	25,801
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	34,016,796,672
NUM_CPUS	4
NUM_CPU_CORES	4
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
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
22-Feb 01:00:49	0.00
22-Feb 02:00:51	0.00	0.31	0.25	0.06	99.69	0.02
22-Feb 03:00:53	0.00	0.28	0.22	0.06	99.72	0.02
22-Feb 04:00:55	0.08	0.28	0.22	0.06	99.72	0.02
22-Feb 05:00:57	0.00	0.27	0.22	0.05	99.73	0.02
22-Feb 06:00:59	0.00	0.28	0.22	0.06	99.72	0.02
22-Feb 07:00:02	0.00	0.28	0.22	0.05	99.72	0.02
22-Feb 08:00:04	0.00	0.28	0.22	0.05	99.72	0.02
22-Feb 09:00:06	0.00	0.29	0.23	0.06	99.71	0.03

---

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 162.0% of Total DB time 18.95 (s)
• Total FG Wait Time: .59 (s) DB CPU time: 30.11 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			30		158.95
Commit	738	0	1	1	2.69
User I/O	7,028	0	0	0	0.40
Network	384	0	0	0	0.00
System I/O	120	0	0	0	0.00
Other	1	0	0	0	0.00
Concurrency	11	0	0	0	0.00
Application	0		0		0.00
Configuration	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
log file sync	738	0	1	1	0.25	2.69
db file sequential read	6,818	0	0	0	2.30	0.27
direct path sync	1	0	0	13	0.00	0.07
Disk file operations I/O	208	0	0	0	0.07	0.05
SQL*Net message from client	384	0	115,203	300007	0.13
jobq slave wait	62,178	100	31,138	501	20.94

---

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
control file parallel write	10,283	0	14	1	3.46	4.16
os thread startup	1,119	0	14	13	0.38	4.12
db file async I/O submit	8,100	0	4	0	2.73	1.17
log file parallel write	5,725	0	3	1	1.93	1.02
control file sequential read	55,650	0	0	0	18.74	0.12
ADR block file read	120	0	0	1	0.04	0.04
enq: CR - block range reuse ckpt	41	0	0	1	0.01	0.01
log file switch completion	2	0	0	7	0.00	0.00
rdbms ipc reply	2	0	0	7	0.00	0.00
log file sync	18	0	0	1	0.01	0.00
ADR block file write	40	0	0	0	0.01	0.00
Disk file operations I/O	555	0	0	0	0.19	0.00
library cache: mutex X	8	0	0	1	0.00	0.00
asynch descriptor resize	1,311	100	0	0	0.44	0.00
reliable message	106	0	0	0	0.04	0.00
db file single write	14	0	0	0	0.00	0.00
enq: RO - fast object reuse	41	0	0	0	0.01	0.00
db file sequential read	243	0	0	0	0.08	0.00
LGWR wait for redo copy	90	0	0	0	0.03	0.00
log file single write	4	0	0	0	0.00	0.00
rdbms ipc message	146,003	96	344,883	2362	49.18
DIAG idle wait	57,385	100	57,437	1001	19.33
Streams AQ: waiting for time management or cleanup tasks	2	50	57,096	28548010	0.00
Space Manager: slave idle wait	8,441	99	41,858	4959	2.84
dispatcher timer	480	100	28,804	60008	0.16
Streams AQ: qmn slave idle wait	1,027	0	28,765	28009	0.35
Streams AQ: qmn coordinator idle wait	2,054	50	28,765	14004	0.69
smon timer	128	74	28,755	224646	0.04
pmon timer	9,578	100	28,755	3002	3.23
shared server idle wait	958	100	28,748	30008	0.32
VKRM Idle	1	0	14,400	14399900	0.00
SQL*Net message from client	960	0	0	0	0.32
class slave wait	163	0	0	0	0.05

---

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)

		% of Waits
Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
ADR block file read	120	75.0	4.2	8.3	12.5
ADR block file write	40	100.0
ADR file lock	48	100.0
Disk file operations I/O	764	100.0
LGWR wait for redo copy	90	100.0
SQL*Net message to client	1152	100.0
asynch descriptor resize	1311	100.0
buffer busy waits	4	100.0
control file parallel write	10.3K	11.7	85.6	2.1	.2	.1	.1	.2
control file sequential read	55.8K	100.0
db file async I/O submit	8100	96.3	3.1	.3	.1	.0	.1	.0
db file sequential read	7061	100.0		.0
db file single write	14	100.0
direct path sync	1					100.0
direct path write temp	1	100.0
enq: CR - block range reuse ckpt	41	65.9	31.7		2.4
enq: RO - fast object reuse	41	100.0
latch free	2	100.0
latch: cache buffers chains	1	100.0
latch: call allocation	13	100.0
latch: shared pool	12	100.0
library cache: mutex X	8	87.5				12.5
log file parallel write	5725	95.8	1.7	1.3	.9	.2	.0	.1
log file sequential read	4	100.0
log file single write	4	100.0
log file switch completion	2				100.0
log file sync	756	97.8	.9	.4	.3	.1	.1	.4
os thread startup	1119					97.1	2.9
rdbms ipc reply	2	50.0				50.0
reliable message	106	100.0
DIAG idle wait	57.4K							100.0
SQL*Net message from client	1344	85.4	.2	.1					14.3
Space Manager: slave idle wait	8438	.0		.0	.0	.0		.5	99.5
Streams AQ: qmn coordinator idle wait	2054	50.0							50.0
Streams AQ: qmn slave idle wait	1027								100.0
Streams AQ: waiting for time management or cleanup tasks	2							50.0	50.0
VKRM Idle	1								100.0
class slave wait	163	100.0
dispatcher timer	480								100.0
jobq slave wait	62.2K	.0					.0	100.0
pmon timer	9578								100.0
rdbms ipc message	146K	1.4	.3	.2	.4	.6	.2	40.1	56.6
shared server idle wait	959								100.0
smon timer	128	1.6		1.6	.8	1.6		14.1	80.5

---

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)

		% of Total Waits
Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
control file parallel write	25	99.8	.2	.1	.0
db file async I/O submit	4	100.0	.0	.0	.0
log file parallel write	4	99.9	.1
log file sync	3	99.6	.4

---

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	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	19	30	7	385
SYS$BACKGROUND	0	0	0	548
orcl	0	0	0	0
orclXDB	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	7028	0	11	0	0	0	384	0
SYS$BACKGROUND	811	0	1132	14	0	0	0	0
orcl	0	0	0	0	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

Back to Top

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %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 99.6% of Total DB Time (s): 19
• Captured PL/SQL account for 61.7% of Total DB Time (s): 19

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
9.22	479	0.02	48.68	99.59	0.78	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
2.62	958	0.00	13.81	105.73	0.00	aykvshm7zsabd		select size_for_estimate, size...
1.99	958	0.00	10.49	98.54	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
1.85	440	0.00	9.75	99.34	2.88	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
1.18	8	0.15	6.21	99.93	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
1.16	8	0.15	6.13	99.98	0.00	dayq182sk41ks		insert into wrh$_memory_target...
1.15	8	0.14	6.09	99.98	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
1.08	27,505	0.00	5.68	100.94	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
0.73	5,748	0.00	3.87	13.11	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
0.60	8	0.08	3.19	99.95	0.00	66gs90fyynks7		insert into wrh$_instance_reco...
0.52	958	0.00	2.74	68.68	0.00	fvkynu9xgck8h		select PGA_TARGET_FOR_ESTIMATE...
0.51	3	0.17	2.69	97.25	0.19	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
0.50	8	0.06	2.65	100.29	0.01	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.44	479	0.00	2.30	97.43	0.33	7vcwzqf7mgk3b	EM_PING	INSERT INTO MGMT_JOB_EXECUTION...
0.42	8	0.05	2.23	99.82	0.00	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
0.41	8	0.05	2.14	99.80	0.09	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.39	1	0.39	2.07	99.97	0.00	acc988uzvjmmt		delete from WRH$_SYSMETRIC_HIS...
0.38	3	0.13	2.01	100.35	13.65	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
0.33	8	0.04	1.74	100.09	0.01	586b2udq6dbng		insert into wrh$_sysstat (snap...
0.33	504	0.00	1.73	96.90	0.00	4jrfrtx4u6zcx		SELECT TASK_TGT.TARGET_GUID TA...
0.28	48	0.01	1.50	100.71	0.00	6mvfay19q3v4n		SELECT COUNT(CLIENT_INFO) FROM...
0.26	47	0.01	1.39	99.37	0.00	dqbhc9r7gz0a5		SELECT DECODE(COUNT(CLIENT_INF...
0.25	1,086	0.00	1.33	97.18	0.51	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.25	528	0.00	1.32	98.59	0.00	cumjq42201t37		select u1.user#, u2.user#, u3....
0.24	8	0.03	1.27	99.85	0.01	7g732rx16j8jc		insert into WRH$_SERVICE_STAT ...
0.24	721	0.00	1.24	78.93	0.00	0k8522rmdzg4k		select privilege# from sysauth...
0.20	528	0.00	1.08	94.92	0.51	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.19	1,713	0.00	1.00	104.07	0.00	5kyb5bvnu3s04		SELECT DISTINCT METRIC_GUID FR...

---

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 59.9% of Total CPU Time (s): 30
• Captured PL/SQL account for 38.6% of Total CPU Time (s): 30

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9.18	479	0.02	30.50	9.22	99.59	0.78	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
2.77	958	0.00	9.18	2.62	105.73	0.00	aykvshm7zsabd		select size_for_estimate, size...
1.96	958	0.00	6.50	1.99	98.54	0.00	772s25v1y0x8k		select shared_pool_size_for_es...
1.84	440	0.00	6.10	1.85	99.34	2.88	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
1.18	8	0.15	3.90	1.18	99.93	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
1.16	8	0.15	3.85	1.16	99.98	0.00	dayq182sk41ks		insert into wrh$_memory_target...
1.15	8	0.14	3.83	1.15	99.98	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
1.09	27,505	0.00	3.61	1.08	100.94	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
0.60	8	0.08	2.01	0.60	99.95	0.00	66gs90fyynks7		insert into wrh$_instance_reco...
0.50	8	0.06	1.67	0.50	100.29	0.01	4dy1xm4nxc0gf		insert into wrh$_system_event ...
0.49	3	0.16	1.64	0.51	97.25	0.19	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
0.42	479	0.00	1.41	0.44	97.43	0.33	7vcwzqf7mgk3b	EM_PING	INSERT INTO MGMT_JOB_EXECUTION...
0.42	8	0.05	1.40	0.42	99.82	0.00	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
0.40	8	0.05	1.34	0.41	99.80	0.09	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.39	1	0.39	1.30	0.39	99.97	0.00	acc988uzvjmmt		delete from WRH$_SYSMETRIC_HIS...
0.38	3	0.13	1.27	0.38	100.35	13.65	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
0.36	958	0.00	1.18	0.52	68.68	0.00	fvkynu9xgck8h		select PGA_TARGET_FOR_ESTIMATE...
0.33	8	0.04	1.10	0.33	100.09	0.01	586b2udq6dbng		insert into wrh$_sysstat (snap...
0.32	504	0.00	1.05	0.33	96.90	0.00	4jrfrtx4u6zcx		SELECT TASK_TGT.TARGET_GUID TA...

---

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 77.2% of Total User I/O Wait Time (s): 0
• Captured PL/SQL account for 133.9% of Total User I/O Wait Time (s): 0

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.07	479	0.00	76.60	9.22	99.59	0.78	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.05	440	0.00	56.83	1.85	99.34	2.88	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
0.05	3	0.02	55.73	0.38	100.35	13.65	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
0.01	1	0.01	14.46	0.02	18.06	81.45	848dyu9288c3h		SELECT mgmt_metric_value_obj....
0.00	479	0.00	1.53	0.44	97.43	0.33	7vcwzqf7mgk3b	EM_PING	INSERT INTO MGMT_JOB_EXECUTION...
0.00	1,086	0.00	1.38	0.25	97.18	0.51	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.00	528	0.00	1.12	0.20	94.92	0.51	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.00	3	0.00	1.04	0.51	97.25	0.19	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
0.00	528	0.00	1.02	0.15	99.91	0.64	47a50dvdgnxc2		update sys.job$ set failures=0...
0.00	1,955	0.00	0.45	0.13	91.42	0.33	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...

---

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: 932,997
• Captured SQL account for 68.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
243,493	479	508.34	26.10	9.22	99.6	.8	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
155,691	3	51,897.00	16.69	0.51	97.2	.2	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
118,693	1	118,693.00	12.72	0.39	100	0	acc988uzvjmmt		delete from WRH$_SYSMETRIC_HIS...
94,754	27,505	3.44	10.16	1.08	100.9	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
85,127	440	193.47	9.12	1.85	99.3	2.9	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
36,041	3	12,013.67	3.86	0.38	100.4	13.7	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
30,917	721	42.88	3.31	0.24	78.9	0	0k8522rmdzg4k		select privilege# from sysauth...
19,449	1	19,449.00	2.08	0.07	100.3	.1	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
14,907	8	1,863.38	1.60	0.41	99.8	.1	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
13,608	168	81.00	1.46	0.07	93.7	0	6xvp6nxs4a9n4		select nvl(sum(space), 0) from...
13,608	168	81.00	1.46	0.04	106.7	0	csnp95dz2r8ss		select file#, block# from recy...
12,044	1	12,044.00	1.29	0.05	101.1	0	0sfsrf0qzvsjv		delete from WRH$_SYSMETRIC_SUM...
11,504	5,748	2.00	1.23	0.73	13.1	0	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
10,452	1,086	9.62	1.12	0.25	97.2	.5	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
9,828	6	1,638.00	1.05	0.05	105	0	1n1bm7xa28vtq		select file#, block#, type#, n...
9,633	1,955	4.93	1.03	0.13	91.4	.3	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
9,583	479	20.01	1.03	0.44	97.4	.3	7vcwzqf7mgk3b	EM_PING	INSERT INTO MGMT_JOB_EXECUTION...

---

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: 6,991
• Captured SQL account for 98.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,818	479	14.23	97.53	9.22	99.59	0.78	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
6,807	440	15.47	97.37	1.85	99.34	2.88	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
6,807	3	2,269.00	97.37	0.38	100.35	13.65	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
85	3	28.33	1.22	0.51	97.25	0.19	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
10	8	1.25	0.14	0.01	111.55	1.34	dcvnnc6bjqshc		SELECT TASK_ID, TASK_CLASS FRO...
4	1	4.00	0.06	0.08	99.97	0.11	c2p32r5mzv8hb		BEGIN prvt_advisor.delete_expi...
3	1	3.00	0.04	0.07	100.33	0.07	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
1	1	1.00	0.01	0.02	18.06	81.45	848dyu9288c3h		SELECT mgmt_metric_value_obj....
0	32	0.00	0.00	0.02	101.37	0.00	00prz3j9n4gyj	Oracle Enterprise Manager.rollup	SELECT METRIC_GUID, TRUNC(COLL...
0	1	0.00	0.00	0.00	0.00	0.00	00zqy3yd0r3p3		lock table sys.mon_mods$ in ex...

---

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: 6,991
• Captured SQL account for 97.9% of Total
• Total UnOptimized Read Requests: 6,991
• Captured SQL account for 97.9% 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	%Opt	%Total	SQL Id	SQL Module	SQL Text
6,938	6,938	479	14.48	0.00	99.24	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
6,927	6,927	440	15.74	0.00	99.08	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
6,843	6,843	3	2,281.00	0.00	97.88	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
224	224	800	0.28	0.00	3.20	49s332uhbnsma		declare vsn varchar2(20); beg...
4	4	1	4.00	0.00	0.06	c2p32r5mzv8hb		BEGIN prvt_advisor.delete_expi...
0	0	32	0.00		0.00	00prz3j9n4gyj	Oracle Enterprise Manager.rollup	SELECT METRIC_GUID, TRUNC(COLL...
0	0	1	0.00		0.00	00zqy3yd0r3p3		lock table sys.mon_mods$ in ex...
0	0	2,961	0.00		0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
0	0	1,235	0.00		0.00	08bqjmf8490s2		SELECT PARAMETER_VALUE FROM MG...
0	0	419	0.00		0.00	08vznc16ycuag	EM_PING	SELECT SYS_GUID() FROM SYS.DUA...

---

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: 94,258
• Captured SQL account for 65.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
27,505	45,888	1.67	1.08	100.9	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
5,748	528	0.09	0.73	13.1	0	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
2,961	2,961	1.00	0.07	99.2	0	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
1,955	1,955	1.00	0.13	91.4	.3	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
1,955	1,955	1.00	0.04	100.1	0	gfdn12rn0fg3m		SELECT TARGET_GUID FROM MGMT_T...
1,713	1,713	1.00	0.19	104.1	0	5kyb5bvnu3s04		SELECT DISTINCT METRIC_GUID FR...
1,235	742	0.60	0.07	120.4	0	08bqjmf8490s2		SELECT PARAMETER_VALUE FROM MG...
1,086	1,086	1.00	0.25	97.2	.5	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
1,056	918	0.87	0.07	97.4	0	g00cj285jmgsw		update sys.mon_mods$ set inser...
958	29,698	31.00	1.99	98.5	0	772s25v1y0x8k		select shared_pool_size_for_es...
958	19,160	20.00	2.62	105.7	0	aykvshm7zsabd		select size_for_estimate, size...
958	13,412	14.00	0.52	68.7	0	fvkynu9xgck8h		select PGA_TARGET_FOR_ESTIMATE...

---

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 58,827
• Captured SQL account for 74.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
27,505	27,505	46.76	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,219	1,235	2.07	08bqjmf8490s2		SELECT PARAMETER_VALUE FROM MG...
1,061	2,961	1.80	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
1,056	1,056	1.80	g00cj285jmgsw		update sys.mon_mods$ set inser...
800	800	1.36	49s332uhbnsma		declare vsn varchar2(20); beg...
721	721	1.23	0k8522rmdzg4k		select privilege# from sysauth...
568	568	0.97	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
528	528	0.90	47a50dvdgnxc2		update sys.job$ set failures=0...
528	528	0.90	aq8yqxyyb40nn		update sys.job$ set this_date=...
528	528	0.90	cumjq42201t37		select u1.user#, u2.user#, u3....

---

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
59,422,648		5.76	9m82p8p2d7z84		** SQL Text Not Available **
26,327,344		2.55	46zqay3hb3n7d		** SQL Text Not Available **
16,155,464		1.57	3mqvkt9as1phq		** SQL Text Not Available **
14,220,615	1	1.38	1wdhux6669jk1		merge /*+ dynamic_sampling(mm...
11,031,918	440	1.07	fsbqktj5vw6n9		select next_run_date, obj#, ru...
8,117,367	16	0.79	69k5bhm12sz98		SELECT dbin.instance_number, d...
4,286,720		0.42	3ypcc0jwu2wxr		** SQL Text Not Available **
4,196,791	1	0.41	2m7ax0c761q1q		delete /*+ dynamic_sampling(m...
3,563,672	105	0.35	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
3,198,063	528	0.31	cumjq42201t37		select u1.user#, u2.user#, u3....
2,546,619	32	0.25	00prz3j9n4gyj	Oracle Enterprise Manager.rollup	SELECT METRIC_GUID, TRUNC(COLL...
2,174,097	17	0.21	g4gp07gt2z920		update sys.scheduler$_job set ...
1,943,961	48	0.19	cabqn4dp09qck		SELECT TASK_CLASS, ROUND(NVL(S...
1,852,963	1	0.18	00zqy3yd0r3p3		lock table sys.mon_mods$ in ex...
1,784,599	690	0.17	9p5tvdmjymwx7		UPDATE MGMT_POLICY_ASSOC_EVAL_...
1,610,136	1,955	0.16	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
1,472,893	8	0.14	dcvnnc6bjqshc		SELECT TASK_ID, TASK_CLASS FRO...
1,441,454	48	0.14	ak5crjygnpk60		UPDATE DBMS_LOCK_ALLOCATED SET...
1,335,472	7	0.13	84ygtc6ucuafk	DBMS_SCHEDULER	update sys.scheduler$_job set ...
1,334,807	122	0.13	3x0kdm7z3yasw		SELECT TARGET_TYPE, TYPE_META_...
1,271,631	8	0.12	11p815z8hkfms	Oracle Enterprise Manager.purge system performan	DELETE MGMT_SYSTEM_PERFORMANCE...
1,190,379	1,056	0.12	g00cj285jmgsw		update sys.mon_mods$ set inser...
1,154,622	528	0.11	47a50dvdgnxc2		update sys.job$ set failures=0...

---

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
271		46zqay3hb3n7d		** SQL Text Not Available **
265		3ypcc0jwu2wxr		** SQL Text Not Available **
249		3mqvkt9as1phq		** SQL Text Not Available **
232		9m82p8p2d7z84		** SQL Text Not Available **
195	1	00zqy3yd0r3p3		lock table sys.mon_mods$ in ex...
190	440	fsbqktj5vw6n9		select next_run_date, obj#, ru...
165	1	2m7ax0c761q1q		delete /*+ dynamic_sampling(m...
165	1	2m7ax0c761q1q		delete /*+ dynamic_sampling(m...
165	7	84ygtc6ucuafk	DBMS_SCHEDULER	update sys.scheduler$_job set ...
164	1	1wdhux6669jk1		merge /*+ dynamic_sampling(mm...
164	1	1wdhux6669jk1		merge /*+ dynamic_sampling(mm...
163	122	3x0kdm7z3yasw		SELECT TARGET_TYPE, TYPE_META_...
163	16	69k5bhm12sz98		SELECT dbin.instance_number, d...
159	48	ak5crjygnpk60		UPDATE DBMS_LOCK_ALLOCATED SET...
154	678	3c1kubcdjnppq		update sys.col_usage$ set equa...
122	8	dcvnnc6bjqshc		SELECT TASK_ID, TASK_CLASS FRO...
117	690	9p5tvdmjymwx7		UPDATE MGMT_POLICY_ASSOC_EVAL_...
112	32	00prz3j9n4gyj	Oracle Enterprise Manager.rollup	SELECT METRIC_GUID, TRUNC(COLL...
111	48	cabqn4dp09qck		SELECT TASK_CLASS, ROUND(NVL(S...
108	105	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
108	105	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
104	48	1t0vfvhmyjq5c		SELECT NVL(AVG(VALUE) , 0) FRO...
102	5,748	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
102	528	aq8yqxyyb40nn		update sys.job$ set this_date=...
99	528	47a50dvdgnxc2		update sys.job$ set failures=0...
96	1,955	gfdn12rn0fg3m		SELECT TARGET_GUID FROM MGMT_T...
88	528	cumjq42201t37		select u1.user#, u2.user#, u3....
82	1,086	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
78	1,955	8vwv6hx92ymmm		UPDATE MGMT_CURRENT_METRICS SE...
77	128	5rygsj4dbw6jt		insert into sys.mon_mods$ (obj...
73	17	g4gp07gt2z920		update sys.scheduler$_job set ...
70	1,056	g00cj285jmgsw		update sys.mon_mods$ set inser...
63	8	11p815z8hkfms	Oracle Enterprise Manager.purge system performan	DELETE MGMT_SYSTEM_PERFORMANCE...

---

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
00prz3j9n4gyj	SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')
00zqy3yd0r3p3	lock table sys.mon_mods$ in exclusive mode
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuag	SELECT SYS_GUID() FROM SYS.DUAL
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sfsrf0qzvsjv	delete from WRH$_SYSMETRIC_SUMMARY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
11p815z8hkfms	DELETE MGMT_SYSTEM_PERFORMANCE_LOG WHERE TIME < :B2 AND ROWNUM <= :B1
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1n1bm7xa28vtq	select file#, block#, type#, nvl(spare1, 0), hwmincr, cachehint, nvl(scanhint, 0) from seg$ where ts# = :1
1t0vfvhmyjq5c	SELECT NVL(AVG(VALUE) , 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME='Notification Delivery' AND NAME='Delivery Time' AND TIME>(SYSDATE-(1/24))
1wdhux6669jk1	merge /*+ dynamic_sampling(mm 4) dynamic_sampling_est_cdn(mm) dynamic_sampling(m 4) dynamic_sampling_est_cdn(m) */ into mon_mods_all$ mm using (select decode(grouping_id(tp.bo#, m.obj#), 1, tp.bo#, m.obj#) obj#, sum(m.inserts) inserts, sum(m.updates) updates, sum(m.deletes) deletes, case when grouping_id(tp.bo#, m.obj#) = 0 then (/* IF THIS IS A PARTITION AGGREGATE THE TRUNCATE BIT */ decode(sum(bitand(m.flags, 1)), 0, 0, 1) +decode(sum(bitand(m.flags, 2)), 0, 0, 2) +decode(sum(bitand(m.flags, 4)), 0, 0, 4) /* ADD NEW KSXM BITS HERE */ ) else (/* IF THIS IS A TABLE DO NOT AGGREAGATE THE TRUNCATE BIT */ decode(sum(bitand(m.flags, 2)), 0, 0, 2) +decode(sum(bitand(m.flags, 4)), 0, 0, 4) /* ADD NEW KSXM BITS HERE */ ) end as flags, max(m.timestamp) timestamp, sum(m.drop_segments) drop_segments from sys.mon_mods$ m, (select obj#, bo# from sys.tabpart$ union all select obj#, bo# from sys.tabcompart$) tp where m.obj# = tp.obj# group by rollup(tp.bo#, m.obj#) having grouping_id(tp.bo#, m.obj#) < 3 ) v on (mm.obj# = v.obj#) when matched then update set mm.inserts = mm.inserts + v.inserts, mm.updates = mm.updates + v.updates, mm.deletes = mm.deletes + v.deletes, mm.flags = mm.flags + v.flags - bitand(mm.flags, v.flags) /* bitor(mm.flags, v.flags) */, mm.timestamp = v.timestamp, mm.drop_segments = mm.drop_segments + v.drop_segments when NOT matched then insert (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (v.obj#, v.inserts, v.updates, v.deletes, sysdate, v.flags, v.drop_segments)
2m7ax0c761q1q	delete /*+ dynamic_sampling(m 4) dynamic_sampling_est_cdn(m) */ from sys.mon_mods$ m where exists (select /*+ unnest */ * from sys.tabcompart$ t where t.obj# = m.obj#)
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3mqvkt9as1phq	** SQL Text Not Available **
3s58mgk0uy2ws	insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
3x0kdm7z3yasw	SELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
3ypcc0jwu2wxr	** SQL Text Not Available **
46zqay3hb3n7d	** SQL Text Not Available **
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4dy1xm4nxc0gf	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4jrfrtx4u6zcx	SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
586b2udq6dbng	insert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
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
5rygsj4dbw6jt	insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
66gs90fyynks7	insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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;
6mvfay19q3v4n	SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7g732rx16j8jc	insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7vcwzqf7mgk3b	INSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC')
848dyu9288c3h	SELECT mgmt_metric_value_obj.new(target_guid, null, null, mgmt_namevalue_array(mgmt_namevalue_obj.new('GROUP_TARGET_GUID', GROUP_TARGET_GUID), mgmt_namevalue_obj.new('MEMBER_TARGET_TYPE', MEMBER_TARGET_TYPE), mgmt_namevalue_obj.new('CATEGORY', CATEGORY), mgmt_namevalue_obj.new('BUCKET1', BUCKET1), mgmt_namevalue_obj.new('BUCKET2', BUCKET2), mgmt_namevalue_obj.new('BUCKET3', BUCKET3), mgmt_namevalue_obj.new('BUCKET4', BUCKET4), mgmt_namevalue_obj.new('BUCKET5', BUCKET5))) from ( with buckets as ( select avgs.target_guid, avgs.target_type, avgs.target_name, NVL(avgs.category_name, 'ALL') as category, case when(width_bucket(avgs.compliance_score, 0, 101, 5)=1) then 1 else 0 end as b1, case when(width_bucket(avgs.compliance_score, 0, 101, 5)=2) then 1 else 0 end as b2, case when(width_bucket(avgs.compliance_score, 0, 101, 5)=3) then 1 else 0 end as b3, case when(width_bucket(avgs.compliance_score, 0, 101, 5)=4) then 1 else 0 end as b4, case when(width_bucket(avgs.compliance_score, 0, 101, 5)=5) then 1 else 0 end as b5 from ( SELECT t.target_guid, t.target_type, t.target_name, c.category_name, round(AVG(a.compliance_score)) as compliance_score from sysman.mgmt_targets t, sysman.mgmt_category_map c, sysman.mgmt_policy_assoc_eval_summ a, sysman.mgmt_policies p where t.target_guid = a.target_guid and a.policy_guid = c.object_guid and p.policy_guid = a.policy_guid and p.policy_type = 2 and c.class_name = 'Functional' group by t.target_name, t.target_guid, t.target_type, rollup(c.category_name) ) avgs ) SELECT q.group_target_guid, rt.target_guid, NVL(q.member_target_type, 'ALL') as member_target_type, q.category as category, sum(q.bucket1) as bucket1, sum(q.bucket2) as bucket2, sum(q.bucket3) as bucket3, sum(q.bucket4) as bucket4, sum(q.bucket5) as bucket5 FROM ( ( SELECT a.source_target_guid as group_target_guid, x.target_type as member_target_type, x.category as category, x.b1 as bucket1, x.b2 as bucket2, x.b3 as bucket3, x.b4 as bucket4, x.b5 as bucket5 FROM sysman.mgmt_flat_target_assoc a, buckets x WHERE a.is_membership = 1 and (a.assoc_target_guid = x.target_guid) ) UNION ALL ( SELECT x.target_guid as group_target_guid, x.target_type as member_target_type, x.category as category, x.b1 as bucket1, x.b2 as bucket2, x.b3 as bucket3, x.b4 as bucket4, x.b5 as bucket5 FROM buckets x, mgmt_type_properties p WHERE x.target_type = p.target_type and p.property_name = 'is_aggregate' and p.property_value = '1' ) ) q, sysman.mgmt_targets rt WHERE rt.target_type = 'oracle_emrep' GROUP BY q.group_target_guid, rt.target_guid, rollup(q.member_target_type), q.category) WHERE target_guid IN (SELECT target_guid FROM MGMT_COLLECTION_METRIC_TASKS WHERE TASK_ID = :task_id) order by target_guid
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
84ygtc6ucuafk	update sys.scheduler$_job set job_status = :1 where obj# = :2
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
9m82p8p2d7z84	** SQL Text Not Available **
9p5tvdmjymwx7	UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VIOLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1
9v9n97qj8z1dg	delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)
acc988uzvjmmt	delete from WRH$_SYSMETRIC_HISTORY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
ak5crjygnpk60	UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bm2pwrpcr8ru6	select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bzscyq07w79ab	delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and rownum <= NVL(:2, rownum)
c2p32r5mzv8hb	BEGIN prvt_advisor.delete_expired_tasks; END;
cabqn4dp09qck	SELECT TASK_CLASS, ROUND(NVL(SUM(THROUGHPUT), 0), 2), NVL(SUM(TOTAL_VALUE), 0), NVL(SUM(TOTAL_DURATION), 0) FROM (SELECT CLIENT_DATA WORKER_ID, ACTION TASK_CLASS, NVL(AVG(VALUE*1000/ DECODE(DURATION, 0, 1000, DURATION)), 0) THROUGHPUT, SUM(VALUE) TOTAL_VALUE, SUM(DURATION)/1000 TOTAL_DURATION, COUNT(*) RECORDS FROM MGMT_SYSTEM_PERFORMANCE_LOG LOG WHERE LOG.JOB_NAME = :B3 AND LOG.MODULE = :B2 AND LOG.TIME > (SYSDATE-:B1 /1440) AND LOG.IS_TOTAL = 'Y' GROUP BY CLIENT_DATA, ACTION ) GROUP BY TASK_CLASS
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
dcvnnc6bjqshc	SELECT TASK_ID, TASK_CLASS FROM MGMT_COLLECTION_TASKS C WHERE FREQUENCY_CODE != 7 AND NOT EXISTS (SELECT 1 FROM MGMT_TASK_QTABLE Q WHERE Q.USER_DATA.TASK_ID = C.TASK_ID) FOR UPDATE
dqbhc9r7gz0a5	SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1
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(cast(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
fvkynu9xgck8h	select PGA_TARGET_FOR_ESTIMATE s, PGA_TARGET_FACTOR * 100 f, ESTD_TIME t, BYTES_PROCESSED b from v$pga_target_advice order by PGA_TARGET_FOR_ESTIMATE
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4gp07gt2z920	update sys.scheduler$_job set last_start_date = :1, running_instance = :2, running_slave = :3, job_status = :4 where obj# = :5
gfdn12rn0fg3m	SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Back to Top

Key Instance Activity Stats

• Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	471,768	16.41	158.90
execute count	94,258	3.28	31.75
logons cumulative	1,856	0.06	0.63
opened cursors cumulative	85,640	2.98	28.84
parse count (total)	58,827	2.05	19.81
parse time elapsed	183	0.01	0.06
physical reads	6,991	0.24	2.35
physical writes	15,561	0.54	5.24
redo size	71,245,476	2,477.48	23,996.46
session cursor cache hits	62,944	2.19	21.20
session logical reads	932,997	32.44	314.25
user calls	5,952	0.21	2.00
user commits	2,969	0.10	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	28,574	0.99	9.62

---

Back to Instance Activity Statistics
Back to Top

Other 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 slow jump 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	66	0.00	0.02
CCursor + sql area evicted	2	0.00	0.00
CPU used by this session	10,107	0.35	3.40
CPU used when call started	1,302	0.05	0.44
CR blocks created	226	0.01	0.08
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	1	0.00	0.00
DBWR checkpoint buffers written	15,418	0.54	5.19
DBWR checkpoints	43	0.00	0.01
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	820	0.03	0.28
DBWR undo block writes	5,310	0.18	1.79
HSC Heap Segment Block Changes	94,573	3.29	31.85
Heap Segment Array Inserts	894	0.03	0.30
Heap Segment Array Updates	904	0.03	0.30
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	1,078	0.04	0.36
IMU Redo allocation size	2,672,564	92.94	900.16
IMU commits	2,757	0.10	0.93
IMU contention	0	0.00	0.00
IMU ktichg flush	1	0.00	0.00
IMU pool not allocated	27	0.00	0.01
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	16,468,856	572.68	5,546.94
IMU- failed to get a private strand	27	0.00	0.01
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Requests to/from client	384	0.01	0.13
RowCR attempts	1,648	0.06	0.56
RowCR hits	1,648	0.06	0.56
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	384	0.01	0.13
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	650	0.02	0.22
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	139,761	4.86	47.07
branch node splits	0	0.00	0.00
buffer is not pinned count	233,381	8.12	78.61
buffer is pinned count	224,771	7.82	75.71
bytes received via SQL*Net from client	112,608	3.92	37.93
bytes sent via SQL*Net to client	238,560	8.30	80.35
calls to get snapshot scn: kcmgss	107,520	3.74	36.21
calls to kcmgas	8,381	0.29	2.82
calls to kcmgcs	20,290	0.71	6.83
cell physical IO interconnect bytes	1,511,389,184	52,556.75	509,056.65
change write time	101	0.00	0.03
cleanout - number of ktugct calls	682	0.02	0.23
cleanouts and rollbacks - consistent read gets	3	0.00	0.00
cleanouts only - consistent read gets	18	0.00	0.01
cluster key scan block gets	19,805	0.69	6.67
cluster key scans	17,394	0.60	5.86
commit batch/immediate performed	480	0.02	0.16
commit batch/immediate requested	480	0.02	0.16
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	46	0.00	0.02
commit cleanout failures: cannot pin	4	0.00	0.00
commit cleanouts	22,369	0.78	7.53
commit cleanouts successfully completed	22,319	0.78	7.52
commit immediate performed	480	0.02	0.16
commit immediate requested	480	0.02	0.16
commit txn count during cleanout	252	0.01	0.08
consistent changes	668	0.02	0.22
consistent gets	466,126	16.21	157.00
consistent gets - examination	159,749	5.56	53.81
consistent gets direct	0	0.00	0.00
consistent gets from cache	466,126	16.21	157.00
consistent gets from cache (fastpath)	283,087	9.84	95.35
cursor authentications	194	0.01	0.07
data blocks consistent reads - undo records applied	524	0.02	0.18
db block gets	466,871	16.23	157.25
db block gets direct	1	0.00	0.00
db block gets from cache	466,870	16.23	157.25
db block gets from cache (fastpath)	128,935	4.48	43.43
deferred (CURRENT) block cleanout applications	10,790	0.38	3.63
dirty buffers inspected	27	0.00	0.01
enqueue conversions	6,405	0.22	2.16
enqueue releases	265,532	9.23	89.43
enqueue requests	265,532	9.23	89.43
enqueue timeouts	0	0.00	0.00
enqueue waits	82	0.00	0.03
exchange deadlocks	0	0.00	0.00
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	8,786	0.31	2.96
free buffer requested	13,225	0.46	4.45
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	294	0.01	0.10
hot buffers moved to head of LRU	14,388	0.50	4.85
immediate (CR) block cleanout applications	21	0.00	0.01
immediate (CURRENT) block cleanout applications	7,824	0.27	2.64
index crx upgrade (positioned)	2	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	139	0.00	0.05
index fetch by key	87,694	3.05	29.54
index scans kdiixs1	103,040	3.58	34.71
leaf node 90-10 splits	159	0.01	0.05
leaf node splits	226	0.01	0.08
lob reads	0	0.00	0.00
lob writes	48	0.00	0.02
lob writes unaligned	48	0.00	0.02
logical read bytes from cache	7,643,103,232	265,779.78	2,574,302.20
max cf enq hold time	0	0.00	0.00
messages received	14,711	0.51	4.95
messages sent	14,711	0.51	4.95
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	16	0.00	0.01
no work - consistent read gets	264,506	9.20	89.09
non-idle wait count	92,750	3.23	31.24
parse count (describe)	3	0.00	0.00
parse count (failures)	1	0.00	0.00
parse count (hard)	382	0.01	0.13
parse time cpu	155	0.01	0.05
physical read IO requests	6,991	0.24	2.35
physical read bytes	57,270,272	1,991.51	19,289.41
physical read total IO requests	62,835	2.19	21.16
physical read total bytes	971,581,440	33,785.58	327,241.98
physical read total multi block requests	0	0.00	0.00
physical reads cache	6,991	0.24	2.35
physical reads cache prefetch	0	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	8,120	0.28	2.73
physical write bytes	127,475,712	4,432.82	42,935.57
physical write total IO requests	34,471	1.20	11.61
physical write total bytes	539,807,744	18,771.17	181,814.67
physical write total multi block requests	322	0.01	0.11
physical writes direct	1	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00
physical writes from cache	15,560	0.54	5.24
physical writes non checkpoint	3,804	0.13	1.28
pinned buffers inspected	3	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	474	0.02	0.16
process last non-idle time	28,802	1.00	9.70
recovery blocks read	0	0.00	0.00
recursive calls	645,679	22.45	217.47
recursive cpu usage	2,311	0.08	0.78
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	27,795	0.97	9.36
redo blocks read for recovery	0	0.00	0.00
redo blocks written	146,996	5.11	49.51
redo buffer allocation retries	2	0.00	0.00
redo entries	226,150	7.86	76.17
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	2	0.00	0.00
redo ordering marks	149	0.01	0.05
redo size for direct writes	0	0.00	0.00
redo subscn max counts	3,598	0.13	1.21
redo synch long waits	209	0.01	0.07
redo synch time	20	0.00	0.01
redo synch time (usec)	535,164	18.61	180.25
redo synch time overhead (usec)	16,308,256,297	567,100.12	5,492,844.83
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	947	0.03	0.32
redo synch time overhead count (<32 msec)	0	0.00	0.00
redo synch time overhead count (<8 msec)	1	0.00	0.00
redo synch time overhead count (>=128 msec)	17	0.00	0.01
redo synch writes	965	0.03	0.33
redo wastage	1,605,696	55.84	540.82
redo write info find	965	0.03	0.33
redo write info find fail	0	0.00	0.00
redo write time	350	0.01	0.12
redo writes	5,725	0.20	1.93
rollback changes - undo records applied	481	0.02	0.16
rollbacks only - consistent read gets	222	0.01	0.07
root node splits	0	0.00	0.00
rows fetched via callback	28,336	0.99	9.54
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	13,115	0.46	4.42
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	81,726	2.84	27.53
sorts (rows)	215,544	7.50	72.60
sql area evicted	198	0.01	0.07
sql area purged	21	0.00	0.01
summed dirty queue length	27	0.00	0.01
switch current to new buffer	2,523	0.09	0.85
table fetch by rowid	131,687	4.58	44.35
table fetch continued row	31	0.00	0.01
table scan blocks gotten	101,091	3.52	34.05
table scan rows gotten	6,834,665	237.67	2,302.01
table scans (direct read)	0	0.00	0.00
table scans (long tables)	20	0.00	0.01
table scans (short tables)	10,692	0.37	3.60
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	540	0.02	0.18
total number of cf enq holders	301	0.01	0.10
total number of times SMON posted	35	0.00	0.01
transaction rollbacks	480	0.02	0.16
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	32,132,240	1,117.36	10,822.58
user logons cumulative	192	0.01	0.06
user logouts cumulative	192	0.01	0.06
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	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
logons current	109	108
opened cursors current	570	570
session cursor cache count	14,903,004	14,933,307
session pga memory	622,159,791,536	623,441,105,584
session pga memory max	715,564,633,488	716,942,482,064
session uga memory	474,048,829,328	475,020,992,976
session uga memory max	729,434,439,600	730,888,494,792
workarea memory allocated	2,140	2,140

---

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)	2	0.25

---

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

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	871M	1.94	.03M	322M	0.71	.011M	76.4K	0.30
DBWR	0M	0.00	0M	121M	0.28	.004M	8100	0.10
LGWR	1M	0.00	0M	72M	0.20	.003M	11.5K	0.15
Buffer Cache Reads	55M	0.24	.002M	0M	0.00	0M	6991	0.00
Direct Writes	0M	0.00	0M	0M	0.00	0M	1	0.00
TOTAL:	927M	2.19	.032M	515M	1.20	.018M	103K	0.25

---

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	872M	1.94	.03M	321M	0.72	.011M	0.00
Data File	55M	0.25	.002M	120M	0.28	.004M	0.00
Log File	0M	0.00	0M	72M	0.20	.003M	0.00
Temp File	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	927M	2.19	.032M	513M	1.20	.018M	0.00

---

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	871M	1.94	.03M	322M	0.71	.011M	55.8K	0.00
Others (Control File)	871M	1.94	.03M	321M	0.71	.011M	55.7K	0.00
Others (Data File)	0M	0.00	0M	1M	0.00	0M	84	0.00
DBWR	0M	0.00	0M	121M	0.28	.004M	0
DBWR (Data File)	0M	0.00	0M	121M	0.28	.004M	0
LGWR	1M	0.00	0M	72M	0.20	.003M	38	0.00
LGWR (Log File)	0M	0.00	0M	72M	0.20	.003M	8	0.00
LGWR (Control File)	1M	0.00	0M	0M	0.00	0M	30	0.00
Buffer Cache Reads	55M	0.24	.002M	0M	0.00	0M	6991	0.00
Buffer Cache Reads (Data File)	55M	0.24	.002M	0M	0.00	0M	6991	0.00
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	927M	2.19	.032M	515M	1.20	.018M	62.9K	0.00

---

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Av Writes(ms)	Buffer Waits	Av Buf Wt(ms)
SYSAUX	4,067	0	0.01	1.00	5,561	0.14	0	0	0.44	0	0.00
SYSTEM	1,512	0	0.01	1.00	651	0.05	0	0	0.43	4	0.00
UNDOTBS1	0	0	0.00	0.00	1,907	0.00	0	0	0.64	0	0.00
TBS_IDX	1,328	0	0.01	1.00	0	0.05	0	0	0.00	0	0.00
ZGRS_BIZ	83	0	0.00	1.00	0	0.00	0	0	0.00	0	0.00
TEMP	1	0	0.00	1.00	1	0.00	0	0	0.00	0	0.00

---

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/datafs/oradata/orcl/sysaux01.dbf	4,067	0	0.01	1.00	0	0.01	5,561	0	0	0.00
SYSTEM	/datafs/oradata/orcl/system01.dbf	1,512	0	0.01	1.00	0	0.01	651	0	4	0.00
TBS_IDX	/datafs/oradata/orcl/tbs_idx.dbf	617	0	0.02	1.00	0	0.00	0	0	0	0.00
TBS_IDX	/datafs/oradata/orcl/tbs_idx2.dbf	711	0	0.00	1.00	0	0.01	0	0	0	0.00
TEMP	/datafs/oradata/orcl/temp01.dbf	1	0	0.00	1.00	0	0.00	1	0	0
UNDOTBS1	/datafs/oradata/orcl/undotbs01.dbf	0	0			0		1,907	0	0	0.00
ZGRS_BIZ	/datafs/oradata/orcl/zgrs_biz.dbf	83	0	0.00	1.00	0	0.00	0	0	0	0.00

---

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Buffer Pool Statistics
• Checkpoint Activity

Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	92,543	99	933,126	6,991	15,560	0	0	4

---

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 15,561

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	15,418	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

Back to Top

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	8	380	1676	1834	165888	1834
E	0	8	392	1593	1700	165888	1700

---

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	64	0.08	8	1.87	25,341	1	740.00
D	128	0.17	16	1.65	22,376	1	615.00
D	192	0.25	24	1.52	20,567	1	539.00
D	256	0.33	32	1.41	19,188	1	482.00
D	320	0.42	39	1.33	18,060	1	434.00
D	384	0.50	47	1.25	16,992	1	389.00
D	448	0.58	55	1.17	15,896	1	343.00
D	512	0.67	63	1.10	14,885	1	301.00
D	576	0.75	71	1.04	14,123	1	269.00
D	640	0.83	79	1.02	13,828	1	257.00
D	704	0.92	87	1.01	13,686	1	251.00
D	768	1.00	95	1.00	13,574	1	246.00
D	832	1.08	102	0.99	13,476	1	242.00
D	896	1.17	110	0.99	13,382	1	238.00
D	960	1.25	118	0.98	13,293	1	234.00
D	1,024	1.33	126	0.97	13,205	1	230.00
D	1,088	1.42	134	0.97	13,120	1	227.00
D	1,152	1.50	142	0.96	13,041	1	223.00
D	1,216	1.58	150	0.96	12,968	1	220.00
D	1,280	1.67	158	0.95	12,899	1	218.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	342	0

---

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs	M-Pass Execs
2K	4K	28,345	28,345	0	0
64K	128K	48	48	0	0
256K	512K	2	2	0	0
512K	1024K	89	89	0	0
1M	2M	79	79	0	0
4M	8M	16	16	0	0

---

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
138	0.13	476,351.83	0.00	100.00	0	42,011,109
276	0.25	476,351.83	0.00	100.00	0	42,011,109
552	0.50	476,351.83	0.00	100.00	0	42,011,109
828	0.75	476,351.83	0.00	100.00	0	42,011,109
1,104	1.00	476,351.83	0.00	100.00	0	42,011,109
1,325	1.20	476,351.83	0.00	100.00	0	42,011,109
1,546	1.40	476,351.83	0.00	100.00	0	42,011,109
1,766	1.60	476,351.83	0.00	100.00	0	42,011,109
1,987	1.80	476,351.83	0.00	100.00	0	42,011,109
2,208	2.00	476,351.83	0.00	100.00	0	42,011,109
3,312	3.00	476,351.83	0.00	100.00	0	42,011,109
4,416	4.00	476,351.83	0.00	100.00	0	42,011,109
6,624	6.00	476,351.83	0.00	100.00	0	42,011,109
8,832	8.00	476,351.83	0.00	100.00	0	42,011,109

---

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)
832	0.68	117	3,369	461,038	0.46	545,311	139.00	81,555
960	0.79	244	6,986	649,305	0.65	357,044	91.01	93,244
1,056	0.87	340	9,471	792,393	0.79	213,956	54.54	101,982
1,072	0.88	355	9,906	815,249	0.81	191,100	48.71	103,394
1,088	0.89	370	10,069	839,148	0.84	167,201	42.62	104,810
1,104	0.91	385	10,232	862,423	0.86	143,926	36.69	106,225
1,120	0.92	400	10,395	886,419	0.88	119,930	30.57	107,639
1,136	0.93	416	10,907	909,728	0.91	96,621	24.63	109,057
1,152	0.95	432	11,210	933,270	0.93	73,079	18.63	110,468
1,168	0.96	448	11,513	955,610	0.95	50,739	12.93	111,835
1,184	0.97	464	11,816	978,027	0.98	28,322	7.22	113,186
1,200	0.99	480	12,119	999,357	1.00	6,992	1.78	114,517
1,216	1.00	496	12,422	1,002,426	1.00	3,923	1.00	114,720
1,232	1.01	512	12,793	1,002,487	1.00	3,862	0.98	114,740
1,248	1.03	528	12,912	1,002,509	1.00	3,840	0.98	114,751
1,264	1.04	544	13,398	1,002,536	1.00	3,813	0.97	114,758
1,280	1.05	560	14,057	1,002,561	1.00	3,788	0.97	114,766
1,296	1.07	576	14,628	1,002,575	1.00	3,774	0.96	114,772
1,312	1.08	592	15,209	1,002,598	1.00	3,751	0.96	114,778
1,328	1.09	608	15,790	1,002,612	1.00	3,737	0.95	114,784
1,344	1.11	624	16,365	1,002,624	1.00	3,725	0.95	114,789
1,360	1.12	640	16,940	1,002,644	1.00	3,705	0.94	114,794
1,472	1.21	752	21,302	1,002,698	1.00	3,651	0.93	114,807
1,600	1.32	880	26,331	1,002,721	1.00	3,628	0.92	114,814
1,728	1.42	1,008	31,360	1,002,758	1.00	3,591	0.92	114,821
1,856	1.53	1,136	36,389	1,002,796	1.00	3,553	0.91	114,827
1,984	1.63	1,264	41,418	1,002,823	1.00	3,526	0.90	114,833
2,112	1.74	1,392	46,447	1,002,869	1.00	3,480	0.89	114,839
2,240	1.84	1,520	51,476	1,002,886	1.00	3,463	0.88	114,845
2,368	1.95	1,648	56,505	1,002,917	1.00	3,432	0.87	114,851
2,496	2.05	1,776	61,534	1,002,948	1.00	3,401	0.87	114,856

---

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,024	0.50	597,869	20,404,655
1,536	0.75	54,076	18,755,396
2,048	1.00	53,700	13,574,145
2,560	1.25	53,555	12,609,023
3,072	1.50	53,437	12,609,023
3,584	1.75	53,378	12,041,624
4,096	2.00	53,367	11,763,354

---

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

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	4	0	0

---

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
CR-Reuse Block Range (block range reuse ckpt)	542	542	0	41	0	1.71
RO-Multiple Object Reuse (fast object reuse)	410	410	0	41	0	0.24

---

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Back to Top

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	4.61	6,039	1,305	4	15/33.8	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
22-Feb 08:58	23	103	670	3	22	0/0	0/0/0/0/0/0
22-Feb 08:48	12	73	1,273	2	32	0/0	0/0/0/0/0/0
22-Feb 08:38	17	87	672	1	22	0/0	0/0/0/0/0/0
22-Feb 08:28	12	73	1,276	1	32	0/0	0/0/0/0/0/0
22-Feb 08:18	3,065	567	674	2	22	0/0	0/0/0/0/0/0
22-Feb 08:08	106	160	1,278	3	32	0/0	0/0/0/0/0/0
22-Feb 07:58	15	100	676	2	22	0/0	0/0/0/0/0/0
22-Feb 07:48	19	88	1,278	4	32	0/0	0/0/0/0/0/0
22-Feb 07:38	13	73	677	2	22	0/0	0/0/0/0/0/0
22-Feb 07:28	12	90	76	1	15	0/0	0/0/0/0/0/0
22-Feb 07:18	21	81	678	3	22	0/0	0/0/0/0/0/0
22-Feb 07:08	124	270	77	3	15	0/0	0/0/0/0/0/0
22-Feb 06:58	12	76	681	2	22	0/0	0/0/0/0/0/0
22-Feb 06:48	16	86	1,284	2	32	0/0	0/0/0/0/0/0
22-Feb 06:38	13	73	681	2	22	0/0	0/0/0/0/0/0
22-Feb 06:28	15	88	1,285	2	32	0/0	0/0/0/0/0/0
22-Feb 06:18	10	150	684	1	22	0/0	0/0/0/0/0/0
22-Feb 06:08	119	166	1,285	3	33	0/0	0/0/0/0/0/0
22-Feb 05:58	14	92	684	2	23	0/0	0/0/0/0/0/0
22-Feb 05:48	16	75	1,288	3	33	0/0	0/0/0/0/0/0
22-Feb 05:38	14	91	685	2	23	0/0	0/0/0/0/0/0
22-Feb 05:28	15	73	84	2	15	0/0	0/0/0/0/0/0
22-Feb 05:18	14	168	688	1	23	0/0	0/0/0/0/0/0
22-Feb 05:08	112	196	86	3	15	0/0	0/0/0/0/0/0
22-Feb 04:58	16	76	689	2	23	0/0	0/0/0/0/0/0
22-Feb 04:48	13	87	88	2	15	0/0	0/0/0/0/0/0
22-Feb 04:38	19	73	691	2	24	0/0	0/0/0/0/0/0
22-Feb 04:28	13	105	1,292	1	34	0/0	0/0/0/0/0/0
22-Feb 04:18	13	76	691	2	24	0/0	0/0/0/0/0/0
22-Feb 04:08	131	271	1,295	3	34	0/0	0/0/0/0/0/0
22-Feb 03:58	23	105	693	2	24	0/0	0/0/0/0/0/0
22-Feb 03:48	16	73	1,297	2	34	0/0	0/0/0/0/0/0
22-Feb 03:38	15	104	696	2	24	0/0	0/0/0/0/0/0
22-Feb 03:28	16	73	94	2	15	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

Back to Top

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	8	0.00		0	0
ASM db client latch	19,341	0.00		0	0
ASM map operation hash table	8	0.00		0	0
ASM network state latch	456	0.00		0	0
AWR Alerted Metric Element list	239,885	0.00		0	0
Change Notification Hash table latch	9,581	0.00		0	0
Consistent RBA	5,728	0.00		0	0
DML lock allocation	27,634	0.00		0	0
Event Group Locks	3,175	0.00		0	0
FOB s.o list latch	1,526	0.00		0	0
File State Object Pool Parent Latch	8	0.00		0	0
I/O Staticstics latch	8	0.00		0	0
IPC stats buffer allocation latch	8	0.00		0	0
In memory undo latch	48,933	0.00		0	10,179	0.00
JS Sh mem access	60	0.00		0	0
JS mem alloc latch	47	0.00		0	0
JS queue access latch	55	0.00		0	0
JS queue state obj latch	208,820	0.00		0	0
JS slv state obj latch	2,944	0.51	0.07	0	0
KFC FX Hash Latch	8	0.00		0	0
KFC Hash Latch	8	0.00		0	0
KFCL LE Freelist	8	0.00		0	0
KGNFS-NFS:SHM structure	8	0.00		0	0
KGNFS-NFS:SVR LIST	8	0.00		0	0
KJC message pool free list	8	0.00		0	0
KJCT flow control latch	8	0.00		0	0
KMG MMAN ready and startup request latch	9,582	0.00		0	0
KTF sga latch	151	0.00		0	9,117	0.00
KWQMN job cache list latch	9	0.00		0	0
KWQS pqueue ctx latch	504	0.00		0	0
Locator state objects pool parent latch	8	0.00		0	0
Lsod array latch	8	0.00		0	0
MQL Tracking Latch	0			0	575	0.00
Memory Management Latch	8	0.00		0	9,582	0.00
Memory Queue	8	0.00		0	0
Memory Queue Message Subscriber #1	8	0.00		0	0
Memory Queue Message Subscriber #2	8	0.00		0	0
Memory Queue Message Subscriber #3	8	0.00		0	0
Memory Queue Message Subscriber #4	8	0.00		0	0
Memory Queue Subscriber	8	0.00		0	0
MinActiveScn Latch	318	0.00		0	0
Mutex	8	0.00		0	0
Mutex Stats	8	0.00		0	0
OS process	10,850	0.00		0	0
OS process allocation	64,327	0.01	0.00	0	0
OS process: request allocation	2,623	0.00		0	0
PL/SQL warning settings	3,503	0.00		0	0
PX hash array latch	8	0.00		0	0
QMT	8	0.00		0	0
Real-time plan statistics latch	34,967	0.00		0	0
Result Cache: RC Latch	4,218	0.00		0	0
SGA IO buffer pool latch	2	0.00		0	2	0.00
SGA blob parent	8	0.00		0	0
SGA bucket locks	8	0.00		0	0
SGA heap locks	8	0.00		0	0
SGA pool locks	8	0.00		0	0
SQL memory manager latch	966	0.00		0	9,577	0.00
SQL memory manager workarea list latch	649,315	0.00		0	0
Shared B-Tree	2,549	0.00		0	0
Streams Generic	8	0.00		0	0
Testing	8	0.00		0	0
Token Manager	8	0.00		0	0
WCR: sync	8	0.00		0	0
Write State Object Pool Parent Latch	8	0.00		0	0
X$KSFQP	8	0.00		0	0
XDB NFS Security Latch	8	0.00		0	0
XDB unused session pool	8	0.00		0	0
XDB used session pool	8	0.00		0	0
active checkpoint queue latch	18,340	0.00		0	0
active service list	65,657	0.01	0.00	0	33,808	0.00
buffer pool	8	0.00		0	0
business card	8	0.00		0	0
cache buffer handles	70	0.00		0	0
cache buffers chains	2,659,060	0.00	0.17	0	12,192	0.00
cache buffers lru chain	28,817	0.00	0.00	0	31,744	0.00
call allocation	9,795	0.26	0.52	0	0
cas latch	8	0.00		0	0
change notification client cache latch	8	0.00		0	0
channel handle pool latch	2,845	0.00		0	0
channel operations parent latch	142,206	0.00	0.00	0	0
checkpoint queue latch	892,748	0.00	0.00	0	14,960	0.00
client/application info	6,370	0.00		0	0
compile environment latch	1,856	0.00		0	0
corrupted undo seg latch	1,923	0.00		0	0
cp cmon/server latch	8	0.00		0	0
cp pool latch	8	0.00		0	0
cp server hash latch	8	0.00		0	0
cp sga latch	456	0.00		0	0
cvmap freelist lock	8	0.00		0	0
database property service latch	6	0.00		0	0
deferred cleanup latch	456	0.00		0	0
dml lock allocation	538	0.00		0	0
done queue latch	8	0.00		0	0
dummy allocation	3,721	0.00		0	0
eighth spare latch - X parent	8	0.00		0	0
eleventh spare latch - children	8	0.00		0	0
enqueue freelist latch	8	0.00		0	486,894	0.00
enqueue hash chains	537,611	0.00	0.00	0	0
enqueues	2	0.00		0	0
fifteenth spare latch - children	8	0.00		0	0
file cache latch	1,452	0.00		0	0
first Audit Vault latch	192	0.00		0	0
flashback copy	8	0.00		0	0
fourteenth spare latch - children	8	0.00		0	0
fourth Audit Vault latch	8	0.00		0	0
gc element	8	0.00		0	0
gcs commit scn state	8	0.00		0	0
gcs partitioned table hash	8	0.00		0	0
gcs pcm hashed value bucket hash	8	0.00		0	0
gcs resource freelist	8	0.00		0	0
gcs resource hash	8	0.00		0	0
gcs resource scan list	8	0.00		0	0
gcs resource validate list	8	0.00		0	0
gcs shadows freelist	8	0.00		0	0
ges domain table	8	0.00		0	0
ges enqueue table freelist	8	0.00		0	0
ges group table	8	0.00		0	0
ges process hash list	8	0.00		0	0
ges process parent latch	8	0.00		0	0
ges resource hash list	8	0.00		0	0
ges resource scan list	8	0.00		0	0
ges resource table freelist	8	0.00		0	0
ges value block free list	8	0.00		0	0
global KZLD latch for mem in SGA	192	0.00		0	0
global tx hash mapping	8	0.00		0	0
granule operation	8	0.00		0	0
hash table column usage latch	625	0.00		0	16,514	0.00
hash table modification latch	686	0.00		0	0
heartbeat check	8	0.00		0	0
interrupt manipulation	1	0.00		0	0
intra txn parallel recovery	8	0.00		0	0
io pool granule metadata list	8	0.00		0	0
job workq parent latch	553	0.00		0	545	2.02
job_queue_processes free list latch	1,125	0.00		0	0
job_queue_processes parameter latch	6,800	0.00		0	0
k2q lock allocation	8	0.00		0	0
kcbtsemkid latch	2	0.00		0	0
kdlx hb parent latch	8	0.00		0	0
kgb parent	8	0.00		0	0
kgnfs mount latch	8	0.00		0	0
kmcptab latch	3	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	44	0.00		0	0
ksfv messages	8	0.00		0	0
ksim group membership cache	8	0.00		0	0
kss move lock	334	0.00		0	0
ksuosstats global area	2,899	0.00		0	0
ksv allocation latch	1,108	0.00		0	0
ksv class latch	660	0.00		0	0
ksv msg queue latch	8	0.00		0	0
ksz_so allocation latch	2,623	0.08	0.00	0	0
ktm global data	469	0.00		0	0
kwqbsn:qsga	1,027	0.00		0	0
lgwr LWN SCN	13,953	0.00		0	0
list of block allocation	2,126	0.05	0.00	0	0
loader state object freelist	44	0.00		0	0
lob segment dispenser latch	8	0.00		0	0
lob segment hash table latch	104	0.00		0	0
lob segment query latch	8	0.00		0	0
lock DBA buffer during media recovery	8	0.00		0	0
logical standby cache	8	0.00		0	0
logminer context allocation	8	0.00		0	0
logminer local	8	0.00		0	0
logminer work area	8	0.00		0	0
longop free list parent	8	0.00		0	0
mapped buffers lru chain	8	0.00		0	0
message pool operations parent latch	333	0.00		0	0
messages	317,025	0.01	0.00	0	0
mostly latch-free SCN	14,022	0.03	0.00	0	0
msg queue latch	8	0.00		0	0
name-service namespace bucket	8	0.00		0	0
ncodef allocation latch	456	0.00		0	0
nineth spare latch - X parent	8	0.00		0	0
object queue header heap	7,363	0.00		0	6,972	0.00
object queue header operation	79,526	0.00		0	0
object stats modification	6,653	0.00		0	0
parallel query alloc buffer	3,768	0.00		0	0
parallel query stats	8	0.00		0	0
parameter list	946	0.00		0	0
parameter table management	8,612	0.00		0	0
peshm	8	0.00		0	0
pesom_free_list	8	0.00		0	0
pesom_hash_node	8	0.00		0	0
post/wait queue	13,822	0.35	0.00	0	12,331	0.08
process allocation	3,742	0.16	0.00	0	1,311	0.00
process group creation	2,623	0.11	0.00	0	0
process queue	8	0.00		0	0
process queue reference	8	0.00		0	0
qmn task queue latch	4,180	0.00		0	0
query server freelists	8	0.00		0	0
queued dump request	96	0.00		0	0
queuing load statistics	8	0.00		0	0
recovery domain hash list	8	0.00		0	0
redo allocation	54,918	0.04	0.00	0	226,086	0.00
redo copy	8	0.00		0	226,092	0.07
redo writing	55,231	0.00		0	0
resmgr group change latch	1,321	0.00		0	0
resmgr:active threads	4,505	0.00		0	1,242	0.00
resmgr:actses change group	950	0.00		0	0
resmgr:actses change state	22	0.00		0	0
resmgr:free threads list	3,741	0.19	0.00	0	0
resmgr:method mem alloc latch	4	0.00		0	0
resmgr:plan CPU method	8	0.00		0	0
resmgr:schema config	1,400	0.00		0	59	0.00
resmgr:session queuing	8	0.00		0	0
rm cas latch	8	0.00		0	0
row cache objects	420,222	0.00	0.00	0	286	0.00
second Audit Vault latch	8	0.00		0	0
sequence cache	2,359	0.00		0	0
session allocation	6,581	0.00		0	3,176	0.00
session idle bit	13,233	0.00		0	0
session queue latch	8	0.00		0	0
session state list latch	5,156	0.00		0	0
session switching	1,776	0.00		0	0
session timer	9,578	0.00		0	0
seventh spare latch - X parent	8	0.00		0	0
shared pool	201,585	0.26	0.02	0	0
shared pool sim alloc	15	0.00		0	0
shared pool simulator	946	0.00		0	0
sim partition latch	8	0.00		0	0
simulator hash latch	58,732	0.00		0	0
simulator lru latch	7,774	0.00		0	50,902	0.00
sixth spare latch - X parent	8	0.00		0	0
sort extent pool	783	0.00		0	0
space background state object latch	80	0.00		0	0
space background task latch	36,311	0.44	0.01	0	19,198	0.00
state object free list	16	0.00		0	0
statistics aggregation	4,480	0.00		0	0
tablespace key chain	8	0.00		0	0
temp lob duration state obj allocation	16	0.00		0	0
temporary table state object allocation	2	0.00		0	0
tenth spare latch - X parent	8	0.00		0	0
test excl. parent l0	8	0.00		0	0
test excl. parent2 l0	8	0.00		0	0
thirteenth spare latch - children	8	0.00		0	0
threshold alerts latch	1,144	0.00		0	0
transaction allocation	7,614	0.01	0.00	0	0
twelfth spare latch - children	8	0.00		0	0
twenty-fifth spare latch - S par	8	0.00		0	0
twenty-first spare latch - S par	8	0.00		0	0
twenty-fourth spare latch - S par	8	0.00		0	0
twenty-second spare latch - S par	8	0.00		0	0
twenty-third spare latch - S par	8	0.00		0	0
undo global data	36,232	0.00		0	0
virtual circuit buffers	8	0.00		0	0
virtual circuit holder	8	0.00		0	0
virtual circuit queues	8	0.00		0	0
write info latch	0			0	5,727	0.00

---

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
shared pool	201,585	534	12	522
space background task latch	36,311	159	1	158
call allocation	9,795	25	13	12
JS slv state obj latch	2,944	15	1	14
cache buffers chains	2,659,060	6	1	5

---

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
JS slv state obj latch	jslvStateObjDel:1	0	1	1
cache buffers chains	kcbgcur_2	0	1	0
cache buffers chains	kcbgtcr: fast path (cr pin)	0	1	1
call allocation	ksuxds	0	13	5
shared pool	kghalo	0	12	6
space background task latch	ktsj_grab_task	0	1	1

---

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	kglget2 2	4	0
Library Cache	kgllkc1 57	4	0
Library Cache	kglhdgn2 106	3	0

---

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by 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

Back to Top

Segments by Logical Reads

• Total Logical Reads: 932,997
• Captured Segments account for 81.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_SYSAUTH1		INDEX	128,048	13.72
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX		INDEX	87,648	9.39
SYS	SYSAUX	I_WRI$_OPTSTAT_H_ST		INDEX	66,224	7.10
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	65,200	6.99
SYS	SYSTEM	RECYCLEBIN$		TABLE	55,168	5.91

---

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 6,991
• Captured Segments account for 1.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	84	1.20
SYSMAN	SYSAUX	MGMT_TASK_QTABLE_IDX02		INDEX	3	0.04
SYSMAN	SYSAUX	SYS_C005714		INDEX	2	0.03
** MISSING **	TBS_IDX	** TRANSIENT: 145679	** MISSING **	UNDEFINED	1	0.01
SYS	SYSTEM	KOTAD$		TABLE	1	0.01

---

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

• Total Physical Read Requests: 6,991
• Captured Segments account for 1.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	84	1.20
SYSMAN	SYSAUX	MGMT_TASK_QTABLE_IDX02		INDEX	3	0.04
SYSMAN	SYSAUX	SYS_C005714		INDEX	2	0.03
** MISSING **	TBS_IDX	** TRANSIENT: 145679	** MISSING **	UNDEFINED	1	0.01
SYS	SYSTEM	KOTAD$		TABLE	1	0.01

---

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

• Total UnOptimized Read Requests: 6,991
• Captured Segments account for 1.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	84	1.20
SYSMAN	SYSAUX	MGMT_TASK_QTABLE_IDX02		INDEX	3	0.04
SYSMAN	SYSAUX	SYS_C005714		INDEX	2	0.03
** MISSING **	TBS_IDX	** TRANSIENT: 145679	** MISSING **	UNDEFINED	1	0.01
SYS	SYSTEM	KOTAD$		TABLE	1	0.01

---

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: 15,561
• Captured Segments account for 36.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	980	6.30
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	454	2.92
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST		INDEX	424	2.72
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	298	1.92
SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK		INDEX	269	1.73

---

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

• Total Physical Write Requestss: 8,120
• Captured Segments account for 38.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	284	3.50
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	238	2.93
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST		INDEX	199	2.45
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	166	2.04
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX		INDEX	143	1.76

---

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

• Total Table Scans: 159
• Captured Segments account for 44.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	35	22.01
SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK		INDEX	28	17.61
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK		INDEX	7	4.40
SYS	SYSTEM	I_OBJ2		INDEX	1	0.63

---

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	SYSAUX	WRH$_SYSMETRIC_HISTORY		TABLE	29,712	15.45
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX		INDEX	29,552	15.37
SYS	SYSAUX	WRI$_OPTSTAT_HISTGRM_HISTORY		TABLE	22,832	11.87
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST		INDEX	22,160	11.52
SYS	SYSAUX	I_WRI$_OPTSTAT_H_ST		INDEX	21,792	11.33

---

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

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	SEG$		TABLE	4	100.00

---

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	561	0.00	0		18	1
dc_files	56	0.00	0		0	7
dc_global_oids	1,867	0.00	0		0	51
dc_histogram_data	5,615	3.99	0		0	5,106
dc_histogram_defs	8,803	11.58	0		0	3,436
dc_object_grants	2	0.00	0		0	47
dc_objects	10,052	1.81	0		327	1,797
dc_profiles	946	0.00	0		0	1
dc_rollback_segments	9,712	0.00	0		0	29
dc_segments	2,574	1.59	0		295	944
dc_sequences	5	0.00	0		5	6
dc_tablespaces	9,384	0.00	0		0	8
dc_users	76,661	0.00	0		0	148
global database name	20,041	0.00	0		0	1
outstanding_alerts	256	0.00	0		0	6
sch_lj_oids	35	0.00	0		0	16

---

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	576	0.00	0		0	0
BODY	10,435	0.00	14,714	0.00	0	0
CLUSTER	34	0.00	34	0.00	0	0
DBLINK	592	0.00	0		0	0
EDITION	860	0.00	1,597	0.00	0	0
INDEX	148	0.00	148	3.38	5	0
OBJECT ID	62	100.00	0		0	0
QUEUE	480	0.00	1,727	0.00	0	0
SCHEMA	813	0.12	0		0	0
SQL AREA	11,125	0.98	161,702	0.48	160	613
SQL AREA BUILD	316	68.67	0		0	0
SQL AREA STATS	314	92.36	314	92.36	0	0
SUBSCRIPTION	103	0.00	103	0.00	0	0
TABLE/PROCEDURE	4,590	0.54	21,875	1.07	70	0
TRIGGER	1,820	0.00	2,206	0.00	0	0

---

Back to Top

Memory Statistics

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

Back to Top

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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	752.00	752.00	672.00	1,408.00	0	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	1,104.00	1,104.00	1,104.00	1,264.00	0	SHR/MAN
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	2,048.00	2,048.00	1,888.00	2,048.00	0	GRO/DEF
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	16.00	0	STA/
large pool	32.00	32.00	32.00	768.00	0	SHR/DEF
shared pool	1,216.00	1,216.00	272.00	1,216.00	0	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	0	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	179.88		1.62	1.70	16	16	111	111
B	Freeable	73.63	0.00	1.57	4.32	30		47	47
B	SQL	7.01	3.85	0.07	0.12	1	9	97	91
B	PL/SQL	3.25	2.37	0.03	0.03	0	2	109	109
E	Other	178.70		1.62	1.70	16	16	110	110
E	Freeable	73.50	0.00	1.56	4.32	30		47	47
E	SQL	6.96	3.85	0.07	0.12	1	9	97	91
E	PL/SQL	3.23	2.37	0.03	0.03	0	2	108	108

---

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	788,529,152
Fixed Size	2,257,720
Redo Buffers	16,527,360
Variable Size	2,483,031,240

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	16.00	16.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	24.19	24.19	0.00
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLH0	146.86	147.93	0.73
shared	KGLHD	21.37	21.51	0.66
shared	KTI-UNDO	22.30	22.30	0.00
shared	SQLA	471.45	469.98	-0.31
shared	dbktb: trace buffer	31.25	31.25	0.00
shared	event statistics per sess	37.93	37.93	0.00
shared	free memory	142.67	142.12	-0.39
shared	kglsim object batch	16.92	16.94	0.11
shared	ksunfy : SSO free list	36.08	36.08	0.00
shared	private strands	43.12	43.12	0.00
	buffer_cache	752.00	752.00	0.00
	fixed_sga	2.15	2.15	0.00
	log_buffer	15.76	15.76	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

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

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

Back to Top

Shared Server Statistics

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

Back to Top

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	1	0	1	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

• Statistics are combined for all servers
• Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
28,753	0.00	100.00	0.00	0.00

---

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

• Ordered by %Busy, descending
• Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
• Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	28,753	0.00	100.00	0	0

---

Back to Shared Server Statistics
Back to Top

init.ora Parameters

• init.ora Parameters
• init.ora Multi-Valued Parameters

Back to Top

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/app/oracle/admin/orcl/adump
audit_trail	DB
compatible	11.2.0.4.0
control_files	/datafs/oradata/orcl/control01.ctl, /oracle/app/oracle/fast_recovery_area/orcl/control02.ctl
db_block_size	8192
db_domain
db_name	orcl
db_recovery_file_dest	/oracle/app/oracle/fast_recovery_area
db_recovery_file_dest_size	4385144832
diagnostic_dest	/oracle/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
memory_target	3305111552
open_cursors	300
plsql_warnings	DISABLE:ALL
processes	2000
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan	SCHEDULER[0x32DA]:DEFAULT_MAINTENANCE_PLAN
undo_tablespace	UNDOTBS1

---

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	/datafs/oradata/orcl/control01.ctl
control_files	/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl

---

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

Back to Top

End of Report