Home » Developer & Programmer » Reports & Discoverer » Unpredictable Report Performance (EBS R12, db-
Unpredictable Report Performance [message #670153] Mon, 11 June 2018 23:28 Go to next message
Messages: 237
Registered: July 2005
Location: Karachi
Senior Member

Dear Experts,

I am facing a very silly problem, I dont understand how can i get rid of this problem. I have built a Material movement report which is 95% based on MTL_MATERIAL_TRANSACTION table. The report is performing very well during early time in a day hardly in some minutes to complete, where as when this report run in evening time which is our real peak time for data input it get slow. Too much slow, it takes more then a hour to complete. I cant understand how can i overcome on this problem. I have made several tries, made changes and update , execution plane change every time, when i made change in report. But nothing is working. Please help me in this regards and suggust the best.


Anwer Ali
Re: Unpredictable Report Performance [message #670157 is a reply to message #670153] Tue, 12 June 2018 03:21 Go to previous message
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
So presumably the query actually takes a lot of work and oracle can complete it quickly if the server isn't busy but not otherwise.
We can't really say any more than that unless you give us a lot more information - the report query, the execution plan and table structures.
Previous Topic: ORA-00932 Error
Next Topic: exit after print
Goto Forum:

Current Time: Sun May 22 06:17:59 CDT 2022