You need DBMS_JOB to schedule and execute PL/SQL procedures at predefined times or at regular intervals, such as routine maintenance procedures or developer batch jobs.
The three INIT.ORA parameters that affect DBMS_JOB are:
Since only one concurrent process is allowed, the second job must wait until the first job is complete.
No, it’s not possible. Every started job establishes a lock in the V$LOCK table to ...