relationship between statistics in time model(10G)

除了如下包含关系,同一level的statistics也有部分包含也被包含的关系.比如DB CPU包含了harse的CPU, sql execute elapsed time 包含了部分 DB CPU

1) background elapsed time
      2) background cpu time
1) DB time
    2) DB CPU
    2) connection management call elapsed time
    2) sequence load elapsed time
    2) sql execute elapsed time
    2) parse time elapsed
          3) hard parse elapsed time
                4) hard parse (sharing criteria) elapsed time
                    5) hard parse (bind mismatch) elapsed time
          3) failed parse elapsed time
                4) failed parse (out of shared memory) elapsed time
    2) PL/SQL execution elapsed time
    2) inbound PL/SQL rpc elapsed time
    2) PL/SQL compilation elapsed time
    2) Java execution elapsed time

ref: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2087.htm#G2030340

发表评论

电子邮件地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>