Is there a possibility to restrict the BefProcMap.Py event for one Target application ?
HI Team,
I have the deadlock situation in FDMEE using the BefProcMap.Py even script ?
When we seen some of performances issues with the one of the Location where this job use to took for 1.5 hours to process the FDMEE import and Oracle has recommended to have the Index created against the table and also BefProcMap.Py script in place with the below script update and in turn this helped us to resolve the performance issue from 1.5 hours to 3 minutes.
fdmAPI.executePLSQL("BEGIN dbms_stats.gather_table_stats(user,?,estimate_percent=>dbms_stats.auto_sample_size,force=>TRUE); END;", ["TDATAMAP_T"], False);