New HFM Index utility

In a recent patch set update, Oracle provides a new utility that will analyze HFM Indexes.

This is for release 11.1.2.3.500 via Patch Set Exception (PSE): 18921957.  However you can use this utility on any 11.1.2.x version.

  • examine the indexes on the database tables and compare them against the required indexes to see if any changes should be made.
  • can be used to repair an issue that may have been caused by certain versions of the HFM Copy Application utility

Link to the patch: https://updates.oracle.com/Orion/Services/download?type=readme&aru=18120702

 

“The index update utility operates in three modes.  The first is to examine the existing database table indexes on an HFM application and generate a report outline any potential problems that may exist.  The second option will generate a report and a file of SQL commands to drop and recreate any possibly missing or incorrect indexes.  The third form generates a report and instantly executes the commands to drop/recreate indexes.”

 

 

~ by Eric Helmer on October 21, 2014.

One Response to “New HFM Index utility”

  1. Great work from Oracle on fixing HFM performance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: