Re: Performance issue after creating higher block size tablespace
Date: Thu, 25 Feb 2010 09:31:18 -0800
On Thu, Feb 25, 2010 at 8:23 AM, Saad Khan <saad4u_at_gmail.com> wrote:
> The db_cache_size is set to 8192 and db_8k_cache_size is also set to 8192.
I don't know if you already considered this, but those cache sizes provide differing number of blocks.
Assuming that 8192 refers to 8192M:
(8192 x 2^20) / (4 x 2^10) = 2097152 blocks
(8192 x 2^20) / (8 x 2^10) = 1048576 blocks
The cache for your new tablespace is providing half as many blocks as the default cache.
And as others have already stated, blocks sizes are not a tuning device.Received on Thu Feb 25 2010 - 11:31:18 CST