I am BI Developer/Consultant and i am currently cluless on the issues with large NQS_*.TMP files in OBIEE. I am currently on obiee - 11g - 18.104.22.168.
I see that after selecting a dashboard report, a NQS_*.TMP file is created in Oracle_Home/instance/tmp/oracleBiservercomponent/coreapplication_obis1/obis_temp/ . The size of the file keeps on increasing and it doesnt stop(AS the data is huge in the report). The file size usually goes up to ~600GB.
Any suggestions on how to avoid such a large tmp file creation or any best practices that i can follow?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!