Checking for tablespace reorg

[Former Member]

Please tell me how to check whether we need to do tablespace reorg or not.

[Former Member]

Hi,

In which column will I check if the table will perform the reorganiztion. is it in Size column or in the Extent column? and what will be the threshold of it?

[Former Member]

Can you advice me on how will I see the most used tables? What will be the priority to check, is that number of extent or etc?

[Former Member]

Hi,

in DB02 -> space statistics ->

you can get following from Space statistics:

Table statistics history : Shows size and fragmentation of the tables.

Top n largest tables: Shows data of the 25 largest tables in the system.

Top n modified tables: Shows data of the most frequently changed tables.

Top n growing tables : Shows data of the fastest growing tables.

regards,

kaushal

[Former Member]

Is there any way to know if the tablespace, table or index are going to reorganize? May I know the standard value for this. How will I know if those item will be reorganize or not?

[Former Member]

Hi,

you need to find out large or rapidly growing tables or indexes in your sap system using DB02.

check http://help.sap.com/saphelp_nw2004s/helpdata/en/f2/31add7810c11d288ec0000e8200722/content.htm

regards,

kaushal

[Former Member]

Hi,

check Note 541538 - FAQ: Reorganizations

regards,

kaushal