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 / perfstatSQL> @statsauto - using the default settings or perform a snapshot 3. per hour manually create (set flexibly the snapshot time interval) 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; / - Remove Timer Perform Snapshot Task Execute DBMS_JOB .remove ('JOB_ID');
