topic Re: Database table sizes in Application Development and Automation Discussions

Database table sizes

former_member841378 — Fri, 30 Oct 2009 06:57:12 GMT

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

Re: Database table sizes

RaymondGiuseppi — Fri, 30 Oct 2009 07:01:11 GMT

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

Re: Database table sizes

venkat_o — Fri, 30 Oct 2009 07:03:25 GMT

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

Re: Database table sizes

Former Member — Fri, 30 Oct 2009 07:07:17 GMT

hai,

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

Re: Database table sizes

former_member841378 — Fri, 30 Oct 2009 07:23:57 GMT

Hi all,

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

Thanks,

Kumar

Re: Database table sizes

former_member841378 — Fri, 30 Oct 2009 07:27:20 GMT

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