dba_hist_active_sess_history -- retention of data
708725Nov 23 2009 — edited Apr 26 2012Hi,
With dba_hist_active_sess_history table data, how long back I go to see my session related information.?
I checked retention period with following query:
select snap_interval, retention
from dba_hist_wr_control;
SNAP_INTERVAL RETENTION
+00 01:00:00.000000 +40150 00:00:00.000000
It means session history remains for more than 100 years (Retention here is days to second column). Then also I m getting data for last 6 months only.
I want to keep all the session information for atleast 1 year in my database.
How can I do that?
Thanks in Advance,
Api