| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help : session stuck with library cache
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Polarski, Bernard
Sent: Tuesday, October 03, 2006 4:12 AM
To: knecht.stefan_at_gmail.com; oracle-l_at_freelists.org
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
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 04 2006 - 09:29:31 CDT
 |
 |