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 - 22.214.171.124.
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?