Archive for March, 2010

Converting lock modes to determine what the root cause is

Monday, March 15th, 2010

Take name|mode print hex(1415053316) …and convert to hex… 0x54580004 …then take the first two, second two, and last four values to get the reason code. 54 in hex = T 58 in hex = X and 0004 = 4. This lock was caused by the same unique key values being inserted (or attempting to) by multiple sessions. »

Posted in Oracle | 1 Comment »

Switch to our mobile site