PL/SQL – DOUG

Collections in PL/SQL: An Introduction

Written by Bob Watkins, Managing Partner of B. Watkins Collections are an essential tool in PL/SQL programming. In this article, we’ll take a look at what collections are, why they’re important, and how to declare and use them. What are collections? Collections are datatypes that you use to declare variables in your PL/SQL program. Unlike […]

Performance Instrumentation for PL/SQL: When, Why, How

Articles / Chris Frost

Based on a Presentation By Karen Morton, Oracle Performance Consultant “If you can’t measure it, you can’t manage it.” -David Garvin The hardest part is getting the “right” information by collecting properly scoped, un-aggregated profile data. This is where instrumentation comes in. Performance instrumentation is a little extra code that developers put into their PL/SQL

Performance Instrumentation for PL/SQL: When, Why, How Read More »