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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxxxxxxx> > > >To: <oracle-l@xxxxxxxxxxxxx> > > >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@xxxxxxxxxxxxxxx> > > > > To: "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx> > > > > 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@xxxxxxxxxxxxx > > > > put 'unsubscribe' in the subject line. > > > > -- > > > > Archives are at //www.freelists.org/archives/oracle-l/ > > > > FAQ is at //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@xxxxxxxxxxxxx > > >put 'unsubscribe' in the subject line. > > >-- > > >Archives are at //www.freelists.org/archives/oracle-l/ > > >FAQ is at //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@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------