Tracing in 10g for query with bind variables
On a performance test system, I'm planning to use instance wide tracing by
Code:
'alter system set events '10046 trace name context forever,level 12';
However, how can we execute a query with bind variables and trace it successfully?
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.
Code:
variable bind1 number;
begin
:bind1:=10;
end;
/
Do we have any other options apart from this?
Thanks In Advance.