We have a custom BIP report that was created by our SI back when we implemented, that we are having some performance issues as of late. The code is a bit complex and we are joining data from multiple places (balances, journal entries, SLA, etc), so we know the nature of the report itself is not ideal by any stretch of the imagination. However, the performance of the report is not consistent. Some times during the month we run it and it takes 6 minutes to run, other times we run it and it will hit the timeout limit of 30 minutes. It's not a difference in filters because the parameters are consistent from run to run (Fiscal Year and Ledger), and while data could be different from run to run, it shouldn't be substantial enough to warrant that much of an increase in processing time. We have been trying to tune the SQL and use the log that BIP provide to get some hints, but so far that hasn't bore any fruit. We think this might be more of a load issue in our environment vs purely a SQL issue, but we aren't sure of the best way to dig into this because unfortunately with being in the cloud, we don't have the normal tools we would use or access to the backend to do that. I know this is a broad question, but just looking for some guidance on where to start. We have tried SR's with Oracle, but as soon as they realize this is a custom SQL report, they just send us the generic guide they have on SQL best practice and say they don't support troubleshooting custom SQL. Any guidance would be greatly appreciated.