Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\dbadm_topsql.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>About Top SQL</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Top SQL" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-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="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="sql_utl.htm" title="Using Oracle Application Ex..." type="text/html" /> <link rel="up" href="dbadm_montitor.htm" title="Monitoring the Database" type="text/html" /> <link rel="up" href="dbadm_topsql.htm" title="About Top SQL" type="text/html" /> <link rel="prev" href="dbadm_stats.htm" title="Previous" type="text/html" /> <link rel="next" href="dbadm_long_opr.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="sql_utl.htm" title="Using Oracle Application Ex...">Using Oracle Application Ex...</a> > <a href="dbadm_montitor.htm" title="Monitoring the Database">Monitoring the Database</a> > About Top SQL</p> <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="dbadm_stats.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="dbadm_long_opr.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBHJACJG" name="CBHJACJG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL280" id="AEUTL280"></a>About Top <a id="sthref350" name="sthref350"></a>SQL</h1> <p>The "top" SQL statements represent the SQL statements that are executed most often, that use more system resources than other SQL statements, or that use system resources more frequently than other SQL statements.</p> <p>Use the Top SQL page to identify poorly performing SQL.</p> <p>To view the Top SQL page:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon and then <span class="bold">Database Monitor</span>.</p> </li> <li> <p>Click <span class="bold">Top SQL</span>.</p> </li> <li> <p>If prompted, enter the appropriate administrator user name and password and click <span class="bold">Login</span>.</p> <p>The Top SQL page appears. Use the search fields and lists and the top of the page and click Go to narrow the display. For details on each field or list, click the Search label.</p> </li> <li> <p>To access the SQL Plan page, click the <span class="bold">View</span> icon.</p> <img src="img/view_icon.gif" alt="Description of view_icon.gif follows" title="Description of view_icon.gif follows" longdesc="img_text/view_icon.htm" /><br /> <a id="sthref351" name="sthref351" href="img_text/view_icon.htm">Description of the illustration view_icon.gif</a><br /> <br /> <p>The SQL Plan page appears, containing the following sections:</p> <ul> <li> <p><span class="bold">Query Plan</span> - Contains a color coded explain plan. Note that unindexed columns display in red.</p> </li> <li> <p><span class="bold">SQL Text</span> - Displays the full text of the SQL statement.</p> </li> <li> <p><span class="bold">Indexes</span> - Displays all indexes on the table in the query. There is a checkmark when that index is used in the query.</p> </li> <li> <p><span class="bold">Table Columns</span> - Shows all columns on all tables or views in the query.</p> </li> </ul> </li> </ol> </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 © 2003, 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="dbadm_stats.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="dbadm_long_opr.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