오라클에서 awr 를 사용하려면 역시 DIAGNOSTIC pack 의 라이센스가 유료다

오라클 standard 에서 라이센스가 있다는 전제조건으로 기능을 활성화하려면

alter system set control_management_pack_access="DIAGNOSTIC+TUNING";

으로 설정 후 진행하면 된다

CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available:

•The DIAGNOSTIC pack includes AWR, ADDM, and so on.
•The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.
A license for DIAGNOSTIC is required for enabling the TUNING pack.

발췌는
https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams038.htm#REFRN10296