Friday, August 26, 2016

How can we see the Bind variable values when they are not in Timestamp and display the cursor plan

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);