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

    Need generated SQL Query after applying VPD clauses.

    1005473

      Hi,

       

      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.