Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_transient012.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>Activity Over Time</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="Activity Over Time" /> <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_transient011.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_degrade.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_transient011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_degrade.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="DAFBFDAE" name="DAFBFDAE"></a><a id="TDPPT088" name="TDPPT088"></a></p> <div class="sect2"> <h1>Activity Over Time</h1> <a name="BEGIN" id="BEGIN"></a> <p>The Activity Over Time section<a id="sthref200" name="sthref200"></a> of the ASH report is particularly useful for longer time periods because it provides in-depth details about activities and workload profiles during the analysis period. The Activity Over Time section is divided into <span class="bold">time slots</span>. The ASH report time span is divided into 10 time slots unless the time period is short or the data is sparse.</p> <p>Each time slot contains session and wait event activity, as described in <a href="#DAFECIIA">Table: Activity Over Time</a>.</p> <div class="tblformal"><a id="TDPPT419" name="TDPPT419"></a><a id="sthref201" name="sthref201"></a><a id="DAFECIIA" name="DAFECIIA"></a> <p class="titleintable">Activity Over Time</p> <table class="Formal" title="Activity Over Time" summary="Describes the columns in the Activity Over Time section of the ASH report" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t14">Column</th> <th align="left" valign="bottom" id="r1c2-t14">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t14" headers="r1c1-t14"> <p>Slot Time (Duration)</p> </td> <td align="left" headers="r2c1-t14 r1c2-t14"> <p>Duration of the slot</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t14" headers="r1c1-t14"> <p>Slot Count</p> </td> <td align="left" headers="r3c1-t14 r1c2-t14"> <p>Number of sampled sessions in the slot</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t14" headers="r1c1-t14"> <p>Event</p> </td> <td align="left" headers="r4c1-t14 r1c2-t14"> <p>Top three wait events in the slot</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t14" headers="r1c1-t14"> <p>Event Count</p> </td> <td align="left" headers="r5c1-t14 r1c2-t14"> <p>Number of ASH samples waiting for the wait event</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t14" headers="r1c1-t14"> <p>% Event</p> </td> <td align="left" headers="r6c1-t14 r1c2-t14"> <p>Percentage of ASH samples waiting for wait events in the entire analysis period</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>All inner slots are the same number of minutes each for easy comparison. The first and last slots, called <span class="bold">outer slots</span>, are odd-sized because they do not have a fixed slot time.</p> <p>When comparing the inner slots, perform a skew analysis by identifying spikes. A spike in the Slot Count column indicates an increase in active sessions and a relative increase in database workload. A spike in the Event Count column indicates an increase in the number of sampled sessions waiting for an event. Typically, when the number of active session samples and the number of sessions associated with a wait event increase, the slot may be the cause of the transient performance problem.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_transient003.htm#DAFGDAJC">Active Session History Reports</a></p> </div> </div> <!-- class="sect2" --> <!-- class="sect1" --> <!-- 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_transient011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_degrade.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