Re: Analyze Table

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Wed, 8 Sep 1999 18:07:13 +0100
Message-ID: <3DwB3.117$xd3.3219@newreader.ukcore.bt.net>

I'm not an Oracle Financials expert - however all experts advise NOT to analyze the SYS schema.

If you have run an 'analyze ....delete statistics'

This advise may change with later versions of Oracle - I would suspect at or before they withdraw RBO.(Rule Based Optimizing)

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. DianeB <diane_at_adventservices.freeserve.co.uk> wrote in message news:7r48bj$3ej$1_at_news6.svr.pol.co.uk...
> Should I be running Analyze table on my Oracle Fiancials 10.7 database.
> Does the Fiancials Code make use of the Cost Based optimiser ?
>
> I have inadvertanlty run an Analyze Table on the SYS schema , is this a
> problem?
>
>
>
>
Received on Wed Sep 08 1999 - 12:07:13 CDT