Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit019.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>Preventing Materialized View Logs From Becoming Too Large</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="Preventing Materialized View Logs From Becoming Too Large" /> <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_adpit018.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_messaging.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_adpit018.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABCGIBA" name="BABCGIBA"></a><a id="TDPII121" name="TDPII121"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Preventing Materialized View Logs From Becoming Too Large<a id="sthref545" name="sthref545"></a><a id="sthref546" name="sthref546"></a><a id="sthref547" name="sthref547"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Materialized view logs keep track of changes to master tables at master sites. When a fast refresh is performed on a materialized view, the changes in the materialized view log are applied to the materialized view. After changes are applied to all of the materialized views that use the materialized view log, the changes are deleted from the materialized view log.</p> <p>A materialized view log can become too large when one or more materialized views that use the materialized view log do not refresh for a relatively long period of time. This situation can slow refresh performance for other materialized views. The following are typical causes and solutions:</p> <ul> <li> <p>A network problem is preventing one or more materialized views that use the materialized view log from refreshing. In this case, correct the network problem and refresh the relevant materialized views. See <a href="topicid:ADMQS004">Configuring the Network Environment</a> for information about configuring network connectivity between databases.</p> </li> <li> <p>A materialized view was dropped at a materialized view site when the materialized view site was not connected to the network. When a materialized view is dropped and a network connection is available, information about the materialized view is removed from the master site automatically. However, when a network connection is not available, information about the materialized view remains at the master site and must be cleaned up manually. See <a href="tdpii_adpit007.htm#BABHFCEE">"Tutorial: Cleaning Up Materialized View Support at a Master Site"</a>.</p> </li> <li> <p>Materialized views are not being refreshed often enough. Materialized views can be refreshed manually, or they can be refreshed automatically when they are in a refresh group.</p> <p>If you refresh materialized views manually, then you might need to refresh them more often if materialized view logs are becoming too large. See <a href="tdpii_adpit004.htm#BABDECCF">"Refreshing a Materialized View"</a>.</p> <p>If materialized views are in a refresh group that is not refreshing often enough, then you can make the refresh interval shorter for the refresh group.</p> </li> </ul> <p class="orderedlisttitle">To modify the refresh interval for a refresh group: </p> <ol> <li> <p>In Enterprise Manager, log in to the materialized view site as the materialized view administrator. The default user name for the materialized view administrator is <code>mvadmin</code>.</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</span> in the Advanced Replication section.</p> <p>The Advanced Replication: Administration page appears, showing the Overview subpage.</p> </li> <li> <p>Click the number associated with <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('REFRESH_GROUPS');">Refresh Groups</a> in the Materialized View Site section.</p> </li> <li> <p>On the Refresh Groups page, use the search tool to list the refresh group that you want to modify.</p> </li> <li> <p>Select the refresh group.</p> </li> <li> <p>Click <span class="bold">Edit</span>.</p> <p>The Edit Refresh Group page appears, showing the General subpage.</p> </li> <li><a id="BABDGGEE" name="BABDGGEE"></a> <p>In the Refresh section, click <span class="bold">Change</span> for the Interval field.</p> </li> <li> <p>Shorten the interval using the Every field and list.</p> </li> <li> <p>Click <span class="bold">OK</span>.</p> </li> <li><a id="BABHDHGI" name="BABHDHGI"></a> <p>On the Edit Refresh Group page, click <span class="bold">Apply</span> to save your changes.</p> </li> </ol> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can also use the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA018','newWindow').focus()"><code>DBMS_REFRESH.CHANGE</code></a> procedure to change the refresh interval for a refresh group.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit003.htm#BEHBEBJA">About Materialized View Refresh</a></p> <p><a href="tdpii_reppit004.htm#BEHBGDFD">About Refresh Groups</a></p> <p><a href="tdpii_reppit002.htm#BEHFGHIE">About Master Sites, Master Tables, and Materialized View Sites</a></p> <p><a href="tdpii_reppit007.htm#CHDCDIAG">Configuring Materialized View Logs at the Master Site</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN008','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></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_adpit018.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_messaging.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