Re: dead(locked?) sessions

From: M Hashim <m.a.n.hashim_at_sympatico.ca>
Date: Sun, 13 Oct 2002 16:35:36 -0700
Message-ID: <KLkq9.836$Lb1.98811@news20.bellglobal.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:r6viqu48kutq4j5rk3kq4n8n5grs32mf36_at_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.
Excatly...seen it so many times. Also, make sure that cursors are closed gracefully, even if the session is still in use and the transaction is logically completed.

> >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 - 18:35:36 CDT