SAP REORG (ORACLE)

[Former Member]

Hi,

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

Thanks.

Regards

[Former Member · Accepted solution]

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,

[Former Member]

Hi,

check Note 541538 - FAQ: Reorganizations

regards,

kaushal