datablock sizing
From: Vissu <vissuyk_at_yahoo.com>
Date: 4 Mar 2004 19:56:44 -0800
Message-ID: <2bedd6a7.0403041956.3935854e_at_posting.google.com>
Date: 4 Mar 2004 19:56:44 -0800
Message-ID: <2bedd6a7.0403041956.3935854e_at_posting.google.com>
Hi All,
Thank you for your feedback on # of tablespaces. Can anyone share some
experiences on sizing the data block ?.
Assuming that the biggest row I would have takes up about 2K, what
should be the size of data block? I am debating between 8K and 16K. Is
there a rule of thumb as to how many rows should fit in a data block?.
Thanks a lot in advance,
Vissu