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).