Re: optimizer_features_enable parameter & query plan

On 9 Jun 2006 04:50:49 -0700, "News" <Contact_404_at_hotmail.com> wrote:

>
>Sybrand Bakker a écrit :
>
>> exp help=y informs you about the various values of the statistics=
>> parameter
>
>This assumes that stats are available in 9i DB ? gathered
>periodically??
>I have already tried upgrading few DBs as described in docs. Upgrade
>Information Tool always displayed:
>
>WARNING: --> Database contains stale optimizer statistics.
>.... Refer to the 10g Upgrade Guide for instructions to update
>.... statistics prior to upgrading the database.
>.... Component Schemas with stale statistics:
>.... SYS
>(among others)

You could export them to a stats table with dbms_stats.export_schema_stats prior to exporting the database (and import them in the dictionary after database import) The statistics= parameter makes sure export add a command to gather statistics right after table creation.

--
Sybrand Bakker, Senior Oracle DBA