Re: Recomended max datafile size

From: Tanel Poder <tanel_at_@peldik.com>
Date: Wed, 21 May 2003 14:44:51 +0300
Message-ID: <3ecb65c7$1_1@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.
Received on Wed May 21 2003 - 06:44:51 CDT