RE: Measuring PLSQL-SQL context switches

From: Yong Huang <>
Date: Fri, 12 Sep 2008 10:54:05 -0700 (PDT)
Message-ID: <>


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       

Received on Fri Sep 12 2008 - 12:54:05 CDT

Original text of this message