{ベースライン}固定ベースラインを作成

演習

 

https://docs.oracle.com/cd/F19136_01/tgdba/gathering-database-statistics.html#GUID-44811EF8-D082-487F-8EEC-DA6E78700E68

 

 

select * from dba_hist_snapshot order by snap_id;


BEGIN
    DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE (start_snap_id => 157, 
                   end_snap_id => 158, baseline_name => 'peak baseline', 
                   dbid => 1709724944, expiration => 30);
END;
/

 

select * from DBA_HIST_BASELINE_METADATA;