Funny, I had this exact same thing happen Monday ( I was off yesterday) in a 9.2.0.5 dev DB. Turned out that a dev was trying to recompile a package (at my request), but a sniped process had a lock on a dependant object. Ended up bouncing the instance when PMON refused to clean it up (my main reason for never ever killing a session from within Oracle -- always kill at the OS level). GL! Rich ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Polarski, Bernard Sent: Tuesday, October 03, 2006 4:12 AM To: knecht.stefan@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Help : session stuck with library cache The problem is that v$sesson_io show no activity, so I set the session on trace mode and no trace file create since nothing moves : Date - Tuesday 03rd October 2006 11:09:25 Username - SYS User Hard Blocks Consistent Consistent Physical Sid username osuser ospid Com HASH_VALUE Type Cpu Parse Changes Changes Gets Reads %Hit ---- -------- -------- ---------- --- ---------- ---- -------- ------- --------- ---------- ---------- ---------- ---- 26 SYSTEM oracle 324799 3 4174678299 USER 564.81 17 4588 20 912 387 92.9 Date - Tuesday 03rd October 2006 11:09:26 Username - SYS User Hard Blocks Consistent Consistent Physical Sid username osuser ospid Com HASH_VALUE Type Cpu Parse Changes Changes Gets Reads %Hit ---- -------- -------- ---------- --- ---------- ---- -------- ------- --------- ---------- ---------- ---------- ---- 26 SYSTEM oracle 324799 3 4174678299 USER 564.81 17 4588 20 912 387 92.9