Recommendations for Upgrading Oracle to 19c Database and Future Releases for Siebel Deployments

Many Siebel customers start considering upgrade to Oracle 19c Database and future releases and this document provides Oracle recommendations and best practices for 19c Database and future releases upgrades for Siebel deployments. Siebel customers’ applications can largely benefit from Oracle 19c Database and future releases features and enhancements particularly in areas like general enrichments in statistics gathering and Oracle Optimizer. Siebel applications can take advantage from overall Optimizer improvements as well as specific features that can benefit Siebel running on Oracle RDBMS 19.9 and onwards.

The best approach is to maintain SQL performance stability while taking advantage of new Oracle 19c Database and future releases features. Siebel customers are strongly encouraged to plan using SQL Plan Management in production to maintain the current performance and overtime adopt Oracle 19c Database and future releases feedback for better SQL execution plans, and other performance improvements. Oracle recommends the following approach:

1. Start gathering statistics with Oracle’s recommendation of DBMS package Advisor, which can provide feedback to enhance the way statistics are gathered.
2. Reduce the number of Oracle parameters.
3. Using SPM is of significant importance to make sure that production performance isn'timpacted while allowing Optimizer to come up with better SQL execution plans for best performance, which could be evolved.
4. Plan to use SQL Quarantine to manage runaway queries by setting limits and stop the ones going beyond those limits before they start.