100,500 Ways to Cache in Oracle Database
summary
Examines why result caching exists in DBMSs and which systems include it, then compares multiple ways to cache SQL query results and database-stored business-logic results in Oracle Database. Covers manual application-level caches versus built-in caching features, evaluates their trade-offs, and gives recommendations about when each approach is optimal or risky.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:07What is Result Cache
- 2:11Case 1: Report acceleration
- 5:19Case 2: Client recommendations
- 7:27How Result Cache works
- 12:51Implementation issues
- 13:54Monitoring Result Cache
- 16:41Latches and performance
- 19:51Configuring Result Cache
- 21:58Undocumented Result Cache tricks
- 25:04Client Result Cache design
- 28:17Pros and cons of client cache
- 30:45Summary and recommendations
- 31:53Q&A
related talks
16mApplication Acceleration with Oracle True Cache
15mAccelerate Application Response Times with True Cache
29mOracle TimesTen: extreme performance for latency-critical applications
53mHow Doctrine Caching Can Skyrocket Your Application
26mOptimize your workload with automatic indexing
27mOracle TimesTen Cloud Service: ultra-low latency applications in the cloud
46mProactive performance optimization of Oracle databases
22mOracle Exadata: Architecture and internals technical deep dive