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, e.g.: execute dbms_jobs.disable(1); Regards, Brandon -----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, -Larry "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.