viernes, 15 de enero de 2021

CREAR SNAPSHOT AWR

 CREAR UN SNAPSHOT TOMAR FOTO

SQL> exec  dbms_workload_repository.create_snapshot();

select SNAP_ID, BEGIN_INTERVAL_TIME, END_INTERVAL_TIME
from DBA_HIST_SNAPSHOT
order by 1;

SQL>execute dbms_workload_repository.DROP_SNAPSHOT_RANGE(1959,1966);

No hay comentarios: