Re: V$active session history

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Thu, 19 Mar 2015 07:37:21 +0800
Message-ID: <CAMNBsZuVoX0QTz49=JVR0Nn6_0Qpckrm6zwetoxZCBLmr9DQyQ_at_mail.gmail.com>

At least some of the snapshots should have shown up as ON_CPU.

Sent from my smart phone.
Hemant K Chitale
On 19-Mar-2015 12:59 AM, "Mohamed Houri" <mohamed.houri_at_gmail.com> wrote:

> 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-l

Received on Thu Mar 19 2015 - 00:37:21 CET