RE: performance impact

I have been caught twice with datafiles that are *exactly* xGB in size by oracle bugs (read restore from backup because a datafile became 2^n gb in size). I no longer trust oracle to handle files 2^n gb in size where n is an integer. In addition If you are using locally managed tablespaces it would be smart to allocate 64kb (or even a whole MB) to the file size so that the extent bitmap can sit there. So I would go for

2049mb,
4097mb,
8193mb or
16395mb

You can obviously choose the more precise kb figure if required.

Niall
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of Roger Xu
> Sent: 28 April 2003 22:02
> To: Multiple recipients of list ORACLE-L
> Subject: performance impact
>
>
> For a 400 GB tablespace, which one is better?
>
> 1) 200 2GB datafiles
> 2) 100 4GB datafiles
> 3) 50 8GB datafiles
> 4) 25 16GB datafiles
>
> [64-bit Oracle 9i on Solaris 9]
>
> Thanks,
> >
> > Roger Xu
> > Database Administrator
> > Dr Pepper Bottling Company of Texas
> > (972)721-8337
> >
>
> ______________________________________________________________
> __________
> This email has been scanned for all viruses by the
> MessageLabs SkyScan service. For more information on a
> proactive anti-virus service working around the clock, around
> the globe, visit http://www.messagelabs.com
> ______________________________________________________________
> __________
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: roger_xu_at_dp7uptx.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).