My Oracle Support Banner

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 19.3.0.0.0 and later
Information in this document applies to any platform.

Goal

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.

Release 19 Administrator’s Guide
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-a-cdb-with-sql-plus.html

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.

 

 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.