Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqlopt017.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: Summary</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: Summary" /> <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_sqlopt016.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqlopt018.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_sqlopt016.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt018.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHFEGAH" name="CIHFEGAH"></a><a id="TDPPT188" name="TDPPT188"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Reviewing the SQL Access Advisor Recommendations: Summary</h1> <a name="BEGIN" id="BEGIN"></a> <p>The Summary subpage displays an overview of the SQL Access Advisor analysis.</p> <p class="orderedlisttitle">To review the recommendations summary<a id="sthref331" name="sthref331"></a>: </p> <ol> <li> <p>On the Results for Tasks page, click <span class="bold">Summary</span>.</p> <p>The Summary subpage of the Results for Tasks page appears.</p> </li> <li> <p>Under Overall Workload Performance, assess the potential for improvement in implementing the recommendations.</p> </li> <li> <p>Use the Workload I/O Cost chart to compare the original workload I/O cost with the new cost.</p> </li> <li> <p>Use the Query Execution Time Improvement chart to compare the improvement in query execution time.</p> <p>This chart shows the percentage of SQL statements in the workload whose execution time will improve by accepting the recommendations. The SQL statements are grouped by the projected improvement factor along the horizontal axis on the chart (1x to >10x). The percentage of SQL statements that will improve by the projected improvement factor are along the vertical axis (0% to 100%).</p> </li> <li> <p>Under Recommendations, click <span class="bold">Show Recommendation Action Counts</span>.</p> </li> <li> <p>Under SQL Statements, click <span class="bold">Show Statement Counts</span> to display the type of SQL statement.</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_sqlopt016.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt018.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