How to Enable AUTOTRACE
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
Performance
How to Install PLUSTRACE Role
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
How to Install PLAN_TABLE Table
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 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
How to Resolve ORA-01000: maximum open cursors exceeded
ORA-01000 Saw an error ORA-01000 when executing a lot of statements. It seemed that the number of open cursors has reached the limitation. ORA-01000: maximum… Read More »How to Resolve ORA-01000: maximum open cursors exceeded
What Makes Instance Shutdown Itself
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
How to Read CPU Utilization
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