Re: Serial# changing

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 23 Jan 2000 14:20:17 GMT
Message-ID: <86f2n1$51j$2@news.seed.net.tw>

<terrysutton_at_usa.net> wrote in message news:s8i6ekeeh6140_at_corp.supernews.com...
> 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

Try to identify whether the session is issued by a job. (query DBA_JOBS) If yes, kill the job, or correct the problem of the job. Received on Sun Jan 23 2000 - 08:20:17 CST