Display Session details with time model data.

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.

select

b.username,

a.stat_name,

round((a.value
/1000000,3) time secs

from
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