Tag Archives: code editor

SQL Developer : Add Custom SQL Query as Template.

Daily for SQL plan reading and analysis, using below command quite often from SQL Developer Tool. explain plan for statement_id = ”; select * from gv$sql where sql_text like ‘%%’; select * from table(dbmx_xplan.display); select * from table(dbmx_xplan.display_cursor(”,null,’ALLSTATS_LAST’)); Wouldn’t it … Continue reading

Rate this:

Posted in Helper SQL | Tagged , , | Leave a comment