Henry,
I have found that on certain versions of Oracle on NT (specifically 8.1.6)
that expiry time does not work. So if you set this parameter in SQLNET.ORA
and you do not see dead connections being removed then you're probably
experiencing the same bug (acknowledge by Oracle support but they seem
reluctant to fix it).
As an alternative you could use the ORAKILL utility and some intelligent
scripting to kill off the underlying process threads
-----Original Message-----
Sent: 06 March 2001 02:05
To: Multiple recipients of list ORACLE-L
Henry,
set the following parameter in the sqlnet.ora on the server and not on the
client.
the unit is minutes. 10 mins shld be enuf. test with ur environment. if set
less then maybe it may hv an impact on SQL*Net performance.
SQLNET.EXPIRE_TIME= 10
-Mandar
> -----Original Message-----
> From: "HENRY, Beno�t" [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 12:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Ghosalkar
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Onions
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
