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

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