Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: after adding 6 new datafiles the performance go down
Thanks for the information i still try it for the tables which are needed
for my job, and i got a better performance. But it is at time not so fast as
the time before adding the files.
"Tianhua Wu" <tianhua.wu_at_mirant.com> schrieb im Newsbeitrag
news:18e503ea.0202190647.42a1496_at_posting.google.com...
> analyze the tables and try your statement again. You have out of date
> statistics in your dict which could cause the problem.
>
> "Alexander M?ler" <it_mueller_at_web.de> wrote in message
news:<a4rdqv$h9k$1_at_news.online.de>...
> > No, i didn't analyze the tables after reorg.
> >
> >
> >
> > "Tianhua Wu" <tianhua.wu_at_mirant.com> schrieb im Newsbeitrag
> > news:18e503ea.0202180657.1132b8eb_at_posting.google.com...
> > > Did you analyze the tables after re-org?
Received on Wed Feb 20 2002 - 12:31:03 CST