It will only go away when the user attempts to
reconnect. You should kill from the OS side whenever
possible so this doesn't happen.

Mike
--- Prakriteswar Santikary
<prakriteswar.[Email Address Removed] wrote:
>
> Hi,
>
> I killed a session using alter system kill
> session(sid,serial#).
> But the session is still visible under v$session
> with status 'killed'.
> How to get rid of this killed session ?
>
> thanks
> Santi
>
> Prakriteswar Santikary
> Professional Services
> POINT Information Systems, Inc.
> 65 William Street, Suite 150
> Wellesley, MA 02481
> Phone: (781) 416-7905
> Fax: (781) 416-7901
>
> mailto:prakriteswar.[Email Address Removed] www.pointinfo.com
>
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


=====
Michael R. Ault
Senior Technical Management Consultant
TUSC
The Ultimate Software Consultants
The Oracle Experts
WWW.TUSC.COM

__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
Oracle LazyDBA home page