Re: Urg: v$session.serial# description

Terminology first :-  	SID = Session ID
   			Serial#  = Serial number

There is no term 'Session#'.

Simply, the combination of SID and Serial# will uniquely identify sessions, throughout the life of the instance.

(so logged on generally as SYSTEM or SYS) :-  

SQL>Select  sid, serial#, status, username, terminal
  2>FROM    v$session
  3>ORDER BY logon_time ASC;

will give you your active sessions and

ALTER SYSTEM KILL SESSION 'x, y';

Will kill the session with Session ID x and Serial# y.

David P. OCP (DBA) MCP (TCP/IP)

Glasgow, Scotland.

lndlnd_at_my-deja.com wrote:
>
> Is it right that pair (session#, sid)
> identifies oracle session between all oracle
> sessions from Oracle instance start to shutdown?
> I mean, Can I expect that the same values for
> (session#, sid) can be reused for another
> sessions when current session is cleaned from
> v$sessions?
>
> Thanx,
> Laimis
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Thu Jun 01 2000 - 00:00:00 CDT