dbms_xplan.display_cursor

Never too late today i thought to learn and know about  using the packaged function DBMS_XPLAN.DISPLAY_CURSOR (as i was trying to tune the query :)). The DBMS_XPLAN package had 4 table fuctions : 1. DISPLAY :- formats and displays the contents of the plan table, 2. DISPLAY_CURSOR :- formats and displays the contents of the … Continue reading dbms_xplan.display_cursor