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: index_stats no populating

Re: index_stats no populating

From: Anurag Varma <avoracle_at_gmail.com>
Date: 20 Jan 2006 10:22:45 -0800
Message-ID: <1137781365.602035.141140@g14g2000cwa.googlegroups.com> 





Did you query index_stats in the *same* session where you ran the
analyze index ... validate structure;


?


Also note: the table will be populated only for the latest analyze ....
statement run.



Running analyze index ... compute statistics ... has nothing to do
with your issue. 



Anurag
Received on Fri Jan 20 2006 - 12:22:45 CST












Original text of this message













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