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: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 14 Dec 2007 12:00:29 -0800 (PST)
Message-ID: <662b8773-9935-4e73-a900-1d6a42dab3a8@e25g2000prg.googlegroups.com> 





On Dec 14, 7:54 am, nicola.far..._at_info-line.it wrote:


> 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




Nicola,



I thought the DDL you gave me was complete. Apparently we were missing
the create mview part. If we had known there was an mview involved, we
would be more efficient in finding the bug.



Yong Huang
Received on Fri Dec 14 2007 - 14:00:29 CST












Original text of this message













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