Wednesday, January 10, 2024

ORA-56747: invalid value ... for parameter sga_target

SQL> alter system set sga_target=4257m; 

alter system set sga_target=4257m 


ERROR at line 1: 

ORA-02097: parameter cannot be modified because specified value is invalid 

ORA-56747: invalid value 4463788032 for parameter sga_target; must be smaller 

than parameter sga_target of the root container 

Popular Posts - All Times