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!

What is cpu_time in v$sqlarea

108225Nov 21 2003 — edited Nov 21 2003

Hi,

I am trying to balance the cpu_time column found in v$sqlarea compared with cpu_used_by_this_session found in v$sysstat. I am finding that the cpu_time numbers in v$sqlarea far exceed the value in v$sysstat by a huge factor.

To try and qualify the cpu_time for a given piece of SQL I used the following formula:

CPU Hours = cpu_time / 100 / 60 / 60 / cpu_count

I end up with a value of 4600 hours for a piece of SQL that ran in less then 24 hours. The value for this single piece of SQL dwarfs the total cpu time shown in v$sysstat.

I'm very confused. Any help or clarification on cpu_time within v$sqlarea would be greatly appreciated.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2003

Added on Nov 21 2003

#general-database-discussions

8 comments

1,250 views