Oracle PL-SQL Question: Download Questions PDF
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Answer:
For improving performance, we need to check the sql statement blocks , because for every sql satement execution transfor to sql engine and come back to plsq engine that process takes more time to process the plsql block.
Download Oracle PL-SQL Interview Questions And Answers
PDF
Previous Question | Next Question |
How can a function retun more than one value in oracle with proper example? | What is the basic structure of PL/SQL? |