yeah Jared, i will look at it. C i am wondering that if the SID is sufficient to gaurentee uniqueness .. why does oracle need the serial# as well??
or maybe there is a scheduled maintainance window at this time inside of my head ;) Thx anyhu ;) Deepak --- [EMAIL PROTECTED] wrote: > > Deepak, > > To be quite honest, I can't remember. I'm like that > with details > sometimes. > I tend to forget them, though I remember the reason > I learned them in > the first place. :) > > This is on MetaLink somewhere if you care to look > for it. I really > can't do that now. It's back to the grindstone for > me. > > The grindstone in this case being iFS 1.1.9. Ah the > joy of > troubleshooting. :) > > Jared > > > > > > > > Deepak Thapliyal > > > <deepakthapliyal@ To: > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > YAHOO.COM> cc: > > > Sent by: Subject: > Re: killing system user > > [EMAIL PROTECTED] > > > > > > > > > 12/03/01 09:55 AM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > Hi Jared > > why does the serial# have to change due to rollback? > lots of us would be curious for a brief expln ... > > Thx > Deepak > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > > The session is rolling back, you can't kill it. > > > > This is why the serial# is changing. > > > > The following query can be used to track its > > progress. > > > > select s.osuser > > ,s.username > > ,s.sid > > ,r.segment_name > > ,t.space > > ,t.recursive > > ,t.noundo > > ,t.used_ublk > > ,t.used_urec > > ,t.log_io > > ,t.phy_io > > ,substr(sa.sql_text,1,200) txt > > from v$session s, > > v$transaction t, > > dba_rollback_segs r, > > v$sqlarea sa > > where s.taddr=t.addr > > and t.xidusn=r.segment_id(+) > > and s.sql_address=sa.address(+); > > > > Jared > > > > > > On Sunday 02 December 2001 22:55, Tatireddy, > > Shrinivas (MED, Keane) wrote: > > > Hi lists, > > > > > > Solaris 2.7 > > > oracle 8i > > > > > > I have a session "SYSTEM" doing import into a > > table. (logged into server > > > thru telnet from win 98 PC) > > > > > > Suddenly the power outage occurred to my PC. > > > > > > When I logged into the server thru telnet, I > found > > that the session is > > > active. > > > By mistake, I killed the process at o/s level. > > > > > > For somereasons,I tried to drop the table. But I > > failed to do it, as it > > > is locked by import process. > > > > > > I tried to kill the user "SYSTEM". But the > oracle > > is giving error that > > > there is not user with such sid and serial > number. > > > > > > The serial# number is often getting changed when > I > > query from v$session. > > > > > > Is there a way to kill this user, without > shutting > > down the database. > > > > > > And why different serial# number each time, I > > query v$SESSION.? > > > > > > Any clues? > > > > > > Thnx and Regards, > > > > > > Srinivas > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
