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

本站中文解释

Oracle 视图 V$RULE_SET 表示 Oracle 数据库实例中定义的所有规则集（Rulesets）的一个总结。用户可以查看每个规则集的属性，以及规则集所对应的数据库对象，以及规则集所包含的规则。

V$RULE_SET 视图中的用户可以查询的信息包括：规则集的核心属性（是否可用，执行深度，上次更新时间等）以及规则集支持的数据库对象和规则。

使用 Oracle 视图 V$RULE_SET 要点：

1. 在查询视图时，记得必须对视图许可权进行连接，以获得查询结果。

2. 查看某个特定的规则集的所有属性，只需将规则集的名称放入 WHERE 子句中，即可查询出该规则集的信息，例如：

SELECT * FROM V$RULE_SET WHERE RULESET_NAME = MyRuleSet

3. 查看某个特定规则集所支持的数据库对象，只需将规则集的名称和对象名称放入 V$RULE_SET_OBJECT 表中，即可查询出该规则集所支持的对象，例如：

SELECT OBJECT_NAME FROM V$RULE_SET_OBJECT WHERE RULESET_NAME = MyRuleSet

4. 查看某个特定规则集所包含的规则，只需将规则集的名称和规则名称放入 V$RULE_SET_RULE 表中，即可查询出该规则集包含的规则，例如：

SELECT RULE_NAME FROM V$RULE_SET_RULE WHERE RULESET_NAME = MyRuleSet

官方英文解释

V$RULE_SET displays rule set statistics. This view has a row for every rule set loaded into shared memory.

Note:

Querying the V$RULE_SET view may have a negative impact on performance if a database has a large library cache.

Total elapsed time (in hundredths of a second) spent in evaluation of the rule set

Total elapsed time (in hundredths of a second) spent to load the rule set the last time it was loaded

Number of evaluations on the rule set which did not internally issue SQL to evaluate rules

Total number of fast (indexed) conditions processed during evaluation of the rule set

Total number of calls made to user-defined functions to retrieve variable values (specified by the variable_value_function field in RE$VARIABLE_TYPE) made during evaluation of the rule set

Total number of calls made to user-defined functions to retrieve variable method values (specified by the variable_method_function field in RE$VARIABLE_TYPE) made during evaluation of the rule set

Total number of calls made to user-defined evaluation functions (specified as the evaluation_function argument to the DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT procedure) made during evaluation of the rule set

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.

Oracle Database PL/SQL
Packages and Types Reference for more information about the DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT procedure

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$RULE_SET 官方解释，作用，如何使用详细说明