How to Enable AutoTask
DBMS_AUTO_TASK_ADMIN.ENABLE To enable AUTOTASK back to work, we just revert the process of disabling AUTOTASK jobs. Let's see the steps. Check AutoTask Here we query… Read More »How to Enable AutoTask
Performance
How to Disable AutoTask
DBMS_AUTO_TASK_ADMIN.DISABLE In the previous post, we've talked about how to modify the starting time and duration of maintenance windows to make the scheduled AUTOTASK work… Read More »How to Disable AutoTask
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 Enable AUTOTRACE
Enable AUTOTRACE To get full AUTOTRACE feature in your session, you should take the following steps. You may need PLAN_TABLE table to be accessed in… Read More »How to Enable AUTOTRACE
How to Install PLUSTRACE Role
PLUSTRACE Before enabling AUTOTRACE feature in your session, you may not need to create PLAN_TABLE table, but you need PLUSTRACE role, which is not native… Read More »How to Install PLUSTRACE Role
PLAN_TABLE, How and Why
What is PLAN_TABLE ? PLAN_TABLE is place to hold some statistics data of explain plans of user's. In the old days, you need to create… Read More »PLAN_TABLE, How and Why
SYS_AUTO_SQL_TUNING_TASK Report
SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… Read More »SYS_AUTO_SQL_TUNING_TASK Report
How to Resolve ORA-20200: Database Instance does not exist
ORA-20200 When we ran a STATSPACK report, we got error ORA-20200. SQL> @?/rdbms/admin/spreport.sql ... ORA-20200: Database/Instance 356760607/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line… Read More »How to Resolve ORA-20200: Database Instance does not exist
Alter System Set PGA_AGGREGATE_LIMIT
Increase PGA_AGGREGATE_LIMIT Whenever you need more PGA to service clients or saw error ORA-04030, you may consider to raise PGA size online. Let's see current… Read More »Alter System Set PGA_AGGREGATE_LIMIT
How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
JDBC ORA-12850 Some developers report ORA-12850 error in their JDBC log. ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated There… Read More »How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated