How can I kill a session if it is inactive for more than one our, for instance??
My server needs more memory (Is there one that didn't??) and I have some users that turn on their machines at 8:00 a.m., access our DB, leave it and goes to another location, turn back at 5 p.m. and then, uses our corporative system for a few minutes, then go home!!!
Can yu help me??
Really thanks!!
Adilsom José Musskopf
Live like each of your days was the last.
If you are using UNIX,you can set a cron job to run at every one hour
to check which are the user sessions that are
inactive for more than 1 hour and kill those sessions.
The sql to be executed is given below
*********************************************
spool killsess.sql
select 'alter system kill session '||''''||sid||','||serial#||''''||';' from v$session where username is not null and status='INACTIVE'
and sysdate-logon_time
> .041666667 ;
Hello,
In my previous reply,I have given the sql .
That would help to identify the users who are connected to
database before an hr and at present they are inactive.
It will not assure if the session were inactive(idle) through out
for more than an hour.
Reply With Quote
Bookmarks