Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> statspack auto starting/stopping
I have configured Statspack on my hp-ux 8.1.7.1.0 Oracle 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... Received on Thu Apr 04 2002 - 08:45:27 CST