Database Administration (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center