AWR для Oracle SE и DBMS_SHARED_POOL

Включение механизма сбора данных для AWR-отчетов в Oracle Standart Edition.

(ист.)

sqlplus / as sysdba
SQL> alter system set control_management_pack_access = "DIAGNOSTIC+TUNING" scope=both;
System altered.

SQL> @$ORACLE_HOME/rdbms/admin/dbmspool.sql
Package created.

Create the dbmspool package body:
SQL> @$ORACLE_HOME/rdbms/admin/prvtpool.plb
View created.
Package body created.

Grant execution privilege on the package:
SQL> grant execute on dbms_shared_pool to sysman;
Grant succeeded.

SQL> grant execute on dbms_shared_pool to dba;
Grant succeeded.

exit

//Пересоздание репозитория
su - oracle
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

OEM -> вкладка Server -> Automatic Workload Repository -> в блоке General нажать "Edit" -> выставить "Retention Period (Days)" = 31.