Oracle-L: RE: Table Size

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 29 Oct 2002 05:54:05 -0800
Message-ID: <F001.004F61A0.20021029055405@fatcity.com>

Prem - Simple way to get in the ballpark with table size. Figure out how large your average row is and multiply by the number of rows. This is only approximate and you'll want to size larger for indexes and other effects like the fact that your data blocks won't be 100% utilized. Better yet, create a test table, insert some data, ANALYZE the table, and then get the average row length from USER_TABLES view.

How large the entire database will be depends on many factors. If you are just creating a simple test database and have a gig or so of space, then you shouldn't have a problem. Oracle Installer is good today about sizing everything for you. If you care to, look up the new feature Oracle Managed Files, designed just for people like you. On the other hand, if you have a special reason for being really, really concerned about precisely how much space it will take, then welcome to the world of the Oracle DBA. We can help you, but you need to provide more information. Hope this is what you were asking.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, October 28, 2002 10:44 PM
To: Multiple recipients of list ORACLE-L

Dear List,

I am using Oracle 9i database. I need to identify the space requirements for our database for the production database. Can anybody suggest how to calculate the size of a table. and also additionally how to calculate the size of the whole database.?

Regards
Prem

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 29 2002 - 07:54:05 CST