Re: library cache lock is blocking ?

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Fri, 18 Jul 2008 08:57:26 +0900
Message-ID: <43c2e3d60807171657g6ec146d2r7447f4b4871180a6@mail.gmail.com>


Which means somebody(session) is holding library cache lock in exclusive mode for a such long time.
Might be bug or some session doing evil things?

Following query will help.

select * from dba_lock_internal
where lock_id like '%MYTABLE%'
;

See source of dba_lock_internal for more info.

Dion Cho

2008/7/18 Dba DBA <oracledbaquestions_at_gmail.com>:

> I am trying to describe a table. It just hangs. So I ran a 10046 trace and
> I get back is library cache locks.
>
> on a describe? I get the same lock when I try to query it. It just blocks
> on it.
>
> anyone ever see this before? This is from sqlplus. I run
>
> desc mytable
>
> it hangs and trace says library cache lock.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 17 2008 - 18:57:26 CDT

Original text of this message