Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

performance Issue in Import

704218Dec 24 2010 — edited Apr 18 2011

Hi,
I have an import format where i am trying to import using an import integration script. the source is an Oracle database. While the import works OK when the record number is 100-200, the performance goes down when the count becomes 1000. for 3000 odd records FDM takes 30 minutes to load. for 10,000+ the application hangs.

I have checked the database setting for the FDM application and found that there are no separate tablespaces for data segement tables and work tables. all of them use the same table space. Could this be the only cause?? what other thing can I look at?

Also, I did some checks and foud that while the data s getting read properly in the recordset (rsAppend), the load to worktable is not happening. based on this I suspect that its a database set-up issue

Any help in resolving this would be greatly appreciated

-Shantanu

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2011

Added on Dec 24 2010

#business-intelligence-applications, #financial-data-management, #performance-management-applications

2 comments

279 views