WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

SMS 854222504 SMS 1 10.2.0.4.0 NO localhost

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
SMS	854222504	SMS	1	10.2.0.4.0	NO	localhost

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 9456 09-Dec-13 15:20:20 41 32.4

End Snap: 9457 09-Dec-13 15:30:20 41 32.7

Elapsed: 10.00 (mins)

DB Time: 0.25 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	9456	09-Dec-13 15:20:20	41	32.4
End Snap:	9457	09-Dec-13 15:30:20	41	32.7
Elapsed:		10.00 (mins)
DB Time:		0.25 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 10,608M 10,608M Std Block Size: 8K

Shared Pool Size: 1,632M 1,632M Log Buffer: 14,324K

	Begin	End
Buffer Cache:	10,608M	10,608M	Std Block Size:	8K
Shared Pool Size:	1,632M	1,632M	Log Buffer:	14,324K

Load Profile

Per Second Per Transaction

Redo size: 1,122.10 10,205.82

Logical reads: 4,721.92 42,947.14

Block changes: 3.37 30.68

Physical reads: 0.00 0.02

Physical writes: 1.04 9.48

User calls: 7.50 68.23

Parses: 2.67 24.24

Hard parses: 0.00 0.02

Sorts: 3.88 35.32

Logons: 0.02 0.20

Executes: 8.48 77.14

Transactions: 0.11

	Per Second	Per Transaction
Redo size:	1,122.10	10,205.82
Logical reads:	4,721.92	42,947.14
Block changes:	3.37	30.68
Physical reads:	0.00	0.02
Physical writes:	1.04	9.48
User calls:	7.50	68.23
Parses:	2.67	24.24
Hard parses:	0.00	0.02
Sorts:	3.88	35.32
Logons:	0.02	0.20
Executes:	8.48	77.14
Transactions:	0.11

% Blocks changed per Read: 0.07 Recursive Call %: 78.15

Rollback per transaction %: 1.52 Rows per Sort: 63.57

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.88 Soft Parse %: 99.94

Execute to Parse %: 68.57 Latch Hit %: 71.06

Parse CPU to Parse Elapsd %: 140.00 % Non-Parse CPU: 99.46

Shared Pool Statistics

Begin End

Memory Usage %: 36.36 36.36

% SQL with executions>1: 95.22 95.86

% Memory for SQL w/exec>1: 79.50 82.70

	Begin	End
Memory Usage %:	36.36	36.36
% SQL with executions>1:	95.22	95.86
% Memory for SQL w/exec>1:	79.50	82.70

Top 5 Timed Events

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

control file parallel write 193 19 97 124.6 System I/O

CPU time 13 85.3

log file parallel write 93 6 61 37.4 System I/O

log file sync 27 1 28 5.0 Commit

os thread startup 2 0 25 .3 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
control file parallel write	193	19	97	124.6	System I/O
CPU time		13		85.3
log file parallel write	93	6	61	37.4	System I/O
log file sync	27	1	28	5.0	Commit
os thread startup	2	0	25	.3	Concurrency

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): 15.1s
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	14.09	93.33
DB CPU	12.88	85.29
PL/SQL execution elapsed time	0.29	1.94
parse time elapsed	0.07	0.46
hard parse elapsed time	0.00	0.01
repeated bind elapsed time	0.00	0.00
DB time	15.10
background elapsed time	34.06
background cpu time	2.47

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	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
System I/O	1,422	0.00	24	17	21.55
Commit	27	14.81	1	28	0.41
Concurrency	13	0.00	0	4	0.20
Other	2	0.00	0	12	0.03
Network	3,791	0.00	0	0	57.44
User I/O	6	0.00	0	0	0.09

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	193	0.00	19	97	2.92
log file parallel write	93	0.00	6	61	1.41
log file sync	27	14.81	1	28	0.41
os thread startup	2	0.00	0	25	0.03
latch free	1	0.00	0	24	0.02
control file sequential read	1,136	0.00	0	0	17.21
SQL*Net message to client	3,769	0.00	0	0	57.11
SQL*Net more data to client	22	0.00	0	0	0.33
latch: cache buffers chains	11	0.00	0	0	0.17
db file sequential read	6	0.00	0	0	0.09
LGWR wait for redo copy	1	0.00	0	0	0.02
SQL*Net message from client	3,769	0.00	12,453	3304	57.11
jobq slave wait	202	94.55	588	2910	3.06
virtual circuit status	20	100.00	586	29297	0.30
Streams AQ: qmn slave idle wait	21	0.00	576	27442	0.32
Streams AQ: qmn coordinator idle wait	43	51.16	576	13402	0.65
class slave wait	2	0.00	0	0	0.03

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	193	0.00	19	97	2.92
log file parallel write	95	0.00	6	59	1.44
os thread startup	2	0.00	0	25	0.03
control file sequential read	473	0.00	0	0	7.17
events in waitclass Other	1	0.00	0	0	0.02
rdbms ipc message	1,982	97.07	7,588	3829	30.03
smon timer	2	100.00	586	293014	0.03
pmon timer	210	100.00	586	2790	3.18
Streams AQ: qmn slave idle wait	21	0.00	576	27442	0.32
Streams AQ: qmn coordinator idle wait	43	51.16	576	13402	0.65

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	17,566
IDLE_TIME	462,537
IOWAIT_TIME	5,477
NICE_TIME	0
SYS_TIME	12,733
USER_TIME	4,793
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,712,402,432
NUM_CPUS	8
NUM_CPU_SOCKETS	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
SYS$USERS	15.00	12.80	2,825,096
SMS	0.00	0.00	504
SMSXDB	0.00	0.00	0
SYS$BACKGROUND	0.00	0.00	4,209

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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	0	11	0	3626	1
SMS	0	0	0	165	0
SYS$BACKGROUND	6	2	5	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
7	7	600	0.01	46.72	9q8v97zzh4vpq	JDBC Thin Client	BEGIN pack_sms_platform.pro_sm...
7	7	600	0.01	43.82	7w3gn3jc180aq	JDBC Thin Client	BEGIN pack_sms_platform.pro_re...
7	7	600	0.01	43.77	4n92k0pdff9vv	JDBC Thin Client	SELECT TO_CHAR(TAB.APP_ID) APP...
6	6	600	0.01	42.52	a7g2rvasz9nb0	JDBC Thin Client	SELECT * FROM SMS_LIST WHERE S...
1	1	1	1.02	6.77	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.42	2.80	84qubbrsr0kfn		insert into wrh$_latch (snap...
0	0	600	0.00	0.67	8uxj0gpvvx8uq	JDBC Thin Client	SELECT TO_CHAR(ST.APP_ID) APP_...
0	0	10	0.01	0.52	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	600	0.00	0.40	4k81s6fvk65nw	JDBC Thin Client	DELETE SMS_TEMPLIST
0	0	2	0.02	0.25	7csbrj7qp213b	JDBC Thin Client	BEGIN pack_sms_platform.pro_su...

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
7	7	600	0.01	46.72	9q8v97zzh4vpq	JDBC Thin Client	BEGIN pack_sms_platform.pro_sm...
7	7	600	0.01	43.82	7w3gn3jc180aq	JDBC Thin Client	BEGIN pack_sms_platform.pro_re...
7	7	600	0.01	43.77	4n92k0pdff9vv	JDBC Thin Client	SELECT TO_CHAR(TAB.APP_ID) APP...
6	6	600	0.01	42.52	a7g2rvasz9nb0	JDBC Thin Client	SELECT * FROM SMS_LIST WHERE S...
1	1	1	1.02	6.77	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.42	2.80	84qubbrsr0kfn		insert into wrh$_latch (snap...
0	0	600	0.00	0.67	8uxj0gpvvx8uq	JDBC Thin Client	SELECT TO_CHAR(ST.APP_ID) APP_...
0	0	10	0.01	0.52	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	600	0.00	0.40	4k81s6fvk65nw	JDBC Thin Client	DELETE SMS_TEMPLIST
0	0	2	0.02	0.25	7csbrj7qp213b	JDBC Thin Client	BEGIN pack_sms_platform.pro_su...

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: 2,834,511
Captured SQL account for 99.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,404,022	600	2,340.04	49.53	7.02	7.05	9q8v97zzh4vpq	JDBC Thin Client	BEGIN pack_sms_platform.pro_sm...
1,403,400	600	2,339.00	49.51	6.56	6.61	4n92k0pdff9vv	JDBC Thin Client	SELECT TO_CHAR(TAB.APP_ID) APP...
1,399,200	600	2,332.00	49.36	6.58	6.62	7w3gn3jc180aq	JDBC Thin Client	BEGIN pack_sms_platform.pro_re...
1,399,200	600	2,332.00	49.36	6.37	6.42	a7g2rvasz9nb0	JDBC Thin Client	SELECT * FROM SMS_LIST WHERE S...
14,029	2	7,014.50	0.49	0.04	0.04	7csbrj7qp213b	JDBC Thin Client	BEGIN pack_sms_platform.pro_su...
4,681	2	2,340.50	0.17	0.01	0.01	7wp6gx0w3t429	JDBC Thin Client	INSERT INTO SMS_LISTDONE SELEC...
4,675	2	2,337.50	0.16	0.01	0.01	45mgmpxup4uff	JDBC Thin Client	DELETE SMS_LIST WHERE SEQ_ID =...
4,671	2	2,335.50	0.16	0.02	0.02	3ff6fpgm16skk	JDBC Thin Client	UPDATE SMS_LIST SET STATUS = '...
4,202	600	7.00	0.15	0.10	0.10	8uxj0gpvvx8uq	JDBC Thin Client	SELECT TO_CHAR(ST.APP_ID) APP_...
1,424	10	142.40	0.05	0.08	0.08	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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
10	0.00	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
10	0.00	0.00	08vznc16ycuag	EM_PING	SELECT SYS_GUID() FROM SYS.DUA...
1	0.00	0.00	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
365	0.02	0.02	0h6b2sajwb74n		select privilege#, level from ...
12	0.00	0.00	0k8522rmdzg4k		select privilege# from sysauth...
2	0.00	0.00	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...
1	0.00	0.00	14566d856s6hs		SELECT owner# FROM sys.wri$_ad...
21	0.00	0.00	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
10	0.00	0.00	19v5guvsgcd1v		SELECT C.TARGET_GUID, C.METRI...
4	0.00	0.00	1jqqpfkr0m3yk		SELECT COUNT(*) FROM SYS.WRI$_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 5,091
Captured SQL account for 92.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
600	2	0.00	0.00	0.00	4k81s6fvk65nw	JDBC Thin Client	DELETE SMS_TEMPLIST
600	2	0.00	0.01	0.01	4n92k0pdff9vv	JDBC Thin Client	SELECT TO_CHAR(TAB.APP_ID) APP...
600	600	1.00	0.01	0.01	7w3gn3jc180aq	JDBC Thin Client	BEGIN pack_sms_platform.pro_re...
600	2	0.00	0.00	0.00	8uxj0gpvvx8uq	JDBC Thin Client	SELECT TO_CHAR(ST.APP_ID) APP_...
600	600	1.00	0.01	0.01	9q8v97zzh4vpq	JDBC Thin Client	BEGIN pack_sms_platform.pro_sm...
600	0	0.00	0.01	0.01	a7g2rvasz9nb0	JDBC Thin Client	SELECT * FROM SMS_LIST WHERE S...
365	407	1.12	0.00	0.00	0h6b2sajwb74n		select privilege#, level from ...
119	10	0.08	0.00	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
109	109	1.00	0.00	0.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
53	53	1.00	0.00	0.00	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,600
Captured SQL account for 82.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
600	600	37.50	8uxj0gpvvx8uq	JDBC Thin Client	SELECT TO_CHAR(ST.APP_ID) APP_...
365	365	22.81	0h6b2sajwb74n		select privilege#, level from ...
22	22	1.38	9m7787camwh4m	PL/SQL Developer	begin :id := sys.dbms_transact...
22	22	1.38	d5791p71c8h93	PL/SQL Developer	select /+rule/ value from v...
15	15	0.94	49s332uhbnsma		declare vsn va...
12	12	0.75	0k8522rmdzg4k		select privilege# from sysauth...
11	11	0.69	bydf32qgqdwdu	PL/SQL Developer	begin sys.dbms_output.get_li...
11	11	0.69	cf06fwacdmgfk	PL/SQL Developer	select 'x' from dual
11	11	0.69	fnj6cnubp1sau	PL/SQL Developer	begin if :enable = 0 then ...
10	10	0.63	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...

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 Text
3,299,649	1	0.19	31a13pnjps7j3	SELECT source, (case w...
1,654,386	1	0.10	d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDUR...
1,488,540	1	0.09	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
1,451,968	2	0.08	10xj8nynmpqtq	SELECT dbin.db_name, dbin.ins...
1,313,191	1	0.08	32whwm2babwpt	insert into wrh$_seg_stat_obj ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
40	1	akh9zqqkx3wj7		select 1, max(id) from sys.wr...
39	1	bhvyz9bgyrhb2		SELECT name, datatype, value, ...
34	1	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
33	6	6d64jpfzqc9rv		INSERT INTO MGMT_METRICS_RAW (...
32	2	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...
32	1	gdn3ysuyssf82		SELECT advisor_id FROM sys.wri...
31	21	18naypzfmabd6		INSERT INTO MGMT_SYSTEM_PERFOR...
31	1	298ppdduqr7wm		SELECT status FROM sys.wri$_ad...
30	1	76natvnhtqqhw		INSERT INTO SYS.WRI$_ADV_TASKS...
29	1	14566d856s6hs		SELECT owner# FROM sys.wri$_ad...
29	1	14566d856s6hs		SELECT owner# FROM sys.wri$_ad...
28	1	31a13pnjps7j3		SELECT source, (case w...
22	18	91h2x42zqagcm		UPDATE MGMT_CURRENT_METRICS SE...
22	1	cxjga3nv4kxa7	DBMS_SCHEDULER	insert into sys.scheduler$_job...
21	1	ccqcbrv0aywad		INSERT INTO MGMT_STRING_METRIC...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08vznc16ycuag SELECT SYS_GUID() FROM SYS.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

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

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

1jqqpfkr0m3yk SELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1

298ppdduqr7wm SELECT status FROM sys.wri$_adv_tasks WHERE id = :1

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

32whwm2babwpt insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'

3ff6fpgm16skk UPDATE SMS_LIST SET STATUS = '2', RESP_TIME = :B2 WHERE SEQ_ID = :B1

45mgmpxup4uff DELETE SMS_LIST WHERE SEQ_ID = :B1

49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;

4k81s6fvk65nw DELETE SMS_TEMPLIST

4n92k0pdff9vv SELECT TO_CHAR(TAB.APP_ID) APP_ID, TAB.SMS_NUMBER, TAB.SMS_DETAIL, TAB.SEND_PRIORITY, TAB.SUBMIT_TIME, TAB.MO_SEQ FROM (SELECT T.*, ROW_NUMBER() OVER(ORDER BY T.SEND_PRIORITY DESC, T.OK_TIME ASC, T.APP_ID ASC, T.SMS_NUMBER ASC, T.MO_SEQ ASC) ROW_ID FROM SMS_LIST T, SMS_ACCESSSYSTEM A WHERE T.STATUS = '0' AND ((T.SEND_TYPE = '1' AND T.SEND_TIME BETWEEN :B3 AND :B2 ) OR T.SEND_TYPE = '0') AND T.AS_ID = A.AS_ID AND :B1 BETWEEN A.AS_BEGIN AND A.AS_END) TAB WHERE TAB.ROW_ID <= TO_NUMBER(:B4 )

5h7w8ykwtb2xt INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :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;

6ssrk2dqj7jbx 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

76natvnhtqqhw INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )

7csbrj7qp213b BEGIN pack_sms_platform.pro_submit_resp_save( :1, :2, :3, :4) ; END;

7w3gn3jc180aq BEGIN pack_sms_platform.pro_reset_save( :1, :2, :3) ; END;

7wp6gx0w3t429 INSERT INTO SMS_LISTDONE SELECT * FROM SMS_LIST WHERE SEQ_ID = :B1

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

8uxj0gpvvx8uq SELECT TO_CHAR(ST.APP_ID) APP_ID, ST.SMS_NUMBER, ST.SMS_DETAIL, ST.SEND_PRIORITY, ST.SUBMIT_TIME, ST.MO_SEQ FROM SMS_TEMPLIST ST

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

9m7787camwh4m begin :id := sys.dbms_transaction.local_transaction_id; end;

9q8v97zzh4vpq BEGIN pack_sms_platform.pro_sms_list( :1, :2, :3, :4, :5) ; END;

a7g2rvasz9nb0 SELECT * FROM SMS_LIST WHERE STATUS = '1' AND RESP_TIME IS NULL AND ROUND(TO_NUMBER(SYSDATE - TO_DATE(DO_TIME, 'yyyy-mm-dd hh24:mi:ss')) * 24 * 60) >= 1

akh9zqqkx3wj7 select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1

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

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

bydf32qgqdwdu begin sys.dbms_output.get_line(line => :line, status => :status); end;

ccqcbrv0aywad INSERT INTO MGMT_STRING_METRIC_HISTORY (TARGET_GUID, KEY_VALUE, COLLECTION_TIMESTAMP, METRIC_GUID, STRING_VALUE) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 )

cf06fwacdmgfk select 'x' from dual

cxjga3nv4kxa7 insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10)

d5791p71c8h93 select /*+rule*/ value from v$sesstat where sid = :sid order by statistic#

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

fnj6cnubp1sau begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;

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

gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08vznc16ycuag	SELECT SYS_GUID() FROM SYS.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
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
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
1jqqpfkr0m3yk	SELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :1
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
32whwm2babwpt	insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below /, 10 / NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
3ff6fpgm16skk	UPDATE SMS_LIST SET STATUS = '2', RESP_TIME = :B2 WHERE SEQ_ID = :B1
45mgmpxup4uff	DELETE SMS_LIST WHERE SEQ_ID = :B1
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) \|\| substr(vsn, 4, 2) \|\| substr(vsn, 7, 2) \|\| nvl(substr(vsn, 10, 2), '00')); end if; end;
4k81s6fvk65nw	DELETE SMS_TEMPLIST
4n92k0pdff9vv	SELECT TO_CHAR(TAB.APP_ID) APP_ID, TAB.SMS_NUMBER, TAB.SMS_DETAIL, TAB.SEND_PRIORITY, TAB.SUBMIT_TIME, TAB.MO_SEQ FROM (SELECT T.*, ROW_NUMBER() OVER(ORDER BY T.SEND_PRIORITY DESC, T.OK_TIME ASC, T.APP_ID ASC, T.SMS_NUMBER ASC, T.MO_SEQ ASC) ROW_ID FROM SMS_LIST T, SMS_ACCESSSYSTEM A WHERE T.STATUS = '0' AND ((T.SEND_TYPE = '1' AND T.SEND_TIME BETWEEN :B3 AND :B2 ) OR T.SEND_TYPE = '0') AND T.AS_ID = A.AS_ID AND :B1 BETWEEN A.AS_BEGIN AND A.AS_END) TAB WHERE TAB.ROW_ID <= TO_NUMBER(:B4 )
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :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;
6ssrk2dqj7jbx	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
76natvnhtqqhw	INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
7csbrj7qp213b	BEGIN pack_sms_platform.pro_submit_resp_save( :1, :2, :3, :4) ; END;
7w3gn3jc180aq	BEGIN pack_sms_platform.pro_reset_save( :1, :2, :3) ; END;
7wp6gx0w3t429	INSERT INTO SMS_LISTDONE SELECT * FROM SMS_LIST WHERE SEQ_ID = :B1
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
8uxj0gpvvx8uq	SELECT TO_CHAR(ST.APP_ID) APP_ID, ST.SMS_NUMBER, ST.SMS_DETAIL, ST.SEND_PRIORITY, ST.SUBMIT_TIME, ST.MO_SEQ FROM SMS_TEMPLIST ST
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
9m7787camwh4m	begin :id := sys.dbms_transaction.local_transaction_id; end;
9q8v97zzh4vpq	BEGIN pack_sms_platform.pro_sms_list( :1, :2, :3, :4, :5) ; END;
a7g2rvasz9nb0	SELECT * FROM SMS_LIST WHERE STATUS = '1' AND RESP_TIME IS NULL AND ROUND(TO_NUMBER(SYSDATE - TO_DATE(DO_TIME, 'yyyy-mm-dd hh24:mi:ss')) * 24 * 60) >= 1
akh9zqqkx3wj7	select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bydf32qgqdwdu	begin sys.dbms_output.get_line(line => :line, status => :status); end;
ccqcbrv0aywad	INSERT INTO MGMT_STRING_METRIC_HISTORY (TARGET_GUID, KEY_VALUE, COLLECTION_TIMESTAMP, METRIC_GUID, STRING_VALUE) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 )
cf06fwacdmgfk	select 'x' from dual
cxjga3nv4kxa7	insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10)
d5791p71c8h93	select /+rule/ value from v$sesstat where sid = :sid order by statistic#
d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
fnj6cnubp1sau	begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	1,651	2.75	25.02
CPU used when call started	1,624	2.71	24.61
CR blocks created	1	0.00	0.02
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	61,415	102.31	930.53
DBWR checkpoint buffers written	626	1.04	9.48
DBWR checkpoints	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	18	0.03	0.27
DBWR undo block writes	118	0.20	1.79
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	6	0.01	0.09
IMU Redo allocation size	80,960	134.87	1,226.67
IMU commits	59	0.10	0.89
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	333,896	556.23	5,059.03
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
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	3,775	6.29	57.20
active txn count during cleanout	20	0.03	0.30
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	1,925	3.21	29.17
branch node splits	0	0.00	0.00
buffer is not pinned count	3,200	5.33	48.48
buffer is pinned count	1,139	1.90	17.26
bytes received via SQL*Net from client	153,766	256.15	2,329.79
bytes sent via SQL*Net to client	383,948	639.61	5,817.39
calls to get snapshot scn: kcmgss	11,625	19.37	176.14
calls to kcmgas	104	0.17	1.58
calls to kcmgcs	20	0.03	0.30
change write time	4	0.01	0.06
cleanout - number of ktugct calls	21	0.03	0.32
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	0	0.00	0.00
cluster key scan block gets	622	1.04	9.42
cluster key scans	19	0.03	0.29
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	3	0.00	0.05
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	414	0.69	6.27
commit cleanouts successfully completed	411	0.68	6.23
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	9	0.01	0.14
concurrency wait time	5	0.01	0.08
consistent changes	10	0.02	0.15
consistent gets	2,832,608	4,718.75	42,918.30
consistent gets - examination	2,209	3.68	33.47
consistent gets direct	0	0.00	0.00
consistent gets from cache	2,832,608	4,718.75	42,918.30
cursor authentications	2	0.00	0.03
data blocks consistent reads - undo records applied	2	0.00	0.03
db block changes	2,025	3.37	30.68
db block gets	1,903	3.17	28.83
db block gets direct	0	0.00	0.00
db block gets from cache	1,903	3.17	28.83
deferred (CURRENT) block cleanout applications	302	0.50	4.58
doubling up with imu segment	0	0.00	0.00
enqueue conversions	123	0.20	1.86
enqueue deadlocks	0	0.00	0.00
enqueue releases	5,940	9.90	90.00
enqueue requests	5,940	9.90	90.00
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	5,091	8.48	77.14
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	100	0.17	1.52
heap block compress	5	0.01	0.08
immediate (CR) block cleanout applications	0	0.00	0.00
immediate (CURRENT) block cleanout applications	50	0.08	0.76
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	861	1.43	13.05
index fast full scans (full)	0	0.00	0.00
index fetch by key	876	1.46	13.27
index scans kdiixs1	1,727	2.88	26.17
leaf node 90-10 splits	5	0.01	0.08
leaf node splits	8	0.01	0.12
lob reads	6	0.01	0.09
lob writes	2	0.00	0.03
lob writes unaligned	2	0.00	0.03
logons cumulative	13	0.02	0.20
messages received	451	0.75	6.83
messages sent	451	0.75	6.83
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	2,821,743	4,700.65	42,753.68
opened cursors cumulative	1,601	2.67	24.26
parse count (failures)	0	0.00	0.00
parse count (hard)	1	0.00	0.02
parse count (total)	1,600	2.67	24.24
parse time cpu	7	0.01	0.11
parse time elapsed	5	0.01	0.08
physical read IO requests	0	0.00	0.00
physical read bytes	0	0.00	0.00
physical read total IO requests	1,143	1.90	17.32
physical read total bytes	18,677,760	31,114.66	282,996.36
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 (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	386	0.64	5.85
physical write bytes	5,128,192	8,542.89	77,699.88
physical write total IO requests	1,062	1.77	16.09
physical write total bytes	15,406,592	25,665.33	233,433.21
physical write total multi block requests	119	0.20	1.80
physical writes	626	1.04	9.48
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	626	1.04	9.48
physical writes non checkpoint	146	0.24	2.21
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks flushed 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 aborts on index block reclamation	0	0.00	0.00
recursive calls	16,101	26.82	243.95
recursive cpu usage	1,547	2.58	23.44
redo blocks read for recovery	0	0.00	0.00
redo blocks written	1,451	2.42	21.98
redo buffer allocation retries	0	0.00	0.00
redo entries	1,170	1.95	17.73
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1	0.00	0.02
redo size	673,584	1,122.10	10,205.82
redo subscn max counts	47	0.08	0.71
redo synch time	77	0.13	1.17
redo synch writes	21	0.03	0.32
redo wastage	27,416	45.67	415.39
redo write time	578	0.96	8.76
redo writer latching time	0	0.00	0.00
redo writes	94	0.16	1.42
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	1	0.00	0.02
rows fetched via callback	651	1.08	9.86
session connect time	0	0.00	0.00
session cursor cache hits	515	0.86	7.80
session logical reads	2,834,511	4,721.92	42,947.14
session pga memory	16,784,840	27,961.31	254,315.76
session pga memory max	93,396,424	155,586.03	1,415,097.33
session uga memory	47,244,996,456	78,703,882.90	715,833,279.64
session uga memory max	16,310,784	27,171.60	247,133.09
shared hash latch upgrades - no wait	879	1.46	13.32
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	2,331	3.88	35.32
sorts (rows)	148,188	246.86	2,245.27
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	4	0.01	0.06
table fetch by rowid	1,151	1.92	17.44
table fetch continued row	0	0.00	0.00
table scan blocks gotten	2,819,237	4,696.47	42,715.71
table scan rows gotten	69,745,521	116,186.77	1,056,750.32
table scans (long tables)	0	0.00	0.00
table scans (short tables)	2,628	4.38	39.82
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	209,664	349.27	3,176.73
user I/O wait time	0	0.00	0.00
user calls	4,503	7.50	68.23
user commits	65	0.11	0.98
user rollbacks	1	0.00	0.02
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	387	0.64	5.86
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	1,252,099	1,252,324
opened cursors current	1,329	1,340
logons current	41	41

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)
SYSAUX	0	0	0.00	0.00	229	0	0	0.00
TS_SMS_DATA	0	0	0.00	0.00	97	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	41	0	0	0.00
SYSTEM	0	0	0.00	0.00	19	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Writes
SYSAUX	/app/oracle/oradata/SMS/sysaux01.dbf	229
SYSTEM	/app/oracle/oradata/SMS/system01.dbf	19
TS_SMS_DATA	/app/oracle/oradata/SMS/TS_SMS_DATA.dbf	97
UNDOTBS1	/app/oracle/oradata/SMS/undotbs01.dbf	41

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	1,312,077	100	2,830,511	0	626	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	10	387	4850	18446	737280	18446
E	0	9	192	356	11194	737280	11194

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	1,056	0.10	130,614	1.04	1,528,656
D	2,112	0.20	261,228	1.01	1,492,140
D	3,168	0.30	391,842	1.00	1,471,933
D	4,224	0.40	522,456	1.00	1,470,966
D	5,280	0.50	653,070	1.00	1,470,961
D	6,336	0.60	783,684	1.00	1,470,961
D	7,392	0.70	914,298	1.00	1,470,961
D	8,448	0.80	1,044,912	1.00	1,470,961
D	9,504	0.90	1,175,526	1.00	1,470,961
D	10,560	1.00	1,306,140	1.00	1,470,961
D	10,608	1.00	1,312,077	1.00	1,470,961
D	11,616	1.10	1,436,754	1.00	1,470,961
D	12,672	1.19	1,567,368	1.00	1,470,961
D	13,728	1.29	1,697,982	1.00	1,470,961
D	14,784	1.39	1,828,596	1.00	1,470,961
D	15,840	1.49	1,959,210	1.00	1,470,961
D	16,896	1.59	2,089,824	1.00	1,470,961
D	17,952	1.69	2,220,438	1.00	1,470,961
D	19,008	1.79	2,351,052	1.00	1,470,961
D	20,064	1.89	2,481,666	0.67	985,210
D	21,120	1.99	2,612,280	0.51	754,384

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	10	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	3,204	2,824	143.09	0.00	0.00	0.00	0.00	328,080
E	3,204	2,823	143.46	0.00	0.00	0.00	0.00	328,080

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	376	376
64K	128K	1	1
512K	1024K	10	10

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
401	0.13	766,251.71	700.32	100.00	457
801	0.25	766,251.71	439.58	100.00	409
1,602	0.50	766,251.71	314.42	100.00	298
2,403	0.75	766,251.71	297.67	100.00	181
3,204	1.00	766,251.71	191.85	100.00	4
3,845	1.20	766,251.71	0.00	100.00	4
4,486	1.40	766,251.71	0.00	100.00	4
5,126	1.60	766,251.71	0.00	100.00	3
5,767	1.80	766,251.71	0.00	100.00	3
6,408	2.00	766,251.71	0.00	100.00	3
9,612	3.00	766,251.71	0.00	100.00	2
12,816	4.00	766,251.71	0.00	100.00	1
19,224	6.00	766,251.71	0.00	100.00	0
25,632	8.00	766,251.71	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
400	0.25	196	11,816	3,488,519	0.99	31,472	46.08	79,063,360
576	0.35	355	26,820	3,518,438	1.00	1,553	2.27	79,076,210
752	0.46	530	48,349	3,519,308	1.00	683	1.00	79,076,463
928	0.57	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,104	0.68	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,280	0.78	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,456	0.89	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,632	1.00	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,808	1.11	618	56,973	3,519,308	1.00	683	1.00	79,076,492
1,984	1.22	618	56,973	3,519,308	1.00	683	1.00	79,076,492
2,160	1.32	618	56,973	3,519,308	1.00	683	1.00	79,076,492
2,336	1.43	618	56,973	3,519,308	1.00	683	1.00	79,076,492
2,512	1.54	618	56,973	3,519,308	1.00	683	1.00	79,076,492
2,688	1.65	618	56,973	3,519,308	1.00	683	1.00	79,076,492
2,864	1.75	618	56,973	3,519,308	1.00	683	1.00	79,076,492
3,040	1.86	618	56,973	3,519,308	1.00	683	1.00	79,076,492
3,216	1.97	618	56,973	3,519,308	1.00	683	1.00	79,076,492
3,392	2.08	618	56,973	3,519,308	1.00	683	1.00	79,076,492

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
3,072	0.25	212,355	1,492,143
6,144	0.50	212,355	1,470,961
9,216	0.75	212,355	1,470,961
12,288	1.00	212,355	1,470,961
15,360	1.25	212,355	1,470,961
18,432	1.50	212,355	1,470,961
21,504	1.75	212,206	754,456
24,576	2.00	212,206	754,456

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.14	884	0	3	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 Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
09-Dec 15:23	136	884	0	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
ASM db client latch	388	0.00		0
AWR Alerted Metric Element list	3,405	0.00		0
Consistent RBA	94	0.00		0
FAL request queue	12	0.00		0
FAL subheap alocation	12	0.00		0
FOB s.o list latch	20	0.00		0
In memory undo latch	1,998	0.00		815	0.00
JS mem alloc latch	1	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	4,374	0.00		0
JS slv state obj latch	5	0.00		0
KMG MMAN ready and startup request latch	200	0.00		0
KTF sga latch	2	0.00		188	0.00
KWQMN job cache list latch	1	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			200	0.00
OS process	18	0.00		0
OS process allocation	212	0.00		0
OS process: request allocation	4	0.00		0
PL/SQL warning settings	91	0.00		0
SQL memory manager latch	1	0.00		194	0.00
SQL memory manager workarea list latch	14,369	0.00		0
Shared B-Tree	21	0.00		0
active checkpoint queue latch	585	0.00		0
active service list	1,334	0.00		1,773	0.00
archive control	12	0.00		0
archive process latch	218	0.00		0
cache buffer handles	112	0.00		0
cache buffers chains	5,665,531	30.55	0.00	109	0.00
cache buffers lru chain	1,262	0.00		114	0.00
channel handle pool latch	4	0.00		0
channel operations parent latch	2,765	0.00		0
checkpoint queue latch	20,644	0.00		433	0.00
client/application info	251	0.00		0
commit callback allocation	2	0.00		0
compile environment latch	13	0.00		0
dml lock allocation	1,698	0.00		0
dummy allocation	26	0.00		0
enqueue hash chains	12,005	0.00		6	0.00
enqueues	12,417	0.02	0.00	0
event group latch	2	0.00		0
file cache latch	21	0.00		0
hash table modification latch	1	0.00		0
job workq parent latch	0			22	0.00
job_queue_processes parameter latch	21	0.00		0
kks stats	7	0.00		0
kokc descriptor allocation latch	10	0.00		0
ksuosstats global area	42	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	21	0.00		0
lgwr LWN SCN	242	0.00		0
library cache	24,393	1.18	0.00	0
library cache lock	5,943	0.00		0
library cache lock allocation	280	0.00		0
library cache pin	11,194	2.05	0.00	0
library cache pin allocation	60	0.00		0
list of block allocation	40	0.00		0
messages	4,828	0.00		0
mostly latch-free SCN	242	0.00		0
ncodef allocation latch	10	0.00		0
object queue header heap	2,340	0.00		0
object queue header operation	4,159	0.00		0
object stats modification	1	0.00		0
parallel query alloc buffer	76	0.00		0
parameter list	20	0.00		0
parameter table allocation management	27	0.00		0
post/wait queue	56	0.00		27	0.00
process allocation	4	0.00		2	0.00
process group creation	4	0.00		0
qmn task queue latch	84	0.00		0
redo allocation	2,206	0.00		1,193	0.00
redo copy	0			1,193	0.08
redo writing	1,275	0.00		0
resmgr group change latch	63	0.00		0
resmgr:active threads	23	0.00		0
resmgr:actses change group	11	0.00		0
resmgr:free threads list	22	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	8,797	0.00		0
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
sequence cache	55	0.00		0
session allocation	4,983	0.18	0.00	0
session idle bit	11,430	0.02	0.00	0
session state list latch	34	0.00		0
session switching	10	0.00		0
session timer	210	0.00		0
shared pool	824	0.00		0
shared pool simulator	7,711	0.00		0
simulator hash latch	145,224	0.00	0.00	0
simulator lru latch	626	0.00		144,588	25.92
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	15	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
threshold alerts latch	45	0.00		0
transaction allocation	32	0.00		0
transaction branch allocation	210	0.00		0
undo global data	703	0.00		0
user lock	22	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
cache buffers chains	5,665,531	1,731,088	11	1,731,077	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
cache buffers chains	kcbgtcr: kslbegin excl	298	282
cache buffers chains	kcbrls: kslbegin	6	22
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: 2,834,511
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SMS	TS_SMS_DATA	SMS_LIST	TABLE	2,800,240	98.79
SMS	TS_SMS_DATA	SMS_ACCESSSYSTEM	TABLE	4,336	0.15
SMS	TS_SMS_DATA	SMS_TEMPLIST	TABLE	3,888	0.14
SYS	SYSTEM	I_SYSAUTH1	INDEX	1,664	0.06
SMS	TS_SMS_DATA	PK$SMS_TEMPLIST	INDEX	752	0.03

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

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	Mod Reqs	Final Usage
dc_awr_control	13	2	1
dc_database_links	1	0	1
dc_global_oids	58	0	144
dc_object_ids	95	0	2,482
dc_objects	87	4	2,258
dc_profiles	12	0	1
dc_rollback_segments	71	0	22
dc_sequences	2	2	10
dc_tablespaces	731	0	9
dc_usernames	379	0	61
dc_users	1,468	0	80
outstanding_alerts	17	1	16

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss
BODY	117	0.00	2,644	0.00
SQL AREA	217	0.92	5,781	0.22
TABLE/PROCEDURE	39	0.00	2,763	0.00
TRIGGER	8	0.00	25	0.00

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	106.37		2.47	5.42	22	8,173	43	43
	Freeable	33.00	0.00	1.10	0.70	4		30	30
	SQL	2.60	1.09	0.08	0.06	0	33	33	31
	PL/SQL	1.14	0.86	0.03	0.02	0	11	41	41
E	Other	106.00		2.47	5.42	22	8,173	43	43
	Freeable	33.75	0.00	1.09	0.68	4		31	31
	SQL	2.62	1.10	0.08	0.06	0	33	33	31
	PL/SQL	1.11	0.87	0.03	0.02	0	11	41	41

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	11,123,294,208
Fixed Size	2,105,920
Redo Buffers	14,667,776
Variable Size	1,744,833,984

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	CCursor	46.79	46.80	0.01
shared	Heap0: KGL	16.46	16.46	0.03
shared	KQR M SO	43.27	43.27	0.00
shared	db_block_hash_buckets	90.00	90.00	0.00
shared	free memory	1,038.60	1,038.59	-0.00
shared	library cache	27.28	27.28	0.00
shared	sql area	203.69	203.69	0.00
	buffer_cache	10,608.00	10,608.00	0.00
	fixed_sga	2.01	2.01	0.00
	log_buffer	13.99	13.99	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	/app/oracle/admin/SMS/adump
background_dump_dest	/app/oracle/admin/SMS/bdump
compatible	10.2.0.3.0
control_files	/app/oracle/oradata/SMS/control01.ctl, /app/oracle/oradata/SMS/control02.ctl, /app/oracle/oradata/SMS/control03.ctl
core_dump_dest	/app/oracle/admin/SMS/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	SMS
db_recovery_file_dest	/app/oracle/flash_recovery_area
db_recovery_file_dest_size	21474836480
dispatchers	(PROTOCOL=TCP) (SERVICE=SMSXDB)
job_queue_processes	10
log_archive_dest_1	location=/app/oracle/arch
open_cursors	300
pga_aggregate_target	3359637504
processes	450
remote_login_passwordfile	EXCLUSIVE
sessions	500
sga_max_size	12884901888
sga_target	12884901888
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/app/oracle/admin/SMS/udump

End of Report

% Blocks changed per Read:	0.07	Recursive Call %:	78.15
Rollback per transaction %:	1.52	Rows per Sort:	63.57

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.88	Soft Parse %:	99.94
Execute to Parse %:	68.57	Latch Hit %:	71.06
Parse CPU to Parse Elapsd %:	140.00	% Non-Parse CPU:	99.46