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: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 6 Dec 2007 08:53:39 -0800 (PST)
Message-ID: <8ad785cd-8b7d-456c-a285-b5a36ae54ee0@p69g2000hsa.googlegroups.com> 





On Dec 6, 10:42 am, nicola.far..._at_info-line.it wrote:


> DBMS_STATS.GATHER_SCHEMA_STATS(user, METHOD_OPT => 'for all columns

> size 1', CASCADE => True);

>

> scheduled each day early morning

>




Dollar gets you a doughnut that the table was empty at the time you
analyzed it.
Received on Thu Dec 06 2007 - 10:53:39 CST












Original text of this message













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