data analysis reporting tool for oracle

[fg]

Hello

I am looking for a report tool that analyse an oracle database, and compute
statistics from the data such that average/max length of attributes for each
table.

Thanks

[Daniel Morgan]

fg wrote:
HelloI am looking for a report tool that analyse an oracle database, and computestatistics from the data such that average/max length of attributes for eachtable.Thanks
SQL> exec dbms_stats.gather_schema_stats(OWNNAME=>'<schema_name>',
CASCADE=>TRUE);

The answers are in dba_tables, dba_indexes, etc.

When spend a dime to get what you already have?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)