select
RULE_SET_OBJECT_ID, -- RULE_SET_OBJECT_ID NUMBER
EVALUATION_CONTEXT_OBJECT_ID, -- EVALUATION_CONTEXT_OBJECT_ID NUMBER
RULE_OWNER, -- RULE_OWNER VARCHAR2(30)
RULE_NAME, -- RULE_NAME VARCHAR2(30)
RULE_CONDITION, -- RULE_CONDITION VARCHAR2(200)
TRUE_HITS, -- TRUE_HITS NUMBER
MAYBE_HITS, -- MAYBE_HITS NUMBER
SQL_EVALUATIONS -- SQL_EVALUATIONS NUMBER
from
GV$RULE
where
inst_id = USERENV('Instance')