Re: killing system user

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Mon, 03 Dec 2001 10:11:34 -0800
Message-ID: <F001.003D3770.20011203095525@fatcity.com>

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

Received on Mon Dec 03 2001 - 12:11:34 CST