The performance of the system goes down and in the EM Console the
Concurrancy and Application usages are very high.

Thanks again for reply.
-Raj

-----Original Message-----
From: Gaurav Shrivastava [mailto:G.[Email address protected]
Sent: Tuesday, January 08, 2008 1:44 AM
To: Rajendra Mohanty; LazyDBA Discussion
Subject: RE: Library Cache Lock

NO, I will not advice it. Does this locks causing any problems in your
system ?

-----Original Message-----
From: Rajendra Mohanty [mailto:[Email address protected]
Sent: Monday, January 07, 2008 3:12 PM
To: Gaurav Shrivastava; 'LazyDBA Discussion'
Subject: RE: Library Cache Lock

Thank you very much for the reply!

These are the sessions and used by SYS user.


SID SERIAL# ADDR USER_NAME KGLNAOBJ
------------------------------------------------------------------------
----
--------
148 4578 FFFFFFFF7B3A5F00 SYS
WRH$_ACTIVE_SESSION_HISTORY
121 40 FFFFFFFF7B3A85C0 SYS
WRH$_ACTIVE_SESSION_HISTORY
135 3384 FFFFFFFF7B3AC800 SYS
WRH$_ACTIVE_SESSION_HISTORY
141 19722 FFFFFFFF7B3AAF78 SYS
WRH$_ACTIVE_SESSION_HISTORY

Can you please advice me! Should I kill these sessions.

Once again thanks!
-Raj

-----Original Message-----
From: Gaurav Shrivastava [mailto:G.[Email address protected]
Sent: Tuesday, January 08, 2008 1:32 AM
To: [Email address protected]
Subject: RE: Library Cache Lock

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed any
attachments, and kept your email address secret **from this person, and any
viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


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
[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