The Oracle9iAS servlet engine has several log tables with the Oracle9iAS Repository that are used to track servlet errors.
ose$http$admin.error$log - This table contains the error message number and associated text
ose$http$admin.event$log – This table contains servlet event numbers and their associated text messages.
ose$http$admin.http$log$ - This is the repository log table that contains specific log information about remote user servlet messages. The table contains the remote user ID, and time of the servlet request and the referrer URL. The referrer column is most useful because you can use it to track the source of servlet requests:
SQL> desc ose$http$admin.http$log$;
Name Null? Type
----------------------------- -------- --------------------
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:
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.