Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_manual001.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>Manually Running ADDM to Analyze Current Database Performance</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:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Manually Running ADDM to Analyze Current Database Performance" /> <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_manual.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_manual002.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_manual.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_manual002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDGGEBG" name="CHDGGEBG"></a><a id="TDPPT051" name="TDPPT051"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Manually Running ADDM to Analyze Current Database Performance</h1> <a name="BEGIN" id="BEGIN"></a> <p>By default, ADDM runs every hour to analyze snapshots taken by AWR during this period<a id="sthref179" name="sthref179"></a>. In some cases you may notice performance degradation that did not exist in the previous ADDM analysis period, or a sudden spike in database activity on the Performance page, as described in <a href="tdppt_realtime.htm#CHDIHEBJ">Monitoring Real-Time Database Performance</a>. If the next ADDM analysis is not scheduled to run for 30 minutes, then you can run ADDM manually to identify and resolve the performance problem.</p> <p>When you run ADDM manually, a manual AWR snapshot is created automatically. This manual run may affect the ADDM run cycle. For example, if you scheduled ADDM to run hourly at the start of each hour and the last ADDM run was at 8:00 p.m., running ADDM manually at 8:30 p.m. causes the next scheduled run to start at 9:30 p.m., not 9:00 p.m. Subsequent ADDM runs will continue on the new run cycle, occurring hourly at the half-hour instead of the start of each hour.</p> <p class="orderedlisttitle">To analyze current database performance by manually running ADDM<a id="sthref181" name="sthref181"></a>: </p> <ol> <li> <p>On the Database Home page, under Related Links, click <span class="bold">Advisor</span> <span class="bold">Central</span>.</p> <p>The Advisor Central page appears.</p> </li> <li> <p>Under Advisors, click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('ADDM_RUN');"><span class="bold">ADDM</span></a>.</p> <p>The Run ADDM page appears.</p> </li> <li> <p>Select <span class="bold">Run ADDM to analyze current instance performance</span> and click <span class="bold">OK</span>.</p> <p>The Confirmation page appears.</p> </li> <li> <p>Click <span class="bold">Yes</span>.</p> <p>The Processing: Run ADDM Now page appears while the database takes a new AWR snapshot.</p> <p>An ADDM run occurs for the time period between the new and the previous snapshot. After ADDM completes the analysis, the Automatic Database Diagnostic Monitor (ADDM) page appears with the results.</p> </li> <li> <p>Click <span class="bold">View Report</span>.</p> <p>The View Report page appears.</p> </li> <li> <p>Optionally, click <span class="bold">Save to File</span> to save the results of the ADDM task in a report for later access.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_auto011.htm#CHDCGBHB">Reviewing the Automatic Database Diagnostic Monitor Analysis</a></p> <p><a href="tdppt_manual.htm#CHDHGBIC">Manual Database Performance Monitoring</a></p> </div> </div> <!-- class="sect1" --> <!-- 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_manual.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_manual002.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