library cache lock

From: Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 5 Mar 2004 09:14:17 -0500
Message-ID: <F2AE82A3FD89334EA21F6C761C541A70678FD2@ap3expr06applge.appl.ge.com>

Oracle 9.2.0 on hp-ux 11

An attempt to truncate a table is hanging for a very long time.

The processes is waiting over and over for 'library cache lock' for the same p1 and p2 (handle address and lock address respectively).

Shouldn't the P2 value (lock_address) map to a KADDR in v$lock?

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Don't ask a man what kind of computer he uses. If it's a Macintosh, he'll tell you.
If not, why embarass him? -- Tom Clancy

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Mar 05 2004 - 08:19:05 CST