Home » RDBMS Server » Server Administration » Re: limit idle_time
Re: limit idle_time [message #53630] Wed, 02 October 2002 08:06 Go to next message
Julie Lawson
Messages: 3
Registered: October 2002
Junior Member
Thanks for your reply. Oracle v9i. I checked to see everyone uses the default profile. I entered the command in SQL*Plus. It shows the profile is set to a 20 min timeout, which is what I want. Is there somewhere else this would work?
Re: limit idle_time [message #53682 is a reply to message #53630] Fri, 04 October 2002 20:07 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You have to setup resource_limit = true in init.ora file together with the idle_time in a profile and assign the profile to the users.

If that parameter is not setup the Resource Manager is not enabled, and the profile settings are not enforced.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Re: limit idle_time [message #53720 is a reply to message #53682] Mon, 07 October 2002 13:55 Go to previous message
Julie Lawson
Messages: 3
Registered: October 2002
Junior Member
Thank you very much, that worked.
Previous Topic: Manually starting Intelligent Agent Configuration Assistant
Next Topic: Database startup automatic
Goto Forum:
  


Current Time: Fri Dec 27 00:04:19 CST 2024