从Oracle 12c开始,process 的默认值根据CPU 的核数来决定,并非再是一个固定值。
https://www.cndba.cn/dave/article/2982
sessions 的规则还是没有改变,sessions=1.5*processes + 22。
https://www.cndba.cn/dave/article/2982
https://www.cndba.cn/dave/article/2982
https://www.cndba.cn/dave/article/2982
这个是我们测试测试环境的:https://www.cndba.cn/dave/article/2982https://www.cndba.cn/dave/article/2982https://www.cndba.cn/dave/article/2982
[oracle@www.cndba.cn trace]$ cat alert_cndba.log |grep cores
Number of processor cores in the system is 2
Number of processor cores in the system is 2
Number of processor cores in the system is 2
Number of processor cores in the system is 2
[oracle@www.cndba.cn trace]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Mon Aug 27 07:14:58 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> set lines 120
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
processes integer 300
SQL>
SQL> show parameter sessions
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
sessions integer 472
生产环境上的值:
https://www.cndba.cn/dave/article/2982
[oracle@www.cndba.cn trace]$ cat alert_orcl.log |grep cores
Number of processor cores in the system is 28
Number of processor cores in the system is 28
Number of processor cores in the system is 28
Number of processor cores in the system is 28
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
processes integer 4480
SQL>
SQL> show parameter sessions
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
sessions integer 6776
官方文档上没有给出processes和cores 之间的计算公式,所以这里无法具体计算,但从实际数据来看,cores 越大,process 越大。 大约的计算公式是 processes = 150 * cores。
版权声明:本文为博主原创文章,未经博主允许不得转载。