Adjustment of Performance for the Application of PL/SQL

The oracle database system is the large relation database management system which is applied most broadly at present. The PL/SQL language is a sort of block structured language, and it is the procedural language that the Oracle extends SQL, and it allows encapsulating operation logics, and its advantage is to use inscribed SQL sentence to define and realize 3GL language structure and describe more complex query, trigger, memory process and other objectives. Therefore, to more reasonably use PL/SQL program can exert important function to implement the Oracle database performances. Through the adjustment of database shared pool and the introduction of different technologies of data access, we discussed some technologies to enhance the implementation performance of PL/SQL and optimize the performance of the database system by means of PL/SQL language.