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@xxxxxxxxxxx>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@xxxxxxxxxxx www.RuleGen.com (co)Author: "Applied Mathematics for Database Professionals"