Oracle 参数 RESOURCE_MANAGE_GOLDENGATE 官方解释，作用，如何配置最优化建议
本站中文解释
_SUPPORT
RESOURCE_MANAGE_GOLDENGATE_SUPPORT是Oracle 11g之后的新参数，它控制Oracle是否支持GoldenGate。若此参数设置为FALSE，则不会启动GoldenGate支持的进程，也不会允许使用GoldenGate。
此参数的正确设置是TRUE，即把这个参数设置成TRUE，以使Oracle支持GoldenGate：
ALTER SYSTEM SET RESOURCE_MANAGE_GOLDENGATE_SUPPORT = TRUE scope=both;
官方英文解释
RESOURCE_MANAGE_GOLDENGATE determines whether Oracle GoldenGate apply processes in the database are resource managed.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
All instances should use the same value. |
To enable Resource Manager, set the RESOURCE_MANAGER_PLAN parameter.
By default, Oracle GoldenGate apply processes in the database are not resource managed. Given that replication to a PDB requires a separate Oracle GoldenGate apply process, it is possible that the apply processes for one PDB could end up consuming most of the CPU on the machine, even if there is a CPU resource management plan in place to limit CPU usage per PDB.
You can set the following values for the RESOURCE_MANAGE_GOLDENGATE parameter:
-
TRUE: With this setting, Oracle GoldenGate apply processes in the database are resource managed based on the resources allocated to the GoldenGate apply user. -
FALSE: With this setting, Oracle GoldenGate apply processes are not resource managed.
