Database table sizes

[former_member841378]

Hi Experts,

I need to find out database table row count and the width for all the tables in the database.

and need to consider the performance also while finding out the above details.

Thanks,

kumar

[RaymondGiuseppi]

Try transactions like DB02 and ST04. (Look at documentation like [Database Administration|http://help.sap.com/saphelp_nw70/helpdata/en/29/7d4ed11dc11d45a73850df6e8a1bac/frameset.htm]) - which database do you use : Oracle, MS SQL, DB2, MaxDB, etc. ?

Regards,

Raymond

[venkat_o]

Hi Kumar, <li>DB table rows are found like below.

DATA:table_count.
SELECT COUNT(*) FROM mara INTO table_count.

<li>Use DB6PMHT_HD (DB6: Summary Record of Table and Index Space Statistics) table to check the database table size.

    REPORT ztest_notepad.
   TABLES :db6pmht_hd.

   SELECT  SINGLE *
     FROM  db6pmht_hd
    WHERE  stattype    = 'D'    "D-daily
      AND  objectname  = 'MARA'
      AND  objecttype  = 'T'.   "T-table.

   WRITE:/ 'Table', 'MARA', 'size', db6pmht_hd-sizekb.

Thanks Venkat.O

[Former Member]

hai,

Please Check DD09L table Also, Technical Settings Are given there, May be helpful For u.

[former_member841378]

Hi all,

And the database table row count which i need to find is client specific.

Thanks,

Kumar

[former_member841378]

Hi all,

I have table 'DBSTATHORA' , if the database is Oracle

and 'MSSDBSTATT' table ,if the database is MSSql to find out the database table rows.

But using the above said tables i am getting total rows irrespective of clients.

Instead i need to have only rows for specific client.

Please help me out.

Thanks in advance,

Kumar