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
row
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
row
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 d
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
AIL PROTECTED]>
Subject: Re: 2k and 8k block size
Sent by:
et> cc:
Sent by: Subject: Re: 2k and 8k block size
cc:
[EMAIL PROTECTED] Subject: Re: 2k and 8k bloc
From: <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 12:29
PM
Subject: Re: 2k and 8k block
size
> > My question was specific to RAC: With a larger block size,
is one not> increasing the chances o