Frazik blog

One Line of Code at a Time, Exploring the World Through Tech

Caching Static Data in PL/SQL for Performance Improvement

Optimize PL/SQL performance by caching static data in a collection stored in the session's PGA.

4 min read · September 03, 2010

2010 · plsql, oracle, performance, caching, collections · database, performance-tuning
PL/SQL Collections A Comprehensive Guide

A detailed explanation of associative arrays, nested tables, and VARRAYs in PL/SQL, including examples and best practices.

6 min read · September 03, 2010

2010 · PL/SQL, collections, associative arrays, nested tables, VARRAY, Oracle · Database, Programming