Re: file size for a large database

Heh... true.
Few days ago with one of the customers we hit the bug with 8.1.7 on
windows. Apparently, you shouldn't make your datafiles sized in
multiples of 4 GB. It reports block corruption later. I repeat - it's
only valid for 8.1.7 so I bet that this new roll out is higher than
that. :)

On 7/6/07, Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx> wrote:

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@xxxxxxxxxxxx <genegurevich@xxxxxxxxxxxx> 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."



--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://blog.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: