Chapter 25. DBMS_JOB Built-in Package
Beginner
Q: | |
25-1. | 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. |
Q: | |
25-2. | The three INIT.ORA parameters that affect DBMS_JOB are:
|
Q: | |
25-3. | Since only one concurrent process is allowed, the second job must wait until the first job is complete. |
Q: | |
25-4. | No, itâs not possible. Every started job establishes a lock in the V$LOCK ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.