Re: Good Analyze script

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 May 2002 09:37:03 +0200
Message-ID: <uehb72ra8ipj6c@corp.supernews.com>

"Linda Lee" <goforticket_at_yahoo.com> wrote in message news:f901fb80.0205190929.46c7a949_at_posting.google.com...
> I want to analyze tables and indexes for a whole schema using
> dbms_stats. My database is big and a robust script is necessary. Do
> you know where I can get a good and free script (pl/sql procedure or
> package) to do that job on the web?
>
> Thank you very much.

dbms_stats.gather_schema_statistics

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon May 20 2002 - 02:37:03 CDT