Oracle 12c R1 Adaptive Patch and workaround
Date: Sun, 4 Mar 2018 23:45:26 +0000 (UTC)
Message-ID: <1491850561.8156564.1520207126903_at_mail.yahoo.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 05 2018 - 00:45:26 CET