Re: In AWR, How can 'user calls' be < 'executes'/sec?
From: <fmhabash_at_gmail.com>
Date: Thu, 15 Oct 2009 12:09:50 -0400
Message-ID: <4AD7494E.1080300_at_gmail.com>
This explains it. thanks
---------- ----------
SQL> /
---------- ----------
Date: Thu, 15 Oct 2009 12:09:50 -0400
Message-ID: <4AD7494E.1080300_at_gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 15 2009 - 11:09:50 CDT