Re: library cache lock is blocking ?
Date: Fri, 18 Jul 2008 08:57:26 +0900
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.
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.