Updating Statistics for the Data Dictionary -- Or

From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Fri, 8 Jul 94 21:20:00 -0500
Message-ID: <12a.3210.905_at_compudata.com>

-> There are two mechanisms (that I am aware of) for updating statistics
-> for the data dictionary with Oracle 7.0:
->
-> 1. Procedures - ANALYZE_SCHEMA, ANALYZE_OPTIONS
-> 2. SQL script - CATSTAT.SQL

NEITHER! Do NOT enable the cost based analyzer in Oracle 7.0 Serious bugs, will not find indexes,will turn previous quick code into trash!

Oracle support told me to wait for 7.1 before using it. If you accidently analyze anything to gathe r the stats, drop them NOW! Received on Sat Jul 09 1994 - 04:20:00 CEST

This message: [ Message body ]
Next message: amckee_at_bfsec.bt.co.uk: "How much data when using SQLNET"
Previous message: Joerg Schmiedle: "How to set Oracle-roles from VB"
In reply to DaveT: "Updating Statistics for the Data Dictionary -- Oracle 7.0"
Next in thread: chadb_at_NeoSoft.com: "Re: Updating Statistics for the Data Dictionary -- Or"
Maybe reply: KIRILLS_at_DELPHI.COM: "Re: Updating Statistics for the Data Dictionary -- Or"
Reply: Barry Roomberg: "Re: Updating Statistics for the Data Dictionary -"
Reply: Karin Schroeter: "Re: Updating Statistics for the Data Dictionary -- Or"
Maybe reply: SSR: "Re: Updating Statistics for the Data Dictionary -- Or"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message