Tag Archives: SQL Developer

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

SQL Developer Connection start up scripts !

Today we had observe very weird issue. Application team were facing an issue of auto data update causing all login to failed. On analysis application team found out , some master set up use to get deleted and all application … Continue reading

Rate this:

Posted in Oracle Internal | Tagged | Leave a comment