Oracle-L: Re: Table Size

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Tue, 29 Oct 2002 06:03:27 -0800
Message-ID: <F001.004F61BD.20021029060327@fatcity.com>

The best way to calculate the size of a table is to load it with 1000 production data rows. Then calculate the size of the predicted volume.
You should be able to handle the first year of data at day 1.

Do not loose time to calculate the table size at the byte level with formulas.

For the temp tablespace, it depends on your application needs. You should be able to rebuild all objects successfully.

As for the rollback segment tablespace, then again it depends on your application and number of users.

Do not forget space for exports, backups, workspace, at least 2 versions of Oracle software, ...

I just went to a DB2 fast track for experienced DBA. According to IBM, the total size for the DB environment is 4 times the size of the data in the DB. (DB2 uses a lot of temporary files outside the DB).

prem_at_ibsplc.com a écrit : > 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

Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.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 - 08:03:27 CST