There are a wide range of techniques with which one can tune SQL statement performance. These include careful collection of fresh Optimizer and system statistics, use of the SQL advisors to find areas where either SQL statements may be rewritten or the schema may be modified, and the entire set of plan management options. Much of the architecture of SQL statement execution is based upon the premise that cursor sharing will occur. However, if not managed carefully, this can occur far less frequently than one might imagine: Within this section we will discuss:
Advantages of cursor sharing.
Monitoring soft parses and hard parses.
Encouraging cursor sharing and cursor peeking with bind variables.
Understand adaptive cursor sharing which allows the Optimizer to adapt to different execution plans for the same shared cursor.
You are currently reading a PREVIEW of this book.
Get instant access to over
$1 million worth of books and videos.
