Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description
Cause : MEMORY_TARGET/MEMORY_MAX_TARGET was set to a non-zero value and LOCK_SGA was also set
Action : Do not set MEMORY_TARGET or MAX_MEMORY_TARGET if LOCK_SGA is set to TRUE.
Popularity: 37% [?]
Cause : The parameter was larger than MEMORY_MAX_TARGET.
Action : Set the parameter to a lower value than MEMORY_MAX_TARGET.
Popularity: 31% [?]
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: 42% [?]
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: 37% [?]
Cause : The specified value of MEMORY_TARGET was greater than MEMORY_MAX_TARGET.
Action : Set MEMORY_TARGET less than or equal to MEMORY_MAX_TARGET.
Popularity: 12% [?]
