V$active session history
From: Mohamed Houri <mohamed.houri_at_gmail.com>
Date: Wed, 18 Mar 2015 17:57:39 +0100
Message-ID: <CAJu8R6hqPRxeRt9Wit=XiO__pqXmBE_d=fXEJqps3zG0PLAypA_at_mail.gmail.com>
Dears
This morning i was monitoring an insert/select using sql monitor in 11.2.0.3. The insert was busy reading a unique index 3 millions times showing cpu and db file sequential read at this particular line. Tanel poder snapper shows that the correspinding sql_id id on cpu and db file sequential read. But gv$active_session_history shows no rows for the same moment
Is it because each unique index scan takes less than 1 sec that it is not stored in gv$active_session_history?
Thanks
Date: Wed, 18 Mar 2015 17:57:39 +0100
Message-ID: <CAJu8R6hqPRxeRt9Wit=XiO__pqXmBE_d=fXEJqps3zG0PLAypA_at_mail.gmail.com>
Dears
This morning i was monitoring an insert/select using sql monitor in 11.2.0.3. The insert was busy reading a unique index 3 millions times showing cpu and db file sequential read at this particular line. Tanel poder snapper shows that the correspinding sql_id id on cpu and db file sequential read. But gv$active_session_history shows no rows for the same moment
Is it because each unique index scan takes less than 1 sec that it is not stored in gv$active_session_history?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 18 2015 - 17:57:39 CET