Creating Single AWR Baseline Template

We cam now , in 11gR2 schedule  baseline template to run in a future time just using the package dbms_workload like bellow:


begin

dbms_workload_repository.create_baseline_template (
start_time => to_date('2009/10/28 22:00:00','yyyy/mm/dd hh24:mi:ss'),
end_time => to_date('2009/10/29 08:00:00','yyyy/mm/dd hh24:mi:ss'),
baseline_name => 'baseline1',
template_name => 'base_temp_1',
expiration => 30);
end;
/

Then, you can check this object using view wrm$_baseline_template;

In this example the AWR will create a baseline captured between 2009/10/28 22:00 and 2009/10/29 08:00.