Re: In AWR, How can 'user calls' be < 'executes'/sec?

  • From: "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>
  • To: Tanel Poder <tanel@xxxxxxxxxx>
  • Date: Thu, 15 Oct 2009 12:09:50 -0400

This explains it. thanks

This immediately after logon
##############################
      SID STATISTIC# NAME                                    VALUE
---------- ---------- ---------------------------------------------------------------- ----------
      110        6 user calls                                   16
      110        7 recursive calls                                  119
      110      436 execute count                                   11

then, after executing plsql block
#############################
SQL> /

      SID STATISTIC# NAME                                    VALUE
---------- ---------- ---------------------------------------------------------------- ----------
      110        6 user calls                                   17
      110        7 recursive calls                                 1121
      110      436 execute count                                 1012




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


Other related posts: