Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$RULE_SET_AGGREGATE_STATS

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