Re: Recomended max datafile size

You should also have a look at the thread "Taking tablespace and datafiles offline". Richard Foote makes some useful comments regarding backup/recovery and datafile size.

Regards,
Anthony Hogan

Noons wrote:
>
> Just from the "performance point of view", none
> whatsoever. From the reliability point of view,
> you may well be advised to stay <2Gb, or <4Gb, or
> <64Gb, depending on the OS type and version
> and the combination of that and Oracle version.
>
> --
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
> "Robert" <grobert_at_azet.sk> wrote in message
> news:a8497ec7.0305210221.2cb0c45a_at_posting.google.com...
> > Hi!
> >
> > Is there any recomandation about maximum size of datafile in Oracle
> > just from the performance point of view. For now I use max datafile
> > size 2Gb on OLTP system(SAP R/3).
> >
> > Regards
> > Robert
Received on Wed May 21 2003 - 06:37:31 CDT