Re: limit idle_time [message #53630] |
Wed, 02 October 2002 08:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|