Re: library cache pin wait

From: John Kanagaraj <>
Date: Sun, 5 Oct 2008 13:48:16 -0700
Message-ID: <>

> 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 <>< (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 **
Received on Sun Oct 05 2008 - 15:48:16 CDT

Original text of this message