Re: Serial# changing

From: <markp7832_at_my-deja.com>
Date: Sat, 22 Jan 2000 22:11:13 GMT
Message-ID: <86d9tq$fb4$1@nnrp1.deja.com>

In article <s8i6ekeeh6140_at_corp.supernews.com>, <terrysutton_at_usa.net> wrote:
> On O 8.0.5, I'm looking at v$session to track a session (actually we
want to
> kill the session). The connection logon_time is 4 days ago, and the
SID
> stays the same, but the serial# keeps increasing (so we can't kill it,
> because it changes). I've never seen this before; I thought a
connection
> retains its SID & serial# for the life of the connection. Can anyone
help
> me? TIA
>
> --Terry
>

I have have seen the serial number change before. It has always be on a session that took an error or was killed. It has always ment it was being rolled back. If the process is not gone in a reasonable amount of time kill it at the OS level.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jan 22 2000 - 16:11:13 CST