idle_time

hi everybody
i want one of my user to get disconnected automatically if he is idle for some time say 10 min.what i have done is created a user with profile.the syntax is

CREATE PROFILE IDE_PRAS LIMIT
IDLE_TIME 10;


ALTER USER XYZ
PROFILE IDE_PRAS 10;

but my prob is the user is not getting disconnecting automatically.what steps should i take other than this.
any help is really appriciated.
thanks
pras

Hi,

Here is a Procedure
Create Profile prf_name
Limit Idle_Time 10;

Alter system set Resource_Limit = True;

Alter user User_name
Profile Prf_Name;

This should be fine.

You need to have the Resource_Limit to True... to work it in the Parameter File. Either through the above statement or Change this in the File.
To see Issue in Server manager

Show parameter Resource

you can also check whether the resource limit had been turned on, through,

sqlplus sys@sid


select * from v$parameter where name = 'resource_limit';

This would tell whether this parameter had been set to true or false.

Sam

hi oracledba8/sambhavan

thanks for ur help.you are right the RESOURCE_LIMIT is FALSE.i made it true through the svrmgr30 and after running the query
select * from v$parameter where name = 'resource_limit';
it is showing me TRUE.
but still the user is not getting disconnected.if i type at sql prompt SHOW USER it is still showing me the user.pls tell me how do i know the user is disconnected.will it show me something??pls help me if iam doing something wrong.
the help is really appreciated.
thanks in advance
pras

Hi,

You may be misunderstood of the Term, Disconected. The user will be disconceted after that specified time but the session will still be active there for that user, even user is Disconnected.

Suppose you have assigned Idel_time 5, and assign this to a user and set the resource_limit to True, the user will be disconneted after five minutes if he is does not do any thing and any transactions will be rollbacked and Keep in Mind that Long queries running on Database from that user will not be counted as Idle Time.

Try to assign that Profile to a user, set Resource Limit to Tru, Connect that user and Just run a simple Update Statement and leave that session open for specified time, then issue any statement, You will get You are Connected.

Hopefully this will help you.

Thanks

Sorry, After specified that if you in that sesion and issue any statement, You will get, You are not Connected, Connect again and you will see that your Transaction was rolled back.

You can see That in
Select * from v$session;

Thanks..