Oracle教程 2023-02-26

Oracle 参数 PROCESSOR_GROUP_NAME 官方解释，作用，如何配置最优化建议

本站中文解释

PROCESSOR_GROUP_NAME 参数用于定义操作系统上CPU资源分配给数据库会话或进程的名称。

如果Oracle数据库会话或进程想要使用特定的CPU资源，那么它应该匹配相应的PROCESSOR_GROUP_NAME参数值。当Oracle数据库进程创建时，它首先根据自身的PROCESSOR_GROUP_NAME参数设置搜索合适的CPU资源，如果没找到，那么它就只能在任何可用的CPU上运行。

要正确设置Oracle参数，首先应该根据Oracle数据库实例具有的特别需求确定PROCESSOR_GROUP_NAME参数值。接着在服务器上创建具有正确值的/etc/system文件，如下所示:

set processor_group_name=

最后重启操作系统，应用参数的新值生效。

官方英文解释

PROCESSOR_GROUP_NAME specifies the name of the processor group that this instance should run in.

Property	Description
Parameter type	String
Syntax	`PROCESSOR_GROUP_NAME =` `string`
Default value	There is no default value
Modifiable	No
Modifiable in a PDB	No
Basic	No
Oracle RAC	For Oracle RAC databases, it is recommended that the operating system processor groups for each database instance are all named the same, so that the same `PROCESSOR_GROUP_NAME` value can be used. However, you can choose to use different names. In this case, you would set the `PROCESSOR_GROUP_NAME` explicitly for each database instance.

This initialization parameter is supported on the Linux and Solaris operating systems.

PROCESSOR_GROUP_NAME instructs the database instance to run itself within the specified operating system processor group. All Oracle processes will be bound to the CPUs in this group and will only run on these CPUs.

Notes:

Oracle recommends that this parameter be set only for databases on which the USE_DEDICATED_BROKER initialization parameter is also set to TRUE.
For NUMA systems, all SGA and PGA memory allocated by the database instance will be allocated from NUMA nodes within the group.
Starting with Oracle Database Appliance (ODA) release 19.9, you can use PROCESSOR_GROUP_NAME to specify the set of CPU cores on which the database on ODA will run. For more information, refer to Oracle Database Appliance X8-2 Deployment and User’s Guide.

本站中文解释

官方英文解释

相关推荐