Oracle教程 2023-02-24

Oracle 视图 DBA_THRESHOLDS 官方解释，作用，如何使用详细说明

DBA_THRESHOLDS视图显示当前数据库中有效的资源使用阈值。Oracle数据库根据被监控的事件具有可配置的资源使用阈值，称为“资源使用阈值”，可以在任何断临界值或危险量临界值之前执行一些操作，以尽早检测出潜在故障。

使用这个视图时，用户可以检查正在使用的阈值。可以使用它来检查数据库正在使用的阈值以及它们是如何改变的。可以使用这个视图来确定数据库如何有效地监视资源使用量。

DBA_THRESHOLDS describes all thresholds.

Column	Datatype	Description
`METRICS_NAME`	`VARCHAR2(64)`	Metrics name
`WARNING_OPERATOR`	`VARCHAR2(12)`	Relational operator for warning thresholds: `GT` `EQ` `LT` `LE` `GE` `CONTAINS` `NE` `DO NOT CHECK` `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` `DO_NOT_CHECK`
`CRITICAL_VALUE`	`VARCHAR2(256)`	Critical threshold value
`OBSERVATION_PERIOD`	`NUMBER`	Observation period length (in minutes)
`CONSECUTIVE_OCCURRENCES`	`NUMBER`	Number of occurrences before an alert is issued
`INSTANCE_NAME`	`VARCHAR2(16)`	Instance name; NULL for database-wide alerts
`OBJECT_TYPE`	`VARCHAR2(64)`	Object type: `SYSTEM` `SERVICE` `EVENT_CLASS` `TABLESPACE` `FILE`
`OBJECT_NAME`	`VARCHAR2(513)`	Name of the object for which the threshold is set
`STATUS`	`VARCHAR2(7)`	Indicates whether the threshold is applicable on a valid object (`VALID`) or not (`INVALID`) Thresholds for non-tablespace metrics can only be set in `ROOT` and apply to a CDB as a whole. Any pre-existing non-tablespace thresholds that may exist in a PDB have a status of `INVALID` in the `DBA_THRESHOLDS` view. You can remove these threshold settings using the `DBMS_SERVER_ALERT.SET_THRESHOLD` API. See Oracle Database PL/SQL Packages and Types Reference for more information about the `DBMS_SERVER_ALERT.SET_THRESHOLD` API.

分享到：