How do you optimise your pl/sql code?

How to optimise your pl/sql code? Not using explain plan which is for tuning the quey
  • Interview Candidate
  • 6
  • 7072

Showing Answers 1 - 6 of 6 Answers

ace1234567

  • Mar 4th, 2015
 

The best technique used is to avoid repeatative coding by putting repeated logic in a subroutine/function. Save the DML operations after a specific interval or records insertion/updation/deletions , depending on your archive log size.

  Was this answer useful?  Yes

Nikhil Inamdar

  • Jul 8th, 2016
 

You can use DBMS_PROFILER to check performance bottlenecks and then change the code where the PLSQL code is taking more time and improve performence.
For more details go through below link.
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_profil.htm

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions