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 |
---|---|
|
Specifies the name of the log. Valid values include |
|
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