Ask the Expert

Tools to help size tables

Is there a tool/book that will help me correctly size a table. I have information indicating the "projected growth" or number of records a particular table will have, but I'm not sure how to calculate the size the table needs to be. Thanks for your help.

    Requires Free Membership to View

There is some good table sizing information on Metalink if you have an account. There is a simple HTML form (found at http://www.suhas.com/tsize.html) that you could use to get started as well.

Books that I know of that have information on table sizing are "Oracle8i Administration and Management" by Michael Ault, "Oracle8i Tuning and Administration" by Heidi Thorpe and "Oracle8i DBA Handbook" by Kevin Loney and Marlene Theriault. I'm sure there are lots of others as well.

In general, to perform a quick estimate of table size, you need to know four pieces of information:

  1. DB_BLOCK_SIZE
  2. PCTFREE for the table (how much room you want to leave for future updates, etc)
  3. Average row length
  4. Expected number of rows in the table

For More Information


This was first published in June 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: