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.
Copyright © Cloud Software Group, Inc. All rights reserved.