Re: Measuring PLSQL-SQL context switches
Date: Thu, 11 Sep 2008 09:09:30 -0700
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-lReceived on Thu Sep 11 2008 - 11:09:30 CDT