Re: Performance issue after creating higher block size tablespace

From: Harel Safra <>
Date: Thu, 25 Feb 2010 19:15:43 +0200
Message-ID: <>

The db_cache_size is set to 8192 and db_8k_cache_size is also set to 8192.

If that's really the case (and you didn't forget M of then your buffer cache is tiny, even after the rounding up described in the docs ( ):
"The value must be at least 4M * number of cpus * granule size (smaller values are automatically rounded up to this value)"

I'd seriously think of setting a bigger size.

Harel Safra

Received on Thu Feb 25 2010 - 11:15:43 CST

Original text of this message