Re: Killed session

Re: Killed session

 

  

When rollback is complete and pmon cleans up, it will disappear. Until
then you can do nothing...

>>> Prakriteswar Santikary <prakriteswar.[Email Address Removed] 11:49AM >>>

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] 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

Oracle LazyDBA home page