DBA_TABLESPACE_THRESHOLDS

6.47 DBA_TABLESPACE_THRESHOLDS

DBA_TABLESPACE_THRESHOLDS describes space utilization threshold settings for all tablespaces in the database.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Tablespace name
`CONTENTS`	`VARCHAR2(9)`	Tablespace contents: `UNDO` `PERMANENT` `TEMPORARY`
`EXTENT_MANAGEMENT`	`VARCHAR2(10)`	Indicates whether the extents in the tablespace are dictionary managed (`DICTIONARY`) or locally managed (`LOCAL`)
`THRESHOLD_TYPE`	`VARCHAR2(8)`	Indicates whether the threshold value is derived from a `DEFAULT` threshold or an `EXPLICIT` threshold
`METRICS_NAME`	`VARCHAR2(64)`	Name of the metric for which the threshold is set
`WARNING_OPERATOR`	`VARCHAR2(12)`	Relational operator for warning thresholds: `GT` `EQ` `LT` `LE` `GE` `CONTAINS` `NE` `DO_NOT_CHECK`
`WARNING_VALUE`	`VARCHAR2(256)`	Warning threshold value
`CRITICAL_OPERATOR`	`VARCHAR2(12)`	Relational operator for critical thresholds: `GT` `EQ` `LT` `LE` `GE` `CONTAINS` `NE` `DO_NOT_CHECK`
`CRITICAL_VALUE`	`VARCHAR2(256)`	Critical threshold value