Performance Tuning Guidelines for Siebel CRM Applications Upgrading to Oracle 19c Database and Future Releases

This topic contains the following sections:

• Overview
• Recommendations for Upgrading Oracle to 19c Database and Future Releases for Siebel Deployments
• Oracle Statistics Gathering
• Oracle Parameters for Siebel on Oracle Database
• Recommending SQL Plan Management (SPM)
• SQL Tuning Set (STS)
• SQL Profiles
• SQL Tuning Advisor
• Steps to Create the SQL Plan Baseline in Source Database
• Stored Outlines Migration Through SPM
• SQL Patches
• Ongoing Tuning of Siebel SQL Statements
• Quarantine SQL Plans
• Recommendations for Setting Event Logging and SQL Tagging Issue