摘要： 阐述了Oracle8作业队列的工作原理,并介绍了Oracle8数据库调度作业的方法。针对由于移动通信网络管理系统中数据量大且数据来源复杂而造成的数据库作业调度难于管理和Oracle中SNP进程资源有限的问题,分析了网管系统中采集数据的特点,提出了在一个SNP进程中运行多个存储过程的设计方案,使数据库中的作业调度更加系统、有序,有效地提高了系统的运行效率。

关键词: 作业调度, 存储过程, SNP进程

Abstract: This paper describes the theory and scheduler method of oracle 8 job queue.Based on the characteristic of collection data,it puts forward a design architecture of executing several stored procedures in a SNP process,which solves the problem of limited SNP processes and difficulties in job management caused by a great amout of data and complicated data sources in mobile network management system,makes schedulers of job queue more systemic and improves the efficiency of running system.

中图分类号: 

• TP311.13