..if we issue a dml from within a plsql block ..suppose a statement like ..delete from employee where emp_id>1001 . so is it like this statement is sent >to the sql engine , a row is deleted and an acknowledgement is sent to plsql engine.another row is deleted and the same thing is repeated. This is >why we say we should avoid context switching between plsql and sql using bulk bindings...There are 2 Engines - SQL Engine & PL/SQL Engine.
Rahul K wrote:In your examples, a "context switch" is just PL/SQL calling the SQL engine.
...does the context switching happens for each row manipulated by the sql engine ? or is it a statement level process.
.i.e. if i issue a delete statement from plsql which deletes 10 rows. so the context switching would be at the statement level or at the row level .....i.e. 10 times of a single time...