Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\advnc_act_log.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>Creating Custom Activity Reports Using APEX_ACTIVITY_LOG</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:32Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Creating Custom Activity Reports Using APEX_ACTIVITY_LOG" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-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="advnc.htm" title="Advanced Programming Techni..." type="text/html" /> <link rel="up" href="advnc_act_log.htm" title="Creating Custom Activity Re..." type="text/html" /> <link rel="prev" href="advnc_coll_clear.htm" title="Previous" type="text/html" /> <link rel="next" href="advnc_plsql.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="advnc.htm" title="Advanced Programming Techni...">Advanced Programming Techni...</a> > Creating Custom Activity Re...</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="advnc_coll_clear.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_plsql.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDDHGJI" name="CHDDHGJI"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB13003|APEX_ACTIVITY_LOG"></a>Creating Custom Activity Reports Using <a id="sthref2231" name="sthref2231"></a><a id="sthref2232" name="sthref2232"></a><a id="sthref2233" name="sthref2233"></a>APEX_ACTIVITY_LOG</h1> <p>The <code>APEX_ACTIVITY_LOG</code> view records all activity in a workspace, including developer activity and application run-time activity. You can use <code>APEX_ACTIVITY_LOG</code> to view to query all activity for the current workspace. For example, you can use this view to develop monitoring reports within a specific application to provide real-time performance statistics.</p> <p><a href="#CHDCIAIG">Table: Columns in APEX_ACTIVITY_LOG</a> describes the columns in the <code>APEX_ACTIVITY_LOG</code> view.</p> <div class="tblformal"><a id="sthref2234" name="sthref2234"></a><a id="CHDCIAIG" name="CHDCIAIG"></a> <p class="titleintable">Columns in APEX_ACTIVITY_LOG</p> <table class="Formal" title="Columns in APEX_ACTIVITY_LOG" summary="This table describes the column name, type, and purpose of the columns in the HTMLDB_ACTIVITY_LOG view." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="33%" /> <col width="24%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t15">Column</th> <th align="left" valign="bottom" id="r1c2-t15">Type</th> <th align="left" valign="bottom" id="r1c3-t15">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t15" headers="r1c1-t15"> <p><code>time_stamp</code></p> </td> <td align="left" headers="r2c1-t15 r1c2-t15"> <p>DATE</p> </td> <td align="left" headers="r2c1-t15 r1c3-t15"> <p>Date and time that activity was logged at the end of the page view.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t15" headers="r1c1-t15"> <p><code>component_type</code></p> </td> <td align="left" headers="r3c1-t15 r1c2-t15"> <p>VARCHAR2(255)</p> </td> <td align="left" headers="r3c1-t15 r1c3-t15"> <p>Reserved for future use.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t15" headers="r1c1-t15"> <p><code>component_name</code></p> </td> <td align="left" headers="r4c1-t15 r1c2-t15"> <p>VARCHAR2(255)</p> </td> <td align="left" headers="r4c1-t15 r1c3-t15"> <p>Reserved for future use.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t15" headers="r1c1-t15"> <p><code>component_attribute</code></p> </td> <td align="left" headers="r5c1-t15 r1c2-t15"> <p>VARCHAR2(4000)</p> </td> <td align="left" headers="r5c1-t15 r1c3-t15"> <p>Title of page.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t15" headers="r1c1-t15"> <p><code>information</code></p> </td> <td align="left" headers="r6c1-t15 r1c2-t15"> <p>VARCHAR2(4000)</p> </td> <td align="left" headers="r6c1-t15 r1c3-t15"> <p>Reserved for future use.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t15" headers="r1c1-t15"> <p><code>elap</code></p> </td> <td align="left" headers="r7c1-t15 r1c2-t15"> <p>NUMBER</p> </td> <td align="left" headers="r7c1-t15 r1c3-t15"> <p>Elapsed time of page view in seconds.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t15" headers="r1c1-t15"> <p><code>num_rows</code></p> </td> <td align="left" headers="r8c1-t15 r1c2-t15"> <p>NUMBER</p> </td> <td align="left" headers="r8c1-t15 r1c3-t15"> <p>Number of rows processed on page.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t15" headers="r1c1-t15"> <p><code>userid</code></p> </td> <td align="left" headers="r9c1-t15 r1c2-t15"> <p>VARCHAR2(255)</p> </td> <td align="left" headers="r9c1-t15 r1c3-t15"> <p>User ID performing page view.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t15" headers="r1c1-t15"> <p><code>ip_address</code></p> </td> <td align="left" headers="r10c1-t15 r1c2-t15"> <p>VARCHAR2(4000)</p> </td> <td align="left" headers="r10c1-t15 r1c3-t15"> <p>IP address of client.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t15" headers="r1c1-t15"> <p><code>user_agent</code></p> </td> <td align="left" headers="r11c1-t15 r1c2-t15"> <p>VARCHAR2(4000)</p> </td> <td align="left" headers="r11c1-t15 r1c3-t15"> <p>Web browser user agent of client.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t15" headers="r1c1-t15"> <p><code>flow_id</code></p> </td> <td align="left" headers="r12c1-t15 r1c2-t15"> <p>NUMBER</p> </td> <td align="left" headers="r12c1-t15 r1c3-t15"> <p>Application ID.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t15" headers="r1c1-t15"> <p><code>step_id</code></p> </td> <td align="left" headers="r13c1-t15 r1c2-t15"> <p>NUMBER</p> </td> <td align="left" headers="r13c1-t15 r1c3-t15"> <p>Page number.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t15" headers="r1c1-t15"> <p><code>session_id</code></p> </td> <td align="left" headers="r14c1-t15 r1c2-t15"> <p>NUMBER</p> </td> <td align="left" headers="r14c1-t15 r1c3-t15"> <p>Oracle Application Express session identifier.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t15" headers="r1c1-t15"> <p><code>sqlerrm</code></p> </td> <td align="left" headers="r15c1-t15 r1c2-t15"> <p>VARCHAR2(4000)</p> </td> <td align="left" headers="r15c1-t15 r1c3-t15"> <p>SQL Error message.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t15" headers="r1c1-t15"> <p><code>sqlerrm_component_type</code></p> </td> <td align="left" headers="r16c1-t15 r1c2-t15"> <p>VARCHAR2(255)</p> </td> <td align="left" headers="r16c1-t15 r1c3-t15"> <p>Reserved for future use.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t15" headers="r1c1-t15"> <p><code>sqlerrm_component_name</code></p> </td> <td align="left" headers="r17c1-t15 r1c2-t15"> <p>VARCHAR2(255)</p> </td> <td align="left" headers="r17c1-t15 r1c3-t15"> <p>Reserved for future use.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>To conserve space in the activity log, only the first log entry of each unique session will contain the IP address and Web browser user agent.</p> <p>The following example demonstrates how to create a report that displays the total number of page views and the average page view time in the past 24 hours for application 9529, and grouped by userid:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT COUNT(*), AVG(elap), userid FROM APEX_ACTIVITY_LOG WHERE time_stamp > (SYSDATE-1) AND flow_id = 9529 GROUP BY userid </pre> <p>Keep in mind that logging of activity in an Oracle Application Express instance is rotated between two different log tables. Because of this, logging information is only as current as the oldest available entry in the logs. If you want to persist your application specific log information for all time, you must either copy the log information into your own application table or implement logging directly in your application.</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">See Also:</p> <a href="bldr_attr_standard.htm#CHDFBAFA">"Name"</a> for information on enabling logging on the Edit Definition page</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- 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 © 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="advnc_coll_clear.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_plsql.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