Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$sesstat.value on 10g

Rich VApr 24 2010 — edited Apr 24 2010
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
This post has been answered by sb92075 on Apr 24 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2010
Added on Apr 24 2010
10 comments
2,092 views