PLS-00201: identifier ‘DBMS_STATS.GATHER_DATABASE_STATS’ must be declared

PLS-00201: identifier ‘DBMS_STATS.GATHER_DATABASE_STATS’ must be declared

Cause:

SQL> EXEC dbms_stats.gather_database_stats();
BEGIN dbms_stats.gather_database_stats(); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_STATS.GATHER_DATABASE_STATS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Solution:

If it is multitenant, then open the pdb.

SQL> alter pluggable database updb open;

Pluggable database altered.

SQL> alter pluggable database updb save state;

Pluggable database altered.

SQL> alter session set container=updb;

Session altered.

SQL> set timing on
SQL> EXEC dbms_stats.gather_database_stats();