You didn't mention the version of Oracle which you gonna use.
Starting with 10g, you can create a bigfile tablespace with a single datafile size range from MB to TB, (depends on your db_block_size).
However, as other already suggested here, you need to think of consequences or the following scenarios:
1. Backup time
2. recovery time
3. single point of failure (in case tablespace has only one datafile (big size).
4. OS support
and so forth.
We have around 2TB database in which couple of database sized around 20gb.
But, I am not so favor of big datafiles (in sizes).
Jaffar
On 7/6/07, genegurevich@discover.com
<genegurevich@discover.com> wrote:
Hi all:
I am building a database which will grow to 2.5 or 3 Tb. I am wondering
what is a realistic file size I should be using.
One of my tablespaces will be about 1.5Tb. I don't want to have too many
files, but I don't want to have the datafiles
that are too big. I don't know however how big is too big. Does anyone have
any guidelines or documents for that?
Any experience with this? My filesystems are 130G so I can create fairly
large files.
thank you
Gene Gurevich
--
http://www.freelists.org/webpage/oracle-l
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
