RE: performance impact

Windows and 8.1.6 were what caught me, but I believe that similar bugs have been logged on various Unices.

The windows metalink alert is Note 148894.1 the underying bug is 1612154

Note 112011.1 is also relevant, platform independant and pertinent to my fnal two recommended sizes:(

I was especially pleased to discover that a bad file size choice meant PITR was mandatory, particularly as support didn't actually ever tell me this, but usenet did. Being caught twice just meant that I had configured test the same as prod, naturally.

Niall

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Niall Litchfield
> Sent: 29 April 2003 22:37
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
>

-- 
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).