SQL Tuning

How to Resolve ORA-13780: SQL statement does not exist

by Ed Chen
February 7, 2023February 8, 2023

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 Run DBMS_SQLTUNE for Specific SQL

by Ed Chen
January 13, 2018February 7, 2023
4 Comments

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 Resolve ORA-27492: unable to run job: scheduler unavailable

by Ed Chen
January 7, 2018October 30, 2021
8 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.