Temp space is very lage

Question

Hi,

We have installed OBIEE 12c in linux environment. And in 	mp mount point we have only 10 gb space. But in s_nq_acct table there is one column called Total_Temp_KB which is having value something as 107gb. Can you please tell me how it is showing 107 gb. We did not change any temp path. Is there any default available for OBIEE where it is stored/processed temp file?

Thanks

Anirban

Anirban1 · Answer

Hi Christian,

Thanks for your suggestion. I am doing that only now. Wanted to know the column "Total_Temp_KB" -- Is this column shows data that "How much temp space used" or "How much temp space is required". Because if first question is the answer then I wanted know how it is getting temp space as I only have temp space as 10 GB allocated (it is showing 107 GB), if it is second one then I am good to go.

Thanks

Anirban

[Deleted User] · Answer

Dissect the report. Check WHAT it is doing and ask WHY is it doing it.

Anirban1 · Answer

Hi Christian,

You are correct. I have disabled that report already but still wanted to know How can I interpret the scenario.

Thanks

Anirban