Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: library cache load lock

RE: library cache load lock

From: Potluri, Venu (CT) <>
Date: Wed, 6 Jul 2005 15:19:41 -0400
Message-ID: <>

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

[] On Behalf Of Sanjay Mishra Sent: Wednesday, July 06, 2005 3:01 PM
To: Jared Still
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 <> 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 <> 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 <>  

	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 e-mail.

-- Received on Wed Jul 06 2005 - 14:22:46 CDT

Original text of this message