Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\ratug\spa_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>Capturing the SQL Workload</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T10:50:31Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Capturing the SQL Workload" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E12254-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="spa_intro.htm" title="Previous" type="text/html" /> <link rel="next" href="spa_intro002.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="spa_intro.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_intro002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDFCBDC" name="CHDFCBDC"></a><a id="RATUG167" name="RATUG167"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Capturing the SQL Workload</h1> <a name="BEGIN" id="BEGIN"></a> <p>Before running <a id="sthref36" name="sthref36"></a>SQL Performance Analyzer, capture a set of SQL statements on the production system that represents the SQL workload which you intend to analyze.</p> <p>The captured SQL statements should include the following information:</p> <ul> <li> <p>SQL text</p> </li> <li> <p>Execution environment</p> <ul> <li> <p>SQL binds, which are bind values needed to execute a SQL statement and generate accurate execution statistics</p> </li> <li> <p>Parsing schema under which a SQL statement can be compiled</p> </li> <li> <p>Compilation environment, including initialization parameters under which a SQL statement is executed</p> </li> </ul> </li> <li> <p>Number of times a SQL statement was executed</p> </li> </ul> <p>Capturing a SQL workload has a negligible performance impact on your production system and should not affect throughput. A SQL workload that contains more SQL statements will better represent the state of the application or database. This will enable SQL Performance Analyzer to more accurately forecast the potential impact of system changes on the SQL workload. Therefore, you should capture as many SQL statements as possible. Ideally, you should capture all SQL statements that are either called by the application or are running on the database.</p> <p>You can store captured SQL statements in a SQL tuning set and use it as an input source for SQL Performance Analyzer. A SQL tuning set<a id="sthref37" name="sthref37"></a> is a database object that includes one or more SQL statements, along with their execution statistics and execution context. SQL statements can be loaded into a SQL tuning set from different sources, including the cursor cache, Automatic Workload Repository (AWR), and existing SQL tuning sets. Capturing a SQL workload using a SQL tuning set enables you to:</p> <ul> <li> <p>Store the SQL text and any necessary auxiliary information in a single, persistent database object</p> </li> <li> <p>Populate, update, delete, and select captured SQL statements in the SQL tuning set</p> </li> <li> <p>Load and merge content from various data sources, such as the Automatic Workload Repository (AWR) or the cursor cache</p> </li> <li> <p>Export the SQL tuning set from the system where the SQL workload is captured and import it into another system</p> </li> <li> <p>Reuse the SQL workload as an input source for other advisors, such as the SQL Tuning Advisor and the SQL Access Advisor</p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="topicid:TDPPT162">Creating a SQL Tuning Set</a> for information about creating SQL tuning sets using Oracle Enterprise Manager</p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=PFGRF02604','newWindow').focus()"><span class="italic">Oracle Database Performance Tuning Guide</span></a> for information about creating SQL tuning sets using APIs</p> <p><a href="spa_intro.htm#CHDGEIIA">Introduction to SQL Performance Analyzer</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 © 2008, 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="spa_intro.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="spa_intro002.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