Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_degrade011.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>Comparing a Baseline to Another Baseline or Pair of Snapshots</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="Comparing a Baseline to Another Baseline or Pair of Snapshots" /> <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_degrade010.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_degrade012.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_degrade010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_degrade012.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CACBGDCI" name="CACBGDCI"></a><a id="TDPPT137" name="TDPPT137"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Comparing a Baseline to Another Baseline or Pair of Snapshots</h1> <a name="BEGIN" id="BEGIN"></a> <p>When performance degradation occurs over time, you can run the AWR Compare Periods report to compare the degraded performance, captured as a new baseline or a pair of snapshots, to an existing baseline. You must have a baseline that represents the system operating at an optimal level. If an existing baseline is unavailable, then compare database performance between two periods of time using two arbitrary pairs of snapshots, as described in <a href="tdppt_degrade012.htm#CACDFJFC">"Comparing Two Pairs of Snapshots"</a>.</p> <p class="orderedlisttitle">To compare a baseline to another baseline<a id="sthref222" name="sthref222"></a><a id="sthref223" name="sthref223"></a>: </p> <ol> <li> <p>From the Database Home page, click <span class="bold">Server</span>.</p> <p>The Server subpage appears.</p> </li> <li> <p>Under Statistics Management, click <span class="bold">Automatic Workload Repository</span>.</p> <p>The Automatic Workload Repository page appears.</p> </li> <li> <p>Under Manage Snapshots and Baselines, click the link next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('AWR_BASELINES_MAIN');"><span class="bold">Baselines</span></a>.</p> <p>The AWR Baselines page appears.</p> </li> <li> <p>Complete the following steps:</p> <ol> <li> <p>Select the baseline to use for the report.</p> <p>At least one existing baseline must be available.</p> </li> <li> <p>From the Actions list, select <span class="bold">Compare Periods</span> and click <span class="bold">Go</span>.</p> </li> </ol> <p>The Compare Periods: Second Period Start page appears. Under First Period, the selected baseline is displayed.</p> </li> <li> <p>Compare the baseline selected in the first period to another baseline or a pair of snapshots. Do one of the following:</p> <ul> <li> <p>To compare to another baseline, select <span class="bold">Select a Baseline</span> and the baseline you want to use in the second period, and then click <span class="bold">Next</span>.</p> <p>The Compare Periods: Review page appears. Go to Step <a href="#CACEFBFG">7</a>.</p> </li> <li> <p>To compare to a pair of snapshots, select <span class="bold">Select Beginning Snapshot</span> and the beginning snapshot to use in the second period, and then click <span class="bold">Next</span>.</p> <p>The Compare Periods: Second Period End appears. Proceed to the next step.</p> </li> </ul> </li> <li> <p>Select the ending snapshot for the snapshot period that will be included in the report and then click <span class="bold">Next</span>.</p> <p>The Compare Periods: Review page appears.</p> </li> <li><a id="CACEFBFG" name="CACEFBFG"></a> <p>Review the periods to be included in the report and then click <span class="bold">Finish</span>.</p> <p>The Compare Periods: Results page appears.</p> <p>Data from the selected periods appears under the General subpage. You can view data per second or per transaction by selecting an option from the View Data list.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>If the time periods have different lengths, then the data is normalized over database time before calculating the difference so that periods of different lengths can be compared.</p> </div> </li> <li> <p>Click <span class="bold">Report</span> to view the report.</p> <p>The Processing: View Report page appears while the report is being generated. After it completes, the report will appear. To change periods, click <span class="bold">Change Periods</span>. To save the report as an HTML file<a id="sthref224" name="sthref224"></a>, click <span class="bold">Save to File</span>.</p> </li> <li> <p>Optionally, do the following:</p> <ul> <li> <p>To change periods, click <span class="bold">Change Periods</span>.</p> </li> <li> <p>To save the report as an HTML file<a id="sthref225" name="sthref225"></a>, click <span class="bold">Save to File</span>.</p> </li> </ul> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_degrade002.htm#CIHDHEAA">Creating a Baseline</a></p> <p><a href="tdppt_degrade013.htm#BABBIDDA">Using the AWR Compare Periods Reports</a></p> <p><a href="tdppt_degrade010.htm#CACGCJDC">Running the AWR Compare Periods Reports</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_degrade010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_degrade012.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