Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqltune010.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>Loading SQL Statements from AWR Snapshots</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="Loading SQL Statements from AWR Snapshots" /> <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_sqltune009.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqltune011.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_sqltune009.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune011.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBBGICCD" name="CBBGICCD"></a><a id="TDPPT169" name="TDPPT169"></a></p> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h1>Loading SQL Statements from AWR Snapshots</h1> <a name="BEGIN" id="BEGIN"></a> <p>You can load SQL statements captured in AWR snapshots. This is useful when you want to collect SQL statements for specific snapshot periods of interest that can be used for later comparison or tuning purposes.</p> <p class="orderedlisttitle">To load SQL statements from AWR snapshots: </p> <ol> <li> <p>On the Create SQL Tuning Set: Load Methods page, select <span class="bold">Load statements one time only</span>.</p> </li> <li> <p>In the <span class="bold">Data Source</span> list, select <span class="bold">AWR Snapshots</span>.</p> </li> <li> <p>In the <span class="bold">AWR Snapshots</span> field, select the snapshots to include. Do one of the following:</p> <ul> <li> <p>Select either <span class="bold">ALL</span> or a time period such as <span class="bold">Last 24 hours</span> and then go to Step <a href="#CACCEBEE">5</a>.</p> <p>Only snapshots that are captured and stored in AWR in the specified time will be included.</p> </li> <li> <p>Select <span class="bold">Customize</span> and then go to Step <a href="#CACGCDCJ">4</a>.</p> <p>Only snapshots that are captured and stored in AWR during a customized time period that you specify will be included.</p> </li> </ul> </li> <li><a id="CACGCDCJ" name="CACGCDCJ"></a> <p>To select a customized time period of snapshots, complete the following steps:</p> <ol> <li> <p>Select <span class="bold">Customize</span> and then click <span class="bold">Go</span>.</p> <p>The Select Time Period window opens.</p> </li> <li> <p>For the starting snapshot, select <span class="bold">Period Start Time</span> and then click the snapshot icon below the Active Session graph that corresponds to the desired start time.</p> </li> <li> <p>For the ending snapshot, select <span class="bold">Period End Time</span> and then click the snapshot icon below the Active Session graph that corresponds to the desired end time.</p> </li> <li> <p>Click <span class="bold">Select</span>.</p> </li> </ol> </li> <li><a id="CACCEBEE" name="CACCEBEE"></a> <p>Click <span class="bold">Next</span>.</p> <p>The Create SQL Tuning Set: Filter Options page is shown.</p> </li> <li> <p>Proceed to the next step, as described in <a href="tdppt_sqltune013.htm#CBBDDHFG">"Creating a SQL Tuning Set: Filter Options"</a>.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_sqltune005.htm#CHDFABIG">Creating a SQL Tuning Set</a></p> <p><a href="tdppt_sqltune007.htm#CBBFGJFI">Creating a SQL Tuning Set: Load Method</a></p> </div> </div> <!-- class="sect4" --> <!-- 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_sqltune009.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune011.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