Oracle教程 2023-02-24

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

_ACTIONS

Oracle 视图 DBA_HIST_RULE_SET_ACTIONS 是数据字典视图，显示当前和历史空间管理属性的变更。它以下列的列组成：

· RULE_OWNER：规则来源的拥有者。
· RULE_SET_ID：规则集 ID。
· ACTION_CLASS：行动类。
· ACTION_NAME：行动名称。
· ACTION_TYPE：行动类型。
· ACTION_VALUE：行动的值。
· VERSION：规则集版本。

使用此视图，可以查看一个规则集的历史变更记录。示例：

SELECT *
FROM dba_hist_rule_set_actions
WHERE rule_set_id = 12345
AND rule_owner = ‘TEST’;

DBA_HIST_RULE_SET displays historical information about rule set statistics.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule set
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the rule set
`STARTUP_TIME`	`DATE`	`NOT NULL`	Startup time of the instance
`CPU_TIME`	`NUMBER`		Total CPU time (in hundredths of a second) spent in evaluation of the rule set
`ELAPSED_TIME`	`NUMBER`		Total elapsed time (in hundredths of a second) spent in evaluation of the rule set
`EVALUATIONS`	`NUMBER`		Number of evaluations on the rule set
`SQL_FREE_EVALUATIONS`	`NUMBER`		Number of evaluations on the rule set which did not internally issue SQL to evaluate rules
`SQL_EXECUTIONS`	`NUMBER`		Total number of SQL statements executed during evaluation of the rule set
`RELOADS`	`NUMBER`		Number of times the rule set object was reloaded in shared memory
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：