1. API Reference
  2. APEX_INSTANCE_ADMIN
  3. TRUNCATE_LOG Procedure

32.35 TRUNCATE_LOG Procedure

Truncates the log entries specified by the input parameter.

Syntax

APEX_INSTANCE_ADMIN.TRUNCATE_LOG (
    p_log     IN VARCHAR2 )

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.
  • WEB_SERVICES - removes all entries that record web service calls initiated from this APEX instance.
  • 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;

Parent topic: APEX_INSTANCE_ADMIN