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.