Rajesh.Rao,
If you exp/imp, your can change your db_block_size, else, you have to
move all the tables to the new tablespaces with 8K db_block_size.
And if you are using 9.2, I suggest you use segment management auto
option of the tablespaces new created.If database is not that big, exp/imp maybe is
the best way.
THere are many doc talking about Larger block size vs smaller ones ,
but most prod system runs 8k db_block_size as far as i see, and for OLTP, it seems
pretty good .
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-02-10 13:04:00 ,you 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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: chao_ping
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
