Re: Size of datafiles - performance impact?

From: Paul <bfekrat_at_erols.com>
Date: 1997/02/02
Message-ID: <5d2edj$6qn@boursy.news.erols.com>#1/1

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_at_pebble.org>, Joel.Garry_at_pebble.org says...


>

> 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.

Received on Sun Feb 02 1997 - 00:00:00 CST