Re: Un-ANALYZE SYS

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.

Good luck

Jac.
jbeekers_at_xs4all.nl

Mark G. Woodruff wrote in message <731no6$224$1_at_comet3.magicnet.net>...
>Oops.
>
>I was reading in Oracle Performance Tuning that it was not a good idea
>to analyze the SYS tables. I've already analyzed them. Is there a way
>to undo the analyze?
>
>
Received on Thu Nov 19 1998 - 14:24:36 CST