Largest Tables - By Database

 

Use this report to view the largest tables in your environment sorted by the databases on which they reside.

Field Name

Description

click this button to view detailed information about a table

Total Size

total amount of space allocated to a table

Database

name of the database on which a table resides

Computer

name of the computer on which a table resides

RDBMS Instance

Instance 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