Re: limit idle_time [message #53630] |
Wed, 02 October 2002 08:06 |
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 |
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
|
|
|
|