dead(locked?) sessions

From: Damir Jurica <sircco_at_online.hr>
Date: Sun, 13 Oct 2002 12:14:52 +0000 (UTC)
Message-ID: <slrnaqiouk.1uk.djurica@damir.globalnet.hr>

my oracle 8.1.7 server recently started to have some problems with speed of queries. After some time i found out that there are 150 inactive sessions, some even two months old. Just one user is supposed to write to oracle, and its accounting that comes from radius server. Sometimes reports from table are made from php sessions, and ocassional access with dbastudio and sqlplus.

I didnt know how to clear all those inactive sessions and I decided to just shutdown and startup instance again, problem dissapeared and my database is working much faster again.

So two questions,
how to prevent accumulating dead(locked?) sessions again how to clear those sesssions without shutting down database.

Thanks for possible answers,

Damir Jurica Received on Sun Oct 13 2002 - 07:14:52 CDT