you can do it on sqlplus...
Code:
alter system set events '10046 trace name context forever,level 12';
variable bind1 number;
exec :bind1 := 10;
your-query
alter session set events '10046 trace name context off';