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: Size of datafiles - performance impact?

Re: Size of datafiles - performance impact?

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/01/27
Message-ID: <32ED600E.3B90@dt.com.hk>#1/1

Andy Hardy wrote:
>

 , does the size of my datafiles have an impact on Oracle itself
> e.g. can it handle many-smaller datafiles easier than fewer-larger ones?

As Oracle suggests, larger size of datafiles will obtain better performance
in general, and less fragmentation.

Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049
Received on Mon Jan 27 1997 - 00:00:00 CST

Original text of this message

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