Hi Everyone
Need some insight from lots of experts using Oracle 12c (12.1.0.2) and
applying bundle and fixes as per Metalink Doc Recommendations for Adaptive
Features in Oracle Database 12c Release 1 (Adaptive Features, Adaptive
Statistics and 12c SQL Performance) (Doc ID 2312911.1)
Are we implementing the fixes as per the above docs or only if there are some
issue which sometime might not be easy to check when we are supporting hundred
of database and application might not be able to see difference. I personally
saw one issue in mutlple environment before patch where Dynamic sampling calls
are very high and been stopped with some underscore fixset setting without
using the patch and saw dramatic performance improvement.
So if we are putting all fixes as per metalink doc or just applying the patch
and not running any alter ssystem commands.
Any thought or suggestion
TIASanjay