| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SID & SERIAL#
Jared, I have also encountered this situation; however, I believe that pmon
is performing the blackout and while the serial# keeps changing while the
sid remains constant and I believe the Oracle background process that is
doing the work remains the same so you can kill it at the OS level and then
Smon will take over the rollback operation and release the locks so you do
not have to bounce the db. At least this is how we managed a couple of
conditions where rollbacks never seemed to end.
Part of the problem in the rollback completing may be that the user has re-established a connection and has launched their update process once again. The call usually comes when the update is taking too long and it is not unusual in my experience to find the user has tried to perform the task several times.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still
Sent: Sunday, February 15, 2004 5:24 PM
To: Oracle-L Freelists
Subject: Re: SID & SERIAL#
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
> -----------------------------------------------------------------
-- 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 Mon Feb 16 2004 - 08:26:16 CST
 |
 |