问题描述

-- 执行手工awr快照报错
SQL> dbms_workload_repository.create_snapshot();
dbms_workload_repository.create_snapshot();
[-2207]:Error in line: 1
Member access [DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT] unresolved.
used time: 0.518(ms). Execute id is 0.

原因

未初始化awr包

解决

--初始化awr包
SQL> sp_init_awr_sys(1);