Re: Need help understanding a performance problem

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 22 Jul 2003 13:06:53 GMT
Message-ID: <3F1D36ED.A3B651B2@remove_spam.peasland.com>

> Sybrand, set your db_cache_size down to 100k and watch the fun,
> foollish man.

Your default buffer cache cannot be as low as 100KB. The smallest size allowed is one granule. Depending on your total SGA size, that granule is either 4MB ro 16MB.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Tue Jul 22 2003 - 08:06:53 CDT