Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Temp space is very lage

Received Response
22
Views
6
Comments
Anirban1
Anirban1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

Hi,

We have installed OBIEE 12c in linux environment. And in \tmp 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

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    I'd suggest that you start off looking at the Oracle Whitepaper on Best Practices Guide for Infrastructure Tuning:

    Oracle Support Document 2106183.1 (OBIEE 12c: Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 12c (12.2.1)) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2106183.1

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Joel,

    Thanks for your reply.

    My question is bit different. I have /tmp mount point as 10 GB where as in s_nq_acct table column "Total_Temp_KB" is showing as 107 GB for a single report in single day. How can I interpret this.

    Thanks

    Anirban

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    In the way that you should seriously think about looking at what that "report" does.

    107GB is mental.

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christian,

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

    Thanks

    Anirban

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    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