Re: Size of datafiles - performance impact?

 RA> From: Robert Altena <altena_at_gol.com>

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

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

I would venture a wild guess that this has something to do with not being able to tell oracle that the backup should be run at a lower priority than the other accesses. Switch to unix, or do cold backups.

jg

--
Standard disclaimer: The views of this user are strictly his own.