When we want to get rid of some of the columns of a table but the table is being used heavily, we can resort to…
BEGIN — Prepare the pending area DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA; DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE( plan => ‘OLTP_PLAN’ ,group_or_subplan => ‘SYS_GROUP’ ,new_cpu_p1 => 30 ); DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE( plan => ‘OLTP_PLAN’ ,group_or_subplan =>…
View All Hidden Parameters: View a Specific Parameter:
There might be many reasons to export the Oracle object statistics. For example, you may want to save the current statistics, that is to say,…
WHAT IS RESOURCE MANAGER Resource Manager, is an Oracle database embedded resource allocation/scheduling mechanism that enables us to manage multiple different database workloads by assigning…
1. Find the SQL_ID: If you are not going to use a SQL Tuning Set which is a set of pre-captured SQL Ids or manually…
There is a purge script named “sppurge” under the path “$ORACLE_HOME/rdbms/admin” to be executed manually from time to time to prevent the tablespace from filling up. See the below…
DATABASE STATISTICS SCHEMA STATISTICS TABLE STATISTICS INDEX STATISTICS DICTIONARY STATISTICS FIXED OBJECT STATISTICS SYSTEM STATISTICS
1. Create a seperate tablespace for the STATSPACK user: It is a recommended best practice to create a seperate tablespace for the STATSPACK user. The…