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.