Serial# changes when rolling back

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Tue, 11 Dec 2001 01:23:53 -0800
Message-ID: <F001.003D9900.20011211005519@fatcity.com>

Jared,Deepak
I did not see a reply on this. From a brief experiment I don't see the serial# changing when rolling back a transaction.

The code posted by Jared certainly works as the number of blocks to rollback reduces as the job nears completion. If the serial# changes I would be interetsed to understand why and to what purpose

John
-----Original Message-----
From: Deepak Thapliyal [mailto:deepakthapliyal_at_YAHOO.COM] Sent: 03 December 2001 17:55
To: Multiple recipients of list ORACLE-L Subject: Re: killing system user

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 <jkstill_at_cybcon.com> 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: jkstill_at_cybcon.com

>
> 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: ListGuru_at_fatcity.com (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: deepakthapliyal_at_yahoo.com


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: ListGuru_at_fatcity.com (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).




=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================

Received on Tue Dec 11 2001 - 03:23:53 CST