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 |