Oracle7 Server Tuning

CHAPTER 4. SQL Processing

Before tuning the SQL in your applications, you should understand the Oracle Server SQL (Structured Query Language) processing scheme. This chapter introduces the basics of SQL processing and outlines the general phases through which each SQL statement goes. Topics include

the stages of executing each type of SQL statement

DML processing

DDL processing

guidelines for controlling transactions

discrete transactions

managing shared SQL and PL/SQL areas

the optimizer

parallel query processing

Although some Oracle tools and applications simplify or mask the use of SQL, all database operations are performed using SQL.