Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_realtime022.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 Disk I/O Utilization</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="Monitoring Disk I/O Utilization" /> <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_realtime021.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_realtime023.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_realtime021.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime023.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDCCFDG" name="CHDCCFDG"></a><a id="TDPPT044" name="TDPPT044"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Monitoring Disk I/O Utilization</h1> <a name="BEGIN" id="BEGIN"></a> <p>Because the database resides on a set of disks, the performance of the I/O subsystem is very important to database performance. Important disk statistics include the disk I/Os per second and the length of the service times. These statistics show if the disk is performing optimally or if the disk is being overworked. This section describes how to monitor disk I/O utilization.</p> <p class="orderedlisttitle">To monitor disk I/O utilization<a id="sthref162" name="sthref162"></a>: </p> <ol> <li> <p>From the Database Home page, under Host CPU, click the <span class="bold">Load</span> link.</p> <p>The Host page appears, showing the Performance subpage.</p> </li> <li> <p>Select <span class="bold">Disk Details</span> from the View list.</p> <p>The Disk Details view appears.</p> <p>This view contains disk I/O utilization and service time statistics gathered over the last hour, and the top disk devices ordered by the percentage of time that they were in use.</p> </li> <li> <p>Verify the current disk I/O utilization using the Disk I/O Utilization chart.</p> <p>The Disk I/O Utilization chart shows how many disk I/Os are being performed per second. The current value for total I/Os per second is displayed below the chart.</p> </li> <li> <p>Click <span class="bold">Total I/Os per Second</span>.</p> <p>The Total Disk I/O Per Second page appears.</p> <p>This page contains disk utilization statistics and related alerts generated over the last 24 hours.</p> <p>If you notice an unexpected spike in this value that is sustained through standard workload hours, then a disk I/O performance problem might exist and should be investigated.</p> </li> <li> <p>Verify the current I/O service time using the Longest I/O Service Time chart.</p> <p>The Longest I/O Service Time chart shows the longest service time for disk I/Os in milliseconds. The current value for longest I/O service time is displayed below the chart.</p> </li> <li> <p>Click <span class="bold">Longest I/O Service Time</span>.</p> <p>The Longest Service Time page appears.</p> <p>This page contains I/O service time statistics and related alerts generated over the last 24 hours.</p> <p>If you notice an unexpected spike in this value that is sustained through normal workload hours, then a disk I/O performance problem might exist and should be investigated.</p> </li> <li> <p>On the Disk Details page, verify the disk devices in the Top Disk Devices table.</p> <p>If a particular disk is busy a high percentage of the time, then this disk should be investigated.</p> </li> <li> <p>If a disk I/O performance problem<a id="sthref163" name="sthref163"></a><a id="sthref164" name="sthref164"></a> is identified, you can attempt to resolve the problem by doing the following:</p> <ul> <li> <p>Use Oracle Automatic Storage Management (Oracle ASM) to manage database storage.</p> </li> <li> <p>Stripe everything across every disk to distribute I/O.</p> </li> <li> <p>Move files such as archived redo logs and online redo logs to separate disks.</p> </li> <li> <p>Store required data in memory to reduce the number of physical I/Os.</p> </li> </ul> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=PFGRF015','newWindow').focus()"><span class="italic">Oracle Database Performance Tuning Guide</span></a> for information about resolving disk I/O issues</p> <p><a href="tdppt_realtime019.htm#CHDEBIAA">Monitoring Host Activity</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_realtime021.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_realtime023.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