Oracle DBA Interview Question:

In PL/SQL, what is bulk binding, and when/how would it help performance?

Submitted by: Administrator

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!
Submitted by: Administrator