Skip to Main Content
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
book

Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

by Sam R. Alapati, Darl Kuhn, Bill Padfield
August 2011
Intermediate to advanced content levelIntermediate to advanced
594 pages
15h 54m
English
Apress
Content preview from Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

C H A P T E R  13

Configuring the Optimizer

The cost optimizer determines the most efficient execution plan for a SQL statement. The optimizer depends heavily on the statistics that you (or the database) gather. This chapter explains how to set the optimizer goal and how to control the behavior of the optimizer. You'll learn how to enable and disable automatic statistics collection by the database and when to collect statistics manually. You'll learn how to set preferences for statistics collection as well as how to validate new statistics before making them available to the optimizer. The chapter explains how to lock statistics, export statistics, gather system statistics, restore older versions of statistics, and how to handle missing statistics. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

Darl Kuhn, Sam Alapati, Arup Nanda

Publisher Resources

ISBN: 9781430236627Purchase book