Proactive performance optimization of Oracle databases
summary
Presents a simple method for proactively finding backend bottlenecks using Oracle Database. The method is applied regularly (twice a year) and, in the CFT-Retail bank case, reduced production performance incidents roughly tenfold despite frequent biweekly feature deliveries. The talk describes the approach and demonstrates it on Oracle as the server-side (database) component where intermittent severe degradation of application server code occurs.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 5:11Reactive vs proactive optimization
- 12:49Proactive optimization methodology
- 22:13Real optimization examples
- 33:39Results and summary
- 38:23Monitoring tools
- 40:57Q&A
related talks
50mSupercharge your Code to Get Optimal Database Performance
29mOracle TimesTen: extreme performance for latency-critical applications
36mHow to make your daily routine, code and database more efficient
29mFuture-proof your applications using RAC
34mUnder the covers of Oracle Real Application Cluster deployments
26mOptimize your workload with automatic indexing
15mUsing Oracle Tech for Digital Inclusion in Rural Areas
20mPredictive Analytics for 99.98% Oracle Cloud Availability