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

Thread: delete stament locking users - any help appreciated!!!

  1. #1

    Question

    Hello Gang,

    I have a third party application. My users have started using it full fledged recently and since then I have this great job of killing sessions because they seem to get locked!

    The statement in question is a delete statement which says

    delete table x where
    y='....'

    or something of that sort, as in there is a where clause which specifies what rows to delete. My problem is that no two users will be accessing the same set of rows and still they get locked. What could be the problem and what is the solution?

    Any help in this regard is appreciated.

    Thanks,
    have a nice day,
    -Shyami
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    1) Is 'COMMIT' or 'ROLLBACK' missing in application after DELETE statement..

    Otherwise there should not be any problem even though two users are deleting same set of rows...

    If first user issues a delete statement

    f.ex

    DELETE FROM test WHERE id =1;

    and if he doesn't COMMIT/ROLLBACK after deleting rows..

    second user will hang if he tries to delete same set of rows.. here is exm..

    DELETE FROM test WHERE id =1;

    2) Or Is there any messgage dialog box which gets confirmation of DELETE operation??.. and then COMMITS/ROLLBACK based on user response..

    In this case.. there is a possibility of missing COMMIT/ROLLACBK statements.... Sometimes application programmers do miss these things which creates such problems..


    HTH

    Sameer

    [Edited by Sameer on 09-17-2002 at 06:45 AM]

  3. #3
    Thanks Sameer, being a third party application I do not know if there is a commit or rollback after the delete statement. I can always ask the provider though.

    Thanks again,
    -Shyami
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

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