Re: library cache lock is blocking ?

From: 조동욱 <>
Date: Fri, 18 Jul 2008 08:57:26 +0900
Message-ID: <>

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 <>:

> 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.

Received on Thu Jul 17 2008 - 18:57:26 CDT

Original text of this message