⟩ 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.