Re: Performance question: single datafile vs multiple datafiles

> Suppose the file is opened and closed very frequently

only if shutdown and startup your database very frequently :-)

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0202280942.5acc0ecb_at_posting.google.com...
> If there's only one physical disk, the difference is very small.
> Suppose the file is opened and closed very frequently, further suppose
> it's written a lot (not mostly for read), splitting into multiple
> files helps to reduce inode locks.
>
> Yong Huang
> yong321_at_yahoo.com
>
> dub_at_latnet.lv (Dub) wrote in message

news:<6445524b.0202280750.cd1f633_at_posting.google.com>...
> > Hi,
> >
> > What is better from performance point of view - to extend existing
> > single datafile or to add one more datafile?
> >
> > Assume I use the same physical disk.
> >
> > Any suggestions/links will be highly appreciated.
> >
> > BR,
> > Dub
Received on Thu Feb 28 2002 - 14:29:47 CST