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

Thread: table locking

  1. #1
    Join Date
    Oct 2000
    Hi guys,
    After a full delete on a table, if a commit is not issued, and if some other user wants to insert new data , his(2nd user's) sqlplus session goes hanging indefinetely. Is there a parameter to set some sort of timeout process and kill the faulty user's session(in this case the 1st user) when he accidentally deletes and say walks out to lunch without committing.
    I checked the behaviour for insert operations. If first user inserts a row and does not commit, the 2nd user does not get to see the data that was inserted by first user and not committed. However the 2nd user can continue to work otherwise like inserting fresh rows.

  2. #2
    Join Date
    Feb 2000
    Washington DC
    See the thread 'Lock Issue' started by ckwan on 12/20/00 which may be of little helpful...

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