From: bfekrat@erols.com (Paul) Subject: Re: Size of datafiles - performance impact? Date: 1997/02/02 Message-ID: <5d2edj$6qn@boursy.news.erols.com>#1/1 references: <32ED600E.3B90@dt.com.hk> <32EDFE60.9E9@gol.com> <8d6_9701281838@pebble.org> content-type: Text/Plain; charset=US-ASCII organization: Erol's Internet Services mime-version: 1.0 newsgroups: comp.databases.oracle.server Are you saying that you cannot prioritize Oracle's tasks on NT? Paul -- Unstandard disclaimer: HAVE FAITH IN THE FIRST AMENDMENT - HA. In article <8d6_9701281838@pebble.org>, Joel.Garry@pebble.org says... > > RA> From: Robert Altena > >> >> 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.