Oracle 参数 ALLOW_GROUP_ACCESS_TO_SGA 官方解释，作用，如何配置最优化建议
本站中文解释
ALLOW_GROUP_ACCESS_TO_SGA参数控制帐号组是否可以访问SGA，默认值为FALSE，即不允许使用具有访问特权的帐号组访问SGA。
要正确设置该参数，可以使用ALTER SYSTEM指令将参数值设置为TRUE：
ALTER SYSTEM SET ALLOW_GROUP_ACCESS_TO_SGA = TRUE;
官方英文解释
ALLOW_GROUP_ACCESS_TO_SGA controls group access to shared memory on UNIX platforms.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
No |
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
The same value must be used on all instances. |
The default value is false, which means that database shared memory is created with owner access only. In Oracle Database releases prior to Oracle Database 12c Release 2 (12.2.0.1), database shared memory was created with owner and group access.
When this parameter is set to true, database shared memory is created with owner and group access. This behavior grants permissions to DBAs to manage shared memory outside the database, but also allows DBAs to read and write to shared memory, which may not be desirable for certain installations.
