Re: data analysis reporting tool for oracle
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 23 Oct 2003 11:24:07 -0700
Message-ID: <1066933461.527160_at_yasure>
Date: Thu, 23 Oct 2003 11:24:07 -0700
Message-ID: <1066933461.527160_at_yasure>
fg wrote:
>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
>
>
>
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_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Oct 23 2003 - 20:24:07 CEST