Checking Statistics for a Reorganization 

Use

Before you reorganize the Oracle database with SAPDBA, we recommend that you check the database statistics for the objects you intend to reorganize. This helps you to decide if a reorganization is necessary.

• Monitoring Table and Index Fragmentation (Oracle)
• Checking Storage Parameters (Oracle)

• SAPDBA command line option sapdba -check

• SAPDBA command line option sapdba -analyze

• Checking Extents and Fragmentation with SAPDBA

• Check Tablespaces with SAPDBA for information on data files, especially:

• Checking Freespace for Tablespaces
• Extending a Tablespace
• Displaying File and Raw Device Information for a Tablespace

• Refer to Reorganization of Special Tablespaces for information on particular tablespaces.