From: c_dopp@my-deja.com
Subject: Re: How to clean Killed Oracle sessions ???
Date: 2000/05/05
Message-ID: <8evblq$o7i$1@nnrp1.deja.com>#1/1
References: <8ev106$bke$1@nnrp1.deja.com>
X-Http-Proxy: 1.1 x38.deja.com:80 (Squid/1.1.22) for client 204.154.239.5
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri May 05 20:41:33 2000 GMT
X-MyDeja-Info: XMYDJUIDc_dopp
Newsgroups: comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)


You don't remove it. The session is truly inactive and you can drop the
schema owner or do anything else as though no one is connected.
The "KILLED" session disappears the next time the user tries to access
their killed session, after notifying the user the session is killed.

In article <8ev106$bke$1@nnrp1.deja.com>,
  venkata_jonnala@my-deja.com wrote:
> DBA GURU's
>
> Please suggest me how to clean the killed sessions
> in Oracle.
>
> When your client session got disconnected , then
> you killed the session in the database still the
> session exist with the status "KILLED". How to
> remove that ???.
>
> Thanks,
> Venkata
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>


Sent via Deja.com http://www.deja.com/
Before you buy.