statspack auto starting/stopping
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: statspack auto starting/stopping

  1. #1
    Join Date
    Sep 2001
    Location
    London
    Posts
    26

    Wink

    Hi,

    I have configured Statspack on my dbase. I'm manually starting the collector on a daily basis using @spauto.sql. This is fine to an extent. I now want to start it automatically using a cron job and say run it between the peak operating hours of 9 and 5. I should be able to do this.

    However, I'm not sure about killing this job each night before the backup at 9pm. We have a cold backup in place which obviously stops it. I would ideally like to restart it the next day at 9am using cron.

    Has anyone else out there done this? or do you have any other ideas?

    Thanks in advance...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    spauto.sql sets up the job to run every hour on the hour. I don't think this is really what you want.

    What I would do is setup a cron job that executed statspack.snap inside a script. I would then schedule that script to run through the cron at the top of the hour between 09 and 17 every day.

    Note: I have setup a cron that runs evey hour on the hour, but it would be simple to modify it to only run certain hours. I prefer this method over dbms_job because I can track the job through an OS log file rather than dbms_job.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    London
    Posts
    26
    Hi there

    Thanks for that. I will try that out. Thats exactly what I want to do.

    I will let you know if I get into any odd problems.

    Later
    Bruce

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width