Truncating Page Views

Page Views track user activity for an application. Application developers enable logging within their application on the Edit Application Attributes page.

Note:

"Configuring Standard Application Attributes"

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 under Log Interval. 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:

On the Database Home Page, click the Application Builder icon.
From the Administration list, select Manage Services.
Select Manage Logs.

The Manage Logs page appears.
Select Page Views.
If prompted, enter the appropriate administrator username and password and click Login.

The entries in the current logs display.
Click either Truncate Log 1 or Truncate Log 2.