airhacks.fm podcast with adam bien

Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database

Jan 12, 2025
Guest
Gerald Venzl
Gerald Venzl, an Oracle database expert, shares his wealth of knowledge about prepared statements and their significant advantages in optimizing query execution. The conversation dives into the nuances of hard and soft parsing, connection pooling, and the powerful capabilities of Oracle's Database Resident Connection Pool. Venzl also discusses sharding versus partitioning, the integration of PL/SQL and JavaScript, and how GraalVM enhances performance. The talk wraps up with insights into Oracle's support for ARM architecture and the evolving landscape of database programming.
Ask episode
Chapters
Transcript
Episode notes
1
Intro
00:00 • 5min
2
Database Parsing and Sharding Dynamics
04:52 • 18min
3
Understanding Prepared Statements in Java
22:58 • 4min
4
Understanding Partitioning and Indexing in Databases
27:15 • 2min
5
Optimizing Database Connections: Parsing and Performance
29:20 • 19min
6
Exploring PLSQL and GraalVM Integration
48:03 • 19min
7
From Groovy to Oracle: Navigating Programming Paradigms and ARM Compatibility
01:06:50 • 3min
8
Exploring Social Media Dynamics and Future Topics
01:09:31 • 3min