Database Response Time Tuning Model
If you ask your users to describe performance, they will either describe it in terms of response time or throughput. When your users call you about performance problems, it is because they are unhappy with their process’s response time or throughput. They don’t call you because certain database ratio numbers are bad or some SQL statements are taking a lot of CPU time, having high buffer gets or causing a lot of physical disk reads. Frankly, they don’t care.
OWI plays a significant role in determining the database response time. The database response time consists of the “service time” and “wait time” as follows:
ResponseTime = ServiceTime + WaitTime
The service time is the amount of time a process spends on ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
