Re: 2k and 8k block size

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:chao_ping_at_163.com
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: 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: chao_ping
  INET: chao_ping_at_vip.163.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).