Re: script for statistics gather DBMS_STATS

On 23 Mar, 14:33, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> 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?

select
initial_extent,NUM_ROWS,AVG_ROW_LEN,blocks,CHAIN_CNT,last_analyzed from user_tables ...

i need this values for verify chianed rows:

(chain_cnt/num_rows) > 0.1 Received on Fri Mar 23 2007 - 09:01:43 CDT