CAJ | 학술논문

针对多数据库系统环境数据库的集中监控与管理，设计一个多数据库系统的监控方案，通过读取系统表、系统视图以及执行脚本等方法实现对数据库DBMS、表空间和死锁的监控，并给出预警设置，当数据库指标超过规定指标时，以颜色预警提示或者以发邮件的形式提示报警。通过创建DBLINK来连接多个数据库，以实现对多个位于不同数据库服务器上的数据库系统进行监控。
침대다수거고계통배경수거고적집중감공여관리，설계일개다수거고계통적감공방안，통과독취계통표、계통시도이급집행각본등방법실현대수거고DBMS、표공간화사쇄적감공，병급출예경설치，당수거고지표초과규정지표시，이안색예경제시혹자이발유건적형식제시보경。통과창건DBLINK래련접다개수거고，이실현대다개위우불동수거고복무기상적수거고계통진행감공。
For centralized monitoring and management of multi-database environment, design a multi-database system monitoring program. To achieve control of the database DBMS, table space and deadlocks by reading the system tables, system views, and execute scripts and other methods, when the database when the index exceeds the index to color warning prompt or in the form of e-mail prompt alarm. By creating DBLINK to connect multiple databases, in order to achieve a plurality of database systems located on different database servers to be monitored.