24.28 TRUNCATE_LOG Procedure

The TRUNCATE_LOG procedure truncates the log entries specified by the input parameter.

Syntax

APEX_INSTANCE_ADMIN.TRUNCATE_LOG (
    p_log     IN VARCHAR2 )

Parameters

Table 24-24 TRUNCATE_LOG Parameters

Parameter

Description

p_log

This parameter can have one of the following values: ACTIVITY - removes all entries that record page access. CLICKS - removes all entries that record clicks tracked to external sites. DEBUG - removes all entries captured during debug sessions. FILE - removes all entries that record automatic file purge activity. LOCK_INSTALL_SCRIPT - removes all entries that record developer locking of supporting objects script. LOCK_PAGE - removes all entries that record developer locking of pages. MAIL - removes all entries that record mail sent. PURGE - removes all entries that record automatic workspace purge activity. SCRIPT - removes all entries that record results of SQL scripts executed in SQL Workshop. SQL - removes all entries that record the history of commands executed in SQL Workshop SQL Commands USER_ACCESS - removes all entries that record user login. WORKSPACE_HIST - removes all entries that record daily workspace summary.

Example

The following example demonstrates how to use the TRUNCATE_LOG procedure to remove all log entries that record access to APEX application pages.

BEGIN
  APEX_INSTANCE_ADMIN.TRUNCATE_LOG('ACTIVITY');
END;