Table Locking
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Table Locking

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Table Locking

    Hello All,

    I have a query (an UPDATE query) which when run, locks one of the tables its trying to access. I know that table locks can be caused by non-indexed foreign keys i.e when a non-indexed foreign key is updated, the parent table will be subjected to a table lock until the transaction is complete. However, my question is: Are there any other circumstances which cause these table locks? And how do you prevent them?

    Any help will be greatly appreciated!
    Thanks
    Chucks_k

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    For prevening undesired locking
    1. As far as possible do not exlussively lock the table.
    2. Frequently commit (or Rollback) your transactions

    Regards

    Viraj
    -----------
    OCP 9i DBA
    A Wise Man Knows How much he doesn't know !!!

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