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 underconfigure the LM_ parameters then you can expect OPS/RAC to take what it needs for DLM resources from the Shared Pool, resulting in terrible performance and lots of messages to the "alert.log".

The instances also may not start if you had requested too many resources using the parameters that start with the prefix "GC_*" (specifically GC_FILES_TO_LOCKS), but I'm not certain of that. I've always used a liberal hand in initially allocating DLM parameters and then monitoring the V$RESOURCE_LIMIT view to consider chopping back (or adding more) as usage patterns become apparent. Clustered systems should not be memory-constrained -- this would be a fine example of "penny-wise, pound-foolish", as the cost of RAM is small compared to the overall (direct and indirect) costs of a clustered configuration.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 16, 2002 8:38 AM

> 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: BRodrigues_at_elcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).