Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Analyze Table

Re: Analyze Table

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 7 Sep 1999 20:53:37 -0400
Message-ID: <ptiB3.9414$r5.663864@typ11.nn.bcandid.com>


Don't know about the financials, but you definitely should not analyze objects owned by SYS or SYSTEM. I'd check with Oracle support to see what they advise since it has already been done.

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 Tue Sep 07 1999 - 19:53:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US