How is enqueue_resources influencing memory usage / server performance?

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 Thu Jan 29 2004 - 01:02:55 CST