Re: 7.3.4 Statistics Problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/25
Message-ID: <964537521.18636.0.pluto.d4ee154e@news.demon.nl>#1/1

Why don't you just run dbms_utility.analyze_schema('<schemaname>','COMPUTE') on the target database instead of trying to create *unsupported* havoc. Analyze_schema generates statistics for all tables an indexes within a schema, and it is not slow.

Hth,

Sybrand Bakker, Oracle DBA

<wetherw_at_my-deja.com> wrote in message news:8ljrp4$bvm$1_at_nnrp1.deja.com...
> We're currently still operating on version 7.3.4
> (!) of Oracle which pre-dates the provision of
> DBMS_STATS package for exporting/importing
> optimiser statistics.
>
> Does anyone have tips or tricks for copying stats
> from a 7.3.4 production volume database into
> another schema which has smaller tables, for
> performance testing using the cost-based
> optimiser?
>
> Is it possible (albeit risky) to manually update
> SYSTEM tables?
>
> Thanks for any help!
> Rob W
> London
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 25 2000 - 00:00:00 CDT