SQL Developer Explain Plan
For those who don't have GUI tools like SQL developer or Enterprise Manager, you can still get an explain plan for a statement in SQL*Plus.… Read More »SQL Developer Explain Plan
SQL Tuning
How to Resolve ORA-13780: SQL statement does not exist
ORA-13780 Tried to create a SQL tuning task for specific SQL ID, but it failed with ORA-13780. SQL> select DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => '21zq47mj49f7w', scope… Read More »How to Resolve ORA-13780: SQL statement does not exist
How to Run DBMS_SQLTUNE for Specific SQL
SQL Tuning Advisor I know there could be more convenient to run SQL tuning reports by DBMS_SQLTUNE in tools like Enterprise Manager or TOAD. But… Read More »How to Run DBMS_SQLTUNE for Specific SQL
How to Resolve ORA-27492: unable to run job: scheduler unavailable
ORA-27492 Found error ORA-27492 when executed a tuning job. BEGIN SYS.DBMS_SCHEDULER.RUN_JOB (job_name => 'SYS.SQLTUNE_JOB_61535_2043' ,use_current_session … Read More »How to Resolve ORA-27492: unable to run job: scheduler unavailable