Symptom: 
Reports that used to take 15 seconds to run on the old server now take three minutes.
Cause: 
Optimizer feature not enabled in Oracle parameters
Resolution: 
This information is provided as a courtesy to customers based on an existing Oracle customer experiencing the problem and resolving in the following manner. If you wish to implement this resolution, please do additional research about Oracle parameters to ensure this resolution will be suitable for your situation.

Add the parameter...

   optimizer_features_enable   = 11.1.0.6 

Required Tags:

Article Type: 
Product Issue
Product Line: 
Millennium
Product Module/Feature: 
Reporting
Reports
Product Version: 
2013.5

Optional Tags:

Database Engine: 
Oracle
Ranking: 
0
No votes yet