Re: Killed sessions

From: Sergey Balter <balter_at_kompas.donetsk.ua>
Date: Fri, 21 Jan 2005 17:30:59 +0200
Message-ID: <csr77o$uoi$1@news.dc.ukrtel.net>

This behavior is known.
Oracle doesn't remove killed session, they may hang in v$sessions for years :-)
Theoretically killed session have to be
automatically cleaned within minutes or hours.

By the way, the first user interaction with a killed session really remove the session from v$session. For instance, if a client application try to perfome any OCI call to it's session that have been killed.

I have no idea why this staff is neccessary for Oracle, but this behavior is the same for Oracle 7, 8 an 9.

Really it can bring serious troubles for developer or DBA. The problem is that a killed session holds locks. Even when all changes made by the session have been rollbacked...

The known way to solve this is:
to kill the killed session again with the ORAKILL utility.

Regards
Sergey Balter Received on Fri Jan 21 2005 - 09:30:59 CST