r17 - 2021-01-12 - 17:24:24 - PaulEllisYou are here: TWiki >  Deployment Web > DeploymentAdminstering > ConfiguringAndTuningOracle

new.png Configuring and tuning Oracle

Authors: MikeDelargy
Build basis: CLM 2012, CLM 2011, CLM 5.0, CLM 6.x, ELM 7.x

Page contents

Initial assessment

Database tuning is outside the scope of the Jazz Administrator. Any information provided below is for reference only and should be passed to your database administrator.

  • There are specific settings when upgrading which are neither necessary or desirable for production run-time. During the upgrade from DOORS Next 6.x to DOORS Next 7.x, it is necessary to tune Oracle with specific settings.

  • A database administrator can use several Oracle tools to help tune the Oracle databases for ELM. One tool is SQL Access Advisor. The database administrator can use SQL Access Advisor to improve performance by providing the proper indexes for a given workload. More information about this tool is available in the Oracle Database Performance Tuning Guide, 19c.

  • Additional information about performance tuning Oracle databases is available in the Oracle documentation: Real-Time SQL Monitoring

Related topics: None

External links:

Additional contributors: RosaNaranjo

Questions and comments:

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r17 < r16 < r15 < r14 < r13 | More topic actions
Deployment.ConfiguringAndTuningOracle moved from Deployment.TuningOracle on 2013-11-30 - 17:50 by Main.sbeard -
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.