Perhaps the most transformative SQL feature in Oracle 19c is the introduction of . Traditionally, developers relied on PL/SQL functions to encapsulate business logic. However, context switching between the SQL engine and PL/SQL engine often incurred significant performance penalties.
Oracle 19c (the "Long Term Support" release) introduced several performance and management features: IT Convergence Official New Features Guide (PDF) — Detailed list of every technical change. Introduction and Overview White Paper (PDF) — A high-level look at why to upgrade. The Optimizer in Oracle 19c (PDF) oracle sql 19c pdf new