Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqlid002.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>Identifying High-Load SQL Statements Using Top SQL</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="Identifying High-Load SQL Statements Using Top SQL" /> <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_sqlid001.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqlid003.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_sqlid001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlid003.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABECDJG" name="BABECDJG"></a><a id="TDPPT142" name="TDPPT142"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Identifying High-Load SQL Statements Using Top SQL</h1> <a name="BEGIN" id="BEGIN"></a> <p>ADDM automatically identifies high-load SQL statements that may be causing systemwide performance degradation. Under normal circumstances, manual identification of high-load SQL statements is not necessary. In some cases, however, you may want to monitor SQL statements at a more granular level. The Top SQL section<a id="sthref238" name="sthref238"></a><a id="sthref239" name="sthref239"></a> of the Top Activity page in Enterprise Manager enables you to identify high-load SQL statements for any 5-minute interval.</p> <p class="orderedlisttitle">To access the Top Activity page: </p> <ol> <li> <p>From the Database Home page, click <span class="bold">Performance</span>.</p> <p>The Performance page appears.</p> </li> <li> <p>Under Additional Monitoring Links, click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('TOP_ACTIVITY');"><span class="bold">Top Activity</span></a>.</p> <p>The Top Activity page<a id="sthref241" name="sthref241"></a> appears.</p> <p>This page shows a 1-hour time line of the top activity running on the database. SQL statements that are using the highest percentage of database activity are listed under the Top SQL section, and are displayed in 5-minute intervals.</p> </li> <li> <p>To move the 5-minute interval, drag the shaded box to the desired time.</p> <p>The information contained in the Top SQL section will be automatically updated to reflect the selected time period. Use this page to identify high-load SQL statements that may be causing performance problems.</p> </li> <li> <p>To monitor SQL statements for a longer duration than one hour, select <span class="bold">Historical</span> from the View Data list.</p> <p>In Historical view, you can view the top SQL statements for the duration defined by the AWR retention period.</p> </li> </ol> <p>This section contains the following topics:</p> <ul> <li> <p><a href="tdppt_sqlid003.htm#CHDHJBGI">Viewing SQL Statements by Wait Class</a></p> </li> <li> <p><a href="tdppt_sqlid004.htm#CHDCAJCB">Viewing Details of SQL Statements</a></p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_sqlid.htm#BABFHBFJ">Identifying High-Load SQL Statements</a></p> </div> <!-- 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_sqlid001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlid003.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de