Re: VPD and rewritten queries

On Nov 27, 3:24 pm, "timo" <timo.ta..._at_luukku.com> wrote:
> Hi,
> VPD rewrites queries  - that's obvious - but I'd like to find out final sql
> executed for optimizing purposes.
> I should find sqls from all connected users with diffent roles and
> privileges - is there any simple way to get those after-VPD-add -sqls ?
> And if it's up to that "alter session set events '10730 trace name context
> forever, level 12', where's that trace file located when using sqlplus on
> client and does it include other users's sqls also ?
> Thanks,
> BR,
> Timo

10730 is IMO the easiest one. The trace file is generated on the server (obviously, because the server executes your SQL and writes the trace, not the client,) and it does not include SQL for other users, only for the particular session the event was set in.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri Nov 28 2008 - 10:11:35 CST