RE: library cache load lock

From: Potluri, Venu (CT) <venu_potluri_at_ml.com>
Date: Wed, 6 Jul 2005 15:19:41 -0400
Message-ID: <F65245818C52764E83192CFDA540095A07E82516@mlnyb705mb.amrs.win.ml.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Wednesday, July 06, 2005 3:01 PM
To: Jared Still
Cc: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_yahoo.com> 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/

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 06 2005 - 14:22:46 CDT