Managing Logs

Deleting SQL Workshop Logs

The SQL Workshop logs maintain a history of recent commands and scripts run in the SQL Commands

To delete log files entries:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click SQL Workshop logs.

4. Click one of the following:

   • Script File executions log entries

   • SQL Command Processor history entries

5. On the Clean up Logs page:

   • To delete entries by age, specify the age of the entries to be deleted and click Delete Entries.

   • 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 using the Logging attribute on the Edit Application Definition page.

The Application Express engine uses two logs to track user activity. At any given time, one log is designated as current. For each rendered page view, the Application Express engine inserts one row into the log file. A log switch occurs at the interval listed on the Page View Activity Logs page. At that point, the Application Express engine removes all entries in the noncurrent log and designates it as current.

To truncate the activity logs manually:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click Page View Activity Logs, with option to truncate.

   The Page View Activity Logs page appears.

4. Click Truncate Logs.

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

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 Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click Developer Activity Logs, with option to delete entries.

   The Developer Activity Log page appears.

4. On the Developer Activity Log page, click Manage.

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

Deleting Click Counting Log Entries

The External Clicks Log counts clicks from an Oracle Application Express application to an external site. You can implement this functionality using the APEX_UTIL.COUNT_CLICK procedure.

To delete click counting log entries:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click External Click Counting Log, with option to truncate.

   The External Click Counting Log page appears.

4. On the External Click Counting Log page, click Manage.

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

Deleting Mail Log Entries

The Oracle Application Express Mail Log records the message header information and send date of successfully sent mail message.

To truncate the mail log:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click Mail Log.

   The Mail Log page appears.

   This page displays as an interactive report. To customize the report, use the Search bar at the top of the page. See "Customizing Interactive Reports" in Oracle Application Express Application Builder User's Guide.

4. On the Mail Log page, click Truncate.

Deleting the Login Access Log

This table records authentication events by developers and administrators accessing the Oracle Application Express environment and by end users of Oracle Application Express applications that use the built-in login APIs available to developers. Log entries are aged out of the log tables and purged periodically.

To truncate the Login Access log:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Instance.

3. Under Manage Logs and Files, click Login Access Log.

   The Login Access Log page appears.

4. Click Manage.

5. On the Manage Login Access Log page, click Delete Entries.