Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> datablock sizing

datablock sizing

From: Vissu <vissuyk_at_yahoo.com>
Date: 4 Mar 2004 19:56:44 -0800
Message-ID: <2bedd6a7.0403041956.3935854e@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 Received on Thu Mar 04 2004 - 21:56:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US