Re: system stats (9205) - can they go stale?
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: mark.teehan@xxxxxxxx
- Date: Thu, 26 May 2005 09:33:17 -0400
Teehan, Mark wrote:
>Is there any way to tell if the optimizer has suddenly decided that it doesnt
>like the contents of sys.aux_stat$ any more?
>
>
>
Optimizer is not a PHB. Do 10053 or do "select * from
table(DBMS_XPLAN.DISPLAY)" or do @?/rdbms/admin/utlxplp and you'll
have a line which contains string "CPU costing" which can be in 3
states: On, Off or "Intel Inside". If your optimizer tells you that
the CPU costing is on, then it uses the system statistics.
--
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
