Resource manager plan is not active or is not managing CPU usage

Error

SQL> EXECUTE dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true);
BEGIN dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true); END;

*
ERROR at line 1:
ORA-20000: Unable to gather statistics concurrently: Resource manager plan is not active or is not managing CPU usage
ORA-06512: at "SYS.DBMS_STATS", line 34757

ORA-06512: at line 1


Cause

Resource Manager must be enabled in 12c in order to use any value other than OFF for the CONCURRENT preference (which enables concurrent statistics gathering).

Solution

SQL> alter system set resource_manager_plan = 'DEFAULT_PLAN' ;

System altered.

SQL> EXECUTE dbms_stats.gather_table_stats(ownname=>'ROCFM',tabname=>'SUBSCRIBER',cascade=>true);


PL/SQL procedure successfully completed.


SQL>