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: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

From: <nicola.farina_at_info-line.it>
Date: Fri, 14 Dec 2007 05:54:16 -0800 (PST)
Message-ID: <317daa9d-d465-4065-a5f5-24821d0d37ac@s19g2000prg.googlegroups.com> 





For those who are interested: it turns out that the sites with this
problem are affected from the bug #4055596 solved in 9.2.0.8.
Workaround: use analyze index ... compute statistics..
Bye


Nicola
Received on Fri Dec 14 2007 - 07:54:16 CST












Original text of this message













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