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 -> data file sizes

data file sizes

From: <gdas_at_my-deja.com>
Date: Fri, 12 Jan 2001 17:23:16 GMT
Message-ID: <93nehn$mbc$1@nnrp1.deja.com>

Hi,

Are there any performance considerations to take into account when sizing index and data tablespace datafiles? Do fewer but larger datafiles have any performance benefits to More but smaller datafiles? Does the fact that the files are on RAID 5 change the answer.

I've seen some posts here that support more but smaller files due to increased manageability, but I was curious if there were any performance implications.

Thanks,
Gavin

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 12 2001 - 11:23:16 CST

Original text of this message

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