GV$RULE
select
INST_ID,                 -- INST_ID NUMBER
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
x$rule 

home |  up  |  mailbox