To set the history retention period for either window logging or job logging individually, which
parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that
apply.)
A.
LOG_HISTORY
B.
JOB_LOG_RETENTION
C.
WINDOW_LOG_RETENTION
D.
WHICH_LOG
E.
LOG_NAME
D is incorrect, only A is ok.
http://docs.oracle.com/cd/E11882_01/appdev.112/e16760/d_sched.htm#ARPLS72434
> ‘log_history’: The number of days that log entries for both the job log and the window log are retained. Default is 30 and the range of valid values is 0 through 1000000.
About “which_log”:
This specifies the log type. Valid values are: job_log, window_log, and job_and_window_log.
So this parameter is needed to indicate which logging we want to set or job or window or for both at the same time.
More about “which_log” – it is a parameter for PURGE_LOG procedure.