Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to clean Killed Oracle sessions ???
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_at_nnrp1.deja.com>,
venkata_jonnala_at_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.
Received on Fri May 05 2000 - 00:00:00 CDT