DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: idle_time

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    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

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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


  5. #5
    Join Date
    Feb 2001
    Posts
    184
    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

  6. #6
    Join Date
    Feb 2001
    Posts
    184

    Angry

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width