Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SID & SERIAL#
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
> -----------------------------------------------------------------
-- 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
![]() |
![]() |