On a performance test system, I'm planning to use instance wide tracing by
However, how can we execute a query with bind variables and trace it successfully?Code:'alter system set events '10046 trace name context forever,level 12';
I assume that it can be done only after declaring the bind variables in a PL/SQL block; and then executing the query with tracing enabled.
Do we have any other options apart from this?Code:variable bind1 number; begin :bind1:=10; end; /
Thanks In Advance.