Report for Stats like DB20.....

[Former Member]

Hi,

We have Oracle 10.2 on Solaris.

Is there any report by SAP or alogorithm at SQL level which can tell me the daviation for all the table stats like it is shown in DB20 trasnaction for one table at a time.

I can write SQL if somebody can tell me the table names. I did some tracing in ST05 to find out the tables names but no major success.

Any help will be greately appreciated.

Regards,

SC

[Former Member]

The information is available in the oracle views dba_tables and dba_tab_modifications.

Example, num_rows is the stat for the number of rows:

SQL> select num_rows from dba_tables where table_name = 'USR02';
  NUM_ROWS
----------
       168
SQL> select count(*) from sapr3.usr02;

  COUNT(*)
----------
       169

Cheers Michael

[Former Member]

It was very helpful.

Regards,

SC