Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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