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

Cause : Attempted to shrink MEMORY_TARGET to the specified value but did not succeed because the PGA and SGA components could not be shrunk.
Action : Do not set MEMORY_TARGET to a value below the current value without first shrinking the individual memory components.

Popularity: 27% [?]

Share This

Related Post

• ORA-00839: SGA_TARGET cannot be modified to the specified value
• ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
• 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-00841: MEMORY_TARGET not supported on this system
• 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-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