This content has been marked as final. Show 2 replies
It sounds like you want to look at v$vpd_policy. The PREDICATE column will show you each predicate that has been applied by VPD to a particular SQL_ID and the POLICY column will tell you which policy applied that predicate.
Hi Sunil Jena,
you can also use event 10730:
alter session set events '10730 trace name context forever, level 1';
make sure the statement is reparsed and a trace file will be generated showing details
of the VPD policy including the full statement with your predicate added,