Namespace TablespaceSummary

The allocated tablespace size in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The type of extent allocation in effect for the tablespace.

The tablespace block size. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The operation type for which default compression is enabled.

A list of the data files associated with the tablespace.

This specifies the default value for the CELLMEMORY attribute that tables created in the tablespace will inherit unless the behavior is overridden explicitly. This column is intended for use with Oracle Exadata.

Indicates whether the In-Memory Column Store (IM column store) is by default enabled or disabled for tables in the tablespace.

Indicates the default compression level for the IM column store for the tablespace.

Indicates how the IM column store is distributed by default for the tablespace in an Oracle Real Application Clusters (Oracle RAC) environment.

Indicates the duplicate setting for the IM column store in an Oracle RAC environment.

Indicates the default priority for In-Memory Column Store (IM column store) population for the tablespace.

Indicates how the IM column store is populated on various instances by default for the tablespace.

Indicates the service name for the service on which the IM column store should be populated by default for the tablespace. This column has a value only when the corresponding DEF_INMEMORY_SERVICE is USER_DEFINED. In all other cases, this column is null.

Indicates whether default index compression is enabled or disabled.

Indicates whether default table compression is enabled or disabled.

Indicates whether the extents in the tablespace are Locally managed or Dictionary managed.

The free space available in the tablespace in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The operation type for which default index compression is enabled.

Indicates whether the tablespace is a Bigfile tablespace or a Smallfile tablespace.

Indicates whether this is a chunk tablespace.

Indicates whether this is the default tablespace.

Indicates whether the tablespace is encrypted.

Indicates whether the tablespace is under Force Logging mode.

Indicates whether the tablespace is plugged in.

The default logging attribute.

The lost write protection setting for the tablespace.

The maximum tablespace size in KB. If the tablespace contains any data files with Autoextend enabled, then this column displays the amount of underlying free storage space for the tablespace. For example, if the current tablespace size is 1 GB, the combined maximum size of all its data files is 32 GB, and its underlying storage (for example, ASM or file system storage) has 20 GB of free space, then this column will have a value of approximately 20 GB. If the tablespace contains only data files with autoextend disabled, then this column displays the allocated space for the entire tablespace, that is, the combined size of all data files in the tablespace. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The name of the tablespace.

Indicates whether predicates are evaluated by Host or by Storage.

Indicates whether undo retention guarantee is enabled for the tablespace.

Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO).

Indicates whether the tablespace is for shared tablespace, or for local temporary tablespace for leaf (read-only) instances, or for local temporary tablespace for all instance types.

The status of the tablespace.

The temporary tablespace group.

The type of tablespace.

The percentage of used space out of the total allocated space in the tablespace. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The percentage of used space out of the maximum available space in the tablespace. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The total space used by the tablespace in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

The size of the tablespace available for user data in KB. The difference between tablespace size and user data size is used for storing metadata. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.