Re: library cache pin wait
From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Sun, 5 Oct 2008 13:48:16 -0700
Message-ID: <2ead3a60810051348p14801309l639fafb5a71ca3d1@mail.gmail.com>
Date: Sun, 5 Oct 2008 13:48:16 -0700
Message-ID: <2ead3a60810051348p14801309l639fafb5a71ca3d1@mail.gmail.com>
> 2. I check v$sess_io and no IO is incrementing for this session.
Why not check V$ACCESS for this object? That should show you the other sessions that are pinning this object...
-- John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 05 2008 - 15:48:16 CDT