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 : 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: 31% [?]
Cause : The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
Action : Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.
Popularity: 41% [?]
Cause : The parameter was larger than MEMORY_TARGET.
Action : Set the parameter to a lower value than MEMORY_TARGET.
Popularity: 29% [?]
Cause : MEMORY_TARGET parameter was not supported on this system as shmfs was disabled.
Action : Refer to documentation for a list of supported systems.
Popularity: 28% [?]
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 less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.
Action : Set MEMORY_TARGET to at least the recommended value.
Popularity: 29% [?]
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% [?]
Cause : SGA_TARGET or MEMORY_TARGET set with DB_BLOCK_BUFFERS set.
Action : Do not set SGA_TARGET, MEMORY_TARGET or use new cache parameters, and do not use DB_BLOCK_BUFFERS which is an old cache parameter.
Popularity: 15% [?]
