Open AccessArchitecture and Design of Oracle Scheduler
Author(s) -
Jimin Liu
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1769/1/012030
Subject(s) - oracle , computer science , scheduling (production processes) , oracle unified method , architecture , software engineering , distributed computing , database , engineering , world wide web , operations management , art , query by example , visual arts , web search query , search engine
Oracle scheduler focuses on the automatic management, maintenance and monitoring of Oracle database jobs. Through it, many routine database tasks can be automatically executed, and human intervention can be reduced, so as to improve the efficiency of system operation and implement more flexible and complex task management. This paper introduces the concept and classification of Oracle scheduler, analyzes each component of Oracle scheduler, explains its overall architecture and tasks of different components, summarizes the problems needing attention in design according to design experience, and illustrates its application through the creation of Oracle scheduler object instance, job scheduling and evaluation of execution frequency.