Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule statspack job to run with interval of 10 minutes and run it every hour

SaurabhchNov 18 2015 — edited Nov 19 2015

Hi,

I have scheduled a statspack job in my 11g RAC DB. I want to run this job every every hour and to create 2 snapshots with a difference of 10 minutes. For example i want the runs to be like this

HH:MM:SS

1:00:00

1:10:00

2:00:00

2:10:00

3:00:00

3:10:00

Please help me with this.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2015

Added on Nov 18 2015

#database-key-features, #scheduler

10 comments

3,060 views