Why IDLE_TIME profile option does not have any effect???
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Why IDLE_TIME profile option does not have any effect???

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Why IDLE_TIME profile option does not have any effect???

    Hi all,

    To reduce peoblems of having too many INACTIVE sessions, I have set IDLE_TIME profile option in the DEFAULT profile with the value of 720 minutes i.e 12 hours. RESOURCE_LIMIT is also set to TRUE in the init.ora file and database has been bounced since then.

    Still, I do not see if this really is working because I can still see old inactive sessions still sitting there. Some of them are even 4-5 days old.

    Could anyone help me please?

    Thanks in Adv..
    Last edited by samdba; 04-10-2003 at 01:36 PM.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    tahiti.oracle.com

    Read about sniped sessions and how IDLE_TIME really works.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Jeff,

    Thanks for the link. They are not even converted to SNIPED sessions.

    select * from dba_profiles where profile = 'DEFAULT' and resource_name = 'IDLE_TIME'
    = DEFAULT IDLE_TIME KERNEL 720

    select name,value from v$parameter where name = 'resource_limit'
    = resource_limit TRUE

    select profile from dba_users where username='APPS'
    = DEFAULT

    What's wrong?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    Help please...

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  5. #5
    Join Date
    Aug 2001
    Posts
    267
    I am sure you might have already checked . Does the users that are talking are created in Default profile or you may have more than one profile?? Just check in case . It should work.
    Raghu

  6. #6
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Ragu,

    Yes, all are assigned DEFAULT profile. Still, does not seem to be working.

    Thanks though.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  7. #7
    Join Date
    Aug 2001
    Posts
    267
    I got a note in oracle tech net

    A session will continue to show as idle even after the idle_time for that user, as specified in that user's profile, has expired. When the user attempts to run a transaction against the database after the idle_time has expired, the database will disconnect the user by terminating the session. After this, the session will no longer show in the output of the above query.
    Raghu

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by raghud
    A session will continue to show as idle even after the idle_time for that user, as specified in that user's profile, has expired. When the user attempts to run a transaction against the database after the idle_time has expired, the database will disconnect the user by terminating the session. After this, the session will no longer show in the output of the above query.
    Bravo! raghud is a true believer in the quest for knowlege. Now that samdba has his answer, we can all rest.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Aug 2001
    Posts
    267
    I got that note from Oracle online help guy. Some body asked a question that they replied. I just trying to learn more from this site www.dbasupport.com.

    Super-Genius and www.dbasupport.com 5714 replies is nothing. Knowledge is like a ocean. If you think you are genius ______ fill in the blanks.

    Yaa: Here we got a 21st century Jesus Christ, just like he answered lot of questions on god(Bible) , this guy can answer all the oracle database questions. I know you got good knowledge, since I am watching this site but If you think you are _______
    Raghu

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Geesh, try to pay a guy a compliment and you end up takin one for the team... :(
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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