CHAPTER 8Parsing

The impact of parsing on overall performance is extremely variable. In some cases, it is simply not noticeable. In other cases, it is one of the major causes of performance problems. If you have problems with parsing, it usually means the application does not handle it correctly. This is a major problem, because more often than not, to change the behavior of an application, you need to modify the code considerably. Developers need to be aware of the implications of parsing and how to write code in such a way as to avoid, as much as possible, the problems associated with it.

Chapter 2 described the life cycle of a cursor and how parsing works. This chapter describes how to identify, solve, and work around parsing problems. I'll ...

Get Troubleshooting Oracle Performance now with O’Reilly online learning.

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