Re: DBA Reporting Tools

You need to write your own sql staments to gather the statistics.

1.exec dbms_utility.analyze_schema('USERNAME','COMPUTE'); 2.get what you need from the data dictionaries, some of the important dictionaries are.

dba_tables,dba_tab_columns,dba_objects,index_stats,dba_tab_columns,dba_ind_columns,dba_tab_partitions,dba_indexes,user_constraints,user_ind_columns.Refer the documentation for more details

yitbsal_at_statcan.ca wrote:

> Hi,
>
> I'm looking for software that can produce reports on the physical
> structure of an Oracle database. A typical 'table report' would include
> table name, triggers, constraints, columns, dependencies, etc. A
> package report would include procedures and functions, and each
> procedure and function's dependencies.
>
> I've generated reports using TOAD and ER-Win, but neither was to my
> satisfaction.
>
> Any recommendations?
>
> Salaam
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 25 2000 - 14:42:04 CST