Re: Size of datafiles - performance impact?

From: Robert Altena <altena_at_gol.com>
Date: 1997/01/28
Message-ID: <32EDFE60.9E9@gol.com>#1/1

>
> As Oracle suggests, larger size of datafiles will obtain better
> performance
> in general, and less fragmentation.
>

The Oracle manual does say this. But We are having performance problems during the online backups (7.1 on windows NT3.51) the database becomes virtually unaccessible during the backup of 2 500Mb files.

/////////////////////////////////////////////////////////////////////
// Robert Altena                 tel/fax: (+81) (0)436-66-8238     
// Yuushuudai Nichi 1-4-6 B212    E-mail: altena_at_gol.com           
// Ichihara-shi, Chiba-ken                HCN01290_at_niftyserve.or.jp
// Japan                         
//                            www:  http://www2.gol.com/users/altena/

Received on Tue Jan 28 1997 - 00:00:00 CST