RE: enqueue_resources

Hi Lisa,

About 72 bytes per slot of memory to waste, that's all. Look at V$RESOURCE_LIMIT to see your peak utilization, and to maintain appropriate room for growth.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
Sent:	Friday, May 12, 2000 7:36 AM
To:	Multiple recipients of list ORACLE-L
Subject:	enqueue_resources

Hello all,

I have to bump enqueue_resources above the default for one of our databases. I'm SWAGging it and changing it from 397 (default) to 450 to allow parallel index creation. Is there anything detrimental to doing something like setting this to 1000? Any gotchas?

Thanks
Lisa

-- 
Author: 
  INET: Lisa_Koivu_at_gelco.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).