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,
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.
Other related posts:
