Oracle 参数 GCS_SERVER_PROCESSES 官方解释,作用,如何配置最优化建议
本站中文解释
GCS_SERVER_PROCESSES参数:该参数用于控制同时运行在全局事务中的进程的最大数目。
最佳设置:如果数据库的事务服务器负载高,建议将该参数设置为服务器内存的大小/512MB+1。设置之后,将PX进程池平均分配给每个参数并保持负载平衡。
官方英文解释
GCS_SERVER_PROCESSES
specifies the number of background GCS server processes (LMSn and LMnn) to serve the inter-instance traffic among Oracle RAC instances.
If there is high Cache Fusion congestion on the system, the number of GCS server processes could be increased to reduce Cluster wait time. Additionally, the number of GCS server processes could be increased to reduce the application brownout time associated with Cluster reconfiguration and Dynamic Re-mastering (DRM).
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
Oracle calculates the default value as follows (in order of precedence):
|
Modifiable |
No |
Modifiable in a PDB |
No |
Range of values |
|
Basic |
No |
Oracle RAC |
Multiple instances can have different values. |
GCS server processes are only seen in an Oracle RAC environment.