> 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