Hi. I want to run the dbms_workload_repository.create_snapshot() at 2 minute intervals instead of the 60 minute default setting. I am having difficulty locating the code. Where do I make this change ? Is it in a procedure or in the job system ? Please advise. Thank you.
No we are not running it through a crontab or in DBA_JOBS.
I believe that in 10g, this feature is new and by default executes every hour. Where dooes it get executed ? It does not appear to be in dba_jobs ?
and disable by exec dbms_scheduler.disable('GATHER_STATS_JOB')
DBA_HIST_WR_CONTROL - To see the snapshot interval and retention period
dba_hist_snapshot -Display a list of snapshots