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

Cause : The specified value of SGA_TARGET was not compatible with current settings of PGA_AGGREGATE_TARGET and MEMORY_TARGET/MEMORY_MAX_TARGET.
Action : Set SGA_TARGET to be no more than the difference of MEMORY_TARGET/MEMORY_MAX_TARGET and PGA_AGGREGATE_TARGET. Also ensure that the current PGA memory used for non-auto workareas is low.

Popularity: 34% [?]

Share This

Related Post

• ORA-00840: PGA_AGGREGATE_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-00846: could not shrink MEMORY_TARGET to specified value
• 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-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