what are the limits of the compatible parameter
We're upgrading a bunch of old oracle instances to 19.19 Because of 3rd party dependencies compatible='11.2.0.0.0 . After upgrade what features of 19c work and which do not, is it simply the optimizer? I can't find any specific lists. For example when running the upgrade utility it cautions about the flip in behavior for the parameter RESOURCE_LIMIT in 12+ databases. Do I need to follow that advise if we keep compatible set to 11 ?
thanks in advance