RE: Measuring PLSQL-SQL context switches
Date: Fri, 12 Sep 2008 10:54:05 -0700 (PDT)
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 HuangReceived on Fri Sep 12 2008 - 12:54:05 CDT