ORA-00823: Specified value of sga_target greater than sga_max_size

Cause : The specified value of sga_target is greater than sga_max_size.
Action : Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize.

Popularity: 18% [?]

Share This

ORA-00845: MEMORY_TARGET not supported on this system
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-00827: could not shrink sga_target to specified value
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

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

Blogroll

Pages

Most Popular

Top Commentators

ORA-00823: Specified value of sga_target greater than sga_max_size

Related Post

Leave a Reply

Browse Our Oracle Tag Archives