Asset Reporting - Monitored Tables

 

Use this report to view information about the tables within your environment. Some of the following fields are not available for all RDBMSs:

Field Name

Description

Computer

name of the computer on which a table resides

Instance

name of the Instance to which a table belongs

Database

name of the database to which a table belongs

Tablespace

name of the tablespace to which a table belongs

Creator

ID of the table creator

Table

name of a table

Total Size

total size of storage allocated to a database but is not currently being used

Empty Used Space

total size of storage allocated to a table but is not currently being used

Index Size

size of the index associated with a table

Freelist Blocks

number of blocks in the freelist chain of a table

Number of Partitions

number of partitions in a table

Number of Indexes

number of indexes associated with a table

Number of Segments

number of segments associated with a table

Number of Extents

number of extents associated with a table

Percent Free Space

percentage of free space available in a table

Percent Used Space

percentage of used space in a table

Initial Transactions

initial number of transactions

Maximum Transactions

maximum number of transactions

Initial Extent Size

size of the first extent allocated to the table

Next Extent Size

amount of space Oracle 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 for Extent Size

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 row 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