Slow Oracle MA workaround?

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

April 21st, 2014 8:48pm

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,

Free Windows Admin Tool Kit Click here and download it now
April 28th, 2014 7:25am

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

April 29th, 2014 5:39pm

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,

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2014 3:30am

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 9 hours 24 minutes ago
  • Unmarked as answer by Shim Kwan 9 hours 23 minutes ago
  • Marked as answer by Shim Kwan 9 hours 22 minutes ago
May 4th, 2014 6:58pm

thanks, will review & investigate both options & revert.
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2014 7:52pm

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.
May 4th, 2014 9:30pm

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 05, 2014 1:27 AM
  • Unmarked as answer by Shim Kwan Monday, May 05, 2014 1:27 AM
  • Marked as answer by Shim Kwan Monday, May 05, 2014 1:28 AM
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2014 1:54am

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 05, 2014 1:28 AM
May 5th, 2014 4:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics