How do you set optimizer_features_enable parameter for OC 4.6?
Last updated on APRIL 28, 2011
Applies to:Oracle Clinical - Version: 4.6.0
Information in this document applies to any platform.
As per OC 4.6 doc, the optimizer_features_enable parameter should be set to 9.2.0.
But changing this from 11.1.x to 9.2.0 causes bad performance of most of the db queries including data dictionary queries.
What is the reason behind setting this parameter to 9.2.0 and negative side of it if it is set to 11.1.x?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms