Question: Comparing stats from ANALYSE and DBMS_STATS

Hi, all.

I'm in the process of implementing DBMS_STATS and the CBO in our environment.

One of the things I'd like to do is compare the plans which result from the stats generated by DBMS_UTILITY and DBMS_STATS/CBO.

I presume that the structure of the stats in the dictionary is the same regardless of how they are generated. Therefore, it seems reasonable that I could pull out the current stats (generated by DBMS_UTILITY) with the export_database_stats and stick them in a separate table which I'd created with DBMS_STATS.

Is this reasonable? If I want to retain the current dictionary stats, is there a supported means to do this, within the confines of DBMS_UTILITY? I don't see one in the package spec...

Thanks!

Cheers,

DW. Received on Tue Jun 28 2005 - 13:45:25 CDT