Hi Team,

We are on 19.28 Oracle Version. We are trying to create SQL Tuning Task on one of the sqlid. We have AWR enabled for PDB and CDB.

When we run sql tuning task from PDB, it throws error:

SQL> SELECT DISTINCT
snap_id,
executions_delta
FROM dba_hist_sqlstat
WHERE sql_id = 'b21nzh12kf0ym'
ORDER BY snap_id;

  SNAP_ID         EXECUTIONS_DELTA
   362             2463————PDB

   363              732———-PDB

  2986             2463———-CDB

  2987              732———-CDB

FROM pdb:

SQL> SQL>
SQL> DECLARE
l_sql_tune_task_id VARCHAR2(100);
BEGIN
l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
begin_snap => 362, -- Starting Snapshot ID
end_snap => 363, -- Ending Snapshot ID