Oracle教程

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

本站中文解释

视图

Oracle视图V$RULE_SET_AGGREGATE_STATS存储的信息与用户规则集的总体统计信息有关。此视图可用于收集有关用户规则集的统计信息，包括有关现有规则集的元数据和计数统计信息。

使用此视图可以轻松跟踪用户规则集的重要统计信息，包括规则触发次数、触发用例的数量等。 例如，可以查看特定视图的每个规则触发的次数，以及每个视图的总触发次数。另外，可以深入探索视图的不同层次，以获取更准确的统计信息。

要使用此视图，请先连接到Oracle数据库，然后查询下面的语句：
SELECT RULE_SET_NAME，RULE_NAME，NUM_TIMES_EVALUATED，NUM_CASES_EVALUATED从V $ RULE_SET_AGGREGATE_STATS;

上面的查询将返回用户规则集的总体统计信息，包括有关规则集名称，规则名称，评估次数和评价案例数量的信息。这些统计信息可帮助DBA更好地了解规则集的性能并精确控制其资源使用率。

官方英文解释

V$RULE_SET_AGGREGATE_STATS displays statistics aggregated over all evaluations on all rule sets. This view has a row for each type of statistic.

Column Datatype Description

NAME

VARCHAR2(80)

Name of the statistic:

  • rule set evaluations (all) – Total number of evaluations on all rule sets

  • rule set evaluations (first_hit) – Total number of evaluations on rule sets with stop_on_first_hit set to TRUE

  • rule set evaluations (simple_rules_only) – Total number of evaluations on rule sets with simple_rules_only set to TRUE

  • rule set evaluations (SQL free) – Total number of evaluations on rule sets which did not internally issue SQL to evaluate rules

  • rule set evaluation time (CPU) – Total CPU time (in hundredths of a second) spent in evaluations on rule sets

  • rule set evaluation time (elapsed) – Total elapsed time (in hundredths of a second) spent in evaluations on rule sets

  • rule set SQL executions – Total number of SQL statements executed during evaluations on rule sets

  • rule set conditions processed – Total number of fast (indexed) conditions processed during evaluations on rule sets

  • rule set true rules – Total number of TRUE rules returned during evaluations on rule sets

  • rule set maybe rules – Total number of MAYBE rules returned during evaluations on rule sets

  • rule set user function calls (variable value function) – 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 evaluations on rule sets

  • rule set user function calls (variable method function) – 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 evaluations on rule sets

  • rule set user function calls (evaluation function) – 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 evaluations on rule sets

VALUE

NUMBER

Statistic value

CON_ID

NUMBER

The ID of the container to which the data pertains. The CON_ID value in this view is always 0. The rows pertain to the entire CDB or to the non-CDB.

See Also:

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


数据运维技术 » Oracle 视图 V$RULE_SET_AGGREGATE_STATS 官方解释，作用，如何使用详细说明
分享到：

相关推荐