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
