Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_method009.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>Tuning the Database Proactively</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="Tuning the Database Proactively" /> <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_method008.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_method010.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_method008.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method010.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHJFHBJ" name="CIHJFHBJ"></a><a id="TDPPT492" name="TDPPT492"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Tuning the Database Proactively</h1> <a name="BEGIN" id="BEGIN"></a> <p>This section lists and describes the proactive steps required to keep the database properly tuned on a regular basis. Perform these steps as part of your daily maintenance of Oracle Database. Repeat the tuning process until your performance goals are met or become impossible to achieve because of other constraints.</p> <p class="orderedlisttitle">To tune the database proactively<a id="sthref39" name="sthref39"></a><a id="sthref40" name="sthref40"></a>: </p> <ol> <li> <p>Review the ADDM findings, as described in <a href="tdppt_auto.htm#CHDEBDAJ">Automatic Database Performance Monitoring</a>.</p> <p>ADDM automatically detects and reports on performance problems with the database, including most of the <a href="tdppt_method012.htm#i11221">"Common Performance Problems Found in Oracle Databases"</a>. The results are displayed as ADDM findings on the Database Home page in Oracle Enterprise Manager (Enterprise Manager). Reviewing these findings enables you to quickly identify the performance problems that require your attention.</p> </li> <li> <p>Implement the ADDM recommendations, as described in <a href="tdppt_auto.htm#CHDEBDAJ">Automatic Database Performance Monitoring</a>.</p> <p>ADDM automatically provides a list of recommendations for reducing the impact of the performance problem with each ADDM finding. Implementing a recommendation applies the suggested changes to improve the database performance.</p> </li> <li> <p>Monitor performance problems with the database in real time, as described in <a href="tdppt_realtime.htm#CHDIHEBJ">Monitoring Real-Time Database Performance</a>.</p> <p>The Performance page in Enterprise Manager enables you to identify and respond to real-time performance problems. By drilling down to the appropriate pages, you can identify and resolve performance problems with the database in real time, without having to wait until the next ADDM analysis.</p> </li> <li> <p>Respond to performance-related alerts, as described in <a href="tdppt_alerts.htm#BEIDDIIG">Monitoring Performance Alerts</a>.</p> <p>The Database Home page in Enterprise Manager enables you to view performance-related alerts generated by the database. Typically, these alerts reveal performance problems whose resolutions will improve the database performance.</p> </li> <li> <p>Validate that any changes made have produced the desired effect, and verify that the users perceive performance improvements.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_method007.htm#CIHFFHBI">Using the Oracle Performance Method</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_method008.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method010.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