Re: Measuring PLSQL-SQL context switches
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Thu, 11 Sep 2008 09:09:30 -0700
On Thu, Sep 11, 2008 at 8:15 AM, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx>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
Other related posts:
