Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqlopt018.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>Reviewing the SQL Access Advisor Recommendations: Recommendations</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:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Reviewing the SQL Access Advisor Recommendations: Recommendations" /> <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_sqlopt017.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqlopt019.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_sqlopt017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt019.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHCIEAG" name="CIHCIEAG"></a><a id="TDPPT189" name="TDPPT189"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Reviewing the SQL Access Advisor Recommendations: Recommendations</h1> <a name="BEGIN" id="BEGIN"></a> <p>The Recommendations subpage ranks the SQL Access Advisor recommendations by cost improvement. You can also view details about each recommendation.</p> <p class="orderedlisttitle">To review recommendation details<a id="sthref333" name="sthref333"></a>: </p> <ol> <li> <p>On the Results for Tasks page, click <span class="bold">Recommendations</span>.</p> <p>The Recommendations subpage appears.</p> </li> <li> <p>Use the Recommendations by Cost Improvement chart to view recommendations ordered by the cost improvement.</p> <p>Under Select Recommendations for Implementation, each recommendation is listed with its implementation status, recommendation ID, cost improvement, space consumption, and the number of affected SQL statements for each recommendation. Implementing the top recommendation will have the biggest benefit to the total performance of the workload.</p> </li> <li> <p>To view details for a particular recommendation, select the recommendation and click <span class="bold">Recommendation Details</span>.</p> <p>The Recommendation Details page appears.</p> <p>The Recommendation Details page displays all actions for the specified recommendation.</p> <p>Under Actions, you can choose to modify the schema name, tablespace name, and storage clause for each action. To view the SQL text of an action, click the link in the Action column for the specified action.</p> <p>Under SQL Affected by Recommendation, the SQL text of the SQL statement and cost improvement information are displayed.</p> </li> <li> <p>Click <span class="bold">OK</span>.</p> <p>The Recommendations subpage appears.</p> </li> <li> <p>To view the SQL text of a recommendation, select the recommendation and click <span class="bold">Show SQL</span>.</p> <p>The Show SQL page for the selected recommendation appears.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_sqlopt016.htm#CHDFDJEH">Reviewing the SQL Access Advisor Recommendations</a></p> </div> </div> <!-- class="sect2" --> <!-- 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_sqlopt017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt019.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