Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\administer013.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>Specifying a Site's Purge Schedule</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:6Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Specifying a Site's Purge Schedule" /> <meta name="relnum" content="11g Release 1 (11.1)" /> <meta name="partnum" content="A12345-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="administer012.htm" title="Previous" type="text/html" /> <link rel="next" href="administer014.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> <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="administer012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="administer014.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABFGGCD" name="BABFGGCD"></a><a id="ADVRP339" name="ADVRP339"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Specifying a Site's Purge Schedule</h1> <p>A scheduled purge determines how a master or materialized view site purges applied transactions from its deferred transaction queue. When you used the Replication Setup Wizard to create a master or materialized view site, Oracle created a job in each site's local job queue to purge the local deferred transaction queue on a regular basis. Consider the following options for a site's purge schedule.</p> <ul> <li> <p>You can synchronize the pushing (scheduled links) and purging of a site's deferred transaction queue.</p> <p>For example, you can configure continuous pushing and purging of the transaction queue. This type of configuration might offer performance advantages because it is likely that information about recently pushed transactions is already in the server's buffer cache for the corresponding purge operation.</p> <p>See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN006','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></a> for information about configuring continuous pushing and purging of the transaction queue.</p> </li> <li> <p>When a server is not CPU bound, you can schedule continuous purging of the deferred transaction queue to keep the size of the queue as small as possible.</p> </li> <li> <p>For servers that experience a high-volume of transaction throughput during normal business hours, you can schedule purges to occur during off-peak hours.</p> </li> </ul> <p>If you want to modify a site's purge schedule, complete the following steps:</p> <ol> <li> <p>In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.</p> </li> <li> <p>Click <span class="bold">Data Movement</span>.</p> </li> <li> <p>Under the Advanced Replication section, click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('ADVRP_ADMINISTRATION');"><span class="bold">Manage</span></a>.</p> <p>The Administration Overview page appears.</p> </li> <li> <p>Click <span class="bold">Purge Schedule</span>.</p> </li> <li> <p>Modify the purge schedule for the site. If you need more information about the controls, click <span class="bold">Help</span>.</p> </li> <li> <p>Click <span class="bold">Apply</span> when you have completed your modifications.</p> </li> </ol> <div class="helpinfonote"> <p><span class="bold">API Equivalents: </span><code>DBMS_DEFER_SYS.SCHEDULE_PURGE</code></p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="administer008.htm#BABEJFGI">Managing Deferred Transactions</a></p> <p><a href="administer018.htm#BABHCHIG">Managing Error Transactions</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 © 2005, 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="administer012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="administer014.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