Instrumenting and Profiling PL/SQL

We’ve all been there. Someone comes up to you in an agitated state: “The system is running slow!”

What—all of it? Very occasionally they do mean that, but usually it means that a certain thing critical to the business is taking too long to run. Less often, but usually with even more agitation, someone will come up and say “The X function is broken!”

In such situations the problem needs to be fixed and it needs to be fixed as quickly as possible. Usually a few questions will reveal the part of the application that is the issue (let’s say it is the daily batch load that ran in 2 hours rather than 20 minutes). ...

Get Real World SQL and PL/SQL: Advice from the Experts 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.