Execution plans and bind peeking...

If you haven't seen this optimizermagic.blogspot.com post already, check it out.

It covers the standard Execution Plan stuff, but also covers use of the dbms_xplan package including using dbms_xplan.display to format output and using dbms_xplan.display_cursor to see Bind Variables used to generate a plan!

Click here for Article

-- Dave