SET_LOG_SWITCH_INTERVAL Procedure

Set the log switch interval for each of the logs maintained by Application Express.

Syntax

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

Parameters

Table 16-20 SET_LOG_SWITCH_INTERVAL Parameters

Parameters	Description
`p_log_name`	Specifies the name of the log. Valid values include `ACCESS`, `ACTIVITY`, `CLICKTHRU`, and `DEBUG.`
`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;

Parent topic: APEX_INSTANCE_ADMIN