3.15 Configuring and Deleting Logs and Log Entries
Configure log intervals and delete logs and log entries.
Note:
To ensure the security and performance of your development environment, some administration functionality is not available in Oracle APEX instances running in Oracle Cloud.- Deleting SQL Workshop Logs
Delete SQL Workshop log entries. The SQL Workshop maintains a history of SQL statements run in the SQL Commands. - Deleting Page View Activity Log Entries
Delete Page View Activity Log entries. Page View Activity Logs track user activity for an application. - Deleting Developer Activity Log Entries
Delete Developer Activity Log entries. - Managing Developer Log Retention
Manage Developer Log retention. - Deleting Click Counting Log Entries
Delete External Clicks Counting Log entries. - Deleting the Login Access Log
Delete Login Access Log entries. - Managing Log Intervals
Use the Manage Log Interval page to set the minimum number of days to retain log information for log files. - Archiving the Activity Log
Archiving the Activity log takes the Oracle APEX Activity log, summarizes it, and writes the results to an archived activity log - Deleting Web Service Log Entries
Delete Web Service Log entries. - Configuring or Deleting the REST Source Synchronization Log
Configure when entries are purged or delete the REST Source Synchronization log. - Configuring or Deleting the Automation Log
Configure when entries are purged or delete the Automation log.
Parent topic: Oracle APEX Administration Services
3.15.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:
See Also:
Accessing a Command from Command History in Oracle APEX SQL Workshop Guide
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.2 Deleting Page View Activity Log Entries
Delete Page View Activity Log entries. Page View Activity Logs track user activity for an application.
- About Page View Activity Logs
Page View Activity Logs track user activity for an application. - Truncating Page View Activity Logs Manually
Delete Page View Activity logs manually.
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.2.1 About Page View Activity Logs
Page View Activity Logs track user activity for an application.
The APEX engine uses two logs to track user activity. At any given time, one log is designated as current. For each rendered page view, the APEX 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 APEX 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 APEX App Builder User’s Guide
Parent topic: Deleting Page View Activity Log Entries
3.15.2.2 Truncating Page View Activity Logs Manually
Delete Page View Activity logs manually.
To truncate the activity logs manually:
See Also:
Parent topic: Deleting Page View Activity Log Entries
3.15.3 Deleting Developer Activity Log Entries
Delete Developer Activity Log entries.
To delete Developer Activity Log entries manually:
See Also:
Developer Activity Dashboard for information about the Developer Activity Log
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.4 Managing Developer Log Retention
Manage Developer Log retention.
To specify the number of days to retain log entries:
See Also:
Developer Activity Dashboard for information about the Developer Activity Log
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.5 Deleting Click Counting Log Entries
Delete External Clicks Counting Log entries.
APEX_UTIL.COUNT_CLICK
procedure.
To delete External Clicks Counting log entries:
See Also:
COUNT_CLICK Procedure in Oracle APEX API Reference
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.6 Deleting the Login Access Log
Delete Login Access Log entries.
To truncate the Login Access log:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.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:
See Also:
SET_LOG_SWITCH_INTERVAL Procedure in Oracle APEX API Reference
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.8 Archiving the Activity Log
Archiving the Activity log takes the Oracle APEX Activity log, summarizes it, and writes the results to an archived activity log
To archive the Oracle APEX log:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.9 Deleting Web Service Log Entries
Delete Web Service Log entries.
To delete Web Service Activity log entries:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.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:
See Also:
Managing Data Synchronization and Managing the REST Data Source Synchronization Log in Oracle APEX App Builder User’s Guide
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.11 Configuring or Deleting the Automation Log
Configure when entries are purged or delete the Automation log.
To configure or delete the Automation log:
Note:
Managing Automations in Oracle APEX App Builder User’s Guide
Parent topic: Configuring and Deleting Logs and Log Entries