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

OBIEE 12c JavaHost tmp grows and grows

Received Response
34
Views
6
Comments
Alex Sharkov
Alex Sharkov Rank 5 - Community Champion
edited Aug 13, 2024 5:58PM in Oracle Analytics Cloud and Server

Hi all

on ver OBIEE 12c 12.2.1.2

under dir

/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp/

i see a lot of huge files

Why files exists under this dir? Can i remove files.

On 11g all temporary files removes automaticaly. Why 12c don't remove?

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    What are the file types(extensions) that exists within Java Host tmp directory?

    What is the log level set for Java Host in EM, is it default or finest?

    Also check if any additional logging for Excel and PDF export is enabled for Java Host causing generation of huge files.

    OBIEE 11g|12c: How To Enable JavaHost Logging to Capture Export (PDF/Excel ) and Graph/Chart Requests (Doc ID 1966917.1)

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

    What host OS are you running 12.2.1.2 on? JH tmp folders get cleaned nicely on OEL7 and Windows2k12.

  • Alex Sharkov
    Alex Sharkov Rank 5 - Community Champion

    I see only

    *.javahost.in

    *.javahost.out

    there is no log files

    My OS version is

    RedHat 7

    Linux appbiprod-12c.hq.bc 3.10.0-514.21.1.el7.x86_64 #1 SMP Sat Apr 22 02:41:35 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux

    by the way

    i have in javahost config

       <XMLP>

          <InputStreamLimitInKB>0</InputStreamLimitInKB>

          <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>

          <LogLargeRequests>true</LogLargeRequests>

       </XMLP>

    Is       <LogLargeRequests>true</LogLargeRequests> may generate huge datafiles under /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp/  ?

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Yes looks like your Advanced Logging for Java Host is enabled and may be you are performing report export which are significant in size because of which response file is written in tmp directory, Please see the document link shared before it clearly states the same

    OBIEE 11g|12c: How To Enable JavaHost Logging to Capture Export (PDF/Excel ) and Graph/Chart Requests (Doc ID 1966917.1)

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

    Syed was faster. Any reason why your instanceconfig is set up like this?

  • Alex Sharkov
    Alex Sharkov Rank 5 - Community Champion

    Thanks!

    We did work on issue with export very huge XLS files.

    Seem's to be we forget switch off this