Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Stats not gathered on all tables with GATHER_STATS_JOB in 10g

Re: Stats not gathered on all tables with GATHER_STATS_JOB in 10g

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: 2005-12-19 14:23:56
Message-id: 5e3048620512190523g6201fbadoe75153b36efa4683@mail.gmail.com 





There's a number of exclusions if memory serves (a trace reveals them)
besides SUMDELTA$



DR$ tables


DR# tables


materialised view logs



the latter of which (may) make enough sense since it would dynamically
sampled at mview refresh time.



--
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"


Received on Mon Dec 19 2005 - 14:23:56 CST












Original text of this message













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