Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with Analyze!!
"Glen A Stromquist" <stromqgl_at_alpac.ca> wrote in message
news:4J0z6.5339$5_2.463141_at_news1.telusplanet.net...
> I wrote a script to delete statistics, then do an analyze compute
statistics
> on all of the tables in a schema. The anaylze failed on one table because
> the temp tablepace filled up.
>
> Performance is now so dismal the application is almost unusable, should I
> delete all of the stats from the analyze? I have to see if there is room
to
> increase the temp tablepace so the analyze will run on the one table it
> failed on.
>
>
> thanks in advance
>
>
>
>
>
Why don't you just use
begin
dbms_utility.analyze_schema(<SCHEMANAME>,'COMPUTE'|'DELETE');
end;
/
Hth,
Sybrand Bakker, Oracle DBA Received on Thu Apr 05 2001 - 11:26:27 CDT