Oracle Database, Fusion Middleware, Linux


How to increase SGA_MAX_SIZE

CASE: Cannot change sga_max_size ORA–02095: specified initialization parameter cannot be modified (Cause: The specified initialization parameter is not modifiable) Simulation: SQL> SHOW parameter sga NAME TYPE VALUE ———————————— ———– —————————— lock_sga BOOLEAN FALSE pre_page_sga BOOLEAN FALSE sga_max_size big integer 592M sga_target big integer 0 SQL> ALTER system SET sga_max_size=600M; ALTER system SET sga_max_size=600M * ERROR […]

, , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.