Try this sql to know what all sessions are holding the locks and kill
them. You may also want to dig further to know about what kind of
activies this sessions performing.


col kgllkmod heading "lockmode"
col kgllkreq heading "reqmode"
col kglnaobj heading "objname"
select ses.sid, ses.serial#,lck.* from x$kgllk lck , v$session ses
where kgllkhdl in
(select kgllkhdl from x$kgllk where kgllkreq >0)
and lck.KGLLKUSE = ses.saddr
Order by lck.KGLNAOBJ


Gaurav

-----Original Message-----
From: Rajendra Mohanty
[mailto:oracledba-ezmlmshield-x19784048.[Email address protected]
Sent: Monday, January 07, 2008 2:57 PM
To: LazyDBA Discussion
Subject: Library Cache Lock

Dear Experts,

In one of my Production Box(Oracle 10g), there are three sessions go
into
waits for Library Cache Lock.

Can any one advice the what are the cause and how can I release these
locks.

Thanks in advance,
-Raj


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page