_high_priority_processes进程的优先级设置

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
  FROM x$ksppi x, x$ksppcv y
 WHERE     x.inst_id = USERENV ('Instance')
       AND y.inst_id = USERENV ('Instance')
       AND x.indx = y.indx
       AND x.ksppinm LIKE '%_high_priority_processes%';

NAME
--------------------------------------------------------------------------------
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DESCRIB
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
_high_priority_processes
LMS*|VKTM
High Priority Process Name Mask

SQL>

如果LMS进程如果长时间没有得到CPU时间片，很有可能发生脑裂，优先得到CPU时间片，就可以减少发生脑裂的概率。

 

alter system set "_high_priority_processes"='LMS*|LGWR|PMON' scope=spfile;
System altered.
startup force nomount

AIX:

# ps -eo pid,class,pri,nice,time,args |grep pmon |grep -v grep
11141312 Unclassified  60 20    00:00:11 asm_pmon_+ASM
23527648 Unclassified  60 20    00:00:07 ora_pmon_sgerp5
#

linux:

pctest01:/home/oracle>ps -eo pid,class,pri,nice,time,args |grep pmon |grep -v grep
 4200 TS   19   0 00:14:34 asm_pmon_+ASM
11537 TS   19   0 00:04:17 ora_pmon_sgerp5
pctest01:/home/oracle>