Collect AWR and Statspack automatically.

collect_awr.sql

spool awr_all.sql
set pages 0
select
'define report_type=html' || chr(10) ||
'define num_days = 1' || chr(10) ||
'define begin_snap='  || SNAP_ID || chr(10) ||
'define end_snap='    || (SNAP_ID + 1)|| chr(10) ||
'define report_name=' || SNAP_ID || '_' || (SNAP_ID + 1) || '.html' ||
chr(10) ||
'@?/rdbms/admin/awrrpt.sql' || chr(10)
from DBA_HIST_SNAPSHOT
--where
--to_char(END_INTERVAL_TIME,'yyyy/mm/dd') = to_char(sysdate,'yyyy/mm/dd')
--SNAP_ID >= 3123
--and SNAP_ID <= 3145
order by snap_id
;

collect_statspack.sql

set pages 0
 select
 'define begin_snap='  || SNAP_ID      || chr(10) ||
 'define end_snap='    || (SNAP_ID + 1)|| chr(10) ||
 'define report_name=' || SNAP_ID || '_' || (SNAP_ID + 1) || '.txt'  ||
 chr(10) ||
 '@?/rdbms/admin/spreport.sql' || chr(10)
 from stats$snapshot
-- where snap_id >= 1077
-- and snap_id <= 1098
 order by snap_id
 ;
spool off