Chapter 2. PL/SQL Internals

How does this work?! This is our number one question whenever we use any complex tool. Although each of the other chapters in this book answers this question for the features being covered, none answers the question for PL/SQL as a whole. That's the purpose of this chapter.

In this chapter, we discuss PL/SQL architecture, including

  • Database architecture review

  • The PL/SQL compiler, including a discussion of Diana

  • Interpreted vs. native compilation

A Database Architecture Primer

There's no way to fully understand PL/SQL architecture without a basic awareness of the database architecture and its role in processing user requests. In this section, we review the database components used with PL/SQL, including the instance, database ...

Get Expert Oracle PL/SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.