Download Oracle Database Application Express User's Guide

Managing Service
Managing Log Entries
Oracle Application Express administrators can delete log entries on the Logs page.
Topics in this section include:
■
Deleting SQL Workshop Logs
■
Deleting Page View Activity Log Entries
■
Deleting Developer Activity Log Entries
■
Deleting Click Counting Log Entries
■
Deleting Mail Log Entries
■
Deleting the Login Access Log
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" on page 22-2.
2.
Click Manage Service.
3.
Under Manage Service, click Logs.
The Logs page appears.
4.
Click SQL Workshop logs.
5.
Click one of the following:
6.
■
Script File executions log entries
■
SQL Command Processor history entries
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.
See Also: "Accessing a Command from Command History" on
page 19-8
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 Definition
page.
See Also:
"About the Edit Definition Page" on page 4-9
The Application Express 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
Application Express 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 Application
Express engine removes all entries in the noncurrent log and designates it as current.
To truncate the activity logs manually:
Managing an Oracle Application Express Hosted Service
22-5