产销系统后台Oracle数据库优化设计与实现  

Optimized Design and Implementation of Backstage Oracle Database in Production and Marketing System

作　　者：刘泽辉[1] LIU Ze-hui(Tianjin Tiantie Metallurgy Group Co.,Ltd.,Hebei 05640)

机构地区：[1]天津天铁冶金集团技术中心,河北涉县056404

出　　处：《天津冶金》2018年第3期40-41,共2页Tianjin Metallurgy

摘　　要：针对产销系统响应过慢、占用系统资源过多问题,通过对后台Oracle数据库的SGA内存区和Oracle后台处理进程的调整、对SQL语句进行优化设计,缩短了响应时间,提高了响应速度。Aiming at the problems that the production and marketing system response is too slow and takes up too much system resources, by adjusting the SGA memory area of the background Oracle database and the Oracle background processing process, and optimizing the SQL statement, the response time of the production and marketing system is shortened and the response speed is improved.

关 键 词：产销系统 ORACLE数据库 优化 索引 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]