Statspack/spauto.sql

Hello,

Happy new year to all.

I am exploring the tuning techniques and tools available on Oracle 9i and there is this script called spauto.sql that one can use to automate the statistics gathering. My problem is that, it collects the statistics every hour. Is there a way to change it to say...every 15 mins or ... every 4 hrs?

Thanks in advance.

Yes

read "Scheduling the Statspack Report" in below link....

http://www.troygeek.com/articles/Sta...01-Installing/

Quote:

---

Originally Posted by hrishy

Yes

---

THAT is the answer.:) Thank God Para read my mind. I will try and be more thorough in my next posts. Thanks for the reminder and thanks for the link Para.

I followed the instructions given in the doc and it worked. Thanks again.

Hi friends :) this is my first time to learn statspack too, is the above link install procedure runs on all db versions (8i,9i,10g,11g)?


Thanks a lot