Monitoring Tblspaces and Extents

Monitor tblspaces and extents to determine disk usage by database, table, or table fragment. Monitoring disk usage by table is particularly important when you are using table fragmentation, and you want to ensure that table data and table index data are distributed appropriately over the fragments.

Execute oncheck -pt to obtain extent information. The oncheck -pT option returns all the information from the oncheck -pt option as well as the additional information about page and index usage.

Using SMI Tables

Query the systabnames table to obtain information about each tblspace. The systabnames table has columns that indicate the corresponding table, database, and table owner for each tblspace.

Query the sysextents table to obtain information about each extent. The sysextents table has columns that indicate the database and the table that the extent belongs to, as well as the physical address and size of the extent.