基于PL/SQL的Oracle数据库性能优化

Optimization of Oracle Database Based on PL/SQL

Oracle数据库系统是目前应用最广泛的大型关系数据库管理系统。PL/SQL是Oracle对结构化查询语言SQL扩展的过程性语言,用于从各种环境中访问Oracle数据库。通过对SQL命令的执行增加程序逻辑,PL/SQL可以在数据库上描述更加复杂的查询、触发器、存储过程等其他对象。因此合理应用PL/SQL对充分发挥Oracle数据库的各项优势起到了重要的作用。文章简要介绍了PL/SQL,探讨了通过对SQL语句的查询优化、存储过程和共享池的使用等技术优化Oracle数据库系统性能的方法。

Oracle database system is large relation database management of system which is applied extensively.PL/SQL is an expanded procedural language to SQL for visiting the Oracle database from the every kind of environment inside.By adding the procedural logic to SQL command, PL/SQL can describe more complicated query, trigger,stored procedure on database.So it is important to give full play to advantage of Oracle database system by using reasonably PL/SQL.PL/SQL is introduced briefly.Gives some discussions about how to optimize performance of Oracle database by using SQL,stored procedure and shared pool.