Subject How to release or kill deadlock process ?
Author Mohd. Jeffry
Here is my output from fb_lock_print...

LOCK_HEADER BLOCK
Version: 15, Active owner: 0, Length: 36896768, Used: 36883652
Lock manager pid: 1958
Semmask: 0x6904, Flags: 0x0001
Enqs: 1644978588, Converts: 1144012, Rejects: 7129637, Blocks: 2581127
Deadlock scans: 313, Deadlocks: 55, Scan interval: 10
Acquires: 2050345641, Acquire blocks: 294394149, Spin count: 0
Mutex wait: 14.4%
Hash slots: 2039, Hash lengths (min/avg/max): 21/ 31/ 46
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (18): forward: 27580, backward: 22061436
Free owners (61): forward: 22062272, backward: 12176256
Free locks (110726): forward: 31096816, backward: 4781640
Free requests (408845): forward: 24276128, backward: 16494776
Lock Ordering: Enabled

It shows that there are 55 deadlocks. How to troubleshoot this ?

--
Malaysian Java Online Community ( www.kampungjawa.cjb.net )