Preventing deadlocks. The DBA should recommend to developers that they try to set their processes up such that all processes acquire locks in the same order. This will prevent the situation where processes acquire locks on resources that others need in reversed order, which has a high probability of creating deadlock situations
Hey,

Can anyone explain me how to set up the processes mentioned above...
Pl...don't ask me to read.....got doubt only on reading....getting lot of deadlock issues.....

Thanks in advance...

------------------------------------------------------------------
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."

Now u know why I am getting doubt!!!!!!!!!!