SQL Developer Explain Planby Ed ChenJuly 4, 2023July 7, 2023For 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
How to Resolve ORA-13780: SQL statement does not existby Ed ChenFebruary 7, 2023February 8, 2023ORA-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 SQLby Ed ChenJanuary 13, 2018February 7, 20234 CommentsSQL 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 unavailableby Ed ChenJanuary 7, 2018October 30, 20218 CommentsORA-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