Re: Q: VPD - how we can see full sql after the policy
From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Thu, 19 Feb 2009 11:56:53 +0200
Message-ID: <OF010EDCF2.2CC5E421-ONC2257562.00368133-C2257562.0036A5F6_at_seb.lt>
v$plan may show it
Date: Thu, 19 Feb 2009 11:56:53 +0200
Message-ID: <OF010EDCF2.2CC5E421-ONC2257562.00368133-C2257562.0036A5F6_at_seb.lt>
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
Hi all,
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 ?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 19 2009 - 03:56:53 CST