SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
2 FROM x$ksppi x, x$ksppcv y
3 WHERE x.inst_id = USERENV ('Instance')
4 AND y.inst_id = USERENV ('Instance')
5 AND x.indx = y.indx
6 AND x.ksppinm LIKE '%_high_priority_processes%'
7 /
NAME VALUE DESCRIB
------------------------------ ---------- ------------------------------
_high_priority_processes LMS* High Priority Process Name Mask
如果LMS进程如果长时间没有得到CPU时间片,很有可能发生脑裂,优先得到CPU时间片,就可以减少发生脑裂的概率。
如果需要设置多个进程,多个进程之间用|分割,*代表通配符。
如下:
SQL> alter system set "_high_priority_processes"='LMS*|LGWR|PMON' scope=spfile;
System altered.
SQL> startup force nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes
Fixed Size 2101912 bytes
Variable Size 1.0586E+10 bytes
Database Buffers 134217728 bytes
Redo Buffers 14671872 bytes
SQL> show parameter _high_priority_processes
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
_high_priority_processes string
LMS*|LGWR|PMON
SQL> set linesize 100
SQL> _high_priority_processes
SP2-0734: unknown command beginning "_high_prio..." - rest of line ignored.
SQL> show parameter _high_priority_processes
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
_high_priority_processes string LMS*|LGWR|PMON