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




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




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.

        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





        Do You Yahoo!?
        Tired of spam? Yahoo! Mail has the best spam protection around <>  

        Jared Still
        Certifiable Oracle DBA and Part Time Perl Evangelist

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

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 

Other related posts: