Quote:
Originally posted by slimdave
I think i read advice in an Oracle doc that developers should follow a pattern of always locking master reccords before child, or vice versa (it doesn't matter as long as it's consistent everywhere), to reduce the probability of deadlocking. Seems like good advice.
While I'll agree with HRISKY, SANJAY_G, and JMAC about letting the ORACLE handle the LOCK management, I can only bear with this, only if the design of the application is good or better. Otherwise if it is bad, like what I'm in right now and the developers doesn't have any intension of re-designing the structure or re-program(major changes).