Re: file size for a large database

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_at_discover.com <genegurevich_at_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."

--
http://www.freelists.org/webpage/oracle-l