Old INACTIVE and KILLED sessions

Hi there,

I'm new to Oracle, coming from (gulp!) Informix. I hope to find on this newsgroup a great help from you.
(it was the case in the Informix newsgroup ;-)))

We are in the developing phase, and during tests, our front-end application crashes often and our server application who access the database still alive.

They are remaining INACTIVE and KILLED processes in Oracle. These eat a lot of memory (Oracle 8.0.5 on Windows NT4).

I would like to find a init parameter (like transaction time-out=24*60), or a system procedure to disconnect automaticaly the user sessions older than 24 hours, and free all the ressources.

Can someone help me, or give some ideas or tips to manage this ?

Thanks in advance

Ben.

select substr(sid,1,5) sid,status,process,type,

       substr(logon_time,1,12) logon_time from dba_v$session
order by status,logon_time;

SID STATUS PROCESS TYPE LOGON_TIM ===== ======== ========= ========== =========

1     ACTIVE   00123     BACKGROUND 02-MAR-01
2     ACTIVE   00124     BACKGROUND 02-MAR-01
3     ACTIVE   00125     BACKGROUND 02-MAR-01
4     ACTIVE   00126     BACKGROUND 02-MAR-01
5     ACTIVE   00127     BACKGROUND 02-MAR-01
6     ACTIVE   00128     BACKGROUND 02-MAR-01
37    ACTIVE   358:396   USER       05-MAR-01
10    INACTIVE 160:250   USER       02-MAR-01
22    INACTIVE 132:361   USER       02-MAR-01
24    INACTIVE 353:352   USER       02-MAR-01
23    INACTIVE 351:349   USER       02-MAR-01
34    INACTIVE 409:402   USER       02-MAR-01
33    INACTIVE 409:402   USER       02-MAR-01
32    INACTIVE 386:385   USER       02-MAR-01
31    INACTIVE 305:309   USER       02-MAR-01
30    INACTIVE 386:385   USER       02-MAR-01
29    INACTIVE 372:344   USER       02-MAR-01
27    INACTIVE 369:368   USER       02-MAR-01
26    INACTIVE 353:352   USER       02-MAR-01
25    INACTIVE 369:368   USER       02-MAR-01
21    INACTIVE 364:348   USER       02-MAR-01
17    INACTIVE 337:336   USER       02-MAR-01
18    INACTIVE 372:344   USER       02-MAR-01
20    INACTIVE 132:361   USER       02-MAR-01
19    INACTIVE 305:309   USER       02-MAR-01
16    INACTIVE 322:329   USER       02-MAR-01
35    INACTIVE 358:396   USER       05-MAR-01
7     KILLED   351:349   USER       02-MAR-01
15    KILLED   303:319   USER       02-MAR-01
8     KILLED   321:318   USER       02-MAR-01
12    KILLED   322:329   USER       02-MAR-01
13    KILLED   337:336   USER       02-MAR-01
14    KILLED   321:318   USER       02-MAR-01
11    KILLED   303:319   USER       02-MAR-01
9     KILLED   364:348   USER       02-MAR-01

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?=22HENRY=2C_Beno=EEt=22?=
  INET: HenryB_at_arjowiggins.be

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).