DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: deadlocks, rowlock and tablelocks

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    How can we simulate a deadlock, rowlock, tablelock?
    What are the tables it will involve?
    How do we debug and take care of the issue??
    thanks,

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    table lock: lock table <table_name > exclusive;
    row lock: select <column_name(s)> for update ....;
    deadlock : Have to be very bad developer.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width