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.
Printable View
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.Quote:
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.
yeahhh v$locked_objects is a fastest way to solve lock situation....Ask your DBA do it for you....