V$RULE_SET

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

Column

Datatype

Description

OWNER

VARCHAR2(64)

Owner of the rule set

NAME

VARCHAR2(1000)

Name of the rule set

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

FIRST_LOAD_TIME

DATE

First time the current cached copy of the rule set was loaded

LAST_LOAD_TIME

DATE

Last time the current cached copy of the rule set was loaded

LAST_LOADING_TIME

NUMBER

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

SHARABLE_MEM

NUMBER

Shared memory (in bytes) used by the rule set

RELOADS

NUMBER

Number of times the rule set object was reloaded in shared memory

INVALIDATIONS

NUMBER

Number of times the rule set object was invalidated

EVALUATIONS

NUMBER

Number of evaluations on the rule set

FIRST_HIT_EVALUATIONS

NUMBER

Number of evaluations on the rule set, with stop_on_first_hit set to TRUE

SIMPLE_RULES_ONLY_EVALUATIONS

NUMBER

Number of evaluations on the rule set, with simple_rules_only set to TRUE

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

CONDITIONS_PROCESSED

NUMBER

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

TRUE_RULES

NUMBER

Total number of TRUE rules returned during evaluation of the rule set

MAYBE_RULES

NUMBER

Total number of MAYBE rules returned during evaluation of the rule set

VARIABLE_VALUE_FUNCTION_CALLS

NUMBER

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

VARIABLE_METHOD_FUNCTION_CALLS

NUMBER

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

EVALUATION_FUNCTION_CALLS

NUMBER

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