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: 9i Analyze Behavior (DBMS_STATS)

Re: 9i Analyze Behavior (DBMS_STATS)

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 28 Feb 2003 20:33:39 +1100
Message-ID: <pan.2003.02.28.09.33.38.972828@yahoo.com.au> 





On Thu, 27 Feb 2003 20:51:42 +0000, Buck Turgidson wrote:



> I guess I thought that since the table was not monitored, when I ran

> dbms_stats, it would update the statistics of the table since it could not

> tell if the statistics were stale or not.

> 

> Is my logic backwards?




Yup. Gather_stale (which is part of what gather_auto is doing) only
calculates statistics when it knows the statistics are stale.



Regards


HJR

Received on Fri Feb 28 2003 - 03:33:39 CST












Original text of this message













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