Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_realtime020.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Monitoring CPU Utilization</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-05-27T15:13:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Monitoring CPU Utilization" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10822-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdppt_realtime019.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_realtime021.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdppt_realtime019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime021.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDFEGDA" name="CHDFEGDA"></a><a id="TDPPT042" name="TDPPT042"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Monitoring CPU Utilization</h1> <a name="BEGIN" id="BEGIN"></a> <p>To address CPU problems, first establish appropriate expectations for the amount of CPU resources your system should be using. You can then determine whether sufficient CPU resources are available and recognize when your system is consuming too many resources. This section describes how to monitor CPU utilization.</p> <p class="orderedlisttitle">To monitor CPU utilization<a id="sthref150" name="sthref150"></a>: </p> <ol> <li> <p>From the Database Home page, under Host CPU, click the <span class="bold">Load</span> link.</p> <p>The Host page appears, showing the Performance subpage.</p> </li> <li> <p>Select <span class="bold">CPU Details</span> from the View list.</p> <p>The CPU Details view appears.</p> <p>This view contains statistics about CPU utilization, I/O wait times, and load gathered over the last hour. The top 10 processes are listed based on CPU utilization.</p> </li> <li> <p>Verify the current CPU utilization using the CPU Utilization chart.</p> <p>The CPU Utilization chart shows CPU utilization over the last hour. The current value is displayed below the chart. During standard workload hours, the value should not exceed the critical threshold.</p> </li> <li> <p>Click <span class="bold">CPU Utilization</span>.</p> <p>The CPU Utilization page appears.</p> <p>This page contains CPU utilization statistics and related alerts generated over the last 24 hours.</p> <p>If you notice an unexpected spike in this value that is sustained through normal workload hours, then the CPU performance problem should be investigated.</p> </li> <li> <p>Verify the current CPU I/O wait time using the CPU I/O Wait chart.</p> <p>The CPU I/O Wait chart shows CPU I/O wait time over the last hour. The current value is displayed below the chart. During normal workload hours, the value of CPU I/O wait should not exceed the warning threshold.</p> <p>CPU I/O wait<a id="sthref151" name="sthref151"></a> represents the average number of jobs waiting for I/O during an interval.</p> </li> <li> <p>Click <span class="bold">CPU I/O Wait</span>.</p> <p>The CPU in I/O Wait page appears.</p> <p>This page contains CPU I/O wait statistics and related alerts generated over the last 24 hours.</p> <p>If you notice an unexpected spike in this value that is sustained through standard workload hours, then a CPU performance problem might exist.</p> </li> <li> <p>Verify the current CPU load using the CPU Load chart.</p> <p>The CPU Load chart shows the CPU load over the last hour. The current value is displayed below the chart. During standard workload hours, the value of CPU load should not exceed the warning threshold.</p> <p>CPU load<a id="sthref152" name="sthref152"></a> represents the average number of processes waiting to be scheduled for CPU resources in the previous minute, or the level of CPU contention time over time.</p> </li> <li> <p>Click <span class="bold">CPU Load</span>.</p> <p>The Run Queue Length page appears.</p> <p>This page contains CPU load statistics and related alerts generated over the last 24 hours.</p> <p>If you notice an unexpected spike in this value that is sustained through normal workload hours, then a CPU performance problem might exist.</p> </li> <li> <p>Return to the CPU Details view of the Host Performance subpage and review the Top 10 Processes table.</p> <p>If a process is consuming too much of the CPU utilization percentage, then this process should be investigated.</p> </li> <li> <p>If a CPU performance problem<a id="sthref153" name="sthref153"></a><a id="sthref154" name="sthref154"></a> is identified, then you can try to resolve the issue by doing the following:</p> <ul> <li> <p>Use Oracle <a id="sthref155" name="sthref155"></a>Database Resource Manager to reduce the impact of peak-load-use patterns by prioritizing CPU resource allocation</p> </li> <li> <p>Avoid running too many processes that use a lot of CPU</p> </li> <li> <p>Increase hardware capacity, including changing the system architecture</p> </li> </ul> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=PFGRF016','newWindow').focus()"><span class="italic">Oracle Database Performance Tuning Guide</span></a> for information about resolving CPU issues</p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ADMIN027','newWindow').focus()"><span class="italic">Oracle Database Administrator's Guide</span></a> for information about Oracle Database Resource Manager</p> <p><a href="tdppt_realtime019.htm#CHDEBIAA">Monitoring Host Activity</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdppt_realtime019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime021.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de