Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> script for statistics gather DBMS_STATS
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
Received on Fri Mar 23 2007 - 07:39:19 CDT