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?


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 QuestionNext Question
How can a function retun more than one value in oracle with proper example?What is the basic structure of PL/SQL?