Open 2 SQLPLUS sessions.
Table Lock :
Lock one in one session, and try to update the same table in another session.
Dead Lock:
Lock Table_A in one session
Lock Table_B in 2nd session.
Update Table_B in first session
Update Table_A is 2nd session.
Now look into alert.log file for the dead lock deduction.




Reply With Quote