Re: Researching the use of resource limits within profiles

We use "limit idle_time 1440" to kill runaway sessions instead of the unreliable sqlnet.expire_time. You have to set "resource_limit = true" which you can do in init.ora or at runtime (alter system).

However, if you have lots of space requests keep in mind that each allocation is checked against the quota system. So this slows down your allocation a bit.

Martin

Peter Bridgland wrote:
>
> Has anyone any experience of implementing resource limits via profiles
> ?...specifically any conclusions, any considerations and how u went about
> determining values for such things as cpu_per_session/call, connect_time etc
>
> Currently we are considering utilising this type of restriction in response
> to issues raised by auditors. I'm personally somewhat of a newbie and so any
> info would be appreciated.
>
> TIA
Received on Fri May 11 2001 - 01:44:21 CDT