single :
DBMS_WORKLOAD_REPOSITORY.CREATE_BALINE_TEMPLATE(
start_time=>to_date('2013-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
end_time=>to_date('2013-09-11 20:00:00','yyyy-mm-dd hh24:mi:ss'),
baseline_name=>'baseline_from_single'
template_name=>'template_single1'
expiration=>180
);
end;
/
repeate:
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(
day_of_week=>'MONDAY',
hour_in_day=9,
duration=8,
start_time=>to_date('2013-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
end_time=>to_date('2014-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
template_name_prefix=>'Monday_baseline_template',
baseline_name=>'Monday_basline',
expiration=>30
);
end;
/
DBMS_WORKLOAD_REPOSITORY.CREATE_BALINE_TEMPLATE(
start_time=>to_date('2013-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
end_time=>to_date('2013-09-11 20:00:00','yyyy-mm-dd hh24:mi:ss'),
baseline_name=>'baseline_from_single'
template_name=>'template_single1'
expiration=>180
);
end;
/
repeate:
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(
day_of_week=>'MONDAY',
hour_in_day=9,
duration=8,
start_time=>to_date('2013-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
end_time=>to_date('2014-09-10 20:00:00','yyyy-mm-dd hh24:mi:ss'),
template_name_prefix=>'Monday_baseline_template',
baseline_name=>'Monday_basline',
expiration=>30
);
end;
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29952014/viewspace-2120323/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29952014/viewspace-2120323/