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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Choosing data file size for a multi TB database?

RE: Choosing data file size for a multi TB database?

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 30 Aug 2005 07:58:09 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FB65@EXCNYSM0A1AJ.nysemail.nyenet>


Branimr,

I would choose file sizes as follows:

First, you need to get a ruling on hardware. You might be limited in file size choices depending on the hardware.

Second, I would ask for individual table sizing estimates. Somebody has got to give you information on the data distribution. I would then make file size choices dependent on managing these objects. Cluster small reference tables in the same tablespaces. Separate large/large-growth objects into their own tablespaces. For tables that are ginormous, start with tablespace sizes of 5G. This is completely arbitrary - maybe you want this to be 2G or 10Gig. But pick a value that you can live with. If the table is going to grow to be 500 Gig, how many file pieces do you want to support the one table?

Same thing with indexes. Really it's just a matter of picking a value and going with it. There are no other implications involved - Oracle acts the same either way.

Look closely at partitioning. It may be your best friend here when it comes to managing the objects. You could create a tablespace for each partition - or combine partitions in a set of tablespaces, depending on whether you have a purge criteria for the data.

Good Luck!

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Branimir Petrovic Sent: Tuesday, August 30, 2005 7:33 AM
To: oracle-l_at_freelists.org
Subject: Choosing data file size for a multi TB database?

How would you approach task of sizing data files for a project that will start with
a 1TB database but may relatively quickly grow to stabilize at around 10TB
mark?

Obvious options are:

Neither of the above options look very desirable (to me at least). First option
might be bad choice with checkpointing in mind, but the second option is not
the
winner if data files ever needs to be moved around. Anyway some initial choice must
be made, and all I'd like at this moment is not to give perilous initial advice...
(admission: once the "ball" starts rollin', this bastard ain't gonna be
mine:))

So from practical perspective - what would be the least troublesome choice?

Branimir

FYI I - OS platform is the darkest secret at this point, as is the hardware
specs
(no-one can tell, early signs of "well communicated, well managed"
project
are all
there)

FYI II - I've never had to deal with DBs much bigger than 100GB, thus the
need for
"reality check"..

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 30 2005 - 07:00:06 CDT

Original text of this message

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