Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle slow after adding datafile
"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 ? Received on Thu Oct 31 2002 - 14:11:35 CST