Can a database go down because of too few locks?

Can anyone tell me if an ops database can be brought down because of too few locks being allocated for the database? Thanks, Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: Can a database go down because of too few locks?

Not that I'm aware of are you thinking about the enqueue_resources parameter? It is dynamically adjusted by Oracle as needed. RF -Original Message- Sent: Thursday, May 16, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Can anyone tell me if an ops database can be brought

Re: Can a database go down because of too few locks?

Depends on what you mean by down, doesn't it? Many define down as unusable, despite the fact that connections can be made and SQL statements can be processed. If you're referring to the parameters that start with the prefix LM_*, then no, the database instance won't crash/halt/abend. If you

RE: Can a database go down because of too few locks?

Tim, You hit the nail right on the head. Thanks for your answer, Bryan -Original Message- Sent: Thursday, May 16, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Depends on what you mean by down, doesn't it? Many define down as unusable, despite the fact that connections