Records Per Block in structure file

Posted by LegacyUser on 16-Apr-2001 11:46

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.

All Replies

Posted by LegacyUser on 18-Apr-2001 10:20

"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

This thread is closed