Re: dropping analyze objects from data dictionary

Hi!

"amani" <amanclark_at_yahoo.co.uk> wrote in message news:ddbedb82.0307280710.56b63a2e_at_posting.google.com...
> I have an Oracle 8.1.7 Database running on a Windows 2000 server
> which, although it is medium sized at best, is and has been running
> slowly. I have noted that there are scheduled tasks running including
> an Analyze script which analyzes every schema, including SYS and
> SYSTEM.
>
> I've read that doing this can cause performance to fall significantly
> and cause problems. While there have been no huge problems so far,
> Would stopping the scripts analyzing the SYS and SYSTEM schema's give
> a potential increase in performance? If so, how would I drop the
> existing analysis data from the data dictionary? (I'm not yet very
> competent/confident at sql)

Yes, you should have no statistics on data dictionary on 8i.

use: exec dbms_utility.analyze_schema('SYS', 'DELETE');

Tanel. Received on Mon Jul 28 2003 - 13:01:22 CDT