DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Statspack/spauto.sql

  1. 01-22-2008, 07:11 AM #1
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77

    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.
    Reply With Quote Reply With Quote
  2. 01-22-2008, 08:23 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Yes
    Reply With Quote Reply With Quote
  3. 01-22-2008, 08:33 AM #3
    paragp1981
    paragp1981 is offline Member
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    read "Scheduling the Statspack Report" in below link....

    http://www.troygeek.com/articles/Sta...01-Installing/
    Rgds
    Parag
    Reply With Quote Reply With Quote
  4. 01-23-2008, 08:35 AM #4
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    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.
    Reply With Quote Reply With Quote
  5. 01-25-2008, 09:17 AM #5
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    I followed the instructions given in the doc and it worked. Thanks again.
    Reply With Quote Reply With Quote
  6. 01-27-2008, 02:08 AM #6
    yxez
    yxez is offline Advisor
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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