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 > 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).
