-
no no no
if you kill the session from the O/S side, the process is gone right away and it's not suppose to mark to kill. I got rid of the process from the O/S side but I still see the lock on the table, that's right I don't understand.
-
Originally posted by mike2000
no no no
if you kill the session from the O/S side, the process is gone right away and it's not suppose to mark to kill. I got rid of the process from the O/S side but I still see the lock on the table, that's right I don't understand.
If the session still has the table locked, I would say that proves your theory wrong.
Jeff Hunter
-
yeahhh v$locked_objects is a fastest way to solve lock situation....Ask your DBA do it for you....
nguyenjl
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
|