Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> script for statistics gather DBMS_STATS

script for statistics gather DBMS_STATS

From: Andrea <netsecurity_at_tiscali.it>
Date: 23 Mar 2007 05:39:19 -0700
Message-ID: <1174653559.577773.201440@p15g2000hsd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US