Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adcont024.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 Active and Spilled Apply Process Transactions</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 Active and Spilled Apply Process Transactions" /> <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_adcont023.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adcont025.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_adcont023.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont025.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABBIEBJ" name="BABBIEBJ"></a><a id="TDPII340" name="TDPII340"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Viewing Active and Spilled Apply Process Transactions</h1> <a name="BEGIN" id="BEGIN"></a> <p>You can use Enterprise Manager to view the transactions that are currently being processed by an apply process. Active transactions are transactions with messages that are currently in the buffered queue for the apply process. Spilled transactions are transactions with messages that have spilled from the buffered queue to the hard disk.</p> <p>Enterprise Manager displays the following information for active transactions:</p> <ul> <li> <p>The transaction ID of each transaction</p> </li> <li> <p>The total number of messages in the transaction</p> <p>In an Oracle Streams replication environment, each message is a logical change record (LCR).</p> </li> <li> <p>The cumulative number of messages in the transaction</p> <p>If the Streams process is restarted while the transaction is being processed, then this column shows the number of LCRs processed in the transaction since the Streams process was started.</p> </li> <li> <p>The system change number (SCN) for the first message in the transaction</p> </li> <li> <p>The time when the first message in the transaction was recorded</p> <p>In an Oracle Streams replication environment, changes captured by a capture process are recorded in the database redo log.</p> </li> <li> <p>The SCN for the last message in the transaction</p> </li> <li> <p>The time when the last message in the transaction was recorded</p> </li> </ul> <p>Enterprise Manager displays the following information for spilled transactions:</p> <ul> <li> <p>The transaction ID of each transaction</p> </li> <li> <p>The number of spilled messages in the transaction</p> <p>In an Oracle Streams replication environment, each message is a logical change record (LCR).</p> </li> <li> <p>The SCN for the first message in the transaction</p> </li> <li> <p>The time when the first message in the transaction was recorded</p> <p>In an Oracle Streams replication environment, changes captured by a capture process are recorded in the database redo log.</p> </li> <li> <p>The time when the first message in the transaction spilled from the buffered queue to the hard disk (spill create time)</p> </li> </ul> <p class="orderedlisttitle">To view active and spilled apply process transactions: </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>Perform one of the following actions:</p> <ul> <li> <p>To view the active apply process transactions, click the number link in the <span class="bold">Current Transactions Active</span> field for the apply process.</p> <p>The Active Streams Transactions List section displays the active apply process transactions.</p> </li> <li> <p>To view the spilled apply process transactions, click the number link in the <span class="bold">Current Transactions Spilled</span> field for the apply process.</p> <p>The Spilled Streams Transactions List section displays the spilled apply process transactions.</p> </li> </ul> </li> <li> <p>To drill-down for more information about a transaction, select the transaction and click <span class="bold">View Transaction Details</span>.</p> </li> </ol> <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_adcont023.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont025.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