Adjustment of Performance for the Application of PL/SQL


  •  Erjun Chen    
  •  Shaohong Yin    

Abstract

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.


This work is licensed under a Creative Commons Attribution 4.0 License.
  • ISSN(Print): 1913-8989
  • ISSN(Online): 1913-8997
  • Started: 2008
  • Frequency: quarterly

Journal Metrics

WJCI (2020): 0.439

Impact Factor 2020 (by WJCI): 0.247

Google Scholar Citations (March 2022): 6907

Google-based Impact Factor (2021): 0.68

h-index (December 2021): 37

i10-index (December 2021): 172

(Click Here to Learn More)

Contact