Re: Statistics for CBO

Andrea wrote:
> hi,
>
> sorry for my questions, but i need to understand these concepts.
>
> I've read that on oracle 10g with "analyze" command and DBMS_STATS package
> i can get the statistics that are use for Cost-base-Optimizer (CBO)
> for increase DML statements. DBMS_STATS further on oracle 10g it runs
> automatic schedule from 10 PM to 6 AM every days.
>
> but after run, where statistics are stored?? maybe in DBA_TABLES and
> DBA_INDEX?
>
> thanks very much
>
> bye
> andrew

The analyze command is deprecated in 10g with respect to the optimizer. What is rattling around in my head right now is RTMF ... but rather than say that to you might I suggest you go to http://tahiti.oracle.com and read the documentation?

The answer to your question ... they are stored in the data dictionary. In tab$, obj$, ind$, etc.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org