Re: Killing Sessions
From: Tan La <TLa_at_mtl.marconi.ca>
Date: 1996/07/23
Message-ID: <4t2rvb$bll_at_gateway.marconi.ca>#1/1
Date: 1996/07/23
Message-ID: <4t2rvb$bll_at_gateway.marconi.ca>#1/1
In article <31F41190.6BDD_at_qld.mim.com.au>, sfd_at_qld.mim.com.au says...
>
>When I issue the "ALTER SESSION KILL SESSION" command I notice that
>the status of the session in v$session changes to KILLED, however, the
>record remains in the v$session table.
>
>Is there a way to completely remove a session so that no record of the
>session remains in the v$session table?
>
>Thanks in advance
>Steve
The only way to remove those killed sessions is when you shutdown and then
startup the Database.
Hope this helps
Tan.
Received on Tue Jul 23 1996 - 00:00:00 CEST