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

From: <sybrandb_at_yahoo.com>
Date: 29 Jan 2004 02:17:28 -0800
Message-ID: <a1d154f4.0401290217.20dd427e@posting.google.com>

newsspam_at_vanzweden.nl.eu.org (Patrick) 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

On HP-UX an enqueue takes about 100 bytes. If you think you perceive performance degradation by increasing the enqueue_resources parameter, you are in serious trouble.

Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 29 2004 - 04:17:28 CST