Use this report to view the largest tables in your environment sorted by the tablespace groups to which they belong.
Field Name |
Description |
|
click this button to view detailed information about a table |
Total Size |
total amount of space allocated to a table |
Group Creator |
ID of the user who created the tablespace group to which a table belongs |
Group Name |
name of the tablespace group to which a table belongs |
Computer |
name of the computer on which a table resides |
RDBMS Instance |
Instance on which a table resides |
Database |
name of the database on which a table resides |
Tablespace |
name of the tablespace on which a table resides |
Creator |
ID of the user who created the table |
Table |
name of a table |
Empty Used Space |
amount of allocated space that is currently empty/not being used |
Index Size |
size of the index associated with a table |
Row Count |
number of rows within a table |
Overflow Row Count |
number of overflow rows within a table. The total number of overflow rows in the table should be less than 5 percent of the total number of rows. Overflow rows can be created when rows are updated and the new rows contain more bytes than the old ones (VARCHAR fields), or when columns are added to existing tables. |
Used Space Percent |
percentage of space allocated to the table is being used. If this number becomes too low (because of too much freespace), we recommend you do a reorg on the table because there is too much freespace in the table. |
Used Page Percent |
percentage of a table's pages that contain data. If this percentage is less than 100, then a table contains some totally empty pages. |
CLUSTER Percent |
percentage that indicates how closely the physical ordering of rows in a table matches its associated clustering index |