代码改变世界

Baseline模板管理

2015-11-05 16:22  abce  阅读(395)  评论(0)    收藏  举报 
SQL> alter session set NLS_DATE_FORMAT= 'yyyy-mm-dd hh24:mi:ss';

创建单一基线模板：

SQL> exec dbms_workload_repository.create_baseline_template (
    start_time => '2015-11-05 10:00:00',
    end_time => '2015-11-05 18:00:00',
    baseline_name => 'baseline_090402',
    template_name => 'template_090402', 
    expiration => 8,
    dbid => 1725496767);

创建可重复基线模板：

SQL> exec dbms_workload_repository.create_baseline_template (
    day_of_week => 'monday', 
    hour_in_day => 17,
    duration => 3, 
    expiration => 8,
    start_time => '2015-11-05 10:00:00',
    end_time => '2015-11-05 19:00:00',
    baseline_name_prefix => 'baseline_2015_mondays_',
    template_name => 'template_2015_mondays',
    dbid => 1725496767);

删除基线模板：

SQL> exec dbms_workload_repository.drop_baseline_template (template_name => 'template_090402',dbid => 1725496767);