On Mar 23, 8:39 am, "Andrea" <netsecur..._at_tiscali.it> wrote:
> hi,
> sometimes i launch dbms_stats.gather_schema.... for perform CBO of my
> oracle 9i DB.
> After that, i verify the number of rows, avg. row length and number of
> blocks of each table from user_tables. But this is very slow and
> expensive, because i must to read data for single table.
>
> I would like to know if there is some sql script for retrive summary
> information of all table statistics.
>
> thanks!
>
> bye
> andrew
Why exactly are you attempting to verify by querying user tables the
results of a dbms_stats operation?
Received on Fri Mar 23 2007 - 08:33:02 CDT
