If it's Unix you may need to kill the Unix side of the job. Look for
something like:
(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
This happens to us all of the time where the Unix job won't let go.
Outside tools (non Unix side tools) like TOAD, C programs, SAS and such
latch on to Oracle and sometimes just won't let go. This will also hang a
shutdown ... we've figured out on our system that if we kill these pesky
connections that the database can be shutdown immediate instead of abort.
I've also heard that on some systems forcing a logswitch will also help them
clear. This is not the case on my system but it's worth a try.
-----Original Message-----
From: Prakriteswar Santikary
[mailto:prakriteswar.[Email Address Removed] Friday, March 29, 2002 9:50 AM
To: LazyDBA.com Discussion
Subject: Killed session
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] 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] 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
********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
Oracle LazyDBA home page