Fixing SQL performance Baseline - Multitenant DB
Hi Team,
We are on Oracle database 19.28 version. We are trying to fix plan for one sql using baseline. But we are able to run the procedure from CDB. From PDB,it says snapshots not exist. Is it expected? We have CDB with single PDB currently. This is a new database.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO
3 PRODDB1 READ WRITE NO
SQL> alter session set container=PRODDB1;
Session altered.
SQL> DECLARE
l_plans_loaded PLS_INTEGER;
2 3 BEGIN
l_plans_loaded := DBMS_SPM.LOAD_PLANS_FROM_AWR(
4 5 begin_snap => &begin_snapshot_id,