Oracle® HTML DB
Release 2.0
  Go To Table Of Contents
Contents

Previous
Previous
Next
Next
 

Managing Logs

Oracle HTML DB administrators can manage the following log files on the Manage Logs and Files page:

Topics:

Deleting SQL Workshop Logs

The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Command Processor.

To delete log files entries:

  1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

  2. Click Manage Service.

  3. Select Manage Logs.

    The Manage Logs page appears.

  4. Select SQL Workshop logs.

  5. Select one of the following:

    • Script File executions log entries

    • SQL Command Processor history entries

  6. To delete entries by age:

    • Specify the age of the entries to deleted.

    • Click Delete Entries.

  7. To delete all entries, click Truncate Log.

Deleting Page View Activity Log Entries

Page view activity logs track user activity for an application. Developers enable logging within their application on the Edit Application Attributes page.

The HTML DB 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 HTML DB 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 HTML DB engine removes all entries in the noncurrent log and designates it as current.

To truncate the activity logs manually:

  1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

  2. Click Manage Service.

  3. Select Manage Logs.

    The Manage Logs page appears.

  4. Select Page View Activity Log, with option to truncate.

  5. Click Truncate Logs.

  6. Click either Truncate Log 1 or Truncate Log 2.


See Also:


Deleting Developer Activity Log Entries

The Developer Activity Log tracks changes to applications within an individual workspace. Log entries older than one month are automatically deleted.

To delete Developer Activity Log entries:

  1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

  2. Click Manage Service.

  3. Select Manage Logs.

    The Manage Logs page appears.

  4. Select Developer Activity Logs, with option to delete entries.

  5. On the Developer Activity Logs page, click Manage.

  6. Specify the age of the entries to be deleted and click Delete Entries.


See Also:

"Viewing Application Changes by Developer" for information about the Developer Activity Log

Deleting Click Counting Log Entries

The External Clicks Log counts clicks from an Oracle HTML DB application to an external site. You can implement this functionality using COUNT_CLICK procedure.

To delete click counting log entries:

  1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

  2. Click Manage Service.

  3. Select Manage Logs.

    The Manage Logs page appears.

  4. Select External Click Counting Log, with option to truncate.

  5. On the Click Counting Log page, click Manage.

  6. Specify the age of the entries to be deleted and click Delete Entries.

Deleting the HTML DB Mail Log Entries

The HTML DB Mail Log records message header information and send date of successfully sent mail message.

To truncate the mail log:

  1. Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".

  2. Click Manage Service.

  3. Select Manage Logs.

    The Manage Logs page appears.

  4. Select Mail Log.

  5. On the Manage Mail Log page, click Truncate Log.