Stefan,
The session stays in the KILLED status because of a lot of reasons - the
primary being the rollback being performed for all the changes the session
did. At some point the session rollback will be complete and the session
will be removed. Don't worry about the session being there.
HTH.
It should disappear eventually, it sometimes takes a while.
Try the immediate clause next time, they don't usually hang around.
alter system kill session 'sid,serial' immediate;
-Original Message-
From: Stefan Jahnke [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 8:54 AM
To:
Use orakill first, rather than using 'alter session kill', it's more
reliable. You'll have to wait for Oracle to clean up the session.
On occasion the only way to clean it up is bounce the database,
which is why I always use kill -9 or orakill to start with.
Jared
On Friday 21 March 2003