Re: Oracle datafile size in Windows

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 5 Sep 2002 15:03:40 +1000
Message-ID: <CrBd9.25209$g9.71397@newsfeeds.bigpond.com>

Hi EP,

I personally would recommend option 2 with a 100 GBish database.

This will require 50ish data files which is not particularly excessive. It will also give you more flexibility with online backup strategies and less issues with restore and recovery times if such a fateful day were to arrive.

Cheers

Richard
"EP" <ep_at_plusnet.pl> wrote in message news:al5qmj$k2o$1_at_news2.tpi.pl...
> Hi,
>
> Oracle 8.1.7 database - size ca. 100 GB
> Windows 2000 Advanced Server - NTFS
>
> What is the better solution:
> 1. few large datafiles
> 2. numerous relatively small datafiles (max. 2 GB)
>
> In case of the first solution - how do you think- what is the "safe" size
of
> such large datafile in Windows ?
>
> TIA
> EP
>
>
>
>
>
Received on Thu Sep 05 2002 - 00:03:40 CDT