Re: V$SESSION, do sessions killed ever get deleted from it?

Q. Do killed sessions ever get deleted from v$session?

1. Normally. Status may change to KILLED if the session cannot be interrupted.

May not disappear if the comms link (network) broke between the client and server (e.g. cable cut). In this case the process still exists but Oracle can't or won't kill it using IPC. In these cases you need to bounce the instance to clear the processes. Alternatively, you could kill the processes at the OS level if you want to be more daring.

David P.

NetComrade wrote:
>
> Do they impact the performance anyhow?
>
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Sun Mar 12 2000 - 00:00:00 CST