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
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
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
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
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 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
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