Skip to Content
avatar image
Former Member

SAP REORG (ORACLE)

Hi,

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

Thanks.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 08, 2008 at 01:42 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2008 at 12:35 PM

    Hi,

    check Note 541538 - FAQ: Reorganizations

    regards,

    kaushal

    Add comment
    10|10000 characters needed characters exceeded