Home > Workload Solutions > Oracle > White Papers > Oracle Database 19c Best Practices on Dell PowerEdge Servers and PowerStore T Model Arrays > Oracle 19c Database: High Priority Processes
In this best practice, we used an Oracle undocumented parameter called high_priority_processes to improve database performance. This parameter allows the LGWR process to have a higher CPU priority. We recommend that customers consult Oracle Support before using this parameter in production. See the Oracle support DOC: Doc ID 1373500.1 for more information.
Overview
The Oracle hidden parameter “_high_priority_processes” enables the database administrator to assign priority to database processes. The following is the default value of the parameter:
_high_priority_processess = ’LMS*|LM1*|LM2*|LM3*|LM4*|LM5*|LM6*|LM7*|LM8*|LM9*’
The LMSn and LMn process relates to the global cache service process. These processes receive, process, and send requests for the global cache service and the buffer cache resources.
To optimize the database configuration, we configured the parameter to prioritize these processes:
_high_priority_processess = ’LMS*|VKTM|LGWR’
Changing the _high_priority_processess parameter requires a database instance restart.