I have implemented vpd.
But I want to see what query Oracle is generating in back end while I am applying a simple select statement on the table.
I have searched in V$SQL, V$SQLAREA, it is not there.
So where I have to see?
Edited by: 990324 on Feb 27, 2013 6:06 AM
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,