Re: V$active session history

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 19 Mar 2015 13:11:01 -0500
Message-ID: <CAMHX9JKeT1wZH=xC1HuAJRazR6kiGL3QZCD5dm-P-FR15zm5iw_at_mail.gmail.com>

How did you query ASH ... which filters - by SQL_ID or by the SID of the session (and a known time range)?

--
Tanel.

On Wed, Mar 18, 2015 at 11:57 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 - 19:11:01 CET