Re: Q: VPD - how we can see full sql after the policy
Date: Thu, 19 Feb 2009 11:56:53 +0200
v$plan may show it
V$VPD_POLICY does show it.
Amihay Gonen <Amihay.Gonen_at_eci tele.com> To Sent by: "oracle-l_at_freelists.org" oracle-l-bounce_at_f <oracle-l_at_freelists.org> reelists.org cc Tali Poliak <tali.poliak_at_oracle.com> 2009.02.19 11:12 Subject Q: VPD - how we can see full sql after the policy Please respond to Amihay.Gonen_at_ecit ele.com
One of our developers , ask me if there is someone to see the changed sql
after VPD policy.
She need that for debug propose. I guess using sql-trace can be an option , but this can be difficult since we’ve connection pooling + shared server.
Any idea ?Received on Thu Feb 19 2009 - 03:56:53 CST