Database Tuning (MOSC)

MOSC Banner

"User calls" vs "Executes (SQL)" in awr report

edited Jul 16, 2018 12:39PM in Database Tuning (MOSC) 8 commentsAnswered

Hello,

Can somebody pls help understand the difference between "User calls" & "Executes (SQL)" in AWR report.

I googled and found explanation for "User calls": it includes logins, parse, execute, fetch. But couldn't find anything on "Executes (SQL)". So I looked up a few AWR reports and it is close to the count of Executions in SQL Statistics section. But then what I do not understand is, shouldn't the "User calls" be a much higher number as compared to the "Executes (SQL)". In all AWR reports that I saw, "User calls" is anywhere between 1/3rd and 1/4th.

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center