Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adcont027.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>Displaying the Amount of Time Between Capture and Apply</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Displaying the Amount of Time Between Capture and Apply" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-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="tdpii_adcont026.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adcont028.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="tdpii_adcont026.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont028.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDDIHDI" name="CHDDIHDI"></a><a id="TDPII160" name="TDPII160"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Displaying the Amount of Time Between Capture and Apply<a id="sthref340" name="sthref340"></a><a id="sthref341" name="sthref341"></a><a id="sthref342" name="sthref342"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>You can query the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30266','newWindow').focus()"><code>V$STREAMS_APPLY_COORDINATOR</code></a> dynamic performance view to monitor the performance of an Oracle Streams replication environment. Specifically, you can query this view to determine the amount of time between when a change was captured at the source database and when it was applied by an apply process at the current database. The query shows the amount of time for a recent change that was applied by each apply process in the current database. In an Oracle Streams replication environment, the amount of time between capture and apply should be relatively short.</p> <p>Some changes might take longer than others to be captured, propagated, and applied. The query shows the message number of the change you are monitoring, and each change has a different message number. Therefore, you can run this query multiple times to view the amount of time between capture and apply for different changes.</p> <p class="orderedlisttitle">To determine the amount of time between capture and apply for a recent change: </p> <ol> <li> <p>Open SQL*Plus and connect to the database running the apply process as the Oracle Streams administrator.</p> <p>See <a href="topicid:ADMQS0361">Starting SQL*Plus and Connecting to the Database</a> for more information about starting SQL*Plus.</p> </li> <li> <p>Run the following query:</p> <pre xml:space="preserve" class="oac_no_warn"> COLUMN APPLY_NAME HEADING 'Apply Process Name' FORMAT A30 COLUMN 'Time Between Capture and Apply' FORMAT 999999 COLUMN HWM_MESSAGE_NUMBER HEADING 'Applied Message Number' FORMAT 999999999 SELECT APPLY_NAME, (HWM_TIME-HWM_MESSAGE_CREATE_TIME)*86400 "Time in Seconds", HWM_MESSAGE_NUMBER FROM V$STREAMS_APPLY_COORDINATOR; </pre> <p>The output will be similar to the following:</p> <pre xml:space="preserve" class="oac_no_warn"> <span class="bold">Apply Process Name Time in Seconds Applied Message Number</span> <span class="bold">------------------------------ --------------- ----------------------</span> <span class="bold">APPLY$_DB_2 3 1486062</span> </pre></li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont001.htm#BABEHDDF">About Oracle Streams Replication</a></p> <p><a href="tdpii_adcont001.htm#BABEBBFA">Managing an Oracle Streams Replication Environment</a></p> <p><a href="tdpii_adcont009.htm#BABBADAC">Monitoring an Oracle Streams Replication Environment</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="tdpii_adcont026.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont028.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