Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Clean-up of reports required to not slow down PRD pod or make it even unusable?

Received Response
1
Views
2
Comments
SidneyBoone
SidneyBoone Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

In our project we have several reports scheduled via data analytics. Some of them need to run daily and some of them have an output for about 0,5 GB.

My question now is if these BIP/OTBI reports are being stacked up on our server and if we are not at risk that one day our system will become slower or not usable?

Is there some kind of process we need to run to get rid of 'older' runs of the report? For example a report from 5 weeks ago?

If there is such a process can you tell me which one this is?

Thanks in advance for your inputs.

Kind regards

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics Lead

    Hi

    For usage metrics, Please review and configure BIP Audit

    KB61120 Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers?

    OR

    Doc ID 2059102.1 Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers?

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Apart from the usage metrics suggested by my colleague, there is one more thing you can do.

    Please look at reducing the amount of data stored in the scheduler tables.

    https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/purge-job-diagnostic-logs.html#TBIPA-GUID-C4FBCDB5-BD63-4393-AB13-66BA9D82DDC3

    If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,
    Gaurav