Oracle DBA Question: Download Questions PDF
In PL/SQL, what is bulk binding, and when/how would it help performance?
Answer:
Oracle's SQL and PL/SQL engines are separate parts of the kernel which require context switching, like between unix processes. This is slow, and uses up resources. If we loop on an SQL statement, we are implicitely flipping between these two engines. We can minimize this by loading our data into an array, and using PL/SQL bulk binding operation to do it all in one go!
Download Oracle DBA Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are bind variables and why are they important? | Why is SQL*Loader direct path so fast? |