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.- 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 SQL Workshop Log Entries
Delete SQL Workshop log entries. - Deleting Page View Activity Log Entries
Delete Page View Activity log entries. Page View Activity Logs track user activity for an application. - Managing the Developer Activity Log
Manage the Developer Activity Log by deleting log entries and configuring the number of days to retain log entries. - Deleting Click Counting Log Entries
Delete External Clicks Counting Log entries. - Deleting the Login Access Log
Delete Login Access Log entries. - Deleting Web Service Activity Log Entries
Delete Web Service Activity log entries. - Deleting REST Synchronization Log Entries
Delete REST Synchronization log entries. - Deleting Automation Log Entries
Delete the Automation log entries.
Parent topic: Oracle APEX Administration Services
3.15.1 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:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.2 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.3 Deleting SQL Workshop Log Entries
Delete SQL Workshop log entries.
The SQL Workshop log maintains a history of SQL statements. This history is available in SQL Commands by clicking the History tab. This table can be truncated to reduce space utilization.
To delete SQL Workshop log entries:
See Also:
Using SQL Command History in Oracle APEX SQL Workshop Guide
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.4 Deleting Page View Activity Log Entries
Delete Page View Activity log entries. 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 Editing the Application Definition in Oracle APEX App Builder User’s Guide.To delete Page View Activity log entries:
See Also:
Viewing Workspace DashboardsParent topic: Configuring and Deleting Logs and Log Entries
3.15.5 Managing the Developer Activity Log
Manage the Developer Activity Log by deleting log entries and configuring the number of days to retain log entries.
To delete log entries manually or configure log entry retention:
See Also:
Developer Activity Dashboard for information about the Developer Activity Log
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.6 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.7 Deleting the Login Access Log
Delete Login Access Log entries.
To delete Login Access Log entries:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.8 Deleting Web Service Activity Log Entries
Delete Web Service Activity log entries.
To delete Web Service Activity log entries:
Parent topic: Configuring and Deleting Logs and Log Entries
3.15.9 Deleting REST Synchronization Log Entries
Delete REST Synchronization log entries.
The REST Synchronization log contains details about previously executed synchronizations such as the status (that is, Success or Failure), the amount of processed rows, and the amount of HTTP requests being made. You can drill down from the Synchronization log to the Web Services log to review each individual HTTP request which was made for this synchronization.
To delete REST Synchronization log entries:
See Also:
Managing Data Synchronization and Managing the REST Data Source Synchronization Log in Oracle APEX App Builder User’s GuideParent topic: Configuring and Deleting Logs and Log Entries
3.15.10 Deleting Automation Log Entries
Delete the Automation log entries.
To delete the Automation log entries:
Note:
Managing Automations in Oracle APEX App Builder User’s Guide
Parent topic: Configuring and Deleting Logs and Log Entries