Oracle Business Intelligence Applications

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

Categories

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

OBIA Finance Incremental Load

Received Response
1
Views
2
Comments
2907462
2907462 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

SDE_ORA_SLAJOURNALFACT, SIL_AR_TRANSACTION_FACT.W_AR_XACT_F interface leads to slow performance of load.  The incremental load has gone from 4 hours to 10 hours.

Folks Please help me out in this. Its Very urgent.

Thanks

Babu

Answers

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

    First and foremost:

    2907462 wrote:Its Very urgent.

      ==> "Also, please remember that all users have normal jobs to do to get the bills paid. Phrases as ‘ASAP’, ‘urgent’ have no meaning at all . There is no ‘Service Level Agreement’ attached to the OTN Community Spaces. If you need urgent help you should use support.oracle.com, the paid support Oracle offers."

    And:

    2907462 wrote: The incremental load has gone from 4 hours to 10 hours.

    Have you done any analysis at all? Checked the logs? Looked at the SQL statements? Checked the explain plans?

    At the moment this "question" is just you asking other people to solve your issue (and do you work) without providing any pertinent information at all.

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi 2907462/Babu -

    If you are still seeing this issue, please reply with some addtional details. You could start with your version number(s). Also, which step, in the load plan, is spending the most time? We would need to narrow this down some to make any progress.

    If you have taken this to support, kindly close this thread ...

    Regards,

    Charles