Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit014.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 Information About Refresh Groups</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 Information About Refresh Groups" /> <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_adpit013.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adpit015.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_adpit013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit015.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABBJIBF" name="BABBJIBF"></a><a id="TDPII117" name="TDPII117"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Viewing Information About Refresh Groups<a id="sthref526" name="sthref526"></a><a id="sthref527" name="sthref527"></a><a id="sthref528" name="sthref528"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>When you refresh a refresh group, all of the materialized views in the refresh group are refreshed to a consistent point in time.</p> <p class="orderedlisttitle">To view information about the refresh groups at a materialized view site: </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> <p>The Refresh Groups page appears.</p> </li> <li> <p>Use the search tool to list the refresh groups that you want to view. To list all refresh groups, ensure that the Schema and Object Name fields are blank, and click <span class="bold">Go</span>.</p> <p>The Refresh Groups page lists the names of the refresh groups at the materialized view site. It also contains the following information for each refresh group:</p> <ul> <li> <p>The Broken column shows whether the refresh job is working properly. <span class="bold">No</span> means that the job is working properly. <span class="bold">Yes</span> means that the job is broken. If 16 attempts to refresh a refresh group fail, then the refresh job is considered broken. If the refresh job is broken, see <a href="tdpii_adpit018.htm#BABGAEFH">"Correcting Problems with Materialized View Refresh"</a>.</p> </li> <li> <p>The Next Date column shows the next date and time when the refresh group will be automatically refreshed.</p> </li> <li> <p>The Interval column shows the time interval between automatic refreshes of the refresh group.</p> </li> </ul> </li> <li> <p>For detailed information about a refresh group, select it and click <span class="bold">View</span> to open the View Refresh Group page.</p> </li> </ol> <p>The View Refresh Group page contains detailed information about the refresh group. The information is organized into the following sections: General, Refresh, and Materialized Views.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can also query the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN20178','newWindow').focus()"><code>ALL_REFRESH</code></a> data dictionary view for information about refresh groups.</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_reppit017.htm#CHDJEFDH">Configuring a Refresh Group</a></p> <p><a href="tdpii_adpit003.htm#BABGBBIJ">Refreshing a Refresh Group</a></p> </div> </div> <!-- class="sect2" --> <!-- 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_adpit013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit015.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