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

Larry,  

U can delete the job from the scheduled job list if using OEM else use DBMS_JOB.REMOVE (<<job_id>>) procedure to remove it from the list if don't want to execute the job. Another option could be setting the value of BROKEN as true or yes(not sure for the value, plz. Check ) which will stop the execution of the job. Remember to perform this activity u need to connect as perfstat and execute privilege on DBMS_JOB package.  

Thanks & Regards,  

T.Onkar Nath

Oracle DBA

Extn. : 2269

email : onkar.tiwari_at_in.ness.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Larry Kelly
Sent: Wednesday, September 14, 2005 8:03 PM To: Oracle-L_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 15 2005 - 00:04:45 CDT