Re: No blocking session for wait event: 'Library cache pin'
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Tue, 2 Aug 2011 22:17:10 +0100
Message-ID: <CAGdek=x7mzGk-91rEi4c-864os8Y8L5Ne3iDYfYdNn3ibbuUCg_at_mail.gmail.com>
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
Date: Tue, 2 Aug 2011 22:17:10 +0100
Message-ID: <CAGdek=x7mzGk-91rEi4c-864os8Y8L5Ne3iDYfYdNn3ibbuUCg_at_mail.gmail.com>
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:17:10 CDT