none
Slow Oracle MA workaround? RRS feed

  • Question

  • Hi,

    Like many previous findings online, our Oracle MA is taking a stupendous amount of time to process a few records.

    A work around by a few people here, including Adreas Kjellman is to:

    Create a table called All_Objects. Create this table with the same column names and types as the actual DB you care about but there shouldn't be any actual data(rows) in it. Verify that the account used by the Oracle MA has access to this table.

    Once this table is created, does the Oracle MA need to be reconfigured to point to it - is that the Table/View MA setting on the MA? If yes, then where do we stipulate the original data Table - in the Delta View? Multi table View?

    Or do we simply leave the Oracle MA as is, and somehow (magically) the Oracle MA reads the empty "All_Objects" table?

    Thanks,

    SK

    Tuesday, April 22, 2014 12:43 AM

Answers

  • What are the chances you may have a 'multi value' table in your Oracle MA config?

    We found that by not having one, performance improved.

    regards.

    • Marked as answer by Shim Kwan Monday, May 5, 2014 1:27 AM
    • Unmarked as answer by Shim Kwan Monday, May 5, 2014 1:27 AM
    • Marked as answer by Shim Kwan Monday, May 5, 2014 1:28 AM
    Sunday, May 4, 2014 10:54 PM

All replies

  • Hello,

    I'm not sure about what you need to create another table, but if you want to use it, you need to change it in the Table/View MA setting. And leave empty the Delta View.

    Can you be more specific about the need of the "All_Objects" table?

    Regards,


    Sylvain

    Monday, April 28, 2014 11:20 AM
  • Hi Sylvain,

    That's actually what I am trying to clarify - the "All_Objects" workaround I found online was recommended by guys from Microsoft (Glenn Zuckermann & Andreas Kjellman) .

    What I am trying to find is a clarification of this "All_Objects" workaround. Its easy enough to create this new table - but does anything else need to be reconfigured on the FIM Sync Server?

    Do we need to change any settings on the Oracle MA? Do we need to change anything in the TNSNames.ora file? do we need to change anything in the Oracle client?

    In other words - how will FIM know to look for the empty "All_Objects" table? Or is this something part of the Oracle MA that on connect it does some sort of a discovery of the Oracle tables, as it does take time to do the initial connection, before any data is imported.

    Here are the links where the workaround is discussed:

    http://social.technet.microsoft.com/Forums/en-US/8017a843-0ae0-40f6-8fbb-553d19e57274/issues-with-fim-2010-upr1-oracle-management-agent-for-11g?forum=ilm2

    http://social.technet.microsoft.com/Forums/en-US/83d5bc17-e247-453f-83f9-e83c2c747e45/oracle-11-g-and-fim-r2-sp1?forum=ilm2

    thank you

    Tuesday, April 29, 2014 9:35 PM
  • Ok,

    From Adreas Kjellman's answer, I understand that you need to change the table to the view in the configuration setting, but the view must contains all entries from the table: It's seems that the driver Oracle has an issue and the SQL query rendering by the driver is more complex than it must be.

    If you pointed to the view, the driver will rebuild the query and everything will go fine!

    Regards,


    Sylvain

    Wednesday, April 30, 2014 7:26 AM
  • What are the chances you may have a 'multi value' table in your Oracle MA config?

    We found that by not having one, performance improved.

    regards.

    • Marked as answer by Shim Kwan Monday, May 5, 2014 1:27 AM
    • Unmarked as answer by Shim Kwan Monday, May 5, 2014 1:27 AM
    • Marked as answer by Shim Kwan Monday, May 5, 2014 1:28 AM
    Sunday, May 4, 2014 10:54 PM
  • thanks, will review & investigate both options & revert.
    Sunday, May 4, 2014 11:47 PM
  • Well, it looks like changing the Oracle table to a view did nothing.

    However, we do have a multi-value table, and if I remove it from the Oracle MA, the import that used to take 80 minutes, now takes 3 minutes !

    Wow, that is a huge difference !!!


    Will need to chat to the Oracle DBAs and see how we can rework that multi-value table.
    • Edited by Shim Kwan Monday, May 5, 2014 1:28 AM
    Monday, May 5, 2014 1:26 AM