Automatic SQL Tuning Job
When you create a database in Oracle Database 11g or higher, there is an automatic SQL tuning job that routinely runs the SQL Tuning Advisor for you and generates advice on how to improve performance. This advice can be in the form of creating indexes, restructuring SQL, creating a SQL profile, and so forth. This architecture is depicted in Figure 9-1.
Figure 9-1. Architecture of the automatic SQL tuning job
Notice that the automatic SQL tuning job uses as its input the high resource statements found in the AWR. Also, the job can be configured to automatically accept SQL profiles (more on this later).
Verifying Automatic ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
