Processing Statements in Oracle

In this chapter, we will explore what happens when Oracle executes the statements that you submit to it. We’ll investigate the complex actions that take place in order to execute both a simple statement such as SELECT * FROM EMP, and a more complex UPDATE statement. We’ll see what database processes (as described in Chapter 5) are involved, what memory structures are used and the general procedure Oracle goes through to execute each and every statement you submit.