{AWR}PDB単位のAWRスナップショット自動取得の有効化

 

https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-D64AEB01-18FF-47EF-BB5C-A0611117D180
https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-18E1B278-B3C5-4FE1-8E51-BC8878C439F5

 

-- PROD3
sqlplus / as sysdba

show con_name;

show parameter pdb
ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED = TRUE;
show parameter pdb

alter session set container=pdb1;

show con_name;

EXEC DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (interval=>10);
SELECT CON_ID,SNAP_INTERVAL,RETENTION FROM AWR_PDB_WR_CONTROL;

 

SELECT DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT() FROM DUAL;
select *   FROM AWR_PDB_SNAPSHOT order by snap_id;

@?/rdbms/admin/awrrpt