SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Context switches in oracle pl sql

Badam123Nov 1 2017 — edited Nov 1 2017

I have some SQL's(without any functions being called ) inside a Procedure , if we execute the procedure will there be context switching when the SQL statements execute ?

How much overhead does the Context switching generally cause for a SQL statement which returns 1000 rows with one simple function being called?

This post has been answered by Cookiemonster76 on Nov 1 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2017

Added on Nov 1 2017

#plsql, #sql

8 comments

821 views