Re: Performance issue after creating higher block size tablespace
From: Harel Safra <harel.safra_at_gmail.com>
Date: Thu, 25 Feb 2010 19:15:43 +0200
Message-ID: <218c004a1002250915r12dc8ef3oab27c2bab40f8ea0_at_mail.gmail.com>
The db_cache_size is set to 8192 and db_8k_cache_size is also set to 8192.
Date: Thu, 25 Feb 2010 19:15:43 +0200
Message-ID: <218c004a1002250915r12dc8ef3oab27c2bab40f8ea0_at_mail.gmail.com>
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 (
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams043.htm
):
"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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 25 2010 - 11:15:43 CST