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 > > > -- > //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 -- //www.freelists.org/webpage/oracle-l