CHAPTER3Code Instrumentation in PL/SQL
As discussed in Chapter 2, Oracle provides many tools and features that can tell you about the resources being consumed by a PL/SQL program unit. This chapter will show how to determine if indeed the problem exists in the database and what developers can do to instrument their code so that performance problem areas within program units can be quickly and easily identified further along in the development process, or even when a system is in production. If code instrumentation is performed correctly, very little developer time should be needed, and there should be little or no system overhead or resources ...
Get Oracle PL/SQL Performance Tuning Tips & Techniques 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.
