AWR Snapshot Repository


select * from dba_hist_snapshot order by snap_id desc;

begin
 dbms_workload_repository.create_snapshot();
 end;

select * from dba_hist_wr_control;

begin
 -- After a 30-minute periods during the month
 DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention => 43200 , interval => 30 )
 end ;

-- displays the history of the contents of the in-memory active session history for recent system activity.
 select * from DBA_HIST_ACTIVE_SESS_HISTORY
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: