oracle佔用os的cpu資源的多少算是健康的!

warehouse發表於2008-05-21
從下面的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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章