There are multiple factors,
Is your Dev & Prod with the same capacity (RAM, Hard disk, Server Configurations etc...)?
The Source you are loading from FDMEE in Dev & Prod do have the same configuration.
Note: Have a look at this generic guide too ORACLE HYPERION FINANCIAL DATA QUALITY MANAGEMENT ENTERPRISE EDITION (FDMEE) – PERFORMANCE BENCHMARKS (Doc ID 1644737.1)
Thanks for your suggestions dayalan.
DEV and PROD servers have same configuration .
is there any SQL tables we need to check if we face any performance issues ?
got one cause, not sure about solution
Issues with table locks on the TDATAMAP and TDATAMAP_T mapping tables were identified in internal bug 19631188 in FDMEE 220.127.116.11.510 which were causing seemingly inexplicable pauses in data loads (at least to end users).
Need to check this and will updated here
- FDMEE and other Oracle EPM software is on the same patch release between DEV and
- PROD and DEV have the exact same infrastructure specification
I would bring your DBA in the mix. Have your DBA monitor the data load in DEV and then monitor the same data load in PROD.
Also, have your DBA compare the FDMEE database repository setting in both DEV and PROD. See if there are any differences that could be making FDMEE slower in PROD.
While this doesn't necessarily explain the performance issues between PROD and DEV, I suggest putting FDMEE on the latest patch release, 18.104.22.168.700.
We had big issues with Check Rules turned on and SQL data locks in SQL Server that would cause long delays as multiple loads would compete for writing records to the FDM Check Rules table. Not sure if you're using that functionality or if you are just talking about loading.