Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_method002.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>Time Model Statistics</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="Time Model Statistics" /> <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_method001.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_method003.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_method001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method003.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHCACJG" name="CIHCACJG"></a><a id="TDPPT008" name="TDPPT008"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Time Model Statistics</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref13" name="sthref13"></a><a id="sthref14" name="sthref14"></a>Time model statistics measure the time spent in the database by operation type. The most important time model statistic is <span class="bold">database time (DB time)</span><a id="sthref15" name="sthref15"></a><a id="sthref16" name="sthref16"></a><a id="sthref17" name="sthref17"></a>. Database time represents the total time spent in database calls, and is an indicator of the total instance workload. As shown in <a href="#CIHCDGCI">Figure: DB Time in Overall User Response Time</a>, database time makes up a portion of an application's overall user response time.</p> <div class="figure"><a id="CIHCDGCI" name="CIHCDGCI"></a><a id="TDPPT345" name="TDPPT345"></a> <p class="titleinfigure">DB Time in Overall User Response Time</p> <img src="./tdppt001.gif" alt="Description of this figure follows" title="Description of this figure follows" longdesc="./img_text/tdppt001.htm" /><br /> <a id="sthref18" name="sthref18" href="./img_text/tdppt001.htm">Description of "DB Time in Overall User Response Time"</a><br /> <br /></div> <!-- class="figure" --> <p>A <span class="bold">session</span> is a specific connection of a user to an Oracle Database instance through a user process. Database time is calculated by aggregating the CPU time and wait time of all user sessions that are not idle. For any database request, the CPU time is the sum of the time spent working on the request, while the wait time is the sum of all the waits for various database instance resources. DB time does not include time spent on background processes such as PMON.</p> <p>For example, a user session may involve an online transaction made at an online bookseller consisting of the actions shown in <a href="#CIHDFGGJ">Figure: DB Time in User Transaction</a>.</p> <div class="figure"><a id="CIHDFGGJ" name="CIHDFGGJ"></a><a id="TDPPT346" name="TDPPT346"></a> <p class="titleinfigure">DB Time in User Transaction</p> <img src="./tdppt002.gif" alt="Description of this figure follows" title="Description of this figure follows" longdesc="./img_text/tdppt002.htm" /><br /> <a id="sthref19" name="sthref19" href="./img_text/tdppt002.htm">Description of "DB Time in User Transaction"</a><br /> <br /></div> <!-- class="figure" --> <ol> <li> <p>Query for novels by author</p> <p>The user performs a search for novels by a particular author. This action causes the application to perform a database query for novels by the author.</p> </li> <li> <p>Browse results of query</p> <p>The user browses the returned list of novels by the author and accesses additional details, such as user reviews and inventory status. This action causes the application to perform additional database queries.</p> </li> <li> <p>Add item to cart</p> <p>After browsing details about the novels, the user decides to add one of the novels to the shopping cart. This action causes the application to make a database call to update the shopping cart.</p> </li> <li> <p>Checkout</p> <p>The user completes the transaction by checking out, using the address and payment information previously saved at the bookseller's Web site from a previous purchase. This action causes the application to perform various database operations to retrieve the user's information, add a new order, update the inventory, and generate an e-mail confirmation.</p> </li> </ol> <p>For each of the preceding actions, the user makes a request to the database, as represented by the down arrow in <a href="#CIHDFGGJ">Figure: DB Time in User Transaction</a>. The CPU time spent by the database processing the request and the wait time spent waiting for the database are considered DB time, as represented by the shaded areas. After the request is completed, the results are returned to the user, as represented by the up arrow. The space between the up and down arrows represents the total user response time for processing the request, which contains other components besides DB time, as illustrated in <a href="#CIHCDGCI">Figure: DB Time in Overall User Response Time</a>.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>DB time is measured cumulatively from when the instance started. Because DB time combines times from all non-idle user sessions, DB time can exceed the time elapsed since the instance started. For example, an instance that has run 5 minutes could have four active sessions whose cumulative DB time is 20 minutes.</p> </div> <p>The objective of database tuning is to reduce the time that users spend performing actions on the database, or reducing database time. In this way, you can improve the overall response time of user transactions on the application.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdppt_method001.htm#CAEICJEI">Gathering Database Statistics Using the Automatic Workload Repository</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_method001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_method003.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