Re: Oracle slow after adding datafile

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 31 Oct 2002 21:46:05 GMT
Message-ID: <3DC1A498.122BB275@exesolutions.com>

François Bourdages wrote:

> "Jake S" <nospam_at_nospam.net> wrote in message news:<wJ9w9.352$mA4.13937_at_read2.inet.fi>...
> > Hi,
> > There is a production database server (SunOS) with Oracle 8.1.7. installed.
> > There was only a 500M datafile that was filled during testing phase. I added
> > another datafile, this time 5000M. Right after that, I was told that it's
> > not enough and I added a third one, this time 30 000M.
> >
> > All data was deleted and another testing was started. This time they tell me
> > that Oracle is exceptionally slow. They noticed it right away but all I did
> > was that I added two datafiles with alter tablespace. Any ideas why this
> > might have happened or how to fix it?
> >
> > - Jake -
>
> Does the datafiles created on the same disk speed that the other one ?

I also notice that we appear to be talking about one 30GB file. Not knowing which version of SunOS I am left wondering how well it handles files larger than 2GB?

Daniel Morgan Received on Thu Oct 31 2002 - 15:46:05 CST