My Oracle Support Banner

Automatic Sql Tuning Results Details: Session Information Unavailable (Doc ID 2872423.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In OEM console, from home page of container database, navigate to Performance -> Advisors Home

login as a CDB admin user (C##SOMEUSER)

Advisor Central -> Advisor Tasks -> select "sys_auto_sql_tuning_task" -> "View Results"

in the Automatic SQL Tuning Result Summary section click on "View Report"

The reports show a list of sqls with recommendations from all the containers (PDBs).

When clicked on any sql_id  or select any row then clicked on view recommendation, that belongs to PDB other than CDB$ROOT, a error page saying session information unavailable is presented.

Changes

 Logged in CDB admin user (C##SOMEUSER)  was recently created.

Cause

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
Symptoms
Changes
Cause
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.