Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqltune004.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>Managing SQL Tuning Sets</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="Managing SQL Tuning Sets" /> <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_sqltune003.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqltune005.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_sqltune003.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune005.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBBGEAJI" name="CBBGEAJI"></a><a id="TDPPT164" name="TDPPT164"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Managing SQL Tuning Sets</h1> <a name="BEGIN" id="BEGIN"></a> <p>A <span class="bold">SQL Tuning Set</span><a id="sthref277" name="sthref277"></a> is a database object that includes one or more SQL statements and their execution statistics and context. You can use the set as an input for advisors such as SQL Tuning Advisor, SQL Access Advisor, and SQL Performance Analyzer. You can load SQL statements into a SQL Tuning Set from different SQL sources, such as AWR, the cursor cache, or high-load SQL statements that you identify.</p> <p>A SQL Tuning Set includes the following:</p> <ul> <li> <p>A set of SQL statements</p> </li> <li> <p>Associated execution context such as:</p> <ul> <li> <p>User schema</p> </li> <li> <p>Application module name and action</p> </li> <li> <p>List of bind values</p> </li> <li> <p>Cursor compilation environment</p> </li> </ul> </li> <li> <p>Associated basic execution statistics such as:</p> <ul> <li> <p>Elapsed time and CPU time</p> </li> <li> <p>Buffer gets</p> </li> <li> <p>Disk reads</p> </li> <li> <p>Rows processed</p> </li> <li> <p>Cursor fetches</p> </li> <li> <p>Number of executions and number of complete executions</p> </li> <li> <p>Optimizer cost</p> </li> <li> <p>Command type</p> </li> </ul> </li> <li> <p>Associated execution plans and row source statistics for each SQL statement (optional)</p> </li> </ul> <p>SQL statements can be filtered using the application module name and action, or any of the execution statistics. In addition, SQL statements can be ranked based on any combination of execution statistics.</p> <p>SQL Tuning Sets are transportable, enabling SQL workloads to be transferred between databases for remote performance diagnostics and tuning. When high-load SQL statements are identified on a production system, it may not be desirable to perform investigation and tuning activities directly on this system. This feature enables you to transport the high-load SQL statements to a test system, where they can be safely analyzed and tuned. For information about transporting SQL Tuning Sets, see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=PFGRF','newWindow').focus()"><span class="italic">Oracle Database Performance Tuning Guide</span></a>.</p> <p>Using Enterprise Manager, you can manage SQL Tuning Sets by doing the following:</p> <ul> <li> <p><a href="tdppt_sqltune005.htm#CHDFABIG">Creating a SQL Tuning Set</a></p> </li> <li> <p><a href="tdppt_sqltune015.htm#CBBFDADC">Dropping a SQL Tuning Set</a></p> </li> <li> <p><a href="tdppt_sqltune016.htm#CBBFCEAA">Transporting SQL Tuning Sets</a></p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_sqltune.htm#CAEBFCFJ">Tuning SQL Statements</a></p> </div> <!-- 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_sqltune003.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune005.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de