O'Reilly logo

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) by John Watson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13 Database Maintenance

CERTIFICATION OBJECTIVES

13.01 Use and Manage Optimizer Statistics

13.02 Use and Manage the Automatic Workload Repository

13.03 Use the Advisory Framework

13.04 Manage Alerts and Thresholds

image Two-Minute Drill

image Self Test

Performance of SQL statements is critically dependent on statistics that the optimizer uses to design efficient execution plans. Collection of statistics can be manual or automatic. If, after gathering statistics, performance is still an issue, then various metrics can be used to drill down to the cause of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required