23. While creating a job class using the DBMS_SCHEDULER package, you

set the logging level to LOGGING_RUNS. What would be the impact of th

is setting?

A. Oracle Scheduler would write detailed information to the job log f

or each run of each job in the job class.

B. Oracle Scheduler would write detailed information to the job log f

or the first run of each job in the job class.

C. Oracle Scheduler would write detailed information to the job log f

or each run of only the first job in the job class.

D. Oracle Scheduler would write detailed information for all operatio

ns performed on all jobs in the job class.

Answer: A
d是指loggin-all;

任务类（job class）任务类的特有参数：

（1）job_class_name ：必须在sys 模式内唯一

（2）resource_consumer_group ：此任务类属于哪一个资源消费群。

（3）service ：在RAC 下，只在指定服务名的实例上运行。

（4）logging_level ：可以设定写在任务日志中的内容。有三个值：

dbms_scheduler.logging_off ：无日志。

dbms_scheduler.logging_runs ：只记录任务运行产生的日志。

dbms_scheduler.logging_full ：记录任务的所有情况。

（5）log_history ：指定了日志内容的保留天数。默认是30 天。超出时间的内容会被自动

清除

ITPub博客

043-023