Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util005.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>CACHE_PURGE_STALE Procedure</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:15Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="CACHE_PURGE_STALE Procedure" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-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="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="apex_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="up" href="apex_util005.htm" title="CACHE_PURGE_S..." type="text/html" /> <link rel="prev" href="apex_util004.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util006.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_util.htm" title="APEX_UTIL">APEX_UTIL</a> > CACHE_PURGE_S...</p> <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="apex_util004.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util006.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDJAFAB" name="CHDJAFAB"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI107" id="AEAPI107"></a>CACHE_PURGE_STALE <a id="sthref30" name="sthref30"></a>Procedure</h1> <p>This procedure deletes all cached pages and regions for a specified application that have passed the defined active time period. When you cache a page or region, you specify an active time period (or Cache Timeout). Once that period has passed, the cache will no longer be used, thus removing those unusable pages or regions from the cache.</p> <a id="sthref31" name="sthref31"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.CACHE_PURGE_STALE ( p_application IN NUMBER); </pre> <a id="sthref32" name="sthref32"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDGJHBI">Table: CACHE_PURGE_STALE Parameters</a> describes the parameters available in the <code>CACHE_PURGE_STALE</code> procedure.</p> <div class="tblformal"><a id="sthref33" name="sthref33"></a><a id="CHDGJHBI" name="CHDGJHBI"></a> <p class="titleintable">CACHE_PURGE_STALE Parameters</p> <table class="Formal" title="CACHE_PURGE_STALE Parameters" summary="This table describes the parameters available in the CACHE_PURGE_STALE procedure." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t6">Parameter</th> <th align="left" valign="bottom" id="r1c2-t6">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t6" headers="r1c1-t6"> <p><code>p_application</code></p> </td> <td align="left" headers="r2c1-t6 r1c2-t6"> <p>The identification number (ID) of the application.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref34" name="sthref34"></a> <p class="subhead2">Example</p> <p>The following example demonstrates how to use the CACHE_PURGE_STALE procedure to purge all the stale pages and regions in the application currently executing.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN APEX_UTIL.CACHE_PURGE_STALE(p_application => :APP_ID); END; </pre></div> <!-- class="refsect1" --> <!-- 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 © 2003, 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="apex_util004.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util006.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