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