Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle slow after adding datafile
"François Bourdages" <francois.bourdages_at_mobilair.qc.ca> wrote in message
news:aadece84.0210311211.3349f78a_at_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 ?
Yes. It would be better to create datafile to another disk, but the performance was awful. They told about 5-20 seconds delays when a one message is inserted! One message includes a few queries and two inserts. Another insert is adds a blob also.