library cache lock

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: