Oracle DBA, How To, Error, Cause and Action

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 75% of the larger of initialization parameters SHARED_POOL_SIZE, MEMORY_TARGET, and SGA_TARGET.



Action:


Specify the value of MAX_SGA to be less than 75% of the maximum of SHARED_POOL_SIZE, MEMORY_TARGET, and SGA_TARGET.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)