-
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.
-
-
read "Scheduling the Statspack Report" in below link....
http://www.troygeek.com/articles/Sta...01-Installing/
Rgds
Parag
-
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
Behind The Success And Failure Of A Man Is A Woman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|