Printable View
Hello everybody!!
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!!
create profile and grant profile to users.
RTFM
My sincere thanks, adewri!
Peace to you!!
One more question:
Can I send to user a message advising him that is going to be disconnected, and the reason why?
on sqlplus no...
You said the infamous 4 letter word!!Quote:
Originally posted by Adilsom Musskop
One more question:
Can I send to user a message advising him that is going to be disconnected, and the reason why?
I will have mercy on you if you were absent and missed yesterdays lesson regarding the dreaded 4 letter word people.
http://www.dbasupport.com/forums/sho...threadid=33619
THEY ARE NOT WORTHY, KILL THEM!!
With Love, Peace, and general appreciation of mankind.
MH
Hello,
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 ;
spool off
@killsess.sql
*********************************************
If you are using UNIX ,You can send mails to the users for
intimating them before killing it.
Shell scripts would make it possible.
Regards
Chithra
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.