Oracle Servlet Log Tables

The Oracle9iAS servlet engine has several log tables with the Oracle9iAS Repository that are used to track servlet errors.

SQL> desc ose$http$admin.http$log$;

 Name                          Null?    Type
 ----------------------------- -------- -------------------- 
 SERVER_NAME                            VARCHAR2(80)
 TIMESTAMP                              DATE
 REMOTE_HOST                            RAW(4)
 REMOTE_USER                            VARCHAR2(80)
 REQUEST_LINE                           VARCHAR2(256)
 STATUS                                 NUMBER(3)
 RESPONSE_SIZE                          NUMBER(38)
 REQUEST_METHOD                         RAW(1)
 REFERER                                VARCHAR2(80)
 AGENT                                  VARCHAR2(80)


Portal Repository Log Audit Reports

Oracle Portal has several log tables in the Iasdb repository, and these can be referenced with SQL to create developer activity reports for Portal.  This produces a report similar to using the Oracle DDL system-level trigger, and tracks all Portal changes made by your development staff.  The report below references the portal.wwlog_activity_log1$ and portal.wwlog_activity_log2$ tables and produces a great report of all Portal development activity.

 


Read more here:

http://www.dba-oracle.com/application_server/t_app_server_servlet_log_tables.htm

 

*****************************************

Need a Health Check?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.