RE: How do I turn off STATSPACK auto snapshots on 8.1.7

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <ldk2005@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 14 Sep 2005 15:52:43 -0700

spauto.sql runs the snapshots through a job, so you could look up the job 
number in user_jobs, then disable it or remove it with the dbms_jobs procedure, 
execute dbms_jobs.disable(1);

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Larry Kelly
Sent: Wednesday, September 14, 2005 7:33 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: How do I turn off STATSPACK auto snapshots on 8.1.7

I want use STATSPACK as part of my tuning strategy.  The spauto.sql script will 
schedule periodic snapshots.  I'm hesitant to start it until I know how to stop 
the automatic snapshots.  

Best Regards,
"Work, work, work...there is no satisfactory alternative."
            --- E.Taft Benson 

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: