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: Oracle slow after adding datafile

Re: Oracle slow after adding datafile

From: François Bourdages <francois.bourdages_at_mobilair.qc.ca>
Date: 31 Oct 2002 12:11:35 -0800
Message-ID: <aadece84.0210311211.3349f78a@posting.google.com>


"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

Original text of this message

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