Re: No blocking session for wait event: 'Library cache pin'
Date: Tue, 2 Aug 2011 14:38:21 -0700
Message-ID: <CAJ2uQaeOqwqhH9BqiNfX_SJi3qVQXJzDDutHYkfVL3HL-FtUcw_at_mail.gmail.com>
Thanks Marcin,Mark for clarification - will keep this in mind in future.
~ Sanjeev.
On Tue, Aug 2, 2011 at 2:17 PM, Marcin Przepiorowski <pioro1_at_gmail.com>wrote:
> On Tue, Aug 2, 2011 at 7:19 PM, Sanjeev M <sanjeevorcle_at_gmail.com> wrote:
> >
> > select p1raw,p1text,event,sid from v$session where sid=1710;
> > P1RAW
> > P1TEXT
> > EVENT
> SID
> > ----------------
> > ----------------------------------------------------------------
> > ----------------------------------------------------------------
> ----------
> > 0000000356213B10 handle
> > address library cache
> > pin 1710
>
> Hi,
>
> Add wait_time to your query
>
> select p1raw,p1text,event,sid, wait_time from v$session where sid=1710;
>
> If wait_time = 0 session is waiting
> If wait_time <> 0 session is on CPU but event and p1 columns still
> have old values (Oracle is lazy and doesn't clean it)
>
> Probably this is why you have different output from your query and Tanel's
> tool.
> If session is on CPU you need to analyse session stats (add stats and
> gather to snapper) and take a look here -
> http://blog.tanelpoder.com/2010/01/15/beyond-oracle-wait-interface-part-2/
>
> --
> Marcin Przepiorowski
> http://oracleprof.blogspot.com
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 02 2011 - 16:38:21 CDT