Oracle Storage Manager (Revision #5)

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 used in the allocated segments
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 database or database device
Index Schema: Database device type (Data, Log or Data & Log)
Table Name: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Table Schema: Total allocated space for the database/database device
Object Type: Unreserved space in the database/database device
Tablespace: Percentage of reserved space in the database
Buffer Pool: Space used in the database by data
Index Type: Space used in the database by indexes
Index Size: Space used in the database by indexes
Average Data Block / Key: Total available (unused) space in the database
Uniqueness: Space used in the database by log
Clusterting Factor:
Rows:
Sample Size(KB):
Last Analyzed: