Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Huge .tmp files being created
Hi All,
As per the business requirements, we had to provide edit access to reports and ability to create ad-hoc reports to business users in production. This led to the creation of reports with fairly larger duration or less filters which is causing the reports to execute forever an create huge amounts of .tmp files (~219 GB in some cases). Currently we have automatic mail alerts to monitor this, but are there any solutions to resolve this issue? Like, kill a report which executes more than a specific time ( is there any setting?)
Any help is highly appreciated.
Thanks,
SG
Answers
-
It's a shame you aren't at the UKOUG conference in Birmingham, as my presentation would have helped you out https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world
Basically - you shouldn't be looking to "kill" reports that run long - you should be looking to do this properly. Take the "business requirements" and actually build a system that satisfies them properly. Letting users build content in Production is fine if you have built a solid RPD underneath, and trained users on how to build proper reports with appropriate use of predicates etc. If you're seeing huge TMP files from the BI Server that's because it's pulling too much data back from the DB (see here).
You can configure in the RPD maximum query runtime and maximum number of rows returned.
0 -
+1'000'000 to @rmoff
Root cause analysis and root cause elimination. Don't fiddle around trying to hide the symptoms.
0