Oracle Database Discussions

Hi All,

        I am using Release 11.2.0.3.0 version of oracle . I can see , in general, the sample time in dba_hist_active_sess_history each with a interval of 10 second. in other words each consecutive samples have 10seconds difference between each other.

  But for some of the cases i can see for same session_id and session_serial# there is more than 2hrs of difference between consecutive samples.So my question is, what activity, the session was doing withinn that time interval of time and why its not get sampled in dba_history_active_sess_history?

Given below is part of the continuous data, for same session, session_serial# order by sample_time desc.

Session       Session-seial Sample_time    Session_state   Event