Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

Question:how to avoid performance problems in PL/SQL.


  1. Use FORALL instead of FOR, and use BULK COLLECT to avoid looping many times
  2. - Tune SQL statements to avoid CPU overhead
  3. - Use NOCOPY for OUT and IN OUT if the original value need not be retained. Overhead of keeping a copy of OUT is avoided.
  4. - Reorder conditional tests to put least expensive ones first
  5. - Minimize datatype conversions => Assign data to exact same type variables
  6. - Use PLS_INTEGER for computation intensive code. NUMBER, INTEGER maintain precision and scale but not optimized for performance as additional checks are made to maintain precision and scale.
  7. - Do not use subtypes like POSITIVE, NATURAL, INTEGER as they have additional checks
  8. - Use BINARY_FLOAT, BINARY_DOUBLE
  9. - EXECUTE IMMEDIATE is faster than DBMS_SQL

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes
13 views



Related Hot Questions



Government Jobs Opening


...