undefined

Gerald Venzl

Oracle database expert, sharing insights on prepared statements, connection pooling, sharding, and serverless workloads.

Best podcasts with Gerald Venzl

Ranked by the Snipd community
undefined
Jan 12, 2025 • 1h 13min

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

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.