OBIA Finance Incremental Load

2907462

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

[Deleted User]

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

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