On an Oracle data server system, where there is generally only one application
running, the server runs database activity in user space. Activities required to service
database requests (such as scheduling, synchronization, I/O, memory management,
and process/thread creation and tear down) run in kernel mode. In a system where all
CPU is fully utilized, a healthy Oracle system runs between 65% and 95% in user
space.
The V$OSSTAT view captures machine level information in the database, making it
easier for you to determine if there are hardware level resource issues. The
V$SYSMETRIC_HISTORY view shows a one-hour history of the Host CPU Utilization
metric, a representation of percentage of CPU usage at each one-minute interval. The
V$SYS_TIME_MODEL view supplies statistics on the CPU usage by the Oracle
database. Using both sets of statistics enable you to determine whether the Oracle
database or other system activity is the cause of the CPU problems.

当cpu全利用的时候,健康的Oracle系统用到用户空间的65%-95%
V$SYSMETRIC_HISTORY收集了cpu一个小时的利用情况

[@more@]

ITPub博客

CPU Statistics

最新文章