WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORA10G 3940039211 ora10g 1 10.2.0.1.0 NO YXPRIMARY

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORA10G	3940039211	ora10g	1	10.2.0.1.0	NO	YXPRIMARY

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 60291 25-Mar-14 16:00:28 22 3.6

End Snap: 60292 25-Mar-14 17:00:52 22 3.6

Elapsed: 60.40 (mins)

DB Time: 0.04 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	60291	25-Mar-14 16:00:28	22	3.6
End Snap:	60292	25-Mar-14 17:00:52	22	3.6
Elapsed:		60.40 (mins)
DB Time:		0.04 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 2,240M 2,240M Std Block Size: 8K

Shared Pool Size: 368M 368M Log Buffer: 14,404K

	Begin	End
Buffer Cache:	2,240M	2,240M	Std Block Size:	8K
Shared Pool Size:	368M	368M	Log Buffer:	14,404K

Load Profile

Per Second Per Transaction

Redo size: 490.17 4,934.36

Logical reads: 12.86 129.41

Block changes: 2.39 24.07

Physical reads: 0.04 0.38

Physical writes: 0.28 2.86

User calls: 0.09 0.95

Parses: 0.90 9.07

Hard parses: 0.00 0.00

Sorts: 0.54 5.39

Logons: 0.03 0.32

Executes: 1.88 18.88

Transactions: 0.10

	Per Second	Per Transaction
Redo size:	490.17	4,934.36
Logical reads:	12.86	129.41
Block changes:	2.39	24.07
Physical reads:	0.04	0.38
Physical writes:	0.28	2.86
User calls:	0.09	0.95
Parses:	0.90	9.07
Hard parses:	0.00	0.00
Sorts:	0.54	5.39
Logons:	0.03	0.32
Executes:	1.88	18.88
Transactions:	0.10

% Blocks changed per Read: 18.60 Recursive Call %: 99.01

Rollback per transaction %: 0.00 Rows per Sort: 10.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 100.00 Soft Parse %: 100.00

Execute to Parse %: 51.96 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 23.08 % Non-Parse CPU: 98.45

Shared Pool Statistics

Begin End

Memory Usage %: 76.93 76.93

% SQL with executions>1: 94.45 94.76

% Memory for SQL w/exec>1: 86.65 87.73

	Begin	End
Memory Usage %:	76.93	76.93
% SQL with executions>1:	94.45	94.76
% Memory for SQL w/exec>1:	86.65	87.73

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

control file parallel write 3,057 41 14 1,634.3 System I/O

db file parallel write 759 15 20 593.7 System I/O

log file parallel write 483 5 11 209.0 System I/O

os thread startup 56 3 48 105.2 Concurrency

CPU time 2 76.5

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
control file parallel write	3,057	41	14	1,634.3	System I/O
db file parallel write	759	15	20	593.7	System I/O
log file parallel write	483	5	11	209.0	System I/O
os thread startup	56	3	48	105.2	Concurrency
CPU time		2		76.5

Main Report

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

Time Model Statistics

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	2.93	115.54
DB CPU	1.94	76.51
PL/SQL execution elapsed time	1.23	48.38
parse time elapsed	0.17	6.71
repeated bind elapsed time	0.00	0.02
DB time	2.54
background elapsed time	80.89
background cpu time	13.18

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	Total Wait Time (s)	Avg wait (ms)	Waits /txn
System I/O	15,105	62	4	41.96
Concurrency	56	3	48	0.16
Commit	86	1	13	0.24
User I/O	312	1	3	0.87
Network	24	1	40	0.07
Other	1	0	28	0.00

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	3,057	0.00	41	14	8.49
db file parallel write	759	0.00	15	20	2.11
log file parallel write	483	0.00	5	11	1.34
os thread startup	56	0.00	3	48	0.16
log file sync	86	0.00	1	13	0.24
ARCH wait on ATTACH	12	0.00	1	80	0.03
direct path write	132	0.00	1	5	0.37
control file sequential read	10,786	0.00	0	0	29.96
direct path read	132	0.00	0	1	0.37
db file sequential read	48	0.00	0	3	0.13
log file sequential read	11	0.00	0	7	0.03
log file single write	4	0.00	0	19	0.01
Log archive I/O	5	0.00	0	8	0.01
latch free	1	0.00	0	28	0.00
ARCH wait on DETACH	12	0.00	0	0	0.03
virtual circuit status	121	100.00	3,544	29287	0.34
Streams AQ: qmn slave idle wait	129	0.00	3,517	27267	0.36
Streams AQ: qmn coordinator idle wait	260	50.38	3,517	13529	0.72
Streams AQ: waiting for time management or cleanup tasks	96	53.13	3,487	36326	0.27
jobq slave wait	1,120	99.64	3,270	2920	3.11
class slave wait	2	100.00	10	4883	0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	3,058	0.00	41	14	8.49
db file parallel write	759	0.00	15	20	2.11
log file parallel write	483	0.00	5	11	1.34
os thread startup	56	0.00	3	48	0.16
ARCH wait on ATTACH	12	0.00	1	80	0.03
direct path write	132	0.00	1	5	0.37
control file sequential read	10,131	0.00	0	0	28.14
direct path read	132	0.00	0	1	0.37
log file sequential read	11	0.00	0	7	0.03
log file single write	4	0.00	0	19	0.01
Log archive I/O	5	0.00	0	8	0.01
db file sequential read	4	0.00	0	10	0.01
ARCH wait on DETACH	12	0.00	0	0	0.03
rdbms ipc message	13,256	97.01	40,708	3071	36.82
pmon timer	1,216	100.00	3,538	2910	3.38
Streams AQ: qmn slave idle wait	129	0.00	3,517	27267	0.36
Streams AQ: qmn coordinator idle wait	260	50.38	3,517	13529	0.72
Streams AQ: waiting for time management or cleanup tasks	96	53.13	3,487	36326	0.27
smon timer	12	100.00	3,338	278140	0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	4,153
AVG_IDLE_TIME	358,356
AVG_IOWAIT_TIME	4,917
AVG_SYS_TIME	741
AVG_USER_TIME	3,305
BUSY_TIME	68,303
IDLE_TIME	5,735,482
IOWAIT_TIME	80,437
SYS_TIME	13,692
USER_TIME	54,611
LOAD	0
OS_CPU_WAIT_TIME	63,200
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	16,777,216,000
NUM_CPUS	16
NUM_CPU_CORES	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	2.50	1.90	0	18,281
SYS$BACKGROUND	0.00	0.00	136	28,091
ora10g	0.00	0.00	0	0
ora10gXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	0	0	0	0	0	0	0	0
SYS$BACKGROUND	312	101	56	266	0	0	24	96

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2	2	1	2.25	88.75	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	56	0.01	33.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	58	0.01	19.11	0hfq79bujc3zj		BEGIN LBACSYS.lbac_events.l...
0	0	1	0.14	5.58	8ux370qa6pyx9		INSERT INTO WRH$_ACTIVE_SESSIO...
0	0	6	0.02	5.27	a1xgxtssv5rrp		select sum(used_blocks), ts.t...
0	0	724	0.00	4.69	803b7z0t84sq7		select job, nvl2(last_date, ...
0	0	36	0.00	3.79	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
0	0	120	0.00	3.76	aykvshm7zsabd		select size_for_estimate, ...
0	0	1	0.07	2.76	84qubbrsr0kfn		insert into wrh$_latch (snap...
0	0	62	0.00	2.26	c0agatqzq2jzr		insert into "SYS"."ALERT_QT" ...
0	0	668	0.00	1.91	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
0	0	180	0.00	1.82	0h6b2sajwb74n		select privilege#, level from ...
0	0	1	0.04	1.56	fn9zxvwfz538b	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
0	0	1	0.04	1.48	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
0	0	1	0.04	1.38	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	0	10	0.00	1.21	g2aqmpuqbytjy	Oracle Enterprise Manager.rollup	SELECT ROWID FROM MGMT_METRICS...
0	0	1	0.03	1.16	cfz686a6qp0kg		select o.obj#, u.name, o.nam...
0	0	114	0.00	1.15	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
0	0	120	0.00	1.12	772s25v1y0x8k		select shared_pool_size_for_es...
0	0	10	0.00	1.10	8sju6v7qw79jq	Oracle Enterprise Manager.rollup	SELECT ROWID FROM MGMT_METRICS...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2	2	1	2.25	88.75	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	56	0.01	33.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	58	0.01	19.11	0hfq79bujc3zj		BEGIN LBACSYS.lbac_events.l...
0	0	1	0.14	5.58	8ux370qa6pyx9		INSERT INTO WRH$_ACTIVE_SESSIO...
0	0	724	0.00	4.69	803b7z0t84sq7		select job, nvl2(last_date, ...
0	0	36	0.00	3.79	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
0	0	120	0.00	3.76	aykvshm7zsabd		select size_for_estimate, ...
0	0	6	0.01	5.27	a1xgxtssv5rrp		select sum(used_blocks), ts.t...
0	0	1	0.07	2.76	84qubbrsr0kfn		insert into wrh$_latch (snap...
0	0	668	0.00	1.91	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
0	0	180	0.00	1.82	0h6b2sajwb74n		select privilege#, level from ...
0	0	62	0.00	2.26	c0agatqzq2jzr		insert into "SYS"."ALERT_QT" ...
0	0	10	0.00	1.21	g2aqmpuqbytjy	Oracle Enterprise Manager.rollup	SELECT ROWID FROM MGMT_METRICS...
0	0	1	0.03	1.56	fn9zxvwfz538b	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
0	0	1	0.03	1.16	cfz686a6qp0kg		select o.obj#, u.name, o.nam...
0	0	114	0.00	1.15	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
0	0	120	0.00	1.12	772s25v1y0x8k		select shared_pool_size_for_es...
0	0	10	0.00	1.10	8sju6v7qw79jq	Oracle Enterprise Manager.rollup	SELECT ROWID FROM MGMT_METRICS...
0	0	1	0.02	1.38	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	0	1	0.02	1.48	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...

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: 46,588
Captured SQL account for 61.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
12,671	56	226.27	27.20	0.68	0.84	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
6,134	1	6,134.00	13.17	0.03	0.03	cfz686a6qp0kg		select o.obj#, u.name, o.nam...
2,994	1	2,994.00	6.43	0.00	0.02	8p23kcbgfqnk4		select file#, block#, ts# fr...
2,172	724	3.00	4.66	0.12	0.12	803b7z0t84sq7		select job, nvl2(last_date, ...
1,958	180	10.88	4.20	0.05	0.05	0h6b2sajwb74n		select privilege#, level from ...
1,881	6	313.50	4.04	0.02	0.02	g337099aatnuj		update smon_scn_time set orig_...
1,856	58	32.00	3.98	0.48	0.48	0hfq79bujc3zj		BEGIN LBACSYS.lbac_events.l...
1,770	36	49.17	3.80	0.10	0.10	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
1,048	1	1,048.00	2.25	0.02	0.04	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
856	114	7.51	1.84	0.03	0.03	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
668	668	1.00	1.43	0.05	0.05	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
632	10	63.20	1.36	0.03	0.03	8sju6v7qw79jq	Oracle Enterprise Manager.rollup	SELECT ROWID FROM MGMT_METRICS...
621	55	11.29	1.33	0.02	0.02	6d64jpfzqc9rv		INSERT INTO MGMT_METRICS_RAW (...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 136
Captured SQL account for 2.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
3	62	0.05	2.21	0.04	0.06	c0agatqzq2jzr		insert into "SYS"."ALERT_QT" ...
0	56	0.00	0.00	0.00	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
0	1	0.00	0.00	0.00	0.00	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
0	110	0.00	0.00	0.00	0.00	0h2dybf5yuz5r		SELECT T.WARNING_OPERATOR, T....
0	180	0.00	0.00	0.05	0.05	0h6b2sajwb74n		select privilege#, level from ...
0	58	0.00	0.00	0.48	0.48	0hfq79bujc3zj		BEGIN LBACSYS.lbac_events.l...
0	60	0.00	0.00	0.01	0.01	0k8522rmdzg4k		select privilege# from sysauth...
0	35	0.00	0.00	0.00	0.00	0sydc5jyrv1t4		UPDATE MGMT_TARGETS SET LAST_L...
0	2	0.00	0.00	0.00	0.00	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...
0	5	0.00	0.00	0.00	0.00	13ufjzvqzz68s		SELECT COUNT(A.TARGET_NAME) FR...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 6,797
Captured SQL account for 63.8% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Text
724	56	0.08	803b7z0t84sq7	select job, nvl2(last_date, ...
668	668	1.00	g2wr3u7s1gtf3	select count(*) from sys.job$ ...
180	1,548	8.60	0h6b2sajwb74n	select privilege#, level from ...
125	125	1.00	5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FR...
120	1,440	12.00	772s25v1y0x8k	select shared_pool_size_for_es...
120	2,400	20.00	aykvshm7zsabd	select size_for_estimate, ...
114	114	1.00	18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFOR...
110	40	0.36	0h2dybf5yuz5r	SELECT T.WARNING_OPERATOR, T....
100	0	0.00	350f5yrnnmshs	lock table sys.mon_mods$ in ex...
100	100	1.00	g00cj285jmgsw	update sys.mon_mods$ set inser...
70	70	1.00	2txg6sm725mn6	INSERT INTO MGMT_METRICS_RAW (...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 3,265
Captured SQL account for 64.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
180	180	5.51	0h6b2sajwb74n		select privilege#, level from ...
100	100	3.06	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
100	100	3.06	g00cj285jmgsw		update sys.mon_mods$ set inser...
61	61	1.87	23yu0nncnp8m9		update "SYS"."AQ$_ALERT_QT_H" ...
61	61	1.87	2ysccdanw72pv		update "SYS"."ALERT_QT" set q_...
60	60	1.84	0k8522rmdzg4k		select privilege# from sysauth...
59	59	1.81	cb21bacyh3c7d		select metadata from kopm$ wh...
58	58	1.78	0hfq79bujc3zj		BEGIN LBACSYS.lbac_events.l...
58	58	1.78	2n1hu6d1pmvtw		SELECT POL# FROM LBAC$POL ORDE...
58	58	1.78	30hy59nc21g04		SELECT A.pol#, nlabel, null ...
58	58	1.78	6r75f7k88qr4a		select pol#, db_labels, defa...
58	58	1.78	74jp9b3h4krhd		SELECT POL#, PACKAGE FROM LBA...
58	58	1.78	b6y9wkhxv1puz		SELECT MAX(TAG#) FROM LBAC$LAB
58	58	1.78	d3apnz76qwmrs		select pol#, usr_name, usr_l...
56	56	1.72	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
56	114	1.72	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
56	56	1.72	19v5guvsgcd1v		SELECT C.TARGET_GUID, C.METRI...
56	56	1.72	24dkx03u3rj6k		SELECT COUNT(*) FROM MGMT_PARA...
56	56	1.72	34rks4d5suuxz	EM_PING	SELECT COUNT(FAILOVER_ID) FROM...
56	56	1.72	3z6cvmt9w5292	EM_PING	SELECT /+ RULE / STEP_ID FRO...
56	56	1.72	47a50dvdgnxc2		update sys.job$ set failures=0...
56	56	1.72	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
56	56	1.72	6t7007dkc1abh	EM_PING	DELETE FROM MGMT_JOB_EMD_STATU...
56	56	1.72	7gnakyxnvaadf	SEVERITY EVALUATION	SELECT UNIQUE(TARGET_GUID) FRO...
56	56	1.72	7s7a79nsaf4j7		select u1.user#, u2.user#, u...
56	56	1.72	813qds7fub8x4		alter session set NLS_LANGUAGE...
56	56	1.72	aq8yqxyyb40nn		update sys.job$ set this_date=...
56	56	1.72	c8h3jdwaa532q	EM_PING	SELECT TO_NUMBER(PARAMETER_VAL...
56	56	1.72	cchx5kcx6tgmz	EM_PING	SELECT COUNT(*) FROM MGMT_FAIL...
56	56	1.72	d59tgwpksgs94	EM_PING	SELECT EMD_URL, EVENT_TYPE, ...
46	46	1.41	bkdusjx00dsmc		select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,787,281	1	0.46	31a13pnjps7j3		SELECT source, (case w...

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 Text
35	114	18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFOR...
31	1	31a13pnjps7j3	SELECT source, (case w...
28	55	6d64jpfzqc9rv	INSERT INTO MGMT_METRICS_RAW (...
26	1	bhvyz9bgyrhb2	SELECT name, datatype, value, ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

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

0h2dybf5yuz5r SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSAGE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GUID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0hfq79bujc3zj BEGIN LBACSYS.lbac_events.logon(dbms_standard.login_user); END;

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

0sydc5jyrv1t4 UPDATE MGMT_TARGETS SET LAST_LOAD_TIME = :B1 WHERE TARGET_GUID = :B2 AND (LAST_LOAD_TIME < :B1 OR LAST_LOAD_TIME IS NULL)

10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_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 = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time

13ufjzvqzz68s SELECT COUNT(A.TARGET_NAME) FROM MGMT_TARGETS A, MGMT_CURRENT_AVAILABILITY B WHERE A.TARGET_GUID = B.TARGET_GUID AND B.CURRENT_STATUS = 1 AND A.TARGET_TYPE NOT IN (:B3 , :B2 , :B1 ) AND A.LAST_LOAD_TIME < ((SYSDATE - ((TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZH'))* 60 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZM'))) / (24 * 60)) + (A.TIMEZONE_DELTA / (24 * 60))) - 1 / 12)

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

19v5guvsgcd1v SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECTIONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 < SYSDATE) AND C.METRIC_GUID = M.METRIC_GUID AND R.TARGET_GUID = C.TARGET_GUID AND R.METRIC_GUID = C.METRIC_GUID AND R.COLL_NAME = C.COLL_NAME

23yu0nncnp8m9 update "SYS"."AQ$_ALERT_QT_H" set transaction_id = NULL where msgid = :1 and dequeue_time is NULL

24dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'

2n1hu6d1pmvtw SELECT POL# FROM LBAC$POL ORDER BY POL#

2txg6sm725mn6 INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 , NULL)

2ysccdanw72pv update "SYS"."ALERT_QT" set q_name = :1, state = :2, time_manager_info = NULL, exception_queue = :3 where rowid = :4

30hy59nc21g04 SELECT A.pol#, nlabel, null FROM lbac$lab A, lbac$pol B WHERE B.pol# = A.pol# AND bitand(A.flags, 1)=1 AND bitand(B.flags, 1)=1 AND tag# > sys_context('LBAC$LABELS', 'LBAC$LASTSEQ') AND null >= 1 ORDER BY nlabel ASC

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

34rks4d5suuxz SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

3z6cvmt9w5292 SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B6 , :B5 , :B4 , :B3 , :B2 ) AND STEP_TYPE=:B1 AND J.EXECUTION_TIMEOUT > 0 AND (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE)-E.START_TIME) > (J.EXECUTION_TIMEOUT/24)

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

5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1

6d64jpfzqc9rv INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )

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;

6r75f7k88qr4a select pol#, db_labels, default_format from lbac$pol

6t7007dkc1abh DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE

74jp9b3h4krhd SELECT POL#, PACKAGE FROM LBAC$POL WHERE BITAND(FLAGS, 1)=1 ORDER BY PACKAGE

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

7gnakyxnvaadf SELECT UNIQUE(TARGET_GUID) FROM MGMT_METRIC_DEPENDENCY WHERE CAN_CALCULATE = 1 AND DISABLED = 0

7s7a79nsaf4j7 select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 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

7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)

803b7z0t84sq7 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) order by next_date, job

813qds7fub8x4 alter session set NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='., ' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

8p23kcbgfqnk4 select file#, block#, ts# from seg$ where type# = 3

8sju6v7qw79jq SELECT ROWID FROM MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B2 AND ROLLUP_TIMESTAMP < :B1

8ux370qa6pyx9 INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, sql_opcode, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, a.sql_opcode, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_add r and shdr.sample_id = a.sample_id)

a1xgxtssv5rrp select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#

abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

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'

b6y9wkhxv1puz SELECT MAX(TAG#) FROM LBAC$LAB

bhvyz9bgyrhb2 SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1

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

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

c0agatqzq2jzr insert into "SYS"."ALERT_QT" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)

c8h3jdwaa532q SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

cb21bacyh3c7d select metadata from kopm$ where name='DB_FDO'

cchx5kcx6tgmz SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP > (HEARTBEAT_INTERVAL*4)/(24*60*60)

cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#

d3apnz76qwmrs select pol#, usr_name, usr_labels, package, privs from lbac$user_logon where usr_name = :username

d59tgwpksgs94 SELECT EMD_URL, EVENT_TYPE, OCCUR_TIME FROM MGMT_JOB_EMD_STATUS_QUEUE ORDER BY OCCUR_TIME

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

fn9zxvwfz538b DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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

g2aqmpuqbytjy SELECT ROWID FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B2 AND COLLECTION_TIMESTAMP < :B1

g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

g337099aatnuj update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h2dybf5yuz5r	SELECT T.WARNING_OPERATOR, T.WARNING_THRESHOLD, T.CRITICAL_OPERATOR, T.CRITICAL_THRESHOLD, T.NUM_OCCURENCES, T.NUM_WARNINGS, T.NUM_CRITICALS, T.MESSAGE, T.MESSAGE_NLSID FROM MGMT_METRIC_THRESHOLDS T WHERE T.TARGET_GUID = :B3 AND T.METRIC_GUID = :B2 AND T.COLL_NAME = :B1 AND T.KEY_VALUE = ' '
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hfq79bujc3zj	BEGIN LBACSYS.lbac_events.logon(dbms_standard.login_user); END;
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sydc5jyrv1t4	UPDATE MGMT_TARGETS SET LAST_LOAD_TIME = :B1 WHERE TARGET_GUID = :B2 AND (LAST_LOAD_TIME < :B1 OR LAST_LOAD_TIME IS NULL)
10xj8nynmpqtq	SELECT dbin.db_name, dbin.instance_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 = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
13ufjzvqzz68s	SELECT COUNT(A.TARGET_NAME) FROM MGMT_TARGETS A, MGMT_CURRENT_AVAILABILITY B WHERE A.TARGET_GUID = B.TARGET_GUID AND B.CURRENT_STATUS = 1 AND A.TARGET_TYPE NOT IN (:B3 , :B2 , :B1 ) AND A.LAST_LOAD_TIME < ((SYSDATE - ((TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZH'))* 60 + TO_NUMBER(TO_CHAR(SYSTIMESTAMP, 'TZM'))) / (24 * 60)) + (A.TIMEZONE_DELTA / (24 * 60))) - 1 / 12)
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))
19v5guvsgcd1v	SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECTIONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 < SYSDATE) AND C.METRIC_GUID = M.METRIC_GUID AND R.TARGET_GUID = C.TARGET_GUID AND R.METRIC_GUID = C.METRIC_GUID AND R.COLL_NAME = C.COLL_NAME
23yu0nncnp8m9	update "SYS"."AQ$_ALERT_QT_H" set transaction_id = NULL where msgid = :1 and dequeue_time is NULL
24dkx03u3rj6k	SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
2n1hu6d1pmvtw	SELECT POL# FROM LBAC$POL ORDER BY POL#
2txg6sm725mn6	INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 , NULL)
2ysccdanw72pv	update "SYS"."ALERT_QT" set q_name = :1, state = :2, time_manager_info = NULL, exception_queue = :3 where rowid = :4
30hy59nc21g04	SELECT A.pol#, nlabel, null FROM lbac$lab A, lbac$pol B WHERE B.pol# = A.pol# AND bitand(A.flags, 1)=1 AND bitand(B.flags, 1)=1 AND tag# > sys_context('LBAC$LABELS', 'LBAC$LASTSEQ') AND null >= 1 ORDER BY nlabel ASC
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
34rks4d5suuxz	SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(246060)
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3z6cvmt9w5292	SELECT /+ RULE / STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B6 , :B5 , :B4 , :B3 , :B2 ) AND STEP_TYPE=:B1 AND J.EXECUTION_TIMEOUT > 0 AND (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE)-E.START_TIME) > (J.EXECUTION_TIMEOUT/24)
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
5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
6d64jpfzqc9rv	INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )
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;
6r75f7k88qr4a	select pol#, db_labels, default_format from lbac$pol
6t7007dkc1abh	DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE
74jp9b3h4krhd	SELECT POL#, PACKAGE FROM LBAC$POL WHERE BITAND(FLAGS, 1)=1 ORDER BY PACKAGE
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
7gnakyxnvaadf	SELECT UNIQUE(TARGET_GUID) FROM MGMT_METRIC_DEPENDENCY WHERE CAN_CALCULATE = 1 AND DISABLED = 0
7s7a79nsaf4j7	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 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
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
803b7z0t84sq7	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) order by next_date, job
813qds7fub8x4	alter session set NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='., ' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8p23kcbgfqnk4	select file#, block#, ts# from seg$ where type# = 3
8sju6v7qw79jq	SELECT ROWID FROM MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B2 AND ROLLUP_TIMESTAMP < :B1
8ux370qa6pyx9	INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, sql_opcode, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, a.sql_opcode, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_add r and shdr.sample_id = a.sample_id)
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
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'
b6y9wkhxv1puz	SELECT MAX(TAG#) FROM LBAC$LAB
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bkdusjx00dsmc	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, spare2, spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1 order by i.obj#
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
c0agatqzq2jzr	insert into "SYS"."ALERT_QT" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
c8h3jdwaa532q	SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cb21bacyh3c7d	select metadata from kopm$ where name='DB_FDO'
cchx5kcx6tgmz	SELECT COUNT() FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP > (HEARTBEAT_INTERVAL4)/(246060)
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
d3apnz76qwmrs	select pol#, usr_name, usr_labels, package, privs from lbac$user_logon where usr_name = :username
d59tgwpksgs94	SELECT EMD_URL, EVENT_TYPE, OCCUR_TIME FROM MGMT_JOB_EMD_STATUS_QUEUE ORDER BY OCCUR_TIME
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
fn9zxvwfz538b	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN begin dbms_rlmgr_dr.execschdactions('RLM$SCHDNEGACTION'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
g2aqmpuqbytjy	SELECT ROWID FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B2 AND COLLECTION_TIMESTAMP < :B1
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
g337099aatnuj	update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	1,323	0.37	3.68
CPU used when call started	344	0.09	0.96
CR blocks created	51	0.01	0.14
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	337,244	93.06	936.79
DBWR checkpoint buffers written	899	0.25	2.50
DBWR checkpoints	2	0.00	0.01
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	79	0.02	0.22
DBWR undo block writes	150	0.04	0.42
IMU CR rollbacks	46	0.01	0.13
IMU Flushes	74	0.02	0.21
IMU Redo allocation size	539,596	148.89	1,498.88
IMU commits	332	0.09	0.92
IMU contention	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	1,967,576	542.93	5,465.49
IMU- failed to get a private strand	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	0	0.00	0.00
active txn count during cleanout	74	0.02	0.21
application wait time	0	0.00	0.00
background checkpoints completed	3	0.00	0.01
background checkpoints started	2	0.00	0.01
background timeouts	12,862	3.55	35.73
branch node splits	0	0.00	0.00
buffer is not pinned count	10,866	3.00	30.18
buffer is pinned count	4,153	1.15	11.54
bytes received via SQL*Net from client	0	0.00	0.00
bytes sent via SQL*Net to client	0	0.00	0.00
calls to get snapshot scn: kcmgss	10,971	3.03	30.48
calls to kcmgas	684	0.19	1.90
calls to kcmgcs	663	0.18	1.84
change write time	4	0.00	0.01
cleanout - number of ktugct calls	80	0.02	0.22
cleanouts and rollbacks - consistent read gets	46	0.01	0.13
cleanouts only - consistent read gets	0	0.00	0.00
cluster key scan block gets	3,572	0.99	9.92
cluster key scans	227	0.06	0.63
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
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	2	0.00	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	1,908	0.53	5.30
commit cleanouts successfully completed	1,906	0.53	5.29
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	17	0.00	0.05
concurrency wait time	267	0.07	0.74
consistent changes	51	0.01	0.14
consistent gets	38,587	10.65	107.19
consistent gets - examination	7,286	2.01	20.24
consistent gets direct	0	0.00	0.00
consistent gets from cache	38,587	10.65	107.19
cursor authentications	2	0.00	0.01
data blocks consistent reads - undo records applied	51	0.01	0.14
db block changes	8,666	2.39	24.07
db block gets	8,001	2.21	22.23
db block gets direct	0	0.00	0.00
db block gets from cache	8,001	2.21	22.23
deferred (CURRENT) block cleanout applications	1,074	0.30	2.98
dirty buffers inspected	0	0.00	0.00
enqueue conversions	1,936	0.53	5.38
enqueue releases	34,701	9.58	96.39
enqueue requests	34,701	9.58	96.39
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	6,797	1.88	18.88
frame signature mismatch	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	152	0.04	0.42
heap block compress	43	0.01	0.12
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	46	0.01	0.13
immediate (CURRENT) block cleanout applications	365	0.10	1.01
index fast full scans (full)	6	0.00	0.02
index fetch by key	3,292	0.91	9.14
index scans kdiixs1	4,527	1.25	12.58
leaf node 90-10 splits	9	0.00	0.03
leaf node splits	12	0.00	0.03
lob reads	0	0.00	0.00
lob writes	2	0.00	0.01
lob writes unaligned	2	0.00	0.01
logons cumulative	114	0.03	0.32
messages received	1,174	0.32	3.26
messages sent	1,174	0.32	3.26
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	23,517	6.49	65.33
opened cursors cumulative	3,294	0.91	9.15
parse count (failures)	0	0.00	0.00
parse count (hard)	0	0.00	0.00
parse count (total)	3,265	0.90	9.07
parse time cpu	3	0.00	0.01
parse time elapsed	13	0.00	0.04
physical read IO requests	136	0.04	0.38
physical read bytes	1,114,112	307.42	3,094.76
physical read total IO requests	10,989	3.03	30.53
physical read total bytes	179,958,784	49,657.30	499,885.51
physical read total multi block requests	3	0.00	0.01
physical reads	136	0.04	0.38
physical reads cache	4	0.00	0.01
physical reads cache prefetch	0	0.00	0.00
physical reads direct	132	0.04	0.37
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	891	0.25	2.48
physical write bytes	8,445,952	2,330.55	23,460.98
physical write total IO requests	10,557	2.91	29.33
physical write total bytes	162,415,104	44,816.34	451,153.07
physical write total multi block requests	444	0.12	1.23
physical writes	1,031	0.28	2.86
physical writes direct	132	0.04	0.37
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	899	0.25	2.50
physical writes non checkpoint	158	0.04	0.44
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	34,290	9.46	95.25
recursive cpu usage	425	0.12	1.18
redo blocks read for recovery	0	0.00	0.00
redo blocks written	3,623	1.00	10.06
redo buffer allocation retries	0	0.00	0.00
redo entries	3,342	0.92	9.28
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	6	0.00	0.02
redo size	1,776,368	490.17	4,934.36
redo synch time	122	0.03	0.34
redo synch writes	1,005	0.28	2.79
redo wastage	122,336	33.76	339.82
redo write time	548	0.15	1.52
redo writer latching time	0	0.00	0.00
redo writes	482	0.13	1.34
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	5	0.00	0.01
rows fetched via callback	1,785	0.49	4.96
session connect time	0	0.00	0.00
session cursor cache hits	708	0.20	1.97
session logical reads	46,588	12.86	129.41
session pga memory	89,866,224	24,797.42	249,628.40
session pga memory max	99,303,408	27,401.49	275,842.80
session uga memory	###############	68,739,130.04	691,976,773.24
session uga memory max	80,911,784	22,326.56	224,754.96
shared hash latch upgrades - no wait	4,798	1.32	13.33
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	1,939	0.54	5.39
sorts (rows)	20,121	5.55	55.89
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	61	0.02	0.17
table fetch by rowid	3,821	1.05	10.61
table fetch continued row	0	0.00	0.00
table scan blocks gotten	12,648	3.49	35.13
table scan rows gotten	263,795	72.79	732.76
table scans (long tables)	0	0.00	0.00
table scans (short tables)	1,400	0.39	3.89
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	629,376	173.67	1,748.27
user I/O wait time	101	0.03	0.28
user calls	342	0.09	0.95
user commits	360	0.10	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	942	0.26	2.62
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
session cursor cache count	7,454,467	7,455,755
opened cursors current	79	79
logons current	22	22

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	1.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes
SYSAUX	7	5.71	1.00	536
PS	90	8.00	1.00	90
UNDOTBS1	3	0.00	1.00	165
SYSTEM	3	0.00	1.00	67
DB2	30	9.00	1.00	30
USERS	3	0.00	1.00	3

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes
DB2	/oradata/ora10g/db2_01.dbf	3	26.67	1.00	3
DB2	/oradata/ora10g/db2_02.dbf	3	3.33	1.00	3
DB2	/oradata/ora10g/db2_03.dbf	3	6.67	1.00	3
DB2	/oradata/ora10g/db2_04.dbf	3	10.00	1.00	3
DB2	/oradata/ora10g/db2_05.dbf	3	23.33	1.00	3
DB2	/oradata/ora10g/db2_06.dbf	3	3.33	1.00	3
DB2	/oradata/ora10g/db2_07.dbf	3	10.00	1.00	3
DB2	/oradata/ora10g/db2_08.dbf	3	6.67	1.00	3
DB2	/oradata/ora10g/db2_09.dbf	3	0.00	1.00	3
DB2	/oradata/ora10g/db2_10.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_01.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_02.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_03.dbf	3	6.67	1.00	3
PS	/oradata/ora10g/ps_04.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_05.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_06.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_07.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_08.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_09.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_10.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_11.dbf	3	20.00	1.00	3
PS	/oradata/ora10g/ps_12.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_13.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_14.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_15.dbf	3	13.33	1.00	3
PS	/oradata/ora10g/ps_16.dbf	3	10.00	1.00	3
PS	/oradata/ora10g/ps_17.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_18.dbf	3	10.00	1.00	3
PS	/oradata/ora10g/ps_19.dbf	3	10.00	1.00	3
PS	/oradata/ora10g/ps_20.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_21.dbf	3	23.33	1.00	3
PS	/oradata/ora10g/ps_22.dbf	3	96.67	1.00	3
PS	/oradata/ora10g/ps_23.dbf	3	6.67	1.00	3
PS	/oradata/ora10g/ps_24.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_25.dbf	3	13.33	1.00	3
PS	/oradata/ora10g/ps_26.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_27.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_28.dbf	3	30.00	1.00	3
PS	/oradata/ora10g/ps_29.dbf	3	0.00	1.00	3
PS	/oradata/ora10g/ps_30.dbf	3	0.00	1.00	3
SYSAUX	/oradata/ora10g/sysaux01.dbf	7	5.71	1.00	536
SYSTEM	/oradata/ora10g/system01.dbf	3	0.00	1.00	67
UNDOTBS1	/oradata/ora10g/undotbs01.dbf	3	0.00	1.00	165
USERS	/oradata/ora10g/users01.dbf	3	0.00	1.00	3

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	277,750	100	46,502	4	899	0	0	0

Advisory Statistics

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

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	36	187	649	1089	184320	1089
E	0	36	250	824	1287	184320	1287

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	224	0.10	27,776	2.53	112,554,513
D	448	0.20	55,552	1.93	85,992,974
D	672	0.30	83,328	1.48	66,088,607
D	896	0.40	111,104	1.19	52,855,477
D	1,120	0.50	138,880	1.08	47,922,647
D	1,344	0.60	166,656	1.05	46,664,355
D	1,568	0.70	194,432	1.04	46,088,685
D	1,792	0.80	222,208	1.02	45,515,739
D	2,016	0.90	249,984	1.01	44,986,429
D	2,240	1.00	277,760	1.00	44,507,482
D	2,464	1.10	305,536	0.99	43,980,174
D	2,688	1.20	333,312	0.96	42,707,429
D	2,912	1.30	361,088	0.91	40,700,310
D	3,136	1.40	388,864	0.84	37,472,200
D	3,360	1.50	416,640	0.74	33,103,144
D	3,584	1.60	444,416	0.46	20,485,707
D	3,808	1.70	472,192	0.21	9,312,837
D	4,032	1.80	499,968	0.15	6,687,190
D	4,256	1.90	527,744	0.14	6,411,529
D	4,480	2.00	555,520	0.12	5,335,621

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	882	55	2,076.73	0.00	0.00	0.00	0.00	102,400
E	882	55	2,077.23	0.00	0.00	0.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	915	915
64K	128K	3	3
512K	1024K	20	20
1M	2M	4	4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
110	0.13	142,037.97	14,602.25	91.00	2,014
221	0.25	142,037.97	13,775.69	91.00	1,888
441	0.50	142,037.97	12,025.16	92.00	1,632
662	0.75	142,037.97	10,409.86	93.00	1,416
882	1.00	142,037.97	0.00	100.00	1,197
1,058	1.20	142,037.97	0.00	100.00	977
1,235	1.40	142,037.97	0.00	100.00	759
1,411	1.60	142,037.97	0.00	100.00	606
1,588	1.80	142,037.97	0.00	100.00	417
1,764	2.00	142,037.97	0.00	100.00	243
2,646	3.00	142,037.97	0.00	100.00	0
3,528	4.00	142,037.97	0.00	100.00	0
5,292	6.00	142,037.97	0.00	100.00	0
7,056	8.00	142,037.97	0.00	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
224	0.61	54	5,343	147,270	1.00	5,279	1.09	45,957,086
272	0.74	100	8,358	147,434	1.00	5,115	1.06	46,024,791
320	0.87	144	11,105	147,583	1.00	4,966	1.03	46,087,513
368	1.00	191	14,569	147,726	1.00	4,823	1.00	46,147,843
416	1.13	238	18,860	147,868	1.00	4,681	0.97	46,207,147
464	1.26	285	23,940	148,009	1.00	4,540	0.94	46,265,876
512	1.39	332	28,028	148,150	1.00	4,399	0.91	46,324,087
560	1.52	379	31,211	148,290	1.00	4,259	0.88	46,381,795
608	1.65	426	34,478	148,428	1.00	4,121	0.85	46,438,853
656	1.78	473	37,719	148,564	1.01	3,985	0.83	46,495,346
704	1.91	520	41,142	148,700	1.01	3,849	0.80	46,551,478
752	2.04	567	44,614	148,836	1.01	3,713	0.77	46,607,371

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
664	0.25	834,420	113,903,548
1,328	0.50	360,440	53,489,092
1,992	0.75	302,783	46,060,793
2,656	1.00	290,607	44,507,482
3,320	1.25	281,889	43,221,216
3,984	1.50	281,773	37,920,375
4,648	1.75	281,773	9,426,685
5,312	2.00	281,773	5,398,758

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	0.13	683	0	3	5760/5760	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
25-Mar 17:02	57	146	3	5,760	0/0	0/0/0/0/0/0
25-Mar 16:52	8	72	3	5,760	0/0	0/0/0/0/0/0
25-Mar 16:42	7	83	1	5,760	0/0	0/0/0/0/0/0
25-Mar 16:32	5	57	1	5,760	0/0	0/0/0/0/0/0
25-Mar 16:22	7	130	1	5,760	0/0	0/0/0/0/0/0
25-Mar 16:12	3	61	1	5,760	0/0	0/0/0/0/0/0
25-Mar 16:02	42	134	3	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	14,494	0.00		0
Consistent RBA	484	0.00		0
FAL request queue	76	0.00		0
FAL subheap alocation	76	0.00		0
FIB s.o chain latch	36	0.00		0
FOB s.o list latch	136	0.00		0
In memory undo latch	5,264	0.00		1,349	0.00
JS mem alloc latch	8	0.00		0
JS queue access latch	8	0.00		0
JS queue state obj latch	26,170	0.00		0
JS slv state obj latch	172	0.00		0
KMG MMAN ready and startup request latch	1,208	0.00		0
KTF sga latch	7	0.00		1,080	0.00
KWQMN job cache list latch	250	0.00		0
LGWR NS Write	76	0.00		0
MQL Tracking Latch	0			73	0.00
Memory Management Latch	0			1,208	0.00
OS process	504	0.00		0
OS process allocation	1,544	0.00		0
OS process: request allocation	112	0.00		0
PL/SQL warning settings	295	0.00		0
SQL memory manager latch	1	0.00		1,202	0.00
SQL memory manager workarea list latch	81,233	0.00		0
Shared B-Tree	129	0.00		0
active checkpoint queue latch	3,187	0.00		0
active service list	7,742	0.00		1,216	0.00
alert log latch	24	0.00		0
archive control	202	0.00		0
archive process latch	1,278	0.00		0
cache buffer handles	12	0.00		0
cache buffers chains	113,292	0.00		92	0.00
cache buffers lru chain	2,819	0.00		182	0.00
channel handle pool latch	112	0.00		0
channel operations parent latch	17,175	0.00		0
checkpoint queue latch	203,526	0.00		897	0.00
client/application info	1,520	0.00		0
commit callback allocation	216	0.00		0
compile environment latch	251	0.00		0
dml lock allocation	2,887	0.00		0
dummy allocation	228	0.00		0
enqueue hash chains	71,301	0.00	0.00	128	0.00
enqueues	65,331	0.00	0.00	0
event group latch	56	0.00		0
file cache latch	122	0.00		0
hash table column usage latch	6	0.00		0
hash table modification latch	62	0.00		0
instance information	116	0.00		0
job workq parent latch	0			116	0.00
job_queue_processes parameter latch	118	0.00		0
ksuosstats global area	243	0.00		0
ktm global data	12	0.00		0
kwqbsn:qsga	129	0.00		0
lgwr LWN SCN	1,395	0.00		0
library cache	40,635	0.00		0
library cache lock	19,630	0.00		0
library cache lock allocation	1,560	0.00		0
library cache pin	25,156	0.00		0
library cache pin allocation	616	0.00		0
list of block allocation	135	0.00		0
loader state object freelist	36	0.00		0
messages	28,608	0.00		0
mostly latch-free SCN	1,396	0.07	0.00	0
ncodef allocation latch	57	0.00		0
object queue header operation	3,020	0.00		0
object stats modification	1	0.00		0
parallel query alloc buffer	480	0.00		0
parameter table allocation management	116	0.00		0
policy information	1,218	0.00		0
post/wait queue	308	0.00		86	0.00
process allocation	112	0.00		56	0.00
process group creation	112	0.00		0
qmn task queue latch	516	0.00		0
redo allocation	6,186	0.00		3,268	0.00
redo copy	0			3,268	0.00
redo writing	7,154	0.01	0.00	0
resmgr group change latch	310	0.00		0
resmgr:actses active list	225	0.00		0
resmgr:actses change group	58	0.00		0
resmgr:free threads list	224	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	12,045	0.00		0
rules engine aggregate statistics	62	0.00		0
rules engine rule set statistics	124	0.00		0
sequence cache	109	0.00		0
session allocation	4,214	0.00		0
session idle bit	821	0.00		0
session state list latch	464	0.00		0
session switching	57	0.00		0
session timer	1,216	0.00		0
shared pool	6,706	0.00		0
simulator hash latch	3,684	0.00		0
simulator lru latch	3,543	0.00		135	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	87	0.00		0
state object free list	2	0.00		0
statistics aggregation	140	0.00		0
threshold alerts latch	331	0.00		0
transaction allocation	131	0.00		0
transaction branch allocation	57	0.00		0
undo global data	5,641	0.00		0
user lock	116	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
slave class create	8	1	1	0	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	NoWait Misses	Sleeps	Waiter Sleeps
slave class create	ksvcreate	0	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 46,588
Captured Segments account for 78.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	TAB$	TABLE	6,208	13.33
SYS	SYSTEM	SMON_SCN_TIME	TABLE	3,328	7.14
SYS	SYSTEM	SEG$	TABLE	2,992	6.42
SYS	SYSTEM	RECYCLEBIN$_TS	INDEX	2,656	5.70
SYS	SYSTEM	JOB$	TABLE	2,416	5.19

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 136
Captured Segments account for 2.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	ALERT_QT		TABLE	3	2.21
SYS	SYSAUX	SYS_IOT_TOP_8803		INDEX	1	0.74

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_global_oids	405	0.00	0	54
dc_object_ids	380	0.00	0	1,279
dc_objects	432	0.00	5	6,405
dc_profiles	60	0.00	0	1
dc_rollback_segments	631	0.00	0	20
dc_segments	50	0.00	3	5,737
dc_sequences	2	0.00	2	8
dc_tablespaces	467	0.00	0	8
dc_usernames	366	0.00	0	18
dc_users	944	0.00	0	41
outstanding_alerts	162	18.52	62	15

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pin Requests
BODY	790	1,053
TABLE/PROCEDURE	166	1,691
TRIGGER	68	218

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

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	2,056.45		85.69	390.37	1,918	1,918	24	24
	Freeable	19.38	0.00	1.49	1.50	5		13	13
	SQL	0.59	0.31	0.05	0.05	0	23	13	10
	PL/SQL	0.32	0.13	0.01	0.02	0	0	22	22
E	Other	2,056.83		85.70	390.45	1,918	1,918	24	24
	Freeable	19.50	0.00	1.50	1.50	5		13	13
	SQL	0.58	0.31	0.04	0.05	0	23	13	10
	PL/SQL	0.32	0.13	0.01	0.02	0	0	22	22

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,348,810,240
Fixed Size	2,023,472
Redo Buffers	14,749,696
Variable Size	419,434,448

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	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	17.29	17.29	0.00
shared	Heap0: KGL	11.39	11.39	0.00
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGH: NO ACCESS	15.95	15.95	0.00
shared	KGLS heap	16.53	16.53	0.00
shared	KQR L PO	6.28	6.28	0.00
shared	KQR M PO	5.19	5.19	0.00
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	PCursor	7.95	7.95	0.00
shared	PL/SQL MPCODE	3.95	3.95	0.00
shared	db_block_hash_buckets	16.81	16.81	0.00
shared	free memory	84.90	84.90	-0.00
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	kglsim heap	5.14	5.14	0.00
shared	kglsim object batch	4.32	4.32	0.00
shared	library cache	33.62	33.62	0.00
shared	private strands	4.54	4.54	0.00
shared	row cache	7.13	7.13	0.00
shared	sql area	50.46	50.46	0.00
	buffer_cache	2,240.00	2,240.00	0.00
	fixed_sga	1.93	1.93	0.00
	log_buffer	14.07	14.07	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_kgl_large_heap_warning_threshold	20480000
archive_lag_target	1800
audit_file_dest	/oracle/app/oracle/admin/ora10g/adump
background_dump_dest	/oracle/app/oracle/admin/ora10g/bdump
compatible	10.2.0.1.0
control_files	/oradata/ora10g/control01.ctl, /oradata/ora10g/control02.ctl, /oradata/ora10g/control03.ctl
core_dump_dest	/oracle/app/oracle/admin/ora10g/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	ora10g
db_recovery_file_dest	/oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=ora10gXDB)
job_queue_processes	10
log_archive_dest_1	LOCATION=/oradata/arch
log_archive_dest_2	SERVICE=STANDBY SYNC LGWR AFFIRM NET_TIMEOUT=10
log_archive_dest_state_2	ENABLE
log_archive_format	arch_%t_%s_%r.arc
open_cursors	300
pga_aggregate_target	924844032
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	2785017856
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/app/oracle/admin/ora10g/udump

End of Report

% Blocks changed per Read:	18.60	Recursive Call %:	99.01
Rollback per transaction %:	0.00	Rows per Sort:	10.38

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	100.00	Soft Parse %:	100.00
Execute to Parse %:	51.96	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	23.08	% Non-Parse CPU:	98.45