Find Oracle Error Code Ora- and Pl/SQL Tips and Tricks

Cause : The specified value of PGA_AGGREGATE_TARGET was not compatible with current settings of SGA_TARGET and MEMORY_TARGET/MEMORY_MAX_TARGET.
Action : Set PGA_AGGREGATE_TARGET to be no more than the difference of MEMORY_TARGET/MEMORY_MAX_TARGET and SGA_TARGET.

Popularity: 37% [?]

Share This

Related Post

• ORA-00839: SGA_TARGET cannot be modified to the specified value
• ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least stringM
• ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
• ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
• ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set
• ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
• ORA-00846: could not shrink MEMORY_TARGET to specified value
• ORA-00845: MEMORY_TARGET not supported on this system
• ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for more information
• ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account, see alert log for more information