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

Thread: Update hanging

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Update hanging

    hi,
    My update stamement is hanging......

    Once i issue the statement, it keeps running forever...
    How can i check, any locks on the table has been obtained by any session..

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    How many rows do you plan to update in a table?

    Tamil

  3. #3
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    Check from v$lock

  4. #4
    Join Date
    Aug 2003
    Location
    Dhahran
    Posts
    33
    If you can identify the SID for the session it might be better to check the V$SESSION_WAIT view to see what it is waiting for. If it is actually doing the update that will show. If it is waiting on something else (and it might not be a lock) then that will show too.

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