r17 - 2021-01-12 - 17:24:24 - PaulEllisYou are here: TWiki > 
Deployment Web > DeploymentAdminstering > ConfiguringAndTuningOracle
Deployment Web > DeploymentAdminstering > ConfiguringAndTuningOracle 
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
- Create Oracle data warehouse without DBA permissions
-
New in 6.0.6.1 Remove DBA permissions from an existing Oracle data warehouse
Related topics: None
External links:
- Oracle Database Performance Tuning Guide, 11g Release 2
- Oracle documentation: Real-Time SQL Monitoring
Additional contributors: RosaNaranjo
Questions and comments:
Deployment.ConfiguringAndTuningOracle moved from Deployment.TuningOracle on 2013-11-30 - 17:50 by Main.sbeard -
-
Deployment web
-
Planning and design
- Installing and upgrading
- Migrating and evolving
- Integrating
- Administering
- Monitoring
- Troubleshooting
- ELM SaaS
Community information and contribution guidelines 
Topic list 
Search 
Advanced search 
Notify 
RSS 
Atom 
Changes 
Statistics 
Web preferences 
NOTE: Please use the Sandbox web for testing -
To do
- Under construction
- New
-
Updated
-
Constant change
- None - stable page
- Smaller versions of status icons for inline text:
-
Copyright © 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.