Re: Database File Sizes

Hi Dennis,

i work with clusters of 2 gig files for several years now; 1991: Oracle 6.0.31 up to 7.3.2 using diferent machines.
No problems regarding the file size.
Do not use files larger than 2GB !

Kind regards,

Toni
In article <584unh$f32$1_at_mhafc.production.compuserve.com>, Dennis Williams <104052.3374_at_CompuServe.COM> wrote:

> Krishna K. Kurup wrote
> > I recently read a thread where someone was working with a 2.5 G
> > datafile on a DEC AlPHA. Since AIX 4.1.4 support files larger
> > than 2 GIG, I don't anticipate too many problems with Oracle
> > 7.3.2. I don't think you can even create a datafile larger than
> > 2 G using 7.2.x. I have tried that on Sequent systems ( 64 bit
> > architecture) but it couldn't > seek beyond 2 G and returned an
> > error (I was able to create a regular file in the OS about 12 G
> > in size).
>
> In my Installation & Configuration Guide for Oracle 7.2.3 for
> Digital Unix, in the section titled "Database and Log File Size",
> there is the following note:
> Note: Oracle Corporation recommends that database file
> sizes be no greater than 300 to 500 MB.
> Does anyone know if this is for real? We had been using much
> larger sizes until I saw this, and I have started using
> the smaller recommended sizes.
>
> ----------------------------------------------------------
> Dennis Williams, DBA
> Lifetouch Corp.
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |