7.3.4 Statistics Problem

From: <wetherw_at_rbos.co.uk>
Date: 2000/07/25
Message-ID: <8ljrvg$c0h$1@nnrp1.deja.com>#1/1

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 7.3.4 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!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 25 2000 - 00:00:00 CDT