Re: How is enqueue_resources influencing memory usage / server performance?

Hi!

One enqueue resource slot takes less than 100 bytes, you can easily measure this by comparing v$sgastat's output in "shared pool enqueue resources" row.

Btw, why did you increse the enqueue resources, did you start getting errors or see a need for it from v$resource_limit?

Tanel.

"Patrick" <newsspam_at_vanzweden.nl.eu.org> wrote in message news:5f5eddec.0401282302.1e93efdc_at_posting.google.com...
> Hi all,
>
> Probably as simple question for most of you.
> I'm using a oracle db server and had the problem of not having enough
> enqueue resources avavailable. The proces i'm starting is running a
> lot of concurrent queries so that's probably the cause of it.
>
> Systems administration increased the value but they want to know how
> this influences the performance and memory usage of the server. Does
> it increase memory usage a lot or doesn't it affect it at all ?
> Also do you get degraded server performance due to this modification
> (increasing the enqueue_resources value in ora.init)?
>
> Greetings,
>
> Patrick
Received on Fri Jan 30 2004 - 05:54:32 CST