ORACLE中安装STATSPACK步骤

zidong

　　SQL>select job,log_user,priv_user,last_date,next_date,interval from user_jobs; --先查看当前自动收集的jobs
　　SQL> execute dbms_job.remove('1');  --移除任务1
　　删除统计资料（statspack相关的所有系统表）
　　SQL>select max(snap_id) from stats$snapshot;
　　SQL> @C:\oracle\ora92\rdbms\admin\sptrunc.sql;
　　Warning
　　~~~~~~~
　　Running sptrunc.sql removes ALL data from Statspack tables. You may
　　wish to export the data before continuing.
　　About to Truncate Statspack Tables
　　~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
　　If you would like to continue, press
　　输入 return 的值:
　　Entered - starting truncate operation