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: after adding 6 new datafiles the performance go down

Re: after adding 6 new datafiles the performance go down

From: Tianhua Wu <tianhua.wu_at_mirant.com>
Date: 19 Feb 2002 06:47:20 -0800
Message-ID: <18e503ea.0202190647.42a1496@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 Tue Feb 19 2002 - 08:47:20 CST












Original text of this message













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