Skip to Content
Former Member
Dec 13, 2012 at 11:12 AM

To find out which tables require reorganization or updating stats in SAP


Hie all,

One of my production system's performance has gone down drastically. And the management has asked to find out tables which require re-organization or updating statistics to improve the system performance.

Now my query is how to find out which tables in my production system which is causing slowness requires re-organization or updating stats.

Is there any ABAP program or a SQL script to find out tables that are highly used and which causes the slowness in the system. Is there anyway to find out tables whose stats are not updated or re-org ed from past a long time due to which system gets slow while accessing those tables and which are heavy in size and requires a reorganization.

My system in on ORACLE 11g

SAP EHP 1 for SAP NetWeaver 7.0

Please suggest on the above.