Performance problems BW
We are facing with some some performance issues in our BW production system. We don´t know what´s the cause for this, so we request some help of you to support us in way to find the solution! We have the SAP BPC installed (SAP BusinessObjects Planning and Consolidation), the BPC when it do a call to SAP BW is running a chain of processes called ZBPC_AUTOMATISMOS_RH (transaction RSPC), this process chain makes a call to the class method in ZCL_HR_IGIF_UJ_CUSTOM_LOGIC~EXECUTE.
For a particular object that runs with a small filter data, between 8.000and 20.000 records, for only a cost center, it performs quickly, nearly 1 minute, but with a greater filter of data it takes much longer (isn´t proporcional!), with 200.000 records it takes something like 40 minutes!
Let me put here the values of some parameters that I changed after system installation (the server has 64Gb and 97Gb of Paging file):
- SAP Parameters adjusted:
- Oracle Parameters adjusted:
alter system set sga_max_size=19G scope=spfile;
alter system set db_cache_size=13G scope=spfile;
alter system set shared_pool_size=3G scope=spfile;
alter system set pga_aggregate_target=3G scope=spfile;
This parameters adjustments are correct?
Can you help us please!?