lock on the table

[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.

[marist89]

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.

[orafup]

yeahhh v$locked_objects is a fastest way to solve lock situation....Ask your DBA do it for you....