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, and the physical address and size of the extent.


Copyright© 2019 HCL Technologies Limited