Printable View
I'm running 9i 9.2.0.1 64-bit on Solaris 9. My current parameter is db_block_size=4096.
My questions:
1. Can I change the parameter to 8192 in the spfile and restart the DB so that the new value is in effect?
2. Do my existing datafiles which are created using 4096 bytes block size able to extend to 8192 bytes?
3. For my environment what is the recommended block size for best performance?
Thanks.
Quote:
Originally posted by richyip
I'm running 9i 9.2.0.1 64-bit on Solaris 9. My current parameter is db_block_size=4096.
My questions:
1. Can I change the parameter to 8192 in the spfile and restart the DB so that the new value is in effect?
>>> No
2. Do my existing datafiles which are created using 4096 bytes block size able to extend to 8192 bytes?
>>> No
3. For my environment what is the recommended block size for best performance?
>>> what's your env???? Dataware house?? if not You are on the right track
Thanks.
Don't forget that Oracle supports multiple block sizes in the same database in 9i. You have init.ora parameters to specify the size of each buffer cache for blocks of x size e.g. db_2k_cache_size, db_4k_cache_size and so on. Therefore you can create tablespaces that have a different block size to db_block_size.
Oops.. Thanks, you are right:cool:Quote:
Originally posted by hacketta
Don't forget that Oracle supports multiple block sizes in the same database in 9i. You have init.ora parameters to specify the size of each buffer cache for blocks of x size e.g. db_2k_cache_size, db_4k_cache_size and so on. Therefore you can create tablespaces that have a different block size to db_block_size.
We are still fighting for 9i
Cheers
We are just about to upgrade to 9i and I'm planning to reconfigure the architecture.
With variable block sizes I'm right in assumming that tables where many,many rows are required for certain transactions (say a mass update of a certain column) would benefit from having larger Block Sizes? So I'd put these tables in a TBS with a larger block size than the other smaller transaction tables?
Is there a tried and trusted simple query on the V$views I can run to see if transactions on an object would benefit from a larger block size?