Re: library cache pin wait

  • From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
  • To: oracledbaquestions@xxxxxxxxx
  • Date: Sun, 5 Oct 2008 13:48:16 -0700

> 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 **
--
//www.freelists.org/webpage/oracle-l


Other related posts: