Re: Q: VPD - how we can see full sql after the policy

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Thu, 19 Feb 2009 10:20:02 +0100
Message-ID: <ecf3dae70902190120v49fa7434xe26558c48a8c9d5e_at_mail.gmail.com>

Standard sql trace will not show what VPD added to your SQL queries. You would need to set event 10730 to get a trace file showing what VPD added.

On Thu, Feb 19, 2009 at 10:12 AM, Amihay Gonen <Amihay.Gonen_at_ecitele.com>wrote:

> 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 ?
>
>
>

-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com

(co)Author: "Applied Mathematics for Database Professionals"

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 19 2009 - 03:20:02 CST