Re: Stats not gathered on all tables with GATHER_STATS_JOB in 10g
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Dec 2005 21:23:56 +0800
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@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
Other related posts:
