Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP REORG (ORACLE)

Hi,

How can i check in system (ERP2005) when needs to be done a table reorganization.

Thanks.

Regards

Former Member
Former Member replied

hi!

first off all you need to now the table usage. Please see notes 554031 & 821687 to gather table and indexes statistics.

If you run the statistics as it is documented in note 554031, indexes will be locked and you cannot update/insert into tables because of "validate structure".

If you want to now the table usage you can run the following command:

brconnect -u / -c -f stats -t all --f allsel,collect,method,space -p 15

this will collect the statistics only for tables and you can run it during the day.

After that you can see the brconnect log to know the tables and you can also check tables DBSTATTORA DBSTATIORA.

you can also see tables statistics via DB02 or DB02OLD (detail analysis).

Usually tables with a "Total free space %" value of 15%-20% could be reorganized, and with more that 20% should be reorganized.

Cheers,

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question