Tracing in 10g for query with bind variables

[hrishy]

Hi

Yes you need to set the bind variables.

You can also use dbms_xplan in 10gr2 to get the values of the bind variables

dbms_xplan.display_cursor(null,null,'basic +PEEKED_BINDS'));

something like

SELECT plan_table_output
FROM v$sql s,
table(dbms_xplan.display_cursor(s.sql_id,
s.child_number, 'basic+PEEKED_BINDS')) t
WHERE s.sql_text like 'select  statement%';