Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dba_hist_active_sess_history -- retention of data

708725Nov 23 2009 — edited Apr 26 2012
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2012
Added on Nov 23 2009
7 comments
10,366 views