August 2014
Intermediate to advanced
336 pages
7h 58m
English

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 ...