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

DBA_TABLES just shows when they were run.

See $ORACLE_HOME/rdbms/admin/dbmsstat.sql - they are in the dictionary.

Also see catost.sql.

jg

--
@home.com is bogus.
"Sorry, but would you mind putting your feet down?  We can't hear." -
Miss Manners