Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

TDATAMAPSEG deletion - very slow

Hello, everybody

We have been facing a problem in the FDMEE load

This is an example of our process:

Stage Data for Period 'XXXXXXXXXX'

2017-09-09 17:14:45,149 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 86913

2017-09-09 17:14:53,277 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 86913

2017-09-09 17:14:53,307 INFO  [AIF]: Number of Rows deleted from TDATASEG: 575

2017-09-09 17:14:53,308 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

2017-09-09 17:14:53,315 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

2017-09-09 17:14:53,435 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1001

2017-09-09 17:14:53,483 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1001

2017-09-09 17:14:53,541 INFO  [AIF]:

This is a piece log for one process. Here we notice that the deletion in TDATAMAPSEG process is taking around 13 seconds each. Considering we have a huge number of steps this is causing a bad performance in our system, due to the delay for the load. Do you have any idea of what may becausing this trouble ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center