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

Cause : Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes.
Action : Do not set sga_target to a value below the current value without first shrinking the individual SGA components.

Popularity: 12% [?]

Share This

Related Post

• ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value
• 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-00832: no streams pool created and cannot automatically create one
• ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
• ORA-00826: cannot set SGA_TARGET or MEMORY_TARGET for an ASM instance
• 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-00823: Specified value of sga_target greater than sga_max_size
• ORA-00821: Specified value of sga_target stringM is too small, needs to be at least stringM