How Automatic Sql Tuning Advisor Runs In 19c Multitenant Environment
(Doc ID 2812745.1)
Last updated on OCTOBER 11, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
This document explains how the Automatic SQL Tuning Advisor is run in 19c multitenant environment.
Documentation says that Automatic Tuning Advisor runs only in CDB root, but if you look into CDB_AUTOTASK_JOB_HISTORY view, "sql tuning advisor" jobs seem to run in PDBs also.
Automatic SQL Tuning Advisor runs only in the CDB root. See the SQL Tuning Advisor row in this table for information about data collected by Automatic SQL Tuning Advisor.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document