Hello,
Below is a query
SELECT SUM (c.VALUE)
FROM v$session a, v$sesstat c, v$statname d
WHERE a.SID = c.SID
AND c.statistic# = d.statistic#
AND d.NAME = 'CPU used by this session'
AND a.status = 'ACTIVE';
This query will tell me cpu consumption by individual session. But the question is : what does the value represent? is it a time factor, or just an octal number, i mean, what exactly it is?
I could not find any elaborative reference on this column(or any column under v$sesstat) anywhere in Oracle documentation.
Thanks,
R