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

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: system stats (9205) - can they go stale?
From: Dennis Williams

References:
- system stats (9205) - can they go stale?
  - From: Teehan, Mark

Re: system stats (9205) - can they go stale?

Other related posts: