Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_realtime001.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>Monitoring User Activity</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:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Monitoring User Activity" /> <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_realtime.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_realtime002.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_realtime.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDEIBAB" name="CHDEIBAB"></a><a id="TDPPT034" name="TDPPT034"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Monitoring User Activity</h1> <a name="BEGIN" id="BEGIN"></a> <p>The Average Active Sessions chart of the Performance page shows the average load on the database. For example, if 20 sessions currently exist in a database, but only 2 are active at a specific time, then the number of active sessions at this time will be 2. The chart shows which active sessions are running on the CPU or waiting on an event.</p> <p>By following the performance method explained in <a href="tdppt_method.htm#CIHIEGEC">Oracle Database Performance Method</a>, you can drill down from the charts to identify the cause of instance-related performance issues and resolve them.</p> <p class="orderedlisttitle">To monitor user activity: </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>Locate the spikes in the Average Active Sessions chart.</p> <p>Each component shows the average number of active sessions in the specified state for the specified time. For example, if only one session were active, then the value .8 for CPU would mean that the session consumed CPU in 4 of 5 sampled seconds around the target time. The Maximum CPU equals the number of CPUs on the system. When the CPU Used value reaches the Maximum CPU line, the database instance is running at 100 percent of CPU time on the host system.</p> <p>The wait classes show how much database activity is consumed by waiting for a resource such as disk I/O. Values that use a larger block of active sessions represent bottlenecks caused by a particular wait class, as indicated by the corresponding color in the legend.</p> </li> <li> <p>To identify each wait class, move your cursor over the block in the Average Active Sessions chart corresponding to the class.</p> <p>The corresponding wait class is highlighted in the chart legend.</p> </li> <li> <p>Click the largest block of color on the chart or its corresponding wait class in the legend to drill down to the wait class with the most active sessions.</p> <p>If you click <span class="bold">CPU Used</span>, then the Active Sessions Working page for the wait class appears. If you click a different wait class, such as <span class="bold">User I/O</span>, then the Active Sessions Waiting page appears.</p> <p>The Active Sessions Working page shows a 1-hour time line. Details for each wait class are shown in 5-minute intervals under Detail for Selected 5 Minute Interval.</p> <p>You can view the details of wait classes in different dimensions by proceeding to one of the following sections:</p> <ul> <li> <p><a href="tdppt_realtime002.htm#CHDCFFHE">"Monitoring Top SQL"</a></p> </li> <li> <p><a href="tdppt_realtime003.htm#CHDEFEEH">"Monitoring Top Sessions"</a></p> </li> <li> <p><a href="tdppt_realtime004.htm#CHDJEGHG">"Monitoring Top Services"</a></p> </li> <li> <p><a href="tdppt_realtime005.htm#CHDFJFBJ">"Monitoring Top Modules"</a></p> </li> <li> <p><a href="tdppt_realtime006.htm#CHDCDIBG">"Monitoring Top Actions"</a></p> </li> <li> <p><a href="tdppt_realtime007.htm#CBBGBJHB">"Monitoring Top Clients"</a></p> </li> <li> <p><a href="tdppt_realtime008.htm#CBBDJABH">"Monitoring Top PL/SQL"</a></p> </li> <li> <p><a href="tdppt_realtime009.htm#CBBDGJHH">"Monitoring Top Files"</a></p> </li> <li> <p><a href="tdppt_realtime010.htm#CBBHFAHB">"Monitoring Top Objects"</a></p> </li> </ul> </li> <li> <p>To change the time selected interval, move the slider below the chart to a different interval.</p> <p>The information contained in the Detail for Selected 5 Minute Interval section is automatically updated to display the selected time period.</p> </li> <li> <p>If you discover a performance problem, then you can attempt to resolve it in real time. On the Performance page, do one of the following:</p> <ul> <li> <p>Click a snapshot below the chart that corresponds to the time when the performance problem occurred to run ADDM for that time period.</p> <p>For information about ADDM analysis, see <a href="tdppt_auto011.htm#CHDCGBHB">"Reviewing the Automatic Database Diagnostic Monitor Analysis"</a>.</p> </li> <li> <p>Create a snapshot manually by clicking <span class="bold">Run ADDM Now</span>.</p> <p>For information about creating snapshots manually, see <a href="tdppt_auto009.htm#CIHHBFGG">"Creating Snapshots"</a>. For information about running ADDM manually, see <a href="tdppt_manual001.htm#CHDGGEBG">"Manually Running ADDM to Analyze Current Database Performance"</a>.</p> </li> <li> <p>Click <span class="bold">Run ASH Report</span> to create an Active Session History (ASH) report to analyze transient, short-lived performance problems.</p> <p>For information about ASH reports, see <a href="tdppt_transient003.htm#DAFGDAJC">"Active Session History Reports"</a>.</p> </li> </ul> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_realtime.htm#CHDIHEBJ">Monitoring Real-Time Database Performance</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_realtime.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime002.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