library cache lock

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