GV$RULE
select
inst_id,                 -- INST_ID NUMBER
kqrfpt07,                -- RULE_SET_OBJECT_ID NUMBER
kqrfpt08,                -- EVALUATION_CONTEXT_OBJECT_ID NUMBER
kqrfpts0,                -- RULE_OWNER VARCHAR2(64)
kqrfpts1,                -- RULE_NAME VARCHAR2(64)
kqrfpts2,                -- RULE_CONDITION VARCHAR2(64)
kqrfpt09,                -- TRUE_HITS NUMBER
kqrfpt10,                -- MAYBE_HITS NUMBER
kqrfpt11                 -- SQL_EVALUATIONS NUMBER
from
x$kqrfp 
where
kqrfpcid=22 

home |  up  |  mailbox