32.31 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
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;
Parent topic: APEX_INSTANCE_ADMIN