Re: library cache lock is blocking ?
- From: "조동욱" <ukja.dion@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- 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.
Dion Cho
2008/7/18 Dba DBA <oracledbaquestions@xxxxxxxxx>:
> 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.
>
Other related posts:
