V$RULE definition in Oracle Database 11.2
V$RULE

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')

home |  up