Oracle Jobs

Create 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;