1 Reply Latest reply: May 29, 2014 9:55 PM by Top.Gun RSS

    v$active_session_history

    1000268

      Hi All,

       

      v$active_session_history is only showing the data for current date. how do i see old data? (say sysdate -3)

       

      ==================================================================

      SQL> select max(SAMPLE_TIME) from v$active_session_history;

       

      MAX(SAMPLE_TIME)

      ---------------------------------------------------------------------------

      29-MAY-14 10.35.11.010 AM

       

      SQL> select min(SAMPLE_TIME) from v$active_session_history;

       

      MIN(SAMPLE_TIME)

      ---------------------------------------------------------------------------

      29-MAY-14 01.18.42.355 AM

       

      SQL> !date

      Thu May 29 10:37:02 EDT 2014

       

      ===========================================================================

       

      Regards.