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

It's pretty easy to get user calls to be less than executes, if you
submit the following pl/sql block, for example:

begin
        for i in 1 .. 1000
        loop
                for cur in (select null from dual)
                loop
                        null;
                end loop;
        end loop;
end;

that would be one user call and 1000+ executes. In fact, in certain
cases you may use this to see how "chatty" the app is, i.e. how much
"work" is being done per call.

On Wed, Oct 14, 2009 at 1:28 PM, Fmhabash <fmhabash@xxxxxxxxx> wrote:
> I've always seen it the other way around. Made sense since 'executes' are a 
> subset of 'user calls'.
> What kind of a load would generate such stats?
>
>
>
> ---------------
> Thank You.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>



-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Other related posts: