Showing posts with label ORA-16181: SGA specified for Logical Standby is too large. Show all posts
Showing posts with label ORA-16181: SGA specified for Logical Standby is too large. Show all posts

Saturday, 24 March 2012

ORA-16181: SGA specified for Logical Standby is too large

ORA-16181: SGA specified for Logical Standby is too large

Cause: MAX_SGA is larger than the larger of initialization parameters SHARED_ POOL_SIZE and SGA_TARGET.

Action: Specify the value of MAX_SGA to be less than the maximum of SHARED_POOL_SIZE and SGA_TARGET. Likely only 75% or lower.