Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing MDM Registry Edition
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading MDM Registry Edition
  7. Uninstalling MDM Registry Edition

Installation and Configuration Guide

Installation and Configuration Guide

Step 4. Configure the Oracle Instance Parameters

Step 4. Configure the Oracle Instance Parameters

Optionally, you can configure the following Oracle instance parameters to improve the performance of the database:
  • OPTIMIZER_DYNAMIC_SAMPLING
  • MAX_COMMIT_PROPAGATION_DELAY
  1. Configure
    OPTIMIZER_DYNAMIC_SAMPLING=0
    to prevent the optimizer from collecting dynamic statistics, which improves the query execution time.
  2. Configure
    MAX_COMMIT_PROPAGATION_DELAY=0
    to avoid any delay in data synchronization.