Re: library cache load lock

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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l