Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEADM\adm_logs.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>Managing Log Entries</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:6:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Managing Log Entries" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12512-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.htm" title="Home" type="text/html" /> <link rel="up" href="adm_wrkspc.htm" title="Oracle Application Express ..." type="text/html" /> <link rel="up" href="adm_mg_service_set.htm" title="Managing Service" type="text/html" /> <link rel="up" href="adm_logs.htm" title="Managing Log Entries" type="text/html" /> <link rel="prev" href="adm_tasklist.htm" title="Previous" type="text/html" /> <link rel="next" href="adm_session.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="adm_wrkspc.htm" title="Oracle Application Express ...">Oracle Application Express ...</a> > <a href="adm_mg_service_set.htm" title="Managing Service">Managing Service</a> > Managing Log Entries</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="adm_tasklist.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_session.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CJACCBDE" name="CJACCBDE"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEADM174" id="AEADM174"></a>Managing <a id="sthref145" name="sthref145"></a>Log Entries</h1> <p>Oracle Application Express administrators can delete log entries on the Logs page.</p> <a id="sthref146" name="sthref146"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABIBJGD">Deleting SQL Workshop Logs</a></p> </li> <li> <p><a href="#BABGIBAG">Deleting Page View Activity Log Entries</a></p> </li> <li> <p><a href="#BABCAIBE">Deleting Developer Activity Log Entries</a></p> </li> <li> <p><a href="#BABHGJCF">Deleting Click Counting Log Entries</a></p> </li> <li> <p><a href="#BABDIJAE">Deleting Mail Log Entries</a></p> </li> <li> <p><a href="#BABGFGCE">Deleting the Login Access Log</a></p> </li> </ul> <a id="BABIBJGD" name="BABIBJGD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM175" id="AEADM175"></a>Deleting SQL Workshop <a id="sthref147" name="sthref147"></a>Logs</h2> <p>The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Commands</p> <p>To delete log files entries:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Logs</span>.</p> <p>The Logs page appears.</p> </li> <li> <p>Click <span class="bold">SQL Workshop logs</span>.</p> </li> <li> <p>Click one of the following:</p> <ul> <li> <p>Script File executions log entries</p> </li> <li> <p>SQL Command Processor history entries</p> </li> </ul> </li> <li> <p>On the Clean up Logs page:</p> <ul> <li> <p>To delete entries by age, specify the age of the entries to be deleted and click <span class="bold">Delete Entries</span>.</p> </li> <li> <p>To delete all entries, click <span class="bold">Truncate Log</span>.</p> </li> </ul> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1"><span class="bold">See Also</span>:</p> "Accessing a Command from Command History"in <a href="../AEUTL/sql_proc_hist_go.htm"><span class="italic">Oracle Application Express SQL Workshop and Utilities Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABGIBAG" name="BABGIBAG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM176" id="AEADM176"></a>Deleting Page View Activity Log <a id="sthref148" name="sthref148"></a>Entries</h2> <p>Page view activity logs track user activity for an application. Developers enable logging within their application using the Logging attribute on the Edit Definition page.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1"><span class="bold">See Also</span>:</p> "About the Edit Definition Page" in <a href="../bldr_attr_standard.htm"><span class="italic">Oracle Application Express Application Builder User’s Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>The Application Express engine actually uses two logs to track user activity. At any given time, one log is designated as current. For each rendered page view, the Application Express engine inserts one row into the log file. A log switch occurs at the interval listed on the Manage Activity Logs page. At that point, the Application Express engine removes all entries in the noncurrent log and designates it as current.</p> <p>To truncate the activity logs manually:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Logs</span>.</p> <p>The Logs page appears.</p> </li> <li> <p>Click <span class="bold">Page View Activity Log, with option to truncate</span>.</p> </li> <li> <p>Click <span class="bold">Truncate Logs</span>.</p> </li> <li> <p>Click either <span class="bold">Truncate Log 1</span> or <span class="bold">Truncate Log 2</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1"><span class="bold">See Also</span>:</p> <a href="aadm_activity.htm#BEJCBDGD">"Monitoring Activity within a Workspace"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABCAIBE" name="BABCAIBE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM177" id="AEADM177"></a>Deleting Developer Activity Log <a id="sthref149" name="sthref149"></a>Entries</h2> <p>The Developer Activity Log tracks changes to applications within an individual workspace. Log entries older than one month are automatically deleted.</p> <p>To delete Developer Activity Log entries:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Logs</span>.</p> <p>The Logs page appears.</p> </li> <li> <p>Click <span class="bold">Developer Activity Logs, with option to delete entries</span>.</p> </li> <li> <p>On the Developer Activity Log page, click <span class="bold">Manage</span>.</p> </li> <li> <p>Specify the age of the entries to be deleted and click <span class="bold">Delete Entries</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1"><span class="bold">See Also</span>:</p> <a href="aadm_chng_dev.htm#BABHACCC">"Viewing Application Changes by Developer"</a> for information about the Developer Activity Log</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABHGJCF" name="BABHGJCF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM178" id="AEADM178"></a>Deleting Click Counting Log <a id="sthref150" name="sthref150"></a>Entries</h2> <p>The External Clicks Log counts clicks from an Oracle Application Express application to an external site. You can implement this functionality using the <code>APEX_UTIL.COUNT_CLICK</code> procedure.</p> <p>To delete click counting log entries:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Logs</span>.</p> <p>The Logs page appears.</p> </li> <li> <p>Click <span class="bold">External Click Counting Log, with option to truncate</span>.</p> </li> <li> <p>On the External Click Counting Log page, click <span class="bold">Manage</span>.</p> </li> <li> <p>Specify the age of the entries to be deleted and click <span class="bold">Delete Entries</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1"><span class="bold">See Also</span>:</p> "COUNT_CLICK Procedure" in <a href="http://www.oracle.com/pls/db112/lookup?id=AEAPI112"><span class="italic">Oracle Application Express API Reference</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABDIJAE" name="BABDIJAE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM179" id="AEADM179"></a>Deleting Mail Log Entries<a id="sthref151" name="sthref151"></a></h2> <p>The Oracle Application Express Mail Log records the message header information and send date of successfully sent mail message.</p> <p>To truncate the mail log:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Logs</span>.</p> <p>The Mail Logs page appears.</p> </li> <li> <p>To control the number of rows that display, make a selection from the Display list and click <span class="bold">Go</span>.</p> </li> <li> <p>Click <span class="bold">Mail Log</span>.</p> </li> <li> <p>On the Mail Log page, click <span class="bold">Truncate</span>.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="adm_email.htm#BABJJDFI">"Managing Mail"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BABGFGCE" name="BABGFGCE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM180" id="AEADM180"></a>Deleting the Login Access Log<a id="sthref152" name="sthref152"></a></h2> <p>This table records authentication events by developers and administrators accessing the Oracle Application Express environment and by end users of Oracle Application Express applications that use the built-in login APIs available to developers. Log entries are aged out of the log tables and purged periodically.</p> <p>To truncate the Login Access log:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Service, click <span class="bold">Login Access Log</span>.</p> <p>The Login Access Log page appears.</p> </li> <li> <p>Click <span class="bold">Manage</span>.</p> </li> <li> <p>On the Manage Login Access Log page, click <span class="bold">Delete Entries</span>.</p> </li> </ol> </div> <!-- class="sect3" --></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 © 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="adm_tasklist.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_session.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