Oracle Database – SQL trace & capturing the value of bind variables
The value of the bind variable has a direct impact on the selectivity of your SQL predicates. Often it is useful to capture the value of the bind variables to investigate the SQL performance issues.