Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqltune012.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 a User-Defined Workload</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 a User-Defined Workload" /> <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_sqltune011.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqltune013.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_sqltune011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBBEJBGD" name="CBBEJBGD"></a><a id="TDPPT156" name="TDPPT156"></a></p> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h1>Loading SQL Statements from a User-Defined Workload</h1> <a name="BEGIN" id="BEGIN"></a> <p>You can load SQL statements by importing from a table or view. This technique is useful if the workload you want to analyze is not currently running on the database or captured in an existing AWR snapshot or AWR baseline.</p> <p>There are no restrictions on which schema the workload resides in, the name of the table, or the number of tables that you can define. The only requirement is that the format of the table must match format of the <code>USER_WORKLOAD</code> table.</p> <p class="orderedlisttitle">To load SQL statements from a user-defined workload: </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> field, select <span class="bold">User-Defined Workload</span>.</p> </li> <li> <p>In the <span class="bold">User-Defined Workload</span> field, select the table or view to include.</p> </li> <li> <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" --> <!-- class="sect3" --> <!-- 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_sqltune011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqltune013.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