5 Replies Latest reply: Jul 17, 2014 11:47 PM by 1005473 RSS

    Need generated SQL Query after applying VPD clauses.




      I need generated SQL Query after applying the VPD clauses.

      I could check predicates in V$VPD_POLICY and by generating event 10730 trace information.


      Below is my base SQL

      SELECT * FROM <tab>

      WHERE col1 = 'XYZ'

      AND ROWNUM <= 20000;


      After executing this SQL , 2 policies are being applied.This infomation i can see in v_$vpd_policy.However  I wanted to see exact generated SQL after applying the VPD clause for performance investigation.


      Is there any way to get final generated SQL?


      -P. M.