8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 12c » Here

Oracle Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1)

This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.1).

Related articles.

Runaway Query Management - Automatic Consumer Group Switching

Managing runaway queries using automatic consumer group switching in resource manager has a long history.

Oracle 12c introduces a number of changes related to consumer group switching. The SWITCH_GROUP parameter can now also be set to LOG_ONLY, so the trigger for a potential switch is logged, but no actual consumer group switch is performed. Plan directives can now include the SWITCH_IO_LOGICAL and SWITCH_ELAPSED_TIME parameters to trigger a consumer group switch, so the current list of parameters for the CREATE_PLAN_DIRECTIVE procedure is now as follows.

The allowable values of the SWITCH_GROUP parameter are described below.

For all the switch-related parameters, there is an equivalent NEW_* parameter for altering the values using the UPDATE_PLAN_DIRECTIVE procedure.


The V$SQL_MONITOR view includes four new resource manager columns.

Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB)

In a multitennent environment resource manager performs two separate tasks. At the CDB level it controls the resources allocated to each PDB, allowing you to prioritise some PDBs over others. At the PDB level it controls the resources allocated to each session connected to the PDB, allowing you to prioritise some sessions over others, just as it does in pre-12c instances.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.