Database Table Pinning in Memory

To improve the performance of TIBCO MDM when using Oracle, ensure that you use the commonly used tables that are cached in memory.

The following commons used tables should be used:

  • ASSOCIATION
  • CONFIGURATIONDEFINITION
  • DOMAIN
  • DOMAINENTRY
  • DOMAINLINK
  • DOMAINSTRING
  • DOMAINVALUE
  • RESOURCEACCESS
  • RESOURCEACL
  • QUEUEENTRY
  • FUNCTION
  • OBJECTSEQUENCE
  • ORGANIZATION
  • ENTERPRISE
  • WORKFLOWFORM

Run the sample script after the installation is complete. The sample script is located under $MQ_HOME/db/oracle/install/tablepinning.sql and contains a complete list of tables which should be pinned in memory.

Note: Consult your database administrator (DBA) to modify and run this script.