library cache lock is blocking ?
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Thu, 17 Jul 2008 16:03:52 -0400
Message-ID: <f30139790807171303r4faefe47gf847dee08827c362@mail.gmail.com>
Date: Thu, 17 Jul 2008 16:03:52 -0400
Message-ID: <f30139790807171303r4faefe47gf847dee08827c362@mail.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-lReceived on Thu Jul 17 2008 - 15:03:52 CDT