Re: Recomended max datafile size

From: Ryan <rgaffuri_at_cox.net>
Date: Wed, 21 May 2003 21:48:40 GMT
Message-ID: <YuSya.50016$823.32024@news1.east.cox.net>

"Tanel Poder" <tanel@@peldik.com> wrote in message news:3ecb65c7$1_1_at_news.estpak.ee...
> Hi!
>
> It takes less to restore (and recover) a 2 GB datafile than 20GB one. So
in
> case of recovery "performance", smaller is better. But under normal
> circumstances, as Nuno said, doesn't matter.
>
> I prefer to keep datafiles 2040MB, a bit less than 2GB.
>
> Tanel.
>
> "Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
> news:3ecb549f$0$16259$afc38c87_at_news.optusnet.com.au...
> > 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.
>
>

2gb? What if you are on a terabyte or multi-terabyte system? Your talking 500 datafiles plus. is that standard?

not criticizing. just asking. Received on Wed May 21 2003 - 16:48:40 CDT