Episode Details
Back to Episodes
Prepared Statements, Connection Pooling, Sharding, Partitioning and Serverless Workloads with Oracle Database
Episode 327
Published 1 year, 3 months ago
Description
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