Skip to content
Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database episode artwork

Jan 12, 2025 1 hr 12 min

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

from airhacks.fm podcast with adam bien Hosted by adam-bien.com

An airhacks.fm conversation with Gerald Venzl (@GeraldVenzl) about: discussion on prepared statements and their benefits in Oracle databases, explanation of hard parsing vs soft parsing in database queries, overview of connection pooling and its importance in database performance, introduction to Oracle's Database Resident Connection Pool (DRCP), exploration of Oracle's support for serverless workloads, discussion on PL/SQL and JavaScript support in Oracle databases, brief mention of ADA programming language and its influence on PL/SQL, introduction to GraalVM and its role in Oracle databases, comparison of performance between PL/SQL and JavaScript in Oracle, mention of Oracle database support for ARM architecture including M1 Macs and Raspberry Pi 5, explanation of database sharding vs partitioning, discussion on the benefits of stored procedures for data-intensive operations Gerald Venzl on twitter: @GeraldVenzl

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

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

0:00 1:12:36

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of airhacks.fm podcast with adam bien?

This episode is 1 hour and 12 minutes long.

When was this airhacks.fm podcast with adam bien episode published?

This episode was published on January 12, 2025.

Can I download this airhacks.fm podcast with adam bien episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.