Bulletproofing Your Upgrade to Oracle Database 23ai：Best Practices [LRN2992].pdf

1、Bulletproofing Your Upgrade to Oracle Database 23ai:Best PracticesLRN2992Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates1Sunil KalraDatabase Engineering and OperationsDigital Technology-United AirlinesGP GongloorVP,Product ManagementObservability&Manageability,OracleOracle CloudWorld C

2、opyright 2024,Oracle and/or its affiliates2Session speakersHarish NiddagattaDirector,Product ManagementObservability&Manageability,OracleMax SzulyaDatabase Engineering and OperationsDigital Technology-United AirlinesDatabase Upgrade ChallengesPre-upgrade stepsUpgrade to Oracle Database 23aiSQL Perfo

3、rmance Analyzer:Best PracticesDatabase Replay:Best PracticesGo-liveOn-going patching,security and complianceAgendaOracle CloudWorld Copyright 2024,Oracle and/or its affiliates3Database upgrade challengesOracle CloudWorld Copyright 2024,Oracle and/or its affiliates4Which release do I upgrade to?Do I

4、have to pay for support?Is this a long-term release?How can I make sure my system is secure,compliant and up-to date with patches after going live?What strategy or tools do I use for upgrade process to be smooth with minimal downtime?How can I perform load and throughput testing to identify performa

5、nce issues before putting changes in production?How can I identify SQL regression caused by plan changes during an upgrade due to changed parameters?How can I identify what parameters are obsolete,what defaults changed for a new release as part of the upgrade?5United Airlines:ChallengesMission criti

6、cal databasesOperations&revenue impact Response time/latencies play a big role in defining a successful operation1000s of SQL statement with sub-sub second response systemUse EM 13.5 RU 21,Diagnostics/Tuning,Real Application Testing(SPA)featuresDatabase 19c RU19,RU23500+Prod/Non-Prod environments6Up