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.
retention => 43200, -- Minutes (= 30 Days). Current value retained if NULL.
interval => 2); -- Minutes. Current value retained if NULL.
Thx for your info.
I noticed that our setting has the following:
PROCEDURE modify_snapshot_settings(retention IN NUMBER DEFAULT NULL,
interval IN NUMBER DEFAULT NULL,
topnsql IN NUMBER DEFAULT NULL,
dbid IN NUMBER DEFAULT NULL
A snapshot appears to be taken every hour. How can this be based on the above procedure ?
Are you guys executing it through crontab then?
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 ?
It appears in database job scheduler tasks.
In dba_scheduler_jobs view, I have the following jobs:
I do not see anything related to dbms_workload_repository_snapshot. However, the job is executed every hour. How could this be ?
have you tried changing from OEM DBC or GC what ever you have?
Try hard to get what you like OR you will be forced to like what you get.
This job is enabled by default
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
Last edited by Rayyah; 11-22-2009 at 10:52 AM.
Click Here to Expand Forum to Full Width