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_at_gmail.com> 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_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."
--
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
Received on Fri Jul 06 2007 - 19:48:32 CDT
