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