Use these reports to view detailed information about the tables monitored by Scan jobs. A table will appear in this report if:
1. It is included in the definition of a table group
2. The table group in which it is included is defined as part of a Scan job
Field Name |
Description |
|
click this button to view a graphical chart that illustrates the used and free space on a table |
|
click this button to view detailed information about a table |
Creator |
ID of the user who created the table |
Table |
name of a table |
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 |
Table Type |
|
Total Size |
total amount of space allocated to 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 |
Discovered Time |
date/time when a table was discovered |
Dropped Time |
date/time when a table was dropped |