In converting to a V9 database with storage areas, what is recommended as our "Records Per Block" in the structure file?
We have our V8 database set up with 16k block size.
"Steve Snyder" wrote:
>>In converting to a V9 database with storage areas, what
>is recommended as our "Records Per Block" in the structure
>file?>We have our V8 database set up with 16k block size.
>
Hello,
First you cannot set 16K blocksize for your
data extents. You can only set 16k blocksize
for bi and ai extents.
For the calculation of "records per block" ,
first do the dbanalys on your database
and calculate "records oer block" for any
table depending on the lenth of record for
that table.
Sunil