Re: Tuning Question

From: <Deepender_Gupta_at_escorts.co.in>
Date: Fri, 21 Jul 2000 10:48:09 +0530
Message-Id: <10564.112611@fatcity.com>

set this parameter ( enqueue_resources=xxxxxx) in your init parameter file and restart your database.

From: cemail_at_sprintmail.com on 07/21/2000 05:00 AM

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>@SMTP_at_AMG1 cc:
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 Fri Jul 21 2000 - 00:18:09 CDT