var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Login Time out
Is there any option to kick out users after a certain time of idle.
Say, a user login my database and don't logout from database and he don't do anything in oracle. I want automatically logout from oracle after a certain time he is idle.
For your information i'm using oracle 8.0.5 and developer 2000.
Thanks in advance.
create a profile with idle_time = <your timeframe to kick out in minutes>
alter user <your user> profile <your profile>;
additionally set resource_limit = true in your initORA
please provie me the code for create a user profile with idle_time.
create profile idle_profile limit idle_time=15;
and it is a good idea to start RTM
Thanks again osy45 for your prompt response.
What is RTM and how it start ?
pardone me if i bother you .
Read the manual tahiti.oracle.com sql reference
Many many thanks for your help
I implement a profile maned comm_user with idle_time=15.
Bus after 15 min the STATUS shows SNIPED not killed.
I aslo add set resource_limit = true with alter system command.
Please explain.....Is there any problem.
Last edited by Momin; 10-14-04 at
as you are on 8.0.5 : I can remember that in some versions pre 8i had a bug where the background process was unable to remove the sniped sessions. Therefore, I had written a generic script and then croned the job which retrieved all the sniped sessions and killed them explicitly.
select 'alter system kill session(' ||sid ||','|| serial# ||');' from v$session where status = 'SNIPED';
Last edited by osy45; 10-14-04 at
Thanks for your prompt help osy45
I'm in terible condition. After implement idle_time the users status shows SNIPED and after kill his session status shows KILLED, but after killed the user session user still unable to LOGON again. also in the v$session the user status shows KILLED.
Please help me, How i survibe from this. After Kill user session why user cannot able to logon ?
do you have set any other profile properties, i.e. max sessions per user or the like ?
post your profile and the properties
and the properties of your user
I don't remember of any initORA parameters that allow users only to connect once which sounds to be your problem
My profile is
create profile comm_user limit
User property :..
CREATE USER momin
IDENTIFIED BY momin
DEFAULT TABLESPACE user_data
TEMPORARY TABLESPACE user_data
you are allowing only 2 sessions per user ...
if there is one killed in v$session and not removed by the oracle Server then only one other session is allowed with momin
increase the value for sessions_per_user
how i removed the killed session from oracle server at a time when i kill users sessions ?
Originally Posted by