Slow Performance of Undo / Remove for Mapping Rule Multi-Processing Process (Doc ID 413227.1)

Last updated on OCTOBER 31, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
Oracle Profitability Manager - Version: 11.5.10
This problem can occur on any platform.

Symptoms

When running an undo / remove for Mapping Rules from the "Process Management" → "Executed Rules" screen, the undo is taking a very long time to complete.  The performance is very slow.

The following statement appears to be taking the most time:

INSERT INTO
FEM_MP_PROCESS_CTL_T(req_id,rule_id,slice_id,partition,data_slice,process_num,rows_processed,rows_lo
aded,rows_rejected,status,message) SELECT 279634,32604,rownum
+131,null,data_slice,0,null,null,null,null,null FROM (SELECT DISTINCT '13095122{#}13195083'
data_slice FROM FEM_BALANCES WHERE 1=1)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms