GV$VPD_POLICY
select c.inst_id, -- INST_ID NUMBER c.kglhdadr, -- ADDRESS RAW(4) c.kglhdpar, -- PARADDR RAW(4) c.kglnahsh, -- SQL_HASH NUMBER c.kglobt09, -- CHILD_NUMBER NUMBER p.kzrtpdow, -- OBJECT_OWNER VARCHAR2(30) p.kzrtpdon, -- OBJECT_NAME VARCHAR2(30) p.kzrtpdgp, -- POLICY_GROUP VARCHAR2(30) p.kzrtpdpy, -- POLICY VARCHAR2(30) p.kzrtpdpo, -- POLICY_FUNCTION_OWNER VARCHAR2(30) p.kzrtpdtx -- PREDICATE VARCHAR2(4096) from x$kglcursor c, x$kzrtpd p where c.kglhdadr != c.kglhdpar and c.kglobt02 != 0 and c.kglhdpar=p.kzrtpdpa and c.kglhdadr = p.kzrtpdad

home |  up  |  mailbox