Question:
I would like to get db time percentage for every
sql_id as I can see in AWR report. Is there a way to get
this db time information from the AWR?
Answer: : The
db time metric is the amount of elapsed time spent
performing Database user-level calls.
The db time percentage for a SQL statement indicates the
cumulative time that is spent processing user requests, so the
db time percentage is a system metric.
For a SQL statement, the db time does not really apply
because
db time is a system-level metric:
Statistic Name Time (s) Percent of Total DB Time
---------------------------------- --------
------------------------
DB time
169
sql execute elapsed time
156 93
DB
CPU 153 90
PL/SQL execution elapsed time
77 46
background cpu
time 53 31
parse time
elapsed 6 4
hard
parse elapsed time 4 3
connection management call elapsed time 0 0
