CHAPTER 5Statement Processing
It is crucial to have a good understanding of exactly what happens when you submit a SQL statement to Oracle. With this knowledge, you’ll have a deeper appreciation of why you want to use bind variables, why you sometimes might not want to use bind variables, and why your goal is to parse a statement once per session, not once per execution per session.
In this chapter, we’ll investigate the complex actions that take place in order to execute a simple statement such as SELECT * FROM EMP or a more complex UPDATE statement. We’ll see what database processes are involved, what memory structures are used, and the general process Oracle goes through to execute each and every statement you submit. Then we’ll cover how ...
Get Effective Oracle by Design 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.
