Re: dead(locked?) sessions

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 13 Oct 2002 16:04:38 +0200
Message-ID: <r6viqu48kutq4j5rk3kq4n8n5grs32mf36@4ax.com>

On Sun, 13 Oct 2002 12:14:52 +0000 (UTC), Damir Jurica <sircco_at_online.hr> wrote:

>So two questions,
>how to prevent accumulating dead(locked?) sessions again

By making sure clients send actually a disconnect/exit statement to Oracle, instead of shutting down themselves.
>how to clear those sesssions without shutting down database.

alter system kill session 'sid,serial#' -- can be looked up in v$session
or find out the process id for the server process (select spid from v$process p, v$session s where p.addr = s.paddr) and issue kill -9 (unix) or use the orakill utility (Winblows) to kill them off.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Oct 13 2002 - 09:04:38 CDT