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