The parameter sga_target not making the assigned value value.
Hi Dear all,
The scenario is as follows:
1) The instance is not configured with automatic memory management (version 10.2.0.4) and sga_max_size = 12G.
2) Run the command alter system set sga_target = 10G scope = both.
3) Run the command show parameter sga_target and it only takes 7G.
4) Check the lights and the value is shmmax 2G ... I wonder why did not generate error if the value is greater than shmmax sga??
5) The next day I run the command alter system set sga_target = 10G scope = both; and this time took the desired value, they think it could have happened?
Kind Regards.
1) The instance is not configured with automatic memory management (version 10.2.0.4) and sga_max_size = 12G.
2) Run the command alter system set sga_target = 10G scope = both.
3) Run the command show parameter sga_target and it only takes 7G.
4) Check the lights and the value is shmmax 2G ... I wonder why did not generate error if the value is greater than shmmax sga??
5) The next day I run the command alter system set sga_target = 10G scope = both; and this time took the desired value, they think it could have happened?
Kind Regards.
0