Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered:

    Impact of using a SELECT.... FOR UPDATE of NOWAIT statement

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    If you don't get an error (which indicates that at least one of the records in the resultset is locked) then you get an exclusive lock on all of those records (for all tables in the FROM clause).

    You won't see much impact on the system until someone else tries to change those records, and if they get blocked and put into a WAIT state, then the CPU will be used to continually check & see if the record's free. The more users waiting, the more CPU.

    --=cf

Posting Permissions

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