Re: SID & SERIAL#

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 15 Feb 2004 14:23:53 -0800
Message-Id: <1076883833.2838.7297.camel@poirot>

Yeah, I've seen this a number of times.

At times when table is locked, and the session is disconnected ( PC crashes ), SMON goes about its cleanup duties, but something isn't quite right.

The session will die and come right back with a new serial#.

You can't kill it, no matter what you do.

You can't get rid of the lock either.

There is only one recourse: bounce the database.

I have seen this happen on Solaris, DG/UX and Windows, versions 7.3, 8.0 and 8.1. Not yet on 9i, maybe it's been fixed.

It hasn't happened to me in about 2 years. It would be interesting to see it again and try to capture a trace of what is going on.

Jared

On Sun, 2004-02-15 at 06:32, Hemant K Chitale wrote:
> Huh ? You've never seen an SID re-used so quickly that by the time
> you decide to issue an ALTER SYSTEM KILL SESSION or a Unix kill -9,
> the same SID has been used by another user ?
> Well, then you haven't worked on a busy system.
>
>
> Hemant
> At 12:38 PM 14-02-04 +0530, you wrote:
> >But I have till date never seen two SID 's having the same no.
> >Deep
> >
> >----- Original Message -----
> >From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
> >To: <oracle-l_at_freelists.org>
> >Sent: Friday, February 13, 2004 6:50 PM
> >Subject: Re: SID & SERIAL#
> >
> >
> > >
> > > 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
> >-----------------------------------------------------------------
>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> http://hkchital.tripod.com {last updated 24-Jan-04}
>
>
> ----------------------------------------------------------------
> 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 Sun Feb 15 2004 - 16:23:53 CST