Home > Workload Solutions > Oracle > Best Practices > Intel-Based Oracle Best Practices on Dell PowerEdge R740 and PowerMax 2000 > Database Best Practices > Day One Best Practices > Oracle 19c Database: High Priority Processes
In this best practice we used an Oracle configuration parameter to set database processes to high priority. The Linux operating system enables setting priorities on processes to ensure critical processes gain priority of the operating systems.
Category | Oracle 19c Database |
Product | Oracle 19c |
Type of best practice | Performance Optimization |
Day and value | Day 1, Highly Recommended |
Overview
The Oracle configuration parameter _high_priority_processes enables the database administrator to assign priority to database processes. See the following 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 does require a database restart.
Recommendation
Updating the _high_priority_processess database parameter did slightly increase performance across all the metrics:
We recommend changing the _high_priority_processess parameter as a Day 3, Fine Tuning activity that could provide the database with a slight performance boost.
Implementation Steps
alter system set _high_priority_processess=’LMS*|VKTM|LGWR’ scope=spfile
Restart the database. We recommended testing this thoroughly before actually using it. Refer to Oracle support DOC: Doc ID 1373500.1.
To check the current value of this parameter, run this query as sys or system user:
select x.ksppinm name, x.ksppdesc description, y.ksppstvl value
from sys.x$ksppi x, sys.x$ksppcv y
where 1=1 and x.inst_id = y.inst_id and x.indx = y.indx
and x.ksppinm ='_high_priority_processes’;