RE: Tuning Question

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Thu, 20 Jul 2000 17:12:33 -0700
Message-Id: <10564.112600@fatcity.com>

Use the formulae: ((SESSIONS - 10)*2)+55 (Refer Oracle reference Manual for this formulae)
If the value comes more than DML_LOCKS value, the new value is used for enqueue_resources.
You may prefer to use more than DML_LOCKS value if the value comes less. Add the param to initsid.ora and restart the DB.

Janardhana Babu

-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com] Sent: Thursday, July 20, 2000 4:30 PM
To: Multiple recipients of list ORACLE-L Subject: Tuning Question

I ran some tuning scripts on an 8.0.5 database and one of the results was that enqueue_resources needed to be increased. It is currently set at 155, but there isn't an enqueue_resources parameter in the init or a Sessions parameter in the init (although I know sessions is set to 60). Is enqueue_resources set based on something else or should it simply be an entry in the init? How can you know what the best number is to set it at?

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--

Author:
INET: cemail_at_sprintmail.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). Received on Thu Jul 20 2000 - 19:12:33 CDT