What is database response time in Oracle

Database Response time in Top 10 Foreground Events in AWR report

Basic definition of Database Response Time means Service Time plus Wait time.

Response Time = Service Time(execution time) + Wait Time

Service time is the time spent on CPU for Processing.

Wait Time is the time which the resources is waiting for other resource to be free before processed by the CPU. Wait Time is the sum of time spent on wait events

In the AWR example, we have CPU time 62.8 % and rest is waiting time 100-62.8 = 37.2 %. We need to reduce the waiting time of the Oracle Database, We found from above awr example, USER I/O wait class is the main which causing the waiting time like Direct Path read, db file scattered read, db file sequential read, log file sync.

We need to tune the event one by one for tuning our Oracle Database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.