Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile size / performance
Hi Sam,
Look at your disk I/O (PHYBLKRD + PHYBLKWRT from v$filestat) per disk (join on file# to something like v$datafile or v$dbfile) to see if you have some disks being over-utilised and other disks under-utilised. If you have, splitting hot areas across smaller datafiles on different disks rather than one large datafile on one disk could remove an i/o bottleneck.
James
--
james_at_valhall.esrin.esa.it.NOSPAM
Sam Jordan 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
Received on Fri Apr 23 1999 - 05:12:10 CDT