CHAPTER 16Tuning SQL

This chapter focuses on tuning actual SQL statements. The next section will introduce you to the Oracle explain plan, the method of visualizing the path that Oracle will take to process the data requested by the SQL statement. There are a number of ways to identify poorly performing SQL and these methods are discussed later in this chapter, starting with the section “Finding Poorly Performing SQL.” This chapter will then conclude with an introduction to several useful tools supplied by Oracle to capture poorly performing SQL.

Examining the Execution Plan

The execution plan is the path that Oracle will use to process the data being requested by the SQL statement. Oracle supplies a Plan_Table that is used to store the execution ...

Get Oracle Database 10g Linux Administration now with O’Reilly online learning.

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