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.kglobt03, -- SQL_ID VARCHAR2(13) 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(4000) from x$kglcursor_child c, x$kzrtpd p where c.kglhdpar = p.kzrtpdpa and c.kglhdadr = p.kzrtpdad

home |  up  |  mailbox