Forum Stats

  • 3,770,167 Users
  • 2,253,079 Discussions
  • 7,875,357 Comments

Discussions

FDM Performance Tunning with Oracle

685893
685893 Member Posts: 183
edited Jun 3, 2010 11:53AM in Financial Data Management
Hi,

We are using Oracle 10g with FDM.We have scheduled batch jobs but it takes a long time while importing the data.

Are there any performance tunnings we can do at Oracle end?

Thanks.

Best Answer

«1

Answers

  • TonyScalese
    TonyScalese Member Posts: 1,108 Bronze Trophy
    Make sure you are using the recommendations for the DB laid out in the FDM DBA guide. It can be downloaded here:

    http://www.oracle.com/technology/documentation/epm.html
    TonyScalese
  • 685893
    685893 Member Posts: 183
    Hi,

    We are refering to FDM DBA Guide mentioned in EPM documentation.
    Are there any other documents or information available?

    Thanks
  • 657263
    657263 Member Posts: 292
    edited May 24, 2010 6:54AM
    Hello,

    Unfortunately "performance" is not an easy question to be answered. There are many factors that go into performance:
    1. Network Performance
    2. FDM Server Performance
    3. Database Server Performance
    4. Application Design/implementation (Scripts, Logic, Mappings, etc.)

    Since there are all different product lines there is not going to be any one documentation.

    Thank you,
    657263
  • 685893
    685893 Member Posts: 183
    Hi,

    Thanks for the reply.

    I am mentioning to my question "We are using Oracle 10g with FDM.We have scheduled batch jobs but it takes a long time while importing the data."

    So we are having performance slow down issue while importing the data from batch files.
  • TonyScalese
    TonyScalese Member Posts: 1,108 Bronze Trophy
    The previous poster is absolutely correct. Isolating the cause of poor performance via a message board will be very difficult.

    Are the import times slower just with batch loader or is the application slow to import files regardless of the method (batch vs interactive)?
    TonyScalese
  • 685893
    685893 Member Posts: 183
    Thanks for the reply.They are more slow with batch loader rather than interactive.
    so I think it can be issue with the batch loading scripts.
    Thanks.
  • TonyScalese
    TonyScalese Member Posts: 1,108 Bronze Trophy
    Well your batch process is likely doing more than just importing so it makes sense that it would take longer than an interactive import.

    Through which process is the batch loader running? Ex: Up-To-Consolidate, Up-To-Load

    What is your target EPM app type and which relational repository type?
  • 665587
    665587 Member Posts: 121
    First you need to isolate where the performance bottleneck is occurring. If batch loads are significantly slower than interactive loads, then I'd look in the batch processes, as you've suggested yourself.

    If load performance is a problem in both batch and interactive modes, then something else you might consider is the number of records in a typical load. Have you configured the location with the optimal load type (SQL Insert or Bulk Insert) for your situation?
    665587
  • 685893
    685893 Member Posts: 183
    Thanks,we would also look at other alternatives like database partitioning etc.
  • 754501
    754501 Member Posts: 10
    You can look at below options

    - Increasing the number of Parallel processes while running the batch.
    - Creating Indexes on TDATASEG & TDATAMAPSEG tables if you dont use reporting extensively.
    - Reduce the like maps / rules (if possible) - (Run the "Import Process Analysis Report" under "System Reports" to get an idea on the exact step thats causing issue)
    - At DB end, try to defrag the tables.
    754501
This discussion has been closed.