GV$RULE_SET
select INST_ID, -- INST_ID NUMBER OWNER, -- OWNER VARCHAR2(30) NAME, -- NAME VARCHAR2(30) CPU_TIME, -- CPU_TIME NUMBER ELAPSED_TIME, -- ELAPSED_TIME NUMBER FIRST_LOAD_TIME, -- FIRST_LOAD_TIME DATE LAST_LOAD_TIME, -- LAST_LOAD_TIME DATE LAST_LOADING_TIME, -- LAST_LOADING_TIME NUMBER SHARABLE_MEM, -- SHARABLE_MEM NUMBER RELOADS, -- RELOADS NUMBER INVALIDATIONS, -- INVALIDATIONS NUMBER EVALUATIONS, -- EVALUATIONS NUMBER FIRST_HIT_EVALUATIONS, -- FIRST_HIT_EVALUATIONS NUMBER SIMPLE_RULES_ONLY_EVALUATIONS, -- SIMPLE_RULES_ONLY_EVALUATIONS NUMBER SQL_FREE_EVALUATIONS, -- SQL_FREE_EVALUATIONS NUMBER SQL_EXECUTIONS, -- SQL_EXECUTIONS NUMBER CONDITIONS_PROCESSED, -- CONDITIONS_PROCESSED NUMBER TRUE_RULES, -- TRUE_RULES NUMBER MAYBE_RULES, -- MAYBE_RULES NUMBER VARIABLE_VALUE_FUNCTION_CALLS, -- VARIABLE_VALUE_FUNCTION_CALLS NUMBER VARIABLE_METHOD_FUNCTION_CALLS, -- VARIABLE_METHOD_FUNCTION_CALLS NUMBER EVALUATION_FUNCTION_CALLS -- EVALUATION_FUNCTION_CALLS NUMBER from x$rule_set

home |  up  |  mailbox