| 数据库系统归档作业优化 |
| |
| 引用本文： | 江涛,赵婷,黄福明.数据库系统归档作业优化[J].宝钢技术,2010(6):25-27. |
| |
| 作者姓名： | 江涛 赵婷 黄福明 |
| |
| 作者单位： | 上海宝信软件股份有限公司,上海,201203;宝山钢铁股份有限公司,上海,200941 |
| |
| 摘 要： | 宝钢股份公司中厚板分公司厚板厂4200 mm轧机L2系统交工运行后,数据库归档作业存在设计缺陷,致使生产过程中出现归档作业异常致使数据库线程死锁,耗尽系统资源的情况发生,导致生产中断。针对这个问题,在原有归档作业的基础上,采取添加状态检测、加强数据库归档处理能力、优化数据库数据记录的清除作业等措施,使L2数据库归档作业能够在异常状态下,正确处理数据,避免对轧机L2系统产生影响,保证生产的稳定顺行。
|
| 关 键 词： | 数据库系统 数据归档作业 性能优化 |
Optimization of the Database Archive Job |
| |
| JIANG Tao,ZHAO Ting,HUANG Fuming.Optimization of the Database Archive Job[J].Baosteel Technology,2010(6):25-27. |
| |
| Authors: | JIANG Tao ZHAO Ting HUANG Fuming |
| |
| Affiliation: | JIANG Tao1,ZHAO Ting1 , HUANG Fuming2(1.Shanghai Baosight Software Co.,Ltd.,Shanghai 201203,China,2.Baoshan Iron & Steel Co.,Shanghai 200941,China) |
| |
| Abstract: | Since Baosteel 4 200 mm heavy plate mill's L2 system was in operation,there have existed some design bugs in the database archive jobs.It would make database sessions abnormal and result in the deadlock of the database threading.The bug would exhaust the resource of the operation system,make the L2 system down and the production fail.Based on the original design of the database archive job,it is advisable to take some measures,such as adding the status detection,enhancing the ability of data processing and ... |
| |
| Keywords: | database system data archive performance optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
