CHAPTER1The Role of PL/SQL in Contemporary Development

When building systems, it is critical to ensure that the systems will perform well. For example, after you build a web-based application, a user who clicks a button on a screen expects to receive a response within a reasonable amount of time. If, instead of waiting 1 to 2 seconds, the user needs to wait 1 to 1.5 minutes for a response, something is definitely wrong. The first instinct of most web developers is to call the DBA and say that the database is slow. However, that might not be the reason for the poorly performing application at all. This chapter discusses system performance tuning ...

Get Oracle PL/SQL Performance Tuning Tips & Techniques now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.