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

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

针对产销系统响应过慢、占用系统资源过多问题,通过对后台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.