I killed a session on a local database using "alter system kill session"
command. But, in v$session, there is still a recordsed with that session,
marked as killed (db version 9.2.0.1).
How could I really delete this session, because I think it's causing me some
problems?
Also, how could I know which objects (tables, packages) are locked by some
session?
tnx in advance