Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_intro001.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>Tools for Tuning the Database</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="Tools for Tuning the Database" /> <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_intro.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_method.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_intro.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CEGIDBCD" name="CEGIDBCD"></a><a id="TDPPT005" name="TDPPT005"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Tools for Tuning the Database</h1> <a name="BEGIN" id="BEGIN"></a> <p>The intent of this guide is to allow you to quickly and efficiently tune and optimize the performance of Oracle Database.</p> <p>To achieve the goals of this guide, you will need to acquire the following products, tools<a id="sthref2" name="sthref2"></a>, features, and utilities:</p> <ul> <li> <p><span class="bold">Oracle Database 11</span><span class="bolditalic">g</span> <span class="bold">Enterprise Edition</span></p> <p>Oracle Database 11<span class="italic">g</span> Enterprise Edition offers enterprise-class performance, scalability and reliability on clustered and single-server configurations. It includes many performance features that are used in this guide.</p> </li> <li> <p><span class="bold">Oracle Enterprise Manager</span></p> <p>The primary tool to manage your database is Enterprise Manager, a Web-based interface. After you install the Oracle software, create or upgrade a database, and configure the network, you can use Enterprise Manager to manage your database. In addition, Enterprise Manager provides an interface for performance advisors and for database utilities, such as SQL*Loader and Recovery Manager (RMAN).</p> </li> <li> <p><span class="bold">Oracle Diagnostics Pack</span></p> <p>Oracle Diagnostics Pack offers a complete, cost-effective, and easy-to-use solution to manage the performance of Oracle Database environments by providing unique features, such as automatic identification of performance bottlenecks, guided problem resolution, and comprehensive system monitoring. Key features of Oracle Diagnostics Pack used in this guide include Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH).</p> </li> <li> <p><span class="bold">Oracle Database Tuning Pack</span></p> <p>Oracle Database Tuning Pack automates the database application tuning process, thereby significantly lowering database management costs while enhancing performance and reliability. Key features of Oracle Database Tuning Pack that are used in this guide include the following:</p> <ul> <li> <p>SQL Tuning Advisor</p> <p>This feature enables you to submit one or more SQL statements as input and receive output in the form of specific advice or recommendations for how to tune statements, along with a rationale for each recommendation and its expected benefit. A recommendation relates to collection of statistics on objects, creation of new indexes, restructuring of the SQL statements, or creation of SQL Profiles.</p> </li> <li> <p>SQL Access Advisor</p> <p>This feature enables you to optimize data access paths of SQL queries by recommending the proper set of materialized views and view logs, indexes, and partitions for a given SQL workload.</p> </li> </ul> </li> <li> <p><span class="bold">Oracle Real Application Testing</span></p> <p>Oracle Real Application Testing consists of the following key features:</p> <ul> <li> <p>Database Replay</p> <p>This feature enables you to capture the database workload on a production system, and replay it on a test system with the exact same timing and concurrency as the production system on the same or newer release of Oracle Database.</p> </li> <li> <p>SQL Performance Analyzer</p> <p>This feature enables you to assess the effect of system changes on SQL performance by identifying SQL statements that have regressed, improved, or remained unchanged.</p> </li> </ul> <p>See <a href="topicid:RATUG101">Introduction to Oracle Real Application Testing</a> to learn how to use these features.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>Some of the products and tools in the preceding list, including Oracle Diagnostics Pack and Oracle Database Tuning Pack, require separate licenses. For more information, see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=DBLIC','newWindow').focus()"><span class="italic">Oracle Database Licensing Information</span></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_intro.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method.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