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

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

Threaded 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 02:36 PM.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

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