Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafile size / performance

Re: datafile size / performance

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Fri, 23 Apr 1999 12:12:10 +0200
Message-ID: <3720477A.54A5@mail.esrin.esa.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US