摘要
针对目前电网企业的ORACLE数据库运行时间增加,数据库中会产生大量的碎片,影响应用程序运行的速度。本文介绍一种自动化进行ORACLE数据库碎片检查与整理的方法,通过该方法实现的工具可广泛用于ORACLE碎片整理,该工具将以往的人工碎片检查与整理转换为自动化检查与整理,缩短了工时,提高了准确性,避免人为操作的失误。
In view of the increasing running time of ORACLE database in power grid enterprises,a large number of fragments will be generated in the database,which will affect the speed of application running.An automatic method is infroduced for checking and collating table fragments in ORACLE database.The tool realized by this method can be widely used in ORACLE fragmentation.The tool transforms the previous manual fragmentation inspection and collation into automatic inspection and collation,shortens the working hours,improves accuracy and avoids the loss of manual operation.Mistake.
作者
杨永娇
YANG Yongjiao(Guangdong Power Grid Co.,Ltd.MGuangzhou Guangdong 510000,China)
出处
《自动化与仪器仪表》
2019年第8期223-226,共4页
Automation & Instrumentation
基金
广东电网有限责任公司信息中心科技项目“面向立体防御的移动应用安全关键技术研究与应用”(037800KK52180001)