What is the key time model statistics that is gathered by the Automatic Workload Repository?

What is the key time model statistics that is gathered by the Automatic Workload Repository?

What is the key time model statistics that is gathered by the Automatic Workload Repository?

A.
Query time

B.
User response time

C.
Database time

D.
Wait event time

Explanation:
The most important of the time model statistics is DB time. This statistics represents
the total time spent in database calls and is a indicator of the total instance workload.
Reference:Overview of the Automatic Workload Repository,Time Model Statistics



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Chow, Kenneth KY

Chow, Kenneth KY

Time Model Statistics

DB Time represents total time in user calls
DB CPU represents CPU time of foreground processes
Total CPU Time represents foreground and background processes
Statistics including the word “background” measure background process time, therefore do not contribute to the DB time statistic
Ordered by % of DB time in descending order, followed by Statistic Name