RE: library cache load lock
- From: "Potluri, Venu (CT)" <venu_potluri@xxxxxx>
- To: <smishra_97@xxxxxxxxx>, "Jared Still" <jkstill@xxxxxxxxx>
- Date: Wed, 6 Jul 2005 15:19:41 -0400
I had this problem recently in our Oracle Applications database. Had a
TAR open with Oracle Support and they proved to be useless, as it
happens more often than not. I couldn't get them to give me a sure fire
way to identify the session causing the others to wait on this event.
There is a doc on metalink that describes how to troubleshoot this. The
name escapes me but search on something like "how to troubleshoot
library cache clock". Everytime I saw this wait event, I took a system
state dump and looked at the trace file which could help in identifying
the offender. It was largely a futile exercise as I could never identify
the offender in two weeks using what Oracle had given me. Good luck.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
Sent: Wednesday, July 06, 2005 3:01 PM
To: Jared Still
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: library cache load lock
Jared
Thanks for quick reply. I had no record in both blockers and Waiters
view. I had killed the session appeared in DBa_jobs_running and even
killed the snp_process and now I am not getting any snp process started
even the Job_queue_process are 8.
ANy suggestions. Lock are still same for all sid appeared in
Dba_jobs_runing and appeared in v$session_wait
Thanks
Sanjay
Jared Still <jkstill@xxxxxxxxx> wrote:
Have you examined dba_blockers/dba_waiters to see which session
is causing the contention?
Maybe it needs to be killed?
We have a similar issue at times with a misbehaving app. The
processes on the app server
dies, leaving a lock on a table.
TCP being what it is, the database never knows that the client
process has died, and we
( meaning me) must go kill the process.
Yes, I have a potential work-around for that, still waiting for
user testing.
Jared
On 7/6/05, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
I have several of these shown in the v$session_wait. Any idea as
what need to be done. SOme of the them are linked to mine Job QUeue
process. So all 7 Job processa re hanged and each have is showing this
lock
TIA
Sanjay
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com/>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
Other related posts:
