Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont018.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>About Key Oracle Streams Data Dictionary Views</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:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Key Oracle Streams Data Dictionary Views" /> <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_repcont017.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont019.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_repcont017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont019.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHCDGJC" name="CIHCDGJC"></a><a id="TDPII189" name="TDPII189"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>About Key Oracle Streams Data Dictionary Views</h1> <a name="BEGIN" id="BEGIN"></a> <p><a href="#CIHJFIAD">Table: Key Oracle Streams Data Dictionary Views</a> describes the data dictionary views that are important for monitoring an Oracle Streams replication environment.</p> <div class="tblformal"><a id="TDPII230" name="TDPII230"></a><a id="sthref178" name="sthref178"></a><a id="CIHJFIAD" name="CIHJFIAD"></a> <p class="titleintable">Key Oracle Streams Data Dictionary Views</p> <table class="Formal" title="Key Oracle Streams Data Dictionary Views" summary="This table lists each data dictionary view and describes each data dictionary view." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="41%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t26">Data Dictionary View</th> <th align="left" valign="bottom" id="r1c2-t26">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t26" headers="r1c1-t26"> <p><a id="sthref179" name="sthref179"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20005','newWindow').focus()"><code>ALL_APPLY</code></a></p> <p><a id="sthref180" name="sthref180"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23005','newWindow').focus()"><code>DBA_APPLY</code></a></p> </td> <td align="left" headers="r2c1-t26 r1c2-t26"> <p>Displays information about apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t26" headers="r1c1-t26"> <p><a id="sthref181" name="sthref181"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20006','newWindow').focus()"><code>ALL_APPLY_CONFLICT_COLUMNS</code></a></p> <p><a id="sthref182" name="sthref182"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23006','newWindow').focus()"><code>DBA_APPLY_CONFLICT_COLUMNS</code></a></p> </td> <td align="left" headers="r3c1-t26 r1c2-t26"> <p>Displays information about conflict handlers.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t26" headers="r1c1-t26"> <p><a id="sthref183" name="sthref183"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20006','newWindow').focus()"><code>ALL_APPLY_ERROR</code></a></p> <p><a id="sthref184" name="sthref184"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23006','newWindow').focus()"><code>DBA_APPLY_ERROR</code></a></p> </td> <td align="left" headers="r4c1-t26 r1c2-t26"> <p>Displays information about the error transactions generated by apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t26" headers="r1c1-t26"> <p><a id="sthref185" name="sthref185"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20031','newWindow').focus()"><code>ALL_CAPTURE</code></a></p> <p><a id="sthref186" name="sthref186"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23031','newWindow').focus()"><code>DBA_CAPTURE</code></a></p> </td> <td align="left" headers="r5c1-t26 r1c2-t26"> <p>Displays information about capture processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t26" headers="r1c1-t26"> <p><a id="sthref187" name="sthref187"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20170','newWindow').focus()"><code>ALL_PROPAGATION</code></a></p> <p><a id="sthref188" name="sthref188"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23170','newWindow').focus()"><code>DBA_PROPAGATION</code></a></p> </td> <td align="left" headers="r6c1-t26 r1c2-t26"> <p>Displays information about propagations.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t26" headers="r1c1-t26"> <p><a id="sthref189" name="sthref189"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20600','newWindow').focus()"><code>ALL_STREAMS_COLUMNS</code></a></p> <p><a id="sthref190" name="sthref190"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23600','newWindow').focus()"><code>DBA_STREAMS_COLUMNS</code></a></p> </td> <td align="left" headers="r7c1-t26 r1c2-t26"> <p>Displays information about the columns that are not supported by synchronous captures and apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t26" headers="r1c1-t26"> <p><a id="sthref191" name="sthref191"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20475','newWindow').focus()"><code>ALL_STREAMS_RULES</code></a></p> <p><a id="sthref192" name="sthref192"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23475','newWindow').focus()"><code>DBA_STREAMS_RULES</code></a></p> </td> <td align="left" headers="r8c1-t26 r1c2-t26"> <p>Displays information about the rules used by capture processes, synchronous captures, propagations, and apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t26" headers="r1c1-t26"> <p><a id="sthref193" name="sthref193"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20391','newWindow').focus()"><code>ALL_STREAMS_UNSUPPORTED</code></a></p> <p><a id="sthref194" name="sthref194"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23391','newWindow').focus()"><code>DBA_STREAMS_UNSUPPORTED</code></a></p> </td> <td align="left" headers="r9c1-t26 r1c2-t26"> <p>Displays information about the database objects that are not supported by capture processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t26" headers="r1c1-t26"> <p><a id="sthref195" name="sthref195"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20572','newWindow').focus()"><code>ALL_SYNC_CAPTURE</code></a></p> <p><a id="sthref196" name="sthref196"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN23572','newWindow').focus()"><code>DBA_SYNC_CAPTURE</code></a></p> </td> <td align="left" headers="r10c1-t26 r1c2-t26"> <p>Displays information about synchronous captures.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t26" headers="r1c1-t26"> <p><a id="sthref197" name="sthref197"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30317','newWindow').focus()"><code>V$BUFFERED_QUEUES</code></a></p> </td> <td align="left" headers="r11c1-t26 r1c2-t26"> <p>Displays information about buffered queues and the messages in the buffered queues.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t26" headers="r1c1-t26"> <p><a id="sthref198" name="sthref198"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30352','newWindow').focus()"><code>V$PROPAGATION_RECEIVER</code></a></p> </td> <td align="left" headers="r12c1-t26 r1c2-t26"> <p>Displays information about the messages received into buffered queues by propagations.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t26" headers="r1c1-t26"> <p><a id="sthref199" name="sthref199"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30353','newWindow').focus()"><code>V$PROPAGATION_SENDER</code></a></p> </td> <td align="left" headers="r13c1-t26 r1c2-t26"> <p>Displays information about the messages sent from buffered queues by propagations.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t26" headers="r1c1-t26"> <p><a id="sthref200" name="sthref200"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30266','newWindow').focus()"><code>V$STREAMS_APPLY_COORDINATOR</code></a></p> </td> <td align="left" headers="r14c1-t26 r1c2-t26"> <p>Displays information about apply process coordinators for enabled apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t26" headers="r1c1-t26"> <p><a id="sthref201" name="sthref201"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30267','newWindow').focus()"><code>V$STREAMS_APPLY_READER</code></a></p> </td> <td align="left" headers="r15c1-t26 r1c2-t26"> <p>Displays information about apply process reader servers for enabled apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t26" headers="r1c1-t26"> <p><a id="sthref202" name="sthref202"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30268','newWindow').focus()"><code>V$STREAMS_APPLY_SERVER</code></a></p> </td> <td align="left" headers="r16c1-t26 r1c2-t26"> <p>Displays information about apply process apply servers for enabled apply processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t26" headers="r1c1-t26"> <p><a id="sthref203" name="sthref203"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30269','newWindow').focus()"><code>V$STREAMS_CAPTURE</code></a></p> </td> <td align="left" headers="r17c1-t26 r1c2-t26"> <p>Displays information about enabled capture processes.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t26" headers="r1c1-t26"> <p><a id="sthref204" name="sthref204"></a><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30415','newWindow').focus()"><code>V$STREAMS_TRANSACTION</code></a></p> </td> <td align="left" headers="r18c1-t26 r1c2-t26"> <p>Displays information about transactions that are being processed by capture processes or apply processes. This view can be used to identify long running transactions and to determine how many logical change records (LCRs) are being processed in each transaction. This view only contains information about LCRs that were captured by a capture process.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STRMS118','newWindow').focus()"><span class="italic">Oracle Streams Concepts and Administration</span></a> for more information about these Oracle Streams data dictionary views and other Oracle Streams data dictionary views</p> <p><a href="tdpii_adcont009.htm#BABBADAC">Monitoring an Oracle Streams Replication Environment</a></p> </div> </div> <!-- class="sect3" --> <!-- 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_repcont017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont019.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