Submitted by 334 on
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 
Article Type
Product Issue
Product Line
Millennium
Product Module/Feature
Reporting
Reports
Product Version
2013.5
Database Engine
Oracle
Ranking
No votes yet