ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value

Friday, March 28th, 2008

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% [?]

ORA-00839: SGA_TARGET cannot be modified to the specified value

Friday, March 28th, 2008

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% [?]

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least stringM

Friday, March 28th, 2008

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% [?]

Close
E-mail It