Reading my oracle 9i new features , there is now something called:
Multiple Database Block Size Support. In other words, it is no longer
necessary
to commit to a single block size for your database. I'd suggest looking
into this, as
it may now be possible to test using different blocksizes for different
tablespaces.
At 01:04 PM 2/10/2003 -0800, Rajesh.Rao_at_jpmchase.com wrote:
>An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The
>8.0 database had an block size of 2k. Multiblock read count is 8. This is
>an OLTP database, all transactions almost always work on a single row. None
>of the row sizes exceed the block size. Hardly any chained or migrated
>rows. Now, during this migration, it was recommended to change the block
>size to 8k. And my concerns are:
>
>1. Would this not increase pinging across the instances? With 9i and
>interconnect and cache fusion, this should be reduced considerably, so, is
>it a mute point?
>2. This could alter the execution plans of some statements. Would some,
>maybe a very few of the statements not prefer a full table scan?
>
>Any other positive or negative effects of this increase in block size?
>
>Thanks
>One Paranoid DBA
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author:
> INET: Rajesh.Rao_at_jpmchase.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Fontana
INET: mfontana_at_verio.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Feb 10 2003 - 15:59:05 CST
