Measuring PLSQL-SQL context switches

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 11 Sep 2008 23:15:23 +0800
Message-Id: <200809111515.m8BFFOZn032261@smtp17.singnet.com.sg>

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 ?

I can't seem to find a relevent statistic when I look at the list of statistics in the 10.2 Reference.

I know I could use timers to time the difference in execution time if I were to rewrite the PLSQL block but I would like to be able to measure and/or estimate the impact on execution time and/or CPU time given an existing piece of code .

Hemant K Chitale

http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 11 2008 - 10:15:23 CDT

Original text of this message