28.27 SET_LOG_SWITCH_INTERVAL Procedure

Set the log switch interval for each of the logs maintained by Oracle APEX.

Syntax

APEX_INSTANCE_ADMIN.SET_LOG_SWITCH_INTERVAL(
    p_log_name              IN VARCHAR2,
    p_log_switch_after_days IN NUMBER );

Parameters

Table 28-19 SET_LOG_SWITCH_INTERVAL Parameters

Parameters	Description
p_log_name	Specifies the name of the log. Valid values include ACCESS, ACTIVITY, AUTOMATION, CLICKTHRU, DEBUG, WEBSERVICE, and WEBSOURCESYNC.
p_log_switch_after_days	This interval must be a positive integer between 1 and 180.

Example

This example sets the log switch interval for the ACTIVITY log to 30 days.

BEGIN
    apex_instance_admin.set_log_switch_interval( p_log_name => 'ACTIVITY', p_log_switch_after_days => 30 );
    COMMIT;
END;