WARNING: Granules of pga_aggregate_target 400 cannot be more than memory_target (404) - sga_target

环境:

linux 6.8 + oracle 11.2.0.4 rac

 

alert 日志有以下告警:

WARNING: Granules of pga_aggregate_target 400 cannot be more than memory_target (404) - sga_target (

 

相关信息:

SQL> show parameter mem

 

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

hi_shared_memory_address integer 0

memory_max_target big integer 101G

memory_target big integer 101G

shared_memory_address integer 0

SQL> show parameter sga

 

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

lock_sga boolean FALSE

pre_page_sga boolean FALSE

sga_max_size big integer 101G

sga_target big integer 0

SQL> show parameter pga

 

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

pg