1. Administration Guide
  2. Oracle Application Express Administration Services
  3. Managing Logs and Files

3.9 Managing Logs and Files

Delete log entries and configure log intervals.

Parent topic: Oracle Application Express Administration Services

3.9.1 Deleting SQL Workshop Logs

Delete SQL Workshop log entries. The SQL Workshop maintains a history of SQL statements run in the SQL Commands.

To delete SQL Workshop log entries:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click SQL Workshop Log.
  4. On the SQL Workshop Logs page, click one of the following:

    • Script File executions log entries

    • SQL Command Processor history entries

  5. On the Clean up Logs page, click one of the following:
    1. For Delete entries this number of days and older - Select the number of days.
    2. Click one of the following:

      • Truncate Log - Deletes all entries.

      • Delete Entries - Deletes entries by age, specify the age of the entries to be deleted.

See Also:

"Accessing a Command from Command History" in Oracle Application Express SQL Workshop Guide

Parent topic: Managing Logs and Files

3.9.2 Deleting Page View Activity Log Entries

Delete Page View Activity Log entries. Page View Activity Logs track user activity for an application.

Parent topic: Managing Logs and Files

3.9.2.1 About Page View Activity Logs

Page View Activity Logs track user activity for an application.

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.

Tip:

Developers enable logging within their application using the Logging attribute on the Edit Application Definition page.

See Also:

"Editing the Application Definition" in Oracle Application Express App Builder User’s Guide

Parent topic: Deleting Page View Activity Log Entries

3.9.2.2 Truncating Page View Activity Logs Manually

Delete Page View Activity logs manually.

To truncate the activity logs manually:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Page View Activity Log.

    The Page View Activity Logs page appears.

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

See Also:

"Viewing Workspace Dashboards"

Parent topic: Deleting Page View Activity Log Entries

3.9.3 Deleting Developer Activity Log Entries

Delete Developer Activity Log entries.

The Developer Activity log tracks changes to applications within an individual workspace.

To delete Developer Activity Log entries manually:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Developer Activity Log.

    The Developer Activity Log page appears.

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

See Also:

"Developer Activity Dashboard" for information about the Developer Activity Log

Parent topic: Managing Logs and Files

3.9.4 Managing Developer Log Retention

Manage Developer Log retention.

The Developer Activity log tracks changes to applications within an individual workspace. You can specify the number of days to retain log entries.

To specify the number of days to retain log entries:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Developer Activity Log.

    The Developer Activity Log page appears.

  4. Specify the number of days to retain developer log entries and click Save Retention Setting.

See Also:

"Developer Activity Dashboard" for information about the Developer Activity Log

Parent topic: Managing Logs and Files

3.9.5 Deleting Click Counting Log Entries

Delete External Clicks Counting Log entries.

The External Clicks Counting 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 External Clicks Counting log entries:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click External Click Counting Log.

    The External Click Counting Log page appears.

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

See Also:

"COUNT_CLICK Procedure" in Oracle Application Express API Reference

Parent topic: Managing Logs and Files

3.9.6 Deleting the Login Access Log

Delete Login Access Log entries.

The Login Access log 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. Sign 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. Specify the age of the entries to be deleted and click Delete Entries.

Parent topic: Managing Logs and Files

3.9.7 Managing Log Intervals

Use the Manage Log Interval page to set the minimum number of days to retain log information for log files.

To manage the log interval:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Manage Log Interval.

    The Manage Log Interval page appears.

  4. For each log type, enter the duration of the interval in days.

    The maximum value that can be specified is 180 days, with a default value of 14 days. Keeping log information for longer periods can degrade runtime performance.

  5. Click Apply Changes.

See Also:

SET_LOG_SWITCH_INTERVAL Procedure in Oracle Application Express API Reference

Parent topic: Managing Logs and Files

3.9.8 Archiving the Activity Log

Archiving the Activity log takes the Oracle Application Express Activity log, summarizes it, and writes the results to an archived activity log

Archiving the Activity log takes the Oracle Application Express Activity log, summarizes it, and writes the results to an archived activity log.

To archive the Oracle Application Express Activity log:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Archive Activity Log.

    The Archive Activity Log page appears listing the last archive date, archive day count, and workspace count.

  4. Click Archive Activity Summary.

Parent topic: Managing Logs and Files

3.9.9 Deleting Web Service Log Entries

Delete Web Service Log entries.

The Web Service Activity Log records all web service requests initiated from the Application Express instance.

To delete Web Service Activity log entries:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Web Service Activity Log.

    The Web Service Activity Log page appears.

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

Parent topic: Managing Logs and Files

3.9.10 Configuring or Deleting the REST Source Synchronization Log

Configure when entries are purged or delete the REST Source Synchronization log.

To configure or delete the REST Source Synchronization log:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click REST Source Synchronization Log.
    The REST Source Synchronization Log page appears displaying the current number of log entries.
  4. Delete entries this number of days and older - Enter the number of days after which the log is purged.
  5. To delete the log, click Delete Entries.

See Also:

"Managing Data Synchronization" and "Managing the REST Data Source Synchronization Log" in Oracle Application Express App Builder User’s Guide

Parent topic: Managing Logs and Files

3.9.11 Configuring or Deleting the Automation Log

Configure when entries are purged or delete the Automation log.

To configure or delete the Automation log:

  1. Sign in to Oracle Application Express Administration Services.
  2. Click Manage Instance.
  3. Under Manage Logs and Files, click Automation Log.
    The Automation Log page appears displaying the current number of log entries.
  4. Delete entries this number of days and older - Enter the number of days after which the log is purged.
  5. To delete the log, click Delete Entries.

Note:

"Managing Automations" in Oracle Application Express App Builder User’s Guide

Parent topic: Managing Logs and Files