Re: Analyzing all tables ?

From: Darren Mallette <khs_riderx_at_geocities.com>
Date: 1998/03/27
Message-ID: <351bdde1.7780775@207.93.1.8>#1/1

"Marco Nedermeijer" <m.n.nedermeijer_at_rtd.nl> wrote:

>Is it possible to analyze all tables, indexes and clusters (in one step) ?
>Or must i write a script where all tables seperately are analyzed ?

Sure -- use the dbms_utility package. Here's the spec:

procedure dbms_utility.analyze_schema

(schema		varchar2
, method		varchar2
, estimate_rows	number default null

, estimate_percent number default null);

To analyze the objects in SCOTT's schema using the compute method, you'd:

exec dbms_utility.analyze_schema('SCOTT', 'compute');

Hope this helps.
-Darren

--
Remove the "x" to reply.

Received on Fri Mar 27 1998 - 00:00:00 CST