Skip to content
August 18, 2014 / doganay

TOP 5 EVENTS OF AWR USING SELECT

select * from
(
SELECT rownum r,output
FROM TABLE (
DBMS_WORKLOAD_REPOSITORY.awr_report_text (
(SELECT dbid FROM v$database),
(SELECT instance_number FROM v$instance),
(SELECT MIN (snap_id)
FROM dba_hist_snapshot
WHERE end_interval_time >=
TO_DATE (
'18.08.2014 08:00:00',
'dd.mm.yyyy hh24:mi:ss')
AND instance_number =
(SELECT instance_number FROM v$instance)),
(SELECT MAX (snap_id)
FROM dba_hist_snapshot
WHERE end_interval_time <= TO_DATE ( '18.08.2014 09:00:00', 'dd.mm.yyyy hh24:mi:ss') + 10 / 1440 AND instance_number = (SELECT instance_number FROM v$instance))))
)
where r>=55 and r<=65;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: