RE: Measuring PLSQL-SQL context switches

Hemant,

Mark proposed 'recursive calls' as a metric. That's good. One minor problem is that there're two types of recursive SQLs, those you write (PL/SQL code in package, procedure, etc. and anonymous blocks, and even triggers), and those Oracle writes to get metadata from data dictionary. Oracle doesn't make a distinction anywhere. If your benchmark has thousands or millions of context switches, Oracle's own internal recursive SQLs become negligible. Just don't flush shared pool in the middle.

While you measure 'recursive calls', you can also measure 'recursive cpu usage'.

Yong Huang       

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