Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SID & SERIAL#

Re: SID & SERIAL#

From: Arghadeep Chatterjee <dba_at_magma.co.in>
Date: Sat, 14 Feb 2004 12:38:30 +0530
Message-ID: <004101c3f2c9$5b680d80$e50610ac@lan.magma.co.in>


But I have till date never seen two SID 's having the same no. Deep

>
> Think about what happens if the
> session you are about to kill decides
> to end itself, and a new session starts
> with the same sid (which means the
> next value for serial#).
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
> Next public appearances:
> March 2004 Hotsos Symposium - The Burden of Proof
> March 2004 Charlotte NC OUG - CBO Tutorial
> April 2004 Iceland
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK___February
> ____UK___June
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> From: "Jack van Zanen" <JACK_at_QUANTSYSTEMS.NL>
> To: "'Oracle-L Freelists'" <oracle-l_at_freelists.org>
> Sent: Friday, February 13, 2004 12:33 PM
> Subject: SID & SERIAL#
>
>
> Hi All,
>
> I have a question about killing a session.
>
> You'll always have to give sid & serial# but I have never seen two session
> having the same SID so why the serial#
>
> TIA
>
> Jack
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sat Feb 14 2004 - 01:08:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US