| 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#
Mark,
When I have encountered this, it could not be killed.
Attempts to kill the OS process may or may not have worked, but a new process and connection was spawned regardless.
Jared
On Mon, 2004-02-16 at 06:26, Powell, Mark D wrote:
> 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
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 - 16:54:17 CST
 |
 |