1.
alert system set job_queue_processes = 10;
alert system set job_queue_processes = 10 scope=both;
alter system set Timed_statistics=true;
2.
connect perfstat/perfstat
SQL>@statsauto --使用默认设置为每小时执行一次快照
3.或使用手工创建(灵活设置执行快照所间隔的时间)
connect perfstat/perfstat
variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
commit;
end;
/
--移除定时执行快照任务
execute dbms_job.remove('job_id');
使statspack自动收集系统状况
最新推荐文章于 2021-04-11 22:45:57 发布