Oracle Storage Manager (Revision #7)

Object Tab - Display of the Tables and Indexes.

Type = Table

Object Name: Name of the database object
Owner: Owner of the Table
Object Type: Type of the database object
Tablespace: Tablespace name to which the table belongs to
Bufferpool: Name of bufferpool
Partitioned: Specify whether the Table is partitoned or not
Table Size: Total Size occupied by the table. Calculated by NUM_ROWS * AVG_ROW_LEN
Allocated Segment Size: Space allocated for the table in the extents. Calculated by INITIAL_EXTENT + (EXTENTS-1) * NEXT_EXTENT
Segment Size: Total size of the extent occupied by the table. Calculated by SUM(BYTES)
Row Count: Total number of rows in the table
Index Size: Space used by Indexes in that table.

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Name of the database object
Table Schema: Owner of the Table
Object Type: Whether Sytem or User Index
Tablespace: Tablespace name to which the Index belongs to
Buffer Pool:Bufferpool name to which the Index belongs to
Index Type: Type of the index
Index Size: Size of the Index
Average Data Block / Key: Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer
Uniqueness: Whether the index is UNIQUE or NONUNIQUE
Clusterting Factor: Indicates the amount of order of the rows in the table based on the values of the index
Rows: Number of rows in the index
Sample Size(KB): Size of the sample used to analyze the index
Last Analyzed: Date on which this index was most recently analyzed