In article <372008F7.DAF41398_at_spin.ch>,
sjo_at_spin.ch wrote:
> Hi
>
> Has the size of the datafiles some influence on Oracle DB Server
> performance? Is it better to have more smaller datafiles or few
> larger datafiles?
>
> bye
> --
> Sam Jordan
>
Hi Sam,
If you use smaller datafile you can distribute ones accross available
disks. It improves performance in multi-user or parallel query/server
environment.
In some OS you can create larger datafile and use stripped logical volume
for filesystem or raw device location.
It is correct for normal operation,but media recovery operation is slower for
larger files and may be more complicated.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 23 1999 - 04:50:59 CDT
