dbms_xplan(3)

Some time ago, I wrote a note about using the packaged function dbms_xplan.display_cursor(). 

I’ve just seen a note on Rob van Wijk’s blog where he investigates many more parameter values that can be used with the function.