Oracle JobsCreate a job to run every 15 minutes to execute statspack.snap
First login as the user who is suppose to run the job, then run the following.
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'statspack.snap;'
,next_date => sysdate
,interval => 'TRUNC(SYSDATE+15/1440,''MI'')'
,no_parse => TRUE
,force => TRUE
);
END;
/
set job queue to zero
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
|