Search notes:

Oracle: V$VPD_POLICY

select
   pol.object_owner,
   pol.object_name,
   pol.policy,
   pol.policy_group,
   pom.pf_owner,
   pom.package,
   pom.function,
   sql.last_active_time last_act_sql,
   sql.sql_text,
   pol.predicate,
   pol.policy_function_owner
from
   v$vpd_policy pol                                                     left join
   v$sqlarea    sql on pol.sql_id       = sql.sql_id                    left join
   dba_policies pom on pol.policy       = pom.policy_name    and
                       pol.policy_group = pom.policy_group   and
                       pol.object_owner = pom.object_owner   and
                       pol.object_name  = pom.object_name
where
   pol.object_name like 'TQ84%'
;

See also

Virtual Private Database

Index