Re: Size of datafiles - performance impact?

Mark Rosenbaum wrote:

> >> Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
> >> PGP key available on request
> >> ===============================================================
> >> Life is a game of bridge - and you've just been finessed.
> >>
> >
> >This brings to mind the saying "It's not the size that counts, but how you
> >use it". <g>
> >
> >Size isn't a factor on performance, but analyzing the types of typical
> >queries issued against the database and allocating Oracle resources
> >properly will make all the difference in the world.
> >
> >Tim Nimmo...
>
> Some time ago I remember reading in the install guide for 7.2 (maybe),
> on an SGI (maybe) that files of less than 500 MB were recomended.
> No reason was give.

Reason would have been because it's easier to move files of 500M around rather than 1G files. We usually have 500M lying around somewhere, but 1G will probably require a new disk. So yes, usage matters.

Leng. Received on Mon Jan 27 1997 - 00:00:00 CST