ITPub博客

首页 > 数据库 > Oracle > oracle占用os的cpu资源的多少算是健康的!

oracle占用os的cpu资源的多少算是健康的!

原创 Oracle 作者:warehouse 时间:2008-05-21 22:30:26 0 删除 编辑
从下面的doc理解,如果单一的应用程序跑在oracle数据库服务器上,那么(

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.

)oracle对系统cpu的利用如果在user cpu(应用程序使用cpu的百分比)的65% ~95%之间,则oralcle system被认为是健康的。

e文不好,不知理解的是否准确!

[@more@]
CPU Statistics

CPU utilization is the most important operating system statistic in the tuning process. Get CPU utilization for the entire system and for each individual CPU on multi-processor environments. Utilization for each CPU can detect single-threading and scalability issues.

Most operating systems report CPU usage as time spent in user space or mode and time spent in kernel space or mode. These additional statistics allow better analysis of what is actually being executed on the CPU.

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.


Note:

On UNIX systems, where wait for I/O is derived for part of the CPU statistics, this value should be treated as idle time.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1004389/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle time_zone!
请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5115567