Enable AUTOTRACE To get full AUTOTRACE feature in your session, you should take the following steps. Need PLAN_TABLE table to be accessed in user's schema.… Read More »How to Enable AUTOTRACE
To enable AUTOTRACE feature in your session, you not only need to create PLAN_TABLE table, but also need PLUSTRACE role, which is not native in… Read More »How to Install PLUSTRACE Role
To enable AUTOTRACE feature in your session, you not only need PLUSTRACE role to be installed, but also need to create PLAN_TABLE table, which is… Read More »How to Install PLAN_TABLE Table
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
What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »What Makes Instance Shutdown Itself
CPU Utilization Breakdown We might have some doubts about OS CPU utilization when we read an AWR report like the following: We all may be… Read More »How to Read CPU Utilization