Statistics: The obvious “User Calls”

I’ve used and read the phrase “User Calls” so many times during the years working with Oracle. The term feels so obvious and self explanatory. But is it really? I just read this article by Craig Shallahammer (from 2010) explaining what the system statistic “User Calls” really includes, and I must say I was a little surprised.

I did not know User Calls is increased both for parse, execute and fetch. This way inserts, updates and deletes always (if not just parsed) causes User Calls to increment by 2. While a SELECT will always generate a minimum of 3 user calls (even if 0 rows are fetched). Also the commit and rollback generates 2 user calls (because of the parse and execute).

Post a Comment

Your email is never published nor shared. Required fields are marked *