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
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
by:Subject: Re: killing system user
[EMAIL PROTECTED
:
Sent by:Subject:
Re: killing system user
[EMAIL PROTECTED
:
Sent by:Subject: Re: killing system user
[EMAIL PROTECTED
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