Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$RULE_SET

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.

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