Re: Measuring PLSQL-SQL context switches

On Thu, Sep 11, 2008 at 8:15 AM, Hemant K Chitale <hkchital_at_singnet.com.sg>wrote:

>
> Is there a method to measure or estimate the impact of context switches
> when executing SQL inside a PLSQL block -- particularly when the PLSQL
> block runs the same SQL statement very many times inside a loop ?
>
>

This discussion has been held a few times, though not perhaps on this list.

Defining what you think a context switch is in PL/SQL might be a good place to start.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l