SQL Performance (MOSC)

MOSC Banner

Quantifying End user experience

edited Aug 15, 2015 10:00AM in SQL Performance (MOSC) 5 commentsAnswered

Hi ,

We are optimizing sql queries and want to quantity end-user/business user's experience improvement after improving query execution. But we find a query is taking 6 seconds to execute from awr report, but the screen which is triggering the query is loading in 2 seconds. My questions are:-

i) How can this be possible?

ii) How can we quantify end-user response time improvement due to sql optiization?

iii) What things I need to check to explain this scenario?

Thanks

Tagged:

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