Oracle HTML DB administrators can manage the following log files on the Manage Logs and Files page:
SQL Workshop logs
Page View Activity logs
Developer activity logs
External click counting log
Topics:
The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Command Processor.
To delete log files entries:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Logs.
The Manage Logs page appears.
Select SQL Workshop logs.
Select one of the following:
Script File executions log entries
SQL Command Processor history entries
To delete entries by age:
Specify the age of the entries to deleted.
Click Delete Entries.
To delete all entries, click Truncate Log.
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:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Logs.
The Manage Logs page appears.
Select Page View Activity Log, with option to truncate.
Click Truncate Logs.
Click either Truncate Log 1 or Truncate Log 2.
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:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Logs.
The Manage Logs page appears.
Select Developer Activity Logs, with option to delete entries.
On the Developer Activity Logs page, click Manage.
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 |
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:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Logs.
The Manage Logs page appears.
Select External Click Counting Log, with option to truncate.
On the Click Counting Log page, click Manage.
Specify the age of the entries to be deleted and click Delete Entries.
The HTML DB Mail Log records message header information and send date of successfully sent mail message.
To truncate the mail log:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Logs.
The Manage Logs page appears.
Select Mail Log.
On the Manage Mail Log page, click Truncate Log.