Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am studying the v$sysmetric view from Oracle and trying to understand what is Oracle's interpretation of "Host CPU Utilization"

It says in the metric_unit as % busy/(idle + busy), but what is busy? Is that the sum of usr + sys time? I tried comparing the query results from v$sysmetric against output from mpstat but it didn't seem to match.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

The figures in the v$sysmetric view are aggregated from v$osstat over a period of time (either 15 or 60 seconds).

v$osstat figures should closely mirror what you'd see from a tool such as iostat, sar, mpstat, top or nmon, but they will never be identical as it is impossible to synchronise the performance monitoring tool data collection with the data collection performed by the Oracle MMON process. As a result, the aggregated data in v$sysmetric will also never perfectly match monitoring tool output, but should be pretty close.

Busy% is indeed Usr% + Sys%.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.