Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adcont023.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>Viewing Statistics for an Apply Process</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="Viewing Statistics for an Apply Process" /> <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_adcont022.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adcont024.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_adcont022.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont024.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDFCAFI" name="CHDFCAFI"></a><a id="TDPII156" name="TDPII156"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Viewing Statistics for an Apply Process<a id="sthref326" name="sthref326"></a><a id="sthref327" name="sthref327"></a><a id="sthref328" name="sthref328"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>You can use Enterprise Manager to view statistics for an apply process. The statistics include the number of messages in the apply process's queue, the number of messages applied by the apply process, and other statistics relating to the apply process.</p> <p class="orderedlisttitle">To view statistics for an apply process in Enterprise Manager: </p> <ol> <li> <p>In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Data Movement</span> to open the Data Movement subpage.</p> </li> <li> <p>Click <span class="bold">Manage Replication</span> in the Streams section.</p> <p>The Streams page appears, showing the Overview subpage.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('STREAMS_APPLY');"><span class="bold">Streams</span></a> to open the Streams subpage.</p> </li> <li> <p>Select the apply process that you want to monitor in the list of components. If necessary, use the search tool to find the apply process, and then select it.</p> </li> <li> <p>Select <span class="bold">View Statistics</span> in Action.</p> </li> <li> <p>Click <span class="bold">Go</span> to open the View Apply Statistics page.</p> </li> </ol> <p>The View Apply Statistics page includes the following subpages:</p> <ul> <li> <p>The Queue subpage shows the number of messages over the past several hours in both the persistent queue portion and the buffered queue portion of the apply process's queue. If the apply process applies changes captured by a synchronous capture, then analyze the persistent queue statistics. If the apply process applies changes captured by a capture process, then analyze the buffered queue statistics.</p> </li> <li> <p>The Reader subpage shows statistics for the reader server. The reader server dequeues messages from the apply process's queue and assembles them into separate transactions.</p> </li> <li> <p>The Coordinator subpage shows statistics for the coordinator process. The coordinator process gets transactions from the reader server and passes them to apply servers.</p> </li> <li> <p>The Server subpage shows statistics for the apply servers. The apply servers apply changes to database objects or pass the changes to apply handlers. To view details about a specific apply server, select it and click <span class="bold">View Details</span>.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can also query the following dynamic performance views for buffered queue statistics and apply process statistics: <ul> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30317','newWindow').focus()"><code>V$BUFFERED_QUEUES</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30266','newWindow').focus()"><code>V$STREAMS_APPLY_COORDINATOR</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30267','newWindow').focus()"><code>V$STREAMS_APPLY_READER</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30268','newWindow').focus()"><code>V$STREAMS_APPLY_SERVER</code></a></p> </li> </ul> </p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont006.htm#BABBAJFE">About Change Apply</a></p> <p><a href="tdpii_adcont006.htm#CHDIJJGJ">Managing Apply Processes</a></p> <p><a href="tdpii_adcont022.htm#CHDIGAED">Viewing Information About an Apply Process</a></p> <p><a href="tdpii_adcont021.htm#CHDBJIHG">Monitoring Apply Processes</a></p> </div> </div> <!-- class="sect3" --> <!-- 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_adcont022.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont024.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