Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit011.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>Determining Which Materialized Views Are Currently Refreshing</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="Determining Which Materialized Views Are Currently Refreshing" /> <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_adpit010.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adpit012.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_adpit010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit012.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABBBICG" name="BABBBICG"></a><a id="TDPII097" name="TDPII097"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Determining Which Materialized Views Are Currently Refreshing<a id="sthref515" name="sthref515"></a><a id="sthref516" name="sthref516"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Refreshing a materialized view synchronizes data in the materialized view with data in its master table. You can query the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN30157','newWindow').focus()"><code>V$MVREFRESH</code></a> dynamic performance view to determine which materialized views are currently refreshing.</p> <p>Before shutting down a database that contains materialized views, it is best to check if any materialized views are currently refreshing. If any materialized views are refreshing, then wait until all of the refreshes are complete before shutting down the database.</p> <p class="orderedlisttitle">To determine which materialized views at a materialized view site are currently refreshing: </p> <ol> <li> <p>Open SQL*Plus and connect to the materialized view site as the materialized view administrator.</p> <p>See <a href="topicid:ADMQS0361">Starting SQL*Plus and Connecting to the Database</a> for more information about starting SQL*Plus.</p> </li> <li> <p><a id="sthref518" name="sthref518"></a>Run the following query:</p> <pre xml:space="preserve" class="oac_no_warn"> COLUMN CURRMVOWNER HEADING 'Owner' FORMAT A15 COLUMN CURRMVNAME HEADING 'Materialized|View' FORMAT A25 SELECT CURRMVOWNER, CURRMVNAME FROM V$MVREFRESH; </pre> <p>The output will be similar to the following:</p> <pre xml:space="preserve" class="oac_no_warn"> <span class="bold"> Materialized</span> <span class="bold">Owner View</span> <span class="bold">--------------- -------------------------</span> <span class="bold">HR COUNTRIES_MV</span> <span class="bold">HR EMPLOYEES_MV</span> </pre></li> </ol> <p>The <code>V$MVREFRESH</code> dynamic performance view does not contain information about updatable materialized views when the deferred transactions of the materialized views are being pushed to their masters.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit003.htm#BEHBEBJA">About Materialized View Refresh</a></p> <p><a href="tdpii_adpit002.htm#BABEDJGH">Refreshing Materialized Views</a></p> <p><a href="tdpii_reppit001.htm#BEHHAHHA">About Materialized View Replication</a></p> <p><a href="tdpii_adpit008.htm#CIHJBJJC">Monitoring a Materialized View Replication Environment</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_adpit010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit012.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