One great benefit of
using the v$sess_time_model view is that it allows the quick
identification of what part of the session's processing work spend
the most time.
using the v$sess_time_model view is that it allows the quick
identification of what part of the session's processing work spend
the most time.
select
b.username,
a.stat_name,
round((a.value
/1000000,3) time secs
/1000000,3) time secs
from
v$sess_time_model a,
v$sess_time_model a,
v$session b
where a.sid = b.sid
and b.sid =123
order by 3 desc,
This query has been
taken from the Oracle Tuning Book by Donald K.Burleson
taken from the Oracle Tuning Book by Donald K.Burleson
