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

Home -> Community -> Usenet -> c.d.o.server -> Re: help with Analyze!!

Re: help with Analyze!!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 5 Apr 2001 18:26:27 +0200
Message-ID: <tcp71qmaj2ku3f@beta-news.demon.nl>

"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

Original text of this message

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