it-rex
asked on
statspack scheduling
We want statspack to take snapshots every 15 minutes excluding during the window starting midnight until 7am, at this h time we would like snapshots taken every 2 hours(midnight, 2, 4 and 6).
ASKER
a. dbms_schedule to schedule a job or
I need the code for that.
I need the code for that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how about crontab?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>how about crontab?
You can use it but do you really want to involve the OS to perform a database activity? If you use dbms_scheduler, everything is contained inside the databsae.
You can use it but do you really want to involve the OS to perform a database activity? If you use dbms_scheduler, everything is contained inside the databsae.
ASKER
thanks all
In 10g you can use dbms_workload_repository package with
a. dbms_schedule to schedule a job or
b. make entry in cronjob.