Re: library cache lock is blocking ?

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