We can see the bind variable values with the below query.
select * from table(dbms_xplan.display_cursor('4b5c6cp4gkup6',null,'+peeked_binds'));
How to display the cursor plan:
Run the cursor and execute the below sql:
select * from table(dbms_xplan.display_cursor);
select * from table(dbms_xplan.display_cursor('4b5c6cp4gkup6',null,'+peeked_binds'));
How to display the cursor plan:
Run the cursor and execute the below sql:
select * from table(dbms_xplan.display_cursor);