Tag Archives: Context Switch

Bulk Collect and Bulk Bind

Retrieve many row in single fetch and improve the speed of data retrieval by less context switch. Oracle server used two engine to run PL/SQL block and subprogram. 1) The PL/SQL   runtime engine , which  run  all procedural line of code but passes the SQL statement to the SQL engine. 2)The SQL engine parse and executes the SQL… Read More »