Quote Originally Posted by matthew00 View Post
so SGA_TARGET is specified, then those number that we set for SHARED_POOL_SIZE (AMONG OTHERS) are irrelevant even it was set. In other word, Oracle will ignore those number and manage by itself?
If you have any of the automatically tuned SGA components set to a non-zero value, then this will set a minimum value that Oracle will use for that particular component.