| |
 |
|
Oracle Tips by Burleson |
Managing
HTML DB Logs
HTML DB captures information in logs as the system
is being used and the applications are being developed. The clean up
of these logs can be controlled by the administrator. The logs kept
by the system are:
:
-
: These entries are kept whenever
a script file is run to record the success or failure of the
execution.
-
: Each command executed in
the SQL Command Processor is recorded for a user. These commands can
be retrieved by the user, if necessary, for easy editing.
-
: HTML DB records page views for all pages in
the system. These logs can be reviewed through reports for analysis
to find the most common pages used or for some other purpose. HTML
DB maintains two activity logs, one current and one non-current.
Every 14 days, a log switch occurs where the non-current log is
truncated and becomes the current log.
-
: Developer activity logs record the changes
made on a page during development. These logs can be used to see
what change has been made, who made the change, and when the change
occurred.
-
: This log records any clicks on URLs to
external sites.
-
:
Each successful email that is sent by HTML DB through the email API
is recorded in this log.
All logs can be truncated manually by the
Administrator. Entries over a month old will be cleaned out of the
SQL Workshoplogs, Developer
Activity Logs, and the External Click Counting Log automatically. The
time period can also be adjusted by the administrator from one to 31
days. The Mail Log is not automatically cleaned out. This must be
done manually.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
