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