BEGIN DBMS_SCHEDULER.DROP_JOB(job_name=>'"PERFSTAT"."PERFSTAT_SNAP"', force=>true); END; / -- SNAPSHOTS BEGIN sys.dbms_scheduler.create_job( job_name => '"PERFSTAT"."PERFSTAT_SNAP"', job_type => 'PLSQL_BLOCK', job_action => ' begin execute immediate (''Alter session set "_cursor_plan_unparse_enabled" = false''); statspack.snap(i_snap_level => 5, i_modify_parameter => ''false''); end;', repeat_interval => 'FREQ=MINUTELY; INTERVAL=10;', start_date => systimestamp at time zone 'Europe/Berlin', job_class => 'DEFAULT_JOB_CLASS', comments => 'Perfstat snapshot (KLM)', auto_drop => FALSE, enabled => TRUE); END; / BEGIN DBMS_SCHEDULER.DROP_JOB(job_name=>'"PERFSTAT"."PERFSTAT_CLEANUP"', force=>true); END; / -- CLEANUP BEGIN sys.dbms_scheduler.create_job( job_name => '"PERFSTAT"."PERFSTAT_CLEANUP"', job_type => 'PLSQL_BLOCK', job_action => 'begin execute immediate ''delete from stats$snapshot where snap_time < sysdate -5''; commit; end;', -- repeat_interval => 'FREQ=DAILY; INTERVAL=1;', repeat_interval => 'FREQ=DAILY;BYHOUR=22;BYMINUTE=0;BYSECOND=0', start_date => systimestamp at time zone 'Europe/Berlin', job_class => 'DEFAULT_JOB_CLASS', comments => 'Perfstat cleanup 5 days history (KLM)', auto_drop => FALSE, enabled => TRUE); END; /