-
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..
-
How many rows do you plan to update in a table?
Tamil
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|