Tablespace Usage

Tablespace usage

Columns

Name Description
Name Tablespace name
Status Tablespace status (ONLINE, OFFLINE, READ ONLY)
Contents Tablespace contents (UNDO, PERMANENT, TEMPORARY)
Log Default logging attribute for objects in the tablespace
Extent Mgmt Extent management type (DICTIONARY, LOCAL)
% Utilized % of total allocated size that is used
% Utilized of Autoextend % of total autoextend size that is used
AutoExt Whether the tablespace files are autoextensible
Total Blocks Total allocated size of the tablespace, in blocks
Total MBytes Total allocated size of the tablespace, in megabytes
Free Blocks Unused space, in blocks
Free MBytes Unused space, in megabytes
Free Segs Number of free space segments (which are each continuous)
Max Free Seg Blocks Largest continuous free space segment, in blocks
Max Free Seg MBytes Largest continuous free space segment, in megabytes

Entity Requirements

Attributes: None
Minimum database version: 8.1

Sample