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:
- PCTFREE for the table (how much room you want to leave for future updates, etc)
- Average row length
- Expected number of rows in the table
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available here.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in June 2002