System Wide - Tables

 

Use these reports to view the following information about the monitored tables within your environment. Some of the following fields are not available for all DBMSs:

Field Name

Description

Creator

ID of the creator of a table

Table

name of a table

Computer

name of the computer on which a table resides

RDBMS Instance

Instance on which a table resides

RDBMS Type

RDBMS to which a table belongs (e.g., Oracle, Sybase, SQL Server, etc.)

Database

name of the database on which a table resides

Tablespace

name of the tablespace on which the table resides

Database-Tablespace

name of the tablespace or database on which a table resides

Table Type

type of a table (e.g., table, cluster, partition, etc.)

Total Size

amount of storage allocated to a table

Empty Used Space

amount space that is allocated to a table but is not currently being used

Index Size

amount of space consumed by the index(es) associated with a table

Freelist Blocks

number of blocks in the freelist chain of a table

Number Partitions

number of partitions in a table

Number Indexes

number of indexes associated with a table

Number Segments

number of segments associated with a table

Number Extents

number of extents associated with a table

Percent Free

percentage of free space available in a table

Percent Used

percentage of used space in a table

Initial Transactions

initial number of transactions

Maximum Transactions

maximum number of transactions

Initial Extent

size of the first extent allocated to the table

Next Extent

amount of space the RDBMS will retrieve when allocating another extent

Minimum Extents

minimum number of extents that can be allocated to the table

Maximum Extents

maximum number of extents that can be allocated to the table

Percent Increase

percentage increase in extent size

Analyze Time

date/time when a table was last analyzed

Number Analyzed

number of rows analyzed in a table

User Stats

indicates whether stats were set by a user or gathered by Analyze

Average Row Length

average length of the rows in the table

Row Count

number of rows in a table

Chained Row Count

number of chained rows in a table

Average Free Space

average of how much free space is available to the blocks in a table

Average Freelist Space

average of how much free space is available to the blocks on the freelist chain in a table

Discovered Time

date/time when a table was discovered

Dropped Time

date/time when a table was dropped