6.49 DBA_TABLESPACES
DBA_TABLESPACES
describes all tablespaces in the database.
Related View
USER_TABLESPACES
describes the tablespaces accessible to the current user. This view does not display the PLUGGED_IN
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the tablespace |
|
|
|
Tablespace block size (in bytes) |
|
|
|
Default initial extent size (in bytes) |
|
|
|
Default incremental extent size (in bytes) |
|
|
|
Default minimum number of extents |
|
|
|
Default maximum number of extents |
|
|
|
Default maximum size of segments (in Oracle blocks) |
|
|
|
Default percent increase for extent size |
|
|
|
Minimum extent size for this tablespace (in bytes) |
|
|
|
Tablespace status:
|
|
|
|
Tablespace contents:
|
|
|
|
Default logging attribute:
|
|
|
|
Indicates whether the tablespace is under force logging mode ( |
|
|
|
Indicates whether the extents in the tablespace are dictionary managed ( |
|
|
|
Type of extent allocation in effect for the tablespace:
|
|
|
|
Indicates whether the tablespace is plugged in ( |
|
|
|
Indicates whether the free and used segment space in the tablespace is managed using free lists ( |
|
|
|
Indicates whether default table compression is enabled ( Note: Enabling default table compression indicates that all tables in the tablespace will be created with table compression enabled unless otherwise specified. |
|
|
|
Undo tablespace retention:
|
|
|
|
Indicates whether the tablespace is a bigfile tablespace ( |
|
|
|
Indicates whether predicates are evaluated by host ( |
|
|
|
Indicates whether the tablespace is encrypted ( |
|
|
|
Default compression for what kind of operations:
The |
|
|
|
Indicates whether the In-Memory Column Store (IM column store) is by default enabled ( |
|
|
|
Indicates the default priority for In-Memory Column Store (IM column store) population for this tablespace. Possible values:
|
|
|
|
Indicates how the IM column store is distributed by default for this tablespace in an Oracle Real Application Clusters (Oracle RACE) environment:
|
|
|
|
Indicates the default compression level for the IM column store for this tablespace:
|
|
|
|
Indicates the duplicate setting for the IM column store in an Oracle RAC environment:
|
|
|
|
Tablespace type:
|
|
|
|
Indicates whether default index compression is enabled ( Note: Enabling default index compression indicates that all indexes in the tablespace will be created with index compression enabled unless otherwise specified. |
|
|
|
Valid values are:
No other values are allowed. |
|
|
|
This specifies the default value for the This column is intended for use with Oracle Exadata. |
|
|
|
Indicates how the IM column store is populated on various instances by default for this tablespace. The possible values are:
|
|
|
|
Indicates the service name for the service on which the IM column store should be populated by default for this tablespace. This column has a value only when the corresponding |
|
|
|
The lost write protection setting for the tablespace. Possible values:
If lost write protection is enabled for a tablespace, it is enabled for all data files for that tablespace, including data files added later. If lost write protection is enabled for a single data file, it does not have to be enabled for another data file in the same tablespace. You can check the lost write protection status for a data file by querying the |
|
|
|
Indicates whether this is a chunk tablespace ( |
See Also: