Re: sid/serial# vs. audsid: why both?

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Mon, 06 Oct 2003 23:54:24 -0800
Message-ID: <F001.005D2325.20031006235424@fatcity.com>

• Paul Drake <discgolfdba_at_yahoo.com> wrote:
  > --- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
  > wrote:
  > >
  > > In what cases does the SERIAL# need to be used?
  >
  > orakill.
  >
  > sqlnet.expire_timeout did not work on NT for 8.1.7.
  > garbage middle-tier apps that don't close
  > connections
  > require the use of orakill.
  >
  > Pd
  

oops.

orakill takes the ORACLE_SID and v$session.sid as arguments.

alter system kill session takes the sid and serial number as arguments.

I'd only use alter system to kill a session if I could not access the server console.

Pd

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Tue Oct 07 2003 - 02:54:24 CDT