Xref: alice comp.databases.oracle.misc:40627
Path: alice!news-feed.fnsi.net!enews.sgi.com!news-peer.gip.net!news.gsl.net!gip.net!newspeer.monmouth.com!baron.netcom.net.uk!netcom.net.uk!not-for-mail
From: "Alex Hudghton" <alex@alenda.freeserve.co.uk>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Analyze Table
Date: Thu, 9 Sep 1999 08:47:15 +0100
Organization: (Posted via) Netcom Internet Ltd.
Lines: 38
Message-ID: <7r7om4$lcg$1@taliesin.netcom.net.uk>
References: <7r48bj$3ej$1@news6.svr.pol.co.uk>
X-Trace: taliesin.netcom.net.uk 936863236 21904 194.42.240.2 (9 Sep 1999 07:47:16 GMT)
X-Complaints-To: abuse@corp.netcom.net.uk
NNTP-Posting-Date: 9 Sep 1999 07:47:16 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


DianeB <diane@adventservices.freeserve.co.uk> wrote in message
news:7r48bj$3ej$1@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?

Yes you shouldn't do it (can't remeber why!!)

From a previous post (not responsible for accuracy !!) - how to unanalyze
SYS

Alex



Start a SQL*Plus session, connect as sys, and delete the statistics using

analyze table name_of_table delete statistics;

If you're lucky, a package called dbms_utility is installed and accessible.
In this case just type

exec dbms_utility.analyze_schema('SYS','DELETE')

This command will de-analyze the entire schema SYS.
Check wether the statistics are deleted with
select *
from user_tables
where avg_space is not null;

This should return 'no rows selected', meaning that there are no values in
the col avg_space, so the table is not analyzed anymore.