Thanks Ian, for making me RTFM on 'kill session'.
I wasn't aware of the 'immediate' clause.
Jared
On Tuesday 03 July 2001 22:35, MacGregor, Ian A. wrote:
> "alter system kill session '<sid>, serial#' immediate;" almost always
> works. The immediate argument must be include don the first attempt. if
> you issue, "alter system kill session '<sid>, serial#';" and then issue,
> "alter system kill session '<sid>, serial#' immediate;", Oracle will
> respond with "session marked for kill".
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>
> -----Original Message-----
> Sent: Tuesday, July 03, 2001 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> The trick to succefully killing a session is to kill the OS process first,
> then kill the
> session if it is still lingering.
>
> This is the way it needs to be done on unix, haven't tried it on NT yet,
> but will soon. :)
>
> Jared
>
>
>
>
> "Jeffrey
> Beckstrom" To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]> <JBECKSTROM@g cc:
> crta.org> Subject: killed sessions
> staying around Sent by:
> root@fatcity.
> com
>
>
> 07/03/01
> 01:05 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
> Killed several sessions, but none will terminate. All were connected via
> ODBC. Users have rebooted, etc. These sessions are several days old and
> killed today. Was going to try ORAKILL, but there is no thread number.
> Apparently, entry is on v$session but no corresponding row in v$process.
> Oracle only suggestion is to exit application gracefully. Oh yeah, like I
> can enforce that - don't touch the power off switch.
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
> (216) 781-4204
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
