Tracing in 10g for query with bind variables
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?
'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?
variable bind1 number;
Thanks In Advance.