Re: Measuring PLSQL-SQL context switches

From: Jared Still <>
Date: Thu, 11 Sep 2008 09:09:30 -0700
Message-ID: <>

On Thu, Sep 11, 2008 at 8:15 AM, Hemant K Chitale <>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

Received on Thu Sep 11 2008 - 11:09:30 CDT

Original text of this message