library cache lock

  • From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 5 Mar 2004 09:14:17 -0500

Oracle 9.2.0 on hp-ux 11

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

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@xxxxxxxxxxx
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

Other related posts: