WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

HGMSUP 165868252 hgmsup 1 10.2.0.1.0 NO ZHUBAO-246

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
HGMSUP	165868252	hgmsup	1	10.2.0.1.0	NO	ZHUBAO-246

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 16 30-Jan-15 10:00:54 30 9.4

End Snap: 17 30-Jan-15 11:00:34 82 3.6

Elapsed: 59.65 (mins)

DB Time: 0.32 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16	30-Jan-15 10:00:54	30	9.4
End Snap:	17	30-Jan-15 11:00:34	82	3.6
Elapsed:		59.65 (mins)
DB Time:		0.32 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,024M 1,024M Std Block Size: 8K

Shared Pool Size: 360M 360M Log Buffer: 4,160K

	Begin	End
Buffer Cache:	1,024M	1,024M	Std Block Size:	8K
Shared Pool Size:	360M	360M	Log Buffer:	4,160K

Load Profile

Per Second Per Transaction

Redo size: 571.53 3,508.81

Logical reads: 14.89 91.44

Block changes: 2.90 17.81

Physical reads: 0.00 0.00

Physical writes: 0.41 2.49

User calls: 1.94 11.89

Parses: 1.30 7.96

Hard parses: 0.05 0.30

Sorts: 0.69 4.21

Logons: 0.05 0.32

Executes: 3.69 22.65

Transactions: 0.16

	Per Second	Per Transaction
Redo size:	571.53	3,508.81
Logical reads:	14.89	91.44
Block changes:	2.90	17.81
Physical reads:	0.00	0.00
Physical writes:	0.41	2.49
User calls:	1.94	11.89
Parses:	1.30	7.96
Hard parses:	0.05	0.30
Sorts:	0.69	4.21
Logons:	0.05	0.32
Executes:	3.69	22.65
Transactions:	0.16

% Blocks changed per Read: 19.47 Recursive Call %: 86.66

Rollback per transaction %: 5.49 Rows per Sort: 15.04

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.44 Soft Parse %: 96.21

Execute to Parse %: 64.84 Latch Hit %: 99.91

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

Shared Pool Statistics

Begin End

Memory Usage %: 68.52 69.24

% SQL with executions>1: 98.10 97.28

% Memory for SQL w/exec>1: 97.09 95.63

	Begin	End
Memory Usage %:	68.52	69.24
% SQL with executions>1:	98.10	97.28
% Memory for SQL w/exec>1:	97.09	95.63

Top 5 Timed Events

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

CPU time 17 88.5

control file sequential read 2,344 3 1 15.9 System I/O

SQL*Net more data from client 14 1 92 6.8 Network

os thread startup 55 0 6 1.6 Concurrency

control file parallel write 1,193 0 0 1.3 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		17		88.5
control file sequential read	2,344	3	1	15.9	System I/O
SQL*Net more data from client	14	1	92	6.8	Network
os thread startup	55	0	6	1.6	Concurrency
control file parallel write	1,193	0	0	1.3	System I/O

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): 19s
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	16.82	88.48
sql execute elapsed time	15.95	83.87
PL/SQL execution elapsed time	11.51	60.56
parse time elapsed	0.43	2.27
connection management call elapsed time	0.25	1.29
hard parse elapsed time	0.23	1.22
hard parse (sharing criteria) elapsed time	0.12	0.66
PL/SQL compilation elapsed time	0.00	0.02
repeated bind elapsed time	0.00	0.01
sequence load elapsed time	0.00	0.01
DB time	19.01
background elapsed time	4.22
background cpu time	2.72

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	5,462	3	1	9.37
Network	6,134	1	0	10.52
Concurrency	62	0	5	0.11
User I/O	20	0	11	0.03
Application	310	0	0	0.53
Commit	236	0	0	0.40
Other	1	0	5	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 sequential read	2,344	0.00	3	1	4.02
SQL*Net more data from client	14	0.00	1	92	0.02
os thread startup	55	0.00	0	6	0.09
control file parallel write	1,193	0.00	0	0	2.05
db file sequential read	20	0.00	0	11	0.03
db file parallel write	1,011	0.00	0	0	1.73
log file parallel write	914	0.00	0	0	1.57
SQL*Net break/reset to client	310	0.00	0	0	0.53
log file sync	236	0.00	0	0	0.40
SQL*Net message to client	6,028	0.00	0	0	10.34
latch free	1	0.00	0	5	0.00
SQL*Net more data to client	92	0.00	0	0	0.16
latch: library cache	4	0.00	0	0	0.01
cursor: mutex X	3	0.00	0	0	0.01
SQL*Net message from client	5,977	0.00	21,889	3662	10.25
Streams AQ: waiting for messages in the queue	716	99.72	3,568	4984	1.23
wait for unread message on broadcast channel	3,569	99.94	3,567	1000	6.12
virtual circuit status	119	100.00	3,565	29954	0.20
Streams AQ: qmn slave idle wait	127	0.00	3,555	27989	0.22
Streams AQ: qmn coordinator idle wait	256	50.39	3,555	13885	0.44
jobq slave wait	1,107	99.64	3,315	2995	1.90
Streams AQ: waiting for time management or cleanup tasks	15	73.33	2,296	153100	0.03
class slave wait	2	100.00	10	4999	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file sequential read	1,024	0.00	2	1	1.76
os thread startup	55	0.00	0	6	0.09
control file parallel write	1,193	0.00	0	0	2.05
db file parallel write	1,011	0.00	0	0	1.73
log file parallel write	914	0.00	0	0	1.57
rdbms ipc message	13,619	93.90	41,460	3044	23.36
pmon timer	1,218	100.00	3,577	2937	2.09
Streams AQ: qmn slave idle wait	127	0.00	3,555	27989	0.22
Streams AQ: qmn coordinator idle wait	256	50.39	3,555	13885	0.44
smon timer	13	84.62	3,508	269815	0.02
Streams AQ: waiting for time management or cleanup tasks	15	73.33	2,296	153100	0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	2,684
AVG_IDLE_TIME	355,014
AVG_SYS_TIME	823
AVG_USER_TIME	1,745
BUSY_TIME	44,802
IDLE_TIME	5,681,997
SYS_TIME	14,993
USER_TIME	29,809
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	65,536
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	17,168,797,696
NUM_CPUS	16
NUM_CPU_CORES	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads
HGMSUP	13.10	12.40	23,780
SYS$USERS	5.90	4.40	19,593
HGMSUPXDB	0.00	0.00	0
SYS$BACKGROUND	0.00	0.00	9,506

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	Network Total Wts	Network Wt Time
HGMSUP	0	0	0	0	4433	129
SYS$USERS	16	16	7	0	1485	1
SYS$BACKGROUND	4	5	55	30	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

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
11	10	118	0.09	57.33	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
1	0	12	0.10	6.24	gz6qtapr9u99d	emagent.exe	/* OracleOEM */ DECLARE l_l...
1	0	12	0.07	4.59	2nkzun1gy8zm8	emagent.exe	SELECT (100 - sum(percent_spac...
1	0	55	0.01	3.33	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1	1	1,200	0.00	3.18	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
0	0	12	0.02	1.21	51vw8qf5uprrv	emagent.exe	SELECT LOG_MODE, FLASHBACK_ON...
0	0	4	0.05	1.06	a73yth55sy3qd	emagent.exe	/* OracleOEM */ DECLARE l_m...
0	0	4	0.05	0.96	gpv3kb4n2f2q1	emagent.exe	SELECT COUNT(FILE#) FROM V$DAT...
0	0	24	0.01	0.89	35rqnp0hn3p3j	OEM.SystemPool	INSERT INTO mgmt_ha_mttr(COLLE...
0	0	60	0.00	0.70	cydnuss99swtd	OEM.SystemPool	BEGIN EM_PING.RECORD_BATCH_HEA...

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
10	11	118	0.09	57.33	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
1	1	1,200	0.00	3.18	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
0	1	55	0.00	3.33	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	24	0.01	0.89	35rqnp0hn3p3j	OEM.SystemPool	INSERT INTO mgmt_ha_mttr(COLLE...
0	1	12	0.01	6.24	gz6qtapr9u99d	emagent.exe	/* OracleOEM */ DECLARE l_l...
0	0	60	0.00	0.70	cydnuss99swtd	OEM.SystemPool	BEGIN EM_PING.RECORD_BATCH_HEA...
0	0	32	0.00	0.69	7gtztzv329wg0		select c.name, u.name from co...
0	0	58	0.00	0.67	8hk7xvhua40va	OEM.SystemPool	INSERT INTO MGMT_METRICS_RAW(C...
0	0	1	0.12	0.64	f9tkk3w2wuv38	PL/SQL Developer	declare t_owner varchar2(30...
0	0	43	0.00	0.54	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
0	1	12	0.00	4.59	2nkzun1gy8zm8	emagent.exe	SELECT (100 - sum(percent_spac...
0	0	12	0.00	1.21	51vw8qf5uprrv	emagent.exe	SELECT LOG_MODE, FLASHBACK_ON...
0	0	4	0.00	1.06	a73yth55sy3qd	emagent.exe	/* OracleOEM */ DECLARE l_m...

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: 53,312
Captured SQL account for 70.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
9,843	55	178.96	18.46	0.23	0.63	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
4,800	1,200	4.00	9.00	0.60	0.60	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
3,744	32	117.00	7.02	0.13	0.13	7gtztzv329wg0		select c.name, u.name from co...
3,741	58	64.50	7.02	0.13	0.13	8hk7xvhua40va	OEM.SystemPool	INSERT INTO MGMT_METRICS_RAW(C...
3,558	252	14.12	6.67	0.07	0.07	0h6b2sajwb74n		select privilege#, level from ...
3,304	118	28.00	6.20	10.30	10.90	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
3,096	24	129.00	5.81	0.17	0.17	35rqnp0hn3p3j	OEM.SystemPool	INSERT INTO mgmt_ha_mttr(COLLE...
2,555	60	42.58	4.79	0.13	0.13	cydnuss99swtd	OEM.SystemPool	BEGIN EM_PING.RECORD_BATCH_HEA...
2,452	751	3.26	4.60	0.05	0.05	91h2x42zqagcm		UPDATE MGMT_CURRENT_METRICS SE...
2,148	716	3.00	4.03	0.07	0.07	803b7z0t84sq7		select job, nvl2(last_date, ...
2,147	43	49.93	4.03	0.10	0.10	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
1,200	1,200	1.00	2.25	0.06	0.06	6gh8gj9n09vr7	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
1,144	143	8.00	2.15	0.03	0.03	6129566gyvx21	OEM.SystemPool	SELECT INSTANTIABLE, supertyp...
1,108	150	7.39	2.08	0.02	0.02	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
1,040	8	130.00	1.95	0.06	0.06	4vvuzs84f1mvr	OEM.SystemPool	INSERT INTO mgmt_db_hdm_metric...
1,003	59	17.00	1.88	0.05	0.05	8ktuh6payfpmy	OEM.SystemPool	UPDATE MGMT_AVAILABILITY_MARKE...
824	8	103.00	1.55	0.01	0.01	d8mayxqw0wnpv	SQL*Plus	SELECT OWNER FROM DBA_PROCEDUR...
783	1	783.00	1.47	0.05	0.05	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
732	134	5.46	1.37	0.02	0.02	0k8522rmdzg4k		select privilege# from sysauth...
721	66	10.92	1.35	0.02	0.02	6d64jpfzqc9rv		INSERT INTO MGMT_METRICS_RAW (...
661	661	1.00	1.24	0.04	0.04	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
550	55	10.00	1.03	0.01	0.01	8bgj359xdaz28	EM_PING	UPDATE MGMT_EMD_PING SET LAST_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 1
Captured SQL account for 0.0% of Total

Executions	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6	0.07	0.07	035rdsw0h9hfk	SQL*Plus	SELECT /*+ opt_param('parallel...
5	0.00	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
1,255	0.04	0.04	089dbukv1aanh	SQL*Plus	SELECT SYS_EXTRACT_UTC(SYSTIME...
1	0.00	0.00	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
252	0.07	0.07	0h6b2sajwb74n		select privilege#, level from ...
134	0.02	0.02	0k8522rmdzg4k		select privilege# from sysauth...
75	0.02	0.02	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
2	0.00	0.00	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...
1	0.04	0.04	13u83qfzhh56a	PL/SQL Developer	SELECT S.TABLE_OWNER, S.TABLE...
1	0.00	0.00	14566d856s6hs		SELECT owner# FROM sys.wri$_ad...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 13,204
Captured SQL account for 68.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
1,255	1,255	1.00	089dbukv1aanh	SQL*Plus	SELECT SYS_EXTRACT_UTC(SYSTIME...
1,200	0	0.00	6gh8gj9n09vr7	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
1,200	1,200	1.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
751	751	1.00	91h2x42zqagcm		UPDATE MGMT_CURRENT_METRICS SE...
716	55	0.08	803b7z0t84sq7		select job, nvl2(last_date, ...
661	661	1.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
252	2,998	11.90	0h6b2sajwb74n		select privilege#, level from ...
173	173	1.00	444ygb1fcndkz		SELECT STRING_VALUE FROM MGMT_...
170	170	1.00	24dkx03u3rj6k		SELECT COUNT(*) FROM MGMT_PARA...
153	153	1.00	5kyb5bvnu3s04		SELECT DISTINCT METRIC_GUID FR...
150	150	1.00	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
143	143	1.00	6129566gyvx21	OEM.SystemPool	SELECT INSTANTIABLE, supertyp...
134	252	1.88	0k8522rmdzg4k		select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 4,643
Captured SQL account for 56.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
251	252	5.41	0h6b2sajwb74n		select privilege#, level from ...
143	143	3.08	6129566gyvx21	OEM.SystemPool	SELECT INSTANTIABLE, supertyp...
134	134	2.89	0k8522rmdzg4k		select privilege# from sysauth...
118	118	2.54	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
116	116	2.50	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
116	116	2.50	g00cj285jmgsw		update sys.mon_mods$ set inser...
110	170	2.37	24dkx03u3rj6k		SELECT COUNT(*) FROM MGMT_PARA...
75	75	1.62	459f3z9u4fb3u		select value$ from props$ wher...
75	75	1.62	5ur69atw3vfhj		select decode(failover_method,...
74	75	1.59	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
61	61	1.31	9ur12dtztw3rx	OEM.BoundedPool	SELECT TARGET_GUID, DELETE_RE...
61	61	1.31	d33xszqrpzu17	OEM.BoundedPool	SELECT TARGET_GUID, DETECTION...
60	60	1.29	cydnuss99swtd	OEM.SystemPool	BEGIN EM_PING.RECORD_BATCH_HEA...
56	150	1.21	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
55	1,255	1.18	089dbukv1aanh	SQL*Plus	SELECT SYS_EXTRACT_UTC(SYSTIME...
55	55	1.18	19v5guvsgcd1v		SELECT C.TARGET_GUID, C.METRI...
55	55	1.18	1f12gkkf27m3z	EM_PING	SELECT TGT.TARGET_GUID, TGT.E...
55	55	1.18	34rks4d5suuxz	EM_PING	SELECT COUNT(FAILOVER_ID) FROM...
55	55	1.18	3z6cvmt9w5292	EM_PING	SELECT /+ RULE / STEP_ID FRO...
55	55	1.18	47a50dvdgnxc2		update sys.job$ set failures=0...
55	55	1.18	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
55	55	1.18	6t7007dkc1abh	EM_PING	DELETE FROM MGMT_JOB_EMD_STATU...
55	55	1.18	7gnakyxnvaadf	SEVERITY EVALUATION	SELECT UNIQUE(TARGET_GUID) FRO...
55	55	1.18	7s7a79nsaf4j7		select u1.user#, u2.user#, u...
55	55	1.18	8bgj359xdaz28	EM_PING	UPDATE MGMT_EMD_PING SET LAST_...
55	55	1.18	aq8yqxyyb40nn		update sys.job$ set this_date=...
55	55	1.18	c8h3jdwaa532q	EM_PING	SELECT TO_NUMBER(PARAMETER_VAL...
55	55	1.18	cchx5kcx6tgmz	EM_PING	SELECT COUNT(*) FROM MGMT_FAIL...
55	55	1.18	d59tgwpksgs94	EM_PING	SELECT EMD_URL, EVENT_TYPE, ...
55	55	1.18	dwssdqx28tzf5		select sysdate + 1 / (24 * 60)...
48	48	1.03	3nz260v5dwqnv	PL/SQL Developer	select value from v$sesstat wh...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

035rdsw0h9hfk SELECT /*+ opt_param('parallel_execution_enabled', 'false') */ extractvalue(xmlval, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "outline"]'), extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'), extractvalue(xmlval, '/*/info[@type = "index_size"]'), extractvalue(xmlval, '/*/info[@type = "plan_hash"]') from (select xmltype(:v_other_xml) xmlval from dual)

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

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'

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

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

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

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

13u83qfzhh56a SELECT S.TABLE_OWNER, S.TABLE_NAME FROM SYS.ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1

14566d856s6hs SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1

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

1f12gkkf27m3z SELECT TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PING.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL

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

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

2nkzun1gy8zm8 SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage

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

35rqnp0hn3p3j INSERT INTO mgmt_ha_mttr(COLLECTION_TIMESTAMP, ESTIMATED_MTTR, TARGET_GUID) VALUES ( :1, :2, :3)

3nz260v5dwqnv select value from v$sesstat where sid = :sid order by statistic#

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)

444ygb1fcndkz SELECT STRING_VALUE FROM MGMT_CURRENT_METRICS WHERE TARGET_GUID = :B3 AND METRIC_GUID = :B2 AND KEY_VALUE = :B1

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

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

4vvuzs84f1mvr INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE) VALUES ( :1, :2, :3)

51vw8qf5uprrv SELECT LOG_MODE, FLASHBACK_ON FROM V$DATABASE

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

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

6129566gyvx21 SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2

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

6gh8gj9n09vr7 SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :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;

6t7007dkc1abh DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE

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

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

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

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

8bgj359xdaz28 UPDATE MGMT_EMD_PING SET LAST_CHECKED_UTC = :B1 WHERE MAX_INACTIVE_TIME > 0 AND ( (STATUS = :B3 ) OR (STATUS = :B2 ) ) AND (:B1 - LAST_CHECKED_UTC)*24*60*60 >= (MAX_INACTIVE_TIME)/2

8hk7xvhua40va INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

8ktuh6payfpmy UPDATE MGMT_AVAILABILITY_MARKER SET MARKER_TIMESTAMP = :B1 WHERE MARKER_TIMESTAMP <= :B1 AND TARGET_GUID IN (SELECT T.TARGET_GUID FROM MGMT_TARGETS T WHERE T.EMD_URL = :B2 AND T.REP_SIDE_AVAIL = 0 AND NOT EXISTS (SELECT 1 FROM MGMT_BLACKOUT_WINDOWS BW WHERE BW.TARGET_GUID = T.TARGET_GUID AND BW.START_TIME <= :B1 AND (BW.END_TIME > :B1 OR BW.END_TIME IS NULL) ) AND NOT EXISTS (SELECT 1 FROM MGMT_BCN_AVAIL_DEF BCNAV WHERE BCNAV.TARGET_GUID = T.TARGET_GUID) )

91h2x42zqagcm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3

9ur12dtztw3rx SELECT TARGET_GUID, DELETE_REQUEST_TIME, DELETE_COMPLETE_TIME FROM MGMT_TARGETS_DELETE DEL WHERE EMD_URL = :B1 OR EXISTS (SELECT 1 FROM MGMT_TARGET_AGENT_ASSOC WHERE TARGET_GUID = DEL.TARGET_GUID AND AGENT_GUID = :B2 )

a73yth55sy3qd /* OracleOEM */ DECLARE l_missing_media_files NUMBER; l_corrupt_data_blocks NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_92 CONSTANT VARCHAR2(10) := '09.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Missing Media Files SELECT count(file#) INTO l_missing_media_files FROM v$datafile_header WHERE recover ='YES' OR error is not null; -- Corrupt Data Blocks (9iR2 or higher) l_corrupt_data_blocks := NULL; IF (v_db_version >= db_version_92) THEN EXECUTE IMMEDIATE 'SELECT count(unique(file#)) FROM v$database_block_corruption' INTO l_corrupt_data_blocks; END IF; OPEN data_cursor FOR SELECT l_missing_media_files, l_corrupt_data_blocks from dual; :1 := data_cursor; END;

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

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

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

cb75rw3w1tt0s begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

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

cydnuss99swtd BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;

d33xszqrpzu17 SELECT TARGET_GUID, DETECTION_TIME, RESOLVED_TIME FROM MGMT_DUPLICATE_TARGETS WHERE DUPLICATE_EMD_URL = :B1

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

d8mayxqw0wnpv SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'

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

dwssdqx28tzf5 select sysdate + 1 / (24 * 60) from dual

f9tkk3w2wuv38 declare t_owner varchar2(30); t_name varchar2(30); procedure check_mview is dummy integer; begin if :object_type = 'TABLE' then select 1 into dummy from sys.all_objects where owner = :object_owner and object_name = :object_name and object_type = 'MATERIALIZED VIEW' and rownum = 1; :object_type := 'MATERIALIZED VIEW'; end if; exception when others then null; end; begin :sub_object := null; if :deep != 0 then begin if :part2 is null then select constraint_type, owner, constraint_name into :object_type, :object_owner, :object_name from sys.all_constraints c where c.constraint_name = :part1 and c.owner = user and rownum = 1; else select constraint_type, owner, constraint_name, :part3 into :object_type, :object_owner, :object_name, :sub_object from sys.all_constraints c where c.constraint_name = :part2 and c.owner = :part1 and rownum = 1; end if; if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if; if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if; if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if; if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; return; exception when no_data_found then null; end; end if; :sub_object := :part2; if (:part2 is null) or (:part1 != user) then begin select object_type, user, :part1 into :object_type, :object_owner, :object_name from sys.all_objects where owner = user and object_name = :part1 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; if :object_type = 'SYNONYM' then select s.table_owner, s.table_name into t_owner, t_name from sys.all_synonyms s where s.synonym_name = :part1 and s.owner = user and rownum = 1; select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; end if; :sub_object := :part2; if :part3 is not null then :sub_object := :sub_object || '.' || :part3; end if; check_mview; return; exception when no_data_found then null; end; end if; begin select s.table_owner, s.table_name into t_owner, t_name from sys.all_synonyms s where s.synonym_name = :part1 and s.owner = 'PUBLIC' and rownum = 1; select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; :sub_object := :part3; begin select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = :part1 and o.object_name = :part2 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null then select 'USER', null, :part1 into :object_type, :object_owner, :object_name from sys.all_users u where u.username = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null and :deep != 0 then select 'ROLE', null, :part1 into :object_type, :object_owner, :object_name from sys.session_roles r where r.role = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; :object_owner := null; :object_type := null; :object_name := null; :sub_object := null; 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

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

gpv3kb4n2f2q1 SELECT COUNT(FILE#) FROM V$DATAFILE_HEADER WHERE RECOVER ='YES' OR ERROR IS NOT NULL

gz6qtapr9u99d /* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_usable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; -- Usable Flash Recovery Area (10gR2) l_usable_area := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage' INTO l_usable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_flashback_on, l_oldest_flashback_time from dual; :1 := data_cursor; END;

SQL Id	SQL Text
035rdsw0h9hfk	SELECT /+ opt_param('parallel_execution_enabled', 'false') / extractvalue(xmlval, '//info[@type = "sql_profile"]'), extractvalue(xmlval, '//info[@type = "outline"]'), extractvalue(xmlval, '//info[@type = "dynamic_sampling"]'), extractvalue(xmlval, '//info[@type = "index_size"]'), extractvalue(xmlval, '/*/info[@type = "plan_hash"]') from (select xmltype(:v_other_xml) xmlval from dual)
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
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'
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
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
13u83qfzhh56a	SELECT S.TABLE_OWNER, S.TABLE_NAME FROM SYS.ALL_SYNONYMS S WHERE S.SYNONYM_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1
14566d856s6hs	SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
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
1f12gkkf27m3z	SELECT TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)246060 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PING.LAST_CHECKED_UTC)246060 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
24dkx03u3rj6k	SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2nkzun1gy8zm8	SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage
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
35rqnp0hn3p3j	INSERT INTO mgmt_ha_mttr(COLLECTION_TIMESTAMP, ESTIMATED_MTTR, TARGET_GUID) VALUES ( :1, :2, :3)
3nz260v5dwqnv	select value from v$sesstat where sid = :sid order by statistic#
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)
444ygb1fcndkz	SELECT STRING_VALUE FROM MGMT_CURRENT_METRICS WHERE TARGET_GUID = :B3 AND METRIC_GUID = :B2 AND KEY_VALUE = :B1
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
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
4vvuzs84f1mvr	INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE) VALUES ( :1, :2, :3)
51vw8qf5uprrv	SELECT LOG_MODE, FLASHBACK_ON FROM V$DATABASE
5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6129566gyvx21	SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
6d64jpfzqc9rv	INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE, STRING_VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , NULL, :B1 )
6gh8gj9n09vr7	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :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;
6t7007dkc1abh	DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE
7gnakyxnvaadf	SELECT UNIQUE(TARGET_GUID) FROM MGMT_METRIC_DEPENDENCY WHERE CAN_CALCULATE = 1 AND DISABLED = 0
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
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
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
8bgj359xdaz28	UPDATE MGMT_EMD_PING SET LAST_CHECKED_UTC = :B1 WHERE MAX_INACTIVE_TIME > 0 AND ( (STATUS = :B3 ) OR (STATUS = :B2 ) ) AND (:B1 - LAST_CHECKED_UTC)2460*60 >= (MAX_INACTIVE_TIME)/2
8hk7xvhua40va	INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
8ktuh6payfpmy	UPDATE MGMT_AVAILABILITY_MARKER SET MARKER_TIMESTAMP = :B1 WHERE MARKER_TIMESTAMP <= :B1 AND TARGET_GUID IN (SELECT T.TARGET_GUID FROM MGMT_TARGETS T WHERE T.EMD_URL = :B2 AND T.REP_SIDE_AVAIL = 0 AND NOT EXISTS (SELECT 1 FROM MGMT_BLACKOUT_WINDOWS BW WHERE BW.TARGET_GUID = T.TARGET_GUID AND BW.START_TIME <= :B1 AND (BW.END_TIME > :B1 OR BW.END_TIME IS NULL) ) AND NOT EXISTS (SELECT 1 FROM MGMT_BCN_AVAIL_DEF BCNAV WHERE BCNAV.TARGET_GUID = T.TARGET_GUID) )
91h2x42zqagcm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
9ur12dtztw3rx	SELECT TARGET_GUID, DELETE_REQUEST_TIME, DELETE_COMPLETE_TIME FROM MGMT_TARGETS_DELETE DEL WHERE EMD_URL = :B1 OR EXISTS (SELECT 1 FROM MGMT_TARGET_AGENT_ASSOC WHERE TARGET_GUID = DEL.TARGET_GUID AND AGENT_GUID = :B2 )
a73yth55sy3qd	/* OracleOEM */ DECLARE l_missing_media_files NUMBER; l_corrupt_data_blocks NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_92 CONSTANT VARCHAR2(10) := '09.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Missing Media Files SELECT count(file#) INTO l_missing_media_files FROM v$datafile_header WHERE recover ='YES' OR error is not null; -- Corrupt Data Blocks (9iR2 or higher) l_corrupt_data_blocks := NULL; IF (v_db_version >= db_version_92) THEN EXECUTE IMMEDIATE 'SELECT count(unique(file#)) FROM v$database_block_corruption' INTO l_corrupt_data_blocks; END IF; OPEN data_cursor FOR SELECT l_missing_media_files, l_corrupt_data_blocks from dual; :1 := data_cursor; END;
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
c8h3jdwaa532q	SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cb75rw3w1tt0s	begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
cchx5kcx6tgmz	SELECT COUNT() FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP > (HEARTBEAT_INTERVAL4)/(246060)
cydnuss99swtd	BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
d33xszqrpzu17	SELECT TARGET_GUID, DETECTION_TIME, RESOLVED_TIME FROM MGMT_DUPLICATE_TARGETS WHERE DUPLICATE_EMD_URL = :B1
d59tgwpksgs94	SELECT EMD_URL, EVENT_TYPE, OCCUR_TIME FROM MGMT_JOB_EMD_STATUS_QUEUE ORDER BY OCCUR_TIME
d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dwssdqx28tzf5	select sysdate + 1 / (24 * 60) from dual
f9tkk3w2wuv38	declare t_owner varchar2(30); t_name varchar2(30); procedure check_mview is dummy integer; begin if :object_type = 'TABLE' then select 1 into dummy from sys.all_objects where owner = :object_owner and object_name = :object_name and object_type = 'MATERIALIZED VIEW' and rownum = 1; :object_type := 'MATERIALIZED VIEW'; end if; exception when others then null; end; begin :sub_object := null; if :deep != 0 then begin if :part2 is null then select constraint_type, owner, constraint_name into :object_type, :object_owner, :object_name from sys.all_constraints c where c.constraint_name = :part1 and c.owner = user and rownum = 1; else select constraint_type, owner, constraint_name, :part3 into :object_type, :object_owner, :object_name, :sub_object from sys.all_constraints c where c.constraint_name = :part2 and c.owner = :part1 and rownum = 1; end if; if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if; if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if; if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if; if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; return; exception when no_data_found then null; end; end if; :sub_object := :part2; if (:part2 is null) or (:part1 != user) then begin select object_type, user, :part1 into :object_type, :object_owner, :object_name from sys.all_objects where owner = user and object_name = :part1 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; if :object_type = 'SYNONYM' then select s.table_owner, s.table_name into t_owner, t_name from sys.all_synonyms s where s.synonym_name = :part1 and s.owner = user and rownum = 1; select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; end if; :sub_object := :part2; if :part3 is not null then :sub_object := :sub_object \|\| '.' \|\| :part3; end if; check_mview; return; exception when no_data_found then null; end; end if; begin select s.table_owner, s.table_name into t_owner, t_name from sys.all_synonyms s where s.synonym_name = :part1 and s.owner = 'PUBLIC' and rownum = 1; select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = t_owner and o.object_name = t_name and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; :sub_object := :part3; begin select o.object_type, o.owner, o.object_name into :object_type, :object_owner, :object_name from sys.all_objects o where o.owner = :part1 and o.object_name = :part2 and object_type in ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') and rownum = 1; check_mview; return; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null then select 'USER', null, :part1 into :object_type, :object_owner, :object_name from sys.all_users u where u.username = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null and :deep != 0 then select 'ROLE', null, :part1 into :object_type, :object_owner, :object_name from sys.session_roles r where r.role = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; :object_owner := null; :object_type := null; :object_name := null; :sub_object := null; 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
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
gpv3kb4n2f2q1	SELECT COUNT(FILE#) FROM V$DATAFILE_HEADER WHERE RECOVER ='YES' OR ERROR IS NOT NULL
gz6qtapr9u99d	/* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_usable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; -- Usable Flash Recovery Area (10gR2) l_usable_area := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (100 - sum(percent_space_used)) + sum(percent_space_reclaimable) FROM v$flash_recovery_area_usage' INTO l_usable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_flashback_on, l_oldest_flashback_time from dual; :1 := data_cursor; END;

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,669	0.47	2.86
CPU used when call started	1,578	0.44	2.71
CR blocks created	126	0.04	0.22
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	1,048,453	292.93	1,798.38
DBWR checkpoint buffers written	1,450	0.41	2.49
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	263	0.07	0.45
DBWR undo block writes	379	0.11	0.65
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	119	0.03	0.20
IMU Flushes	1,609	0.45	2.76
IMU Redo allocation size	206,828	57.79	354.77
IMU commits	527	0.15	0.90
IMU contention	1	0.00	0.00
IMU ktichg flush	3	0.00	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	1,746,596	487.98	2,995.88
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	5,812	1.62	9.97
active txn count during cleanout	31	0.01	0.05
application wait time	4	0.00	0.01
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	12,722	3.55	21.82
buffer is not pinned count	14,323	4.00	24.57
buffer is pinned count	8,421	2.35	14.44
bytes received via SQL*Net from client	783,600	218.93	1,344.08
bytes sent via SQL*Net to client	1,001,192	279.72	1,717.31
calls to get snapshot scn: kcmgss	22,738	6.35	39.00
calls to kcmgas	1,060	0.30	1.82
calls to kcmgcs	34	0.01	0.06
change write time	11	0.00	0.02
cleanout - number of ktugct calls	42	0.01	0.07
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	3	0.00	0.01
cluster key scan block gets	195	0.05	0.33
cluster key scans	116	0.03	0.20
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	33	0.01	0.06
commit batch/immediate requested	33	0.01	0.06
commit cleanout failures: block lost	3	0.00	0.01
commit cleanout failures: callback failure	4	0.00	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	2,057	0.57	3.53
commit cleanouts successfully completed	2,050	0.57	3.52
commit immediate performed	33	0.01	0.06
commit immediate requested	33	0.01	0.06
commit txn count during cleanout	23	0.01	0.04
concurrency wait time	31	0.01	0.05
consistent changes	286	0.08	0.49
consistent gets	43,747	12.22	75.04
consistent gets - examination	11,683	3.26	20.04
consistent gets from cache	43,747	12.22	75.04
cursor authentications	16	0.00	0.03
data blocks consistent reads - undo records applied	127	0.04	0.22
db block changes	10,382	2.90	17.81
db block gets	9,565	2.67	16.41
db block gets direct	0	0.00	0.00
db block gets from cache	9,565	2.67	16.41
deferred (CURRENT) block cleanout applications	1,551	0.43	2.66
enqueue conversions	720	0.20	1.23
enqueue releases	38,211	10.68	65.54
enqueue requests	38,215	10.68	65.55
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	13,204	3.69	22.65
free buffer requested	294	0.08	0.50
heap block compress	10	0.00	0.02
immediate (CR) block cleanout applications	3	0.00	0.01
immediate (CURRENT) block cleanout applications	222	0.06	0.38
index fast full scans (full)	16	0.00	0.03
index fetch by key	6,255	1.75	10.73
index scans kdiixs1	12,956	3.62	22.22
leaf node 90-10 splits	7	0.00	0.01
leaf node splits	16	0.00	0.03
lob reads	318	0.09	0.55
lob writes	23	0.01	0.04
lob writes unaligned	23	0.01	0.04
logons cumulative	187	0.05	0.32
messages received	1,840	0.51	3.16
messages sent	1,840	0.51	3.16
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	14,444	4.04	24.78
opened cursors cumulative	4,765	1.33	8.17
parse count (failures)	0	0.00	0.00
parse count (hard)	176	0.05	0.30
parse count (total)	4,643	1.30	7.96
parse time cpu	20	0.01	0.03
parse time elapsed	20	0.01	0.03
physical read IO requests	0	0.00	0.00
physical read bytes	0	0.00	0.00
physical read total IO requests	2,364	0.66	4.05
physical read total bytes	38,567,936	10,775.52	66,154.26
physical read total multi block requests	0	0.00	0.00
physical reads	0	0.00	0.00
physical reads cache	0	0.00	0.00
physical reads cache prefetch	0	0.00	0.00
physical reads direct	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	1,011	0.28	1.73
physical write bytes	11,878,400	3,318.71	20,374.61
physical write total IO requests	5,505	1.54	9.44
physical write total bytes	72,881,664	20,362.45	125,011.43
physical write total multi block requests	1,012	0.28	1.74
physical writes	1,450	0.41	2.49
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	1,450	0.41	2.49
physical writes non checkpoint	35	0.01	0.06
process last non-idle time	47,277	13.21	81.09
recursive calls	45,016	12.58	77.21
recursive cpu usage	1,213	0.34	2.08
redo blocks written	4,619	1.29	7.92
redo buffer allocation retries	0	0.00	0.00
redo entries	3,417	0.95	5.86
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	11	0.00	0.02
redo size	2,045,636	571.53	3,508.81
redo synch time	11	0.00	0.02
redo synch writes	2,727	0.76	4.68
redo wastage	261,068	72.94	447.80
redo write time	13	0.00	0.02
redo writes	914	0.26	1.57
rollback changes - undo records applied	58	0.02	0.10
rollbacks only - consistent read gets	126	0.04	0.22
rows fetched via callback	3,521	0.98	6.04
session connect time	0	0.00	0.00
session cursor cache hits	1,581	0.44	2.71
session logical reads	53,312	14.89	91.44
session pga memory	88,844,740	24,822.38	152,392.35
session pga memory max	86,747,588	24,236.46	148,795.18
session uga memory	###############	68,402,149.58	419,942,149.94
session uga memory max	66,141,460	18,479.30	113,450.19
shared hash latch upgrades - no wait	13,365	3.73	22.92
shared hash latch upgrades - wait	84	0.02	0.14
sorts (memory)	2,456	0.69	4.21
sorts (rows)	36,943	10.32	63.37
sql area purged	52	0.01	0.09
switch current to new buffer	93	0.03	0.16
table fetch by rowid	8,056	2.25	13.82
table fetch continued row	6	0.00	0.01
table scan blocks gotten	9,009	2.52	15.45
table scan rows gotten	518,590	144.89	889.52
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	2,000	0.56	3.43
total number of times SMON posted	2	0.00	0.00
transaction rollbacks	33	0.01	0.06
undo change vector size	712,964	199.20	1,222.92
user I/O wait time	21	0.01	0.04
user calls	6,930	1.94	11.89
user commits	551	0.15	0.95
user rollbacks	32	0.01	0.05
workarea executions - optimal	1,212	0.34	2.08
write clones created in background	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	18,302	19,680
opened cursors current	282	292
logons current	30	82

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
UNDOTBS1	0	0	0.00	0.00	515	0	0	0.00
SYSAUX	0	0	0.00	0.00	422	0	0	0.00
SYSTEM	0	0	0.00	0.00	74	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Writes
SYSAUX	D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\SYSAUX01.DBF	422
SYSTEM	D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\SYSTEM01.DBF	74
UNDOTBS1	D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\UNDOTBS01.DB	515

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	128,000	100	52,940	0	1,450	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	8	219	567	1738	184320	1738
E	0	8	179	439	1771	184320	1771

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	96	0.09	12,000	1.77	27,382
D	192	0.19	24,000	1.30	20,037
D	288	0.28	36,000	1.11	17,102
D	384	0.38	48,000	1.00	15,523
D	480	0.47	60,000	1.00	15,448
D	576	0.56	72,000	1.00	15,448
D	672	0.66	84,000	1.00	15,448
D	768	0.75	96,000	1.00	15,448
D	864	0.84	108,000	1.00	15,448
D	960	0.94	120,000	1.00	15,448
D	1,024	1.00	128,000	1.00	15,448
D	1,056	1.03	132,000	1.00	15,448
D	1,152	1.13	144,000	1.00	15,448
D	1,248	1.22	156,000	1.00	15,448
D	1,344	1.31	168,000	1.00	15,448
D	1,440	1.41	180,000	1.00	15,448
D	1,536	1.50	192,000	1.00	15,448
D	1,632	1.59	204,000	1.00	15,448
D	1,728	1.69	216,000	1.00	15,448
D	1,824	1.78	228,000	1.00	15,448
D	1,920	1.88	240,000	1.00	15,448

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	55	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	7,134	6,392	56.74	0.00	0.00	0.00	0.00	102,400
E	7,134	6,374	92.40	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	1,147	1,147
64K	128K	1	1
512K	1024K	65	65

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 PGA Cache Hit %
892	0.13	1,076.19	100.00
1,784	0.25	1,076.19	100.00
3,567	0.50	1,076.19	100.00
5,351	0.75	1,076.19	100.00
7,134	1.00	1,076.19	100.00
8,561	1.20	1,076.19	100.00
9,988	1.40	1,076.19	100.00
11,414	1.60	1,076.19	100.00
12,841	1.80	1,076.19	100.00
14,268	2.00	1,076.19	100.00
21,402	3.00	1,076.19	100.00
28,536	4.00	1,076.19	100.00

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
80	0.22	43	8,739	4,807	1.00	54	1.35	907,772
120	0.33	81	11,970	4,815	1.00	46	1.15	910,200
160	0.44	121	15,777	4,819	1.00	42	1.05	911,683
200	0.56	160	19,711	4,820	1.00	41	1.03	912,280
240	0.67	199	24,040	4,821	1.00	40	1.00	912,548
280	0.78	238	27,467	4,821	1.00	40	1.00	912,689
320	0.89	240	27,854	4,821	1.00	40	1.00	912,689
360	1.00	240	27,854	4,821	1.00	40	1.00	912,689
400	1.11	240	27,854	4,821	1.00	40	1.00	912,689
440	1.22	240	27,854	4,821	1.00	40	1.00	912,689
480	1.33	240	27,854	4,821	1.00	40	1.00	912,689
520	1.44	240	27,854	4,821	1.00	40	1.00	912,689
560	1.56	240	27,854	4,821	1.00	40	1.00	912,689
600	1.67	240	27,854	4,821	1.00	40	1.00	912,689
640	1.78	240	27,854	4,821	1.00	40	1.00	912,689
680	1.89	240	27,854	4,821	1.00	40	1.00	912,689
720	2.00	240	27,854	4,821	1.00	40	1.00	912,689

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

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.18	954	0	5	15/15	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
30-Jan 11:08	57	137	5	15	0/0	0/0/0/0/0/0
30-Jan 10:58	15	143	3	15	0/0	0/0/0/0/0/0
30-Jan 10:48	20	107	5	15	0/0	0/0/0/0/0/0
30-Jan 10:38	14	123	5	15	0/0	0/0/0/0/0/0
30-Jan 10:28	12	100	1	15	0/0	0/0/0/0/0/0
30-Jan 10:18	14	195	2	15	0/0	0/0/0/0/0/0
30-Jan 10:08	51	149	3	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
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,072	0.00		0
Consistent RBA	914	0.00		0
FAL request queue	72	0.00		0
FAL subheap alocation	72	0.00		0
FOB s.o list latch	58	0.00		0
In memory undo latch	11,332	0.00		3,001	0.00
JS mem alloc latch	7	0.00		0
JS queue access latch	7	0.00		0
JS queue state obj latch	25,882	0.00		0
JS slv state obj latch	169	0.00		0
KMG MMAN ready and startup request latch	1,193	0.00		0
KTF sga latch	6	16.67	0.00	1,071	0.00
KWQMN job cache list latch	23	0.00		0
MQL Tracking Latch	0			69	0.00
Memory Management Latch	0			1,193	0.00
OS process	561	0.00		0
OS process allocation	1,617	0.00		0
OS process: request allocation	204	0.00		0
PL/SQL warning settings	712	0.00		0
SQL memory manager latch	1	0.00		1,193	0.00
SQL memory manager workarea list latch	81,220	0.00		0
Shared B-Tree	133	0.00		0
active checkpoint queue latch	3,397	0.00		0
active service list	8,050	0.01	0.00	1,218	0.00
archive control	134	0.00		0
archive process latch	1,265	0.00		0
cache buffer handles	28	0.00		0
cache buffers chains	129,195	0.26	0.00	119	0.00
cache buffers lru chain	4,583	0.00		401	0.00
channel handle pool latch	206	0.00		0
channel operations parent latch	21,500	0.00		0
checkpoint queue latch	194,518	0.00		1,253	0.00
client/application info	1,867	0.00		0
commit callback allocation	8	0.00		0
compile environment latch	2,341	0.00		0
dml lock allocation	14,462	0.00		0
dummy allocation	322	0.93	0.00	0
enqueue hash chains	77,114	0.00	0.00	0
enqueues	62,334	0.01	0.00	0
event group latch	127	0.00		0
file cache latch	112	0.00		0
global KZLD latch for mem in SGA	75	0.00		0
hash table column usage latch	66	0.00		3,257	0.00
hash table modification latch	64	0.00		0
job workq parent latch	0			114	0.00
job_queue_processes parameter latch	117	0.00		0
kks stats	52	0.00		0
kmcptab latch	1	0.00		0
kmcpvec latch	0			1	0.00
ksuosstats global area	241	0.00		0
ktm global data	13	0.00		0
kwqbsn:qsga	133	0.00		0
lgwr LWN SCN	1,755	0.00		0
library cache	111,000	0.10	0.04	0
library cache load lock	98	0.00		0
library cache lock	37,599	0.00		0
library cache lock allocation	1,400	0.00		0
library cache pin	73,099	0.01	0.00	0
library cache pin allocation	478	0.00		0
list of block allocation	147	0.00		0
loader state object freelist	6	0.00		0
message pool operations parent latch	12	0.00		0
messages	30,167	0.01	0.00	0
mostly latch-free SCN	1,755	0.00		0
ncodef allocation latch	58	0.00		0
object queue header heap	28	0.00		10	0.00
object queue header operation	18,752	0.00		0
object stats modification	9	0.00		0
parallel query alloc buffer	432	0.00		0
parameter list	74	0.00		0
parameter table allocation management	138	0.00		0
post/wait queue	345	0.00		237	0.00
process allocation	212	0.00		127	0.00
process group creation	204	0.00		0
qmn task queue latch	508	0.00		0
redo allocation	10,396	0.00		3,384	0.00
redo copy	0			3,384	0.00
redo writing	8,657	0.00		0
resmgr group change latch	374	0.00		0
resmgr:actses active list	319	0.00		0
resmgr:actses change group	132	0.00		0
resmgr:free threads list	318	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	57,284	0.64	0.00	0
rules engine aggregate statistics	2	0.00		0
rules engine rule set statistics	4	0.00		0
sequence cache	289	1.38	0.00	0
session allocation	17,365	0.01	0.00	0
session idle bit	16,015	0.00		0
session state list latch	382	0.00		0
session switching	87	0.00		0
session timer	1,218	0.00		0
shared pool	13,844	1.03	0.00	0
simulator hash latch	3,520	0.00		0
simulator lru latch	3,512	0.00		4	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	145	0.00		0
state object free list	2	0.00		0
statistics aggregation	140	0.00		0
temp lob duration state obj allocation	4	0.00		0
temporary table state object allocation	4	0.00		0
threshold alerts latch	215	0.00		0
transaction allocation	143	0.00		0
transaction branch allocation	58	0.00		0
undo global data	7,520	0.00		0
user lock	310	1.29	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
library cache	111,000	107	4	103	0	0	0
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	Sleeps	Waiter Sleeps
library cache	kglhdgc: child:	1	0
library cache	kglobld	1	0
library cache	kglpndl: child: before processing	1	1
library cache	kglrtl	1	0
slave class create	ksvcreate	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: 53,312
Captured Segments account for 70.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_SYSAUTH1	INDEX	3,968	7.44
SYSMAN	SYSAUX	SYS_IOT_TOP_49769	INDEX	3,120	5.85
SYS	SYSTEM	CDEF$	TABLE	2,960	5.55
SYS	SYSTEM	SYS_C00648	INDEX	2,688	5.04
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	2,640	4.95

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSTEM	SMON_SCN_TIME		TABLE	2	100.00

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	63	0.00	2	1
dc_global_oids	3,263	0.00	0	194
dc_histogram_data	275	0.00	0	1,582
dc_histogram_defs	934	14.03	0	6,684
dc_object_ids	3,986	0.00	0	2,312
dc_objects	344	1.45	5	2,949
dc_profiles	152	0.00	0	2
dc_rollback_segments	1,079	0.00	0	36
dc_segments	106	0.00	3	1,935
dc_sequences	5	0.00	5	24
dc_tablespace_quotas	1	0.00	0	2
dc_tablespaces	1,354	0.00	0	6
dc_usernames	171	0.00	0	28
dc_users	8,624	0.00	0	70
outstanding_alerts	74	1.35	2	11

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	627	0.00	4,217	0.00	0
CLUSTER	6	0.00	8	0.00	0
INDEX	3	66.67	3	66.67	0
SQL AREA	15	100.00	15,377	0.66	50
TABLE/PROCEDURE	200	4.00	6,863	0.68	8
TRIGGER	15	0.00	323	0.00	0

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	56.03		1.75	2.59	9	9	32	32
	SQL	1.01	0.40	0.05	0.04	0	6	21	17
	PL/SQL	0.59	0.23	0.02	0.02	0	0	30	30
E	Other	91.43		1.12	1.93	9	9	82	82
	SQL	1.04	0.42	0.01	0.03	0	6	71	20
	PL/SQL	0.90	0.24	0.01	0.03	0	0	80	80

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,073,741,824
Fixed Size	1,333,600
Redo Buffers	4,259,840
Variable Size	573,220,512

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	24.00	24.00	0.00
large	free memory	160.00	160.00	0.00
shared	ASH buffers	18.00	18.00	0.00
shared	CCursor	22.48	22.60	0.57
shared	Heap0: KGL	4.81	4.84	0.62
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLS heap	8.09	8.27	2.17
shared	KQR M PO	5.80	5.87	1.14
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	PCursor	10.56	10.59	0.29
shared	PL/SQL DIANA	4.45	4.45	0.00
shared	PL/SQL MPCODE	5.41	5.41	0.00
shared	XDB Schema Cac	4.75	4.75	0.00
shared	free memory	113.31	110.75	-2.26
shared	library cache	14.88	14.93	0.35
shared	row cache	3.57	3.57	0.00
shared	sql area	62.78	64.38	2.55
shared	sql area:PLSQL	22.73	22.73	0.00
	buffer_cache	1,024.00	1,024.00	0.00
	fixed_sga	1.27	1.27	0.00
	log_buffer	4.06	4.06	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)
audit_file_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\HGMSUP\ADUMP
background_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\HGMSUP\BDUMP
compatible	10.2.0.1.0
control_files	D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\HGMSUP\CONTROL03.CTL
core_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\HGMSUP\CDUMP
db_block_size	8192
db_cache_size	1073741824
db_domain
db_file_multiblock_read_count	16
db_name	HGMSUP
db_recovery_file_dest	D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size	4102029312
dispatchers	(PROTOCOL=TCP) (SERVICE=HGMSUPXDB)
java_pool_size	25165824
job_queue_processes	10
large_pool_size	167772160
log_archive_format	ARC%S_%R.%T
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
pga_aggregate_target	7480541184
processes	150
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	377487360
spfile	D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEHGMSUP.ORA
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	D:\ORACLE\PRODUCT\10.2.0\ADMIN\HGMSUP\UDUMP

End of Report

% Blocks changed per Read:	19.47	Recursive Call %:	86.66
Rollback per transaction %:	5.49	Rows per Sort:	15.04

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.44	Soft Parse %:	96.21
Execute to Parse %:	64.84	Latch Hit %:	99.91
Parse CPU to Parse Elapsd %:	100.00	% Non-Parse CPU:	98.81