Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stopping Statspack snap to run automatically

Madhu.149Oct 5 2012 — edited Oct 5 2012

Hello All,

The statspack snap is being executed automatically every 15minutes. I want to stop this process.

SQL> select * from user_jobs;

no rows selected

column begin_interval_time format A25
column END_interval_time format A25

SELECT snap_id, begin_interval_time, end_interval_time
FROM dba_hist_snapshot
ORDER BY 1
/

   SNAP_ID BEGIN_INTERVAL_TIME       END_INTERVAL_TIME
---------- ------------------------- -------------------------
       205 05-OCT-12 11.30.55.051 AM 05-OCT-12 11.45.07.392 AM
       206 05-OCT-12 11.45.07.392 AM 05-OCT-12 12.00.07.900 PM
       207 05-OCT-12 12.00.07.900 PM 05-OCT-12 12.15.08.347 PM
       208 05-OCT-12 12.15.08.347 PM 05-OCT-12 12.30.08.808 PM
       209 05-OCT-12 12.30.08.808 PM 05-OCT-12 12.45.09.325 PM
       210 05-OCT-12 12.45.09.325 PM 05-OCT-12 01.00.09.806 PM
       211 05-OCT-12 01.00.09.806 PM 05-OCT-12 01.15.10.277 PM
       212 05-OCT-12 01.15.10.277 PM 05-OCT-12 01.30.01.823 PM
       213 05-OCT-12 01.30.01.823 PM 05-OCT-12 01.45.01.743 PM

How to stop the statspack snap being taken automatically?

This post has been answered by EdStevens on Oct 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2012

Added on Oct 5 2012

#general-database-discussions

5 comments

1,823 views