Re: Reports Tuning issues

Hi Billy,
All of what you say is very valid.

However right now I lack direct access to the Prod Database and there are already Oracle Apps guys trying to find the problem in the Reports.

There are very few optimizer hints being used and the reports are large but not using PQ etc.

And the same report with the same values( or almost same) generates these widely varying results.

But the server Parameters seem OK and it would be better to go and check the Report Parsing etc.. (as you have indicated)

KP

--
Posted via http://dbforums.com