Bulk Binds in Oracle

Bulk Binds

Bulk binding decreases context switch between PL/SQL engine and SQL Engine that makes code execution faster. Context switch occurs every time when PL/SQL calls SQL engine to parse, execute or fetch from cursor. Since context switching uses CPU time, by reducing the number of context switching between engines increases performance of the program.