Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_realtime021.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 Memory 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 Memory 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_realtime020.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_realtime022.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_realtime020.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime022.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDFAGCD" name="CHDFAGCD"></a><a id="TDPPT043" name="TDPPT043"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Monitoring Memory Utilization</h1> <a name="BEGIN" id="BEGIN"></a> <p>Operating system performance issues commonly involve process management, memory management, and scheduling. This section describes how to monitor memory utilization and identify problems such as paging and swapping.</p> <p class="orderedlisttitle">To monitor memory utilization<a id="sthref157" name="sthref157"></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">Memory Details</span> from the View list.</p> <p>The Memory Details view of the Performance subpage appears.</p> <p>This view contains statistics about memory utilization, page scan rates, and swap utilization gathered over the last hour. The top 10 processes are also listed ordered by memory utilization.</p> </li> <li> <p>Verify the current memory page scan rate using the Memory Page Scan Rate chart.</p> <p>The current value of the memory page scan rate is displayed below the chart. On UNIX and Linux, this value represents the number of pages scanned per second. On Microsoft Windows, this value represents the rate at which pages are read from or written to disk to resolve hard page faults. This value is a primary indicator of the kinds of faults that may be causing systemwide delays.</p> </li> <li> <p>Click <span class="bold">Memory Scan Rate</span>.</p> <p>The Memory Page Scan Rate page appears.</p> <p>This page contains memory page scan rate statistics and related alerts 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 memory performance problem might exist.</p> </li> <li> <p>Verify the current memory utilization using the Memory Utilization chart.</p> <p>The Memory Utilization chart shows how much memory is being used. The current value of memory utilization is displayed below the chart. During standard workload hours, the value should not exceed the warning threshold (shown in yellow).</p> </li> <li> <p>Click <span class="bold">Memory Utilization</span>.</p> <p>The Memory Utilization page appears.</p> <p>This page contains memory 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 a memory performance problem might exist.</p> </li> <li> <p>Verify current swap utilization using the Swap Utilization chart.</p> <p>The Swap Utilization<a id="sthref158" name="sthref158"></a> chart shows how much swap space is being used. The current value of swap utilization is displayed below the chart. During normal workload hours, the value should not exceed the warning threshold.</p> </li> <li> <p>Click <span class="bold">Swap Utilization</span>.</p> <p>The Swap Utilization page appears.</p> <p>This page contains swap 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 a memory performance problem might exist.</p> </li> <li> <p>Return to the Memory Details view of the Host Performance subpage and review the top processes in the Top 10 Processes (ordered by Memory) table.</p> <p>If a process is taking up too much memory, then this process should be investigated.</p> </li> <li> <p>If a memory performance problem<a id="sthref159" name="sthref159"></a><a id="sthref160" name="sthref160"></a> is identified, you can attempt to resolve the issue by doing the following:</p> <ul> <li> <p>Use Automatic Memory Management to automatically manage and distribute memory between the System Global Area (SGA) and the aggregate program global area (PGA aggregate).</p> </li> <li> <p>Use the Memory Advisor to set SGA and PGA memory target values.</p> </li> <li> <p>Use Automatic PGA Management to manage SQL memory execution.</p> </li> <li> <p>Avoid running too many processes that use a lot of memory.</p> </li> <li> <p>Reduce paging or swapping.</p> </li> <li> <p>Reduce the number of open cursors and hard parsing with cursor sharing.</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=ADMIN11011','newWindow').focus()"><span class="italic">Oracle Database Administrator's Guide</span></a> for information about using Automatic Memory Management</p> <p><a href="topicid:ADMQS1034">Optimizing Memory Usage with the Memory Advisors</a> for information about using the Memory Advisor</p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=PFGRF014','newWindow').focus()"><span class="italic">Oracle Database Performance Tuning Guide</span></a> for information about resolving memory issues</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_realtime020.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime022.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