Essentially, you cannot. You can do a shutdown abort of the database, and
restart it so that it can go into recovery mode and clean up, but that
should be used only for *emergencies*.

Oracle needs time for the session's processes to exit gracefully and
recover.

Good Luck!
Chris

----------------------------------------------------
Chris Weiss, Blueoak Database Engineering, LLC
http://www.blueoakdb.com
PH: 517-381-9305
CELL: 517-974-5634
eFAX: 801-340-0740


-----Original Message-----
From: Amuthamukesh Sivaji
[mailto:oracledba-ezmlmshield-x63233566.[Email address protected]
Sent: Friday, October 29, 2004 10:15 AM
To: LazyDBA Discussion
Subject: How to clear session


Hi

How to clear sessions that marked for Killed.

Mukesh


Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual or entity to whom
it is addressed and may contain information that is privileged,
confidential, or exempt from disclosure under applicable law. If you are not
the intended recipient of this EMAIL immediately notify the sender at iGATE
or [Email address protected] and delete this EMAIL including any
attachments.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page